./sources/schedule.php
PHP Code:
<div id="main">
<div id="primaryContent" class="">
<h1 class="title">Schedule</h1>
<p class="firstP">Below you will find out schedule for live sets, when there is no live DJ on air we will be streaming recorded mixes so there will always be something to listen to!</p>
<p>Always remember that our schedule is studio time and not necessarily your local time. We have displayed the current studio date and time below for your benefit.</p>
<p><strong>Studio Time & Date (UK):</strong> <?php $serverdate = date('l, jS F Y. H:i',time() + 0000 ); echo($serverdate); ?></p>
<div class="clear"></div><a name="times"></a>
<div class="one-third firstItem">
<h4><span>Day</span> Selection</h4>
<p class="firstP">Don't want to see todays schedule? Not a problem, just hit the day you wanna see and we'll show you what's happening.</p>
<p><a href="?id=schedule&week=Monday#times">Monday</a><br />
<a href="?id=schedule&week=Tuesday#times">Tuesday</a><br />
<a href="?id=schedule&week=Wednesday#times">Wednesday</a><br />
<a href="?id=schedule&week=Thursday#times">Thursday</a><br />
<a href="?id=schedule&week=Friday#times">Friday</a><br />
<a href="?id=schedule&week=Saturday#times">Saturday</a><br />
<a href="?id=schedule&week=Sunday#times">Sunday</a></p>
</div><!-- #one-third -->
<div class="one-third">
<h4><span>Set</span> Times</span></h4>
<?php
//set local variables
$dbhost = "localhost"; //Database Host
$dbuser = "****"; //Database User
$dbpass = "****"; //Database Password
$dbname = "****"; //Database Name
//connect
$db = mysql_pconnect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);
$day = $_GET['week'];
if($_GET['week'] == ""){
$day = date("l",time() + 3600);
$_GET['week'] = date("l",time() + 3600);
}
$result = mysql_query("SELECT * FROM rp_timetable WHERE day = '$day'");
while($slot = mysql_fetch_assoc($result)) {
if($slot["1"] == "")
{ $one = "OPEN SLOT"; }
else
{ $one = "<b>{$slot["1"]}</b>"; }
if($slot["2"] == "")
{ $two = "OPEN SLOT"; }
else
{ $two = "<b>{$slot["2"]}</b>"; }
if($slot["3"] == "")
{ $three = "OPEN SLOT"; }
else
{ $three = "<b>{$slot["3"]}</b>"; }
if($slot["4"] == "")
{ $four = "OPEN SLOT"; }
else
{ $four = "<b>{$slot["4"]}</b>"; }
if($slot["5"] == "")
{ $five = "OPEN SLOT"; }
else
{ $five = "<b>{$slot["5"]}</b>"; }
if($slot["6"] == "")
{ $six = "OPEN SLOT"; }
else
{ $six = "<b>{$slot["6"]}</b>"; }
if($slot["7"] == "")
{ $seven = "OPEN SLOT"; }
else
{ $seven = "<b>{$slot["7"]}</b>"; }
if($slot["8"] == "")
{ $eight = "OPEN SLOT"; }
else
{ $eight = "<b>{$slot["8"]}</b>"; }
if($slot["9"] == "")
{ $nine = "OPEN SLOT"; }
else
{ $nine = "<b>{$slot["9"]}</b>"; }
if($slot["10"] == "")
{ $ten = "OPEN SLOT"; }
else
{ $ten = "<b>{$slot["10"]}</b>"; }
if($slot["11"] == "")
{ $eleven = "OPEN SLOT"; }
else
{ $eleven = "<b>{$slot["11"]}</b>"; }
if($slot["12"] == "")
{ $twelve = "OPEN SLOT"; }
else
{ $twelve = "<b>{$slot["12"]}</b>"; }
if($slot["13"] == "")
{ $thirteen = "OPEN SLOT"; }
else
{ $thirteen = "<b>{$slot["13"]}</b>"; }
if($slot["14"] == "")
{ $fourteen = "OPEN SLOT"; }
else
{ $fourteen = "<b>{$slot["14"]}</b>"; }
if($slot["15"] == "")
{ $fifteen = "OPEN SLOT"; }
else
{ $fifteen = "<b>{$slot["15"]}</b>"; }
if($slot["16"] == "")
{ $sixteen = "OPEN SLOT"; }
else
{ $sixteen = "<b>{$slot["16"]}</b>"; }
if($slot["17"] == "")
{ $seventeen = "OPEN SLOT"; }
else
{ $seventeen = "<b>{$slot["17"]}</b>"; }
if($slot["18"] == "")
{ $eighteen = "OPEN SLOT"; }
else
{ $eighteen = "<b>{$slot["18"]}</b>"; }
if($slot["19"] == "")
{ $nineteen = "OPEN SLOT"; }
else
{ $nineteen = "<b>{$slot["19"]}</b>"; }
if($slot["20"] == "")
{ $twenty = "OPEN SLOT"; }
else
{ $twenty = "<b>{$slot["20"]}</b>"; }
if($slot["21"] == "")
{ $twentyone = "OPEN SLOT"; }
else
{ $twentyone = "<b>{$slot["21"]}</b>"; }
if($slot["22"] == "")
{ $twentytwo = "OPEN SLOT"; }
else
{ $twentytwo = "<b>{$slot["22"]}</b>"; }
if($slot["23"] == "")
{ $twentythree = "OPEN SLOT"; }
else
{ $twentythree = "<b>{$slot["23"]}</b>"; }
if($slot["24"] == "")
{ $twentyfour = "OPEN SLOT"; }
else
{ $twentyfour = "<b>{$slot["24"]}</b>"; }
$day = $_GET['week'];
echo "<p class=\"firstP\">You are currently viewing ";
echo "$day";
echo "'s times<p>";
echo "<p>0000 | $one<br />
0100 | $two<br />
0200 | $three<br />
0300 | $four<br />
0400 | $five<br />
0500 | $six<br />
0600 | $seven<br />
0700 | $eight<br />
0800 | $nine<br />
0900 | $ten<br />
1000 | $eleven<br />
1100 | $twelve<br />
1200 | $thirteen<br />
1300 | $fourteen<br />
1400 | $fifteen<br />
1500 | $sixteen<br />
1600 | $seventeen<br />
1700 | $eighteen<br />
1800 | $nineteen<br />
1900 | $twenty<br />
2000 | $twentyone<br />
2100 | $twentytwo<br />
2200 | $twentythree<br />
2300 | $twentyfour<p>";
}
?>
</div><!-- #one-third -->
<div class="one-third last">
<h4><span>What</span> About The Auto DJ</h4>
<p class="firstP">Our Auto DJ system randomly select mixes/tracks from our database of music to play randomly when we are off air which means there is always something on that you'll love.</p>
<p>If you are a DJ/MC and want your mix added to our database to be played at random, just get in touch via the Contact page, we'll happily get it on there for you.</p>
<p>You can find a list of all of the media in our database <a href="index.php?id=autodj" />here</a>!</p>
</div><!-- #one-third -->
</div><!-- #primaryContent end -->
</div><!-- #main end -->
</div><!-- #container end -->