Reply to thread

Message

<blockquote data-quote="edieter" data-source="post: 171115" data-attributes="member: 53609">Hi,If you like clickfinder, a German tv-guide, and use the tvserver of mp, these two scripts might be interesting for you. They allow direct programming of recordings out of clickfinder. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" /> Simply choose &quot;an Sendetermin erinnern&quot; in clickfinder, exit clickfinder and the schedule in tvserver is set.Installation:1. Install PHP if not done yet2. Set up two ODBC-connections to tvlibrary (tvlibrary) and the clickfinder-libary (tvdaten.mdb).3. Adjust the names of the ODBC-connections and put this script into a file called clickfinder.php in the clickfinder directory:------------------&lt;?php$dbtvserver = odbc_connect('tvlibrary'&nbsp; &nbsp; &nbsp; , '', '', SQL_CUR_USE_ODBC);$dbcf&nbsp; &nbsp; &nbsp;&nbsp; = odbc_connect('clickfinder', '', '', SQL_CUR_USE_ODBC);$rescf = odbc_exec ($dbcf, &quot;SELECT Sendungen.SenderKennung, Sendungen.Beginn, Sendungen.Ende, Markierungen.Sendung FROM Markierungen INNER JOIN Sendungen ON Markierungen.Pos = Sendungen.Pos;&quot;);while (odbc_fetch_row($rescf)){&nbsp; &nbsp; &nbsp;&nbsp; $sender&nbsp; = odbc_result($rescf,&quot;SenderKennung&quot;);&nbsp; &nbsp; &nbsp; $sendung = odbc_result($rescf,&quot;Sendung&quot;);&nbsp; &nbsp; &nbsp; $beginn&nbsp; = odbc_result($rescf,&quot;Beginn&quot;);&nbsp; &nbsp;&nbsp; $ende&nbsp; &nbsp; = odbc_result($rescf,&quot;Ende&quot;);&nbsp; &nbsp; &nbsp;&nbsp; echo &quot;$sender - $sendung ($beginn - $ende)&quot;;&nbsp; &nbsp; &nbsp;&nbsp; $res_tvs1 = odbc_exec ($dbtvserver,&quot;SELECT idChannel FROM Channel WHERE name = '$sender';&quot;);&nbsp; &nbsp; &nbsp;&nbsp; if (odbc_fetch_row($res_tvs1))&nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $id_sender=odbc_result($res_tvs1,&quot;idChannel&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $res=odbc_exec($dbtvserver,&quot;INSERT INTO schedule VALUES(NULL, '$id_sender', '0', '$sendung', '$beginn', '$ende', '5', '0', ' ', '0', '0', '2000-01-01', '1', '5', '2000-01-01', '-1')&quot;);&nbsp; &nbsp; &nbsp;&nbsp; }}$rescf = odbc_exec ($dbcf, &quot;DELETE FROM Markierungen;&quot;);?&gt;------------------4. Put this script into a file called clickfinder.vba in the clickfinder directory, adjust the path settings and start clickfinder by calling this script------------------WScript.CreateObject(&quot;WScript.Shell&quot;).Run &quot;tvghost.exe&quot;,0,TrueWScript.CreateObject(&quot;WScript.Shell&quot;).Run &quot;C:\PHP\php.exe C:\Programme\clickfinder\clickfinder.php&quot;,0,TrueWScript.CreateObject(&quot;WScript.Shell&quot;).Run &quot;taskkill /IM tvtip.exe&quot;,0------------------That's it, have fun!RegardsEDieter</blockquote>

[QUOTE="edieter, post: 171115, member: 53609"] Hi, If you like clickfinder, a German tv-guide, and use the tvserver of mp, these two scripts might be interesting for you. They allow direct programming of recordings out of clickfinder. :D Simply choose "an Sendetermin erinnern" in clickfinder, exit clickfinder and the schedule in tvserver is set. Installation: 1. Install PHP if not done yet 2. Set up two ODBC-connections to tvlibrary (tvlibrary) and the clickfinder-libary (tvdaten.mdb). 3. Adjust the names of the ODBC-connections and put this script into a file called clickfinder.php in the clickfinder directory: ------------------ <?php $dbtvserver = odbc_connect('tvlibrary' , '', '', SQL_CUR_USE_ODBC); $dbcf = odbc_connect('clickfinder', '', '', SQL_CUR_USE_ODBC); $rescf = odbc_exec ($dbcf, "SELECT Sendungen.SenderKennung, Sendungen.Beginn, Sendungen.Ende, Markierungen.Sendung FROM Markierungen INNER JOIN Sendungen ON Markierungen.Pos = Sendungen.Pos;"); while (odbc_fetch_row($rescf)) { $sender = odbc_result($rescf,"SenderKennung"); $sendung = odbc_result($rescf,"Sendung"); $beginn = odbc_result($rescf,"Beginn"); $ende = odbc_result($rescf,"Ende"); echo "$sender - $sendung ($beginn - $ende)"; $res_tvs1 = odbc_exec ($dbtvserver,"SELECT idChannel FROM Channel WHERE name = '$sender';"); if (odbc_fetch_row($res_tvs1)) { $id_sender=odbc_result($res_tvs1,"idChannel"); $res=odbc_exec($dbtvserver,"INSERT INTO schedule VALUES(NULL, '$id_sender', '0', '$sendung', '$beginn', '$ende', '5', '0', ' ', '0', '0', '2000-01-01', '1', '5', '2000-01-01', '-1')"); } } $rescf = odbc_exec ($dbcf, "DELETE FROM Markierungen;"); ?> ------------------ 4. Put this script into a file called clickfinder.vba in the clickfinder directory, adjust the path settings and start clickfinder by calling this script ------------------ WScript.CreateObject("WScript.Shell").Run "tvghost.exe",0,True WScript.CreateObject("WScript.Shell").Run "C:\PHP\php.exe C:\Programme\clickfinder\clickfinder.php",0,True WScript.CreateObject("WScript.Shell").Run "taskkill /IM tvtip.exe",0 ------------------ That's it, have fun! Regards EDieter [/QUOTE]

Verification