Again, this is very rough and ready, but the following at least should
provide what you need. Obviously change the mysql parameters as required.
Standard disclaimer re suitability of code etc:
<?php
$host = "localhost";
$username = "rduser";
$password = "letmein";
mysql_connect($host, $username, $password);
@mysql_select_db("Rivendell") or die("Unable to select database");
?>
<html>
<head>
<title>Rivendell Log Display</title>
</head>
<body>
<form method='post'>
<select name='log'>
<?php
$log ="";
$query = "SELECT * FROM LOGS";
$res = mysql_query($query);
if ($res) {
$log =
isset($_REQUEST['log'])?$_REQUEST['log']:mysql_result($res,0,"NAME");
for ($i = 0; $i < mysql_numrows($res); $i++) {
echo "<option" . ($_REQUEST['log']==mysql_result($res, $i,
"NAME")?" SELECTED":"") . ">" . mysql_result($res, $i, "NAME") .
"</option>";
}
}
?>
</select><input type='submit' value='Go'>
</form>
<hr>
<table>
<tr><td>Type</td><td>Start Time</td><td>Cart
Number</td><td>Artist</td><td>Title</td></tr>
<?php
$query = "SELECT * FROM " . $log . "_LOG a LEFT OUTER JOIN CART b ON
a.CART_NUMBER = b.NUMBER ";
$res = mysql_query($query);
if ($res) {
for ($i=0; $i < mysql_numrows($res); $i++) {
$type = "Unknown";
if (mysql_result($res,$i,"TYPE")==0)
$type = "Internal";
else if (mysql_result($res,$i,"TYPE")==7)
$type = "Music Import";
else if (mysql_result($res,$i,"TYPE")==8)
$type = "Traffic Import";
echo "<tr><td>$type</td><td>" . gmdate("H:i:s",
mysql_result($res,$i,"START_TIME")/1000) . "</td><td>" .
mysql_result($res,$i,"CART_NUMBER") . "</td><td>" . mysql_result($res,$i,
"ARTIST") . "</td><td>" . mysql_result($res,$i,"TITLE") . "</td></tr>";
}
}
?>
</table>
</body>
</html>
<?php
mysql_close();
?>
On 14 February 2013 09:35, Peter Claes <[email protected]> wrote:
> That would indeed help me a bit further ...
>
> PHP was also my first option : one form to select the date, click ok, then
> displaying the log for the selected date.
>
> That would be enough for our use.
>
> Regards
> Peter
>
> Verstuurd vanaf mijn iPhone
>
> Op 14-feb.-2013 om 10:21 heeft Jay Eames <[email protected]> het
> volgende geschreven:
>
> I am currently looking into creating a traffic (and possibly music)
> scheduling system in PHP that interacts directly with the Rivendell tables.
> The first step of this was of course to ensure the log information could be
> pulled into a web page, which is fairly trivial to do.
>
> Remote tracking etc is outside of the scope I am looking at, but when I am
> a bit further down the road I would be happy to put my code up for others
> to pick apart and use as required, if this would any help?
>
> Jay
>
>
> On 14 February 2013 09:16, Lee Baker <[email protected]> wrote:
>
>> I would most certainly be keen to know of anyone who has done this as we
>> are the same with announcers who do their vts remotely.
>>
>> We use natural music for scheduling.
>>
>> But would be a great feature.
>>
>> Also to remotely edit cross fades on their vts so they can talk over
>> intros of songs.
>> On Feb 14, 2013 9:37 AM, "Peter Claes" <[email protected]> wrote:
>>
>>> Hi guys,
>>>
>>> Since the database is done in SQL, it should be easy to display daily
>>> logs in a webpage.
>>> I have some guys who are voicetracking remotely and who don't have a
>>> linux box.
>>>
>>> Is there anyone who has some scripts to do this ? or could this already
>>> be a standard feature in RD ?
>>>
>>> Regards
>>> Peter
>>>
>>>
>>> _______________________________________________
>>> Rivendell-dev mailing list
>>> [email protected]
>>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>>>
>>>
>> _______________________________________________
>> Rivendell-dev mailing list
>> [email protected]
>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>>
>>
>
>
> --
> There are 2 kinds of people in the world; Those who can extrapolate from
> incomplete data
>
> _______________________________________________
> Rivendell-dev mailing list
> [email protected]
> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>
>
> _______________________________________________
> Rivendell-dev mailing list
> [email protected]
> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>
>
--
There are 2 kinds of people in the world; Those who can extrapolate from
incomplete data
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
