Proxy Hack v1.0

Ooook,

Well, this hack is a little thing to give you vB admins and moderators some more information about the users using proxys on your board (mainly, thier IP address).

The following version is upto date and works with vb 2.2.8 and whatever else. This version was updated by Stadler to work with 2.2.8. I cannot provide support personally for ANY versions here. And I do not know what support Stadler can give you.

So, download the 2.2.8 update here

----------------

Everything below has to do with super old versions that don't matter.. because they are super old! You don't want them, so don't even read it!


STOP READING! hehe, anyway. I repeat:

VERSION 2.2.8 ABOVE ^
VERSION 2.2.5 BELOW

enjoy

--------------

Screenshots are in the posts to follow.

Let me know how you like it, or ways I could improve it. ^_^ :bunny:

Edit: Non intrusive version
This little edit simply adds the proxy info to the getip template. So when mods/admins click the "IP Logged" button/graphic if there is any proxy info, it will tell them instead of in postbit.

Get it here

Attachment: Non Intrusive Version Screenshot

Normal, version:

[PurpleCow]

I have the same problem with ver2.3.0.

anyone have a solution for us running vB ver2.3.0 !

Thanks much

Yesterday at 07:22 AM AViO 07 said this in Post #135
This hack doesn't work with vb2.3.0 i cant see nothing on the postbit or anywhere else.

[mtha]

03-28-03 at 10:17 AM HostBubble said this in Post #136
I have the same problem with ver2.3.0.

anyone have a solution for us running vB ver2.3.0 !

Thanks much

It works fine for me, 2.3.0

[Keyser S?ze]

this hack is very helpful, question is, can it work in 2.3.0, will find out soon, also does this link up with the vb-ban system, so it will keep ppl banned that use a proxie?

[Disturbed]

did you guys try the file Stadler posted?

i think it works

[Joe Mac]

I have 2.3 and it didn't work for me either. I used the non intrusive version.

[PurpleCow]

Can I get the Stadler's version of this hack posted in the first post to work on ver 2.3.0 ?? B'cos Stadlers help file says specifically for 2.2.8 and 2.2.9 !!

Anyone got it working fine on 2.3.0 ??

Thanks

[Stadler]

Tried locally with 2.3.0.

The hack worked find for me without any changes.

Did you read Post #114

[PurpleCow]

Okay, just finished installing ProxyDetect on my stable release of ver2.3.0.

It works like a charm, without any problems.

However, i wonder, if the Host names of the proxies are resolved correctly ??

Thanks soo much for the Hack !

Cheers

/me clicks installed now

[Blizzb]

### Run the Following SQL Query

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

This is the first instruction for installing this. But I don't understand and I don't know what to do. Can anyone help me?

[Blizzb]

Someone help me!

[MaDCaT75]

I'd install it but I dont have enough users yet :cry:

[Blizzb]

### Run the Following SQL Query

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

How do you do this?

[tanhadil]

Im getting this error on this hack(below),
it does submit the thread but no posting was there and its empty

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,proxyip,iconid,visible) VALUES (NULL,'5','lml;lk','administrator','1','1063838498 ','0','ljklk','1','0','63.70.211.103','','0' ,'1','3')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

[Stadler]

In both newthread.php and newreply.php there should be a line, that begins with

PHP Code:

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext, 


Could you post both occurrences here (one in newthread.php and one in newreply.php), so I can look, what went wrong?

[Stadler]

Originally Posted by Me!

go into your PHP myadmin click on "SQL" tab then in the empty box that you can type in place

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

in the box and hit the submit button. That will alter the table for you.

Sorry, I haven't updated the file so far. The Query should be

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

To change this from VARCHAR(16) to VARCHAR(50) run the following query:

ALTER TABLE post CHANGE proxyip proxyip VARCHAR(50) NOT NULL