Proxy ip to real ip conversion

[Paul M]

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

[???`S?LV?R???`]

nice

[Surtain23]

Cool, I'm going to install this later after I work on vb ads for a while.

[BladeZ]

Thank you! Very usefull :)
*clicks install*

[Bigwrenn]

Thank you very much! :D

[sacredfox]

wheres the original proxy hack that i need

[Beermonster]

Very good idea

* Beermonster clicks install :)

[lcryan]

kinda having trouble beleaving it can resolve the users real IP, but we will see :)

[Paul M]

wheres the original proxy hack that i needIn the Zip file, as it says. :)

kinda having trouble beleaving it can resolve the users real IP, but we will see :)As long as the proxy passes the client IP on in the standard http variables it will. Obviously it can't do anything about proxies that don't do this. I can't perform miracles.

[Spinball]

Paul - I've installed your hack as per the instructions, but I'm getting IP addresses being saved by proxy users in the post table such as
192.168.1.7, 82.
172.26.106.249,
unknown, 10.255.
10.20.5.2, 194.2

I'm regarding this is quite a serious error as IP information needs to be correct.

I've looked at the bit of code which I think gets the real IP in init.php :
// ####################### HN getproxyip START########################
// Establish Proxy Server IP address (if it exists) and Real IP Address
// Make sure forum always uses real client IP address
// Start of Paul Marsden Proxy Hack Modification
if ($_SERVER['HTTP_X_FORWARDED_FOR'] != '')
{
$proxyip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}
else if ($_SERVER['HTTP_CLIENT_IP'] != '')
{
$proxyip = $_SERVER['HTTP_CLIENT_IP'];
}
else if ($_SERVER['HTTP_FORWARDED'] != '')
{
$proxyip = $_SERVER['HTTP_FORWARDED'];
}
else
{
$proxyip = '';
}
$proxyip = preg_replace('/javascript/i', 'java script', $proxyip);
$proxyip = str_replace('"', '"', $proxyip);
$proxyip = str_replace('<', '&lt;', $proxyip);
$proxyip = str_replace('>', '&gt;', $proxyip);
if (!preg_match("#\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}#", $proxyip))
{
$proxyip = '';
}
if ($proxyip == '')
{
define('PROXYIP', '');
define('IPADDRESS', $_SERVER['REMOTE_ADDR']);
}
else
{
define('PROXYIP', $_SERVER['REMOTE_ADDR']);
define('IPADDRESS', $proxyip);
}
unset($proxyip);
// End of Paul Marsden Proxy Hack Modification
// ####################### HN getproxyip END ########################

Is this code in error?
Please help!

[Paul M]

Paul - I've installed your hack as per the instructions, but I'm getting IP addresses being saved by proxy users in the post table such as
192.168.1.7, 82.
172.26.106.249,
unknown, 10.255.
10.20.5.2, 194.2

I'm regarding this is quite a serious error as IP information needs to be correct.

Please help!Hi Spinball,

This problem is corrected in v1.1 - which has a better ip extraction and check.

The steps to update are in the new zip file. :)

[Spinball]

Thanks. I'll keep an eye on it. For the bad IP addresses, I'll just edit out anything after the first 4 numbers and in the case of them having 'unknown' in the text I'll leave them blank. Do you agree with this course of action?
FYI I have installed this hack and the IP Info hack so my moderators can track down the morons causing trouble with duplicate registrations and proxys.

[mikeB]

I installed Proxy Detector 3.0 to my VB 3.01 - and next to the IP button is _HacNho - it doesnt seem to be working, any idea what might cause this? thanks>!

[Paul M]

For the bad IP addresses, I'll just edit out anything after the first 4 numbers and in the case of them having 'unknown' in the text I'll leave them blank. Do you agree with this course of action?Yes, if you really need to edit old records that are in error then that would work. I'm not sure it is worth the effort, depends on how many you have I suppose.

I installed Proxy Detector 3.0 to my VB 3.01 - and next to the IP button is _HacNho - it doesnt seem to be working, any idea what might cause this? thanks>!Well I didn't write that hack, but by the sound of it you have a small error in the postbit_ip template. Make sure you have copyied that part correctly.

[mikeB]

Well I didn't write that hack, but by the sound of it you have a small error in the postbit_ip template. Make sure you have copyied that part correctly.

no Ive checked it 10 times - maybe this wont work w 3.0.1?

[Paul M]

no Ive checked it 10 times - maybe this wont work w 3.0.1?Hmm, Well you are right, the postbit_ip template code in that proxy detector text file is a bit duff. I just took that hack, as was, and added it to my zip file assuming it was ok.

You could replace it with this which should work ok ;

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

But it's a bit academic if you are applying my Hack, as part of mine replaces the postbit_ip template code again anyway.

Paul.

[nnjj.net]

nothing change,
I did the change in postbit_ip
but nothing!

[Paul M]

nothing change,
I did the change in postbit_ip
but nothing!Sorry, but you will have to be a little more specific.

What steps have you done, and what is the problem ?

[Rich]

Hello,
I have some members that I know for certain are behind a proxy. however, this hack hasn't changed or added the second "red" comp in their posts.
I do believe that it is showing the correct IP, but now I can't see who else is behind a proxy.
If there is a proxy detected, will it tell me that a proxy was detected? I click the normal comp and it tells me the IP and the host, but not if they were behind a proxy.
On "who's online", nothing has changed either. All I see are the usernames,where they are currently on the site, and their IP address. Should i also see the host?

[integra99]

Hello,
I have some members that I know for certain are behind a proxy. however, this hack hasn't changed or added the second "red" comp in their posts.
I do believe that it is showing the correct IP, but now I can't see who else is behind a proxy.
If there is a proxy detected, will it tell me that a proxy was detected? I click the normal comp and it tells me the IP and the host, but not if they were behind a proxy.
On "who's online", nothing has changed either. All I see are the usernames,where they are currently on the site, and their IP address. Should i also see the host?
Depends on if they are using a completly anonymous proxy, or just a regular proxy

[DeMiNe0]

whatproxy can i use to test this?

[Paul M]

Hello,
I have some members that I know for certain are behind a proxy. however, this hack hasn't changed or added the second "red" comp in their posts.
I do believe that it is showing the correct IP, but now I can't see who else is behind a proxy.
If there is a proxy detected, will it tell me that a proxy was detected? I click the normal comp and it tells me the IP and the host, but not if they were behind a proxy.
On "who's online", nothing has changed either. All I see are the usernames,where they are currently on the site, and their IP address. Should i also see the host?
See https://vborg.vbsupport.ru/showpost.php?p=551685&postcount=9 for the first bit.

For who's online, it is an option (in Admin CP) to turn on host display, but this still relies on there actually being a reverse dns lookup record for the ip (which is nothing to do with me ;))

[MickDoneDee]

