Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 1283043" data-attributes="member: 18896">When HTPC powers on, and MediaPortal starts it doesn't do this magically.Either you're using the MePo option to boot with Windows (which is registry key entry), or you added MediaPortal launch shortcut to the &quot;Startup&quot; folder.Adjust either to instead launch a batch-script, or power-shell script or whatever you prefer, and then process whatever you want in there.Below is what I do on mine, and where I deal with AmbiBox is where I would deal with other tools as well if I use them, such as devcon for display restarts, dc2 for clone screen adjustments, or synergy commandline launch for complex configurations. At one point I was even sending network messages to let me know HTPC was finished booting, but it boots so quick now that there is no need for such trickery. I'd be happy to share more details on those methods though, but have to dig them up as that was back in 2009/2010 when I used those.PS: I'm on an SSD so it only adds like a second to run the entire script.[code]@Echo Off:::: Auto backup/restore MediaPortal databases based on integrity check.:::: Author&nbsp; » RoChess:: Updated » July 19th 2013::SET BACKUP=AutoBackupSET MEPO_PATH=Team MediaPortal\MediaPortal\databaseIF EXIST &quot;%AllUsersProfile%\Application Data\%MEPO_PATH%\*.db3&quot;&nbsp; &nbsp; SET DB3_PATH=%AllUsersProfile%\Application Data\%MEPO_PATH%IF EXIST &quot;%AllUsersProfile%\%MEPO_PATH%\*.db3&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SET DB3_PATH=%AllUsersProfile%\%MEPO_PATH%taskkill /F /T /IM AmbiBox.exe &gt; nulstart &quot;AmbiBox&quot; /D &quot;C:\Program Files (x86)\AmbiBox&quot; AmbiBox.exeIF &quot;%DB3_PATH%&quot;==&quot;&quot; GOTO Error_MePoIF NOT EXIST &quot;%~dp0\sqlite3.exe&quot; GOTO Error_SQLite:: Check to make sure MediaPortal is not still running::tasklist | find /i /c &quot;MediaPortal.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningtasklist | find /i /c &quot;PluginConfigLoader.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningtasklist | find /i /c &quot;Moving Pictures Config.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningtasklist | find /i /c &quot;MP-TVSeries-Configuration.exe&quot; &gt;nul &amp;&amp;goto MediaPortalRunningecho Auto Backup/Restore STARTED (%DATE% -- %TIME%) &gt;&quot;%~dpn0.log&quot;echo.&gt;&gt;&quot;%~dpn0.log&quot;CD /D &quot;%DB3_PATH%&quot;FOR %%I IN (*.db3) DO (&nbsp; &nbsp; CALL:checkSQLite &quot;%%I&quot;)echo.&gt;&gt;&quot;%~dpn0.log&quot;echo Auto Backup/Restore FINISHED (%DATE% -- %TIME%) &gt;&gt;&quot;%~dpn0.log&quot;:LaunchMediaPortal&nbsp; &nbsp; :: Locating MediaPortal folder&nbsp; &nbsp; ::&nbsp; &nbsp; IF EXIST &quot;%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; start &quot;MediaPortal&quot; &quot;%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; &nbsp; ) ELSE (&nbsp; &nbsp; &nbsp; &nbsp; IF EXIST &quot;%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; start &quot;MediaPortal&quot; &quot;%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe&quot;&nbsp; &nbsp; &nbsp; &nbsp; ) ELSE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Goto MediaPortalNotFound&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )GOTO:EOF:checkSQLite&nbsp; &nbsp; IF %~z1 EQU 0 (&nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp; Aborting: &quot;%~nx1&quot; is ZERO bytes&nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp; Aborting: &quot;%~nx1&quot; is ZERO bytes &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; &nbsp; &nbsp; &nbsp; GOTO:EOF&nbsp; &nbsp; )&nbsp; &nbsp; SET Pass=No&nbsp; &nbsp; echo PRAGMA integrity_check; | &quot;%~dp0\sqlite3.exe&quot; &quot;%~dpf1&quot; | find /c &quot;ok&quot; &gt; nul &amp;&amp;SET Pass=Yes&nbsp; &nbsp; IF &quot;%Pass%&quot;==&quot;Yes&quot; (&nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp; Updating backup for: &quot;%~nx1&quot;&nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp; Updating backup for: &quot;%~nx1&quot; &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; &nbsp; &nbsp; &nbsp; xcopy &quot;%DB3_PATH%\%~nx1&quot; &quot;%DB3_PATH%\%BACKUP%\&quot; /I /C /D /Y /Q &gt;nul&nbsp; &nbsp; )&nbsp; &nbsp; IF &quot;%Pass%&quot;==&quot;No&quot; (&nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp; ERROR: DATABASE CORRUPT!&nbsp; &nbsp; &nbsp; &nbsp; IF NOT EXIST &quot;%DB3_PATH%\%BACKUP%\%~nx1&quot; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; - No backup exists for: &quot;%~nx1&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; - No backup exists for: &quot;%~nx1&quot; &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; IF EXIST &quot;%DB3_PATH%\%BACKUP%\%~nx1&quot; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; - Restoring last-known good backup for: &quot;%~nx1&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; - Restoring last-known good backup for: &quot;%~nx1&quot; &gt;&gt;&quot;%~dpn0.log&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xcopy &quot;%DB3_PATH%\%BACKUP%\%~nx1&quot; &quot;%DB3_PATH%\&quot; /I /C /Y /Q &gt;nul&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )GOTO:EOF:MediaPortalRunning&nbsp; &nbsp; echo&nbsp;&nbsp; WARNING: MediaPortal is still running!!&nbsp; &nbsp; echo.&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; MediaPortal and/or Configuration tools are still active.&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; Try it again later, after giving it more time to finish.GOTO ErrorDelay:MediaPortalNotFound&nbsp; &nbsp; echo&nbsp;&nbsp; WARNING: MediaPortal *NOT* Found!!&nbsp; &nbsp; echo.&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; Unable to locate MediaPortal in the default location.&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; Please adjust this script manually to use your custom folder.goto ErrorDelay:Error_MePo&nbsp; &nbsp; echo&nbsp;&nbsp; ABORTING: MediaPortal databases not found&nbsp; &nbsp; echo.&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; Nothing to do, please verify your MediaPortal installation.GOTO ErrorDelay:Error_SQLite&nbsp; &nbsp; echo&nbsp;&nbsp; ABORTING: SQLite.exe command-line tool missing!&nbsp; &nbsp; echo.&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; Download binary shell for Windows from: http://www.sqlite.org/download.html&nbsp; &nbsp; echo&nbsp; &nbsp;&nbsp; Unzip and copy sqlite3.exe to:&nbsp; &nbsp; echo.&nbsp; &nbsp; echo&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &quot;%~dp0&quot;GOTO ErrorDelay:ErrorDelay&nbsp; &nbsp; echo.&nbsp; &nbsp; echo&nbsp;&nbsp; This window will self-destruct in a few seconds.&nbsp; &nbsp; echo.&nbsp; &nbsp; ping 1.0 -n 1 -w 5000 &gt; nulGOTO:EOF[/code]</blockquote>

