منتديات phpBBArabia

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

		// Display not already displayed Attachments for 

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

				
	///////////////	last topic by user
    $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
  ORDER BY t.topic_id DESC";
	$result = $db->sql_query_limit($sql, $limit);

	while ($row = $db->sql_fetchrow($result))
	{
	

				$template->assign_block_vars('postrow.postrowy', array(



			'POST_SUB'	=> $row['topic_title'],
      'U_MINI_POST'      => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$row['forum_id']}&t={$row['topic_id']}"),

		));
  }
//////////////////// last topic by user
						

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

			<!-- END custom_fields -->			

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

			
	
		<table width="100%" cellspacing="1">

<h4>{L_TOPIC_BY_USER}</h4>
<tbody>
  <tr>
	<td>
      <div style="border: 1px inset ; padding: 6px; overflow: auto;">
 <!-- BEGIN postrowy -->
<a href="{postrow.postrowy.U_MINI_POST}" >{postrow.postrowy.POST_SUB}</a><br>

<!-- END postrowy -->
	 </div>
	</td>
  </tr>  
</tbody>		</table>	

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

	 	'SUBMIT'	=> '?????',  

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

			
	'TOPIC_BY_USER'	=> '??? ???????',

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

page_footer();

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

            
   ///////////////   last topic by user
    $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
  ORDER BY t.topic_id DESC";
   $result = $db->sql_query_limit($sql, $limit);

   while ($row = $db->sql_fetchrow($result))
   {
   

            $template->assign_block_vars('postrow.postrowy', array(



         'POST_SUB'   => $row['topic_title'],
      'U_MINI_POST'      => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$row['forum_id']}&t={$row['topic_id']}"),

      ));
  }
//////////////////// last topic by user
                  

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

  ///////////////   last topic by user
   $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
         ORDER BY t.topic_id DESC";
   $result_last_topic = $db->sql_query_limit($sql, $limit);

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

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

<!-- IF postrow.POSTER_TOPICS -->
      <table width="100%" cellspacing="1">
         <tr>
            <td><h4>{L_TOPIC_BY_USER}</h4></td>
         </tr>
         <tr>
         <td>
            <div style="border: 1px inset ; padding: 6px; overflow: auto;">
               <!-- BEGIN postrowy -->
                  <a href="{postrow.postrowy.U_MINI_POST}" >{postrow.postrowy.POST_SUB}</a><br />
               <!-- END postrowy -->
            </div>
         </td>
      </tr>
      </table>
<!-- ENDIF -->