Fanat_FCB, <?php

/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = '10';
echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
$bolm_sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC");
$sql = mysql_result(mysql_query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1'), 0);
$page = $page >= ceil($sql / $kmess) ? ceil($sql / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);

$req_lib = mysql_query("SELECT * FROM `library_texts` WHERE `premod`='1' ORDER BY `time` DESC LIMIT 10 ");
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo'<div class="menu">';

if (file_exists((ROOTPATH . 'files/library/images/big/' . $lib['id'] . '.png'))){

$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
echo '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">';
}else{
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
}
echo '<img src="/vip.png" alt="icon" width="16" height="16"/></a> <a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"> ' . $lib['name'] . '</a><div class="" style="float:right;"> O\'qildi: <span class="time"> [' . $lib['count_views'] . ']</span> </div>';









echo '</div>';
}
}


?>



librarydagi yangiliklarni chiqaradi bita iconka bilan

<?php
include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo '<div class="phdr"><a href="/download/dir_1.html"><b>Yangi Musiqalar</b></a>(orginal)</div>';
$cat ='1';
$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1");
if(mysql_num_rows($cat_inf)){
$cat_inf = mysql_fetch_assoc($cat_inf);
}else{
$cat_inf = array('way' => '');
}
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%'"), 0);
$zap = mysql_query("SELECT * FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%' ORDER BY `time` DESC LIMIT 10");
while ($ok = mysql_fetch_array($zap)) {
echo ($i % 2) ? '<div class="menu">' : '<div class="menu">';
$i;
$ok['name'] = str_replace('||||','',$ok['name']);
$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0);
echo "<img src='/images/music.png' width='16' height='16' align='middle'/> <a href='/download/" . str_replace(' ', '_', $ok['name']) . "_".$ok['id'].".html'>".$ok['name']."</a> <div class='' style='float:right;'><span class='time'> (" . size_convert($ok['size']) . ")</span></div>";
if($new > 0){
echo '<span class="red"> NEW!</span>';
}else{
echo '';
}


echo "</div>";
}

if ($total > $kmess){
echo '<p>' . functions::display_pagination('?get=fayl&', $start, $total, $kmess) . '</p>';
}

?>

<?php

/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = '20';
echo '<div class="phdr"><b>So\'ngi maqolalar</b></div>';
$bolm_sql = mysql_query("SELECT id, name, dir, description FROM library_cats WHERE parent=0 ORDER BY pos DESC");
$sql = mysql_result(mysql_query('SELECT COUNT(*) FROM library_texts WHERE premod=1'), 0);
$page = $page >= ceil($sql / $kmess) ? ceil($sql / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);

$req_lib = mysql_query("SELECT * FROM library_texts WHERE premod='1' ORDER BY time DESC LIMIT " . $start . "," . $kmess);
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo'<div class="list1">';

if (file_exists((ROOTPATH . 'files/library/images/big/' . $lib['id'] . '.png'))){

$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
echo '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">';
}else{
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
}
echo ''
. '**<img src="/images/icon nomi.png" width="16"height="16" **/><a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"><b>' . $lib['name'] . '</b></a><br />'.$lib['announce'].'
. 'Ko`rilgan: ' . $lib['count_views'] . ''
. ' | Fikrlar ' . $lib['count_comments'] . '';





echo '</div>';
}
}


?> koda maqolani nomini uziz chiqadi bosh saxifada shuni maqolani nomini pastida maqoladan bir parcha chiqaradigan qilishni qoyib beringlar

Asil4ek, mana buni aytmayapsizmi


<?php

/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = '15';
echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
$bolm_sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC");
$sql = mysql_result(mysql_query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1'), 0);
$page = $page >= ceil($sql / $kmess) ? ceil($sql / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);

$req_lib = mysql_query("SELECT * FROM `library_texts` WHERE `premod`='1' ORDER BY `time` DESC LIMIT 15 ");
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo'<div class="menu">';

if (file_exists((ROOTPATH . 'files/library/images/big/' . $lib['id'] . '.png'))){

$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
echo '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">';
}else{
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
}
echo '<img src="/vip.png" alt="icon" width="16" height="16"/></a> <a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"> ' . $lib['name'] . '</a><div class="" style="float:right;"> O\'qildi: <span class="time"> [' . $lib['count_views'] . ']</span> </div>';









echo '</div>';
}
}


?>

Fanat_FCB, $zap = mysql_fetch_array(mysql_query
("SELECT * FROM `downpath` WHERE `id` =
'2'"));
$old = time() - (3 * 24 * 3600);
$countnf = mysql_result(mysql_query
("SELECT COUNT(*) FROM `downfiles` WHERE
`type`!= 1 && `time` > '".$old."' && `way` LIKE
'" . $zap['way'] ."%' "),0);
$countf = mysql_result(mysql_query("SELECT
COUNT(*) FROM `downfiles` WHERE `type`!=
1 && `way` LIKE '" . $zap['way']."%' "), 0);
echo '<img src="/img/play.png" alt=""width="20" height="20" /> <a href="download/dir_2.html">Mp3lar</a><span style="background:#630063;padding:5px;float:right;">'.
$countf;
if($countnf > 0){ echo'<span class="red">+'.
$countnf.'</span>'; }
echo'</span>';

Mana library dagi maqolalarni bosh sahifaga chiqaruvchi kod




<?php

/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = '15';
echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
$bolm_sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC");
$sql = mysql_result(mysql_query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1'), 0);
$page = $page >= ceil($sql / $kmess) ? ceil($sql / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);

$req_lib = mysql_query("SELECT * FROM `library_texts` WHERE `premod`='1' ORDER BY `time` DESC LIMIT 15 ");
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo'<div class="menu">';

if (file_exists((ROOTPATH . 'files/library/images/big/' . $lib['id'] . '.png'))){

$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
echo '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">';
}else{
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
}
echo '<img src="/vip.png" alt="icon" width="16" height="16"/></a> <a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"> ' . $lib['name'] . '</a><div class="" style="float:right;"> O\'qildi: <span class="time"> [' . $lib['count_views'] . ']</span> </div>';









echo '</div>';
}
}


?>

MuRoDBeK, mana librarydagi maqolalarni bosh sahifaga chiqaruvchi kod




<?php
/*
-----------------------------------------------------------------
Maqolalar
-----------------------------------------------------------------
*/
$kmess = '15';
echo '<div class="phdr"><b>Yangi maqolalar</b></div>';
$bolm_sql = mysql_query("SELECT `id`, `name`, `dir`, `description` FROM `library_cats` WHERE `parent`=0 ORDER BY `pos` DESC");
$sql = mysql_result(mysql_query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=1'), 0);
$page = $page >= ceil($sql / $kmess) ? ceil($sql / $kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $kmess;
$bolm = mysql_fetch_assoc($bolm_sql);
$req_lib = mysql_query("SELECT * FROM `library_texts` WHERE `premod`='1' ORDER BY `time` DESC LIMIT 15 ");
if ($sql) {
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
echo'<div class="menu">';
if (file_exists((ROOTPATH . 'files/library/images/big/' . $lib['id'] . '.png'))){
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
echo '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">';
}else{
$img_style = 'width: 60px; height: 35px; float: left; clear: both; margin: 10px';
}
echo '<img src="/vip.png" alt="icon" width="16" height="16"/></a> <a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '"> ' . $lib['name'] . '</a><div class="" style="float:right;"> O\'qildi: <span class="time"> [' . $lib['count_views'] . ']</span> </div>';
echo '</div>';
}
}
?>