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

[MickDoneDee]

Join me (Mike) in this chat room and I'll take you through it. Make sure you have the chat room window open and the phpMyAdmin window open.

http://client1.sigmachat.com/sc.pl?id=62374

[VBUsers]

Originally Posted by MickDoneDee

Join me (Mike) in this chat room and I'll take you through it. Make sure you have the chat room window open and the phpMyAdmin window open.

http://client1.sigmachat.com/sc.pl?id=62374

thanks mick you fixed my problem! i appreciate the time and patience. the table and query worked perfectly. your the man!

[MickDoneDee]

You're welcome. :classic:

[MickDoneDee]

Originally Posted by lowandloudinc

thanks mick you fixed my problem! i appreciate the time and patience. the table and query worked perfectly. your the man!

You may have problems with the rest of the hack because your table names differ from what is assigned in the code.

[VBUsers]

Originally Posted by MickDoneDee

You may have problems with the rest of the hack because your table names differ from what is assigned in the code.

well everything installed smoothly but now how do i know if i have an error and also how will i know it works?

[Delphiprogrammi]

Originally Posted by lowandloudinc

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

why do you add that smoralo thingy twice ? and using table prfixes like that isn't verry "user friendly" it verry confusing anyway your problem is solved i see

[MickDoneDee]

Originally Posted by lowandloudinc

well everything installed smoothly but now how do i know if i have an error and also how will i know it works?

You need someone to make a post using a proxyip address. I tested my own by going to a website which issues free proxy ip addresses and then in my browser internet options I selected proxy server and input the proxy ip address. If you can't do that then I'll test it for you if you give me temporary access to post on your forum.

I also wonder whether this query will work?

//	 	Paul M Proxy Hack v1.2 
		// ### POST NEW POST ###
		$DB_site->query("
			INSERT INTO " . TABLE_PREFIX . "post
				(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
				 showsignature, ipaddress, proxyip, iconid, visible, attach)
			VALUES
				($threadinfo[threadid], $parentid, '" . addslashes($post['title']) . "',
				 '" . addslashes($post['postusername']) . "', $bbuserinfo[userid], " . TIMENOW . ",
				 '" . addslashes($post['message']) . "', $post[enablesmilies], $post[signature],
				 '" . addslashes($post['ipaddress']) . "','" . addslashes($post['proxyip']) . "', $post[iconid], $post[visible], $totalattachments)
		");
//	 	End Proxy Hack

The query is calling the table called post. That is not the name of your post table. Have you changed that?

Perhaps this part of the query (TABLE_PREFIX) makes the query work with tables that use prefixes like yours. If it didn't have that I doubt it would work properly. Fantastic that Jelsoft thought about that when coding the software.

Update: I've done some further research and found that vB2 did not support table prefixes but vB3+ does. This quote from vB.com:

Originally Posted by Zachery

When you install vBulletin, you can define a table prefix, by default there is not one. However in config.php there is a setting that tell you if you have one or not: $tableprefix

http://www.vbulletin.com/forum/showthread.php?t=130708

Paul, I wonder whether you should ammend your query to include TABLE_PREFIX to stop people with table prefixes from getting query errors and enable them to execute the query properly?

[Paul M]

Originally Posted by MickDoneDee

Paul, I wonder whether you should ammend your query to include TABLE_PREFIX to stop people with table prefixes from getting query errors and enable them to execute the query properly?

Table prefixes are only a feature of vB itself - MySQL would not understand the query if I added it. Most people know if they are using prefixes, but I might add a note or something later.

[VBUsers]

well update on my install it works fine mickdondee tested for me with a test account and it works fine i just named my table smora_post in the query like dundee told me to do and it went smooth after that, thanks to the maker of the hack and to all that have posted.

[bonnmac]

i need some help can you explain the phrases what to do with this its not clear in the directions i mean i know how to add phrase but the way you have them they won't install thanks for a great addition