andyb-uk
09-02-2005, 05:59 AM
Hi, I use the code below to find the currently playing track from a database for a radio station (i didn't make this, it came with the broadcast software). The trouble i'm having is that from 4-10am the broadcast comes from one PC and from 10-4am the broadcast feed is from another PC with a different database. Each of these PC's has a config file (seen in the 'require' in this PHP file), for the 10-4am PC this is config.php and for the 4-10am PC this is config2.php. I was just wandering if there was a way I could replace the 'require' in th file below with some kind of If statement, so if the time is 7am require config2.php, but if the time is 3pm require config.php etc.
<?
require("config.php");
$db->open("SELECT songlist.*, historylist.listeners as listeners, historylist.requestID as requestID, historylist.date_played as starttime FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S') OR (historylist.songID = songlist.ID) AND (songlist.songtype='L') ORDER BY historylist.date_played DESC",6);
$history = $db->rows();
reset($history);
$db->open("SELECT songlist.*, queuelist.requestID as requestID FROM queuelist, songlist WHERE (queuelist.songID = songlist.ID) AND (songlist.songtype='S') AND (songlist.artist <> '') ORDER BY queuelist.sortID ASC",2);
$queue = $db->rows();
reset($queue);
//### Calculate the bezt time to refresh the webpage in order to show new updated song information
//==================================================================================================
list($key, $song) = each($history);
$listeners = $song["listeners"];
$starttime = strtotime($song["date_played"]);
$curtime = time();
$timeleft = $starttime+round($song["duration"]/1000)-$curtime;
//Set refesh interval
if($timeleft>0) # 30 second minimum wait
{ $timeout = $timeleft;} # if timeleft is valid, refresh on timeleft (should be end of song)
else
{ $timeout = 90; } # otherwise, fall back on 90 second refresh
if(($timeout>180) or ($timeout==0)) $timeout = 180;
if($timeout<30) $timeout = 30;
$refreshURL = "selectnowplaying.php?buster=".date('dhis').rand(1,1000);
//==================================================================================================
$pic_cnt = 0;
function PicName()
{
global $pic_cnt;
echo "Picture".$pic_cnt;
}
function NextPicName()
{
global $pic_cnt;
$pic_cnt += 1;
PicName();
}
function PutSongRow(&$song)
{
global $rc, $showpic, $darkrow, $lightrow;
PrepareSong($song);
$rc++;
$bgcolor = $darkrow;
if(($rc % 2)==0) $bgcolor = $lightrow;
?><? echo $song["combine"]; ?><?
}//PutSongRow
/* ## ===================================================================== ## */
?>
<body bgcolor="D80000">
Now Playing: <? $rc=0; PutSongRow($song); $mainsong = $song; ?>
Thanks in advance
Andy :)
<?
require("config.php");
$db->open("SELECT songlist.*, historylist.listeners as listeners, historylist.requestID as requestID, historylist.date_played as starttime FROM historylist,songlist WHERE (historylist.songID = songlist.ID) AND (songlist.songtype='S') OR (historylist.songID = songlist.ID) AND (songlist.songtype='L') ORDER BY historylist.date_played DESC",6);
$history = $db->rows();
reset($history);
$db->open("SELECT songlist.*, queuelist.requestID as requestID FROM queuelist, songlist WHERE (queuelist.songID = songlist.ID) AND (songlist.songtype='S') AND (songlist.artist <> '') ORDER BY queuelist.sortID ASC",2);
$queue = $db->rows();
reset($queue);
//### Calculate the bezt time to refresh the webpage in order to show new updated song information
//==================================================================================================
list($key, $song) = each($history);
$listeners = $song["listeners"];
$starttime = strtotime($song["date_played"]);
$curtime = time();
$timeleft = $starttime+round($song["duration"]/1000)-$curtime;
//Set refesh interval
if($timeleft>0) # 30 second minimum wait
{ $timeout = $timeleft;} # if timeleft is valid, refresh on timeleft (should be end of song)
else
{ $timeout = 90; } # otherwise, fall back on 90 second refresh
if(($timeout>180) or ($timeout==0)) $timeout = 180;
if($timeout<30) $timeout = 30;
$refreshURL = "selectnowplaying.php?buster=".date('dhis').rand(1,1000);
//==================================================================================================
$pic_cnt = 0;
function PicName()
{
global $pic_cnt;
echo "Picture".$pic_cnt;
}
function NextPicName()
{
global $pic_cnt;
$pic_cnt += 1;
PicName();
}
function PutSongRow(&$song)
{
global $rc, $showpic, $darkrow, $lightrow;
PrepareSong($song);
$rc++;
$bgcolor = $darkrow;
if(($rc % 2)==0) $bgcolor = $lightrow;
?><? echo $song["combine"]; ?><?
}//PutSongRow
/* ## ===================================================================== ## */
?>
<body bgcolor="D80000">
Now Playing: <? $rc=0; PutSongRow($song); $mainsong = $song; ?>
Thanks in advance
Andy :)