Administrative and Maintenance Tools - Convert Zoints Thread Tags to vB 3.7 tagging system

Description

This will convert all tags from the Zoints thread tags hack to vB 3.7's tagging system.

Use

Simply upload the converttags.php to your forums root folder and run it in your browser. Once the script is done, delete it. Don't refresh the page after running it (this would give you an MySQL error).

Note:
vB 3.7's tagging system has a few additional settings which Zoints thread tags doesn't have, so it couldn't be converted.

UserID: vB 3.7 saves the ID of the user who added the tag in the database. In my converter, the ID will always be '1'. If you want to use a different one, let me know.
(I think the only time this is used is when you edit the tags of the thread: The tags added by you will be displayed in bold.)

Date: Whenever a tag is added, vB will save the date in the database. In my converter, it will always be the date you ran my script.

Once again, I'm putting this under beta stage for a while, until more people have tested it and got it to work.

I myself have been testing this many times and hope everything is working fine
Use at your own risk, I suggest running this on a test forum before.

Updates
22/6/2008: Security issues fixed. Everyone who got database errors should give this another try, the update will fiy this issue.
19/4/2008: version 1.0.1: Made some changes which will hopefully fix some problems the users have had.

[dirtycrow]

looked soo promising until it gave a Mysql error will processing 370 of 5550 tags.

[zappsan]

Which error did you get?

[Zaiaku]

You know original I was going to do without importing them over since it asn't really that big of a deal but then since you just helped me out here 1 less thing to do without. Thx!

[birdie]

THANK YOU. My use of Zoints tags in 3.6 is the reason I was not going to update to 3.7! I will get back to considering it now!

[FleaBag]

Zoints Tags works just fine with vB 3.7, as I use it myself!

But this is great, I wanted to move over to the vB system but this is what was holding me back. I'll give this a whirl later tonight.

Thanks.

[dirtycrow]

Originally Posted by zappsan

Which error did you get?

this one

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('142','47370','1','1202835441');

MySQL Error : Duplicate entry '142-47370' for key 1
Error Number : 1062
Date : Tuesday, February 12th 2008 @ 11:57:21 AM
Script : http://forums.xxx.com/converttags.php
Referrer :
IP Address : xxx
Username : xxx
Classname : vb_database
MySQL Version : 4.1.22-standard~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[hckby]

Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.

[FleaBag]

I will hold off for now with an install, but hope to install soon!

[kafi]

GREAT GREAT, please fix the issue!!!

Milion Thanks!!!