forum.lissyara.su

Код: Выделить всё

   3 209.85.238.9
   3 213.148.178.173
   3 85.21.138.219
   4 193.17.75.155
   4 193.33.92.3
   4 193.41.62.140
   4 77.91.224.2
   4 89.163.12.20
   4 89.178.162.172
   4 89.19.167.155
   4 92.46.139.125
   5 212.118.46.182
   5 212.12.70.44
   5 87.228.26.54
   6 213.79.68.12
   6 81.89.183.130
   6 87.252.253.48
   7 89.222.201.38
   7 91.76.111.117
   8 82.207.93.135
   9 195.248.188.26
  10 82.207.108.43
  11 195.248.233.254
  11 81.89.183.139
  12 212.12.70.34
  12 72.14.199.9
  13 84.204.200.146
  13 85.140.118.187
  14 194.146.243.213
  16 87.236.184.86
  17 85.140.231.235
  19 93.188.32.222
  20 67.212.169.34
  47 193.109.80.186
  68 81.19.66.38
  82 213.172.6.220
 116 193.189.127.98
 153 72.14.199.47
 212 195.234.72.66
 289 193.109.249.217

Код: Выделить всё

        $sql = 'SELECT f.forum_id,f.forum_name, f.forum_desc_options, t.topic_title, t.topic_id,t.topic_last_post_id,t.topic_last_poster_name, p.post_time, p.post_text, 
        	p.bbcode_uid, p.bbcode_bitfield, u.username, u.user_id
                FROM  '. FORUMS_TABLE .'  f,'.TOPICS_TABLE.' t, '.POSTS_TABLE.' p,'.USERS_TABLE.' u
                WHERE t.forum_id = f.forum_id
                AND t.topic_status != 1
                AND p.post_id = t.topic_last_post_id 
                AND u.user_id = p.poster_id
                ORDER BY t.topic_last_post_id DESC
                LIMIT 100 ';	

Код: Выделить всё

$sql = 'SELECT f.forum_id,f.forum_name, f.forum_desc_options, t.topic_title, t.topic_id,t.topic_last_post_id,t.topic_last_poster_name, p.post_time, p.post_text, 
           p.bbcode_uid, p.bbcode_bitfield, u.username, u.user_id
                FROM  '. FORUMS_TABLE .'  f,'.TOPICS_TABLE.' t, '.POSTS_TABLE.' p,'.USERS_TABLE.' u
                WHERE t.forum_id = f.forum_id
                AND t.topic_status != 1
                AND t.topic_id='__сюда_id_топика__'
                AND p.post_id = t.topic_last_post_id 
                AND u.user_id = p.poster_id
                ORDER BY t.topic_last_post_id DESC
                LIMIT 100 ';