Thread Splitter

[Keloran]

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)

[rooban12]

demo or any samples?
thanks in advance

[Magnumutz]

A demo would be nice.

[Fungsten]

Installed on test server. BTW, you should mention to Import as a product. Also where to find it; Vb Options.

[Fungsten]

Could you correct this spelling please?

Set the amount of replys a thread can have.

It should be "replies".

On Edit:

After the thread is closed it posts an additional post after the notice that it has been moved. When I clicked on the Continuation link it said it was invalid.

After searching for the new thread the date on that thread is 12-31-1969 06:00 PM.

[Keloran]

ill upload the fixed version when i get back to work on monday, it fixes alot of the bugs, ill make it a zip with instructions too, ill try to make a semi-demo aswell

[Keloran]

update to work almost fully now, just has 3 bugs left, that ill endevor to fix, if someone else manages to work out the fix, plz tell me

[Fungsten]

I updated and now it's not working at all.

I also got this error after clicking.

71064

[Keloran]

that problem should now be fixed

[Fungsten]

Better!! But, when I click on the link to the "old" post there is an error message that it cannot be found. Also, I'm still getting that problem where the new "split post" has the date of 12-31-1969.

[Marco van Herwaarden]

You do know that you can add Install/Uninstall code to your product. Usually database cahnges are done there.

[Keloran]

before i did the updates in the installcode i wanted to make sure i had all the syntax correct for checking the index didnt exist before making it, which some plugins on here dont seem todo, its now automatic, and doesnt add multiple index's

[Mum]

Great, will keep an eye on this, i've been wanting this!

[Reeve of shinra]

This is a good idea!

[ams3521]

be great if it could split at a certain time possibly.

[Keloran]

be great if it could split at a certain time possibly.

do you mean certain time of the day ?

[TheBlackPoet]

can you split a thread??!!!!! say like i have a short story... and its over 500 words.. i may want to split it where IN THE THREAD every 250 words... so, you see... next.. page 1 page 2 so on and so forth....???

[Fungsten]

Not working on mine. VB 3.6.8 Pl 1

[Mum]

Great idea, doesn't work on 3.6.8

[Keloran]

fixed all the issues (on mine), and sorted a problem with something that happened on multiple splits

[inciarco]

Great Idea, Keloran!! ;)

But There is a Bug on this Hack for vBulletin 3.6.7 PL1!! :(

I Hope You Can Tell Me What's Wrong?? :confused: What Template or Plugin Should I Change to make it Work?? :confused:

I didn't Even Reached the Count of Posts to Split the Thread, it Happened just Only by Posting a Simple New Post!! :(

(Perhaps a Bad Reference To a Table On a Plugin??) :confused:

I'll Keep the Hack Not Active so that I can Allow Postings on my Forum!! :(

My Best Regards!! ;)



Database error
The INCIARCO - FOROS - Comunidades Virtuales de Integraci?n database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the inciarco.com home page, then try to open another page.
Click the Back button to try another link.

The inciarco.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT replycount, open, contnum FROM vb_thread WHERE threadid = 818 AND thread.forumid NOT IN ('') LIMIT 1;

MySQL Error : Unknown table 'thread' in where clause
Error Number : 1109
Date : Tuesday, October 30th 2007 @ 09:59:44 AM
Script : http://zzz/newreply.php?do=postreply&t=818
Referrer : http://zzz/newreply.php?do=newreply&noquote=1&p=9433
IP Address : zzz.zzz.zzz.zzz
Username : zzz
Classname : vb_database

[Keloran]

ahh sorry thats my fault, yeah i didnt add the " . TABLE_PREFIX . "

fixed

[inciarco]

Now is Working Better, Keloran!! ;)

But... :eek: :p

There's a Bug With The Option "Update subscriptions" (Update the users thread subscriptions to add the new thread to people who subscribed to the old ones.)!! :( :confused:

When Activated, Causes the Error I Present To You Inside the Code Tags!! :( ;)

The Hack Splits the Thead, but Presents that Error, and I Think that Don't Perform the Updating of the Suscriptions!! :( ;)

(Code in Plugins Under "//update the subscribed people to the new thread").

My vBulletin Version is 3.6.7 PL1!! ;)

My Best Regards, Keloran!! :up:



Database error
The INCIARCO - FOROS - Comunidades Virtuales de Integraci?n database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the inciarco.com home page, then try to open another page.
Click the Back button to try another link.

The inciarco.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT userid, folderid, emailupdate FROM vb_threadsubscribe WHERE threadid = 2048 AND canview = 1;

(The zzz_zzz text mentioned Next is the Name of the DataBase!!)