Thanks Paul. Yesterday I installed Proxy Detector v3.1 - for Posts and WOL (https://vborg.vbsupport.ru/showthread.php?t=61331) which also allows you to see the Proxy IP address and Real IP address in Who's Online when User Agent info is displayed.

I think I discovered a bug afterwards in relation to the Revert function which caused my Whosonline template to disappear. I explained what happened in this (https://vborg.vbsupport.ru/showpost.php?p=558336) post.

Today I added your Proxy IP Hack Modification v1.1. Can you explain why you've changed the text in the phrase thread_displayproxyip from

Below is text from original Proxy Detector v3.0 hack which is replaced

The proxy IP Address is: $postinfo[ipaddress]<br>
The proxy host name is: $postinfo[hostaddress]<br>
The real IP Address is: $postinfo[proxyip]
--------------------------------------------------------
to

Real IP Address : $postinfo[ipaddress]<br>
$postinfo[hostaddress]<br>
Proxy Server IP Address : $postinfo[proxyip]<br>
$postinfo[proxyhost]
-----------------------------------------------------------
Why was this necessary?

Also, in your postbit_ip modification one of the lines you add is:

<if condition="($post[proxyip] != '' & $permissions['adminpermissions'])">

I changed it to <if condition="($post[proxyip] != '')">

to allow my supermods to see the red gif identifying the proxy users.

[Paul M]

Can you explain why you've changed the text in the phrase thread_displayproxyip ....Well I would have hoped it was obvious from looking at it. The old template has the ip's reversed (i.e. it displays the proxyip as the real ip, and vice versa) - there is also now a forth line to display the proxy servers host name.

<if condition="($post[proxyip] != '' & $permissions['adminpermissions'])">

I changed it to <if condition="($post[proxyip] != '')">

to allow my supermods to see the red gif identifying the proxy users.Fine, it was just an extra check and should probably be removed anyway as it's a bit redundant. Interestingly, our supermods can see them anyway. If I do another update I'll probably remove it myself.

[MickDoneDee]

Well I would have hoped it was obvious from looking at it. The old template has the ip's reversed (i.e. it displays the proxyip as the real ip, and vice versa) - there is also now a forth line to display the proxy servers host name.


It was obvious to me, Paul but I wanted confirmation from a coder. Are you saying that original text display is incorrect? Why then hasn't someone informed mtha?
https://vborg.vbsupport.ru/showthread.php?t=61331

[Paul M]

It was obvious to me, Paul but I wanted confirmation from a coder. Are you saying that original text display is incorrect? Why then hasn't someone informed mtha?
https://vborg.vbsupport.ru/showthread.php?t=61331No, the original text display is correct for the way his hack works.

The main reason I wrote this [for our forum] was because when his hack detects a proxy, it still treats the proxy server ip as the real ip, and just records the real ip in the proxyip field. As detailed in post one of this thread, my hack corrects this 'problem' and makes sure the forum always uses the members real ip, even when a proxy is detected. :)

[MickDoneDee]

Thanks again, Paul. Just wanted further clarification as the fields appear to be swapped between your version and the original but your modification works and adds further benefits to the original without diminishing the original so thankyou for sharing it.

[MickDoneDee]

The main reason I wrote this [for our forum] was because when his hack detects a proxy, it still treats the proxy server ip as the real ip, and just records the real ip in the proxyip field. As detailed in post one of this thread, my hack corrects this 'problem' and makes sure the forum always uses the members real ip, even when a proxy is detected. :)

Paul, I need further clarification, please. With your hack installed and a member logs in using a proxy will that proxy address be stored in the database and be available to search in admin or mod cp to see which members use the same proxy server?

Or are proxy IP addresses ignored and not stored? Thereby, making it impossible to search and find proxy IPs shared by members.

[Paul M]

With your hack installed and a member logs in using a proxy will that proxy address be stored in the database and be available to search in admin or mod cp to see which members use the same proxy server?Yes, and No. Both addresses are stored, but the ACP / MCP functions only scan the real ip data field, not the proxy ip field.

Or are proxy IP addresses ignored and not stored? Thereby, making it impossible to search and find proxy IPs shared by members.No, and Yes !. As above, the proxy server addresses are stored, but the current vB ip functions do not access them.

[MickDoneDee]

Paul, since installing your hack I'm getting weird results when searching in admin cp Search IP Addresses.

For example: a member called Scott-Wozniak has 640 posts recorded with 80.3.32.4 When I do a search "Find IP Addresses for user" and type Scott-Wozniak I get 80.3.32.4 However, when I use "Find Users by IP Address" and type 80.3.32.4 I get No Matches Found. What is going on here, Paul. Have others experienced the same problem since installing this hack.

I've checked other members including myself and some IP numbers listed when using Find IP Addresses for user return "No Matches Found" when entered as the search string in Find Users by IP Address to get the members name. But some IP numbers do return the member's name. Any explanation for this?

[Paul M]

Paul, since installing your hack I'm getting weird results when searching in admin cp Search IP Addresses.

For example: a member called Scott-Wozniak has 640 posts recorded with 80.3.32.4 When I do a search "Find IP Addresses for user" and type Scott-Wozniak I get 80.3.32.4 However, when I use "Find Users by IP Address" and type 80.3.32.4 I get No Matches Found. What is going on here, Paul. Have others experienced the same problem since installing this hack.

I've checked other members including myself and some IP numbers listed when using Find IP Addresses for user return "No Matches Found" when entered as the search string in Find Users by IP Address to get the members name. But some IP numbers do return the member's name. Any explanation for this?
Sorry, TBH I can't follow exactly what what you are saying, but just to be clear here - this hack makes no changes to the search functions in ACP, or MCP, nor does it make any changes to ip data collected prior to installing it. All it does, if a proxy is detected, is make the correct ip address for that member is available to vB. What vB does with that ip is unchanged.

[gotvenm]

Paul, great work !

I was wondering if there was an easy way to show something in WOL to see whos using a proxy without needing them to post first ?

I have hancho's WOL installed, but it doesnt seem to show this...?

[MickDoneDee]

<a href="https://vborg.vbsupport.ru/showthread.php?t=61331" target="_blank">Proxy Detector v3.1 - for Posts and WOL </a> shows proxy IP in WOL but first you must turn the User Agent option on. The setting is at the bottom of the WOL page and is off by default. It also defaults each time you close the page and re-open it. Once user agent is on the real IP is seen above the user agent info and the proxy IP is indicated by a blue question icon (vB3)that appears to th eright of the user agent info. Mouse-over/hover over the icon to reveal the proxy IP.

[gotvenm]

Proxy Detector v3.1 - for Posts and WOL (https://vborg.vbsupport.ru/showthread.php?t=61331) shows proxy IP in WOL but first you must turn the User Agent option on. The setting is at the bottom of the WOL page and is off by default. It also defaults each time you close the page and re-open it. Once user agent is on the real IP is seen above the user agent info and the proxy IP is indicated by a blue question icon (vB3)that appears to th eright of the user agent info. Mouse-over/hover over the icon to reveal the proxy IP.

Oh... DOH ! Thanks for explaining that to me. I get it now.
I was turning on the user agent, but somehow I missed the whole mousehover over the ? thing.

[mtha]

Oh... DOH ! Thanks for explaining that to me. I get it now.
I was turning on the user agent, but somehow I missed the whole mousehover over the ? thing.
The pupose of leaving them in "user agent" is I dont want/need to see too many text in the WOL page (my preference).

however, if you want, you can modify the template :)

[Neal-UK]

The pupose of leaving them in "user agent" is I dont want/need to see too many text in the WOL page (my preference).

however, if you want, you can modify the template :)
This version works fine, great thanks!

[JazzleBug]

