$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 '<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"' : '') . ' />&nbsp;' . $lng_lib['search_name']. '
  </form>
</div>';

echo '<div class="phdr"><b>Kinolar</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>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>';
}

$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>
';