[BETA] هاك اخر 5 مواضيع العضو في صفحة الموضوع..V1.2.0

[(M)]

?????? ?????

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

??? ???? ? ???? ???? ????? ?????? ?? ???????? , ????? ?? ??? ???? ??????? ??? ??????? ????? ????? ??? ??????? ??? ???? 35 ? 40 , ?????? ??? ????? ?? ?????

???? ?? ??? ?????? ??? ??????? .... ? ???? ??? ???? ??? ????? ????? ??? ??? ????? ????????? ??? ???????? ??????? ??? ????? ?? ??????? vb
??? ?? ??????? ??? ?? ?????? ?????? ??? ???????

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

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

// last topic by user - Fixed by MSSTI - Start
   $lt_forum_ary = array();
   $lt_forum_read_ary = array();

   // Do not include those forums the user is not having read access to...
   $lt_forum_read_ary = $auth->acl_getf('!f_read');
   foreach ($lt_forum_read_ary as $lt_forumid => $lt_not_allowed)
   {
      if ($lt_not_allowed['f_read'])
      {
         $lt_forum_ary[] = (int) $lt_forumid;
      }
   }

   $lt_forum_ary = array_unique($lt_forum_ary);
   $lt_forum_sql = (sizeof($lt_forum_ary)) ? ' AND ' . $db->sql_in_set('t.forum_id', $lt_forum_ary, true) : '';

   $lt_limit = 5;
   $sql = 'SELECT t.*, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_id
         FROM ' . TOPICS_TABLE . ' t 
            LEFT JOIN ' . POSTS_TABLE . " p ON (p.post_time = t.topic_time)
         WHERE t.topic_poster = $poster_id " . " $lt_forum_sql 
         ORDER BY t.topic_id DESC";
   $lt_result = $db->sql_query_limit($sql, $lt_limit);

   while ($lt_row = $db->sql_fetchrow($lt_result))
   {
      $template->assign_block_vars('postrow.postrowy', array(
         'POST_SUB'      => $lt_row['topic_title'],
         'U_MINI_POST'   => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$lt_row['forum_id']}&t={$lt_row['topic_id']}"),
      ));
   }
   $db->sql_freeresult($lt_result);
   unset($lt_result, $lt_forum_ary, $lt_forum_read_ary, $lt_forum_sql);
// last topic by user - Fixed by MSSTI - End

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

[FaresNB]

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

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

// last topic by user - Fixed by MSSTI - Start
   $lt_forum_ary = array();
   $lt_forum_read_ary = array();

   // Do not include those forums the user is not having read access to...
   $lt_forum_read_ary = $auth->acl_getf('!f_read');
   foreach ($lt_forum_read_ary as $lt_forumid => $lt_not_allowed)
   {
      if ($lt_not_allowed['f_read'])
      {
         $lt_forum_ary[] = (int) $lt_forumid;
      }
   }

   $lt_forum_ary = array_unique($lt_forum_ary);
   $lt_forum_sql = (sizeof($lt_forum_ary)) ? ' AND ' . $db->sql_in_set('t.forum_id', $lt_forum_ary, true) : '';

   $lt_limit = 5;
   $sql = 'SELECT t.*, p.topic_id, p.poster_id, p.post_time, p.post_subject, p.post_id
         FROM ' . TOPICS_TABLE . ' t 
            LEFT JOIN ' . POSTS_TABLE . " p ON (p.post_time = t.topic_time)
         WHERE t.topic_poster = $poster_id " . " $lt_forum_sql 
         ORDER BY t.topic_id DESC";
   $lt_result = $db->sql_query_limit($sql, $lt_limit);

   while ($lt_row = $db->sql_fetchrow($lt_result))
   {
      $template->assign_block_vars('postrow.postrowy', array(
         'POST_SUB'      => $lt_row['topic_title'],
         'U_MINI_POST'   => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$lt_row['forum_id']}&t={$lt_row['topic_id']}"),
      ));
   }
   $db->sql_freeresult($lt_result);
   unset($lt_result, $lt_forum_ary, $lt_forum_read_ary, $lt_forum_sql);
