Version: 1.00, by Takara
Developer Last Online: Oct 2009
Version: 2.2.x
Rating:
Released: 05-06-2002
Last Update: 06-08-2002
Installs: 101
No support by the author.
Ooook,
Well, this hack is a little thing to give you vB admins and moderators some more information about the users using proxys on your board (mainly, thier IP address).
The following version is upto date and works with vb 2.2.8 and whatever else. This version was updated by Stadler to work with 2.2.8. I cannot provide support personally for ANY versions here. And I do not know what support Stadler can give you.
Everything below has to do with super old versions that don't matter.. because they are super old! You don't want them, so don't even read it!
STOP READING! hehe, anyway. I repeat:
VERSION 2.2.8 ABOVE ^ VERSION 2.2.5 BELOW
enjoy
--------------
Screenshots are in the posts to follow.
Let me know how you like it, or ways I could improve it. ^_^ :bunny:
Edit: Non intrusive version
This little edit simply adds the proxy info to the getip template. So when mods/admins click the "IP Logged" button/graphic if there is any proxy info, it will tell them instead of in postbit.
Originally posted by heretic meh, for soem reason it's not detecting the proxies now that I'm using the non-intrusive version
It wont display the "Proxy Detected" in the postbit with the non intrusive version. It only displays that a proxy has been detected when you click "IP Logged" or whatever you set it to.
Aswell DWZ. If you have other hacks installed it may be slightly diffrent, so replace:
PHP Code:
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");
with
PHP Code:
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,proxyip,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");
New thread works fine, but new reply i get a database error...
Quote:
Database error in vBulletin 2.2.5:
Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,proxyip,iconid,visible) VALUES (NULL,'95','','DWZ','1','1020915881','0','test','1 ','0','63.34.212.243','0','1')
mysql error: Column count doesn't match value count at row 1
EDIT: I have just uploaded the backup of newreply that i made just before i installed this hack, all is well now... but yeah, would be nice If I could have that proxy checking on newreply as well as newthread...
Originally posted by DWZ thanks for the reply... but I have a problem...
New thread works fine, but new reply i get a database error... and yeah, i ran the query and everything...
EDIT: I have just uploaded the backup of newreply that i made just before i installed this hack, all is well now... but yeah, would be nice If I could have that proxy checking on newreply as well as newthread...
Could you post that sql line from your newreply.php (the one you have to edit) please? thankies ^_^
This is what im using now (that works, but wont record proxies, well, i dont think it does) is:
PHP Code:
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");
And yeah, the thing you posted for me on the last page for me (which was):
PHP Code:
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,proxyip,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");
You are missing a parameter there... Not having checked out the hack, I can't tell you the name of the var, but it should be the one containing the proxy-ip, and it should be placed between '$ipaddress' and '$iconid', something like '$ipaddress', '$proxyip', '$iconid'