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

[Paul M]

Originally Posted by Harry Bo

Paul, do you know if this hack works with NTL's UK proxy servers? I administrate a fairly large vB and we can end up with 20+ users in the same city on one proxy

If it works with NTL, I'll be installing soon

Cheers,

HB

Harry Bo - Check the sig - we are primarily an ntl user site - it was written with their transparant caches in mind.

I see you are not far from me - what is your site ?

[Harry Bo]

I visited your site shortly after posting, I figured it would probably work then, lol

I'm here from www.talkaudio.co.uk, the UK's biggest Car Audio Forum

HB

[mtha]

This is a simple modification I did for our forum that is based on the existing 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.

well, just wondering if you should state the credit to Takara for his original work and a link to Proxy Detector Hack (v3.1)

thanks

[Paul M]

Originally Posted by mtha

well, just wondering if you should state the credit to Takara for his original work and a link to Proxy Detector Hack (v3.1)

thanks

Maybe you should read the installation notes ......

This is partly based on the Proxy Detector v3.0 hack by "HacNho/Takara/Stadler".

:glasses:

[rh2004]

Hi I get 'Could not find phrase 'thread_displayproxyip'.' and it is added, I also have
the IPINFO added..

Add the following phrase "thread_displayproxyip" ;

GLOBAL

Real IP Address : $postinfo[ipaddress]<br>
$postinfo[hostaddress]<br>
Proxy Server IP Address : $postinfo[proxyip]<br>
$postinfo[proxyhost]


This is my postbit..

<if condition="$show['ip']">
$vbphrase[ip]: $post[ip]
<else />
<if condition="($post[proxyip] != '')">
<a href="postings.php?$session[sessionurl]do=getip&amp;p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ipp.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
<a href="ipinfo.php?$session[sessionurl]p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
<else />
<a href="ipinfo.php?$session[sessionurl]p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
</else></if>
</if>

It should show me two IP buttons if using a proxy if a normal user no proxy
should give me just one button, now the buttons work its just when you
click on a proxy IP it gives you the above error...


EDIT I fixed it sorry I read through maybe you should place in the readme its Front-End Error



So my only question is can I show the proxy button if only admin, not mods or super mods

[Paul M]

Originally Posted by rh2004

EDIT I fixed it sorry I read through maybe you should place in the readme its Front-End Error

It's never been mentioned before, but I'll update the instructions when I have time.

Originally Posted by rh2004

So my only question is can I show the proxy button if only admin, not mods or super mods

Just enclose it in a test for usergroup == 6. I would check the logic in you postbit code though - I can't make sense of it, I don't see how it actually works .....

[rh2004]

Ok thanks for that... I have noticed an error which has arrised I think its
to do with this mod, I receive this a few times a day around 2-3

Database error in vBulletin 3.0.3:

Invalid SQL: 
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext, 
allowsmilie,
showsignature, ipaddress, proxyip, iconid, visible, attach)
VALUES
(10154, , '',
'BlackbirdDJ', 2696, 1102976866,
'cheers', 1, 0,
'81.--,'', 0, 1, 0)

mysql error: You have an error in your SQL syntax.  Check the manual 
that corresponds to your MySQL server version for the right syntax to use 
near ' '',
'BlackbirdDJ', 2696, 1102976866,
'cheers', 1, 0,

mysql error number: 1064

Date: Monday 13th of December 2004 10:27:46 PM
Script: http://--/forum/newreply.php
Referer: http://--/showthread.php?t=10154
Username: BlackbirdDJ
IP Address: --

I have these mods added:

Who Viewed This Thread - Enhanced Version
Advanced Editing Options For Mods & Admins
Reoccurring Paypal Subscriptions
Email notification if someone attempts to access your Admin CP
BB Messenger 1.5
ipInfo -- Extra user IP information
Proxy ip to real ip conversion
V3acade
uCash & uShop
modmanagementv1
vBSigHosting
Whos online in admin
statistik_english2
Advanced Warning System (AWS)
Hide
vB Report Manager 2.0 (Admin CP) - Report to Email, PM, Forum



(PS: I removed the IP of the user, and URL - also note its off different users too)


Do you know whats wrong :ermm:

[MickDoneDee]

I can see the syntax error: there is no parentid value. However, I don't know which file is making that query. When the file is found you'll be able to fix the query.

Try searching all your files for this text string:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "post

I searched my files and couldn't find it so I don't think it's related to this hack.

[Paul M]

There is also an error here

'BlackbirdDJ', 2696, 1102976866,
'cheers', 1, 0,
'81.--,'', 0, 1, 0)

But since you have edited the error message it's impossible to tell if it's a real error. If you want any more help you must post the actual error message, not an edited version.

[rh2004]

Here is the message as it is displayed, I have just repalced the IP

Database error in vBulletin 3.0.3:

Invalid SQL: 
			INSERT INTO post
				(threadid, parentid, title, username, userid, dateline, pagetext, 
allowsmilie,
				 showsignature, ipaddress, proxyip, iconid, visible, attach)
			VALUES
				(2463, , '',
				 'luciosestio', 2762, 1103012553,
				 'Grazie !', 1, 0,
				 '127.3.192.6','213.175.2.50', 0, 1, 0)
		
mysql error: You have an error in your SQL syntax.  Check the manual 
that corresponds to your MySQL server version for the right syntax to use 
near ' '',
				 'luciosestio', 2762, 1103012553,
				 'Grazie !', 1, 

mysql error number: 1064

Date: Tuesday 14th of December 2004 08:22:33 AM
Script: http://www.mydomain.com/forum/newreply.php
Referer: http://www.mydomain.com/forum/showthread.php?t=2463
Username: luciosestio
IP Address: 127.3.192.6

Also any idea on where about this will be, in included folder?

DB_site->query("INSERT INTO " . TABLE_PREFIX . "post



Thanks