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)

Paul M 11-17-2004 09:20 PM

Quote:

Originally Posted by Harry Bo
Paul, do you know if this hack works with NTL's UK proxy servers? I administrate a fairly large vB and we can end up with 20+ users in the same city on one proxy :)

If it works with NTL, I'll be installing soon :)

Cheers,

HB

Harry Bo - Check the sig - we are primarily an ntl user site - it was written with their transparant caches in mind. :)

I see you are not far from me - what is your site ?

Harry Bo 11-17-2004 09:26 PM

I visited your site shortly after posting, I figured it would probably work then, lol :)

I'm here from www.talkaudio.co.uk, the UK's biggest Car Audio Forum :)

HB

mtha 11-18-2004 07:28 PM

Quote:

This is a simple modification I did for our forum that is based on the existing Proxy Detector Hack (v3.0). Obviously, like all proxy server detection hacks, this will only work if the proxy server passes the appropiate http variables.
well, just wondering if you should state the credit to Takara for his original work and a link to Proxy Detector Hack (v3.1)

thanks :)

Paul M 11-18-2004 08:40 PM

Quote:

Originally Posted by mtha
well, just wondering if you should state the credit to Takara for his original work and a link to Proxy Detector Hack (v3.1)

thanks :)

Maybe you should read the installation notes ......
Quote:

This is partly based on the Proxy Detector v3.0 hack by "HacNho/Takara/Stadler".
:glasses:

rh2004 12-05-2004 08:37 PM

Hi I get 'Could not find phrase 'thread_displayproxyip'.' and it is added, I also have
the IPINFO added..

Add the following phrase "thread_displayproxyip" ;

GLOBAL

Real IP Address : $postinfo[ipaddress]<br>
$postinfo[hostaddress]<br>
Proxy Server IP Address : $postinfo[proxyip]<br>
$postinfo[proxyhost]


This is my postbit..

Code:


<if condition="$show['ip']">
$vbphrase[ip]: $post[ip]
<else />
<if condition="($post[proxyip] != '')">
<a href="postings.php?$session[sessionurl]do=getip&amp;p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ipp.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
<a href="ipinfo.php?$session[sessionurl]p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
<else />
<a href="ipinfo.php?$session[sessionurl]p=$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/ip.gif" alt="$vbphrase[ip]" title="$post[ip]" border="0" /></a>
</else></if>
</if>

It should show me two IP buttons if using a proxy if a normal user no proxy
should give me just one button, now the buttons work its just when you
click on a proxy IP it gives you the above error...


EDIT I fixed it sorry I read through maybe you should place in the readme its Front-End Error



So my only question is can I show the proxy button if only admin, not mods or super mods

Paul M 12-05-2004 09:28 PM

Quote:

Originally Posted by rh2004
EDIT I fixed it sorry I read through maybe you should place in the readme its Front-End Error

It's never been mentioned before, but I'll update the instructions when I have time.

Quote:

Originally Posted by rh2004
So my only question is can I show the proxy button if only admin, not mods or super mods

Just enclose it in a test for usergroup == 6. I would check the logic in you postbit code though - I can't make sense of it, I don't see how it actually works .....

rh2004 12-13-2004 10:11 PM

Ok thanks for that... I have noticed an error which has arrised I think its
to do with this mod, I receive this a few times a day around 2-3


Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext,
allowsmilie,
showsignature, ipaddress, proxyip, iconid, visible, attach)
VALUES
(10154, , '',
'BlackbirdDJ', 2696, 1102976866,
'cheers', 1, 0,
'81.--,'', 0, 1, 0)

mysql error: You have an error in your SQL syntax.  Check the manual
that corresponds to your MySQL server version for the right syntax to use
near ' '',
'BlackbirdDJ', 2696, 1102976866,
'cheers', 1, 0,

mysql error number: 1064

Date: Monday 13th of December 2004 10:27:46 PM
Script: http://--/forum/newreply.php
Referer: http://--/showthread.php?t=10154
Username: BlackbirdDJ
IP Address: --


I have these mods added:

Who Viewed This Thread - Enhanced Version
Advanced Editing Options For Mods & Admins
Reoccurring Paypal Subscriptions
Email notification if someone attempts to access your Admin CP
BB Messenger 1.5
ipInfo -- Extra user IP information
Proxy ip to real ip conversion
V3acade
uCash & uShop
modmanagementv1
vBSigHosting
Whos online in admin
statistik_english2
Advanced Warning System (AWS)
Hide
vB Report Manager 2.0 (Admin CP) - Report to Email, PM, Forum



(PS: I removed the IP of the user, and URL - also note its off different users too)


Do you know whats wrong :ermm:

MickDoneDee 12-14-2004 12:05 PM

I can see the syntax error: there is no parentid value. However, I don't know which file is making that query. When the file is found you'll be able to fix the query.

Try searching all your files for this text string:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "post

I searched my files and couldn't find it so I don't think it's related to this hack.

Paul M 12-14-2004 06:02 PM

There is also an error here

'BlackbirdDJ', 2696, 1102976866,
'cheers', 1, 0,
'81.--,'', 0, 1, 0)

But since you have edited the error message it's impossible to tell if it's a real error. If you want any more help you must post the actual error message, not an edited version.

rh2004 12-15-2004 12:38 AM

Here is the message as it is displayed, I have just repalced the IP

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                        INSERT INTO post
                                (threadid, parentid, title, username, userid, dateline, pagetext,
allowsmilie,
                                showsignature, ipaddress, proxyip, iconid, visible, attach)
                        VALUES
                                (2463, , '',
                                'luciosestio', 2762, 1103012553,
                                'Grazie !', 1, 0,
                                '127.3.192.6','213.175.2.50', 0, 1, 0)
               
mysql error: You have an error in your SQL syntax.  Check the manual
that corresponds to your MySQL server version for the right syntax to use
near ' '',
                                'luciosestio', 2762, 1103012553,
                                'Grazie !', 1,

mysql error number: 1064

Date: Tuesday 14th of December 2004 08:22:33 AM
Script: http://www.mydomain.com/forum/newreply.php
Referer: http://www.mydomain.com/forum/showthread.php?t=2463
Username: luciosestio
IP Address: 127.3.192.6


Also any idea on where about this will be, in included folder?

DB_site->query("INSERT INTO " . TABLE_PREFIX . "post



Thanks


All times are GMT. The time now is 01:37 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.01314 seconds
  • Memory Usage 1,757KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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