vb.org Archive - Administrative and Maintenance Tools - Troll/ip-tracker, detect multiple accounts/trolls [3.6 compatible]

Page 4 of 12

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

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

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - Troll/ip-tracker, detect multiple accounts/trolls [3.6 compatible] (https://vborg.vbsupport.ru/showthread.php?t=119695)

TMM-TT

07-17-2006 08:18 PM

Quote:

Originally Posted by kofoid

I'm getting this error :(

Invalid SQL:
SHOW COLUMNS FROM Yadauser_troll WHERE field != 'username';

The problem seem to start when this row executes from iptracker.php:

PHP Code:


		
			
$columns = $vbulletin->db->query("SHOW COLUMNS FROM " . TABLE_PREFIX . "user_troll WHERE field != '$q_t'");

I have a strange feeling that this is a mysql-issue where SHOW-commands isn't allowed (confirmable?). I'm not so good in such errors so this is just a wild guess and I should see if I can change this in the code.

geppeto, I'll get back to you. :)
I got the same error before, but that time I fixed that part.

MThornback

07-17-2006 08:21 PM

Code:

Database error in vBulletin 3.5.4:



Invalid SQL:

SHOW COLUMNS FROM vb3_user_troll WHERE field != 'username';



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 'WHERE field != 'username'' at line 1

Error Number : 1064

Date         : Monday, July 17th 2006 @ 04:20:33 PM

Script       : /forum/iptracker.php?q=Marines101&q_t=username&resolver=true&Submit=Ask

Referrer     : /forum/iptracker.php

Username     : MThornback

Classname    : vb_database

Release looks really promising :) hope you can get the kins worked out :)

aveon

07-18-2006 04:12 PM

i cant ewen search for the ip adresses when i type an user name it says 0 user name but there is a member on this name what im i doing wrong can you help me

kofoid

07-18-2006 06:14 PM

thx tmm

MThornback

07-19-2006 09:46 AM

If the wife and I both try and access my forum...she gets blocked out of the site cause shes not an admin...and she gets an SQL error...

TMM-TT

07-19-2006 08:29 PM

A small fix for iptracker.php, in version 2.0.4

Hopefully the problem with SHOW COLUMNS is fixed here (replaced with an array instead). I've also added the file in the release at the top, if someone misses this post.

Debugging for selfchecking is added, but only for admins. Calling iptracker.php with those parameters should therefore work: ?self=1&selftest=<ip>&selfuser=<username>

Also known as "What the user see in the selfcheck"-debugging.

FQDN-checking in the selfchecker is also removed. The FQDN lookup should only be available for the tracking.

Quote:

Originally Posted by MThornback

If the wife and I both try and access my forum...she gets blocked out of the site cause shes not an admin...and she gets an SQL error...

I think it's time to add that exclude-list I have planned. :)

By the way, you can turn off the function that automatically blocks all users with more than X nicknames (attached screenie).

TMM-TT

07-20-2006 10:22 PM

Quote:

Invalid SQL:
SHOW COLUMNS FROM vb3_user_troll WHERE field != 'username';

Did I get rid of this problem after the upgrade of iptracker.php? :)

sduckie2k5

07-21-2006 08:35 PM

I use quick account switch and it detected me as a troll. How do I delete my entry in the log?

TMM-TT

07-22-2006 01:08 AM

Quote:

Originally Posted by sduckie2k5

I use quick account switch and it detected me as a troll. How do I delete my entry in the log?

Do a lookup on your nickname and mark yourself in the checkbox in the list of usernames. Then choose to delete yourself. In the configuration from admincp, you can decide if the removal from the list should be hard or soft.

sduckie2k5

07-22-2006 01:26 AM

to be a bother but I uninstalled the hack, the reinstalled it and tried again, this time, I am not marked as a troll but I still cant seem to get the same view you have in your screenshot with the delete button. I appear to be in the right area but theres missing text next to one of the check boxes and I cant delete even if I select the names then press the button. What am I doing wrong, it almost looks like part of the old version is still left behind? Thankyou in advance

All times are GMT. The time now is 09:29 PM.

Page 4 of 12

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01453 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 (1)bbcode_code_printable (1)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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: