<?php


/**

@topic  https://uzfor.uz/view.php?act=post&id=29992

*/


/**
 * @package     JohnCMS
 * @link        http://johncms.com
 * @copyright   Copyright (C) 2008-2011 JohnCMS Community
 * @license     LICENSE.txt (see attached file)
 * @version     VERSION.txt (see attached file)
 * @author      http://johncms.com/about
 */

defined('_IN_JOHNCMS') or die('Error: restricted access');
$lng_lib = core::load_lng('library');

$mp = new mainpage();

$tasodifiy_maqola = mysql_query("SELECT * FROM  `library_texts` ORDER BY RAND() LIMIT 1");
while ($tasodif = mysql_fetch_assoc($tasodifiy_maqola)) {
  $matn = mb_substr($tasodif['text'], 0, 50);
echo '
  <div class="list1">
    <b>Tasodiiy hikoya:</b>
    <a href="/library/index.php?id='.$tasodif['id'].'">'.$tasodif['name'].'</a><br />
    '.$matn.'... <a href="/library/index.php?id='.$tasodif['id'].'">davomi</a>
  </div>
';
}
echo $mp->news;
echo '
<div class="phdr"><b>Qidiruv</b></div>
<div class="list1">
  <form action="/library/?act=search" method="post">
    <input placeholder="matnni kiriting" type="text" value="' . ($search ? functions::checkout($search) : '') . '" name="search" />
    <input type="submit" value="' . $lng['search'] . '" name="submit" /><br />
    <input name="t" type="checkbox" value="1" ' . ($search_t ? 'checked="checked"' : '') . ' /> ' . $lng_lib['search_name']. '
  </form>
</div>

<div class="phdr"><b>Sayt bo\'limlari</b></div>
<div class="list1">
  <img src="/images/label.png" align="top" />
  <a href="/users/index.php?act=top">Eng faollar (haftlaik reyting!)</a>
</div>
<div class="list1">
  <a href="/library/?act=top">Eng ko\'p o\'qilgan hikoyalar</a> Top-100
</div>
<div class="list1"><a href="forum/">' . $lng['forum'] . '</a> (' . counters::forum() . ')</div>
<div class="list1"><a href="guestbook/index.php">' . $lng['guestbook'] . '</a> (' . counters::guestbook() . ')</div>
<div class="list1"><a href="users/index.php">' . $lng['users'] . '</a> (' . counters::users() . ')</div>
<div class="list1"><a href="library/index.php">' . $lng['library'] . '</a> (' . counters::library() . ')</div>
<div class="list1"><a href="users/album.php">' . $lng['photo_albums'] . '</a> (' . counters::album() . ')</div>
<div class="list1"><a href="download/">' . $lng['downloads'] . '</a> (' . counters::downloads() . ')</div>

<div class="phdr"><b>Kino</b></div>';
$yangi_yuklamalar = mysql_query("SELECT * FROM `download` WHERE `type` = 'cat' AND `refid`= '1' ORDER By `time` DESC LIMIT 7");
while ($yuklama = mysql_fetch_assoc($yangi_yuklamalar)) {
  echo '<div class="list1"><a href="/download/index.php?act=view&file='.$yuklama['id'].'">'.$yuklama['text'].'</a></div>';
}

echo '<div class="phdr"><b>So\'nggi rasmlar</b></div>';
$yangi_yuklamalar = mysql_query("SELECT * FROM `download` WHERE `type` = 'file' AND `refid`= '2' ORDER By `time` DESC LIMIT 7");
while ($yuklama = mysql_fetch_assoc($yangi_yuklamalar)) {
  echo '
    <div class="list1">
    <img src="/download/graftemp/'.$yuklama['screen'].'temp.png" />
      <a href="/download/index.php?act=view&file='.$yuklama['id'].'">
        '.$yuklama['text'].'
      </a>
      <br />
      Yuklab olindi: '.($yuklama['ip'] == '' ? '0' : $yuklama['ip']).'
    </div>
  ';
}

echo '<div class="phdr"><b>So\'nggi audiolar</b></div>';
$yangi_yuklamalar = mysql_query("SELECT * FROM `download` WHERE `type` = 'file' AND `refid`= '3' ORDER By `time` DESC LIMIT 7");
while ($yuklama = mysql_fetch_assoc($yangi_yuklamalar)) {
  echo '
    <div class="list1">
      <a href="/download/index.php?act=view&file='.$yuklama['id'].'">
        '.$yuklama['text'].'
      </a>
      <br />
      Yuklab olindi: '.($yuklama['ip'] == '' ? '0' : $yuklama['ip']).'
    </div>
  ';
}

