vb.org Archive
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Template Modifications (https://vborg.vbsupport.ru/forumdisplay.php?f=139)
-   -   [release] Spambot Protection (https://vborg.vbsupport.ru/showthread.php?t=86544)

filburt1 03-10-2003 01:30 AM
Arg, I'm an idiot...download and upgrade PAPI again.

jrotunda85 03-10-2003 01:40 AM
Still getting it.....here's the "new" copy:


Quote:
<html><head><title>Senate Sim Version 3.0 Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

<!-- Database error in vBulletin 2.3.0:

Invalid SQL: SELECT
IF(COUNT(postidid) >= 6, 6, COUNT(postid))
FROM post WHERE userid = 12
AND dateline > UNIX_TIMESTAMP() - 30
mysql error: Unknown column 'postidid' in 'field list'

mysql error number: 1054

Date: Sunday 09th of March 2003 08:35:57 PM
Script: http://www.senatesim.com/testvb/testvb/index.php?
Referer: http://www.senatesim.com/testvb/index.php?
-->

</table></td></tr></table></form>
<blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the Senate Sim Version 3.0 database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:support@senatesim.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>

filburt1 03-10-2003 01:47 AM
You know the drill...;)

Remember I wrote this at 2 AM, unlike HelperBot which was a respectable 8 PM ;) :D

jrotunda85 03-10-2003 01:51 AM
Um, your attachment is missing on the PAPI thread ;).

filburt1 03-10-2003 01:53 AM
Odd :confused: It's back.

jrotunda85 03-10-2003 02:04 AM
Filburt,

Since updating the new PAPI page, it is working. My settings were to close the thread and delete the replies after 6 posts in 30 seconds. While it did work, it did it after 4 replies (total 5 posts), so I am not sure if there is a greater then or something sign messed up.

I have posted some screenshots, you may use them if you wish :).

Note: I called my drone guy 'spammerbot' so don't get confused ;).

filburt1 03-10-2003 02:06 AM
Try setting it up to only do stuff with threads or replies, but not both.

jrotunda85 03-10-2003 02:15 AM
Ok, I did it to hide the replies when it hits 6. As I was posting my 6th time all the replies were hiddden so I didn't see the 6th post. I assume this is how it works. :confused:

filburt1 03-10-2003 02:17 AM
The concurrent deletion is tricky because (I think) a new thread counts as a new reply as well. Therefore two threads and two replies might count as six and then kick in.

jrotunda85 03-10-2003 02:19 AM
I defintely believe that the new thread counts as part of the "new replies." If it doesn't then it has a bug because it is one short everytime, as far as "replies" goes.

Let me know, I will test new stuff out on my test board if you wish :).


All times are GMT. The time now is 06:00 AM.
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

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.01124 seconds
  • Memory Usage 1,731KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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