New Posting Features - Automatic Thread Tagger

Automatic Thread Tagger


Description
When a user submits a new thread this modification will automatically take keywords from the thread title and use these as tags. You can use Automatic Thread Tagger to propose the user AJAX tags for his new thread, or it assigns new tags after saving the new thread. It can add the translated thread prefix to the tags.
Additionally, you can tag existing threads via maintenance and also scheduled tasks.

This modification is a successor to the terminated Automatic Thread Tagger by MrEyes:
https://vborg.vbsupport.ru/showthread.php?t=179927

As an example, if a user submits a thread with a title of:
"Fish Food for Cats!"

The thread will be automatically tagged with:

- Fish
- Food
- Cats

If the user also submits an actual tag of "Fish" this will not be duplicated. Any rules you have setup for tagging will be respected.
If you choose to do so this product will also automatically tag threads created by incoming RSS feeds.

Demo
I cannot show you the process of creation, but here is a list of tags generated by Auto Thread Tagger:
http://www.insideearth.net/tags.php?langid=5
http://www.insidesupcom.de/tags.php?langid=1


Automatic Tagging of existing threads
You can tag existing threads via maintenance or scheduled task/cron. They will be created with a special flag so they can be easily identified and deleted. Manual assigned tags are not touched. Maintenance is also working if Automatic Tagging is disabled via settings. Great if you want to test some settings. Automatic Tagging will take the date of the thread creation and also the userid of the creator. This process can be automated by running a scheduled job once a night.

Please keep in mind that tags that were proposed via AJAX are not tagged as auto tagged and therefore cannot be identified as such (and therefore not deleted automatically). If you want to retain the auto tagged flag you should disable AJAX and enable the tagging after the thread has been saved. As an alternative way you can also disable this and let new threads be tagged in the night from the scheduled job.


Installation / Upgrade
1. Upload all files from "upload" to your server, take care of the directory structure
2. Import "product-auto_thread_tagger110.xml" as a product, overwrite if it's already installed
3. Check settings
4. Run maintenance / Auto Tag Threads to tag existing threads (needed if you want to use the cron)

After install, and by default the modification is disabled, this will allow you to play around with configuration before switching it on.


Troubleshooting
If you report a bug please post the thread title that created it, without this I cannot test it and improve the language parsers.

* If no threads are tagged you will have to check the following:
- Is the modification enabled? Is the action you are testing enabled? (vBulletin tagging, whole auto thread tagger system, AJAX, new threads)
- Are the words you are using badwords or filtered out?

* Cron/Scheduled Task is not tagging all threads.
- The cron is limited to 500 (you can change this via settings) threads per run to avoid heavy impact on server. Make sure you run maintenance auto tagger before this to tag old threads. You can check the scheduled tasks log to see if it is running correctly.
Important: If a thread title does not meet minimum requirements to be included in tags (f.e. one word thread titles, too short words), it will be forever in this queue.

* I'm using polish, arabic, turkish, etc.. language and the tagger is not working like it should.
- If not already replaced, replace the filter replacement '&'=>'and' with ' & '=>'and' (a space before and after &)



Todo
What comes next? You decide. Tell me what you are missing and I'll look if it can be integrated.


Why thread title and not thread text?
Parsing the thread text for tags is an extremely unlikely addition as this would require some fairly heavy processing to ensure quality of tags.


What are Stopwords?
Stopwords is the name given to words which are filtered out prior to processing of tags.
The user Hostboard on vBulletin.org posted some resources regardings this:
https://vborg.vbsupport.ru/showpost....&postcount=380



History
1.2.0, 9th August 2008
- Fixed error with missing threadid's
- Fixed error with AJAX and prefix
- Fixed error with not indexing tags via cron
- Added polish, spain, english stopwords
- Compatibel with vBulletin 3.8

[Phalynx]

Originally Posted by KevinL

I just upgraded and ran the cron. Still nothing. It's not tagging the RSS feeds.

Run maintenance tools, auto tag threads. Cron is only for nightly run.
Also:
* If no threads are tagged you will have to check the following:
- Is the modification enabled? Is the action you are testing enabled? (vBulletin tagging, whole auto thread tagger system, AJAX, new threads)
- Are the words you are using badwords or filtered out?

* Cron/Scheduled Task is not tagging all threads.
- The cron is limited to 500 (you can change this via settings) threads per run to avoid heavy impact on server. Make sure you run maintenance auto tagger before this to tag old threads. You can check the scheduled tasks log to see if it is running correctly.
Important: If a thread title does not meet minimum requirements to be included in tags (f.e. one word thread titles, too short words), it will be forever in this queue.

