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.

[zappsan]

Originally Posted by hckby

Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.

Which error did you get? The same dirtycrow got?

Originally Posted by kafi

GREAT GREAT, please fix the issue!!!

Milion Thanks!!!

I will try to fix it.
I must have missed something.
It seemed to work fine for my forums though (around 900 tags).

[pipedreams]

thanks you for this!

It worked perfectlfy for me, though I did have to use

PHP Code:

 set_time_limit(0); 


to make sure the script ran fully

[maxicep]

it works fine, thanks

just some words are bad like quotvbulletin

[ZiG]

crashed for me at tag 758

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('1','1082','1','1203492601');

MySQL Error : Duplicate entry '1-1082' for key 1
Error Number : 1062
Date : Wednesday, February 20th 2008 @ 01:30:01 PM
Script : http://www.xxx.com/xxx/xxx/converttags.php
Referrer :
IP Address : xxx
Username : xxx
Classname : vb_database
MySQL Version : 4.1.22-standard

[Zaiaku]

Tried it out during my update to a heavily modded beta6, worked flawlessly!

[FleaBag]

I'm looking forward to using this, too - I just need to wait for the final version of vB (which will give me the new version of vBSEO).

[MissKalunji]

Thanks for this i tested it in a test format it works perfectly. But i'de like to change the userid from 1 to 6 (since 6 is me and i'm the one who added all those tags)

Thanks

    $db->query_write("INSERT INTO `" . TABLE_PREFIX . "tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('$tagid','$threadid','1','$dateline')");

I suppose i just change the "1" in there for 6 right?

[yakusasc]

Hi,

What about urls like forums/tags/mytag/ ? Does your script redirect them to the VB tag system ?

Tks and good job !

[Basit]

Tried but didn't worked for some reasons, get error just before the end (total tags are 25,000), but get error around 23,000 :>

[Keyser Soze]

Originally Posted by yakusasc

What about urls like forums/tags/mytag/ ? Does your script redirect them to the VB tag system ?

I am also interested in how to solve this issue. My forum is ranking very good in Google with some of the forum.mydomain.com/tags/tagname pages. I definitely need to find a solution how I can rewrite all links to tags.php on showthread.php etc.