Author: viragotech » Fri Sep 17, 2010 5:15 pm
where does it output the most common words?
it ran fine but dunno where to find what it found?
## If you want to find your most commonly used words, so you can put some of them into this blacklist,
## you can run the following db query in phpmyadmin, before running this mod :
##
## SELECT swl.word_id, swl.word_text, COUNT(swm.word_id) as total
## FROM `phpbb_search_wordlist` swl, `phpbb_search_wordmatch` swm
## WHERE swl.word_id = swm.word_id
## GROUP BY swm.word_id
## ORDER BY total
## DESC LIMIT 0,50