Proxy ip to real ip conversion

This modification is no longer available or supported.

A simple modification I did for our forum that was originally based on the Proxy Detector Hack (v3.0). Obviously, like all proxy server detection hacks, this will only work if the proxy server passes the appropiate http variables.

This hack makes the forum always use the members real ip when a proxy is detected, meaning that all existing ip functions continue to work, basically ignoring the proxy server (other than recording it's presence).

i.e.

* The real ip/host is displayed in who's online

* The real and proxy server ip's are accesible for each post, the button is red for members using a proxy.

* The real ip is searchable in the admin/mod cp, not the proxy ip.

* The real ip is bannable by admins (no moving to another proxy to avoid a ban).

etc etc.

The installation should take about 10-15 mins (4 file edits, 2 phrase changes, 1 new template, 1 sql query, 1 new image).

[RFViet]

Does it work on vB 3.5.2 ????

[Paul M]

Originally Posted by RFViet

Does it work on vB 3.5.2 ????

https://vborg.vbsupport.ru/showthrea...threadid=95198

[Mysticales]

Tell me, should I install this on my 3.0.9 vB or should I just wait till we upgrade to 3.5.4? Im asking since Im not sure which one is better for this mod.

Plus I am wondering.. is it worth it? If people can use free online proxies, then what is the main thing? Just wondering. =)

[Paul M]

Originally Posted by Mysticales

Tell me, should I install this on my 3.0.9 vB or should I just wait till we upgrade to 3.5.4? Im asking since Im not sure which one is better for this mod.

Plus I am wondering.. is it worth it? If people can use free online proxies, then what is the main thing? Just wondering. =)

It's your choice, it works equally well on either. I cannot tell you if it's worth it - it is to me - but it depends on proxy usage in your member base. It doesn't hurt anything to use it.

[rjmjr69]

Ok this is probably really stupid but. Where does this information appear? I'm obviously a noob to all this but I did get the hack installed and I do not see any type of change as to user's ips that button that was installed does not appear anywhere. I searched thru the admincp and do not see anything different in there either. What is my retarded brain missing?

Was very simple to install with those well written directions. I find some of the other hacks are really short on instructions or written for those who know what they are doing.

[MickDoneDee]

Every post has an IP address associated with it and stored in the post table in the database. The field is labelled ipaddress. Without this hack that IP address could be a proxy IP which could not be used to ban someone because it's not their real IP address.

If you have Admin rights to your forum you can see a blue PC icon in the postbit area of every post near the triangle icon used to report the post. Hovering the mouse over the icon will reveal the IP address. Without the hack installed this IP address could be a real address or a proxy IP address.

After the hack is installed, a post using a proxy IP address will show a reddish icon instead of the blue one. The IP address that appears when the mouse hovers over it is the real IP address - not the proxy IP address. The real IP address should be used when banning the IP address of an unwanted user like a spammer.

To check if anyone has posted with a proxy IP address you can run this query:

SELECT `post`.`proxyip` , `post`.`postid`
FROM post
ORDER BY `post`.`proxyip` DESC

If you have admin rights the query can be run from the admin cp.

Import & Maintenance -> Execute SQL Query

In the edit box of the manual query section paste the above query and click Continue. If some of your members have posted using a proxy IP you should get some results like:

proxyip .................postid
85.158.137.195 ....122709
85.158.137.195 ....127575
85.12.72.2 ..........118743
85.12.72.2 ..........118744
85.12.72.2 ..........118745
85.12.72.2 ..........119307
85.12.72.2 ..........121896
85.12.72.2 ..........121898
85.12.72.2 ..........122090

Use any postid to find that post and it should display a reddish PC icon in the postbit area. That confirms the hack is working properly. This hack has been very helpful to ban spammers and other unwanted posters from my forum.

[rjmjr69]

Thank you sir very much. Well explained.