منتديات phpBBArabia

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

   ///////////////   last topic by user
   $limit_lt = 10;
   $noflt = array(500,600);
   $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';
   $result_lt = $db->sql_query_limit($sql, $limit_lt);

   while ($row_lt = $db->sql_fetchrow($result_lt))
   {
      $template->assign_block_vars('postrow.postrowy', array(
         'TITLE'      => $row_lt['topic_title'],
         'U_TOPIC'   => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$row_lt['forum_id']}&t={$row_lt['topic_id']}"),
      ));
   }
   $db->sql_freeresult($result_lt);
   unset($result_lt);
   //////////////////// last topic by user

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

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

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

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