\n" ?> db issue"; return; } mysql_select_db('webdriver09'); $timestamp = mktime(); $month = date('m',$timestamp); $day = date('d',$timestamp); $year = date('Y',$timestamp); $start_day = mktime(00, 00, 00, $month, $day, $year); $end_day = mktime(23, 59, 00, $month, $day+20, $year); $query = "SELECT * FROM gigdates WHERE gignum BETWEEN " . $start_day . " AND " . $end_day . " AND usetype = 'B' LIMIT 0, 14"; $result = mysql_query($query); $cnt = 0; $cnt1 = 0; $V = "var linkarray = new Array();\nvar dayarray = new Array();\nvar namearray = new Array();\nvar folderarray = new Array();\nvar timearray = new Array();\nvar coverarray = new Array();\nvar datearray = new Array();\nvar todayarray = new Array();\nvar infoarray = new Array();\n\n\n"; $vrow = array(); $dbl = array(); $tflag = 0; $tonight = 0; while($row = mysql_fetch_array($result)) { $vrow[$cnt1] = $row; $tcnt = $cnt1 - 1; if ($tcnt > -1 && (date('l', $row['GigNum']) == date('l', $vrow[$tcnt]['GigNum'])))$dbl[$tcnt] = 1; $cnt1++; } $infoarray = array(); $gigdatearray = array(); $namearray = array(); $linkarray = array(); $folderarray = array(); $cnt1 = 0; mysql_close($link); while ($cnt1 < 8) { $tempdayM = mktime(00, 00, 00, date('m',$vrow[$cnt1]['GigNum']), date('d',$vrow[$cnt1]['GigNum']), date('y',$vrow[$cnt1]['GigNum'])); $namearray[$cnt1] = preg_replace('/%2526/', "&", $vrow[$cnt1]['Name']); $linkarray[$cnt1] = $vrow[$cnt1]['SiteURL']; $folderarray[$cnt1] = $vrow[$cnt1]['Folder']; $gigdatearray[$cnt1] = $vrow[$cnt1]['GigNum']; $tfilen = "../bands/" . $vrow[$cnt1]['Folder'] . "/about.txt"; if (file_exists($tfilen)) { $fd = fopen ($tfilen, "r"); while (!feof ($fd)) { $buffer = fgets($fd, 2048); $infoarray[$cnt1] .= urlencode($buffer); } fclose ($fd); } else { $tfilen = "../bands/" . $vrow[$cnt1]['Folder']; if (!is_dir($tfilen)) { mkdir($tfilen , 0755); $headers = "From: website_no_reply@otr-bar.com\r\n"; $headers .= "X-Mailer: PHP/".phpversion(); $mess1 = $vrow[$cnt1]['Folder'] . " is not setup"; mail("bookings@otr-bar.com", $vrow[$cnt1]['Folder'], $mess1, $headers); } $infoarray[$cnt1] = ""; } $V .= "\nnamearray[" . $cnt1 . "] = '" . $namearray[$cnt1] . "';"; $V .= "\nlinkarray[" . $cnt1 . "] = '" . $linkarray[$cnt1] . "';"; $V .= "\ninfoarray[" . $cnt1 . "] = '" . $infoarray[$cnt1] . "';"; $V .= "\nfolderarray[" . $cnt1 . "] = '" . $folderarray[$cnt1] . "';"; $V .= "\ndayarray[" . $cnt1 . "] = '" . date('l', $vrow[$cnt1]['GigNum']) . "';"; $V .= "\ntimearray[" . $cnt1 . "] = '" . date('g:i', $vrow[$cnt1]['GigNum']) . "';"; $V .= "\ncoverarray[" . $cnt1 . "] = '"; $V .= (date('w', $vrow[$cnt1]['GigNum']) == 5 || date('w', $vrow[$cnt1]['GigNum']) == 6)?"Cover - $5';":"No Cover';"; $V .= "\ndatearray[" . $cnt1 . "] = '" . date('mdy', $vrow[$cnt1]['GigNum']). "';"; $V .= "\ntodayarray[" . $cnt1 . "] = '"; $V .= ($start_day == $tempdayM)?"1';":"0';"; if ($start_day == $tempdayM) $tonight = 1; $cnt1++; } ?> On the Rocks - Home
 
"; ?>
\n"; $tV .= ($cnt == 1 || $cnt == 3)?"\n":""; $cnt++; } echo $tV; ?>
Start Time: " . date('g:i', $vrow[0]['GigNum']) . "
"; echo (date('w', $vrow[0]['GigNum']) == 5 || date('w', $vrow[0]['GigNum']) == 6)?"Cover - $5
":"No Cover
"; ?>
" . $namearray[0] . " Website"; echo ($dbl[0] == 1)?"
" . $namearray[1] . " Website":""; echo "
" . urldecode($infoarray[0]); ?>
"; echo "\n\t
"; echo "\n" . date('l', $vrow[$cnt]['GigNum']); echo "\n
\n\t\t
"; echo "\n\n" . $namearray[$cnt] . "\n\t
\n
"; $cnt++; } ?>
 
Our Hours -  
On The Rocks!