I like this, but would like to see it integrated into the ipInfo hack (https://vborg.vbsupport.ru/showthread.php?t=66824) (or vice versa)...

[MickDoneDee]

I like this, but would like to see it integrated into the ipInfo hack (https://vborg.vbsupport.ru/showthread.php?t=66824) (or vice versa)...
I'm happy that the IpInfo hacks works as an add-on. It just means you have two ip.gif icons in the postbit but that doesn't bother me.

[JazzleBug]

I'm happy that the IpInfo hacks works as an add-on. It just means you have two ip.gif icons in the postbit but that doesn't bother me.
Oh, absolutely! Don't get me wrong, I love both of them and will gladly live with two icons, but I'm a freak for streamlined, consolidated functionality. ;)

[Seekers]

Well I am pretty puzzled. I have installed the hack but I don't see anything different in the WOL, or on any posts. It simply displays one IP address and not

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

as indicated by the explaination of the thread. I must have done something wrong. Anyone got any ideas.

Thanks

[peterska2]

I always get an error when I click the IP gif saying that the phrase 'thread_proxyip' can't be found. I've added it as a global phrase so I dunno what the problem is.

[MickDoneDee]

Well I am pretty puzzled. I have installed the hack but I don't see anything different in the WOL, or on any posts. It simply displays one IP address and not

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

as indicated by the explaination of the thread. I must have done something wrong. Anyone got any ideas.

ThanksTo get four lines of info instead of two the icon you click in the postbit must be the red-coloured ipp.gif. This gif only appears when a proxy IP was detected with the post. If no proxy IP was detected with the post then the normal blue-coloured ip.gif will show. When that is clicked only two lines of info will show.

To test the hack you must login via a proxy server. This is easily done. There are lists of free proxy addresses such as those on http://www.aliveproxy.com/

In your browser's connections tab look for LAN Settings and there should be an option to use a proxy server. You just enter the proxy IP address and port and save. When done, login to your site and make a test post. The red ipp.gif should be visible in the postbit. Click this to see the real IP and proxy IP details.

[MickDoneDee]

I always get an error when I click the IP gif saying that the phrase 'thread_proxyip' can't be found. I've added it as a global phrase so I dunno what the problem is.Search your postings.php file for the phrase 'thread_proxyip'. You won't find it because that is not the phrase you are required to add. You are required to add 'thread_displayproxyip'. Make sure this phrase is in your postings.php file and make sure 'thread_displayproxyip' is created as a Front-End Error Messages phrase - not a Global phrase.

[Paul M]

Thanks MDD, I couldn't have answered either of them any better. :)

[Seekers]

To get four lines of info instead of two the icon you click in the postbit must be the red-coloured ipp.gif. This gif only appears when a proxy IP was detected with the post. If no proxy IP was detected with the post then the normal blue-coloured ip.gif will show. When that is clicked only two lines of info will show.

To test the hack you must login via a proxy server. This is easily done. There are lists of free proxy addresses such as those on http://www.aliveproxy.com/

In your browser's connections tab look for LAN Settings and there should be an option to use a proxy server. You just enter the proxy IP address and port and save. When done, login to your site and make a test post. The red ipp.gif should be visible in the postbit. Click this to see the real IP and proxy IP details.


So then I assume I installed the hack correctly. I suppose I don't have any proxy IPs at this time so I can not see the full effect. Could someone that has a proxy IP please post on my site so I can verify it does work as designed. My site is www.clanseekers.com and thanks so much for the excellent help so far.

[peterska2]

Search your postings.php file for the phrase 'thread_proxyip'. You won't find it because that is not the phrase you are required to add. You are required to add 'thread_displayproxyip'. Make sure this phrase is in your postings.php file and make sure 'thread_displayproxyip' is created as a Front-End Error Messages phrase - not a Global phrase.
sorry my bad. it is thread_displayproxyip

[Seekers]

So then I assume I installed the hack correctly. I suppose I don't have any proxy IPs at this time so I can not see the full effect. Could someone that has a proxy IP please post on my site so I can verify it does work as designed. My site is www.clanseekers.com and thanks so much for the excellent help so far.


Nevermind it works great - caught a jerk lurking behind one - WOOT

[Paul M]

Nevermind it works great - caught a jerk lurking behind one - WOOTI would point out that many ISP's (in the UK anyway) force you through a proxy server.

[Reminder]

thanks

[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

[Paul M]

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,

HBHarry 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 (http://member.php?u=11941) for his original work (https://vborg.vbsupport.ru/showthread.php?threadid=38358) and a link to Proxy Detector Hack (v3.1) (https://vborg.vbsupport.ru/showthread.php?t=61331)

thanks :)

[Paul M]

well, just wondering if you should state the credit to Takara (http://member.php?u=11941) for his original work (https://vborg.vbsupport.ru/showthread.php?threadid=38358) and a link to Proxy Detector Hack (v3.1) (https://vborg.vbsupport.ru/showthread.php?t=61331)

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]

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.

So my only question is can I show the proxy button if only admin, not mods or super modsJust 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

[Paul M]

Okay, then there is nothing wrong with the ip section, your problem is, as MickDoneDee says, no parent id is being supplied - and as such is not related to this hack. Therefore there is not much I can do to help you, sorry.

[Delphiprogrammi]

this works fine but i have no idea what the image is for ? i tested it with using a proxy anonymous (level b) checked with a proxychecker and the correct ip is detected but what the heck is the image for ?

[MickDoneDee]

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

DB_site->query("INSERT INTO " . TABLE_PREFIX . "post Your error message suggests that the error is in your newreply.php script:

Script: http://www.mydomain.com/forum/newreply.php

The fault appears to be occurring when someone posts a reply.

Check any hacks that have altered the original script. If necessary, use the original file and see if the fault disappears. If it does then you have confirmed that the error is caused by the newreply.php script and that a faulty hack is the cause.

[rh2004]

Thanks alot I will check it out

[Sadie Frost]

I know very little about proxy servers, and I was wondering if anyone could tell me if I Use this hack and thus get the 'real ip', does that mean I can ban that real ip without worrying that other users will be sharing that same ip? Or does that same concern still apply? Thanks :)

[Paul M]

I know very little about proxy servers, and I was wondering if anyone could tell me if I Use this hack and thus get the 'real ip', does that mean I can ban that real ip without worrying that other users will be sharing that same ip? Or does that same concern still apply? Thanks :)As long as the real ip is being detected then yes, you can ban it.

[plubius]

I would love to install this hack and thank the coder for making it, however, I have the extra ip info hack located here www.vbulletin.org/forum/showthread.php?t=66824 (https://vborg.vbsupport.ru/showthread.php?t=66824) installed and this hack required me to change the Template: postbit_ip to this:

<if condition="$show['ip']">
$vbphrase[ip]: $post[ip]
<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>
</if>

and this excellent hack needs the same template changed to this:

<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>
<else />
<a href="postings.php?$session[sessionurl]do=getip&amp;p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
</else></if>
</if>


Is it possible to run both hacks and can this template be edited to serve them both? If it is possible could show me what I will need to edit?

[Sadie Frost]

As long as the real ip is being detected then yes, you can ban it.
Great - thanks for your help Paul :)

[Paul M]

I would love to install this hack and thank the coder for making it, however, I have the extra ip info hack located here www.vbulletin.org/forum/showthread.php?t=66824 (https://vborg.vbsupport.ru/showthread.php?t=66824) installed ......

Is it possible to run both hacks and can this template be edited to serve them both? If it is possible could show me what I will need to edit?
I don't know much about the other hack, but looking at the two templates I would suggest trying this ;


<if condition="$show['ip']">
$vbphrase[ip]: $post[ip]
<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>
<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>
</if>

This should give you two icons, one for ipinfo, and one for this hack (the red one).

HTH :)

[plubius]

I could have sworn I typed a thank you here....?

oh well, I will again as the first one did not take. Thanks for the help, PaulM

[clearchannel]

I installed Proxy Dector 3.1 and all worked as expected. When viewing who's on line, via useragent, I could see who was using a proxy server as evidenced by the question mark in useragent.

I've installed this hack, it also works as expected except I do not see who is using a proxy when viewing who's on line using useragent. Is this normal behavior, or did I do something wrong?

Thank you much for the hack and assistance.

[Paul M]

There is nothing in this hack to add anything to the WOL display when a user is on a proxy server. :)

