Просмотр архива board


<?

##############################################################################################################

###################                                                                     ######################

###################    Установка и настройка Joker Board Commercial 3 ==> ICQ:183917    ######################

###################                                                                     ######################

##############################################################################################################



if (defined('JBCITY')) $subQuery=' AND jb_board.city_id = '.JBCITY; else $subQuery='';

$name_cat=(defined('JBLANG')&& constant('JBLANG')=='en')?'en_name_cat':'name_cat';

$result = mysql_query ("SELECT id FROM jb_board WHERE old_mess = 'old' ".$subQuery);cq();

if (@$result) $total_rows = mysql_num_rows ($result);

if (@$total_rows){

    $tot=($total_rows-1)/$c['count_adv_on_index'];

    $total=intval($tot+1);if($page>$total) $page=$total;

    $start=$page*$c['count_adv_on_index']-$c['count_adv_on_index'];

    $last_add=mysql_query("SELECT jb_board.id AS board_id, jb_board.id_category, jb_board.title, jb_board.city, DATE_FORMAT(jb_board.date_add,'%d.%m.%Y') AS dateAdd, jb_board.checkbox_top, jb_board.checkbox_select, jb_board_cat.id, jb_board_cat.".$name_cat.", jb_photo.photo_name, jb_city.city_name, jb_city.en_city_name FROM jb_board RIGHT JOIN jb_board_cat ON jb_board.id_category = jb_board_cat.id LEFT JOIN jb_city ON jb_board.city_id = jb_city.id LEFT JOIN jb_photo ON jb_board.id = jb_photo.id_message WHERE old_mess = 'old' ".$subQuery." GROUP by board_id ORDER BY board_id DESC LIMIT ".$start.", ".$c['count_adv_on_index']); cq();

    if(mysql_num_rows($last_add)){

        ?><center><h1><?=$lang[600]?></h1></center><br /><div class="stradv b orange"><div class="o1 alcenter"><?=$lang[123]?></div><div class="o2 alcenter"><?=$lang[127]?></div><div class="o3 alcenter"><?=$lang[153]?></div><div class="o4 alcenter"><?=$lang[122]?></div><div class="o5 alcenter"><?=$lang[163]?></div><div class="clear"></div></div><?

        while ($last=mysql_fetch_assoc($last_add)){

            ?><div class="<?=smsclass($last['checkbox_top'],$last['checkbox_select'])?>"><div class="o1"><a class="b" title="<?=$last['title']?>" href="<?="c".$last['id_category']."-".$last['board_id']?>.html"><?=$last['title']?></a></div><div class="o2 alcenter"><? echo($last['dateAdd']==date("d.m.Y"))?$lang[531]:$last['dateAdd'];?></div><div class="o3 alcenter"><? echo(@$last['photo_name'])?"<img src="".$im."photo.gif" alt="".$lang[200]."" />":"<img src="".$im."nophoto.gif" alt="nophoto" />";?></div><div class="o4"><a class="dgray" title="<?=$last[$name_cat]?>" href="<?="c".$last['id_category']?>.html"><?=$last[$name_cat]?></a></div><div class="o5"><?    if(defined('JBLANG')&& constant('JBLANG')=='en') echo $last['en_city_name']; else echo $last['city_name']; ?></div><div class="clear"></div></div><? 

        }

        if ($total_rows>=$c['count_adv_on_index']){

            $a="<a href="newlist-p";

            if($page!=1)$pervpage=$a."1.html" title="".$lang[174]."">&nbsp;&nbsp;&nbsp;&#171;&nbsp;&nbsp;&nbsp;</a> ";

            if($page!=$total) $nextpage=$a.$total.".html" title="".$lang[175]."">&nbsp;&nbsp;&nbsp;&#187;&nbsp;&nbsp;&nbsp;</a>";        

            $pageleft="";$pageright="";

            for($i=$c['limit_pagination_on_page'];$i>=1;$i--)if($page-$i>0)$pageleft.=$a.($page-$i).".html">".($page-$i)."</a>";

            for($i=1;$i<=$c['limit_pagination_on_page'];$i++)if($page+$i<=$total)$pageright.=$a.($page+$i).".html">".($page+$i)."</a>"; 

            echo "<div class="pagination">".@$pervpage.@$pageleft."<b><span class="current">".$page."</span></b>".@$pageright.@$nextpage."</div>";

        }

    }

}

?>