New Posting Features - Doublepost Prevention

--------------------------------------------------------------------------------
This modification has been withdrawn.
vBulletin 4.0.x and 4.1.x are no longer supported.

The feature is already built into the core vBulletin 4.2.x code.
--------------------------------------------------------------------------------


This is a current version of the popular modification, originally developed for the early 3.x series by Xenon.

Basically, if member posts in a thread where they were the previous last poster, then if the conditions are met, their new post will be auto-merged into the previous post instead of creating a new "double" post.

A number of options are provided ;

Time Limit - if more than xxx minutes have passed since the last post, no merge is done.

Timestamp Spacer - if enabled, a timestamped spacer is added between the old post text and the new post text.
Other spacer choices provided are no spacer, a default, or a custom spacer.

Spacer Colour - allows you to set the colour of the spacer between merged posts (if one is enabled).

Post Timestamp Update - if enabled the newly merged post will have its post time updated to the new time, otherwise it retains the time of the original post.

Usergroup exceptions - Allows you to exempt certain usergroups from the doublepost merges.

Forum exceptions - Allows you to exempt certain forums form the doublepost merges.

IP Address Check - Specifies if the poster IP should be checked, if enabled, the post will only be merged if the user and ip address are the same.

All settings are located in vBulletin Options > Doublepost Prevention.

To install just unzip the XML and import into vB using the ACP Product Manager.


History:

v4.0.1 : 15-Jan-2010 : Initial release for vb 4.0.0 Gold.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.
v4.1.1 : 17-Jun-2011 : Fixed for vBulletin 4.1.4.
v4.1.2 : 30-Jun-2011 : Javascript updated for CKE and Autosave.
v4.1.3 : 08-Jul-2011 : Dependancies updated as its no longer compatible with vB 4.1.3 or less.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

[physiart]

I've tried to install the update and I had the following MySQL error:

UPDATE vp_template SET
                styleid = -10
            WHERE product = 'paulm_pdp_40' AND styleid = -1;

MySQL Error   : Duplicate entry 'editor_clientscript_pdp--10-template' for key 'title'
Error Number  : 1062
Request Date  : Saturday, March 13th 2010 @ 01:48:10 AM
Error Date    : Saturday, March 13th 2010 @ 01:48:14 AM
Script        : http://www.mydomain.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.mydomain.com/forums/admincp/plugin.php?do=productadd
IP Address    : 123.4.567.89
Username      : webmaster
Classname     : vB_Database
MySQL Version : 5.1.30

Now, the product is not displayed in the product list at all...
Any suggestions how to recover it?

[RedHacker]

Database error in vBulletin 4.0.2:

Invalid SQL:

UPDATE vb_template SET
styleid = -10
WHERE product = 'paulm_pdp_40' AND styleid = -1;

MySQL Error : Duplicate entry 'editor_clientscript_pdp--10-template' for key 2
Error Number : 1062
Request Date : Saturday, March 13th 2010 @ 06:14:02 AM
Error Date : Saturday, March 13th 2010 @ 06:14:06 AM
Script : http://www.xxx.xxx/admincp/plugin.php?do=productimport
Referrer : http://www.xxx.xxx/admincp/plugin.php?do=productadd
IP Address : xxx.x.xxx.xxx
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.89-community

[Paul M]

Originally Posted by physiart

I've tried to install the update and I had the following MySQL error:

Originally Posted by RedHacker

Database error in vBulletin 4.0.2:

Please remember to read the forum announcements.

https://vborg.vbsupport.ru/announcement.php?a=47

[RedHacker]

Originally Posted by Paul M

Please remember to read the forum announcements.

https://vborg.vbsupport.ru/announcement.php?a=47

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'xxx_xxx.template' doesn't exist

[anaksimandros]

Database error in vBulletin 4.0.2:

Invalid SQL:

UPDATE template SET
styleid = -10
WHERE product = 'paulm_pdp_40' AND styleid = -1;

MySQL Error : Duplicate entry 'editor_clientscript_pdp--10-template' for key 2
Error Number : 1062
Request Date : Saturday, March 13th 2010 @ 05:41:35 PM
Error Date : Saturday, March 13th 2010 @ 05:41:40 PM
Classname : vB_Database
MySQL Version : 5.0.85-community

[Paul M]

@anaksimandros - Read the posts above yours.

Originally Posted by RedHacker

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'xxx_xxx.template' doesn't exist

READ the announcement.

Please note that template is the table name and should be typed exactly as is unless you use any tablename prefix (e.g. vb3_template).

[RedHacker]

OK I put vb_template and work....

[borbole]

I think this mod should be included as a standard built in feature for vb as it is very useful.

[Alien]

This says that the mod was updated yesterday, yet still says 4.0.1? Did you update it, or did you just update something else in your original post and not the attachment?

[borbole]

Originally Posted by Alien

This says that the mod was updated yesterday, yet still says 4.0.1? Did you update it, or did you just update something else in your original post and not the attachment?

The mod works fine with 4.0.2 as well.