echo '<div class="phdr"><b>So\'nggi videolar</b></div>';
$yangi_yuklamalar = mysql_query("SELECT * FROM `download` WHERE `type` = 'file' AND `refid`= '1' ORDER By `time` DESC LIMIT 7");
while ($yuklama = mysql_fetch_assoc($yangi_yuklamalar)) {
  echo '
    <div class="list1">
      <a href="/download/index.php?act=view&file='.$yuklama['id'].'">
        '.$yuklama['text'].'
      </a>
      <br />
      Yuklab olindi: '.($yuklama['ip'] == '' ? '0' : $yuklama['ip']).'
    </div>

    <img src="/download/screen.php?srс='.$yuklama['adres'].'/'.$yuklama['name'].'" width="Ширина" height="Высота" />

  ';
}

echo '<div class="phdr"><b>So\'nggi o\'yinlar</b></div>';
$yangi_yuklamalar = mysql_query("SELECT * FROM `download` WHERE `type` = 'file' AND `refid`= '8' ORDER By `time` DESC LIMIT 7");
while ($yuklama = mysql_fetch_assoc($yangi_yuklamalar)) {
    echo '
      <div class="list1">
        <img src="/images/system/2.png" />
        <a href="/download/index.php?act=view&file='.$yuklama['id'].'">
          '.$yuklama['text'].'
        </a>
        <br />
        Yuklab olindi: '.($yuklama['ip'] == '' ? '0' : $yuklama['ip']).'
      </div>
    ';

}

echo '<div class="phdr"><b>Kutubxona</b></div>';
$kutubxona_bolim = mysql_query("SELECT * FROM `library_cats` ORDER BY `id` DESC LIMIT 20");
while ($bolim = mysql_fetch_assoc($kutubxona_bolim)) {
  $maqola = mysql_result(mysql_query("SELECT COUNT(*) FROM `library_texts` WHERE `cat_id` = '".$bolim['id']."' "), 0);
  echo '<div class="list1"><a href="/library/index.php?do=dir&id='.$bolim['id'].'">'.$bolim['name'].'</a>
  <br />('.$maqola.' maqola.)</div>';
}
echo '<div class="phdr"><b>Yangi maqolalar</b></div>';

$yangi_maqola = mysql_query("SELECT * FROM `library_texts` WHERE `premod` = '1' ORDER BY `time` DESC LIMIT 15");
while ($yangi = mysql_fetch_assoc($yangi_maqola)) {
  $matn = mb_substr($yangi['text'], 0, 97);
  $bolimi = mysql_fetch_assoc(mysql_query("SELECT * FROM `library_cats` WHERE `id` = '".$yangi['cat_id']."' "));
  $izohi = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_library_comments` WHERE `sub_id` = '".$yangi['id']."' "), 0);
  echo '
  <div class="list2">
      <b>
        <a href="/library/index.php?id='.$yangi['id'].'">
          '.$yangi['name'].'
        </a>
      </b>
      <span style="font-size:xx-small">['.functions::display_date($yangi['time']).']</span>
      <br>'.$matn.'...
      <br><span style="font-size:xx-small">[<a href="/library/index.php?id='.$bolimi['id'].'">'.$bolimi['name'].'</a>]</span>
      <span style="float:right;font-size:xx-small">
        <a href="/library/index.php?act=comments&id='.$yangi['id'].'">
          <font color="red">Izohlar</font>
        </a> ['.$izohi.']<br />
        O\'qildi: '.$yangi['count_views'].'
       </span>
  </div>
  ';
}



echo '<div class="phdr"><b>Maqola yozish</b></div>';
if ( isset($HTTP_GET_VARS[UZFOR_UZ]) || isset($HTTP_POST_VARS[UZFOR_UZ]) ) {
  $id = ( isset($HTTP_GET_VARS[UZFOR_UZ]) ) ? intval($HTTP_GET_VARS[UZFOR_UZ]) : intval($HTTP_POST_VARS[UZFOR_UZ]);
} else if ( 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&" . UZFOR_UZ ."=$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>';
}

$fayllar = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` WHERE `type` = 'file' "), 0);
$yuklash = mysql_result(mysql_query("SELECT SUM(`ip`) FROM `download` WHERE `ip` > '0' "), 0);
echo '
<div class="phdr" style="text-align: center"><b>Ma\'lumot</b></div>
<div class="menu" style="text-align: center">
  Barchasi '.$fayllar.' ta fayl,
  Hammasi bo\'lib: '.$yuklash.' martta yuklandi!
</div>
';

?>
