Integration with vBulletin - Zoints Thread Tags - GREAT for SEO

Demo:

http://network.zoints.com/tags

If you choose to send tags to Zoints (optional) you can see what we do with them and how we send you traffic and nice inbound links: http://zoints.com

A great article on the importance of tagging can be read here.

The Zoints Thread Tags System will improve forum side search, SEO, and traffic for forums that choose to utilize it. And in my opinion, it's just plain cool

When a member creates a new thread, they can now input a series of "tags". Tags are simply keywords that describe the thread.



If you then go to your-forum.com/tags you will be presented with what is called a "tag cloud". The more times a tag is used, the larger the text grows. As you can see, the tags are also searchable.



Clicking on one of the tags in the cloud then lists all of the threads that are tagged with that particular keyword. The default option lists tags in a forumdisplay format. There is an option in the admincp to use a simple format.



Clicking on the thread title of one of the above threads then takes you to the thread. If you have the option on, the tags the thread are tagged with are also listed above the thread. Clicking one of those tags takes you to all the threads on the forum tagged with the same tag. Search engine spiders are going to have a field day with this



The thread starter and moderation staff have a slightly different view which allows for administration of tags:



The forum's tags are also searchable via the search dropdown. The advanced search option allows for a variety of additional criteria to be seached for. Your members create a whole new (and highly efficient) forum search engine!



If you have the option on in the admincp and register your forum, once every hour, your tagged threads in publically viewable forums are linked via the corresponding interest tag on the Zoints Forum Network. For example, if you go to http://zoints.com/tag/children you will see what is pictured below. Not only is this a great relevant inbound link for SEO, but you will get traffic from Zoints direct to these threads!

Another example of this in action: http://zoints.com/tag/music




The admincp options

















Official support for this modification will be at http://network.zoints.com in this forum.


Change log:
2008/05/01 - 1.2.3
* vBulletin CSRF Protocol Compatible
2007/12/24 - 1.2.2
* Security patch

2006/10/24 - 1.2.1
* Bugfix: breaking inline moderation when tag cloud below posts
* Bugfix: ajax input not working when tag cloud below posts
* Bugfix: seo hook effective for "results as threads" option
* Bugfix: Autogenerated tags have "quot" removed
* Bugfix: Automated template edit screwing up styles
* Improved instructions for manual template edits

2006/10/19 - 1.2.0
* Option to display results as threads
* Advanced search page
* Popular tag cloud pagination
* Popular tags displayed in forums
* Option to display tags in showthread at the top/bottom
* Fix for vbadvanced products navbar links
* Other minor fixes and tweaks

2006/10/02 - 1.1.2
* Bugfix: Foreign language characters in thread description
* Bugfix: Commas showing up when removing first tag in showthread via ajax
* Removing some redundancy in the tags AJAX removal

2006/09/30 - 1.1.1
* Bugfix: Preventing all HTML from being parsed inside tag descriptions

2006/09/30 - 1.1.0
* Adding and deleting tags from showthread via AJAX
* Mass-deleting single tags from entire cloud for admins
* Automatically generate tags for older threads (with option to show or hide on main cloud)
* Automatically stripping out tiny (2 or less characters) tags

2006/09/28 - 1.0.8
* Minor bugfix

2006/09/28 - 1.0.7
* Bugfix for required tagging

2006/09/28 - 1.0.6
* Character replacements
* Tag limit per thread
* Option to require tags for a thread
* Bugfix where stopwords may not have worked properly
* Bugfix for vBSEO / main cloud not showing up

2006/09/xx - 1.0.5
* Unreleased dev build

2006/09/23 - 1.0.4
* Ability to add multiple tags via showthread.php
* Ability to exclude certain forums from utilizing tags
* Addition of custom hook for developers to change thread urls

2006/09/21 - 1.0.3
* Ability to add and remove tags from showthread.php
* Bugfix for older versions of mysql

2006/09/21 - 1.0.2
* Small bugfix

2006/09/20 - 1.0.1
* Showing tags list on showthread.php

2006/09/20 - 1.0.0
* Initial release

[SaN-DeeP]

Another problem, after auto-generating old threads with Aut-TAG system.
If I am mass-pruning bunch of threads, this threads are not removed from tag system.

