Postgresql – Drop connections script
Select another database in pgadmin and execute this script to drop all connected users. Script — view active connections SELECT * FROM pg_stat_activity WHERE datname=’DBNAME’; — drop active connections SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE datname=’DBNAME’;– view active connections select *…
Fix: HTTP error when uploading images in WordPress
Assuming: You have enough memory allocated to PHP and (128MB is default for PHP5) You are uploading an image that is below the 2mb limit. You’ve messed with the permissions on the upload folder. You are using Ubuntu and can…
Unlocking the BRZ Sat Nav Unit – Eclipse AVN 827GA
This guide will trick your AVN 827GA into thinking that the handbrake is active all the time, thus enabling all functions of the head unit whilst on the move. Before we begin. Disclaimer: This mod is not exactly legal. I provide…
Classic Snake Game using C# Windows Forms
Everybody likes the classic snake game. Here is a simple C# implementation built for funsies.
Subtle waiting effect for buttons
A simple waiting effect that can be used for lengthy operations. Fiddle: http://jsfiddle.net/pootie/7z5Sj/
lightbox rotate image using jqueryrotate
If you’ve ever wanted to be able to rotate lightbox images, here’s an example that uses lightbox2 and jqueryrotate. Fiddle http://jsfiddle.net/pootie/EBLc7/