13.08.2009, 20:05
|
|
Участник форума
Регистрация: 28.07.2007
Сообщений: 177
Провел на форуме:
274360
Репутация:
5
|
|
а в етом?
спасибо с первым - помогло
вот такой же файл только чуть чуть изменен)
надо отключить именно запрос к бд ( чтоб снизить нагрузку
PHP код:
<div id="lbox" style="margin:6px 0">
<div id="box_t1"><?=$lang[598]?></div>
<div class="p">
<div id="cat_nav" >
<?
if (@$_GET['city']){
$GLOBALS['start_for_links'] = "city/".htmlspecialchars($_GET['city'])."/";
$GLOBALS['end_for_links'] = "sort/city_asc/page/1/";
}
else {
$GLOBALS['start_for_links'] = ""; $GLOBALS['end_for_links'] = "sort/date_desc/page/1/";
}
$GLOBALS['host'] = $h;
function listcat2($id, $sub)
{
$categories = mysql_query("SELECT * FROM jb_board_cat WHERE root_category = $id ORDER by name_cat");
while($category = mysql_fetch_array($categories))
{
$count = mysql_num_rows(mysql_query("SELECT * FROM jb_board WHERE old_mess = 'old' AND id_category='".$category['id']."' ".@$city_from_search));
$query = mysql_query("SELECT * FROM jb_board_cat WHERE root_category = ".$category['id']);
@$count_subcat_mthe_cat = mysql_num_rows($query);
if (@$GLOBALS['city_name_from_tips']) $tip_city = "".$GLOBALS['city_name_from_tips']; else $tip_city = "";
if(!@$count) echo "<span style='display:none;' href=\"".$GLOBALS['host']."/advertisement/".@$GLOBALS['start_for_links']."nesting/".$category['id']."/".@$GLOBALS['end_for_links']."\" >".$category['name_cat']."</span>";
else echo "<a href=\"".$GLOBALS['host']."/advertisement/".@$GLOBALS['start_for_links']."nesting/".$category['id']."/".@$GLOBALS['end_for_links']."\">".$category['name_cat']." (".$count.")</a>";
listcat2($category['id']);
}
}
$categories = mysql_query("SELECT * FROM jb_board_cat WHERE root_category = 0 ORDER by name_cat");
while($category = mysql_fetch_assoc($categories))
{
echo "<div onClick=\"details(9999".$category['id'].");\">".$category['name_cat']."</div><span id=\"9999".$category['id']."\" style=\"DISPLAY: none;\">";
listcat2($category['id']);
echo "</span>";
}
?> </div></div>
</div>
|
|
|