<?php
include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo '<div class="phdr"><b>Лучшее видео. </b></div>';
$cat = '2';
$qiymat ='10';
$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysql_num_rows($cat_inf)){ 
$cat_inf = mysql_fetch_assoc($cat_inf); 
}else{ 
$cat_inf = array('way' => ''); 
} 
$zap = mysql_query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `time` DESC LIMIT " .$qiymat. "");
while ($ok = mysql_fetch_array($zap)) {
echo ($i % 2) ? '<div class="list1"><span class="red">' : '<div class="list2"><span class="green">';
++$i;
$ok['name'] = str_replace('||||','',$ok['name']);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0); 
echo "<a href='/download/" . str_replace(' ', '_', $ok['name']) ."_".$ok['id'].".html'>" .$ok['name']."</a>";
if($new > 0){
}else{
echo '<span class="blue"><b> *New*</b></span>';
} 
 
 
echo '</div>';
    }
?>

<?php
echo'<div class="phdr"><b>MAQOLA YOZING</b></div>';
echo'<!-- BiG ViRuS -->';
if( isset($HTTP_GET_VARS[BIG_VIRUS])|| isset($HTTP_POST_VARS[BIG_VIRUS]))
{
$id=( isset($HTTP_GET_VARS[BIG_VIRUS])) ?  intval($HTTP_GET_VARS[BIG_VIRUS]): intval($HTTP_POST_VARS[BIG_VIRUS]);
}
elseif( isset($HTTP_GET_VARS['id']))
{
$id= intval($HTTP_GET_VARS['id']);
}
else
{
$id='';
}
$name= isset($_POST['name']) ?  mb_substr(functions::checkin($_POST['name']),0,100):'';
$text= isset($_POST['text']) ? functions::checkin($_POST['text']):'';
if($user_id){
echo'<div class="menu"><form name="form" enctype="multipart/form-data" action="library/index.php?act=addnew&" . BIG_VIRUS ."=$id" method="post">
<p>Maqola nomi <small>(max. 100)</small>:<br>
<input type="text" name="name" value="'.$name.'" /></p>
<p>Maqolaga mos keluvchi bo\'limni tanlang:<br>';
echo'<select name="id">';
$req=mysql_query("SELECT * FROM `library_cats` WHERE `id` ORDER BY `name` DESC");
while($category= mysql_fetch_assoc($req)){
echo'<option value="'.$category['id'].'">'.$category['name'].'</option>';
}
echo'</select></p><p>Maqola matni <small>(iltimos batafsilroq yozing)</small>:<br>
<textarea name="text" rows="'.$set_user['field_h'].'" cols="20">'.$text.'</textarea></p>
<p><input type="checkbox" name="comments" value="1" checked="checked" /> Fikr bildirishga ruxsat berish</p><p><input type="submit" name="submit" value="Yozish" /></p></form></div>';
}else{
echo'<div class="menu">Maqola yozish uchun <a href="registration.php">Ro`yhatdan o`tishingiz</a> shart.</div>';
}
?>

<?php
include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo '<div class="phdr"><b> ЗАРУБЕЖНАЯ МУЗЫКА </b></div>';
$cat = '3';
$qiymat ='10';
$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysql_num_rows($cat_inf)){ 
$cat_inf = mysql_fetch_assoc($cat_inf); 
}else{ 
$cat_inf = array('way' => ''); 
} 
$zap = mysql_query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `time` DESC LIMIT " .$qiymat. "");
while ($ok = mysql_fetch_array($zap)) {
echo ($i % 2) ? '<div class="list1"><span class="red">' : '<div class="list2"><span class="green">';
++$i;
$ok['name'] = str_replace('||||','',$ok['name']);
$tf = pathinfo($ok['way'], PATHINFO_EXTENSION);
echo "<img src='/img/mus.png'> <a href='/download/" . str_replace(' ', '_', $ok['name']) ."_".$ok['id'].".html'>".$ok['name'].".[".$tf."]</a>";
 
 
echo "</span> <span style='float:right; font-size: 9px;'>[" . size_convert($ok['size']). "]</span> </div>";
}
$req = mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `pathid` = '" . $cat . "' AND `status` = 1");
$totalfile = mysql_result($req, 0);
if ($totalfile <1) {
echo'<div class="gmenu">Hozircha fayllar yo`q!</div>'; }
///////////////////////////
///Creator by  Besthakker
?>