Administrative and Maintenance Tools - Thread Prefixes upgrade from Mystics to 3.7

Thread prefixes upgrade.

This script upgrades the old Thread Prefixes hack by Mystics to the new thread prefixes found in 3.7+. The only guarantee is that it works on my test server, going from 3.6.8 to 3.7.0B3.

It is a one-run operation. The script reads the details of the old thread prefix system from your database, and then writes new entries for the new system into your database. The code is rough and ready (OK, it's my first ever script), so do NOT use it unless you have backed up your database and are prepared to restore it.

It will create a fully populated prefixset for each forum with prefixes, and then assign the prefixes to the threads in that forum.

The rich text format of the new prefix is set to be bold with square brackets around, although if you want to change that you can edit tpup.php (there is a commented out version of the query, that will make the text plain - it should be obvious).

Instructions.

1. Upgrade to 3.7 and revert all templates.
2. Open dp.php in a text editor and enter your database login details.
3. Upload all 4 .php files to a new folder on your server (or test server).
4. Backup your database.
5. Browse to tpup.php in your browser to run it.
6. When it's done, close the browser window and delete the files from your server.
7. Now you must rebuild all languages in AdminCP > Languages & Phrases > Language Manager > Rebuild All Languages. If you miss this step, nothing will work!
8. Please report any success or failure in this thread.

Versions:
1.00 First go.
1.01 Added the facility to specify a database table prefix.
1.04 Got the table prefix right, thanks to Mystics.

[Delazar]

Thanks Pottsy and Mystics,

it?s working now:up:

regards
Delazar

[rellek]

Thanks a lot. Will try it soon - and give my vote for MOTM

[daFish]

Great converter - works perfectly on my testboard.
Thanks for this.

[Snake]

Thanks for this!

[rellek]

Okay, tested, working well, nominated for MOTM

Thank you again!

[DS MrSinister]

thanks for sharing... works great..

[Trigr]

just so im understanding .......

i must have your original from https://vborg.vbsupport.ru/showthread.php?t=123033 installed on my 3.6.x board before i try the upgrade to 3.7

then once i upgrade to 3.7 i have to use this to convert over so it will work again?

id love to use this .... just want to be clear.

thanks

[daFish]

Originally Posted by Trigr

just so im understanding .......

i must have your original from https://vborg.vbsupport.ru/showthread.php?t=123033 installed on my 3.6.x board before i try the upgrade to 3.7

then once i upgrade to 3.7 i have to use this to convert over so it will work again?

id love to use this .... just want to be clear.

thanks

Basically, yes.
If you're using Mystics prefix hack a lot in your forums, then this hack is for you if you're upgrading to vB3.7.
Otherwise not.

[firstrebel]

This is greatly appreciated. At what stage do we:

remove the product

remove the files: threadprefix.php and includes/functions_threadprefix.php

remove the templates: threadprefix_listbit and threadprefix_modify

revert the two templates that are not changed for 3.7: threadbit_announcement and SUBSCRIBE

Bob

[Pottsy]

I would do that once you know you are never going to need the old data. So for me it will be once I upgrade my live site to 3.7.? and get it happily running, and take a "I'm happy with it" backup.