$value) { if ($value && preg_match('/del([0-9]+)/i', $key, $m)) { $uid = intval($m[1]); Query("DELETE FROM wm_users WHERE id=$uid"); Query("DELETE FROM wm_group_assoc WHERE `user`=$uid"); Query("DELETE FROM wm_bets WHERE `user`=$uid"); } } } // Get and abbreviate group names $groups = array(); $abbrev = array(); foreach(Query("SELECT id, name FROM wm_groups") as $item) { $id = $item['id']; $name = $item['name']; $groups[$id] = $name; $abbrev[$id] = preg_replace('/((der|die|das|ein|eine|the|familie)\s+)+/i', "", $name); } // determine length of group names for the headers function IsUnique($len) { global $groups, $abbrev; $map = array(); foreach($abbrev as $id => $name) { $part = trim(substr($name, 0, $len)); if(isset($map[$part])) return FALSE; $map[$part] = TRUE; } return TRUE; } for($NameLength = 4; !IsUnique($NameLength); $NameLength++); // get matrix of group associations $matrix = array(); $res = $dbConn->query("SELECT * FROM wm_group_assoc", MYSQLI_USE_RESULT); while (($row = $res->fetch_assoc())) { if (!isset($matrix[$row['user']])) $matrix[$row['user']] = array(); $matrix[$row['user']][$row['group']] = $row['id']; } $res->free(); // page header echo <<Nutzer/Gruppen-Matrix

Sortieren nach: ID Name E-Mail Domain

EOF; // start query $order = @$_GET['order']; $ocode = "ORDER BY id ASC"; if ($order == 'name') $ocode = "ORDER BY name ASC, email ASC"; else if ($order == 'email') $ocode = "ORDER BY email ASC"; else if ($order == 'domain') $ocode = "ORDER BY domain ASC, email ASC"; $res = $dbConn->query("SELECT id, name, akey, email, score, SUBSTRING_INDEX(email,'@',-1) AS domain, (SELECT COUNT(*) FROM wm_bets WHERE user = wm_users.id) AS bets FROM wm_users $ocode", MYSQLI_USE_RESULT); // main loop $n = 0; while (($row = $res->fetch_assoc())) { if (!($n % 20)) { echo "\n"; foreach($groups as $id => $fullname) { echo "\n"; } echo "\n"; } $n++; echo "\n\n"; $check = $row['akey'] ? "onclick=\"toggle(event)\"" : "checked=\"checked\" disabled=\"disabled\""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $mrow = @$matrix[$row['id']]; foreach($groups as $gid => $dummy) { $check = isset($mrow[$gid]) ? " checked=\"checked\"" : ""; echo "\n"; } echo "\n"; } $res->free(); // end of page echo <<

Ja, wirklich!

Zurück zum Admin-Menü

EOF; CloseDB(); EndPage(); ?>

ID	Akt?	Del?	Name	E-Mail	Punkte	#Tipps	"; echo htmlescape(substr($abbrev[$id], 0, $NameLength)) . "
{$row['id']}			" . htmlescape($row['name']) . "	" . htmlescape($row['email']) . "	{$row['score']}	{$row['bets']}