// last topic by user - Fixed by MSSTI - End

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

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

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

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

.[/quote]

[الساحر]

??????

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

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

[ميدو الحزين]

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

[sembawyo]

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

[sembawyo]

a???? ???? ??? ????? ??? ???? ?? ???????

[sembawyo]

?? ?? ?????? ?? ????? ???? ?? ???? ?? ????? ???? ???? ???? ??
??? ?? ?????? ?? ???? ????
if total topic>0 then
--------
else
end if

[ahmed dawod]

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

[vixus]

?????? ?????

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

[vixus]

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

??? ?? ???? ??? ??????? ? ?????? ????? ????? ??? ?????? ? ???? ???? ????? ?? ??? ??? ???? mysql ? ??? ????????? ??? ????? ??? ??? ????? ???????
???? ??? ???? ????? ???? ????? ???????? ?????

?? ??? viewtopic.php

???? ??

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

$sql = 'SELECT t.topic_title, t.forum_id, p.topic_id, p.post_time
          FROM ' . TOPICS_TABLE . ' t
          LEFT JOIN ' . POSTS_TABLE . ' as p ON (p.post_time = t.topic_time)
          WHERE NOT ' . $db->sql_in_set('t.forum_id', $noflt) . '
          AND t.topic_poster = ' . $poster_id . '
          ORDER BY t.topic_id DESC';

??????? ??

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

$sql = array(
		'SELECT'	=> 't.topic_poster, t.topic_id, t.topic_title, t.forum_id, p.post_time',
		'FROM'		=> array(TOPICS_TABLE => 't', POSTS_TABLE => 'p'),
		'WHERE'		=> 'p.topic_id = t.topic_id
		AND p.post_time = t.topic_time
		AND t.topic_poster = ' . $poster_id,
		'ORDER_BY'	=> 't.topic_id DESC',
	);

??? ???? / ????? ???? ??? ?????? ?? ?????? ???? ?? ??? ???????
????? ???????

?????? ?????

[MHUMMED]

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

??? ?? ???? ??? ??????? ? ?????? ????? ????? ??? ?????? ? ???? ???? ????? ?? ??? ??? ???? mysql ? ??? ????????? ??? ????? ??? ??? ????? ???????
???? ??? ???? ????? ???? ????? ???????? ?????

?? ??? viewtopic.php

???? ??

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

$sql = 'SELECT t.topic_title, t.forum_id, p.topic_id, p.post_time
          FROM ' . TOPICS_TABLE . ' t
          LEFT JOIN ' . POSTS_TABLE . ' as p ON (p.post_time = t.topic_time)
          WHERE NOT ' . $db->sql_in_set('t.forum_id', $noflt) . '
          AND t.topic_poster = ' . $poster_id . '
          ORDER BY t.topic_id DESC';

??????? ??

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

$sql = array(
		'SELECT'	=> 't.topic_poster, t.topic_id, t.topic_title, t.forum_id, p.post_time',
		'FROM'		=> array(TOPICS_TABLE => 't', POSTS_TABLE => 'p'),
		'WHERE'		=> 'p.topic_id = t.topic_id
		AND p.post_time = t.topic_time
		AND t.topic_poster = ' . $poster_id,
		'ORDER_BY'	=> 't.topic_id DESC',
	);

??? ???? / ????? ???? ??? ?????? ?? ?????? ???? ?? ??? ???????
????? ???????

?????? ?????

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

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

[vixus]

?? ???? ??? ???? ???? ????? ???????? Mysql
??? ?????? ?????? localhost
? ??? ??? ???? ?????? ????????? .. ????? ??? ?? ???? ???? ???

? ?? ??? ???? ?? ? ??? ????? ????? ????? ???? mysql ??? ?????? ?????? localhost
??? ???? ????? ????? ?????????