Reply to thread

Message

<blockquote data-quote="larry_S" data-source="post: 487712" data-attributes="member: 85587">Müsste so funktionieren (mit MS SQL Server).Script für Taskplaner:[CODE]set ws = CreateObject(&quot;Wscript.shell&quot;)set db1 = createobject (&quot;ADODB.connection&quot;)Set FSO = CreateObject(&quot;Scripting.FileSystemObject&quot;)SQLServer=&nbsp; &quot;Server\SQLEXPRESS&quot;SQLUser=&nbsp; &nbsp; &quot;sa&quot;SQLPW=&nbsp; &nbsp; &nbsp; &quot;mediaportal&quot;DWH=&nbsp; &nbsp; &nbsp; &nbsp; &quot;MpTvDb&quot;Quelldatei= &quot;C:\start.vbs&quot;Zieldatei = &quot;C:\Dokumente und Einstellungen\All Users\Startmenü\Programme\Autostart\standy.vbs&quot;Zeitdiff=10db1.Open(&quot;Driver={SQL Server};SERVER=&quot;&amp;SQLServer&amp;&quot;;Database=&quot;&amp;DWH&amp;&quot;;User ID=&quot;&amp;SQLUser&amp;&quot;;Password=&quot;&amp;SQLPW)&nbsp; &nbsp; &nbsp; set rs1=db1.execute(&quot;SELECT min(Starttime) as start from &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;(&nbsp; &nbsp;&nbsp; select Starttime, Endtime &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; from schedule &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; where scheduleType=0 &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; union &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; select dateadd(mi,datepart(mi,starttime)-(preRecordInterval) -&quot;&amp;Zeitdiff&amp;&quot; ,dateadd(hh,datepart(hh,starttime),heute)) as startime, &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; dateadd(mi,datepart(mi,endtime)+(PostRecordInterval)+&quot;&amp;Zeitdiff&amp;&quot; ,dateadd(hh,datepart(hh,endtime),heute)) as endtime &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; from schedule &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; inner join (SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as heute,DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) as gestern, DATEADD(dd, +1, DATEDIFF(dd, 0, GETDATE())) as morgen&nbsp; ) as UA &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; on 1=1 &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; where scheduleType in(1,3,4) or (scheduleType=2 and datepart(dw,heute)=datepart(dw,starttime)) or (scheduleType=6 and datepart(dw,heute) in (1,2,3,4,5)) or (scheduleType=5 and datepart(dw,heute) in (6,7)) &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; union &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; select dateadd(mi,datepart(mi,starttime)-(preRecordInterval) -&quot;&amp;Zeitdiff&amp;&quot; ,dateadd(hh,datepart(hh,starttime),morgen)) as startime, &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; dateadd(mi,datepart(mi,endtime)+(PostRecordInterval)+&quot;&amp;Zeitdiff&amp;&quot; ,dateadd(hh,datepart(hh,endtime),morgen)) as endtime &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; from schedule &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; inner join (SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as heute,DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) as gestern, DATEADD(dd, +1, DATEDIFF(dd, 0, GETDATE())) as morgen&nbsp; ) as UA &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; on 1=1 &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; where scheduleType in(1,3,4) or (scheduleType=2 and datepart(dw,morgen)=datepart(dw,starttime)) or (scheduleType=6 and datepart(dw,morgen) in (1,2,3,4,5)) or (scheduleType=5 and datepart(dw,morgen) in (6,7)) &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; union &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; select dateadd(mi,datepart(mi,starttime)-(preRecordInterval) -&quot;&amp;Zeitdiff&amp;&quot; ,dateadd(hh,datepart(hh,starttime),gestern)) as startime, &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; dateadd(mi,datepart(mi,endtime)+(PostRecordInterval)+&quot;&amp;Zeitdiff&amp;&quot; ,dateadd(hh,datepart(hh,endtime),gestern)) as endtime &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; from schedule &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; inner join (SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as heute,DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) as gestern, DATEADD(dd, +1, DATEDIFF(dd, 0, GETDATE())) as morgen&nbsp; ) as UA &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; on 1=1 &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp; &nbsp; &nbsp; where scheduleType in(1,3,4) or (scheduleType=2 and datepart(dw,gestern)=datepart(dw,starttime)) or (scheduleType=6 and datepart(dw,gestern) in (1,2,3,4,5)) or (scheduleType=5 and datepart(dw,gestern) in (6,7)) &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;) as ua &quot; &amp; _&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;where endTime&gt;current_timestamp&quot;)&nbsp; &nbsp; &nbsp; if isdate(rs1(&quot;Start&quot;)) then 'Wenn Aufnahmen läuft... oder in 10 Minuten startet&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if rs1(&quot;Start&quot;)&lt;now() then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WScript.Sleep 60000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fso.copyfile Quelldatei, Zieldatei&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws.AppActivate &quot;MediaPortal&quot;, True&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws.sendkeys &quot;+(ü)&quot;, True&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WScript.Sleep 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws.sendkeys &quot;{LEFT}&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws.sendkeys &quot;{ENTER}&quot;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; end if&nbsp; &nbsp; &nbsp; end if&nbsp; &nbsp; &nbsp; db1.close[/CODE]Script 2:[CODE]set ws = CreateObject(&quot;Wscript.shell&quot;)Set FSO = CreateObject(&quot;Scripting.FileSystemObject&quot;)Zieldatei = &quot;C:\Dokumente und Einstellungen\All Users\Startmenü\Programme\Autostart\standy.vbs&quot;WScript.Sleep 120000fso.deletefile Zieldateiws.AppActivate &quot;MediaPortal&quot;, Truews.sendkeys &quot;q&quot;[/CODE]GrußLarry</blockquote>

