vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Administrative and Maintenance Tools - Convert Zoints Thread Tags to vB 3.7 tagging system (https://vborg.vbsupport.ru/showthread.php?t=170314)

zappsan 02-11-2008 10:00 PM
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.

dirtycrow 02-12-2008 03:44 PM
looked soo promising until it gave a Mysql error will processing 370 of 5550 tags.

zappsan 02-12-2008 03:51 PM
Which error did you get?

Zaiaku 02-12-2008 05:12 PM
You know original I was going to do without importing them over since it asn't really that big of a deal but then since you just helped me out here 1 less thing to do without. Thx!

birdie 02-12-2008 06:11 PM
THANK YOU. My use of Zoints tags in 3.6 is the reason I was not going to update to 3.7! I will get back to considering it now!

FleaBag 02-12-2008 08:00 PM
Zoints Tags works just fine with vB 3.7, as I use it myself! :)

But this is great, I wanted to move over to the vB system but this is what was holding me back. I'll give this a whirl later tonight.

Thanks.

dirtycrow 02-13-2008 02:36 AM
Quote:
Originally Posted by zappsan (Post 1441523)
Which error did you get?
this one

Quote:
Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
INSERT INTO `tagthread` (`tagid`, `threadid`, `userid`, `dateline` ) VALUES ('142','47370','1','1202835441');

MySQL Error : Duplicate entry '142-47370' for key 1
Error Number : 1062
Date : Tuesday, February 12th 2008 @ 11:57:21 AM
Script : http://forums.xxx.com/converttags.php
Referrer :
IP Address : xxx
Username : xxx
Classname : vb_database
MySQL Version : 4.1.22-standard~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

hckby 02-13-2008 06:30 AM
Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.

FleaBag 02-13-2008 09:21 PM
I will hold off for now with an install, but hope to install soon! :)

kafi 02-14-2008 10:14 AM
GREAT GREAT, please fix the issue!!!

Milion Thanks!!!

zappsan 02-14-2008 11:45 AM
Quote:
Originally Posted by hckby (Post 1441989)
Database error in vBulletin 3.7.0 Beta 4:

at the end of the converting.
Which error did you get? The same dirtycrow got?
Quote:
Originally Posted by kafi (Post 1442798)
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 02-15-2008 11:57 PM
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 :D

maxicep 02-18-2008 12:07 AM
it works fine, thanks

just some words are bad like quotvbulletin :)

ZiG 02-20-2008 05:32 AM
crashed for me at tag 758

Quote:
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 03-09-2008 08:01 PM
Tried it out during my update to a heavily modded beta6, worked flawlessly!

FleaBag 03-09-2008 11:47 PM
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 03-21-2008 06:16 AM
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 :)

Code:
    $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 03-21-2008 07:24 AM
Hi,

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

Tks and good job !

Basit 03-22-2008 12:47 AM
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 04-02-2008 04:35 PM
Quote:
Originally Posted by yakusasc (Post 1470490)
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.

skiseiju 04-12-2008 04:34 PM
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 04-13-2008 02:29 AM
Quote:
Originally Posted by MissKalunji (Post 1470465)
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 :)

Code:
    $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.
Quote:
Originally Posted by yakusasc (Post 1470490)
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.
Quote:
Originally Posted by Basit (Post 1471216)
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.
Quote:
Originally Posted by skiseiju (Post 1489156)
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 04-13-2008 02:53 AM
worked perfectly :) thanks again!

skiseiju 04-13-2008 01:19 PM
Quote:
Originally Posted by zappsan (Post 1489468)
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 04-13-2008 02:23 PM
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 :D


MOTM for sure!