[clearchannel]

I was under the impression this hack was an enhancement to proxy detector. I am not all all complaining, it think it's a great hack and intend on using it.

Is there a way I can add who is using a proxy server to who's on line, much the same way proxy detector utilizied that feature?

[Paul M]

I was under the impression this hack was an enhancement to proxy detector. I am not all all complaining, it think it's a great hack and intend on using it.Nope, the idea came from the original proxy hack, which I adapted and improved for my own use. The version that inspired this hack made no alteration to the WOL.

Is there a way I can add who is using a proxy server to who's on line, much the same way proxy detector utilizied that feature?I'm sure there is, and if I have time at some point I'll look at it, but not at the moment.

[Paul M]

vB 3.0.4

If you don't do the full upgrade to 3.0.4, but do the recommended upgrade of init.php then remember that this hack includes an edit of that file - which will need to be re-applied. :)

[Eagle Creek]

ASO forums systeembericht

Could not find phrase 'thread_displayproxyip'.


But that sentence is really there (global)(!).

[Eagle Creek]

no Ive checked it 10 times - maybe this wont work w 3.0.1?
And to be honest.. All my users have displayed the proxy icon under their name..

[Paul M]

Um, did you have a specific question ......

[Dennis B]

Installed in 3.0.5 without problems. Still testing it. Thanks anyway for sharing. :up:

[Eagle Creek]

Um, did you have a specific question ......

I had but not anymore, I guess I did something wrong with the install..

[Paul M]

I had but not anymore, I guess I did something wrong with the install..So have you installed this ? If so then might I ask you to click on the relevant install link to indicate you have done so. :)

[ToastBusters]

Hey guys,

I just *barely* installed my copy of vb last night, so I have a few complete newbie questions for you guys.

First, the modification has this:

Add the following phrase "thread_displayproxyip" ;

How do I go about doing that? Second:

Replace the template "postbit_ip";

Do I do that by editing a file or making changes in the admin cp?

Finally, is it permissible to create a second "test" board that only I have access to so I can test mods before making them live? It's not your competence in creating the mods that concerns me, only my own ability to impliment them. ;)

Thanks!

[yoyoyoyo]

Hey guys,

I just *barely* installed my copy of vb last night, so I have a few complete newbie questions for you guys.You may want to read up a bit before adding any hacks, etc., and start off with some simple ones (look in the minor mods section)First, the modification has this:

Add the following phrase "thread_displayproxyip" ;

How do I go about doing that?
In the admin CP -> languages & phrases -> Phrase Manager -> Add New Phrase

Replace the template "postbit_ip";

Do I do that by editing a file or making changes in the admin cp?
all template changes are done via the style manager in the admin CP
Finally, is it permissible to create a second "test" board that only I have access to so I can test mods before making them live? It's not your competence in creating the mods that concerns me, only my own ability to impliment them. ;)
yes, you can have one, but it must be not available to the public (ie: closed) and it must be named "vbtest," and located on the same server, etc..

[ToastBusters]

[quote]yes, you can have one, but it must be not available to the public (ie: closed) and it must be named "vbtest," and located on the same server, etc..[/quote

I can't imagine doing it any other way. :)

Thanks man, just what I wanted to know! I've done extensive hacks on a phpbb before this, but on that software it's just follow the instructions and replace code. I don't think I've ever had to do anything in the control panel.

[charlesk]

Well, I just tested this hack using two different proxies. The first time, it detected the proxy but got the real IP address wrong, and the second time it didn't detect it at all. Any suggestions?

It does seem to be working for some proxies. Install clicked; thanks.

Charles

[Delphiprogrammi]

charlesk ,

that's completely normal anonymous do not pass the variables this hack uses ... that's why it is called "anonymous" for example an anonymous proxy won't pass "HTTP_X_FORWARDED_FOR" <<-- you'll see the anonymous proxy ip here instead.

anyway i'm having a problem with this hack it's operation works fine but if i click the image to get the ipadress vbulletin tells me "couldn't find the phrase "thread_displayproxyip" althrough the phrase is there and i'm sure i didn't make any typos while editing postings.php (phrasetype GLOBAL)


$postinfo['proxyhost'] = @gethostbyaddr($postinfo['proxyip']);
if($postinfo['proxyip'] !='')
{
eval(print_standard_error('thread_displayproxyip', 1, 0));
}


attached two images one shows that the hack is working correctly the second image is a little proof the phrase is there now the question is what do i do about it ?

[charlesk]

Delphi: you need to make the phrase a Front End Error phrase rather than a global. That happened to me as well, I hope Paul will fix the instructions.

As for the anon proxy issue... it doesn't seem to even work for AOL proxies, which is unfortunate.

c

[Paul M]

Delphi: you need to make the phrase a Front End Error phrase rather than a global. That happened to me as well, I hope Paul will fix the instructions.Oops, I completely forgot to update them. I'll do it now.

[Paul M]

As for the anon proxy issue... it doesn't seem to even work for AOL proxies, which is unfortunate. Yes, it will only work with proxy servers that actually pass the correct http variables. There is nothing anyone can do about that.

[Delphiprogrammi]

hmmm strange now i'm getting the global variables names as result

IPADDRESS and PROXYIP looks like it passed or something i can't find anything wrong with it :rolleyes:

[Paul M]

Are you sure you have correctly done the edit to init.php and uploaded it ? - this is where those constants are defined.

[Delphiprogrammi]

Are you sure you have correctly done the edit to init.php and uploaded it ? - this is where those constants are defined.

i did edited that file but there was a typo :tired: now it works fine i tested it with a normal proxy and with an anonymous one (the hack doesn't detect this type of proxys) but that's normal nothing you or anybody else cando about it

rgds

[cyt0plas]

So what if a regular user sends the X-Forwarded for header, specifying someone else's IP? Can the user avoid bans/etc?

[Delphiprogrammi]

So what if a regular user sends the X-Forwarded for header, specifying someone else's IP? Can the user avoid bans/etc?

that's impossible unless you "spoof" an ip adress which isn't so easy ...

[xheliox]

Is there any way to ignore reserved private IP ranges? I have several users who show up has having 192.168.x.x or 10.0.x.x as their "real IP".

Great mod, btw.. :)

[Paul M]

Is there any way to ignore reserved private IP ranges? I have several users who show up has having 192.168.x.x or 10.0.x.x as their "real IP".

Great mod, btw.. :)What exactly do you mean by "ignore them" ?

[xheliox]

What exactly do you mean by "ignore them" ?Show the "real IP" as the proxy IP.

[Paul M]

Well I haven't tested it, but this should work ;

Find;

$proxyip = $iplist[0];

Add below it ;

if (preg_match("#^(127|10|172\.(1[6-9]|2[0-9]|3[0-1])|192\.168|169\.254)\.#", $proxyip))

{
$proxyip = '';
}

Obviously this won't change any existing data.

Edit: Updated for full 172 range and 127 range as per posts below.

[xheliox]

That seemed to do the trick. Thank you kindly.

Any chance you'll be adding that to your next release?

[xheliox]

