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.

[skiseiju]

i have some error like

"
Converting...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /converttags.php on line 14

Updating threads...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /converttags.php on line 44
"
what should i do?

[zappsan]

Originally Posted by 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?

Yeah. Also don't forget to change it twice. The query is mentioned in the script twice.

Originally Posted by yakusasc

Hi,

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

Tks and good job !

Nope, all it does is convert the database entries to the new system.

Originally Posted by 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 :>

I assume you got the same error like the ones posted before?
I'll try to fix it, but I haven't had time to look at it yet and don't know when I will.

Originally Posted by skiseiju

i have some error like

"
Converting...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /converttags.php on line 14

Updating threads...

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /converttags.php on line 44
"
what should i do?

Are you sure everything is right with your zoints tags table?

[MissKalunji]

worked perfectly thanks again!

[skiseiju]

Originally Posted by zappsan

Are you sure everything is right with your zoints tags table?

Sorry, i don't understand what's that mean.
My zoints tags is work fine , everything should be ok.
May something wrong i couldn't see?

[sensimilla]

Outstanding! worked like a charm, I have been waiting for it for sooo long, You just made my day.

After removing zoints profile now this I am completly deZoinded now free and happy


MOTM for sure!

[GrendelKhan{TSU]

got this error towards the end of running the script (at Tag 5139 of 5153)

Database error in vBulletin 3.7.0 Release Candidate 1:

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

MySQL Error   : Duplicate entry '1-20590' for key 1
Error Number  : 1062
Date          : Wednesday, April 16th 2008 @ 07:12:14 PM
Script        : http://ww ************* .com/forums/converttags.php
Referrer      : 
IP Address    : **************
Username      : GrendelKhan{TSU}
Classname     : vB_Database
MySQL Version : 4.1.22-standard-log

[elmati]

i run the converter but i have the same issue than others Duplicate entry '1-20590' for key 1...
the converter add the tags but the tags dont appear in the threads, so what i have to do?

EDIT: when i edit the tags in some thread the tags appear and i need to add some new tag to see the others...
i dont understand LOL :P

[993ti]

Nothing happens here?
I just see :

Converting...



Updating threads...



Done!

[sensimilla]

It went smooth but my tags are still sent to zoints even while Ive uninstalled zoints plugin..
default vbulletin tags are now sent to zoints!

[zappsan]

Originally Posted by skiseiju

Sorry, i don't understand what's that mean.
My zoints tags is work fine , everything should be ok.
May something wrong i couldn't see?

It's hard to say what it is, I added some code which will display a better error message, you can try it again.

Originally Posted by GrendelKhan{TSU

got this error towards the end of running the script (at Tag 5139 of 5153)

Database error in vBulletin 3.7.0 Release Candidate 1:

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

MySQL Error   : Duplicate entry '1-20590' for key 1
Error Number  : 1062
Date          : Wednesday, April 16th 2008 @ 07:12:14 PM
Script        : http://ww ************* .com/forums/converttags.php
Referrer      : 
IP Address    : **************
Username      : GrendelKhan{TSU}
Classname     : vB_Database
MySQL Version : 4.1.22-standard-log

I have looked at this error (since you haven't been the only one) and couldn't really find out why this is happening. The error would happen whenever the same tag is added to the same thread twice, but Zoints actually doesn't let you do that. Anyway, I've added something which should most likely prevent this, but I can't be certain it does, since I've never had that problem with my own forums' tags. Try running the newer version file which I'm going to add right now.

Originally Posted by elmati

i run the converter but i have the same issue than others Duplicate entry '1-20590' for key 1...
the converter add the tags but the tags dont appear in the threads, so what i have to do?

EDIT: when i edit the tags in some thread the tags appear and i need to add some new tag to see the others...
i dont understand LOL :P

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.

Originally Posted by 993ti

Nothing happens here?
I just see :

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