Proxy Hack v1.0

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.

So, download the 2.2.8 update here

----------------

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.

Get it here

Attachment: Non Intrusive Version Screenshot

Normal, version:

[heretic]

Great job Takara! you went faster than I was able to get on to help. This helps my forum a whole lot

[Keyser S?ze]

err, maybe im reading this wrong, but check this out, for the non-intrusive version, to install it, on the postbit template one for UP, u do this:
## Go to Templates -> Postbit Templates -> threads_displayip
### Replace ALL with:

The Proxy IP Address is: $postinfo[ipaddress]. The Proxy host name is: $postinfo[hostaddress].<br>Real IP: $postinfo[proxyip]<P>Please click <a href="showthread.php?s=$session[sessionhash]&threadid=$threadid">here</a> to return to the thread.

now, does that mean, for ppl that DONT have a IP it will say this: The proxy IP address is: <real address> proxy host name is: <real host>. Real IP is <real IP>. Please.....

so it will basically say everyone is using a prxy, couldnt u make it so when u click that link, it say what it normally says unless they are using a proxy, like if they are using a proxy, the message changes, make sense?

[Jawelin]

Originally posted by Takara
Ah, I actually wasnt aware of that, but its easyily correctable by replacing: [...]

Yes, thanks. Actually I merged the proxyfied-ip displaying within the existent threads_displayip template.
And when retrieving the ip, I made this check:

PHP Code:

      if (getenv("HTTP_FORWARDED")!="") {
        $ipforwarded=getenv("HTTP_FORWARDED");
      } elseif (getenv("HTTP_X_FORWARDED_FOR")!="") {
        $ipforwarded=getenv("HTTP_X_FORWARDED_FOR");
      } elseif (getenv("HTTP_CLIENT_IP")!="") {
        $ipforwarded=getenv("HTTP_CLIENT_IP");
      } else {
        $ipforwarded="";
      } 


There should be many many more env vars (I don't know their real use, but found at least 20 vars with a proxy meaning...) to detect/discover a proxy, but the three above are the most commonly filled.

Thanks again.

[TECK]

this is a great hack.
i wonder if the original file in the first post is updated with all the mods listed in this thread... let me know please.
this will be a great addition to my board.. as i fight pirates.

[Takara]

Okie, sorry everyone. I took a look at the second one again, and corrected it. Alot of it didnt make any sence at all >.<
Just run through the script and re-replace things.

Also I updated both with the stuff from Jawelin, thankyou.

If you previously installed the less intrusive verson, you NEED to run this sql query to make it run:

ALTER TABLE post MODIFY proxyip varchar(255);

Sorry everyone T_T

All txt files updated

[Ian]

Originally posted by Takara
Sorry everyone T_T

All txt files updated

I just downloaded the newest .txt file and it is still using the 16 variable... Might want to change that if that's what your referring to.

[Takara]

eurrgh, I'm so stupid >.< lol

[Takara]

Here is how the non-intrusive looks in the getip

[heretic]

meh, for soem reason it's not detecting the proxies now that I'm using the non-intrusive version

[DWZ]

Thanks for the update. The instrutions for newthread.php went fine, however, I had trouble with newreply.php. Where I am supposed to find:

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($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','1')"); 


and replace 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($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$proxyip','$iconid','1')"); 


I cant find that. However, what I can find is this:

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')"); 


I take it thats what you are talking about, what do you think I should do?

Sorry about word wrap

[Takara]

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 it doesnt work with ALL proxys >.<

[Takara]

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')"); 


^_^ :bunny:

[DWZ]

thanks for the reply... but I have a problem...

New thread works fine, but new reply i get a database error...

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

mysql error number: 1136

Date: Thursday 09th of May 2002 11:44:41 AM
Script: http://www.consoleradar.com/forums/forums/newreply.php
Referer: http://www.consoleradar.com/forums/n...ly&threadid=95

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...

[squawell]

one problem....

if the user did not use proxy and how to make it show up ""no

proxy detect"" like this message in postbit.......can do that??

or its already done in ur hack...

[Takara]

Well, first thing replace both of these in newreply.php and newthread.php

PHP Code:

//Proxy Check
    if ($post[proxyip]!='') {
        eval("\$post[proxysip] = \"".gettemplate("proxy_proxyip")."\";");
    } else {
        $post[proxysip]='';
    }
//Proxy Check 


with the following:

PHP Code:

//Proxy Check
    if ($post[proxyip]!='') {
        eval("\$post[proxysip] = \"".gettemplate("proxy_proxyip")."\";");
    } else {
        eval("\$post[proxysip] = \"".gettemplate("proxy_noproxyip")."\";");
    }
//Proxy Check 


Then make a new template called proxy_noproxyip and put in it whatever you want (ie: No Proxy Detected)

^-^