vb.org Archive - Prevent Doubleposting

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)

My members has informed me that when they accidentally double posted a white page appears and the top left corner It say "FLOOD".

So i check the in message posting and its set it set to 30 so i don't know where else to check.

any info will be great

Quote:

Default? or did you modify this?

I got it working on 3.7.0 beta 6 default, without changing things. Does that help you?

Quote:

Originally Posted by Thomas P (Post 1480708)

I could do this, no problem, if you want

Would it be hard to change the code so that this mod would only work in selected forums?

I am testing out yoyoyoyo's version. It has a field in the options called 'Additional Condition'. Can this be used to exclude forums?

Quote:

Originally Posted by Black Tiger (Post 1423399)

Suggestion: Change the way time is displayed depending on the amount of time which is passed when a users writes his second reply after the initial post/reply.
I mean the following:
I've got my limit on 20 hours, so if a user writes a reply after some 14 hours and minutes it will be displayed like this
testuser added 888 Minutes and 26 Seconds later...

Now it would be nice to let only be shown minutes and seconds before an hour is over. So it would show the messages as followd after for example 63 minutes:
testuser added 1 Hour and 3 Minutes later...

Or for whoever likes it:
testuser added 1 Hour, 3 Minutes and 12 seconds later...

I guess this would not be difficult to make bye a IF/THEN statement in the code.
IF time >60... etc.. Ik wouldn't know exactly I'm not a coder.

Is there a way to implement this in a next version or if not, a way I can adjust the code myself to change it like this?
I have seen it with "hours" and "minutes" on some forum, just can't remember which forum.

AFAIK the above version does this.

Quote:

Originally Posted by Black Tiger (Post 1457042)

Yes you can exclude forums in which you don't want it to work.

Could you please explain how?

After reading back the past 10 pages, it seems there is still no reply to making the merged text read:

--------------- Added 6 April 2008 at 7:17pm ---------------

Anyone managed to get that working?

I have tried to install this in my vb 3.5.x site and I get this error anyone know what this is and how to fix it

HTML Code:

Database error in vBulletin 3.5.3:



Invalid SQL:



### INSERT QUERY GENERATED BY fetch_query_sql() ###

