Tweet
$result = $query->select('SELECT m2.menu_id, m2.level, m2.sort, m2.parent_id,
if(isnull(mu.user_right),0,mu.user_right) +
sum(mu2.user_right) my_user_right, d.text
FROM menus m
LEFT JOIN menus_has_menus mm
ON ( m.menu_id = mm.child_id )
LEFT JOIN menus m2
ON ( mm.menu_id = m2.parent_id )
LEFT JOIN menus_has_user mu
ON ( m2.menu_id = mu.menu_id AND mu.user_id = 1)
LEFT JOIN menus_has_menus mm2
ON ( m2.menu_id = mm2.child_id )
LEFT JOIN menus_has_user mu2
ON ( mm2.menu_id = mu2.menu_id AND mu2.user_id = 1)
LEFT JOIN datas d
ON ( m2.data_id = d.data_id )
WHERE m.menu_id = '.$site.' or m.parent_id = '.$site.'
GROUP BY m2.menu_id, m2.parent_id, m2.level, m2.sort
ORDER BY m2.parent_id, m2.level, m2.sort');
[/color]<-ForumSuche rettet Leben-> || <-Schau in den Codeschnippsels->
wenn die Sache richtig programmiert ist gibt es keine Probleme. Ich hatte bei einem Projekt über 10 Tausen Einträge mit bis zum Level 10 und es dauerte vielleicht mal 2 Sekunden bis der Baum im Browser angezeigt wurde.
$result_module_preferences = $this->_db->query("SELECT `module_table_name`,
`module_primary_key`,
`module_secondary_key`,
`recursive_permission_check`
FROM {prefix}modules WHERE `module`='".$this->_db->escape($module)."'");
$row_module_preferences = $this->_db->fetch_assoc($result_module_preferences);
if ($row_module_preferences['recursive_permission_check'] == 1) {
$finish = false;
while ($finish != true) {
$result_parentid = $this->_db->query("SELECT
`".$this->_db->escape($row_module_preferences['module_secondary_key'])."`
FROM {prefix}".$this->_db->escape($row_module_preferences['module_table_name'])."
WHERE
`".$this->_db->escape($row_module_preferences['module_primary_key'])."`='".$this->_db->escape($id)."'");
$row_parentid = $this->_db->fetch_assoc($result_parentid);
$result_permission = $this->_db->query("SELECT `".$this->_db->escape($access_type)."`,
`administrator`,
`backend`,
`frontend`
FROM {prefix}permissions
WHERE module='".$this->_db->escape($module)."'
AND id='".$this->_db->escape($id)."'
AND group_id='".$this->_db->escape($group_id)."'");
$row_permission = $this->_db->fetch_assoc($result_permission);
if ($row_permission[$access_type]) {
$id = $row_parentid[$row_module_preferences['module_secondary_key']];
if ($row_parentid[$row_module_preferences['module_secondary_key']] == 0) {
$finish = true;
}
} else {
$finish = true;
}
}
}
Sunshine CMS 
BannerAdManagement
Borlabs - because we make IT easier
Formulargenerator [color=red]Neu![/color]
Herkunftsstatistik [color=red]Neu![/color]
Sunshine CMS BannerAdManagement Borlabs - because we make IT easier Formulargenerator [color=red]Neu![/color] Herkunftsstatistik [color=red]Neu![/color]
Kommentar