MySQL Error : Table 'zzz_zzz.vb_threadsubscribe' doesn't exist
Error Number : 1146
Date : Tuesday, October 30th 2007 @ 03:46:12 PM
Script : http://zzz/newreply.php?do=postreply&t=2048
Referrer : http://zzz/newreply.php?do=newreply&noquote=1&p=9454
IP Address : zzz.zzz.zzz.zzz
Username : zzz
Classname : vb_database

[inciarco]

http://inciarco.com/foros/images/smilies/anterior.gif

Another Additional Little Bug I Found!! ;)

When the New Splitted Thread is Created, on the First Two (2) Replies (The Firts Post of the Previous Version of the Thread, and the Post that Caused the Split), the Smilies Don't Show (Appear Written But Don't Show), and I Have To Edit The Message with the Advanced Editor and Save It for the Smilies to Appear (the Codes Appear but Seems Like if the Smilies where Not Used on those Particular Posts that come from the Closed Splitted Thread)!! :( :confused:

My Best Regards, Keloran!! :up:

:)

[inciarco]

Another Bug I Found Later, that I Think a Forumer Mentioned Previously, is that the Date of the Splitted (New) Thread is "31-12-1969 08:42 PM", and also NO User Appears as Poster of the Last Message!! (Perhaps Those Thow Fields Are Missing On The New Thread, and Shall be Copyed From the Las Post Placed on It)!! :( ;)

I Hope You Can Fix Those Three (3) Bugs I've Mentioned on my Posts, because This Is a Great Hack!! ;)

My Best Regards!! ;)

:)

[Keloran]

the date one is an odd one, because it uses server time of time() + 1 or 2, depending on the post (to stop vB complaining of duplicates)

the only time it did it on mine was when the server decided to forget the real date, the others are fixed (or should be)

[inciarco]

I've Tested the New Update, Keloran, but Another Bug Appeared Also for the "Update subscriptions" Option!! :( ;) :confused:

I'll Copy/Paste the Error Message!! ;)

I Think You're Near The Final Solution!! ;)

The "Unsticky old threads" Option, Works Fine!! ;)

:rolleyes: I Think You Should Consider Using the Date Of The Last Post as a Reference for the New Thread, or Simply Use the Same Formula of the Bump Hacks (there are like 2 or Three Hacks that Bump/DeBump Threads)!! I Think for some Reason Using the Date of the Server Don't Works Fine (I Know the Date of My Hosting Server is Ok, so there's Something in the Code of the Hack that Isn't Working Fine)!! ;)

Perhaps If The Date of The New Thread When Creating It Is The Same Of The Old Thread, is Better To Leave Them That Way, Because The Old Thread Is Already Closed and Nobody Will Change It; and Also With The Date Set to "31-12-1969" the New Thread Don't Appear on the List of New Threads on the Forum Statistics Hacks, and It Also NOT Appear on the "Today's Threads" (http://zzz/search.php?do=getdaily) which Will Be Very Confusig For Users!! :( ;) :confused:

I've tested the Hack with a Threar Limit Below the Max Number of Posts inside My Test Thread, and Also Works When Next Post is Posted and Splits the Thread Ok (Only Bug is the One Mentioned at the Beginning of this Message)!! ;)

I've Tested the "Dont Split In Forums" Option, and Works Ok!! ;)

I've Tested the Hack with the "Quick Reply" and Works, only that the "Closed" Image Appears After Refreshing the Window, but the Thread Is Closed and the Split is Made and the Message Of Split Appears Fine, and No Additional Message is Allowed To Be Posted (Old Thread Is Closed)!! ;)

My Best Regards!! ;)

:)



Database error
The INCIARCO - FOROS - Comunidades Virtuales de Integraci?n database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the inciarco.com home page, then try to open another page.
Click the Back button to try another link.

The inciarco.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.6.7:

Invalid SQL:
INSERT INTO vb_subscribethread (threadid, folderid, userid, emailupdate, canview) VALUES (2050, , , , 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1' at line 1
Error Number : 1064
Date : Wednesday, October 31st 2007 @ 06:12:04 PM
Script : http://zzz/newreply.php?do=postreply&t=818
Referrer : http://zzz/newreply.php?do=newreply&noquote=1&p=9473
IP Address : zzz.zzz.zzz.zzz
Username : zzz
Classname : vb_database



:)

[Ania]

screenshots?

[Keloran]

ania its quite hard todo screenshots

it litterlly, closes a thread, starts a new one, i cant screenshot the process

[Keloran]

that should fix the problem with hte dates not being inserted correctlly, although looking at my forum there was an occasion where this happened, but in the database the dates are correct, so im guessing vbulletin is doing something really stupid

[inciarco]

Thanks For The Update, Keloran!! :up:

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

