منتديات phpBBArabia

Faresnb كتب:?????? ?????

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

??? ???? ? ???? ???? ????? ?????? ?? ???????? , ????? ?? ??? ???? ??????? ??? ??????? ????? ????? ??? ??????? ??? ???? 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

(M كتب: ?? ???? ??? ??????? ????? ?? ????? ?????? ?:

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

// 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

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

?????? كتب:?????? ???? ????? ???? ???? ??????? ?????? ???????
?? ???? ???? ??????? ??? ??????? ?? ???

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

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',
	);

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

?????? ?????