Thanks for sharing that jay. Let us know when you have the traffic scheduler written, im very keen to take a look.
Currently we use natural music for music scheduling and then the internal scheduler for traffic. But thats tedious. Would be great to go to a web page abd schedule all our traffic spots. Could it handle multiple stations? On Feb 14, 2013 7:44 PM, "Jay Eames" <[email protected]> wrote: > 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 > >
_______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