[QUOTE="RoChess, post: 1283043, member: 18896"] When HTPC powers on, and MediaPortal starts it doesn't do this magically. Either you're using the MePo option to boot with Windows (which is registry key entry), or you added MediaPortal launch shortcut to the "Startup" folder. Adjust either to instead launch a batch-script, or power-shell script or whatever you prefer, and then process whatever you want in there. Below is what I do on mine, and where I deal with AmbiBox is where I would deal with other tools as well if I use them, such as devcon for display restarts, dc2 for clone screen adjustments, or synergy commandline launch for complex configurations. At one point I was even sending network messages to let me know HTPC was finished booting, but it boots so quick now that there is no need for such trickery. I'd be happy to share more details on those methods though, but have to dig them up as that was back in 2009/2010 when I used those. PS: I'm on an SSD so it only adds like a second to run the entire script. [code] @Echo Off :: :: Auto backup/restore MediaPortal databases based on integrity check. :: :: Author » RoChess :: Updated » July 19th 2013 :: SET BACKUP=AutoBackup SET MEPO_PATH=Team MediaPortal\MediaPortal\database IF EXIST "%AllUsersProfile%\Application Data\%MEPO_PATH%\*.db3" SET DB3_PATH=%AllUsersProfile%\Application Data\%MEPO_PATH% IF EXIST "%AllUsersProfile%\%MEPO_PATH%\*.db3" SET DB3_PATH=%AllUsersProfile%\%MEPO_PATH% taskkill /F /T /IM AmbiBox.exe > nul start "AmbiBox" /D "C:\Program Files (x86)\AmbiBox" AmbiBox.exe IF "%DB3_PATH%"=="" GOTO Error_MePo IF NOT EXIST "%~dp0\sqlite3.exe" GOTO Error_SQLite :: Check to make sure MediaPortal is not still running :: tasklist | find /i /c "MediaPortal.exe" >nul &&goto MediaPortalRunning tasklist | find /i /c "PluginConfigLoader.exe" >nul &&goto MediaPortalRunning tasklist | find /i /c "Moving Pictures Config.exe" >nul &&goto MediaPortalRunning tasklist | find /i /c "MP-TVSeries-Configuration.exe" >nul &&goto MediaPortalRunning echo Auto Backup/Restore STARTED (%DATE% -- %TIME%) >"%~dpn0.log" echo.>>"%~dpn0.log" CD /D "%DB3_PATH%" FOR %%I IN (*.db3) DO ( CALL:checkSQLite "%%I" ) echo.>>"%~dpn0.log" echo Auto Backup/Restore FINISHED (%DATE% -- %TIME%) >>"%~dpn0.log" :LaunchMediaPortal :: Locating MediaPortal folder :: IF EXIST "%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe" ( start "MediaPortal" "%ProgramFiles%\Team MediaPortal\MediaPortal\MediaPortal.exe" ) ELSE ( IF EXIST "%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe" ( start "MediaPortal" "%ProgramFiles(x86)%\Team MediaPortal\MediaPortal\MediaPortal.exe" ) ELSE ( Goto MediaPortalNotFound ) ) GOTO:EOF :checkSQLite IF %~z1 EQU 0 ( echo Aborting: "%~nx1" is ZERO bytes echo Aborting: "%~nx1" is ZERO bytes >>"%~dpn0.log" GOTO:EOF ) SET Pass=No echo PRAGMA integrity_check; | "%~dp0\sqlite3.exe" "%~dpf1" | find /c "ok" > nul &&SET Pass=Yes IF "%Pass%"=="Yes" ( echo Updating backup for: "%~nx1" echo Updating backup for: "%~nx1" >>"%~dpn0.log" xcopy "%DB3_PATH%\%~nx1" "%DB3_PATH%\%BACKUP%\" /I /C /D /Y /Q >nul ) IF "%Pass%"=="No" ( echo ERROR: DATABASE CORRUPT! IF NOT EXIST "%DB3_PATH%\%BACKUP%\%~nx1" ( echo - No backup exists for: "%~nx1" echo - No backup exists for: "%~nx1" >>"%~dpn0.log" ) IF EXIST "%DB3_PATH%\%BACKUP%\%~nx1" ( echo - Restoring last-known good backup for: "%~nx1" echo - Restoring last-known good backup for: "%~nx1" >>"%~dpn0.log" xcopy "%DB3_PATH%\%BACKUP%\%~nx1" "%DB3_PATH%\" /I /C /Y /Q >nul ) ) GOTO:EOF :MediaPortalRunning echo WARNING: MediaPortal is still running!! echo. echo MediaPortal and/or Configuration tools are still active. echo Try it again later, after giving it more time to finish. GOTO ErrorDelay :MediaPortalNotFound echo WARNING: MediaPortal *NOT* Found!! echo. echo Unable to locate MediaPortal in the default location. echo Please adjust this script manually to use your custom folder. goto ErrorDelay :Error_MePo echo ABORTING: MediaPortal databases not found echo. echo Nothing to do, please verify your MediaPortal installation. GOTO ErrorDelay :Error_SQLite echo ABORTING: SQLite.exe command-line tool missing! echo. echo Download binary shell for Windows from: http://www.sqlite.org/download.html echo Unzip and copy sqlite3.exe to: echo. echo "%~dp0" GOTO ErrorDelay :ErrorDelay echo. echo This window will self-destruct in a few seconds. echo. ping 1.0 -n 1 -w 5000 > nul GOTO:EOF [/code] [/QUOTE]

Verification