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)

SpanishHarlem 09-17-2006 05:09 AM

Hi we have 3.6.1 and have did the last xml file and we still get

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT COUNT(postid) AS count
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE visible = 0 AND dateline > 1155567293
AND deletionlog.primaryid IS NULL;

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

only way to fix is tuen off plugins. I have triedto uninstall the Product and turn plugins back on and we still get that dateline err please help!

Thankyou in advance

SpanishHarlem 09-17-2006 05:42 AM

::resolved::

we uninsralled some other hacks and it works! Ajax and Dble Post mods are enabled!

Thankyou, the fix in other post was a lifesaver!!!

Snake 09-17-2006 07:34 AM

Thank you for the fix! :)

mtha 09-27-2006 06:28 AM

Quote:

Originally Posted by rmxs
Here its the product For 3.6.x!

Info about HOW TO exclude usergroups from Double Posting!


Vb Settings - Doublepost Preventing - Additional Condition (experts only)

And Add
Code:

!in_array($vbulletin->userinfo['usergroupid'], array(5,6,7))
Change 5,6,7 with user group id that you wont to exclude!

cool!
Adding this

AND strlen($post['message']) < $vbulletin->options['xen_dp_maxchars']


to Main Doublepost Prevent Engine

and xen_dp_maxchars variable to the option

in order to add maxchars condition :)

chrisvonc 10-04-2006 05:15 PM

I loved the older versions of this one. Glad to see it back!
I havent had a chance to read through all the posts here yet so maybe it was covered, but if not, is there a way to add a line break to help space the follow up posts apart?

bashy 10-04-2006 05:39 PM

Hi

Is there anyway to set it so that after a set time it does not auto merge?
Also is there a way so that it dont do this with the staff please?

chrisvonc 10-04-2006 06:52 PM

Bashy, the time limit is adjustable in the admincp > vb options > doublepost preventing > timespan

Shouzen 10-08-2006 06:36 PM

it would be coll to make so that you don't have to refresh the page to se eit.

JohnBee 10-18-2006 06:28 PM

Very odd...

I installed this hack (straight forward) ajusted the admincp settings to 60mins.
fired a few threads in a row... nothing... :(

Tried re-installing it a few times... Still no go
Very odd.


* Nevermind - I did a bunch of crap and now it works...

BANDiT600 10-21-2006 08:27 PM

Someone, make a graphic bar for post separator, please.

Domenico 11-02-2006 12:20 PM

Still no go after the fixes. We run 3.6.2 and users still need to refresh manually.

Can someone please pick this plugin up and take it to 100% functonality for 3.6+ ?

redlabour 11-10-2006 12:23 PM

Quote:

Originally Posted by rmxs
Here its the product For 3.6.x!

Info about HOW TO exclude usergroups from Double Posting!


Vb Settings - Doublepost Preventing - Additional Condition (experts only)

And Add
Code:

!in_array($vbulletin->userinfo['usergroupid'], array(5,6,7))
Change 5,6,7 with user group id that you wont to exclude!

Seem it is not longer working under 3.6.3 - let?s get it complettely updated :

Doublepost Prevention for 3.6.x

redlabour 11-11-2006 01:55 PM

It works now ! ;) But i do not know what the Error was. :/

Guest210212002 11-12-2006 12:53 PM

Quote:

Originally Posted by rmxs
Here its the product For 3.6.x!

Info about HOW TO exclude usergroups from Double Posting!


Vb Settings - Doublepost Preventing - Additional Condition (experts only)

And Add
Code:

!in_array($vbulletin->userinfo['usergroupid'], array(5,6,7))
Change 5,6,7 with user group id that you wont to exclude!

Great tip - Xenon should add this to the initial post.

beebi 11-15-2006 04:15 AM

Quote:

Originally Posted by rmxs (Post 1071823)
Here its the product For 3.6.x!

Info about HOW TO exclude usergroups from Double Posting!


Vb Settings - Doublepost Preventing - Additional Condition (experts only)

And Add
Code:

!in_array($vbulletin->userinfo['usergroupid'], array(5,6,7))
Change 5,6,7 with user group id that you wont to exclude!


