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]

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?? What Template or Plugin Should I Change to make it Work??

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??)

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...

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.)!!

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]

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)!!

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!!

I'll Copy/Paste the Error Message!!

I Think You're Near The Final Solution!!

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

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!!

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