Блок 'последние комментарии'

<&#063;php<br /> # Copyright © 2005 - 2008 SLAED<br /> # Website: http://www.slaed.net<br /> if (!defined("BLOCK_FILE")) {<br /> Header("Location: ../index.php");<br /> exit;}<br /> <br /> <br /> global $prefix, $db;<br /> #количество комментариев на страницу<br /> $kol = 10; <br /> #длина текста<br /> $dlina = 50;<br /> $result = $db->sql_query("SELECT a.id, a.cid, a.modul,a.date, a.name, a.comment, b.user_name FROM ".$prefix."_comment AS a <br /> <br /> LEFT JOIN ".$prefix."_users AS b ON (a.uid=b.user_id) ORDER BY date DESC LIMIT $kol");<br /> if ($db->sql_numrows($result) > 0) {<br /> while (list($id, $cid, $com_modul,$date, $com_name, $com_text, $user_name) = $db->sql_fetchrow($result)) {<br /> <br /> <br /> $com_name = ($user_name) &#063; "".user_info($user_name, 1)."" : (($com_name) &#063; $com_name : $confu['anonym']);<br /> <br /> $content .= "<table cellspacing=\"0\" cellpadding=\"1\" border=\"0\"><tr><td>» $date<br><b>$com_name</b>: <a <br /> <br /> href=\"".view_article($com_modul, $cid, $id)."\" title=\""._READMORE."\">".substr(text_filter(bb_decode($com_text, <br /> <br /> $com_modul)),0,$dlina)."</a></td></tr></table><hr>";}}<br /> &#063;>

function comm_show() {<br /> global $prefix, $db, $admin_file, $conf, $confu;<br /> head();<br /> comm_navi();<br /> $num = isset($_GET['num']) &#063; intval($_GET['num']) : "1";<br /> $offset = ($num-1) * $conf['anum'] ;<br /> $result = $db->sql_query("SELECT a.id, a.cid, a.modul, a.name, a.comment, b.user_name FROM ".$prefix."_comment AS a <br /> <br /> LEFT JOIN ".$prefix."_users AS b ON (a.uid=b.user_id) ORDER BY date DESC LIMIT ".$offset.", ".$conf['anum']."");<br /> if ($db->sql_numrows($result) > 0) {<br /> open();<br /> echo "<table width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\" class=\"sort\" <br /> <br /> id=\"sort_id\"><tr>"<br /> ."<th>"._ID."</th><th>"._MODUL."</th><th>"._NICKNAME."</th><th <br /> <br /> width=\"60%\">"._COMMENT."</th><th>"._FUNCTIONS."</th></tr>";<br /> while (list($id, $cid, $com_modul, $com_name, $com_text, $user_name) = $db->sql_fetchrow($result)) {<br /> $com_name = ($user_name) &#063; "".user_info($user_name, 1)."" : (($com_name) &#063; $com_name : <br /> <br /> $confu['anonym']);<br /> echo "<tr class=\"bgcolor1\">"<br /> ."<td align=\"center\">$id</td>"<br /> ."<td align=\"center\">$com_modul</td>"<br /> ."<td align=\"center\">$com_name</td>"<br /> ."<td>".bb_decode($com_text, $com_modul)."</td>"<br /> ."<td align=\"center\">".ad_edit("".$admin_file.".php&#063;op=comm_edit&id=".$id."")." <a <br /> <br /> href=\"".view_article($com_modul, $cid, $id)."\" title=\""._READMORE."\"><img src=\"".img_find("all/about")."\" border=\"0\" <br /> <br /> align=\"center\" alt=\""._READMORE."\"></a> <br /> <br /> ".ad_delete("".$admin_file.".php&#063;op=comm_del&id=$id&cid=$cid&modul=".$com_modul."&refer=1", <br /> <br /> cutstr(text_filter(bb_decode($com_text, $com_modul)), 50))."</td></tr>";<br /> }<br /> echo "</table>";<br /> close();<br /> list($numstories) = $db->sql_fetchrow($db->sql_query("SELECT Count(id) FROM ".$prefix."_comment"));<br /> $numpages = ceil($numstories / $conf['anum']);<br /> num_page("", $numstories, $numpages, $conf['anum'], "op=comm_show&");<br /> } else {<br /> warning(""._NO_INFO."", "", "", 2);<br /> }<br /> foot();<br /> }