"Listings_Session", "auth" => "Listings_Auth", "perm" => "Listings_Perm")); $db = new DB_Listings; $db1 = new DB_Listings; print "

ShowBiz Ireland Listings Engine

\n"; if (isset($logout)) { $auth->logout(); page_close(); exit; } ?> Listings Engine Home
To Logout click
auth["uname"]; $listings_id = md5(time() . $username); $msg = "Thats grand so, " . $username; $date = $yyyy . "-" . $mm . "-" . $dd; $doors = $doorshour .".". $doorsminute .".". $doorsampm; $todayArray = getdate(time()); $day = $todayArray["mday"]; $month = $todayArray["mon"]; $year = $todayArray["year"]; $today = $year . "-" . $month . "-" . $day; $description = nl2br($description); $SQL = "insert into listings (event, date, doors, venue, price, category, description, username, listings_id, link) "; $SQL .= "values ('$event', '$date', '$doors', '$venue', '$price', '$category', '$description', '$username', '$listings_id', '$link')"; $db->query($SQL); $SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id from listings where date >= '$today' order by date limit 5"; $db->query($SQL); $fp = fopen("listings.htm", "w"); fwrite($fp, "\n"); fwrite($fp, "\n"); fwrite($fp, "\n"); fwrite($fp, "\n"); fwrite($fp, "\n"); $i = 1; while ($db->next_record()) { if (($i % 2) == 0) $cc = "#FFFFCC"; else $cc = "#99CC99"; $i++; fwrite($fp, ""); fwrite($fp, ""); fwrite($fp, ""); fwrite($fp, ""); } fwrite($fp, "
DATE
EVENT
\n"); fwrite($fp, "
VENUE
\n"); fwrite($fp, "
TIME
\n"); fwrite($fp, $db->f("DATE_FORMAT(date, '%d/%m/%Y')")); fwrite($fp, "
\n"); fwrite($fp, ""); fwrite($fp, $db->f("event")); fwrite($fp, "\n"); fwrite($fp, "
\n"); fwrite($fp, $db->f("venue")); fwrite($fp, "
\n"); fwrite($fp, $db->f("doors")); fwrite($fp, "
\n"); fclose($fp); print "

Your listing has been made live.\n"; print "
To see your listing Click Here\n"; print "
To go back to the engine pself_url(); print "\">Click Here\n"; print "
Please do not click your back button as it may resubmit the listing!\n"; } else { print "Hello " . $auth->auth["uname"] . ". Welcome to the ShowBiz Ireland Listings Engine\n"; if ((!isset($update)) && (!isset($delete)) && (!isset($edit))) { ?>

Add Listing

Event:
Date(dd/mm/yyyy): /
Doors:
Venue:
Price:
Category:
Description:
Link:
query($SQL); $db->next_record(); ?>

Update this article

Date: f("DATE_FORMAT(date, '%d/%m/%Y')"); list ($dd, $mm, $yyyy) = split ('[/.-]', $date); $doors = $db->f("doors"); list ($doorshour, $doorsminute, $doorsampm) = split ('[/.-]', $doors); ?> / /
Event: " maxlength="25">
Venue: " maxlength="25">
Doors: Hours Minutes AM/PM
Link: ">
Category:
f("description")); ?> Description:
query($SQL); print "

Your listing has been made live.\n"; print "
To see your listing Click Here\n"; print "
To go back to the engine pself_url(); print "\">Click Here\n"; print "
Please do not click your back button as it may resubmit the listing!\n"; } if (isset($delete)) { $SQL = "delete from listings where listings_id = '$listings_id'"; $db->query($SQL); $SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id from listings order by date desc limit 5"; $db->query($SQL); $fp = fopen("listings.htm", "w"); fwrite($fp, "\n"); fwrite($fp, "\n"); fwrite($fp, "\n"); fwrite($fp, "\n"); fwrite($fp, "\n"); $i = 1; while ($db->next_record()) { if (($i % 2) == 0) $cc = "#FFFFCC"; else $cc = "#99CC99"; $i++; fwrite($fp, ""); fwrite($fp, ""); fwrite($fp, ""); fwrite($fp, ""); } fwrite($fp, "
DATE
EVENT
\n"); fwrite($fp, "
VENUE
\n"); fwrite($fp, "
TIME
\n"); fwrite($fp, $db->f("DATE_FORMAT(date, '%d/%m/%Y')")); fwrite($fp, "
\n"); fwrite($fp, ""); fwrite($fp, $db->f("event")); fwrite($fp, "\n"); fwrite($fp, "
\n"); fwrite($fp, $db->f("venue")); fwrite($fp, "
\n"); fwrite($fp, $db->f("doors")); fwrite($fp, "
\n"); fclose($fp); } if ((!isset($edit)) && (!isset($update))) { $day = $dateArray["mday"]; $month = $dateArray["mon"]; $year = $dateArray["year"]; $today = $year. "-" . $month . "-" . $day; if ($auth->auth["perm"] != "admin") { $un = $auth->auth["uname"]; $SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id, username from listings where username = '$un' and date >= '$today' order by date desc limit 10"; } else { $SQL = "select DATE_FORMAT(date, '%d/%m/%Y'), event, venue, doors, listings_id, username from listings where date >= '$today' order by date desc"; } $db->query($SQL); ?> next_record()) { ?> "> ">
p("DATE_FORMAT(date, '%d/%m/%Y')"); ?> p("event"); ?> p("venue"); ?> p("doors"); ?> p("username"); ?>