function dbExec($sql, $vars = null) { global $db, $dbg, $uid; if ($vars != null) { $rs = $db->Execute($sql, $vars); } else { $rs = $db->Execute($sql); } if (!$rs) { p_sqlfail($db, $sql); } return $rs; }
function dbExec($db, $sql) { $rs = $db->Execute($sql); if (!$rs) { p_sqlfail($db, $sql); } return $rs; }
break; } // someone else tried to grab at the same time as us. // decrement my grab and try again ... dbg("grab failed"); $sql = "update groups set grab=grab-1 where id={$id}"; $rs = $db->Execute($sql); dbg("grab count decremented"); logit("grab failed (id={$id})"); $n++; } // Store my info into the group $sql = "update groups set teacher_code={$teacher_code}, name='{$name}', city_name='',week=0 where id={$id}"; $rs = $db->Execute($sql); if (!$rs) { p_sqlfail($db, $sql); } logit("group {$id} acquired by teacher {$teacher_code}"); //msgRedirect("Group created successfully.", $anchor); //exit; anchorRedirect($anchor, $tab); } else { if ($action == "addtogroup") { $anchor = rt("anchor"); $tab = rt("tab"); $gid = rt("gid"); $students = $_GET["student"]; $sql = "select count(*) from users where active=1 and teacher_code={$teacher_code} and group_id={$gid}"; $rs = dbExec($sql); $spaceleft = 4 - $rs->fields(0); $numprovided = count($students);
function logit($msg) { global $db; $msg = preg_replace("/'/", "\\'", $msg); dbg("logging '{$msg}'"); $sql = "insert into log (stamp, msg) values (now(), '{$msg}')"; $rs = $db->Execute($sql); if (!$rs) { p_sqlfail($db, $sql); } }
function find_available_group($teacher_code) { global $db; $sql = "select * from groups where teacher_code={$teacher_code}"; $rs = $db->Execute($sql); if (!$rs) { p_sqlfail($db, $sql); } while (!$rs->EOF) { $id = $rs->fields("id"); $num_in_group = num_in_group($id); if ($num_in_group < 4) { dbg("found an existing group with space; id={$id}"); return $id; } $rs->MoveNext(); } dbg("couldn't find an existing group with space"); return 0; }
function optAvailStudents($teacher_code) { global $db; $r = ""; $sql = "select * from users where "; $sql .= "active=1 and "; $sql .= "teacher_code={$teacher_code} and "; $sql .= "user_type='s' and "; $sql .= "group_id=0 "; $sql .= "order by last_name"; $rs = $db->Execute($sql); if (!$rs) { p_sqlfail($db, $sql); } while (!$rs->EOF) { $id = $rs->fields("id"); $first_name = $rs->fields("first_name"); $last_name = $rs->fields("last_name"); $r .= "<option value={$id}>{$first_name} {$last_name}</option>\n"; $rs->MoveNext(); } return $r; }