NobuNobu
nobun****@users*****
2006年 12月 28日 (木) 22:09:44 JST
Index: xoops2jp/html/modules/legacy/admin/blocks/AdminSideMenu.class.php diff -u xoops2jp/html/modules/legacy/admin/blocks/AdminSideMenu.class.php:1.1.2.3 xoops2jp/html/modules/legacy/admin/blocks/AdminSideMenu.class.php:1.1.2.4 --- xoops2jp/html/modules/legacy/admin/blocks/AdminSideMenu.class.php:1.1.2.3 Sat Nov 11 18:34:33 2006 +++ xoops2jp/html/modules/legacy/admin/blocks/AdminSideMenu.class.php Thu Dec 28 22:09:44 2006 @@ -68,10 +68,11 @@ $mod = $db->prefix("modules"); $perm = $db->prefix("group_permission"); $groups = implode(",", $user->getGroups()); - - $sql = "SELECT DISTINCT ${mod}.mid FROM ${mod},${perm} " . - "WHERE ${mod}.isactive=1 AND ${mod}.mid=${perm}.gperm_itemid AND ${perm}.gperm_name='module_admin' AND ${perm}.gperm_groupid IN (${groups}) " . - "ORDER BY ${mod}.weight, ${mod}.mid"; + + $sql = "SELECT DISTINCT ${mod}.mid FROM ${mod},${perm} " . + "WHERE ${mod}.isactive=1 AND ${mod}.mid=${perm}.gperm_itemid AND ${perm}.gperm_name='module_admin' AND ${perm}.gperm_groupid IN (${groups}) " . + "AND ${mod}.hasadmin=1 " . + "ORDER BY ${mod}.weight, ${mod}.mid"; $result=$db->query($sql);