Clear View History
-
once you watch a movie it is placed into the history section and will not play again, just keeps saying that the movie has finished playing and gives you a back to browsing button. if there was a clear history or the ability to remove single movies from this section i believe this would not happem unless there is an issue with how this is working,.... possibly a bug?
-
i use mainly .avi,mkv, mp4 but using the remote works great and yes it does it to all movies i play even if i only play them for a few seconds.
Haveing a bat that will stop the service, load hsql into memory, and then execute DELETE FROM PLAY_HISTORY * (or what ever syntax hSQL uses, as i am a PHP/MySQL programmer not a hSQLDB guy.) but i am also a batch guy...
here is some of the needed info.for /F "tokens=3 delims=: " %%H in ('sc query "CWService" ^| findstr " STATE"') do (
if /I "%%H" NEQ "STOPPED" (
net stop "CWService"
java -Xmx768m -cp C:/craigworks/movies/lib/hsqldb.jar org.hsqldb.server.Server -database.0 file:"C:/craigworks/movies/data/data";hsqldb.tx=mvcc -dbname.0 xdb
REM code to delete contents of table PLAY_HISTORY
java SHUTDOWN SQL
net start "CWService"
)
)
Explanation of what it does:
1.Queries the properties of the service.
2.Looks for the line containing the text "STATE"
3.Tokenizes that line, and pulls out the 3rd token, which is the one containing the state of the service.
4.Tests the resulting state against the string "STOPPED"
you could even drop the table and re-create it if HSQL wont allow for mass deletion of records in a single statement ... not sure if it supports truncating or not.
NEways this is just a thought let me know what you think.
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
