Tasodiiy hikoya:
'.$tasodif['name'].'
'.$matn.'... davomi
';
}
echo $mp->news;
echo '
Qidiruv
Sayt bo\'limlari
Kino
';
$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 '';
}
echo 'So\'nggi rasmlar
';
$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 '
';
}
echo 'So\'nggi audiolar
';
$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 '
';
}
echo 'So\'nggi videolar
';
$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 '
';
}
echo 'So\'nggi o\'yinlar
';
$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 '
';
}
echo 'Kutubxona
';
$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 '';
}
echo 'Yangi maqolalar
';
$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 '
';
}
echo 'Maqola yozish
';
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 '
';
} else {
echo '';
}
$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 '
Ma\'lumot
';
?>