コード例 #1
0
ファイル: user.php プロジェクト: kveldscholten/Ilch-1.1
     }
     $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 )");
コード例 #2
0
ファイル: user.php プロジェクト: rjdesign/Ilch-1.2
     }
     $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)) {