$rs = dbExec($sql); $tbl = new Table("scores"); $row = 0; while (!$rs->EOF) { $o = $rs->FetchNextObj(); //$tbl->set(mkbut("Delete", "?act=del&dec=".$o->decision, true)); //$tbl->set(mkbut("Clear", "?act=clr&dec=".$o->decision, true)); $hrow = array(); foreach ($o as $t => $v) { array_push($hrow, $t); } if ($row % 10 == 0) { foreach ($hrow as $h) { $tbl->set($h, "head"); } $tbl->nextrow(); } foreach ($o as $t => $v) { if ($t == "decision") { $tbl->set($v); } else { $class = "set_zero"; if ($v < 0) { $class = "set_neg"; } if ($v > 0) { $class = "set_pos"; } $dec = $o->decision; $minus = "<a href='javascript:set(\"{$dec}\", \"{$t}\", -1)'><</a>"; $vv = "<span class='{$class}' id='{$dec}{$t}'>{$v}</span>";
} if ($userqry) { $rs = dbExec("select\n\t\t\t\t\t\t\tu.id,\n\t\t\t\t\t\t\tu.user_type,\n\t\t\t\t\t\t\tu.username,\n\t\t\t\t\t\t\tu.password,\n\t\t\t\t\t\t\tu.first_name,\n\t\t\t\t\t\t\tu.last_name,\n\t\t\t\t\t\t\tu.email,\n\t\t\t\t\t\t\tt.name as grp,\n\t\t\t\t\t\t\tu.group_id gid,\n\t\t\t\t\t\t\tu.status,\n\t\t\t\t\t\t\tu.task_progress,\n\t\t\t\t\t\t\tu.active\n\t\t\t\t\t\tfrom users as u\n\t\t\t\t\t\tleft outer join groups as t on \n\t\t\t\t\t\t\tt.id = u.group_id\n\t\t\t\t\t\twhere\n\t\t\t\t\t\t\tu.active = 1\n\t\t\t\t\t\t\tand\n\t\t\t\t\t\t\tconcat_ws(\n\t\t\t\t\t\t\t\t' ',\n\t\t\t\t\t\t\t\tu.first_name,\n\t\t\t\t\t\t\t\tu.last_name,\n\t\t\t\t\t\t\t\tu.username,\n\t\t\t\t\t\t\t\tu.email,\n\t\t\t\t\t\t\t\tt.name\n\t\t\t\t\t\t\t\t) like '%{$userqry}%'\n\t\t\t"); $t = new Table("s"); if ($rs->RecordCount() > 0) { //$t->set("ID"); //$t->set("Active"); //$t->set("Type"); $t->set("First"); $t->set("Last"); $t->set("User"); $t->set("Pass"); $t->set("EMail"); $t->set("Team / Status"); //$t->set("Team ID"); $t->nextrow(); while (!$rs->EOF) { $o = $rs->FetchNextobj(); if (preg_match("/-delet/", $o->username)) { continue; } // xxx $ut = "cell"; if ($o->user_type == 't') { $ut = "tch"; } if ($o->user_type == 'a') { $ut = "adm"; } if ($o->active == 0) { $ut = "inact";
if ($dbg) { $guts .= "\n\t\t\t\t\t<br/>\n\t\t\t\t\t<div class=dbg>group_id: " . $o->id . "</div> \n\t\t\t\t\t<div class=dbg>server_host: " . $o->server_host . "</div>\n\t\t\t\t\t<div class=dbg>server_port: " . $o->server_port . "</div>\n\t\t\t\t\t<div class=dbg>week/task: " . $o->week . "</div> \n\t\t\t\t\t"; } if ($user_type != 't') { $guts = ""; } $t->set($guts, "ghead"); $t->nextrow(); $t2 = new Table("s"); $t2->set("Student Name"); for ($w = 1; $w <= $game_weeks; $w++) { $t2->set("Task {$w}"); } $t2->set(""); $t2->set(""); $t2->nextrow(); foreach ($o->studs as $o2) { $eid = "stud" . $o2->id; $z = $o2->name; $z = preg_replace("/ /", " ", $z); if ($user_type == 't') { $z = "<a href='javascript:showdet(\"{$eid}\")' >{$z}</a>"; } $up = "Username: "******"<br/>"; $up .= "Password: "******"<br/>"; $plusdbg = ""; if ($dbg) { $plusdbg = "\n\t\t\t\t\t\t\t\t<div class='dbg'>user id: " . $o2->id . "</div>\n\t\t\t\t\t\t\t\t<div class='dbg'>created: " . $o2->created . "</div>\n\t\t\t\t\t\t\t\t<div class='dbg'>modified: " . $o2->modified . "</div>\n\t\t\t\t\t\t\t\t<div class='dbg'>sid: " . $o2->sid . "</div>\n\t\t\t\t\t\t\t\t<div class='dbg'>school_code: " . $o2->school_code . "</div>\n\t\t\t\t\t\t\t\t<div class='dbg'>group_id: " . $o2->group_id . "</div>\n\t\t\t\t\t\t\t"; } if ($user_type == 't') { $z .= "\n\t\t\t\t\t\t<div style='display: none;' id='{$eid}'>\n\t\t\t\t\t\t\t<div class='studdet'>\n\t\t\t\t\t\t\t\tRole: " . $o2->role . "<br/>\n\t\t\t\t\t\t\t\tUsername: "******"<br/>\n\t\t\t\t\t\t\t\tPassword: "******"<br/>\n\t\t\t\t\t\t\t\tLogins: " . $o2->auth_count . "<br/>\n\t\t\t\t\t\t\t\t{$plusdbg}\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t";