if ( isset($meta_topic_id) ) {
$keywords='SITE_ADINIZ, '; //Buraya kendi site adınızı yazınız
$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'];
for($i = 0; $i < strlen($meta_row['topic_title']); $i++)
{
if ( substr($meta_row['topic_title'], $i, 1) == ' ')
{
$keywords = $keywords . ', ';
}else
{
$keywords = $keywords . substr($meta_row['topic_title'], $i, 1);
}
}
}
}
$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 10";
if( ($result = $db->sql_query($sql)) ) {
// $keywords = '';
while ( $meta_row = $db->sql_fetchrow($result) ) {
$keywords .= ($keywords == '') ? $meta_row['word_text'] : ',' . $meta_row['word_text'];
}
}
} //Buradan sonrası "elseif ( isset($meta_forum_id) ) {" diye devam ediyor.
Bu forumu görüntüleyenler: Kayıtlı kullanıcı yok ve 0 misafir