limit list

[michaelh]

hey there,
first of all, i'm using the latest version of component and this tree module. and it is working fine.
today i customized this tree module, to only show the category with id=1 and all categories with parent_id=1.
for this i modified the sql statement by adding this line:

Code: Select all

' AND cc.id = 1 OR cc.parent_id = 1'

in mod_phocagallery_tree.php

after uploading and refreshing the site, the moduleposition was empty.
the javascript looks like generated well:

Code: Select all

<script type="text/javascript">
<!--

dtree_4c0386cd7f8ed = new dTree2548('dtree_4c0386cd7f8ed', '/modules/mod_phocagallery_tree/assets/');

dtree_4c0386cd7f8ed.add(1,0,'images','/index.php/de/galerie/category/1-images');
dtree_4c0386cd7f8ed.add(2,1,'avatars','/index.php/de/galerie/category/2-avatars');

document.write(dtree_4c0386cd7f8ed);
dtree_4c0386cd7f8ed.openTo(1,'true');

//-->
</script>

the sql-query is working fine, i tested in phpmyadmin as well.
i don't use the dtree js in any other module etc.

i hope someone can help me.

i tried to turn off joomla's search friendlie urls, but it doesn't changed anything.
thx, mike

[michaelh]

oh no
i've forgottn the setting to exclude id's in joomlas-backend, but why does my sql-query don't work?

thx, mike