[Toolkit] Optimizing phpBB meta keywords

phpBB mods by phpBB SEO.

Moderator: Moderators

Postby dcz » Thu Jul 13, 2006 2:10 pm

Hu, the charset joy :D

I though it was worth it to give it a try utf-8 => latin then cut the word under three letters then utf-8, but it's just toeasy to work it seems.

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Advertisement

Postby AmirAbbas » Thu Jul 13, 2006 3:30 pm

excuse me i couldn't understand :roll:
User avatar
AmirAbbas
phpBB SEO Team
phpBB SEO Team
 
Posts: 534
Joined: Thu May 11, 2006 3:30 pm
Location: IRAN

Postby dcz » Thu Jul 13, 2006 3:40 pm

well, my idea was to convert utf-8 to latin prior to filter it with giefca's code working with latin charset and then to convert it back to utf-8, where all words under 3 letters would have been filtered.

But it's not this simple it seems :roll:
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Postby AmirAbbas » Thu Jul 13, 2006 3:45 pm

ok

but i think it needs lot of work to writing code for this purpose :roll:
User avatar
AmirAbbas
phpBB SEO Team
phpBB SEO Team
 
Posts: 534
Joined: Thu May 11, 2006 3:30 pm
Location: IRAN

Postby AmirAbbas » Sun Jul 16, 2006 6:20 am

:roll: excuse me , another question

can i use this mod without keyword metatag
keyword metatag in this mod is not suitable for my language
giefca fix doesn't work for persian and for some reason we are not able to use search_stopwords.txt file.

can i remove keyword section of this mod
is it standard to have description meta tag and don't have keyword metatag :?:
User avatar
AmirAbbas
phpBB SEO Team
phpBB SEO Team
 
Posts: 534
Joined: Thu May 11, 2006 3:30 pm
Location: IRAN

Postby dcz » Sun Jul 16, 2006 11:03 am

Yes off course.

Just delete those part in the code, so you don't search for keywords for nothing :

Code: Select all
        $sql = "SELECT w.word_text
                FROM " . TOPICS_TABLE . " t, " . SEARCH_MATCH_TABLE . " m, " . SEARCH_WORD_TABLE . " w
                WHERE t.topic_first_post_id = m.post_id
                AND m.word_id = w.word_id
                AND t.topic_id = $meta_topic_id LIMIT 20";
        if( ($result = $db->sql_query($sql)) ) {
      $keywords = '';
      while ( $meta_row = $db->sql_fetchrow($result) ) {
         $keywords .= ($keywords == '') ? $meta_row['word_text'] : ',' . $meta_row['word_text'];
      }
        }


and :

Code: Select all
         $keywords = $board_config['sitename'] . ', ' . $meta_row['cat_title'] . ', ' . $meta_row['forum_name'] . ', FEW_MORE_KEYWORDS_COMA_SEPARATED';


and :

Code: Select all
         $keywords = $board_config['sitename'] . ', ' . $meta_row['cat_title'] . ', FEW_MORE_KEYWORDS_COMA_SEPARATED';


and :

Code: Select all
$phpbb_meta .= '<meta name="keywords" content="' . $keywords  .'" />' . "\n";


and you're done ;)
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Postby AmirAbbas » Mon Jul 17, 2006 4:04 am

thanks :D
User avatar
AmirAbbas
phpBB SEO Team
phpBB SEO Team
 
Posts: 534
Joined: Thu May 11, 2006 3:30 pm
Location: IRAN

Postby Peter77 » Mon Aug 07, 2006 6:19 am

For some reason, viewing topics, there are no keywords showing. its blank. I did run into one thread where the content had kewwords in it. what should I be checking? I do have search_stopwords.txt in my launguage file and search_synonyms.txt too.
Peter77
phpBB SEO Team
phpBB SEO Team
 
Posts: 520
Joined: Wed May 10, 2006 9:46 am
Location: Michigan

Postby dcz » Mon Aug 07, 2006 11:09 am

Well I do see meta keywords for your topics.

Could you post an URL to a problematic topic ?

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Postby Peter77 » Wed Aug 09, 2006 4:50 am

Hmm, I guess I was wrong. seems to be working correctly.

Is there really a better benefit in having different meta keywords in topic pages?

Because I see a lot of ....

"click,for,get,good,here,how,its,link,not,shared,sharing,the,this,will,with,you,50s,60s,70s,musica">


for keyword content In my topics....

wouldn't it be better off using normal meta tag instead of random words? normally these are words that google ignores in thier searches anyway.... BUT if it actually makes a difference having diffrent content for meta keywords, then nevermind. spider bots like different content anyway, right?
Peter77
phpBB SEO Team
phpBB SEO Team
 
Posts: 520
Joined: Wed May 10, 2006 9:46 am
Location: Michigan

Postby dcz » Wed Aug 09, 2006 10:40 am

Well, actually, all of those are part of the topic messages.
It's the main interest of this part of the mod, we at least provide honest informations about the page content as the keywords shown in the meta keywords are really in the content.

Then, you can narrow the possibilities to output better ones with you search_stopwords.txt.

terms such as its, for, the, get, not, you, 50s, 60s, 70s, with could be trashed ;)

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Postby JanoF » Sat Oct 07, 2006 10:20 pm

Shall I coding UTF8 and doesn't create me all right keywords nor' descriptions, that would to have been needs repair that this operate right?

Code: Select all
<meta name="keywords" content="administrăˇtorov,ako,alebo,aseldof,banu,bruce,dvojităˇ,dă´vod,edităˇcie,făłra,făłre,istă©,jajooo,janofa,jarof,konto,konäťă­m,kopirovanie,krăˇl,ktoră˝" />
User avatar
JanoF
 
Posts: 43
Joined: Tue May 30, 2006 4:01 pm

Postby dcz » Sun Oct 08, 2006 10:39 am

UTF-8 is not easy to deal with in this matter, this is being discussed just few post above, look at this post ;)
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Postby tweety » Wed Jan 24, 2007 1:58 am

what is this utf-g and latin charset? how do you find out and can you change it? i am doing site aimed at uk
tweety
PR0
PR0
 
Posts: 94
Joined: Wed Jan 24, 2007 1:29 am

Postby tweety » Wed Jan 24, 2007 2:11 am

i have check my phpadmin and it is showing the database as

Database Ascending Collation
tollens_mighty latin1_general_ci
information_schema utf8_general_ci
Total: 2 latin1_swedish_ci

tollens_mighty is the database i use is this OK

i do not understand why the latin is swedish mmmmm????
is this OK
tweety
PR0
PR0
 
Posts: 94
Joined: Wed Jan 24, 2007 1:29 am

PreviousNext

Return to phpBB2 SEO TooLKit

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 1 guest