INSERT INTO plugin

        (`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)

VALUES

        ('1', '5', 'Main Doublepost Prevent Engine', 'newpost_complete', '// ########### Xenon\'s prevent doublepost modification #########\r\n\r\n$vbulletin->GPC[\'xen_isdoublepost\'] = false;\r\n\r\n// parse custom conditions\r\n$custcond = true;\r\nif (trim($vbulletin->options[\'xen_dp_custcond\']) != \'\')\r\n{\r\n        eval(\'$custcond = ((\' . $vbulletin->options[\'xen_dp_custcond\'] . \') ? true : false);\');\r\n}\r\n\r\n\r\n// at first check if there is at least the possibility to be a doublepost\r\nif ($custcond AND $type != \'thread\'\r\n        AND $dp_threadinfo[\'lastpost\'] > TIMENOW - $vbulletin->options[\'xen_dp_timespan\'] * 60\r\n        AND $dp_threadinfo[\'lastposter\'] == $vbulletin->userinfo[\'username\']\r\n        AND $dataman->fetch_field(\'attach\') == 0)\r\n{\r\n        // we are here, so we may have a doublepost -> do more exact checkings\r\n        $doublepost = $vbulletin->db->query_first(\"\r\n                SELECT post.*\r\n                FROM \" . TABLE_PREFIX . \"post AS post\r\n                LEFT JOIN \" . TABLE_PREFIX . \"deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = \'post\')\r\n                WHERE post.threadid = $threadinfo[threadid]\r\n                        AND post.dateline > \" . (TIMENOW - $vbulletin->options[\'xen_dp_timespan\'] * 60) . \"\r\n                        AND post.visible = 1 AND deletionlog.primaryid IS NULL\r\n                        AND post.postid <> $post[postid]\r\n                ORDER BY post.dateline DESC\r\n                LIMIT 1\r\n        \");\r\n\r\n        if ($doublepost[\'userid\'] == $vbulletin->userinfo[\'userid\'] AND $doublepost[\'attach\'] == 0)\r\n        {\r\n                // we truely have a doublepost, now check if the merged post still fits the rules!\r\n                $dpdataman =& datamanager_init(\'Post\', $vbulletin, ERRTYPE_ARRAY, \'threadpost\');\r\n                $dpdataman->set_existing($doublepost);\r\n                $doublepost[\'message\'] = $doublepost[\'pagetext\'] . \"\\n\" . $vbulletin->options[\'xen_dp_spacer\'] . \"\\n\" . $post[\'message\'];\r\n\r\n                // set info\r\n                $dpdataman->set_info(\'preview\', $post[\'preview\']);\r\n                $dpdataman->set_info(\'parseurl\', $post[\'parseurl\']);\r\n                $dpdataman->set_info(\'posthash\', $post[\'posthash\']);\r\n                $dpdataman->set_info(\'forum\', $foruminfo);\r\n                $dpdataman->set_info(\'thread\', $dp_threadinfo);\r\n\r\n                // set options\r\n                $dpdataman->setr(\'showsignature\', $post[\'signature\']);\r\n                $dpdataman->setr(\'allowsmilie\', $post[\'enablesmilies\']);\r\n\r\n                // set data\r\n                $dpdataman->setr(\'pagetext\', $doublepost[\'message\']);\r\n                $dpdataman->setr(\'iconid\', $post[\'iconid\']);\r\n\r\n                $dpdataman->pre_save();\r\n                if (!$dpdataman->errors)\r\n                {\r\n                        // merged post is ok, so actually do the merging by editing old post\r\n                        $vbulletin->GPC[\'xen_isdoublepost\'] = true;\r\n\r\n                        if ($vbulletin->options[\'xen_dp_bumpthread\'])\r\n                        {\r\n                                // bump thread, so change the post\'s dateline\r\n                                $doublepost[\'dateline\'] = TIMENOW;\r\n                                $dpdataman->setr(\'dateline\', $doublepost[\'dateline\']);\r\n                        }\r\n                        $dpdataman->save();\r\n\r\n                        // as we have edited an old post, we can now delete the new created post\r\n                        $postman =& datamanager_init(\'Post\', $vbulletin, ERRTYPE_SILENT, \'threadpost\');\r\n                        $postman->set_existing($post);\r\n                        $postman->delete($foruminfo[\'countposts\'], $threadinfo[\'threadid\'], $removaltype = true, array(\'userid\' => $vbulletin->userinfo[\'userid\'], \'username\' => $vbulletin->userinfo[\'username\'], \'reason\' => $vbulletin->options[\'xen_dp_editedby\'], \'keepattachments\' => false), false);\r\n                        unset($postman);\r\n\r\n                        $doublepost[\'oldmessage\'] = $post[\'message\'];\r\n                        $post = $doublepost;\r\n                        $id = $post[\'postid\'];\r\n\r\n                        //now add edited by message\r\n                        if ($vbulletin->options[\'xen_dp_editedby\'] != \'\')\r\n                        {\r\n                                $vbulletin->db->query_write(\"\r\n                                        REPLACE INTO \" . TABLE_PREFIX . \"editlog (postid, userid, username, dateline, reason)\r\n                                        VALUES ($post[postid], \" . $vbulletin->userinfo[\'userid\'] . \", \'\" . addslashes($vbulletin->userinfo[\'username\']) . \"\', \" . TIMENOW . \", \'\" . addslashes($vbulletin->options[\'xen_dp_editedby\']) . \"\')\r\n                                \");\r\n                        }\r\n\r\n                        // last step update counters\r\n                        build_thread_counters($post[\'threadid\']);\r\n                        build_forum_counters($foruminfo[\'forumid\']);\r\n                }\r\n        }\r\n}', 'xenon_prevdoublepost');



MySQL Error  : Unknown column 'executionorder' in 'field list'

Error Number : 1054

Date         : Friday, April 11th 2008 @ 03:41:11 PM

Script       : http://www.mysite.com/forums/admincp/plugin.php

Referrer     : http://www.mysite.com/forums/admincp/plugin.php?do=productadd

IP Address   : 67.x.x.x

Username     : **********

Classname    : vb_database

You need to go through the XML and take out the executionorder settings as that wasn't introduced until a later version of vb. I would recommend upgrading.

work fine with 3.7.x :)

Quote:

Originally Posted by Boofo (Post 1488567)

You need to go through the XML and take out the executionorder settings as that wasn't introduced until a later version of vb. I would recommend upgrading.

Boofo can you help me out by removing the correct code and posting the xml please... I know I should upgrade but with my site being extremely hacked and lots of members along with the site running good I am just no ready, maybe when version 3.7 comes out of beta I might concider.

Quote:

Originally Posted by bada_bing (Post 1488761)

Try this:

Quote:

Originally Posted by Boofo (Post 1488764)

Try this:

You da man Boofo I will try it now..

Excellent it worked!!!!!!!!!!!!!!!!!!!!!

Boofo

Thanks for your help I wanted to ask you another question, I wanted to exclude certain forums for example my sponsor forums from this double post hack. I have excluded the Mods by adding "!can_moderate()" in the Additional Conditions area of the hack in admincp. How and where can I exclude certain forums ?

thank you...

I would really like to know as well.

Add this to the Additional Conditions:

Code:

in_array($threadinfo['forumid'], array(27,28)) AND can_moderate()

Adjusting it to your needs.

Many thanks!!!

BTW: how do you exclude forums? I have a LOT of forums and typing all the forumID's is a lot more work then placing the forumIDs of the forums that I do not want to automerge. Here are the ID's:
125,142,152,156,164,165,166,174,176,190,192,196,20 9,211,212,213,214,215,216,217, 218,219,220,221,223,224,225,226,228,229,237,238,23 9,240,241,242,243,244,245,246, 247,248,249,250,251,252,253,254,255,256,257,258,25 9,260,261,262,263,264,265,266, 267,268,269,270,271,272,273,277,278,279,

Figure out if there are more you want to include or exclude and use the smallest amount. I know of no other way to do it.

The forumID's above are by far the smallest amount. I would like to exclude them.
Is it possible to use a code to define not in array/ outside array?

Installed without any problem on v3.6.9! It works perfectly :)

Alfa1: if those ids of forums are all subforums of a specific category, something like

PHP Code:


		
			
AND $foruminfo['parentid'] != categoryid

should work as well and might save a lot of ids ;)

Quote:

Originally Posted by Xenon (Post 1491290)

Alfa1: if those ids of forums are all subforums of a specific category, something like

PHP Code:


		
			
AND $foruminfo['parentid'] != categoryid

should work as well and might save a lot of ids ;)

So if all my forums I want to exlude are subforums how can I exlude the main forum which also include all the subforums below it?

Can you post the code do this with exampe of exluding forums 83,129 and also to exclude mods from this hack...

Thanks

Quote:

Originally Posted by bada_bing (Post 1491355)

Any help with this Boofo?

!in_array($threadinfo['forumid'], array(83,129)) AND !can_moderate()

Somehow this doesn't work:
!in_array($threadinfo['forumid'], array(125,142,152,156,164,165,166,174,176,190,192, 196,209,211,212,213,214,215,21 6,217, 218,219,220,221,223,224,225,226,228,229,237,238,23 9,240,241,242,243,244,245,246, 247,248,249,250,251,252,253,254,255,256,257,258,25 9,260,261,262,263,264,265,266, 267,268,269,270,271,272,273,277,278,279)) AND !can_moderate()

While on my development forum this does work:
!in_array($threadinfo['forumid'], array(6,8,9))

The forumID's are the ID's I want to exclude

Please delete this post. I would really like to know if anyone knows the answer to the question above.

Quote:

Originally Posted by Boofo (Post 1491777)

!in_array($threadinfo['forumid'], array(83,129)) AND !can_moderate()

Boofo I have tried your listed code and it does not work, If I try and double post in either forum or subforum under forum id 83 or 129 it still merges in those forums???

Awe never mind got it thanks I used this

!in_array($threadinfo['forumid'], array(83,129)) AND !can_moderate()

I was missing the )

OK Another glitch as this works to exclude all subforms also uner the forumid with version 3.6.9 cant get it to work with 3.5.x as I have to add all the subforum ID's to exclude them???? Any reason why?

Quote:

Originally Posted by Noctavia (Post 1484326)

unfortunately i think not ... maybe Bobby can give us a hand ...? :P

Quote:

Originally Posted by bada_bing (Post 1492332)

Hey Boofo any ideas?

Quote:

Originally Posted by Noctavia (Post 1484326)

No but we do have:

Quote:

Alfa1 added 0 Minutes and 12 Seconds later...

BTW: I have this hack working now.

When activating this hack does it only process new posts or old ones as well?
Would rebuilding post or thread cache cause old double posts to be merged?

I think it only works on new posts after it is installed.

Would be great to reduce DB size if it could be applied to old posts as well.

Any help with my question to post 872 ?

Since I am no longer using 3.5.4, I can't help you there.

Can someone please help me with this? I really need to exclude subforums

Quote:

Originally Posted by KURTZ (Post 1492987)

Quote:

unfortunately i think not ... maybe Bobby can give us a hand ...? :P

*Is ever so hopeful someone can help out* Seeing "added 1084 minute and 26 seconds later confuses a lot of people lol.

This hack should definitely be revised - it's great work and demand is quite high.

:(

Quote:

Originally Posted by Boofo (Post 1493419)

Since I am no longer using 3.5.4, I can't help you there.

maybe you can create something like this for the 3.7.x ... :D

It works for 3.7RC3.

Requested features:
- better time notation.
- process old posts as well.

I have installed it on 3.6.9 and it appears to do nothing for my forum. I left the 1440 minutes there, the separator text is blank and edit reason was the default. I did allow it to bump but it does not seem to be workign at all. ANy suggestions?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02225 seconds Memory Usage 1,858KB 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_html_printable (2)bbcode_php_printable (17)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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
Messages: