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.

[Fırtına]

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

This post not replyed? please help...

[zappsan]

Originally Posted by Mecho

just one weird problem !

i have prefixes in all threads and sections now expect just one section !!!!! and we have tons of threads in that section . what shall i do ??
Prefixes? Do you mean tags?
Any idea ??

Originally Posted by Fırtına

This post not replyed? please help...

I will take a look at this, I didn't have time yet, sorry for the late response.

[Fırtına]

After converting all pages indexed in google for my web site redirected as + symbol.

http://www.sisligece.net/tags/ne-oldugu-uzerine/ < Please click is URL (error resolved). http://www.sisligece.net/tags/ne+oldugu+uzerine/ < or click this URL (error not resolved).



All pages indexed in Google for - . How do changing + is to this -

[maxicep]

That settings about interesting with vbseo plugin.

Go
www.vbseo.com Turkish Section

[Amenadiel]

for some odd reason, this plugin does nothing on my forum

Converting...



Updating threads...



Done!

And nothing's changed

Edit: Solved! this script only works if you configure your db connection to use mysql instead of mysqli.

[Chadi]

I ran this, uninstalled zoints and then checked a few threads. No tags are found. I did not encounter any errors during the file run. The default VB tags was also enabled prior to the run as well. I even ran Rebuild Thread Information too.

[zappsan]

Originally Posted by chadi

I ran this, uninstalled zoints and then checked a few threads. No tags are found. I did not encounter any errors during the file run. The default VB tags was also enabled prior to the run as well. I even ran Rebuild Thread Information too.

Did you check if there are any tabs in the database?
Maybe you are having the same problem as this person -> https://vborg.vbsupport.ru/showpost....6&postcount=65

[web_styler]

3.7.0 Turkish karakter problems

alexa-s-ralamas-neye-gore-t problem ö,ı,ç,ü, vsvs Carecters problem

[libertylounge]

Worked perfectly for me with 3.7.1 ..thank you SO MUCH for writing this.

[delinetciler]

T?rk?e karakter sorunun ??z?m? burada