vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Prevent Doubleposting (https://vborg.vbsupport.ru/showthread.php?t=96602)

Pathor 06-09-2006 06:12 PM

Xenon is gone. :( I hope anybody else can fix it.
Maybe a new Hook?

Quote:

Originally Posted by Kier
While there have not been extensive changes to the underlying architecture of vBulletin 3.6 from 3.5, it is possible that certain hooks may have changed.


Smiry Kin's 06-10-2006 07:05 PM

can some one please tell me what to use? lol theres just so many codes/files..

i want one that auto freshes ajax. n maybe displays time that it was added!

Wordplay 06-29-2006 05:41 AM

i've got it worst, on 3.6 beta 3. when i double post, i get a database error, but the double-post is still made. has anybody got it to work on 3.6 yet?

VBUsers 06-29-2006 07:34 AM

can a coder take this over and make it for 3.6 beta 3? its a must have for so many admins.

Keyser S?ze 06-29-2006 08:30 AM

this is a really nice hack, ill tell ya what i would like if someone could make this for me to put in the expert part, i want it so it does not count for s. mods and admins, also i have it set so it prevents it for the first 72 hours without bumping, i would like it to be after 72 hours and until say forever ;p it prevents it but also bumps the thread

think anyone could do that for me? thanks

Yorixz 06-30-2006 09:44 AM

Quote:

Originally Posted by Boofo
Well, what doesn't work in it? An error or something might give us a little better idea on what to do to fix it.

Code:

Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

              SELECT post.*
              FROM vb3_post AS post
              LEFT JOIN vb3_deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
              WHERE threadid = 47971
                      AND dateline > 1151567543
                      AND visible = 1 AND deletionlog.primaryid IS NULL
                      AND postid <> 409299
              ORDER BY dateline DESC
              LIMIT 1;

MySQL Error  : Column 'dateline' in where clause is ambiguous

I'm getting that error quite often, didn't manage to reproduce it but I suppose theres something wrong in the query it's using.

Keyser S?ze 06-30-2006 01:56 PM

something else i would like to add is in the add part, make it give someone a warning with inferno warning system for the double post, if done in the first say 72 hours

Stoebi 06-30-2006 03:20 PM

Hi

Plugin 'Main Doublepost Prevent Engine' - Hook newpost_complete


Search for:
Code:

AND dateline > " . (TIMENOW - $vbulletin->options['xen_dp_timespan'] * 60) . "
Change to:
Code:

AND post.dateline > " . (TIMENOW - $vbulletin->options['xen_dp_timespan'] * 60) . "

Reason:
With vBulletin v3.6.x the row dateline exists in the tables post and deletionlog (ambiguous).



Regards, Stoebi

Quote:

Originally Posted by Yorixz
Code:

Database error in vBulletin 3.6.0 Beta 3:

Invalid SQL:

              SELECT post.*
              FROM vb3_post AS post
              LEFT JOIN vb3_deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
              WHERE threadid = 47971
                      AND dateline > 1151567543
                      AND visible = 1 AND deletionlog.primaryid IS NULL
                      AND postid <> 409299
              ORDER BY dateline DESC
              LIMIT 1;

MySQL Error  : Column 'dateline' in where clause is ambiguous

I'm getting that error quite often, didn't manage to reproduce it but I suppose theres something wrong in the query it's using.


Wifey 07-01-2006 11:56 PM

Is there a code to exclude a certain forum from this in the additional options box? Also, what would the code be to exclude moderators from this?

Thanks!

Wordplay 07-03-2006 09:44 PM

Stoebi thanks for updating that, but it created a new error for letters such as ü ä ö dont show up now when people quickedit their threads in translates them to ü codes. like ü becomes ü but not when posting a new thread, or a comment, or submitting advanced editings only when submitting quick edits.


All times are GMT. The time now is 10:04 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.01853 seconds
  • Memory Usage 1,746KB
  • 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
  • (4)bbcode_code_printable
  • (3)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