PS - the range is 172.16.0.0 through 172.31.255.255.. I'm a regex moron, how would I add that range?

preg_match("#^(10|172\.[16-31]|192\.168)\.#", $proxyip))

?

[Paul M]

PS - the range is 172.16.0.0 through 172.31.255.255.. I'm a regex moron, how would I add that range?

preg_match("#^(10|172\.[16-31]|192\.168)\.#", $proxyip))

?
I'm not sure that would work - regex gives me headaches - I'll look into it for you.

[xheliox]

I'm not sure that would work - regex gives me headaches - I'll look into it for you.Yeah, my way didn't work at all. It just broke the whole thing. :(

I appreciate it. :)

[Paul M]

Try this;

if (preg_match("#^(10|172\.(1[6-9]|2[0-9]|3[0-1])|192\.168)\.#", $proxyip))

:)

[xheliox]

That seems to work.. I'll keep an eye on it and let you know. Thanks again!

[David Bott]

I was just coming here to post about this same issue. I just had an issue with 127.0.0.1 and also some 10.X.X.X numbers. I do not think the above handles 127's. Somtimes hacks just work too good.

[Paul M]

Somtimes hacks just work too good.No, they work as designed. :)

I have no reason to exclude those addresses, so my hack doesn't. If you don't want them then use the extra code posted above, you can add 127.x.x.x to it easily enough as well.

[David Bott]

Hi Paul...Thanks for the reply. I am sorry to say I am not advanced enough to understand how to add in the 127 range. Can you please be so kind to advise.

Thank you in advance. (Currently dealing with a problem user.)

[Paul M]

Hi Paul...Thanks for the reply. I am sorry to say I am not advanced enough to understand how to add in the 127 range. Can you please be so kind to advise.Sure - I have updated the code in Post 98 (https://vborg.vbsupport.ru/showpost.php?p=610959) for all the changes. :)

[David Bott]

Paul...Here is something for you to REALLY help in this case...

http://www.tcpipguide.com/free/t_IPReservedPrivateandLoopbackAddresses-3.htm

It lists all the private IP's that could be used. (Not many)

Thank you for the updates!!!!

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

BTW...Now running on TiVo Community (http://www.tivocommunity.com) and will be at AVS Forum after I convert that. (http://www.avsforum.com)

[Paul M]

Thanks - the only one really relevant in that list that was missing was the DHCP auto range of 169.254.x.x - I have added that.

BTW - you just reminded me to check my old Tivo userid out - I joined in 2002 !

[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]

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

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]

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]

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]

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]

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.

[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]

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]

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]

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]

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]

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 HackThe 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:
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: $tableprefixhttp://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]

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

[VBUsers]

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


this is what you need to add

Step 2.

Add the following phrase (with out the "")"thread_displayproxyip" (as a Front End Error Phrase, not a Global Phrase) <----in this area.choose in the drop down;

enter this text:

then post this in the box
Real IP Address : $postinfo[ipaddress]<br>
$postinfo[hostaddress]<br>
Proxy Server IP Address : $postinfo[proxyip]<br>
$postinfo[proxyhost]


and save.

[bonnmac]

ok i've done that and i get nothing i see no change from the way vb was i had a friend login with a proxy and it showed the proxy ip normal did not show real ip am i doing something wrong?

[Paul M]

ok i've done that and i get nothing i see no change from the way vb was i had a friend login with a proxy and it showed the proxy ip normal did not show real ip am i doing something wrong?That depends on the proxy server your friend is using, as it says in the first post;

Obviously, like all proxy server detection hacks, this will only work if the proxy server passes the appropiate http variables.

[MickDoneDee]

ok i've done that and i get nothing i see no change from the way vb was i had a friend login with a proxy and it showed the proxy ip normal did not show real ip am i doing something wrong?Did your friend make a post? That is the real test. A post which was made using a proxy ip will call the red icon which will reveal the real ip address when clicked or hovered over with the mouse.

[VBUsers]

Did your friend make a post? That is the real test. A post which was made using a proxy ip will call the red icon which will reveal the real ip address when clicked or hovered over with the mouse.

yeah have atleast 3 members/staff post with Proxy IPs. that way you will know if it did work. also make sure that you added everything in the right place. sometimes you make a mistake and its as easy as doing the edit over.

[VBUsers]

See https://vborg.vbsupport.ru/showpost.php?p=551685&postcount=9 for the first bit.

For who's online, it is an option (in Admin CP) to turn on host display, but this still relies on there actually being a reverse dns lookup record for the ip (which is nothing to do with me ;))

cant seem to find this is want to see the icon in the whos online but i dont find this option.

[MickDoneDee]

What are you asking?

[Paul M]

cant seem to find this is want to see the icon in the whos online but i dont find this option.Erm, what icon ? - This hack does not add any icons to the WOL display :confused:

[YLP1]

Hi all...I am applying this modification but came across a major difference in the code to be replaced:

Instructions say to find this:
Find:

// ### POST NEW POST ###
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, 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']) . "', $post[iconid], $post[visible], $totalattachments)
");

My functions_newpost.php says this:
// ### POST NEW POST ###
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach, useragent, altip)
VALUES
($threadinfo[threadid], $parentid, '" . addslashes($post['title']) . "',
'" . addslashes($post['postusername']) . "', $bbuserinfo[userid], " . TIMENOW . ",
'" . addslashes($post['message']) . "', $post[enablesmilies], $post[signature],
'" . addslashes($post['ipaddress']) . "', $post[iconid], $post[visible], $totalattachments,
'" . addslashes($_SERVER['HTTP_USER_AGENT']) . "', '" . ALT_IP . "')
");


I have this extra code in my file:

'" . addslashes($_SERVER['HTTP_USER_AGENT']) . "', '" . ALT_IP . "')


I am not sure what to do with this added line (I have ver 3.0.7)

Please advise and thanks in advance.

[Paul M]

You must have added a hack at some point ;

Replace the code with this and it should be ok ;


// Paul M Proxy Hack v1.31x
// ### 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, useragent, altip)
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,
'" . addslashes($_SERVER['HTTP_USER_AGENT']) . "', '" . ALT_IP . "')
");
// End Proxy Hack

[YLP1]

Thank you bunches Paul!

[mojo8850]

Hi Guy's.!

Is there any chance of having a screenshot.
I'd like to see on how it would look like once installed..! :)

[Paul M]

Hi Guy's.!

Is there any chance of having a screenshot.
I'd like to see on how it would look like once installed..! :)I'll do a couple if I get chance.

[Corriewf]

This isnt working for on whos online...Everything else is working fine though :)

[Paul M]

This isnt working for on whos online...Everything else is working fine though :)Since it doesn't change anyting in WOL, I don't understand what you mean, please explain.

BTW, what is vB 4.0.1 ? (this is the version number you have in your profile).

[Corriewf]

Since it doesn't change anyting in WOL, I don't understand what you mean, please explain.

BTW, what is vB 4.0.1 ? (this is the version number you have in your profile).

I will answer you with a quote.

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

Also sorry but I cannot release any details pertaining to the validity of 4.0 or 4.0.1 due to any tort involved.

[Paul M]

I will answer you with a quote.That's nice, and tells me nothing. Once again, please explain your problem. Also, please click on install. At the moment you are not showing as having installed this hack.


Also sorry but I cannot release any details pertaining to the validity of 4.0 or 4.0.1 due to any tort involved.Okay .......

[Corriewf]

That's nice, and tells me nothing. Once again, please explain your problem. Also, please click on install. At the moment you are not showing as having installed this hack.


