function format_as_table($formatter, $where = NONE, $order = NONE, $url = NONE) { // note argument order differs global $opts, $event_tools_db_prefix; mysql_connect($opts['hn'], $opts['un'], $opts['pw']); @mysql_select_db($opts['db']) or die("Unable to select database"); //echo $formatter->select_statement($where, $order)."<br/>\n"; $result = mysql_query($formatter->select_statement($where, $order)); $i = 0; $num = mysql_numrows($result); //echo "num: ".$num."<br/>\n"; if ($num == 0) { mysql_close(); return; } $lastmajorkey = ""; $first = 0; while ($i < $num) { if ($lastmajorkey != $formatter->get_major_key($result, $i)) { $lastmajorkey = $formatter->get_major_key($result, $i); if (checkShowEventStatus($result, $i)) { // end any existing table if ($first != 0) { echo "</table>\n"; } $first = 1; // start a new table echo "\n"; echo "<table border=\"1\" class=\"et-lt-table\">\n"; $formatter->format_heading($result, $i, $url); } } if (checkShowEventStatus($result, $i)) { $formatter->format_subitem($result, $i, $url); } $i++; } echo '</table>'; mysql_close(); }
public function format_item($result, $i, $url) { global $event_tools_replace_on_data_error; if (checkShowEventStatus($result, $i)) { $cost = show_status_link_or_cost($result, $i); $date = daytime_from_long_format(mysql_result($result, $i, "start_date")) . " - " . time_from_long_format(mysql_result($result, $i, "end_date")); echo "<tr class=\"et-lt-tour-tr1\">\n"; echo " <td class=\"et-lt-tour-td1\">\n"; echo " <span class=\"et-lt-tour-tourNumber\">\n"; echo " <a href=\"" . $url . mysql_result($result, $i, "number") . "\">" . mysql_result($result, $i, "number") . "</a>\n"; echo " </span>\n"; echo " </td>\n"; echo " <td class=\"et-lt-tour-td2\">\n"; echo " <span class=\"et-lt-tour-tourName\">\n"; echo " <a href=\"" . $url . mysql_result($result, $i, "number") . "\">" . htmlspecialchars(mysql_result($result, $i, "name")) . "</a>\n"; echo " </span>\n"; echo " </td>\n"; echo " <td class=\"et-lt-tour-td3\">\n"; echo " <span class=\"et-lt-tour-tourDateTime\">" . $date . "</span>\n"; echo " </td>\n"; echo " <td class=\"et-lt-tour-td4\">\n"; echo " <span class=\"et-lt-tour-tourCost\">" . $cost . "</span>\n"; echo " </td>\n"; echo "</tr>\n"; } }