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]

Make sure you are running 3.2.0 RC4. Enable the 2nd tag structure rewrite. Perform the file edits in the below thread.

http://www.vbseo.com/f9/how-rewrite-tag-url-22739/

[MissKalunji]

great thanks

[Sal Collaziano]

Originally Posted by MissKalunji

uh? you were getting loads of database message about what?

having connect error?

or you mean that the spiders are getting 404?

My zoints tags were spidered and listed in the search engines. When people clicked the links (from the search engines), they'd get a database error (which I was informed of) because the page didn't exist.

I reinstalled Zoints Tags. Once you use them, you cannot stop using them. This conversion will only convert Zoints tags to the new system. You cannot disable the Zoints tags - unless you're not receiving any traffic through them. If that's the case, than they didn't do anything for you anyway...

[MissKalunji]

it shouldn't give them no database error unless you still have the zoint files on your server?

it should give them a 404 error or if you have vbseo or i think you're able to set that in htaccess forwarding back to your main forum.

I had zoint tag installed i used this and took of zoint i had a bunch of tags indexed they went straight to the main forum page til vbseo updated and now supports the old zoint tag url format

[Neutral Singh]

Works flawlessly!! Now i can remove zoints finally. Though i love Zoints. It served my forums a great deal.

[imranbaig]

Thanks, Tried on 3.7 Gold Worked like Charm

[Fırtına]

Error: Thread 5236 of 6221

Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE `thread` SET taglist='dİsk'e, emre ak?z, ergenekon'dan, ka?arken, yakalanmak' WHERE threadid=5356;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'e, emre ak?z, ergenekon'dan, ka?arken, yakalanmak' WHERE threadid=5356' at line 1
Error Number  : 1064
Request Date  : Friday, May 16th 2008 @ 01:25:54 AM
Error Date    : Friday, May 16th 2008 @ 01:26:14 AM
Script        : http://www.********.net/converttags.php
Referrer      : 
IP Address    : 77.****************
Username      : Fırtına
Classname     : vB_Database
MySQL Version : 4.1.22-standard

[Mecho]

wow seems that it converted alllllllllll the TAGS !!

Thanks alot man

[RC.]

wowww great, works very fine... thanks.

[Mecho]

EDIT : "Everything is FINE and this mod works like a charm ."