iOS 5 Notification Screen is cool
Tuesday, July 26th, 2011
Just noticed that the iOS5 notification screen shows what tunes you are listening to on the lock screen. Cool.
Archive for July, 2011
Finding Spambots in your WordPress Database
Thursday, July 28th, 2011
If you run a WordPress site you will know that spambots will try and post at an alarming rate to your site. Now there are plenty of spam filters but they don’t always catch users who register and do not post. I have hundreds of these spam users and wanted a quick way to find them.
Well here is an SQL query to find users that have registered but not posted anything – note this is for WordPress used with bbPress
View Code SQL
1 2 3 | SELECT * FROM wp_users WHERE (SELECT Count(*) FROM wp_posts WHERE wp_posts.post_author = wp_users.id) = 0 |
Now I just need to find a way to bulk delete these users :)
Remove Dropbox from Ubuntu 11.4
Thursday, July 21st, 2011
Open Terminal and type
sudo apt-get remove nautilus-dropbox
Show the Library folder in Lion
Thursday, July 21st, 2011
Just type chflags nohidden ~/Library in to Terminal… done
Macbook Pro has no sound – red optical out light
Tuesday, July 5th, 2011
If your Macbook Pro has no sound (at all) and you cannot set the volume then check if your headphone speaker has a red light. If it does then you may need to poke a toothpick around to reset it. I kid you not.
After a day at a clients listening to files via the headphones the sound had locked and in System Preferences > Sound > Output only had Digital Out. A quick wiggle inside with a toothpick and I heard a click and the red light went off and the sound came back on. Perfect.
depicus in africa
-
gallery
videos
