vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Proxy ip to real ip conversion (https://vborg.vbsupport.ru/showthread.php?t=69295)

David Bott 02-16-2005 10:24 AM

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 02-16-2005 10:38 AM

Quote:

Originally Posted by David Bott
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 02-16-2005 11:05 AM

Thanks for the help in this. It should help.

VBUsers 02-26-2005 05:57 AM

i got this when i tried to run the SQL query

PHP Code:

SQL-query

ALTER TABLE post ADD proxyip VARCHAR50 NOT NULL AFTER ipaddress 
MySQL said
:  

#1146 - Table 'smoralo_forum.post' doesn't exist 


why??? can you help?

MickDoneDee 02-26-2005 07:52 AM

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 02-26-2005 08:04 AM

Quote:

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


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 02-26-2005 08:14 AM

Quote:

Originally Posted by lowandloudinc
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

Code:

ALTER TABLE smoralo_forum_post ADD proxyip VARCHAR(50) NOT NULL AFTER ipaddress;

MickDoneDee 02-26-2005 08:18 AM

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 02-26-2005 08:18 AM

Quote:

Originally Posted by Delphiprogrammi
people,

you are both wrong see the error MySQL is telling you

#1146 - Table 'smoralo_forum.post' doesn't exist

the korrect query becomes

Code:

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 02-26-2005 08:24 AM

Quote:

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


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01251 seconds
  • Memory Usage 1,745KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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