kwatog & co.

Got this one from Donncha on his Who’s abusing your website?

grep -v "wp-content" access.log|grep -v wp-includes|cut -f 1 -d " "|sort|uniq -c|sort -nr|less


Hmnn.. pretty neat, noh? It will list down all IP addresses that accessed your website including the number of appearance (how many times the site was accessed by the IP).
Read more…

This one has been on my draft for more than a year already so I better fix it up and share. Besides, I find myself more and more googling my site to find my posts instead of searching via the WP admin. Without further ado, here it is..
Read more…

Here’s a quick post on how to drop a column/field in a table.

Dropping One Column
alter table
table_name
drop column col_name1;

Dropping Multiple Columns

alter table
table_name
drop (col_name1, col_name2);

Simple, eh?

In my previous job, I use SnagIt v8.x in creating screenshots and I would say that it’s a great tool. It’s very efficient, non-obstructive and relatively lightweight screen capture tool. I find it an indispensable tool especially when doing documentations or user manuals and also in creating screenshots for blogs. However, SnagIt is not free. So below are some of the screen capture I use in place of SnagIt.
Read more…

Converting rows to column is a breeze if you are using Microsoft Access or reporting tools like Oracle Reports Builder. However, there are times that you’ll also need it for something else. I mean like displaying rows to one column in a SQL*Plus report. So how leh? (imagine that saying with a Singaporean accent)
Read more…