2012-09-13, 20:33
(2012-09-13, 19:47)pumkinut Wrote:Quote:This would not alone affirm if the sql dbase is 'working', resuming a movie is a local/skin setting that wouldn't be captured in the database. under settings/videos on both machines is it set to the same?Not quite true. Resuming a "stopped" movie from a certain point is not a skin capability. That relies completely on the database whether local or networked. The thing is, as clambert pointed out, you need to stop it on one system in order to resume on another, as the stop time is what's recorded by the database.
If you want to see if the database is storing the correct information, you can always install something like phpMyAdmin on the same box you have the SQL database running. Then you could open up a web browser, point it to your db machine and look at the tables directly. On my Synology NAS, I have MySQL and phpMyAdmin installed. I can watch in realtime as the database is modified. You could also download and install something like Marischino and set it up to look at a remote database rather than local. The front end for Marischino is much more oriented for a casual user than something like phpMyAdmin.
I didnt mean it was the skin that enabled that functionality, just that the settings to choose/play/resume/...etc was local. the timestamp index is in the database regardless.