[rsb8940]

I just applied/installed the upgrade to 1.1.0 (previously ran 1.0.1). Since then, I get this SQL Error:

-----------------

Invalid SQL:
SELECT
t.tagid
FROM tagthread as t
WHERE t.threadid= AND autotag=1;

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 'AND autotag=1' at line 4
Error Number : 1064
Request Date : Thursday, July 31st 2008 @ 11:38:06 AM
Error Date : Thursday, July 31st 2008 @ 11:38:07 AM
Script : http://support.vpi-corp.com/forum/ne...streply&t=5127
Referrer : http://support.vpi-corp.com/forum/ne...quote=1&p=7308
IP Address : #### (masked)
Username : #### (masked)
Classname : vB_Database_MySQLi
MySQL Version :

[Phalynx]

Originally Posted by rsb8940

I just applied/installed the upgrade to 1.1.0 (previously ran 1.0.1). Since then, I get this SQL Error:

-----------------

Invalid SQL:
SELECT
t.tagid
FROM tagthread as t
WHERE t.threadid= AND autotag=1;

Strange. I'm catching now the missing threadid with an "intval". The ZIP has been silently updated, please replace the functions_autotagger.php

[MadK]

The special characters auto tags got messed up after the update. The plugin would read special characters, now it shows as: "aand#304lesand#304"

http://www.mafia-mp.com/forums/

Guest account:

Username: TestAccount
Password: testaccount123

[lstintxs100]

Will update later when I get a chance. Thanks for the wisdom and hard work.

[masterross]

Thanks for update unfortunately AJAX doesnt work for me:

Line:466
Char:3
Code:0
Error:Object required
URL:http://www.my-forum.pl/newthread.php?do=newthread&f=116

And the line 466 is:

  vBAjax_ATT.onreadystatechange = m_State_ATT;

regards

[redlabour]

Bug after Updating:

Datenbankfehler in vBulletin 3.7.2:

Invalid SQL:
UPDATE vb3_thread SET autoskip=2 WHERE threadid=11616;

MySQL-Fehler  : Unknown column 'autoskip' in 'field list'
Fehler-Nr.    : 1054
Fehler-Zeit   : Thursday, 31.07.2008 @ 19:44:18
Datum         : Thursday, 31.07.2008 @ 19:44:19
Skript        : http://www.politikstube.de/forum/newreply.php?do=postreply&t=11616
Referrer      : http://www.politikstube.de/forum/newreply.php?do=newreply&p=157876
IP-Adresse    : XXXXXXXX
Benutzername  : Kiara
Klassenname   : vB_Database_MySQLi
MySQL-Version :

at Delete Auto Tags.

[Phalynx]

Originally Posted by MadK

The special characters auto tags got messed up after the update. The plugin would read special characters, now it shows as: "aand#304lesand#304"

Please keep in mind to replace the filter replacement '&'=>'and' with ' & '=>'and'

Originally Posted by masterross

Thanks for update unfortunately AJAX doesnt work for me:

Line:466
Char:3
Code:0
Error:Object required
URL:http://www.my-forum.pl/newthread.php?do=newthread&f=116

And the line 466 is:

  vBAjax_ATT.onreadystatechange = m_State_ATT;

regards

Which browser are you using?

Originally Posted by redlabour

Bug after Updating:

Datenbankfehler in vBulletin 3.7.2:

Invalid SQL:
UPDATE vb3_thread SET autoskip=2 WHERE threadid=11616;

MySQL-Fehler  : Unknown column 'autoskip' in 'field list'
Fehler-Nr.    : 1054
Fehler-Zeit   : Thursday, 31.07.2008 @ 19:44:18
Datum         : Thursday, 31.07.2008 @ 19:44:19
Skript        : http://www.politikstube.de/forum/newreply.php?do=postreply&t=11616
Referrer      : http://www.politikstube.de/forum/newreply.php?do=newreply&p=157876
IP-Adresse    : XXXXXXXX
Benutzername  : Kiara
Klassenname   : vB_Database_MySQLi
MySQL-Version :

at Delete Auto Tags.

Uninstall, install. Seems the installcode did not execute on upgrade.

[Hostboard]

Deleted tags, ran re-tag got this:

Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 35 bytes) in /home/domains/domain_name/public_html/forums/includes/functions_autotagger.php on line 408

Had to decrease tag number to 500 in order to get it to work.

[drumbo]

When I enable Disable Auto Tag if Tagged ;its still adding tags if the user has submitted tags with their post. :-(