vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - vbStopForumSpam - known spammer lookup for new registrations (https://vborg.vbsupport.ru/showthread.php?t=176481)

Embroidables 08-07-2008 06:51 AM

Pedigree,

Check your inbox. I just PMed you my access key.

pedigree 08-07-2008 02:55 PM

... and with that, the code is going back in for testing, thanks Embroidables!!!

pedigree 08-07-2008 08:01 PM

haha, just got a page of emails from them for my account confirmation, hehe

Embroidables 08-07-2008 08:26 PM

cool... it sounds like they finally got their sign up fixed.

BadgerDog 08-27-2008 10:22 AM

Thought I'd report a database error received when trying to sort on IP address ... :)

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT * FROM vbstopforumspam_log AS logs

ORDER BY ip ASC, date DESC
LIMIT 0, 30;

MySQL Error : Unknown column 'ip' in 'order clause'
Error Number : 1054
Date : Wednesday, August 27th 2008 @ 07:18:22 AM
Script : http://www.xxxx.com/admincp/vbstopfo...erby=ip&page=1
Referrer : http://www.xxxx.com/admincp/vbstopfo...y=email&page=1
IP Address : xx.xx.xx.xx
Username : Badger
Classname : vB_Database
Regards,
Badger

skippybosco 08-27-2008 10:33 AM

Good find. I can confirm that I also see this error when sorting VBStopFormLog by IP. (vb3.6.11 running VBSFS .61)

pedigree 08-28-2008 11:25 AM

yeah, it was reported a couple of pages back and its been fixed. Im just trying to find a spare minute in the week to do some more work on it. A newborn, 6 hours/day travel and a kid in the terrible "twos"

Good to see youre on the ball though :)

The wife and the kids are in London tomorrow, leaving me at home without too much work on... I hope to get some code done

pedigree 08-29-2008 10:34 AM

If you go to line 62 in admincp/vbstopforumspam.php and change

$order = 'ip ASC, date DESC';

to

$order = 'ipaddress ASC, date DESC';

then that will fix that error

RedeemedWarrior 08-31-2008 05:09 AM

one of the Best modifcation on the site, its saved me no end of work

over 400 spammers in 48 hours have been stopped

pedigree 08-31-2008 11:51 AM

Quote:

Originally Posted by RedeemedWarrior (Post 1610980)
one of the Best modifcation on the site, its saved me no end of work

over 400 spammers in 48 hours have been stopped

Thanks for the feedback :)

Glad to help. Hopefully, 0.7 will be even better.


All times are GMT. The time now is 06:32 PM.

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.01908 seconds
  • Memory Usage 1,735KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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