[QUOTE="larry_S, post: 487712, member: 85587"] Müsste so funktionieren (mit MS SQL Server). Script für Taskplaner: [CODE]set ws = CreateObject("Wscript.shell") set db1 = createobject ("ADODB.connection") Set FSO = CreateObject("Scripting.FileSystemObject") SQLServer= "Server\SQLEXPRESS" SQLUser= "sa" SQLPW= "mediaportal" DWH= "MpTvDb" Quelldatei= "C:\start.vbs" Zieldatei = "C:\Dokumente und Einstellungen\All Users\Startmenü\Programme\Autostart\standy.vbs" Zeitdiff=10 db1.Open("Driver={SQL Server};SERVER="&SQLServer&";Database="&DWH&";User ID="&SQLUser&";Password="&SQLPW) set rs1=db1.execute("SELECT min(Starttime) as start from " & _ "( select Starttime, Endtime " & _ " from schedule " & _ " where scheduleType=0 " & _ " union " & _ " select dateadd(mi,datepart(mi,starttime)-(preRecordInterval) -"&Zeitdiff&" ,dateadd(hh,datepart(hh,starttime),heute)) as startime, " & _ " dateadd(mi,datepart(mi,endtime)+(PostRecordInterval)+"&Zeitdiff&" ,dateadd(hh,datepart(hh,endtime),heute)) as endtime " & _ " from schedule " & _ " inner join (SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as heute,DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) as gestern, DATEADD(dd, +1, DATEDIFF(dd, 0, GETDATE())) as morgen ) as UA " & _ " on 1=1 " & _ " where scheduleType in(1,3,4) or (scheduleType=2 and datepart(dw,heute)=datepart(dw,starttime)) or (scheduleType=6 and datepart(dw,heute) in (1,2,3,4,5)) or (scheduleType=5 and datepart(dw,heute) in (6,7)) " & _ " union " & _ " select dateadd(mi,datepart(mi,starttime)-(preRecordInterval) -"&Zeitdiff&" ,dateadd(hh,datepart(hh,starttime),morgen)) as startime, " & _ " dateadd(mi,datepart(mi,endtime)+(PostRecordInterval)+"&Zeitdiff&" ,dateadd(hh,datepart(hh,endtime),morgen)) as endtime " & _ " from schedule " & _ " inner join (SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as heute,DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) as gestern, DATEADD(dd, +1, DATEDIFF(dd, 0, GETDATE())) as morgen ) as UA " & _ " on 1=1 " & _ " where scheduleType in(1,3,4) or (scheduleType=2 and datepart(dw,morgen)=datepart(dw,starttime)) or (scheduleType=6 and datepart(dw,morgen) in (1,2,3,4,5)) or (scheduleType=5 and datepart(dw,morgen) in (6,7)) " & _ " union " & _ " select dateadd(mi,datepart(mi,starttime)-(preRecordInterval) -"&Zeitdiff&" ,dateadd(hh,datepart(hh,starttime),gestern)) as startime, " & _ " dateadd(mi,datepart(mi,endtime)+(PostRecordInterval)+"&Zeitdiff&" ,dateadd(hh,datepart(hh,endtime),gestern)) as endtime " & _ " from schedule " & _ " inner join (SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) as heute,DATEADD(dd, -1, DATEDIFF(dd, 0, GETDATE())) as gestern, DATEADD(dd, +1, DATEDIFF(dd, 0, GETDATE())) as morgen ) as UA " & _ " on 1=1 " & _ " where scheduleType in(1,3,4) or (scheduleType=2 and datepart(dw,gestern)=datepart(dw,starttime)) or (scheduleType=6 and datepart(dw,gestern) in (1,2,3,4,5)) or (scheduleType=5 and datepart(dw,gestern) in (6,7)) " & _ ") as ua " & _ "where endTime>current_timestamp") if isdate(rs1("Start")) then 'Wenn Aufnahmen läuft... oder in 10 Minuten startet if rs1("Start")<now() then WScript.Sleep 60000 fso.copyfile Quelldatei, Zieldatei ws.AppActivate "MediaPortal", True ws.sendkeys "+(ü)", True WScript.Sleep 1000 ws.sendkeys "{LEFT}" ws.sendkeys "{ENTER}" end if end if db1.close[/CODE] Script 2: [CODE]set ws = CreateObject("Wscript.shell") Set FSO = CreateObject("Scripting.FileSystemObject") Zieldatei = "C:\Dokumente und Einstellungen\All Users\Startmenü\Programme\Autostart\standy.vbs" WScript.Sleep 120000 fso.deletefile Zieldatei ws.AppActivate "MediaPortal", True ws.sendkeys "q" [/CODE] Gruß Larry [/QUOTE]

Verification