<?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

?>