Okay .......


http://www.w3bdevil.com/forums/Understand-BillAndTed.jpg

Ok you stated in the original post that the IP resolves and the correct one is displayed on whos online.......... And that isnt happening for me.....

Before you think it , it shows in their post the icon to resolve to the correct IP however that same user's IP is the proxy on WOL.

[Abe1]

I installed the hack and when ever I opened a new thread, it would double post my first post.

[Paul M]

I installed the hack and when ever I opened a new thread, it would double post my first post.Check you did Step 5 correctly, note it says "Replace". :)

[Abe1]

Check you did Step 5 correctly, note it says "Replace". :)
OK. Thanks. I'll check and let you know if I have a problem.

[Eagle Creek]

Guess you did something wrong then..

[montda]

if i want to show the real ip to user group=6 wat i have to do?

[Abe1]

I figued out my problem. I was installing it over another hack I had in the same area.

[zetetic]

Nice hack, Paul. I had a little problem with one of the edits because of Xenon's doublepost hack but I figured it out. I also noticed you mentioned the conflict in a post on his thread... maybe you should mention it here too in case someone else installs his before yours. :)

[Paul M]

What problem did you have ?

[Corriewf]

Nice hack, Paul. I had a little problem with one of the edits because of Xenon's doublepost hack but I figured it out. I also noticed you mentioned the conflict in a post on his thread... maybe you should mention it here too in case someone else installs his before yours. :)


Do you mind posting the code integration?

[zetetic]

What problem did you have ?
Oh nothing major. It's just that Xenon's hack edit is inserted between // ### POST NEW POST ### and the query, so step five in your instructions was a bit confusing for me.

corriewf, just ignore that POST NEW POST line above when you do that search and replace in section #5 and you should be fine. :)

[zetetic]

Aha, now that I've used this a bit I see what the others meant about the WOL not working. Paul, I know your hack doesn't make any changes to the WOL list, but version 3.1 of the old hack does. But for some reason that doesn't work anymore after upgrading to your version.

The way it used to work is when you looked at the WOL list, if a user was behind a proxy their real IP would show up (as it still does) but next to it would be the blue question mark graphic which you could mouseover to see the proxyip. I don't know how that would be terribly useful, but it explains what people mean by there being a missing icon in the WOL anyway.

[Paul M]

Oh nothing major. It's just that Xenon's hack edit is inserted between // ### POST NEW POST ### and the query, so step five in your instructions was a bit confusing for me.

corriewf, just ignore that POST NEW POST line above when you do that search and replace in section #5 and you should be fine. :)Ah, I see what you mean, I'll remove that line from the instructions, then they will match in either case.

[Paul M]

Aha, now that I've used this a bit I see what the others meant about the WOL not working. Paul, I know your hack doesn't make any changes to the WOL list, but version 3.1 of the old hack does. But for some reason that doesn't work anymore after upgrading to your version.

The way it used to work is when you looked at the WOL list, if a user was behind a proxy their real IP would show up (as it still does) but next to it would be the blue question mark graphic which you could mouseover to see the proxyip. I don't know how that would be terribly useful, but it explains what people mean by there being a missing icon in the WOL anyway.Well this was never meant to work with the other proxy hack - the only reason it's mentioned is because we had the proxy 3.0 version installed on our forum at the time I decided to develop this - therefore it made sense to use part of the 3.0 code we already had (mainly for storing the extra IP in the database). In reality, had I written it from scratch then the code would pretty much have been the same anyway.

I have never actually looked at the 3.1 version so I have no idea what it does to the WOL, or why it would stop it working but I'll take a peek and see if it's obvious.

[zetetic]

I have never actually looked at the 3.1 version so I have no idea what it does to the WOL, or why it would stop it working but I'll take a peek and see if it's obvious.
One of the attachments available on that hack thread is just the WOL changes, so that should make it pretty easy to spot any differences. :)

[Paul M]

One of the attachments available on that hack thread is just the WOL changes, so that should make it pretty easy to spot any differences. :)I can see no reason why it would stop working - if you already have the proxy hack 3.1 WOL code installed - then installing this hack should have no effect. The PH3.1 WOL works by storing the detected proxyip in the sessions table, this hack would not affect this.

[zetetic]

