منتديات phpBBArabia

كود: تحديد الكل

$sql= 'SELECT f.forum_id, f.forum_name, t.topic_id, t.topic_title, u.user_id, u.username, u.user_colour
   FROM ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u, ' . FORUMS_TABLE . " f
   WHERE MATCH (t.topic_title) AGAINST ('" . $db->sql_escape($topic_data['topic_title']) . "' IN BOOLEAN MODE)
   AND f.forum_id = t.forum_id
   AND u.user_id = t.topic_poster
   AND t.topic_id <> " . (int) $topic_data['topic_id'] . '
   GROUP BY t.topic_id';

if ($result = $db->sql_query_limit($sql, 5))
{
while($similar = $db->sql_fetchrow($result))
{
if ($auth->acl_get('f_list', $similar['forum_id']))
{
$similar_forum_url = append_sid('viewforum.php?f='.$similar['forum_id']);
$similar_topic_url = append_sid('viewtopic.php?f='.$similar['forum_id'].'&t='.$similar['topic_id']);
$similar_user = '<a style="color: #' .$similar['user_colour']. ';" href="' .append_sid('memberlist.php?mode=viewprofile&u='.$similar['user_id']). '">' .$similar['username']. '</a>';

$template->assign_block_vars('similar', array(
'TOPIC_TITLE' => $similar['topic_title'],
'U_TOPIC' => $similar_topic_url,
'USER' =>  $similar_user,
'U_FORUM' => $similar_forum_url,
'FORUM' => $similar['forum_name'])
);
}
}
}

كود: تحديد الكل

$sql= 'SELECT f.forum_id, f.forum_name, t.topic_id, t.topic_title, u.user_id, u.username, u.user_colour
   FROM ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u, ' . FORUMS_TABLE . " f
   WHERE MATCH (t.topic_title) AGAINST ('" . $db->sql_escape($topic_data['topic_title']) . "' IN BOOLEAN MODE)
   AND f.forum_id = t.forum_id
   AND u.user_id = t.topic_poster
   AND t.topic_id <> " . (int) $topic_data['topic_id'] . '
   GROUP BY t.topic_id';

if ($result = $db->sql_query_limit($sql, 10))
{
while($similar = $db->sql_fetchrow($result))
{
if ($auth->acl_get('f_list', $similar['forum_id']))
{
$similar_forum_url = append_sid('viewforum.php?f='.$similar['forum_id']);
$similar_topic_url = append_sid('viewtopic.php?f='.$similar['forum_id'].'&t='.$similar['topic_id']);
$similar_user = '<a style="color: #' .$similar['user_colour']. ';" href="' .append_sid('memberlist.php?mode=viewprofile&u='.$similar['user_id']). '">' .$similar['username']. '</a>';

$template->assign_block_vars('similar', array(
'TOPIC_TITLE' => $similar['topic_title'],
'U_TOPIC' => $similar_topic_url,
'USER' =>  $similar_user,
'U_FORUM' => $similar_forum_url,
'FORUM' => $similar['forum_name'])
);
}
}
}