This is regarding phpbb3 SEO Dynamic Meta Tags V0.2.0RC1

I am using phpBB3 RC7

I completed the mod and it is dynamically creating meta just fine, but it is not excluding terms in the "search_ignore_words.php" file.

I notice the demo at http://phpbb3.phpbb-seo.net/ is also including meta keywords in the default "search_ignore_words.php" file.

Was I wrong in reading the instructions that this is supposed to be happening?

Thanks.

Well, the mod does query for the most used words within the whole forum that are used in the topic's first post of a given thread from the search tables, in viewtopic.php :

Code: Select all

   // www.phpBB-SEO.com SEO TOOLKIT BEGIN  - META
   if ($i == 0) {
      $m_kewrd = '';
      $seo_meta['meta_desc'] = meta_filter_txt(word_limit($message));
      $sql = "SELECT w.word_text
         FROM " . SEARCH_WORDMATCH_TABLE . " m, " . SEARCH_WORDLIST_TABLE . " w
         WHERE m.post_id = {$row['post_id']}
            AND w.word_id = m.word_id
            ORDER BY w.word_count DESC LIMIT 20";
      if( ($result = $db->sql_query($sql)) ) {
         while ( $meta_row = $db->sql_fetchrow($result) ) {
            $m_kewrd .= " " . $meta_row['word_text'];
         }
      }
      $db->sql_freeresult($result);
      $seo_meta['keywords'] = !empty($m_kewrd) ? make_keywords($m_kewrd) : make_keywords($seo_meta['meta_desc']);
   }
   // www.phpBB-SEO.com SEO TOOLKIT END  - META

If the query does not return any result, for example if you have problems with your search tables, the meta description, build with the beginning of the first post will be used instead (most used word first in both cases).

So, if you saw excluded words on forums, it's normal, the search_ignore_words list is not checked for them so far, it's only (indirectly) used for topics.

I'm not sure it would be this worth it for forums, since the meta are then build out forum title and description, we already are able to use our best keywords in there for each.

++

I'm using the phpBB3 3.0.1 premod.

and with the same problem, the meta keywords are not reflecting the search_ignore_words.php file. Yes, the keywords seem to be coming from the first post. I have rebuild the search tables within phpbb admin and don't what else to do. Everything else seems in order, but would love just content specific keywords.

Question: when installing the premod, doesn't in change the mysql search tables? Do I need to update them?

Forgive me if I'm blind

Cheers

No, the mod does not change the phpBB DB besides adding an entry in the acp module list for the phpBB SEO acp.

So you need to rebuild search table every time you change the search_ignore_words.php.

Then, words listed there should not show up in the topic metas, the only one to play with these exclusions.

URL of you forum ?

I'm also facing two problems with "phpbb3_seo_dynamic_meta_tagsV0-2-4"

One problem is.. Most of the dynamic keyword read bbcode... like if i post a image

Code: Select all

[img] http://www.websitename.com/cameron%20diaz/1.jpg[/img]

it reads 20diaz most of the time out of this bbcode... but this problem not seems to be with ur mod... phpbb search table reading those contents too... I saw the contents of phpbb search wordlist table it has all the image bbcode word there (like imageshack & photobucket and other subdomain information)

Second problem is how to create a complete keyword like "Funny Pics".. "Funny Video".. by using this dynamic keyword.. keyword r like "funny, pics" this... this degrade keyword value when doing SEO

Can u please help me regarding this...

Sorry for my poor english..

SeO wrote:No, the mod does not change the phpBB DB besides adding an entry in the acp module list for the phpBB SEO acp.

So you need to rebuild search table every time you change the search_ignore_words.php.

Then, words listed there should not show up in the topic metas, the only one to play with these exclusions.

URL of you forum ?

Unfortunately PHPBB3 does not use search_ignore_words.php at all, so the contents of that file do not matter at all. From phpBB3's own forum posts I saw that they are not going to implement support for ignore words either. There was a topic here where I told the same thing, with links to the discussion at phpBB forums.

phpBB3 only uses the "common words" feature.