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.

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.

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

Ah ok,thanks alot for the explanation MickDoneDee :)

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

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

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

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

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

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

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

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

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.

Sorry, I don't understand what you are asking, what codes ?

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

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

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

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.

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 :)?

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.

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.

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

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

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

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.

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

Nice.

Does it work on vB 3.5.2 ????

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.

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.

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.

Thank you sir very much. Well explained.