I can see no reason why it would stop working - if you already have the proxy hack 3.1 WOL code installed - then installing this hack should have no effect. The PH3.1 WOL works by storing the detected proxyip in the sessions table, this hack would not affect this.
Oh, I see what you mean. Now I realize the reason I'm not seeing that graphic is the $show[useragent] conditional which I apparently don't have set (and can't find). Anyway sorry to bother you.

[Rukas]

Seems to be working fine. Wont know until I come accross a proxy though I guess.

Question, when searching users IPs in the Admin CP, will it specify which is a proxy and which is real or will it just resolve the proxy into a real IP?

[Paul M]

Oh, I see what you mean. Now I realize the reason I'm not seeing that graphic is the $show[useragent] conditional which I apparently don't have set (and can't find). Anyway sorry to bother you.It's a setting at the bottom of each WOL page.

Question, when searching users IPs in the Admin CP, will it specify which is a proxy and which is real or will it just resolve the proxy into a real IP?Only the real ip is searchable, because the ACP code does not know that the proxip field exists.

[Eagle Creek]

You know what would be nice;

when the forum detects you are surfing a proxy it looks op your reall IP. If your reall IP's is banned; you don't have forum acces. Not even with proxy.

[Paul M]

Um, that's exactly what this does :)

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

[zetetic]

It's a setting at the bottom of each WOL page.
Wow. I went through every related php file and template twice before realizing what you mean. I can't believe I've never noticed that option before. Thanks!

[Eagle Creek]

Um, that's exactly what this does :)

Huh? Well... if that's the case it's just great!

(huh? im really confused... when I asked the same question about, uuhm, 8 months ago people said to me "no that isn't possible". Maybe I'm confussing some hacks with each other! THX ANYWAY!)

[Paul M]

(huh? im really confused... when I asked the same question about, uuhm, 8 months ago people said to me "no that isn't possible". Maybe I'm confussing some hacks with each other! THX ANYWAY!)You must have asked this about another hack - it was one of the reasons I developed this version. The real ip is extracted and assigned to the standard vB ipaddess static variable - this is what vB then uses in all it's ip related functions (wol, sessions, banning, ip searching etc).

[sv1cec]

Paul M,

I just installed your hack, but is there anyway to test it? I am sorry if this has been posted before, I skipped through some of the pages and didn't see a way to test it.

Rgds and many thanks

[Paul M]

You're not showing as having it installed ;)

The only test is to post via a proxy server (one that passes on the correct http headers). If you PM me a test account I can post on your forum - my ISP is ntl in the uk - who route all http traffic through such proxy servers. I will be here for about 15 mins, and then back again in a few hours.

[MickDoneDee]

Another option is to set up your browser with a temporary proxy address and then login to your site and make a post.

Get a free proxy address from http://www.freeproxy.ru/download/lists/goodproxy.txt

Go to your browser Internet Options in the Tools menu and select the Connections tab. Click the LAN settings button and tick the Proxy Server box and type in the address and port number. Click Okay and Apply. Now when you logon to your site you should see that proxy address in WOL and get a red icon when you post.

When the test is finished remove the proxy address from your browser.

All of the above presumes you don't already have a proxy address via your ISP as Paul does.

[sv1cec]

You're not showing as having it installed

I know, LoL, I just wanted to test it first. OK, OK, I'll click install now.

My site is: http://forum.m1911.org

Just register under the name Paul M and post something in the Test Forum here:

http://forum.m1911.org/forumdisplay.php?f=85

Thanks, let's see what it does.

[sv1cec]

Neat, it works, thanks Paul M, nice hack.

Now let's wait for any ... offenders!

If I want to see who has used a proxy IP instead of a normal one, can I create a report which will compare the two columns in post? From what I read, if proxyip is not null, and the ipaddress is different than the proxyip, this meaans that this user is using a proxy to log in, right?

[Paul M]

If I want to see who has used a proxy IP instead of a normal one, can I create a report which will compare the two columns in post? From what I read, if proxyip is not null, and the ipaddress is different than the proxyip, this meaans that this user is using a proxy to log in, right?You would have to make your own report or sql query to do this, but yes, if proxy is not null, and ip <> proxy then they have come in via a proxy server. In fact, if proxy is not null, it should never equal the real ip, that would be a seriously screwed set-up.

[sv1cec]

Thank you Sir, that's what I intended to do, create an Admin report. When I have it, I'll post it here, with your permission of course.

It looks as if this is a powerful tool for the admins, again, well done.

[Paul M]

Thank you Sir, that's what I intended to do, create an Admin report. When I have it, I'll post it here, with your permission of course.Feel free. :)

[bigdog829]

Clicks install

[bulbasnore]

Clicks install.

So, if I ban the proxy IP, "what happen?!"

[Paul M]

If it's detected as a proxy then nothing. If it isn't detected as one, then it will get banned.

[Eagle Creek]

Will it work @ 3.5?

[Paul M]

I have a 3.5 version of this, which will be released in the last week of August (after my holiday).

[MP3]

In includes/functions_newpost.php

i didn't see:

$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, 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']) . "', $post[iconid], $post[visible], $totalattachments)
");


i run vb 308 :ermm:


also; If I installed the early version, what should I modify to upgrade it to the newest version? Knowing that I delete the early hack file from my pc so I can't look for the difference between both.

[Paul M]

In includes/functions_newpost.php

i didn't see:

i run vb 308 :ermm:
Well it seems to be there for me, about line 423 (under "// ### POST NEW POST ###")

also; If I installed the early version, what should I modify to upgrade it to the newest version? Knowing that I delete the early hack file from my pc so I can't look for the difference between both.The early version of what ?

[yoyoyoyo]

The instructions say " "This hack makes the forum always use the members real ip when a proxy is detected,"" and then "Obviously, like all proxy server detection hacks, this will only work if the proxy server passes the appropiate http variables." So, the claims following it are a bit confusing. They are written as it if always works. But they are a bit "optimistic" as they only work if the conditions in the first paragraph are met.

I am wondering just how many people work with a "non-anonymous" proxy?

[Paul M]

It seems perfectly clear to me - when a proxy is detected, the real ip is used, not the proxy ip. A proxy can only be detected if it passes the correct http variables. Only you seem to be confused.

I am wondering just how many people work with a "non-anonymous" proxy?1.5 million ntl customers in the uk for starters, as well as many companies and other ISP's.

[yoyoyoyo]

It seems perfectly clear to me - when a proxy is detected, the real ip is used, not the proxy ip. A proxy can only be detected if it passes the correct http variables. Only you seem to be confused.

1.5 million ntl customers in the uk for starters, as well as many companies and other ISP's.I was not putting your hack down, so there is no need to be nasty about it. The reason I asked is because it seemed to be a contradiction, which confused me, and I wanted to understand how this great hack worked. When I install a modification on a board I like to try to understand how it works, rather than letting the "magic" of vb do the work. Thanks again for sharing your work.

[Paul M]

I was not putting your hack down, so there is no need to be nasty about it. There was no intention to be nasty, I'm sorry if you took it that way - I simply answered your questions. :)

[yoyoyoyo]

There was no intention to be nasty, I'm sorry if you took it that way - I simply answered your questions. :)In that case I apologize for taking it that way.

Can you explain which variable the http is passed through to check if it is a proxy IP? Is it simply checking the IP against the x-originating IP address, or is it doing something else as well?

[Paul M]

Proxy servers pass the originating ip in a variety of ways depending on the software they run (is there a standard I wonder ?). The most common ones are X_FORWARDED_FOR & CLIENT_IP. The hack checks these (and others) for a vailid IP address.

[yoyoyoyo]

Proxy servers pass the originating ip in a variety of ways depending on the software they run (is there a standard I wonder ?). The most common ones are X_FORWARDED_FOR & CLIENT_IP. The hack checks these (and others) for a vailid IP address.cool- thanks for the info. What are some of the "others"?

[CP,]

This seems like a very good hack, ive installed other hacks, but this one seems a little hard onto following some of the steps, im stuck at the second step already, anybody have or maybe got an easier translation for a newbie like me?? So i can follow clear instructions and details??

[bjs144]

Works really well.

Thanks again Paul.

[chriswible]

Great idea, great hack. Functionality is perfect.

Of course, it took a bit of modding to make this work with the "extra IP info" hack, but I managed. :p (I realize someone's probably done it already.)

[Zephyrus]

Hmm, I installed the extra IP info hack, and I don't know if it'll work with this, care to add me on MSN or AIM or YIM to teach me? Anyone?

Anyone will do.
MSN: szehan80@hotmail
AIM: szehan72
YIM: szehan72

[Paul M]

Hmm, I installed the extra IP info hack, and I don't know if it'll work with this, care to add me on MSN or AIM or YIM to teach me? Anyone?
As far as functionality is concerned they will work fine, they do not intefere with each other. The only clash is the displayiing of the icon via postbit_ip template. One suggested solution to this is here (https://vborg.vbsupport.ru/showthread.php?p=586395#post586395).


Another solution, that I e-mailed to someone the other week, is to do this ;

Follow the proxy-to-real instructions and replace postbit_ip - ignore the ipinfo instructions that mention this template. Then in postbit template (or postbit_legacy if you use it)

Find ;

<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
Add this below ;

<tr><td class="vbmenu_option"><a href="ipinfo.php?$session[sessionurl]p=$post[postid]" target='_blank' >Display IP Information</a></td></tr>

After doing this you should be able to view the ip information for any post like this ;

Click on the posters name - this should display the DHTML list of options, at the bottom of the list (under "Add xxxx to Your Buddy List") should be "Display IP Information" - simply click on it.

[Zephyrus]

Theres another way, I just figured it out:
at step 3, theres this code, and..


<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>
<else />
After this..
<a href="postings.php?$session[sessionurl]do=getip&amp;p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
</else></if>
</if>
I'll replace it with the code that ipinfo tells me to

Find:
<a href="postings.php?$session[sessionurl]do=getip&amp;p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>

Replace with:
<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>


This way, I'll see the ipinfo when a proxy is not detected, but when a proxy is detected, the "red ipp.gif" icon appears and I'll see the proxy info, hmm its probably all good. =)

[Paul M]

Like anything, there is usually more than one way to do something. :)

[Zephyrus]

Well, theres something I want to enquire about. The older posts, before I installed the proxy to real ip hack, is there anyway to make them detect the proxy and change it into the real ip? Because I've gotten the hack to work, and it detects perfectly, but only new posts after the installation were detected, older posts will still show the proxies.

[Paul M]

Well, theres something I want to enquire about. The older posts, before I installed the proxy to real ip hack, is there anyway to make them detect the proxy and change it into the real ip? Because I've gotten the hack to work, and it detects perfectly, but only new posts after the installation were detected, older posts will still show the proxies.No, the ip can only be detected at the time, not after the event.

[bhxtyrant]

Hey guys,I am majorly interested in this hack as i have had problems with spammers using the proxy trick to bypass bans.Can anyone confirm that this hack will work with vB 3.0.7? thanks alot :)

[Abe1]

Hey guys,I am majorly interested in this hack as i have had problems with spammers using the proxy trick to bypass bans.Can anyone confirm that this hack will work with vB 3.0.7? thanks alot :)

