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.

[veyissen]

edit. : solved

[veyissen]

hi. .. I need a little change in the code . in vbulletin tag options panel, my choice is "max tag on a thread" is 30. But when I convert from zoints to vb with your script, this max number is not important. some threads have 50 or more tags. is it possible to limit if a thread has the max number of tags, dont add the tag to thread... is it possible? .. Thanks a lot

[dutchbb]

I'm having this error after switching to vb tags, anyone please?

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT zoints_tag.tag, COUNT(*) count FROM zoints_tag zoints_tag
LEFT JOIN thread thread ON(zoints_tag.threadid = thread.threadid)
WHERE thread.forumid IN(44,2,6,7,12,10,22,32,41,25,11,42,5,45,31,30,39, 43,46,8,29,50,36,33,9,35,53,27,20,34)

AND autogen != 1
GROUP BY zoints_tag.tag
ORDER BY count DESC
LIMIT 30;

MySQL Error : Table 'forum.zoints_tag' doesn't exist
Error Number : 1146
Request Date : Monday, September 14th 2009 @ 01:24:35 PM
Error Date : Monday, September 14th 2009 @ 01:24:35 PM
Script : http://www.mydomain.com/tags/
Referrer :
IP Address : 81.52.143.33
Username : Niet geregistreerd
Classname : vB_Database
MySQL Version :

[giorgiotave]

Nothing for vBulletin 4.0?

[Domenico]

Will this work with 3.6.8 ?

[Domenico]

I just tested it and I can confirm that it worked for vB 3.6.8. More then 200000 tags were converted easily on our 100% identical testboard and I'm hapy.

[birdie]

I still using 3.6 and never upgraded to >3.7 or 4.0 because I extensively used the Zoints tags and still do; they are integral to the running of my forum. Now with 5.0 on the horizon, its time I consider the move.

Is this mod likely to be any use going to 5.0?
Anyone know what my options are?