спасибо
попробовал сегодня сделать модуль менюшку, сразу не получилось, пришлось немного поправить,
в результате добился вывода пока
только одной родительской категории
и еще вопрос как бы избавиться от знаков вопроса в конце? - избавился добавив JString:: к substr
[spoiler title=Код]
<?php
$sql= "(SELECT distinct b1.id as c1, b1.name as c2, b1.name as c3, count(b7.published=1) as c4, b1.sort_order as c5, count(b7.published=1) as f1, b1.parent as par
FROM XXXX_XXXX.jos_marketplace_categories as b1,
XXXX_XXXX.jos_marketplace_categories as b2,
XXXX_XXXX.jos_marketplace_ads as b7
WHERE (b1.id=b2.parent and b2.id=b7.category)
group by b1.id)
union
(select a1.id as c1, a1.name as c2, ss.s_name as c3, ss.s_cnt as c4, a1.sort_order as c5, fff.f_cnt as f1, a1.parent as par
from XXXX_XXXX.jos_marketplace_categories as a1,
(SELECT distinct b1.id as s_id, b1.name as s_name, count(b7.published=1) as s_cnt
FROM XXXX_XXXX.jos_marketplace_categories as b1,
XXXX_XXXX.jos_marketplace_categories as b2,
XXXX_XXXX.jos_marketplace_ads as b7
WHERE (b1.id=b2.parent and b2.id=b7.category)
group by b1.id) as ss,
(SELECT distinct e1.id as f_id, e1.name as f_name, count(f1.published=1) as f_cnt
FROM XXXX_XXXX.jos_marketplace_categories as e1,
XXXX_XXXX.jos_marketplace_ads as f1
WHERE (e1.id=f1.category)
group by e1.id) as fff
where (a1.parent = ss.s_id and a1.id = fff.f_id)
order by ss.s_cnt desc, fff.f_cnt desc)
order by c4 desc, c3, !(c2=c3), f1 desc, c2";
$result = mysql_query($sql);
if (!$result) {
die('Неверный запрос: '. mysql_error());
}
$ff=1;
?>
<script type="text/javascript" src="
http://www.dom116.ru/modules/mod_swmenupro/dtree_Packed.js"></script>
<style type='text/css'>
<!--
.dtree150 {
border: 1px none #124170 !important ;
background-color: #FFFFFF !important ;
margin: 0 !important ;
padding: 2px 2px 2px 2px !important ;
}
.dtree150 img {
border: 0px !important ;
vertical-align: middle !important ;
}
.dtree150 a {
font-family: Arial, Helvetica, sans-serif !important ;
font-size: 12px !important ;
text-decoration: none !important ;
font-weight: bold !important ;
color: #666666 !important ;
text-decoration: none !important ;
}
.dtree150 a.node, .dtree150 a.nodeSel {
white-space: nowrap;
padding: 2px 2px 2px 2px !important ;
}
.dtree150 a.node:hover, .dtree150 a.nodeSel:hover {
color: #000000 !important ;
font-weight: normal !important ;
background-color: #CCC !important ;
}
.dtree150 a.nodeSel {
background-color: #CCC !important ;
}
.dtree150 .clip {
overflow: hidden;
}
-->
</style>
<script type="text/javascript">
<!--
d150= new dTree('d150');
d150.add(0,-1,'');
<?php
while ($row = @mysql_fetch_assoc($result)){
$max_len=35;
if ($row['par']==0) {
$my_sub = "(".$row['f1'].") ".substr($row['c2'], 0, 25);
echo "d150.add(".$row['c1'].",0,'".$my_sub."','
http://www.dom116.ru/doska/','".$my_sub."','_self','','');";
} else {
$my_sub = "(".$row['f1'].") ".substr($row['c2'], 0, 25);
echo "d150.add(".$row['c1'].",".$row['par'].",'".$my_sub."','
http://www.dom116.ru/doska/page/show_category/catid/".$row['c1']."','".$my_sub."','_self','','');";
}
$ff=$ff+1;
}
?>
d150.menuid=150;
d150.config.target=null;
d150.config.folderLinks=false;
d150.config.useSelection=false;
d150.config.useCookies=true;
d150.config.useLines=false;
d150.config.useIcons=true;
d150.config.useStatusText=false;
d150.config.closeSameLevel=false;
d150.config.inOrder=true;
d150.icon.root='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/1.gif';d150.icon.folder='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/folder.gif';d150.icon.folderOpen='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/folderopen.gif';d150.icon.node='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/page.gif';d150.icon.empty='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/empty.gif';d150.icon.line='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/line.gif';d150.icon.join='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/join.gif';d150.icon.joinBottom='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/joinbottom.gif';d150.icon.plus='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/plus.gif';d150.icon.plusBottom='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/plusbottom.gif';d150.icon.minus='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/minus.gif';d150.icon.minusBottom='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/minusbottom.gif';d150.icon.nlPlus='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/nolines_plus.gif';d150.icon.nlMinus='
http://www.dom116.ru/modules/mod_swmenupro/images/tree_icons/nolines_minus.gif';document.write(d150);
//-->
</script>
[/spoiler]
следующим шагом будет реализация показа обьектов на карте, за описание создания был бы очень благодарен