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.

[suvari1794]

thank you.

[briansol]

Tag 329389 of 375620

Fatal error: Maximum execution time of 30 seconds exceeded in /home/xxxxxxx/public_html/includes/class_core.php on line 408

lol

i guess that's good enough

[Auron]

lve just noticed after converting the tags over that when you use the "show tag" search page, that all threads listed with the tag you searched for.. for example sake:

http://site.com/forum/tags.php?tag=stuff

you should get all threads that were tagged with word "stuff" that works well enough, HOWEVER all "thread titles" link to my main forum page (the /forum/ directory) none of the thread titles go anywhere except there, however the page numbers "do" link to the threads they are supposed to.

what l need is a way to fix this as l didnt find any references within this thread for the problem.. the weird thing is it has affected all forums l recently upgraded by the looks of it.

[Auron]

does this update fix the above issue? and how can l rebuild tags since due to the original issues and not noticing until it was too late?

[Auron]

just to update, lve retested the conversion, didnt seem to cause issues re-running altho l did the usual backup database etc just in case and it still doesnt convert the locations of the the threads, and also the forum locations of threads doesnt update either.

page numbers are fine however if the thread contains no pages you are redirected to the forum root.

[Auron]

sorry for adding another post, lve found the issue, but no closer to a solution.

l need to find a way to exclude the tags script executing zoints seo options, the url rewriting seems to break the tags links when disabled it works again.

[zappsan]

Sorry for the late response but I can't help you there.
All my hack does is convert the data to vB's tag system, it doesn't apply any template changes.

[Auron]

sadly my guess is right T_T looks like l wont be getting a fix then thanks for taking a look tho..

and just to reiterate, its a url rewriting issue, assumed template originally but its actually an issue because its trying to rewrite the urls.

[TacticalNuke]

I disabled the Zoints tags in the product manager prior to upgrade, then did this conversion, then uninstalled it, now I'm getting this error (by, I presume, google searches):

Warning: main([path]/includes/class_zointstags.php) [function.main]: failed to open stream: No such file or directory in [path]/tags/index.php on line 304

Fatal error: main() [function.require]: Failed opening required '/home/*****/public_html/includes/class_zointstags.php' (include_path='/usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php') in /home/*****/public_html/tags/index.php on line 304

By the way, I only copied the tags folder over from my old forum directory to the new one after the upgrade, I didn't put all the Zoints stuff back since it was disabled.

Also, this is what I get e-mailed (the above is from the browser):

Invalid SQL:

SELECT zoints_tag.tag, COUNT(*) count FROM zoints_tag zoints_tag
LEFT JOIN thread thread ON(zoints_tag.threadid = thread.threadid)
WHERE thread.forumid IN(43,44,1,2,3,4,5,6,13,21,19,20,26,27,31,15,39,14 ,41,22,47,29,23,38,16,33,18,45,36,37)

AND autogen != 1
GROUP BY zoints_tag.tag
ORDER BY count DESC
LIMIT 30;

MySQL Error : Table '*****_forum2.zoints_tag' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 9th 2008 @ 08:49:08 AM
Error Date : Wednesday, July 9th 2008 @ 08:49:08 AM
Script : http://www.serviceacademyforums.com/...eal/search.php
Referrer :
IP Address : 76.189.85.129
Username : **********
Classname : vb_database
MySQL Version : 4.1.22-standard

[zappsan]

You think Google search produces this error? Maybe this could be the case, if people are trying to access tags on your site by using yourdomain.com/tags/sometag. If you would have everything removed from the Zoints tags system, you'd get a 404 error, but since some files are still there, it's trying to make use of the tag system (which has been partially removed) and so you get the error.
I suggest you delete the Zoints tags folder and redirect yourdomain.com/tags/sometag to the vB tag system format which is yourdomain.com/tags.php?tag=sometag so people won't get a 404 error when they try to access your page by using the old tag link.
I hope you understand what you mean.