امر sql

[tota]

?????? ?????

???? ??????? sql ??? ???

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

$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'])
);
}
}
}

?? ???? ?? ???? ??? 10 ??????? ??? ???

???? ?????? ??? ???????? ???????? ??? ??? ??? 10 ?????? ??? ???

????? ??? [/b]

[TheIlluminative]

?????? ???? ?? ??? ??? ????? ?????? ????:

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

$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'])
);
}
}
}

???? ???????? ????????.

[tota]

?????? ????????

?? ??? ?? ???? ????

???? ??? ????? ???? ??? 10 ?????? ???? ???????? ???????? ?????? ??????? ????? ??? ???????

[TheIlluminative]

????? ???? ?? ???? ??? ?? ????? ???? ??????? ??? ???? ??? 5 ??????

??? ???? ????? ??? ????? | http://www.phpbbarabia.com/community/vi ... 44&t=29123 ?

[tota]

????? ???? ?? ???? ??? ?? ????? ???? ??????? ??? ???? ??? 5 ??????

??? ???? ????? ??? ????? | http://www.phpbbarabia.com/community/vi ... 44&t=29123 ?

?????? ??

??? ????? ????? ?? ???????? ???? ?? ??? ??? ???????? ???? ?????

http://lahlooba.com/knitting.html

??????? ??? ??? ??? ??? ???? ????? ???? ?????? ?? ??? ??????

http://www.phpbbarabia.com/community/vi ... 43&t=40322

???? ??? ??????? ???????? ???? ?? ?????? ?? ????? ?????? ???????

???? ??? 5 ?????? ??? ??? ???? ?????????

[vixus]

?????
http://www.mediafire.com/?502wwnbduwzzkxu

[tota]

???? ???? ?????? ?????

?? ??????? ??? ?? ????? ???????

?? ??? ???????? ???? ??? ???? ????? ??????? ???? ???? ?? ????? ???? ??? ?????? ???????

????? ???? ???? ????? ??? ????? ?????????

??? ??? ???? ??? ???????? ???? ???? ????? ??? ?? ??????? ?? ??? ????? ??? ????? ????? ?? ???????

?????? ?????? ?????

[Garebooo]

vixus ? ?? ???????? ?? ???? ??? ?

[vixus]

@Garebooo ? ???? ???????? ??? ?????? ?? ???? ?? ???? ??? ????? ????

@??????? ????? ?? ??? ??????? ????? ??? ???????? ?? ???? ??????
??? ????? ??? ?????? ??? ?????? ???? ??????? ???? ??????? html ????? ???
??? ???? ????? ??? ????? ?? ???? ??????? ???????
??? ????? ??? ?? ????? ????? ??????? !

??????/ ????? ??? ???? ?? phpbb.com ??? ???? ???? ??? ????? ??????? ??
??? ?? ????? ????? ? ??? ????? ???

[tota]

????? ??? vixus ??? ?? ????? ???? ??? ???????? ?? ???? ?????? ?? ?? ??? ???? ???? ???

??????? ???? ????? ?? ???? ??? ??? ??????

???? ?? ???? Garebooo

?? ?? ??? ???? ?? ??????? ????? ????? ?????? ?? ???? ???? ????? ??? ???????

??????? ??? ?????

[vixus]

????? ???? ?????? ????????? ?? ???? ??????
??????? ?????? ??? ????? ?? ??????
??????? ?????? ??? ???????? ????????

????? ???????? ?? ???? ??????? ????????
??? ???? ?????????

[tota]

????? ???? ?????? ????????? ?? ???? ??????
??????? ?????? ??? ????? ?? ??????
??????? ?????? ??? ???????? ????????

????? ???????? ?? ???? ??????? ????????
??? ???? ?????????

????? ???? ?? ???

?????? ??? ?????