My plan is that it will handle multiple stations etc, as at the end of the day it's all pretty much just SQL - though even in it's initial phases it would be looking directly at log files - so assuming all the logs were in the one database then it would be able to deal with them regardless of the station they were for.
It is a project still very much at the beginning of it's life at the moment - in fact most of it is currently residing in my head! Jay On 14 February 2013 09:52, Lee Baker <[email protected]> wrote: > 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 > > -- 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