????????????????????????????????????????????
what is this?
this is bad coding


to get it work fine with 3.6.x
find
PHP Code:

    // we are here, so we may have a doublepost -> do more exact checkings
    
$doublepost $vbulletin->db->query_first("
        SELECT post.*
        FROM " 
TABLE_PREFIX "post AS post
        LEFT JOIN " 
TABLE_PREFIX "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
        WHERE threadid = 
$threadinfo[threadid]
            AND dateline > " 
. (TIMENOW $vbulletin->options['xen_dp_timespan'] * 60) . "
            AND visible = 1 AND deletionlog.primaryid IS NULL
            AND postid <> 
$post[postid]
        ORDER BY dateline DESC
        LIMIT 1
    "
); 


replace it with
PHP Code:

        // we are here, so we may have a doublepost -> do more exact checkings
        
$doublepost $vbulletin->db->query_first("
                SELECT post.*
                FROM " 
TABLE_PREFIX "post AS post
                LEFT JOIN " 
TABLE_PREFIX "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
                WHERE threadid = 
$threadinfo[threadid]
                        AND post.dateline > " 
. (TIMENOW $vbulletin->options['dp_timespan'] * 60) . "
                        AND post.visible = 1 AND deletionlog.primaryid IS NULL
                        AND post.postid <> 
$post[postid]
                ORDER BY post.dateline DESC
        "
); 


Alfa1 11-20-2006 09:24 AM

This hack is installed at vb.org and causes text in html tags to get the colors mixed up. See here:
https://vborg.vbsupport.ru/showpost....3&postcount=13
I did not add any color to the html tagged text. Only after I posted an additional (back to back) post and this second post got merged, the color was added.

Smoothie 12-29-2006 12:20 AM

Does this work with 3.6.4?

Smoothie 12-29-2006 12:30 AM

I'm guessing it does....

Smoothie 12-29-2006 12:48 AM

Or does it? I installed this and it seems you need a refresh of the page to see the posts merged.

Err0r1 01-01-2007 08:28 AM

Is this working for anyone on 3.6.4?

I've installed, but nothing happens upon double posting.

Maybe it's because I've installed beebi's mod: https://vborg.vbsupport.ru/showpost....&postcount=618

Smoothie 01-01-2007 06:52 PM

Quote:

Originally Posted by Err0r1 (Post 1148417)
Is this working for anyone on 3.6.4?

I've installed, but nothing happens upon double posting.

Maybe it's because I've installed beebi's mod: https://vborg.vbsupport.ru/showpost....&postcount=618

It's working for me.

TrIn@dOr 01-04-2007 09:10 AM

Thanks, nice.

Where can i find the sentence, "Doublepost will be merged" ?, i need to translate it!

Wild-Wing 01-06-2007 04:01 PM

ok im confused whats with post var where theres no sql

MeMySelfNi 01-09-2007 11:22 PM

I was looking all over the place for this

*installed*

Nik_s3 01-10-2007 08:32 PM

Sorry... I'm using 3.6.4 versione. Is there someone that could explain to me what is the exact procedure to install this modification?

Thank you

Nik_s3 01-11-2007 11:07 AM

Up....

SCRIPT3R 01-15-2007 06:29 PM

Quote:

Originally Posted by Nik_s3 (Post 1155748)
Sorry... I'm using 3.6.4 versione. Is there someone that could explain to me what is the exact procedure to install this modification?

Thank you

Quote:

Originally Posted by Nik_s3 (Post 1156146)
Up....

Quote:

Originally Posted by beebi (Post 1117689)
to get it work fine with 3.6.x
find
PHP Code:

    // we are here, so we may have a doublepost -> do more exact checkings
    
$doublepost $vbulletin->db->query_first("
        SELECT post.*
        FROM " 
TABLE_PREFIX "post AS post
        LEFT JOIN " 
TABLE_PREFIX "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
        WHERE threadid = 
$threadinfo[threadid]
            AND dateline > " 
. (TIMENOW $vbulletin->options['xen_dp_timespan'] * 60) . "
            AND visible = 1 AND deletionlog.primaryid IS NULL
            AND postid <> 
$post[postid]
        ORDER BY dateline DESC
        LIMIT 1
    "
); 


