function insert_multiple_ops_request_structure($cycle, $reqs)
{
$num = mysql_numrows($reqs);
// create the group entries, one for each
for ($i = 0; $i < $num; $i++) {
// skip if no selections
if (mysql_result($reqs, $i, "opsreq_pri1") <= "1" && mysql_result($reqs, $i, "opsreq_pri2") <= "1" && mysql_result($reqs, $i, "opsreq_pri3") <= "1" && mysql_result($reqs, $i, "opsreq_pri4") <= "1" && mysql_result($reqs, $i, "opsreq_pri5") <= "1" && mysql_result($reqs, $i, "opsreq_pri6") <= "1" && mysql_result($reqs, $i, "opsreq_pri7") <= "1" && mysql_result($reqs, $i, "opsreq_pri8") <= "1" && mysql_result($reqs, $i, "opsreq_pri9") <= "1" && mysql_result($reqs, $i, "opsreq_pri10") <= "1" && mysql_result($reqs, $i, "opsreq_pri11") <= "1" && mysql_result($reqs, $i, "opsreq_pri12") <= "1") {
echo "Skip " . mysql_result($reqs, $i, "opsreq_person_email") . "<br/>";
continue;
}
// now insert
insert_one_ops_request_structure($cycle, $reqs, $i);
}
}
if ($args["op"] == "Add") {
// skip if already exists
$query = "\r\n SELECT *\r\n FROM " . $event_tools_db_prefix . "eventtools_ops_group_session_assignments\r\n WHERE opsreq_person_email = '" . $args["id"] . "'\r\n AND opsreq_group_cycle_name = '" . $cycle . "'\r\n ;\r\n ";
$reqs = mysql_query($query);
$nums = mysql_numrows($reqs);
if ($nums != 0) {
echo "Skipping duplicate add for " . $args["id"] . "</br>";
} else {
// make the entire line for a new user
$query = "\r\n SELECT *\r\n FROM " . $event_tools_db_prefix . "eventtools_opsession_req\r\n WHERE opsreq_person_email = '" . $args["id"] . "'\r\n ;\r\n ";
$reqs = mysql_query($query);
$nums = mysql_numrows($reqs);
if ($nums != 1) {
echo "wrong number of email matches: " . $nums;
}
insert_one_ops_request_structure($cycle, $reqs, 0);
}
}
}
}
// Basic approach: walk through cycle as if making a new one,
// adding changes as needed.
// first, make sure everybody is present.
$query = "\r\n SELECT *\r\n FROM " . $event_tools_db_prefix . "eventtools_opsession_req\r\n ORDER BY opsreq_person_email\r\n ;\r\n";
//echo $query;
$reqs = mysql_query($query);
$nums = mysql_numrows($reqs);
$query = "\r\n SELECT *\r\n FROM " . $event_tools_db_prefix . "eventtools_ops_group_session_assignments\r\n WHERE opsreq_group_cycle_name = '" . $cycle . "'\r\n GROUP BY opsreq_person_email\r\n ORDER BY opsreq_person_email\r\n ;\r\n";
//echo $query;
$reqd = mysql_query($query);
$numd = mysql_numrows($reqd);
