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

';