function newclip() {
global $prefix, $db, $admin, $module_name, $bgcolor1, $bgcolor2, $tabcolumn, $showsubkat, $numsubkat;
$sql = "ALTER TABLE `nuke_clip` ORDER BY `dataandtime` DESC";
if ($result = $db->sql_query($sql)) {
OpenTable();
echo "<FONT COLOR=\"red\"><H3>Последние поступления</H3><br></FONT>";
$sql3 = "SELECT cid, sid, title, img, hits, size FROM ".$prefix."_clip LIMIT 10";
$result3 = $db->sql_query($sql3);
while ($row3 = $db->sql_fetchrow($result3)) {
$cid = $row3[cid];
$sid = $row3[sid];
$title = $row3[title];
$img = $row3[img];
$size = $row3[size];
$files_num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_clip WHERE sid = $sid"));
$singer = $db->sql_fetchrow($db->sql_query("SELECT name FROM ".$prefix."_clip_singer WHERE sid = $sid"));
echo "<table border=\"0\"><tr>"
."<td><img src=\"images/clip/clip/$img\" Height=\"100\" alt=\"$name\"></td>"
."<td>"
."<table border=\"0\">"
."<tr>"
."<td><b>$title</b>"
."</td>"
."</tr>"
."<tr>";
echo "<tr>"
."<td>Исполнитель $singer"
."<tr>"
."<td><br>"
."</td>"
."</tr>"
."</td>"
."</tr>"
."<tr>"
."<td><b>Размер</b> $size MB"
."</td>"
."</tr>";
echo "<tr>"
."<td><a href=modules.php?name=clip&go=download&cid=$cid target=\"_blank\"><b><FONT COLOR=\"blue\"><H4> Скачать</H4></FONT></b></a>"
."</td>"
."</tr>"
."</table>"
."</td>"
." </tr>"
." </table>"
."<br>";
}
CloseTable();
}
}
