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