Просмотр файла downs/new.php

Размер файла: 2.29Kb
  1. <?php
  2.  
  3. $title='Новые загрузки за 3дня';
  4. require"../system/config.php";
  5. require"../system/func.php";
  6. require"../system/head.php";
  7. require"../system/error.php";
  8.  
  9. echo'<div class="i">'.$title.'<br></div>';
  10. $clocp=time()-86400*3;
  11. $total=mysql_result(mysql_query("SELECT COUNT(*) FROM `down_files` WHERE `typer`='file' AND `dobav`>'$clocp' ORDER BY `dobav` LIMIT 30"),0);
  12.  
  13. $page = abs((int)$_GET['page']);
  14.  
  15. if($page < 0 || $page > $total) $page = 0;
  16. if ($total < $page + 10) $end = $total;
  17. else $end = $page + 10;
  18.  
  19. if($total==0){echo'За последние 3дня,небылo новых загрузок';} $sdata=mysql_query("SELECT * FROM `down_files` WHERE `typer`='file' AND `dobav`>'$clocp' ORDER BY `dobav` DESC LIMIT $page,10");
  20.  
  21. while($ofile=mysql_fetch_array($sdata)){
  22. $dokuda='../down/'.$ofile['put'].'/'.$ofile['nastna'].'.'.$ofile['format'];
  23. $vesma=round(filesize($dokuda)/1024);
  24. if($vesma==0){$vesma='Менее 1';}
  25.  
  26. $pere=preg_replace('/\/(.*?)\//si','',$ofile['put']);
  27. $kateg=mysql_fetch_assoc(mysql_query("SELECT `name` FROM `down_files` WHERE `nastna`='$pere' AND `typer`='dir' LIMIT 1"));
  28. echo'<div class="p">';
  29. if(empty($ofile['name'])){
  30. $ofile['name']=$ofile['nastna'].'.'.$ofile['format'];
  31. }
  32.  
  33. echo'<b>Категория:</b> <a href="index.php?dir='.$ofile['put'].'">'.$kateg['name'].'</a><br><b>Имя:</b> <a href="'.$ofile['id_file'].'.info">'.$ofile['name'].'</a> <br><b>Описание: </b>'; if($ofile['opis']==""){echo'нет';}else{echo mb_substr($ofile['opis'],0,200,'UTF-8');} echo'<br>
  34. <small>Скачали: '.$ofile['loads'].' раз<br></small>
  35. <a href="load.php?id_load='.$ofile['id_file'].'&amp;'.$s.'">Скачать</a> ['.strtoupper($ofile['format']).'] ['.$vesma.'Кб]<br>
  36. ';
  37.  
  38. $koments=mysql_num_rows(mysql_query("select * from koments where type='downs' and id_kogo='".$ofile['id_file']."'"));
  39. $koments=mysql_num_rows(mysql_query("select * from koments where type='downs' and id_kogo='".$ofile['id_file']."'"));
  40. echo'<a href="../pages/koments.php?id_wm='.$ofile['id_file'].'&amp;type=downs&amp;'.$s.'">Комментарии</a> ['.$koments.']<br>
  41. </div>';
  42. }
  43. echo'<div class="p">';
  44. strpage($page, 10, $total, "new.php"); echo'</div><div class="p"><img src="'.$dirsite.'/design/default/act.gif" alt=""> <a href="index.php">В архив</a></div>';
  45. require"../system/foot.php";
  46. ?>