-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/plugin.php?do=productimport
Referrer : http://blahblahblah/forum/admincp/plugin.php?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>', '1', '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 53149HERESo you can see the BBcode brackets and it doesn't link to the next/past thread.

[sjcallas]

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

So you can see the BBcode brackets and it doesn't link to the next/past thread.
I have the same issue. The BB code doesn't work.

[koolfire]

Can someone please confirm if this hack works like a charm? I mean there are some shacky replies!

[Mum]

it doesn't work for me as per my post a few posts back. No response from Coder either, hasn't been on since Jan :(

[PGAmerica]

I am using 3.7.3 PL1 and although this does split the thread, the bbcode that links one thread to another does not work. Also, in the new thread, it puts in the new split post (which is fine), but it also puts in a post from the previous thread, but seems to be a random post.

[viper357]

Is there anybody that has this running successfully on 3.6.* ?

[TimIgoe]

Is there anybody that has this running successfully on 3.6.* ?

yep, its also compatible with 3.7.

[kenfuzed]

Somebody should close this since the code is obviously broken and the developer has abandoned it.

Anyone know of another mod like this that actually works?

[SBlueman]

Can anyone confirm if this works without issues on 3.6.12?

[TimIgoe]

we are still using it on the forum it was developed for - now on 3.8.4

[Sidewindr]

we are still using it on the forum it was developed for - now on 3.8.4

It kind of works on 3.8.4+ but the split tag does not work and it does not update subscriptions etc. Any chance anyone could port this mod to 3.8 ?? pretty please ?? :)

[Acido]

I am crazy or this is still working in vbulletin 4.0.3 ???

[TimIgoe]

I've not tried an upgrade to vB4 yet, but as far as I know this should still work.

[HFB]

To fix the bbcode go to BB Code Manager. Find "Split", click Edit, then click Save. That's all there is to it.

[HFB]

I got subscription updating to work. Product file is attached. It's been installed on vB 3.6.8 and 3.8.4 without any issues. You will still have to save the bbcode as described in my post above to get that working.

[viper357]

I got subscription updating to work. Product file is attached. It's been installed on vB 3.6.8 and 3.8.4 without any issues. You will still have to save the bbcode as described in my post above to get that working.
Awesome, thank you for your contribution, I will test it later on 3.8.5 :up:

Quick question, if I have 20 posts per page, what is the recommended amount of pages to have before a thread should be split, and does this help with performance? Thanks.

[HFB]

Awesome, thank you for your contribution, I will test it later on 3.8.5 :up:

Quick question, if I have 20 posts per page, what is the recommended amount of pages to have before a thread should be split, and does this help with performance? Thanks.
That will depend on your server specs and configuration. We use this solely for performance reasons and set it at 1000 replies to keep db queries from getting too long. In master-slave replication server configurations we experience replication lag and lost connections with higher reply counts. Performance hit is especially severe if post cache needs to be rebuilt.

[viper357]

Thanks for that, it is running 100% on my 3.8.5.

Just one question if you don't mind, is there any way I can prevent it from posting the first post of the original thread? Much appreciated, thanks.

[HFB]

Thanks for that, it is running 100% on my 3.8.5.

Just one question if you don't mind, is there any way I can prevent it from posting the first post of the original thread? Much appreciated, thanks.
The second post of the new thread is the first post of the old thread so I'd try commenting out or removing this code in the plugins. It's found in both plugins.

//create the second post in the new thread
$newPostNTF = $db->query_write("INSERT INTO " . TABLE_PREFIX . "post (title, threadid, username, userid, dateline, pagetext, visible, parentid, showsignature) VALUES ('" . $db->escape_string($oldPostF['title']) . "', " . $newThreadId . ", '" . $db->escape_string($oldPostF['username']) . "', " . $oldPostF['userid'] . ", " . $newTime . ", '" . $db->escape_string($oldPostF['pagetext']) . "', 1, " . $newPostId . ", 1)");
$newPostNTFId = $db->insert_id();

[viper357]

The second post of the new thread is the first post of the old thread
Really sorry to bug you again. Is there any way we can make 'the second post of the new thread', the last post of the old thread? So when someone makes a post in the original thread, the post is posted, the thread is then closed and split and that last post is then posted again as the 2nd post in the new thread?

Would really appreciate your help on this, Thanks.

[mikexxx]

Any clue if this still works in VB4?

[ravenscape]

On the first split, the thread splitter includes "Part 1" in the thread name, which is cool, but since it's actually the 2nd thread in the potential series, how could I make the title "Part 2" instead?

//fix the title for when we get multi-parts
if (strstr($oldThread['title'], "Part")) { $oldThread['title'] = substr($oldThread['title'], 0, (strlen($oldThread['title']) - 8)); }