XtGem Forum catalog

' . $lng['forum'] . ' | Posting acak'; $req = mysql_query("SELECT * FROM `forum` WHERE `type` = 't' AND `close` != '1' ORDER BY RAND() LIMIT 10"); //LIMIT 10 untuk mengatur jumlah posting yang akan ditampilkan if (mysql_num_rows($req)) { while ($res = mysql_fetch_assoc($req)) { $q3 = mysql_query("select `id`, `refid`, `text` from `forum` where type='r' and id='" . $res['refid'] . "' LIMIT 1"); $razd = mysql_fetch_assoc($q3); $q4 = mysql_query("select `id`, `refid`, `text` from `forum` where type='f' and id='" . $razd['refid'] . "' LIMIT 1"); $frm = mysql_fetch_assoc($q4); $nikuser = mysql_query("SELECT `from`, `time` FROM `forum` WHERE `type` = 'm' AND `close` != '1' AND `refid` = '" . $res['id'] . "'ORDER BY `time` DESC"); $colmes1 = mysql_num_rows($nikuser); $cpg = ceil($colmes1 / $kmess); $nam = mysql_fetch_assoc($nikuser); echo $i % 2 ? '

' : '

'; // ?????? $icons = array ( ($np ? (!$res['vip'] ? '

' : '') : '

'), ($res['vip'] ? '

' : ''), ($res['realid'] ? '

' : ''), ($res['edit'] ? '

' : '') ); echo functions::display_menu($icons, ' ', ' '); echo '' . $res['text'] . ' [' . $colmes1 . ']'; if ($cpg > 1) echo ' >>'; echo '

' . $frm['text'] . ' / ' . $razd['text'] . '
'; echo $res['from']; if (!empty($nam['from'])) { echo ' / ' . $nam['from']; } echo ' (' . date("d.m.y / H:i", $nam['time']) . ')'; echo '

'; $i++; } } else { echo ''; } echo '

'; ?>