I have pruned nearly 50000 old threads from a total of 200000 threads on our forums, Zoints tag table is still the same size..

[justim123]

It doesnt replace characters; it shows 0131 for the place of a character. All replaced characters changed to this kind of values.

[Snake]

Help me please. Somone!

[s25]

Ask on the vBSEO forums its usualy there thing to fix!

[Zoints]

Originally Posted by Snake

Also I'm using vBSEO and the thread URLs, last post, etc. aren't rewriting. What could be the problem here?

See this thread

[Zoints]

Originally Posted by SaN-DeeP

Another problem, after auto-generating old threads with Aut-TAG system.
If I am mass-pruning bunch of threads, this threads are not removed from tag system.

I have pruned nearly 50000 old threads from a total of 200000 threads on our forums, Zoints tag table is still the same size..

Aye, that is a known issue that will be fixed.

[Zoints]

Originally Posted by mtlcore

Great mod! Is there a way to show the tag cloud on a wordpress blog? and/or forum home?

Not at this time.

[993ti]

Originally Posted by 993ti

Still stuck with this part:

Anyone know what to do if i want the tag url to show tags/nissan instead of tags/index.php/nissan?

Fixed it by adding this line to the htaccess file:

RewriteBase /tags

[vppremier]

I've made a mistake I believe. I think that I selected all forums to not display the tags, thinking I was enabling tags on them. So I then went and tried to reupload the xml file via the mange products option and I got the following error
-------------------------

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Zoints Thread Tags', 'admin_options_processing', 'if ($oldsetting[\'varname\'] == \'zointstags_disable_forums\')\r\n{\r\n $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] = array_filter(array_map(\'intval\', $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]));\r\n # verify existence of forums\r\n foreach ($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] as $key => $forumid)\r\n {\r\n if (!isset($vbulletin->forumcache[$forumid]))\r\n {\r\n unset($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']][$key]);\r\n }\r\n }\r\n \r\n if (count($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]))\r\n {\r\n $vbulletin->input->clean_gpc(\'p\', \'zointstags_auto_delete_invalid_tags\', TYPE_BOOL);\r\n if ($vbulletin->GPC[\'zointstags_auto_delete_invalid_tags\'])\r\n {\r\n # get threadids\r\n $threadids = array();\r\n $_threadids = $vbulletin->db->query_read(\"\r\n SELECT DISTINCT thread.threadid FROM \" . TABLE_PREFIX . \"thread thread\r\n LEFT JOIN \" . TABLE_PREFIX . \"zoints_tag zoints_tag ON(zoints_tag.threadid = thread.threadid)\r\n WHERE zoints_tag.tag IS NOT NULL\r\n AND thread.forumid IN(\" . implode(\',\', $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]) . \")\r\n \");\r\n while (list($threadid) = $vbulletin->db->fetch_row($_threadids))\r\n {\r\n $threadids[] = $threadid;\r\n }\r\n \r\n if (count($threadids))\r\n {\r\n $vbulletin->db->query_write(\"DELETE FROM \" . TABLE_PREFIX . \"zoints_tag WHERE threadid IN(\" . implode(\',\', $threadids) . \")\");\r\n # also delete tags from zoints\r\n $bits = array();\r\n foreach ($threadids as $id)\r\n {\r\n $bits[] = \"($id, \" . TIMENOW . \")\";\r\n }\r\n $vbulletin->db->query_write(\"REPLACE INTO \" . TABLE_PREFIX . \"zoints_tag_update (threadid, dateline) VALUES \" . implode(\',\', $bits));\r\n }\r\n }\r\n }\r\n \r\n $vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']] = serialize($vbulletin->GPC[\'setting\'][$oldsetting[\'varname\']]);\r\n}', 'zointstags');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Friday, December 29th 2006 @ 08:31:36 AM
Script : http://stepinthezone.com/forum/admincp/plugin.php
Referrer : http://stepinthezone.com/forum/admin...?do=productadd
IP Address : Mp ip
Username : My username
Classname : vb_database

How can I fix this? How can I reinstall?

[993ti]

You have VB 3.5.4 this is the 3.6.x version.
The 3.5.x version can be found here