New Posting Features - Thread Splitter

This creates a new thread once a thead has reached a certain size and a user posts a new reply

NOTE
this does alter your thread table, it adds a new row (contnum) and a new index
it adds a new bbcode to your forum, so that the topic continue doesnt open a new window/tab

Install guide
when you install through the "manage products", a new set of options will appear in the vbulletin options->vbulletin options (defualt off)

this allows you to change the following settings:
userid of the post continuer - when a post is auto-closed a post is made that says it is closed, and a new thread is created with a post in it saying where the original is, this is posted auto by the user given (default 1)

reply count - the amount of posts before a thread is closed and split (default 500)

threadsplitter enabled - turn off/on the thread splitter (default off)

dont allow splits in X forums - add new forums by using ,. e.g 4,5 (default blank)

update subscriptions - update the users threadsubscriptions to the new thread if subscribed to the old one before split

unsticky old threads - unsticky the old threads after a continuation is made (default off)

[inciarco]

Thanks For The Update, Keloran!! :up:

Five (5) Things I Experienced with the New Updated Version :

-1- When Splitting, Now The Hack is Adding the First Post of the Old Thread Before the Last Split Post in the Old Thread. In previous Version that Didn't Happened.

-2- When Splitting with Option "Update subscriptions" Activated, the Last Post Isn't the Split Message, but the Last Posted Message; when that Option is Disabled, the Last Post of the Old Closed Thread is the Split Message.

-3- Option "Update subscriptions" isn't Causing Anymore Error in Database, but Suscriptions aren't Being Updated to the New Splitted Thread. Suscriptions remain only in Old Closed Thread.

-4- Date in New Thread remains "31-12-1969", so New Thread Don't Appear in Latest Threads, Nor in Today's Threads, Nor in Forum Lates Statistics. I Still Recommend to Use the Date of the Last Post as the Date of the New Thread, (using the Date of the Server Don't Work Successfully).

-5- Smilies in First Created Posts of New Thread Don't Show; Only Show When Editing the Posts with the Full Editor and Saving the Posts. Perhaps one of the Options of the Posts need to be Set.

Those are the Tests I've made until Now!! I Hope This Post Helps to Improve This Excellent Hack!!

My Best Regards!!

[Keloran]

1. interesting ill look into it
2. related to the first one im gona guess
3. it "should" create a subscription to the new thread, not replace
4. the date of the old thread is set by the server, so using the same function should be okay, if you check the data in your database it will most likelly be correct (vbulletin is being a PoW)
5. strange this is fixed on mine, ill see if i can get it working for you

[Fungsten]

Updated. It works so much better!!

[Keloran]

i guess there is no more bugs with this then, at least i havent found anymore to fix, hehe

[MikeHolohan]

didn't work for me, every post made gives and error this is a duplicate post made you will be redirected to that thread... or something like that...

[Keloran]

this might fix that, although its odd because that was fixed in 0.2

[Fungsten]

I'm getting this error message on the import:

Database error in vBulletin 3.7.0 Beta 3:
Invalid SQL:
ALTER TABLE thread ADD contnum INT NOT NULL;
MySQL Error : Duplicate column name 'contnum'
Error Number : 1060
Date : Wednesday, January 9th 2008 @ 03:32:41 PM
Script : http://blahblahblah/forum/admincp/pl...=productimport
Referrer : http://blahblahblah/forum/admincp/pl...?do=productadd
IP Address : XXX.XXX.XX.XXX
Username : XXXXXXXX
Classname : vb_database
MySQL Version : 4.1.21-standard

[civil78]

Also in 3.6.4 have prolbem in import

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO bbcode (bbcodetag, bbcodereplacement, bbcodeexample, bbcodeexplanation, twoparams, title) VALUES ('split', '<a href="/showthread.php?t=%1$s">Here</a>', '[split]1[/split]', 'New tag to stop splits opening a new window', 0, 'Split');

MySQL Error  : Duplicate entry 'split-0' for key 2
Error Number : 1062
Date         : Monday, February 4th 2008 @ 07:08:28 PM
Script       : /admincp/plugin.php?do=productimport
Referrer     : r/clone/admincp/plugin.php?do=productadd
IP Address   : -
Username     : -
Classname    : vB_Database

[MikeHolohan]

I am getting a database error...

Invalid SQL:
ALTER TABLE ffthread ADD contnum INT NOT NULL;

MySQL Error : Duplicate column name 'contnum'
Error Number : 1060

[Mum]

This actually works really well, but i can't use it. The BBCode doesn't appear to be installed? I get this when a thread is closed/opened

This thread is now closed it has a continuation thread [split]53149HERE[/split]

So you can see the BBcode brackets and it doesn't link to the next/past thread.