View Single Post
  #252  
Old 09-22-2009, 12:57 AM
NLP-er's Avatar
NLP-er NLP-er is offline
 
Join Date: Aug 2008
Location: Wrocław
Posts: 1,353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by turbosatan View Post
how do i delete the tags?

this seems to have just created hundreds and hundreds of totally nonsense tags .

the options menu item doesn't show anything in the backend either

How do i remove all the tags it has created?
This mod creates only tags which you approve - manually or setting quarantine time. So you have only what you approved

Please read configuration options descriptions carefully and set mod to work as you want it to work. You can easily configure it to not create any new tags and only associate already existing with new posts. Also read mod description where you have noted which vB native options are respected by this mod

You can delete tags by Admin CP, or by SQL. In 2nd case you can use query like this (I didn't check it so do corrections yourself if there is some typo or syntax issue):
Code:
DELETE tag FROM tag INNER JOIN tag_proposition WHERE tag_proposition.status=4 and tag_proposition.tagtext=tag.tagtext
This will remove only tags which was made automatically after quarantine (status = 4). If you want to remove also propositions (will be proposed again if occurs in new posts), then execute this query:
Code:
DELETE tag, tag_proposition FROM tag INNER JOIN tag_proposition WHERE tag_proposition.status=4 and tag_proposition.tagtext=tag.tagtext
Note that it is wise to clear all tags associations after that and generate it again (see mod options). And it it even wiser to close forum for minute, clear all associations, delete automatically created tags, generate association again and turn forum on
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01181 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete