edit. : solved

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

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 :

Nothing for vBulletin 4.0?

Will this work with 3.6.8 ?

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

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?