if (mysql_result($result, $i, "opsreq_opt8") == 'Y') {
$options = $options . " (" . $event_tools_op_session_opt8_name . ") ";
}
if ($options != "") {
$sessions = $sessions . "\n" . $options;
}
$sessions = $sessions . "\n\n";
if ($i == $num - 1 || $lastmajorkey != mysql_result($result, $i + 1, "show_name") . mysql_result($result, $i + 1, "start_date")) {
if ($i < $num - 1) {
$lastmajorkey = mysql_result($result, $i + 1, "show_name") . mysql_result($result, $i + 1, "start_date");
}
if ($testto == '$') {
$to = mysql_result($result, $i, "layout_owner_email");
} else {
$to = $testto;
}
echo "Sending to " . mysql_result($result, $i, "layout_owner_email") . ' ' . mysql_result($result, $i, "show_name") . '(' . $to . ')<p>';
$subject = "Operating Session Assignments";
$headers = "from: " . $from . "\nreply-to: " . $reply . "\nbcc: " . $bcc;
$body = $part1 . "\n\n" . daydatetime_from_long_format(mysql_result($result, $i, "start_date")) . " session attendees:\n\n" . $sessions . "\n\n\n";
mail($to, $subject, $body, $headers);
echo '<hr>' . $body . '<hr>';
$sessions = "";
}
$i++;
}
mysql_close();
echo "</clinics>\n";
?>
if (!($args["operator"] == NONE || $args["operator"] == "" || $args["operator"] == "(ALL)")) {
$where = "AND opsreq_person_email = '" . $args["operator"] . "' ";
} else {
$where = "";
}
$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 " . $where . "\r\n AND show_name != ''\r\n AND status = '1'\r\n ORDER BY opsreq_group_cycle_name\r\n ";
$result = mysql_query($query);
$num = mysql_numrows($result);
//echo $query;
//echo '['.$num.']';
$i = 0;
$lastmajorkey = mysql_result($result, $i, "opsreq_person_email");
$part1 = $args["content"] . "\n\n";
$sessions = "";
while ($i < $num) {
$sessions = $sessions . mysql_result($result, $i, "show_name") . "\n" . daydatetime_from_long_format(mysql_result($result, $i, "start_date")) . "\n\n";
if ($i == $num - 1 || $lastmajorkey != mysql_result($result, $i + 1, "opsreq_person_email")) {
if ($i < $num - 1) {
$lastmajorkey = mysql_result($result, $i + 1, "opsreq_person_email");
}
if ($testto == '$') {
$to = mysql_result($result, $i, "opsreq_person_email");
} else {
$to = $testto;
}
echo "sending to " . mysql_result($result, $i, "opsreq_person_email") . '(' . $to . ')<p>';
$subject = $args["subject"];
$headers = "from: " . $from . "\nreply-to: " . $reply . "\nbcc: " . $bcc;
$body = $part1;
if ($args["noassignments"] != "on") {
$body = $body . $sessions;
function format_all_clinics_as_2table($where = "", $order = "start_date, end_date")
{
global $opts, $event_tools_db_prefix, $event_tools_href_add_on;
mysql_connect($opts['hn'], $opts['un'], $opts['pw']);
@mysql_select_db($opts['db']) or die("Unable to select database");
if ($where != NONE) {
$where = " WHERE " . $where;
}
$query = "\r\n SELECT *\r\n FROM " . $event_tools_db_prefix . "eventtools_clinics_with_tags\r\n " . $where . "\r\n ORDER BY start_date, end_date, name\r\n ;\r\n ";
//echo $query;
$result = mysql_query($query);
$i = 0;
$num = mysql_numrows($result);
//echo "num: ".$num."<br/>\n";
if ($num == 0) {
mysql_close();
return;
}
$lastmajorkey = mysql_result($result, 0, "start_date");
echo "<table border=\"1\" class=\"et-clinic\">\n";
while ($i < $num) {
if ($lastmajorkey != mysql_result($result, $i, "start_date")) {
$lastmajorkey = mysql_result($result, $i, "start_date");
echo "</table>\n";
echo "<p/>\n";
echo "<table border=\"1\" class=\"et-clinic\">\n";
}
echo "<tr class=\"et-clinic-tr1\">\n";
echo " <td class=\"et-clinic-td1\">\n";
echo " <a name=\"" . mysql_result($result, $i, "number") . "\"></a>\n";
echo " <span class=\"et-clinic-name\">" . mysql_result($result, $i, "name") . "</span>\n";
echo " </td>\n";
echo " <td class=\"et-clinic-td2\">\n";
echo " <span class=\"et-clinic-time\">" . daydatetime_from_long_format(mysql_result($result, $i, "start_date")) . " - " . time_from_long_format(mysql_result($result, $i, "end_date")) . "</span>\n";
echo " </td>\n";
echo "</tr>\n";
if (mysql_result($result, $i, "clinic_presenter") != '') {
$clinic_presenter = mysql_result($result, $i, "clinic_presenter");
} else {
$clinic_presenter = "(no presenter name provided)";
}
if (mysql_result($result, $i, "description") != '') {
$description = mysql_result($result, $i, "description");
} else {
$description = "(no description provided)";
}
echo "<tr class=\"et-clinic-tr2\">\n";
echo " <td class=\"et-clinic-td1\">\n";
echo " <span class=\"et-clinic-presenter\">" . $clinic_presenter . "</span>\n";
echo " </td>\n";
echo " <td class=\"et-clinic-td2\">\n";
echo " <span class=\"et-clinic-location\">" . mysql_result($result, $i, "location_name") . "</span>\n";
echo " </td>\n";
echo "</tr>\n";
echo "<tr class=\"et-clinic-tr3\">\n";
echo " <td colspan=\"2\" class=\"et-clinic-td1\">\n";
echo " <div class=\"et-clinic-description\">" . $description . "</div>\n";
echo " </td>\n";
echo "</tr>\n";
echo "<tr class=\"et-clinic-tr4\">\n";
echo " <td colspan=\"2\" class=\"et-clinic-td1\">\n";
if (mysql_result($result, $i, "clinic_url") != '') {
echo " <span class=\"et-clinic-url\"><a " . $event_tools_href_add_on . " href=\"" . mysql_result($result, $i, "clinic_url") . "\">" . mysql_result($result, $i, "clinic_url") . "</a></span>\n";
}
echo " </td>\n";
echo "</tr>\n";
// process tags
echo "<tr class=\"et-clinic-tr5\">\n";
echo " <td colspan=\"2\" class=\"et-clinic-td1\"><span class=\"et-clinic-tags\">\n";
echo mysql_result($result, $i, "tag_name");
while ($i < $num - 1 && mysql_result($result, $i, "name") == mysql_result($result, $i + 1, "name")) {
$i++;
echo ",\n" . mysql_result($result, $i, "tag_name");
}
echo "\n </span></td>\n";
echo "</tr>\n";
// spare line at end
echo "<tr class=\"et-clinic-tr6\">\n";
// blank line
echo " <td colspan=\"2\" class=\"et-clinic-td1\">\n";
echo " </td>\n";
echo "</tr>\n";
$i++;
}
// done, clean up
echo "</table>\n";
mysql_close();
}
