Reply to thread

Message

<blockquote data-quote="ChrisOfCatford" data-source="post: 271282" data-attributes="member: 23650">Hello,I have had a go at making a really simple web EPG that helps me with recording and finding films (and other stuff as well).I didn't want to use the existing offerings as I already have&nbsp; web server running 24/7, and don't need the overheads of another one. Also, I just like making PHP applications.It works great (only on IE PHP and mysql), apart from any recordings I set using my interface ignore the default recording folder and record to the MP tv server root instead.Here is part of the code that I am using in case it helps:[PHP]//Pre record$result=mysql_query(&quot;SELECT s.`value` FROM setting s WHERE s.`tag`='preRecordInterval'&quot;)or die(&quot;OOPS failed on select preRecord: &quot;.mysql_error());$row=mysql_fetch_array($result);$prerecord=$row[0];//Post record$result=mysql_query(&quot;SELECT s.`value` FROM setting s WHERE s.`tag`='postRecordInterval'&quot;)or die(&quot;OOPS failed on SELECT postRecord: &quot;.mysql_error());$row=mysql_fetch_array($result);$postrecord=$row[0];//Get GET vars from url$startdate=$_REQUEST[&quot;s&quot;];$enddate=$_REQUEST[&quot;e&quot;];$idchannel=$_REQUEST[&quot;c&quot;];$title=$_REQUEST[&quot;t&quot;];//Add the recording$result=mysql_query(&quot;INSERT INTO schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, priority, quality, preRecordInterval, postRecordInterval, recommendedCard, keepDate, canceled) &quot;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;VALUES ('&quot;.$idchannel.&quot;' , '0' , '&quot;.$title.&quot;' , '&quot;.$startdate.&quot;' ,&nbsp; '&quot;.$enddate.&quot;' , '2147483647' , '0' , '0' , '&quot;.$prerecord.&quot;' , '&quot;.$postrecord.&quot;' , '-1','2000-01-01 00:00:00','2000-01-01 00:00:00')&quot;)&nbsp; &nbsp; or die(&quot;ERROR: &quot;.mysql_error());[/PHP]Am I missing some setting somewhere? Is it even possible to set recordings JUST using the MYSQL DB? Can anyone help me solve this please?Thanks,Chris</blockquote>

[QUOTE="ChrisOfCatford, post: 271282, member: 23650"] Hello, I have had a go at making a really simple web EPG that helps me with recording and finding films (and other stuff as well). I didn't want to use the existing offerings as I already have web server running 24/7, and don't need the overheads of another one. Also, I just like making PHP applications. It works great (only on IE PHP and mysql), apart from any recordings I set using my interface ignore the default recording folder and record to the MP tv server root instead. Here is part of the code that I am using in case it helps: [PHP] //Pre record $result=mysql_query("SELECT s.`value` FROM setting s WHERE s.`tag`='preRecordInterval'") or die("OOPS failed on select preRecord: ".mysql_error()); $row=mysql_fetch_array($result); $prerecord=$row[0]; //Post record $result=mysql_query("SELECT s.`value` FROM setting s WHERE s.`tag`='postRecordInterval'") or die("OOPS failed on SELECT postRecord: ".mysql_error()); $row=mysql_fetch_array($result); $postrecord=$row[0]; //Get GET vars from url $startdate=$_REQUEST["s"]; $enddate=$_REQUEST["e"]; $idchannel=$_REQUEST["c"]; $title=$_REQUEST["t"]; //Add the recording $result=mysql_query("INSERT INTO schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, priority, quality, preRecordInterval, postRecordInterval, recommendedCard, keepDate, canceled) ". "VALUES ('".$idchannel."' , '0' , '".$title."' , '".$startdate."' , '".$enddate."' , '2147483647' , '0' , '0' , '".$prerecord."' , '".$postrecord."' , '-1','2000-01-01 00:00:00','2000-01-01 00:00:00')") or die("ERROR: ".mysql_error()); [/PHP] Am I missing some setting somewhere? Is it even possible to set recordings JUST using the MYSQL DB? Can anyone help me solve this please? Thanks, Chris [/QUOTE]

Verification