- Code: Tout sélectionner
//BEGIN www.phpBB-SEO.com Dynamic meta tags
if ( isset($HTTP_GET_VARS[POST_TOPIC_URL]) ) {
$meta_topic_id = intval($HTTP_GET_VARS[POST_TOPIC_URL]);
} elseif ( isset($HTTP_GET_VARS[POST_FORUM_URL]) ) {
$meta_forum_id = intval($HTTP_GET_VARS[POST_FORUM_URL]);
} elseif ( isset($HTTP_GET_VARS[POST_CAT_URL]) ) {
$meta_cat_id = intval($HTTP_GET_VARS[POST_CAT_URL]);
}
if ( isset($meta_topic_id) ) {
$sql = "SELECT c.cat_title, f.forum_name, t.topic_title
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
WHERE f.forum_id = t.forum_id
AND c.cat_id = f.cat_id
AND t.topic_id = $meta_topic_id";
if( ($result = $db->sql_query($sql)) ) {
if ( $meta_row = $db->sql_fetchrow($result) ) {
$description = $board_config['sitename'] . ' :: ' . $meta_row['cat_title'] . ' :: ' . $meta_row['forum_name'] . ' :: ' . $meta_row['topic_title'];
}
}
$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'];
}
}
} elseif ( isset($meta_forum_id) ) {
$sql = "SELECT c.cat_title, f.forum_name
FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
WHERE c.cat_id = f.cat_id
AND f.forum_id = $meta_forum_id";
//SQL CACHE
if( ($result = $db->sql_query($sql)) ) {
//if( ($result = $db->sql_query($sql, false, 'META_')) ) {
if ( $meta_row = $db->sql_fetchrow($result) ) {
$description = $board_config['sitename'] . ' :: ' . $meta_row['cat_title'] . ' :: ' . $meta_row['forum_name'];
$keywords = $board_config['sitename'] . ', ' . $meta_row['cat_title'] . ', ' . $meta_row['forum_name'] . 'jeux, flash, arcade, arcad, arkade';
}
//here we clear $result from ram and cache it
$db->sql_freeresult($result);
//End sql cache opt
}
} elseif ( isset($meta_cat_id) ) {
$sql = "SELECT cat_title
FROM " . CATEGORIES_TABLE . "
WHERE cat_id = $meta_cat_id";
//SQL CACHE
if( ($result = $db->sql_query($sql)) ) {
//if( ($result = $db->sql_query($sql, false, 'META_')) ) {
if ( $meta_row = $db->sql_fetchrow($result) ) {
$keywords = $board_config['sitename'] . ', ' . $meta_row['cat_title'] . 'jeux, flash, arcade, arcad, arkade';
$description = $board_config['sitename'] . ' :: ' . $meta_row['cat_title'];
}
//here we clear $result from ram and cache it
$db->sql_freeresult($result);
//End sql cache opt
}
} else {
$description .= 'Plein de jeux flash. Bon moment de detente!';
$keywords = 'flash, arcade, arcad, arkade, jeu, animation,tetris,casse briques,reflexion,mahjong,mini golf,tirs,shootem,pacman,froger';
}
$phpbb_meta = '<meta name="title" content="' . $page_title .'" />' . "\n";
//$meta_str .= '<meta name="author" content=" Hawk88 " />' . "\n";
//$meta_str .= '<meta name="copyright" content=" Jeu-Arcade " />' . "\n";
$phpbb_meta .= '<meta name="keywords" content="' . $keywords .'" />' . "\n";
$phpbb_meta .= '<meta name="description" lang="fr" content="'. $description .'" />' . "\n";
$phpbb_meta .= '<meta name="category" content="general" />' . "\n";
$phpbb_meta .= '<meta name="robots" content="index, follow" />' . "\n";
//END www.phpBB-SEO.com Dynamic meta tags
Voila mon code, j'ai essayer de réduire le nombre de mot clés pour tester par rapport a la limite mais pareil
Merci
J'ai bien fait les deux autres modifications mais je pense que c'est le plus important ce code la les autres les erreurs sont limités :p

Français |
Anglais