I used it and it worked.

[bhxtyrant]

Thanks for the reply.I have one question.I am about to install this mod on my forums but when reading the instructions it's fairly vague so just wanted to make sure of something.

Step 1.

Run the following SQL code;

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

(Note: if you use table prefixes then remember to change "post" to the correct table name).


Step 2.

Add the following phrase "thread_displayproxyip" (as a Front End Error Phrase, not a Global Phrase) ;

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

Step 2 is also something i have to add to MYSQL?or is it something i have to add to one of vB's templates?I've used PHPmyadmin pleanty of times but i'm not 100% fluent with it.so just don't want to make any mistakes :)

[MickDoneDee]

Step 2 is also something i have to add to MYSQL?or is it something i have to add to one of vB's templates?I've used PHPmyadmin pleanty of times but i'm not 100% fluent with it.so just don't want to make any mistakes :)Go to your Phrase Manager in the Admin contol panel. In the Phrase Manager select Phrase Type: Front-End Redirect Messages. Click Add New Phrase.
Paste thread_displayproxyip in the Varname text box.

Paste:

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

in the Text text box. Click Save.

[bhxtyrant]

Ah ok,thanks alot for the explanation MickDoneDee :)

[osariase]

ok I have a problem serious one nobody can open or respond to a thread on the site everytime u click on post or reply u get this error message below:

Parse error: parse error, unexpected $ in /home/naijawor/public_html/includes/functions_newpost.php on line 1268

can someone please help thanks

[Paul M]

You have made a mistake in either step 4 or step 5.

Start with an unhacked copy of functions_newpost and redo those steps.

[osariase]

that was quick response thanks man i'm checking that now I will let you know please stand by, I appreciate it

[osariase]

Ok paul that seem to have fixed the problem and after redoing the steps i didnt get any error messages. So now my next question is how do I test it?

thanks for supporting this

[Paul M]

Ok paul that seem to have fixed the problem and after redoing the steps i didnt get any error messages. So now my next question is how do I test it?

thanks for supporting thisYou click on install, then provide me a test login - and I post for you - my isp (ntl) use proxy servers.

[osariase]

well paul,
I am sorry to have given false info, after I did that I didnt check to see if I can post. my user's have been trying to post all day and they couldnt I just found out so I removed the old functions_newpost.php and put a fresh one there and it fixed it. if it is possible can u please give me the codes again i mean the one that have worked for you. I run vb3 3.07

thanks

[osariase]

ok below is the error message I or members of my forum gets when the click on submit reply

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO nwvb3post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, proxyip, iconid, visible, attach, useragent, altip)
VALUES
(104, 1576, 'Re: Comebacks and Insults for Women.',
'Teckno', 1, 1128116581,
'this is a test', 1, 1,
'xx.xxx.xxx.xx','', 0, 1, 0,
'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)', 'xx.xxx.xxx.xx')

mysql error: Unknown column 'useragent' in 'field list'

mysql error number: 1054

Can u please tell me what is going on thanks

[Paul M]

You have modified the sql in functions_newpost to insert a field called 'useragent' in each post - there is no such field in the standard post table. There is also no such field in this hack - so it's obviously some other hack you have installed.

[Paul M]

if it is possible can u please give me the codes again i mean the one that have worked for you. I run vb3 3.07Sorry, I don't understand what you are asking, what codes ?

[osariase]

Sorry to bother you again PaulM,
I went and did it again, now I get this error message below

Parse error: parse error, unexpected T_ELSE in /home/naijawor/public_html/includes/init.php on line 283

So i checked the line 283 it is an else statement like this below,
}
else
{

but when I comment this line out I dont that above error is it supposed to be like this? or is there something i'm doing wrong, please assist thanks

[Paul M]

Well then I guess you need to check/redo the changes in this file (step 7).

[bhxtyrant]

Hey guys,I just installed this mod and seem to be having what looks like some issues.

After installing i tryed purposly using a proxy IP address to see how well the mod works.It detected the proxy but doesnt seem to work.I can not see my real IP.I also got a freind to give it a try and i still could only see there proxy IP.I also notice the little ipp.gif icon doesnt show up.Is this normal?or am i maissing something :(

Im using vB 3.0.7

[Paul M]

Quite simply, it's not detecting the proxy you are using, what makes you think it is ?

JFYI, Proxy servers can only be detected if they pass on certain http variables, many do not.

[bhxtyrant]

Ah ok,I was under the impression that when ever someone using a proxy server would view the forums and post the ipp icon would appear to let you know.Thanks for the informationthough.So do you know of any free Proxy that does pass the required http variables so i can test the mos to make sure it's working correctly :)?

[Paul M]

Sorry, I don't.

If you supply me a username/password/url for your forum I will post a test post, my isp uses proxies that do pass on the client ip.

[vbcia]

How would I go about uninstalling this? It's not a bad hack, it's just that I seem to be having issues with some of my AOL users. I'm not blaming this hack at all, but I'm just going to uninstall anything I can to see what fixes the issues.

[Paul M]

How would I go about uninstalling this? It's not a bad hack, it's just that I seem to be having issues with some of my AOL users. I'm not blaming this hack at all, but I'm just going to uninstall anything I can to see what fixes the issues.Allthough it was tempting, there is nothing in this to upset AOLiens. Uninstall is the reverse of install - reverse the instructions.

[MRGTB]

I installed this, and then went to a well know FREE WEB PROXY and used it to posts on my site. Seems even this was able to bypass this hack here:

http://www.guardster.com/subscription/proxy_free.php

If your on NTL Paul do me a favour and test my site as I know NTL uses proxy. You don't need an account as guest can post on the Asylum board

[Paul M]

I installed this, and then went to a well know FREE WEB PROXY and used it to posts on my site. Seems even this was able to bypass this hack here:

http://www.guardster.com/subscription/proxy_free.php

If your on NTL Paul do me a favour and test my site as I know NTL uses proxy. You don't need an account as guest can post on the Asylum boardMost free proxy's are deliberately annonymous, so they will bypass this. I will post on your forum shortly.

Edit: Well atually I won't post as I can't - even in the Asylum I get a no permission screen.

Edit of the Edit: Oh, it seems I can't post replies, only a new topic - that's bizarre .....

[Drifter Jet]

That's because he has onlyl certain permissions for the members set up..or something like that.

[MRGTB]

Most free proxy's are deliberately annonymous, so they will bypass this. I will post on your forum shortly.

Edit: Well atually I won't post as I can't - even in the Asylum I get a no permission screen.

Edit of the Edit: Oh, it seems I can't post replies, only a new topic - that's bizarre .....

Thats the way I have it setup so Guests can make new posts, you should have been able to reply to others on that board, but not reply to yourself asa guest. I'll double check that.

[MRGTB]

I created an animated version of the ipp image to suit the default one if you want it

[Paul M]

Nice.

[RFViet]

Does it work on vB 3.5.2 ????

[Paul M]

Does it work on vB 3.5.2 ????https://vborg.vbsupport.ru/showthread.php?s=&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]

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.