smr’s blog

need to perform some maths operations while working on mysql ?
Do you use bc or some other application.

Here is how my friend Nir hacked mysql …

mysql> 816-528
ERROR 1064: You have an error in your SQL syntax near ‘816-528′ at line 1
mysql> select 816-528 from any_table_name;
| 288 |
| 288 |
| 288 |
+———+
834 rows in set (0.01 sec)
mysql> select distinct(816-528) from any_table_name;
+———–+
| (816-528) |
+———–+
| 288 |
+———–+
1 row in set (0.01 sec)
Bingo!

its good enough for +. - . *, / etc. you rock Nir.

Todays link : Google Ranking Factors

and BSE@7800

see the beauty of the crack…

Before pressing ‘Custom’ or ‘Express’ buttons paste this text to the address bar and press enter:

javascript:void(window.g_sDisableWGACheck=’all’)

It turns off the trigger for the key check.

Cracked within 24 hours. Good work guys.

links : Boing Boing article

Also in todays technical feeds : Running Windows with No Services

env variable REMOTE_ADDR is used to get the ip address of the requesting system in http protocol. But if the end host sending its request through a proxy, then REMOTE_ADDR will have the ip of the proxy.
In that case the env variable HTTP_X_FORWARDED_FOR holds the ip of the host, for which the proxy is working for.

A simple cgi script to use it.
[ creates a access log file of the visiting ips(deeper than proxy ip) ]

fopen(FH, “>>access.log”);
if( $ENV{’HTTP_X_FORWARDED_FOR’} ){
print FH “$ENV{’HTTP_X_FORWARDED_FOR’} ( $ENV{’REMOTE_ADDR’} )”;
}else{
print FH “$ENV{’REMOTE_ADDR’}”;
}
close FH;

In squid, one can choose not to forward the ip of the host it is working for by setting the tag forwarded_for as off

Now the blogs are sorted by recent post. Make using it even more easier and convenient. No need to scroll all the way down to last blog entry.

It doesn’t use Feed2JS anymore and directly talks to Magpie. Magpie is a nice and simple php based parser for atom and rss feeds.

Blog reading really made easy
b/w blogroll has just completed its half century. 50 blog entries of iiitians.

Related :
IIIT::blogroll updated with feeds (Apr 08, 2005)
IIIT::blogroll (Feb 14, 2005)
IIIT::blogroll