replace it with
PHP Code:

        // we are here, so we may have a doublepost -> do more exact checkings
        
$doublepost $vbulletin->db->query_first("
                SELECT post.*
                FROM " 
TABLE_PREFIX "post AS post
                LEFT JOIN " 
TABLE_PREFIX "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
                WHERE threadid = 
$threadinfo[threadid]
                        AND post.dateline > " 
. (TIMENOW $vbulletin->options['dp_timespan'] * 60) . "
                        AND post.visible = 1 AND deletionlog.primaryid IS NULL
                        AND post.postid <> 
$post[postid]
                ORDER BY post.dateline DESC
        "
); 


there ya go. ;)

Bubble #5 01-16-2007 03:14 PM

Quote:

Originally Posted by Xenon (Post 776744)

PHP Code:

AND !in_array($vbulletin->userinfo['usergroupid'], array(5,6,7)) 


We added this to the 'conditionals' section of the hack, but we're getting a bunch of parsing errors and admins are still getting automerged :(

Quote:

Parse error: syntax error, unexpected T_LOGICAL_AND in /home/imnotimk/public_html/forum/includes/functions_newpost.php(524) : eval()'d code(9) : eval()'d code on line 1
Is this a 3.6.4 problem, or did we add the wrong code to the conditionals section?

Xenon 01-16-2007 03:18 PM

remove the AND in front ;)

that was in an old version iirc, regarding that the post is on page one ^^

Bubble #5 01-16-2007 03:52 PM

Thank you Xenon, I fully appreciate your help :)

One other quick question while I have your attention. At the beginning of the thread there is a post that makes this hack 3.6.x compatible. It basically just changed 'AND dateline' to 'AND post.dateline'. However now I see additional code being posted above in beebi post. In your opinion what is the advantage (if any) to using beebis code VS. just adding "AND post.dateline"?

Xenon 01-16-2007 05:40 PM

Well, as far as i can see both codes will work, beebi's code adds just a few more post. which doesn't change anything now, but may prevent bugs with future versions of vb, so i'd suggest you should use the version by beebi

SCRIPT3R 01-16-2007 06:05 PM

was the product actually updated (changed)? it still shows the same version #.

Xenon 01-17-2007 10:58 AM

yep, i uploaded a slightly modified file so it will run in 3.6

you don't have to update if you did the changes manually before.

TrIn@dOr 01-17-2007 11:46 AM

Quote:

Originally Posted by Xenon (Post 1161346)
yep, i uploaded a slightly modified file so it will run in 3.6

you don't have to update if you did the changes manually before.

Installed before the update and working good, need we to update??

We have 3.6.4

Thanks in advance!

EDIT 1: Udapted, all ok in 3.6.4

EDIT 2: Working full dual spanish/english, thanks.

Bubble #5 01-17-2007 03:04 PM

Quote:

Originally Posted by Xenon (Post 1161346)
i uploaded a slightly modified file so it will run in 3.6

THANK YOU Xenon, we appreciate the update ;)

PoetJA-1975 01-21-2007 03:00 PM

Great mod - Thanx for the share!

Jacquii.

AZone 01-25-2007 06:55 PM

Tried to import it to my 3.5.4 and got MySQL Error : Unknown column 'executionorder' in 'field list'

Xenon 01-26-2007 12:49 PM

hmm, seems that the xml files are not downward compatible.
Didn't think Jelsoft would code that way.

edit the xml file manually and remove all executionorder=".." parts and it should work again

AZone 01-26-2007 05:07 PM

Did what you said and it works. Thank you.
However, it doesn't change posting time, leaving post marked as old. Is it how it actually works or something's wrong?

WrestlingAcadem 01-26-2007 07:00 PM

Is there a way to turn off auto-merge in a certain forum?


All times are GMT. The time now is 08:14 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.02257 seconds
  • Memory Usage 1,855KB
  • 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
  • (5)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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