GrendelKhan{TSU 04-16-2008 10:13 PM
got this error towards the end of running the script (at Tag 5139 of 5153)


Code:
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 04-17-2008 01:08 AM
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 04-17-2008 02:44 PM
Nothing happens here?
I just see :
Quote:
Converting...



Updating threads...



Done!

sensimilla 04-18-2008 02:48 PM
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! :D :D

zappsan 04-19-2008 02:33 AM
Quote:
Originally Posted by skiseiju (Post 1489703)
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.
Quote:
Originally Posted by GrendelKhan{TSU (Post 1492527)
got this error towards the end of running the script (at Tag 5139 of 5153)


Code:
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.
Quote:
Originally Posted by elmati (Post 1492607)
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.
Quote:
Originally Posted by 993ti (Post 1493010)
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?

FleaBag 04-20-2008 01:38 AM
Thanks for the update, I will be able to give this a run through soon (when vB is released, and thus the new vBSEO).

993ti 04-20-2008 10:26 PM
Quote:
Originally Posted by zappsan (Post 1494236)
Seems like it doesn't find any tags to convert. Are you sure your Zoints tags table isn't empty?
Not empty: 15,712 records
Strange though, no errors

Edit: Tried it on another site of mine and it works.
Strange, why doesn't it work on my main site :?

Edit 2:
Found what's causing it.
In config.php i had database type set to Mysqli, i changed that to Mysql and it works ;)

elmati 04-21-2008 12:36 AM
Quote:
Originally Posted by zappsan (Post 1494236)
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.
ok, tags disapear in every thread, but if a click "edit tags" there are tags in thread and i need to add new tag to see olders, i think i have to update the database...

i dont find in update counters an update tags link...
see my attachments, same thread when i click in edit tags they are some tags there! :)

zappsan 04-21-2008 04:45 PM
Quote:
Originally Posted by 993ti (Post 1495432)
Not empty: 15,712 records
Strange though, no errors

Edit: Tried it on another site of mine and it works.
Strange, why doesn't it work on my main site :?

Edit 2:
Found what's causing it.
In config.php i had database type set to Mysqli, i changed that to Mysql and it works ;)
Good to know you managed to fix it :)
Quote:
Originally Posted by elmati (Post 1495478)
ok, tags disapear in every thread, but if a click "edit tags" there are tags in thread and i need to add new tag to see olders, i think i have to update the database...

i dont find in update counters an update tags link...
see my attachments, same thread when i click in edit tags they are some tags there! :)
Like already said, my script will update the threads so you'll see older tags when you view a thread. It isn't showing up for you, because you got an error message while running the script so it didn't get to the part where the threads get updated. Try running the new version. If you don't get any errors, the threads should all be updated.

elmati 04-21-2008 09:01 PM
Ok, tonite ill run the new version :)

Thanks zappsan!

elmati 04-22-2008 01:49 AM
Hey Zappsan i run the converter again and everything works fine!

Thanks a lot for your help :)

Very usefull, ty a lot!

bada_bing 04-22-2008 02:13 AM
Will this work for the zoints thread tags for vb 3.5.x ?

elmati 04-22-2008 05:03 AM
i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!

zappsan 04-22-2008 01:24 PM
Quote:
Originally Posted by bada_bing (Post 1496281)
Will this work for the zoints thread tags for vb 3.5.x ?
Quote:
Originally Posted by elmati (Post 1496335)
i think u first need to upgrade to vbulletin 3.7 in order to use this converter...
new version works perfect!
That's correct.
You need to upgrade 3.7 first, so you've got the new tag tables in your database. You also need to keep the Zoints tag table.

Glad to see the new version is working :)

Rik Brown 04-23-2008 03:17 AM
We de-Zointed our forums several months ago. But I did like how the Zoints tagging created new tags since we use the NNTP Gateway that imports Usenet Newsgroup messages. We then ran the Zoints tagging against those imported messages.

Question: Can both the Zoints tagging and new vb 3.7 tagging systems co-exist on an ongoing basis where we first run Zoints tagging and then run vb tagging via this mod (say, weekly)? Or, is this mod normally to be run on a one-time basis and then discontinue the prior Zoints tagging?

Please advise. Thanks. -- Rik


All times are GMT. The time now is 06:33 AM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01407 seconds
  • Memory Usage 1,848KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_php_printable
  • (22)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete