} $limit = 15; // Limit $page = $menu->getA(1) == 'p' ? $menu->getE(1) : 1; $MPL = db_make_sites($page, "WHERE name LIKE '" . $q . "'", $limit, '?user', 'user'); $anfang = ($page - 1) * $limit; $class = ''; $q = "SELECT name,recht,id FROM `prefix_user` WHERE name LIKE '" . $q . "' ORDER by recht,posts DESC LIMIT " . $anfang . "," . $limit; $erg = db_query($q); while ($row = db_fetch_object($erg)) { if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $ar = array('name' => $row->name, 'class' => $class, 'id' => $row->id, 'grouplist' => user_get_group_list($row->id), 'recht' => dblistee($row->recht, "SELECT id,name FROM prefix_grundrechte ORDER BY id ASC"), 'modslist' => user_get_mod_change_list($row->id)); $tpl->set_ar_out($ar, 1); } $tpl->set_out('MPL', $MPL, 2); $design->footer(); break; // gruppen zugehoerigkeiten eines users aendern // gruppen zugehoerigkeiten eines users aendern case 'gruppen': $uid = $menu->get(2); if (isset($_POST['usergroups'])) { $erg = db_query("SELECT id FROM prefix_groups"); while ($row = db_fetch_assoc($erg)) { $ck = db_count_query("SELECT COUNT(uid) FROM prefix_groupusers WHERE uid = " . $uid . " AND gid = " . $row['id']); if ($ck == 0 and isset($_POST['grprhave'][$row['id']][$uid])) { db_query("INSERT INTO prefix_groupusers (uid,gid,fid) VALUES ( " . $uid . ", " . $row['id'] . ", 3 )");
} $limit = 15; // Limit $page = $menu->getA(1) == 'p' ? $menu->getE(1) : 1; $MPL = db_make_sites($page, "WHERE `name` LIKE '" . $q . "'", $limit, 'admin.php?user', 'user'); $anfang = ($page - 1) * $limit; $class = ''; $grundrechte = simpleArrayFromQuery('SELECT `id`,`name` FROM `prefix_grundrechte` ORDER BY `id` ASC'); $users = allRowsFromQuery('SELECT `name`,`recht`,`id` FROM `prefix_user` WHERE `name` LIKE "' . $q . '" ORDER BY `recht`,`posts` DESC LIMIT ' . $anfang . ',' . $limit, 'id'); $userids = array_keys($users); $modulerights = allRowsFromQuery('SELECT * FROM `prefix_modulerights` WHERE `uid` < 1 OR `uid` IN (' . implode(',', $userids) . ') ORDER BY `uid`'); $modulenames = simpleArrayFromQuery('SELECT `id`, `name` FROM `prefix_modules` WHERE `fright` = 1'); foreach ($users as $row) { $class = $class == 'Cmite' ? 'Cnorm' : 'Cmite'; $row['class'] = $class; $row['grouplist'] = user_get_group_list($row['id']); $row['modslist'] = user_get_mod_list($row['id'], $row['recht'], $modulenames, $modulerights); if (strlen($row['modslist']) > 90) { $row['modslist'] = substr($row['modslist'], 0, 87) . '...'; } $row['recht'] = arlistee($row['recht'], $grundrechte); $tpl->set_ar_out($row, 1); } $tpl->set_out('MPL', $MPL, 2); $design->footer(); break; // gruppen zugehoerigkeiten eines users aendern // gruppen zugehoerigkeiten eines users aendern case 'gruppen': $uid = $menu->get(2); if (isset($_POST['usergroups']) and chk_antispam('adminuser_action', true)) {