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

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

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