<h2>Who has played?</h2> <div id=inset> <?php $rs = dbExec("select\n\t\t\t\t\tid,\n\t\t\t\t\tlast_name,\n\t\t\t\t\tfirst_name,\n\t\t\t\t\tusername,\n\t\t\t\t\tschool_code,\n\t\t\t\t\tteacher_code,\n\t\t\t\t\tweek\n\t\t\t\t\tgroup_id\n\t\t\t\tfrom\n\t\t\t\t\tusers\n\t\t\t\tWHERE\n\t\t\t\t\t`active` = 1\n\t\t\t\t\tAND\n\t\t\t\t\t`user_type` = 's'\n\t\t\t\t\tAND\n\t\t\t\t\t`school_code` !=0\n\t\t\t\t\tAND\n\t\t\t\t\t`auth_count` > 0\n\t\t\t\t\tAND\n\t\t\t\t\t`gamedata` != ''\n\t\t\t\torder by\n\t\t\t\t\tlast_name\n\t\t\t\t\t"); $students = array(); while (!$rs->EOF) { $o = $rs->FetchNextObj(); $students[$o->id] = $o; } $schools = array(); $ref = array(); foreach ($students as $s) { $c = $s->school_code; if (!$ref[$c]) { $ref[$c] = true; $o = getrecobj("schools", "where code = {$c}"); $schools[$o->name] = $o; } } $teachers = array(); $ref = array(); foreach ($students as $s) { $c = $s->teacher_code; if (!$ref[$c]) { $ref[$c] = true; $rs = dbExec("select\n\t\t\t\t\t\t\tid,\n\t\t\t\t\t\t\tlast_name,\n\t\t\t\t\t\t\tfirst_name,\n\t\t\t\t\t\t\tconcat(last_name,', ',first_name) as name,\n\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\tschool_code,\n\t\t\t\t\t\t\tteacher_code,\n\t\t\t\t\t\t\tusername,\n\t\t\t\t\t\t\tpassword,\n\t\t\t\t\t\t\temail,\n\t\t\t\t\t\t\tphone\n\t\t\t\t\t\tfrom\n\t\t\t\t\t\t\tusers\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t`active` = 1\n\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t`user_type` = 't'\n\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\tteacher_code = {$c}\n\t\t\t\t\t\torder by\n\t\t\t\t\t\t\tlast_name\n\t\t\t\t\t\t\t"); $o = $rs->FetchNextObj(); $teachers[$o->name] = $o; } } ?>
<p> </div> </td> </tr> <tr><td style="padding: 2em;"> <?php $studs = array(); $sql = "select * from users where active=1 and user_type='s' and teacher_code={$teacher_code} and group_id != 0 order by last_name"; $rs_studs = dbExec($sql); while (!$rs_studs->EOF) { $o = $rs_studs->FetchNextObj(); $o->eid = "stud" . $o->id; $o->role = roleName($o->class); $o->name = $o->last_name . ", " . $o->first_name; $o->tracking = getrecobj("tracking", "where user_id=" . $o->id); $studs[$o->id] = $o; } $teams = array(); $sql = "select * from groups where teacher_code={$teacher_code} order by name"; $rs_teams = dbExec($sql); while (!$rs_teams->EOF) { $o = $rs_teams->FetchNextObj(); $o->eid = "team" . $o->id; $o->studs = array(); $teams[$o->id] = $o; } foreach ($studs as $o) { $t = $teams[$o->group_id]; $o->team = $t; array_push($t->studs, $o);