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;
}
