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!

You're welcome. :classic:

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?

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

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?

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

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

Update: I've done some further research and found that vB2 did not support table prefixes but vB3+ does. This quote from vB.com:
http://www.vbulletin.com/forum/showthread.php?t=130708

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

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.

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.

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.

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;

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.

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

What are you asking?

Erm, what icon ? - This hack does not add any icons to the WOL display :confused:

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

Instructions say to find this:
My functions_newpost.php says this:

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.

You must have added a hack at some point ;

Replace the code with this and it should be ok ;

Thank you bunches Paul!

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.

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

I will answer you with a quote.

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

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.

Quote:

Originally Posted by corriewf 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 .......

http://www.w3bdevil.com/forums/Under...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.

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

OK. Thanks. I'll check and let you know if I have a problem.

Guess you did something wrong then..

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

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

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

What problem did you have ?

Do you mind posting the code integration?

Oh nothing major. It's just that Xenon's hack edit is inserted between 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. :)

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.

Ah, I see what you mean, I'll remove that line from the instructions, then they will match in either case.