$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";
