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.

[FleaBag]

Thanks for the update, I will be able to give this a run through soon (when vB is released, and thus the new vBSEO).

[993ti]

Originally Posted by zappsan

Seems like it doesn't find any tags to convert. Are you sure your Zoints tags table isn't empty?

Not empty: 15,712 records
Strange though, no errors

Edit: Tried it on another site of mine and it works.
Strange, why doesn't it work on my main site :?

Edit 2:
Found what's causing it.
In config.php i had database type set to Mysqli, i changed that to Mysql and it works

[elmati]

Originally Posted by zappsan

You don't have to do anything. The tags usually get added to the threads and will show up automatically after the script has been run, but since you got the error message before it finished, they aren't going to show up on most threads.

ok, tags disapear in every thread, but if a click "edit tags" there are tags in thread and i need to add new tag to see olders, i think i have to update the database...

i dont find in update counters an update tags link...
see my attachments, same thread when i click in edit tags they are some tags there!

[zappsan]

Originally Posted by 993ti

Not empty: 15,712 records
Strange though, no errors

Edit: Tried it on another site of mine and it works.
Strange, why doesn't it work on my main site :?

Edit 2:
Found what's causing it.
In config.php i had database type set to Mysqli, i changed that to Mysql and it works

Good to know you managed to fix it

Originally Posted by elmati

ok, tags disapear in every thread, but if a click "edit tags" there are tags in thread and i need to add new tag to see olders, i think i have to update the database...

i dont find in update counters an update tags link...
see my attachments, same thread when i click in edit tags they are some tags there!

Like already said, my script will update the threads so you'll see older tags when you view a thread. It isn't showing up for you, because you got an error message while running the script so it didn't get to the part where the threads get updated. Try running the new version. If you don't get any errors, the threads should all be updated.

[elmati]

Ok, tonite ill run the new version

Thanks zappsan!

[elmati]

Hey Zappsan i run the converter again and everything works fine!

Thanks a lot for your help

Very usefull, ty a lot!

[bada_bing]

Will this work for the zoints thread tags for vb 3.5.x ?

[elmati]

i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!

[zappsan]

Originally Posted by bada_bing

Will this work for the zoints thread tags for vb 3.5.x ?

Originally Posted by elmati

i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!

That's correct.
You need to upgrade 3.7 first, so you've got the new tag tables in your database. You also need to keep the Zoints tag table.

Glad to see the new version is working

[Rik Brown]

We de-Zointed our forums several months ago. But I did like how the Zoints tagging created new tags since we use the NNTP Gateway that imports Usenet Newsgroup messages. We then ran the Zoints tagging against those imported messages.

Question: Can both the Zoints tagging and new vb 3.7 tagging systems co-exist on an ongoing basis where we first run Zoints tagging and then run vb tagging via this mod (say, weekly)? Or, is this mod normally to be run on a one-time basis and then discontinue the prior Zoints tagging?

Please advise. Thanks. -- Rik