<?php
header("Content-type: text/html");;
?>
<html>
<head><title>хРТБЧМЕОЙЕ MIDI ЖБКМБНЙ</title></head>
<body>
<?php
include '../wap/config.php';
if (!($conn=pg_connect("host=$dbhost port=$dbport dbname=$dbname user=$dbuser password=$dbpass"))) {
echo ("пЫЙВЛБ РПДЛМАЮЕОЙС Л вд!\n");
};
$res=pg_query($conn, "SET CLIENT_ENCODING TO 'KOI8';");
$res=pg_query($conn, "select id,name_eng,name_rus from cat order by id;");
$rows=pg_numrows($res);
$enabled=1;
if ($sortby=='') $sortby=4;
?>
<center><b>дПВБЧЙФШ НЕМПДЙА</b></center>
<form action="file_add.php" method=post>
<table bgcolor="f0f0f0">
<?php
print "<tr><td>бОЗМЙКУЛПЕ ОБЪЧБОЙЕ: </td><td><input type=text name=\"name_eng\" value=\"".$name_eng."\" size=60></td></tr>\n";
print "<tr><td>тХУУЛПЕ ОБЪЧБОЙЕ: </td><td><input type=text name=\"name_rus\" value=\"".$name_rus."\" size=60> <font size=1 face=arial>(оЕ ПВСЪБФЕМШОП)</font></td></tr>\n";
print "<tr><td>лБФЕЗПТЙС: </td><td><select name=\"category\" size=1>\n";
for ($i=0; $i<$rows; $i++) {
$catname=pg_result($res,$i,2);
if ($catname=='') $catname=pg_result($res,$i,1);
print "<option value=\"".pg_result($res,$i,0)."\">".$catname."</option>\n";
}
print "</select></td></tr>\n";
print "<tr><td>рХФШ Л ЖБКМХ: </td><td><input type=text name=\"path\" value=\"".$path."\" size=60></td></tr>\n";
print "<tr><td></td><td><input type=checkbox name=\"enabled\" value=\"".$enabled."\" checked> рХВМЙЛПЧБФШ ЖБКМ</td></tr>\n";
?>
</table>
<input type=submit value="дПВБЧЙФШ">
<input type=reset value="пЮЙУФЙФШ">
</form>
<center><b>уРЙУПЛ НЕМПДЙК Ч ВБЪЕ</b></center>
<table width="100%">
<tr align=center bgcolor="e0e0e0"><td>N</td><td>бОЗМЙКУЛПЕ ОБЪЧБОЙЕ</td><td>тХУУЛПЕ ОБЪЧБОЙЕ</td><td><a href="files.php" title="уПТФЙТПЧЛБ">лБФЕЗПТЙС</a></td><td>рХФШ</td><td><a href="files.php?sortby=6" title="уПТФЙТПЧЛБ">дПВБЧМЕО</a></td><td>рХВМЙЛХЕФУС</td><td><a href="files.php?sortby=8" title="уПТФЙТПЧЛБ">уЛБЮЙЧБОЙК</a></td></tr>
<?php
$enab[0]='оЕФ';
$enab[1]='дБ';
switch ($sortby)
{
case 6:
$res=pg_query($conn, "select midi.id,midi.name_eng,midi.name_rus,cat.name_eng,cat.name_rus,midi.path,midi.enabled,midi.adate,midi.dlcount from midi,cat where cat.id=midi.category order by midi.adate desc;");
break;
case 8:
$res=pg_query($conn, "select midi.id,midi.name_eng,midi.name_rus,cat.name_eng,cat.name_rus,midi.path,midi.enabled,midi.adate,midi.dlcount from midi,cat where cat.id=midi.category order by midi.dlcount desc;");
break;
case 4:
default:
$res=pg_query($conn, "select midi.id,midi.name_eng,midi.name_rus,cat.name_eng,cat.name_rus,midi.path,midi.enabled,midi.adate,midi.dlcount from midi,cat where cat.id=midi.category order by midi.category,midi.name_eng;");
break;
}
$rows=pg_numrows($res);
for ($i=0; $i<$rows; $i++) {
$catname=pg_result($res,$i,4);
$path=pg_result($res,$i,5);
if (stat('../WWW/'.$path)) {
if (pg_result($res,$i,6)) $trcolor='f0f0f0';
else $trcolor='c0c0ff';
} else {
$trcolor='ffc0c0';
}
if ($catname=='') $catname=pg_result($res,$i,3);
print "<tr align=center bgcolor=\"".$trcolor."\">".
"<td><a title=\"тЕДБЛФЙТПЧБФШ ЙОЖПТНБГЙА ПВ ЬФПК НЕМПДЙЙ\" href=\"file_edit.php?id=".pg_result($res,$i,0)."\">".$i."</a></td><td>".
pg_result($res,$i,1)."</td><td>".
pg_result($res,$i,2)."</td><td>".$catname."</td><td>".
$path."</td><td>".pg_result($res,$i,7)."</td><td>".
$enab[pg_result($res,$i,6)]."</td><td>".pg_result($res,$i,8).
"</td></tr>\n";
}
pg_close($conn);
?>
</table>
</body>
</html>