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.

[TacticalNuke]

It's from a Google search, I forgot to add that but impressive that you know.

Alright, so I'll delete the Zoints folder.

I don't really understand how to do the redirects. I know a site where I can read up on it (and I will), but how do I make sure that every Google search that is looking for Zoints tags is redirected to the new tags system.

Thanks for all the help.

EDIT: I think I got it, here is the code I use in my forum root .htaccess:

Redirect /tags http://www.serviceacademyforums.com/tags.php

Anyway, for SEO purposes and for general user friendliness, should I direct to the tags or just to the homepage? I'm tempted to direct to the homepage.

[obmob]

Seems it worked perfect, thanks!

[msm_eg]

what i can do if i already uninstall zoint is there anyway to fix the databais error of zoint???

[saxahan]

Installed.Thanks for share.

[caliman]

BIG THANKS FOR THIS MOD.
WORKED PERFECTLY.

FYI vbseo users:

1) You will need to enable this option in config_vbseo.php:

define('VBSEO_URL_TAGS_FILTER', 1);
(change 0 to 1 to enable as shown)

2) Remove old tags folder (forums/tags) completely.

[LoveStream]

I convert from zoints 1.2.1 to vb3.8.0 successfully.

[tefon]

converttags.php starting but is not completed...

No error but, tag 317223 or 1261904 stopped end.

pls help me.

[mykkal]

My site is www.mymodeltalk.com/jobs/

Since installing Zoints I've had problems with the template. THe Zoints tag cloud page doesn't make user of the template i'm using. Any Ideas?

You can see the tag cloud here and compare the difference to the site url above.
www.mymodeltalk.com/jobs/tags/

[tarionyx]

worked great for me... I'm just working on a rewrite rule for the old tags.

[tarionyx]

Ok here's what I did for redirection of the old zoints tag links...

In the vbSEO control panel, under "Define Custom 301 Redirects" put this in there:

'^tags/index\.php/([^/]+)/?$' => 'tags/$1.html'