vb.org Archive - Proxy Hack v1.0

Page 15 of 16

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Proxy Hack v1.0 (https://vborg.vbsupport.ru/showthread.php?t=38358)

PurpleCow

08-04-2003 04:24 AM

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

08-04-2003 10:50 AM

Tried locally with 2.3.0.

The hack worked find for me without any changes.

Did you read Post #114

PurpleCow

08-04-2003 01:22 PM

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

08-22-2003 02:39 PM

Quote:

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

09-03-2003 11:31 PM

Someone help me!

MaDCaT75

09-04-2003 02:13 AM

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

Blizzb

09-06-2003 10:06 PM

Quote:

### Run the Following SQL Query

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

How do you do this?

tanhadil

09-17-2003 09:41 PM

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:cool:','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

09-17-2003 11:17 PM

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

09-17-2003 11:23 PM

Quote:

Originally Posted by Me!

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

Code:

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

Code:

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

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

Code:

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

All times are GMT. The time now is 04:53 AM.

Page 15 of 16

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01131 seconds Memory Usage 1,738KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: