Example #1
0
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();
}
Example #2
0
 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";
     }
 }