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

[David Bott]

Great. I updated the code.

Am I right in what I mentioned above? "I am gussing that if the code finds any of these private IPs, it will just use the reported proxy IP like it did not find anything. (Thus we can choose to block the proxy if need be.)"

[Paul M]

Originally Posted by David Bott

Am I right in what I mentioned above? "I am gussing that if the code finds any of these private IPs, it will just use the reported proxy IP like it did not find anything. (Thus we can choose to block the proxy if need be.)"

Correct - it will simply treat it as no proxy found - so the "real" IP will be the proxy ip, and be bannable.

The hack code has been updated to include this [optional] change.

[David Bott]

Thanks for the help in this. It should help.

[VBUsers]

i got this when i tried to run the SQL query

PHP Code:

SQL-query: 

ALTER TABLE post ADD proxyip VARCHAR( 50 ) NOT NULL AFTER ipaddress 
MySQL said:  

#1146 - Table 'smoralo_forum.post' doesn't exist 


why??? can you help?

[MickDoneDee]

ALTER TABLE post ADD proxyip VARCHAR(50) not null AFTER ipaddress;

You forgot to add the semi-colon to the end of the query statement which closes the statement and tells MySQL to execute the statement.

[VBUsers]

Originally Posted by MickDoneDee

ALTER TABLE post ADD proxyip VARCHAR(50) not null AFTER ipaddress;

You forgot to add the semi-colon to the end of the query statement which closes the statement and tells MySQL to execute the statement.

i did add it : just like this

Step 1.

Run the following SQL code;

ALTER TABLE post ADD proxyip VARCHAR(50) not null AFTER ipaddress;

[Delphiprogrammi]

Originally Posted by lowandloudinc

i did add it : just like this

Step 1.

Run the following SQL code;

ALTER TABLE post ADD proxyip VARCHAR(50) not null AFTER ipaddress;

people,

you are both wrong see the error MySQL is telling you

#1146 - Table 'smoralo_forum.post' doesn't exist

the korrect query becomes

ALTER TABLE smoralo_forum_post ADD proxyip VARCHAR(50) NOT NULL AFTER ipaddress;

[MickDoneDee]

Do you have a table called post? Are you running the query within vBulletin or phpMyAdmin? You can manually add the proxyip field manually within the post table using phpMyAdmin.

[VBUsers]

Originally Posted by Delphiprogrammi

people,

you are both wrong see the error MySQL is telling you

#1146 - Table 'smoralo_forum.post' doesn't exist

the korrect query becomes

ALTER TABLE smoralo_forum_post ADD proxyip VARCHAR(50) NOT NULL AFTER ipaddress;

it didnt work either

SQL-query:

ALTER TABLE smoralo_forum_post ADD proxyip VARCHAR( 50 ) NOT NULL AFTER ipaddress
MySQL said:

#1146 - Table 'smoralo_forum.smoralo_forum_post' doesn't exist

[VBUsers]

Originally Posted by MickDoneDee

Do you have a table called post? Are you running the query within vBulletin or phpMyAdmin? You can manually add the proxip field manually within the post table using phpMyAdmin.

im using phpmyadmin and im using the run SQL query where it asks you to drop in the text to create a table. ive done this before but i dont see the smoralo_forum_post.



theres a smora_post and smora_forum. wich one do i need to do it in?

all my tables are smora_something.