home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
set ALL episodes in all series as unwatched (reset database for new users)
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="dir" data-source="post: 1005546" data-attributes="member: 24485"><p>Ok, I hit a brick wall. I worked out the following:</p><p> </p><p>Tool to use to open / modify database: SQLITE3.exe</p><p>commands used:</p><p>.mode column</p><p>.headers on</p><p>.output blah.txt</p><p>select * from local_episodes;</p><p>.quit</p><p> </p><p>I examine the output and it shows:</p><p>[CODE]EpisodeFilename OriginalComposite CompositeID SeriesID SeasonIndex EpisodeIndex LocalEpisodeName LocalImportProcessed CompositeUpdated AvailableSubtitles OriginalComposite2 CompositeID2 EpisodeIndex2 videoWidth videoHeight FileDateAdded FileDateCreated IsAvailable DateWatched ext VolumeLabel localPlaytime VideoCodec VideoFormat VideoFormatProfile VideoBitrate VideoFrameRate VideoAspectRatio AudioCodec AudioFormat AudioFormatProfile AudioBitrate AudioChannels AudioTracks TextCount StopTime </p><p>---------------------------------------------------------------------- ----------------- ----------- ---------- ----------- ------------ ---------------- -------------------- ---------------- ------------------ ------------------ ------------ ------------- ---------- ----------- ------------------- ------------------- ----------- ----------- ---------- --------------------------- ------------- --------------- ----------- ------------------ ------------ -------------- ---------------- ---------- ----------- ------------------ ------------ ------------- ----------- ---------- ----------</p><p>\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e01 - Pilot.mkv 248741_1x1 248741 1 1 Pilot 2 1 0 0 1920 1080 2013-06-11 14:20:09 2012-12-18 23:17:50 2 mkv \\mofo\Audio Video Media\TV 1319319 V_MPEG4/ISO/AVC AVC High@L4.1 12675000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 </p><p>\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e02 - And the B 248741_1x2 248741 1 2 And the Breakup 2 1 0 0 1920 1080 2013-06-11 14:42:28 2012-12-18 23:44:39 2 mkv \\mofo\Audio Video Media\TV 1286286 V_MPEG4/ISO/AVC AVC High@L4.1 8164000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 </p><p>\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e03 - And Strok 248741_1x3 248741 1 3 And Strokes of G 2 1 0 0 1280 720 2013-06-11 15:02:31 2012-12-18 17:46:46 2 mkv \\mofo\Audio Video Media\TV 1299299 V_MPEG4/ISO/AVC AVC High@L4.1 5657000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 </p><p>\\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e04 - And the R 248741_1x4 248741 1 4 And the Rich Peo 2 1 0 0 1280 720 2013-06-11 15:20:25 2012-12-18 18:08:58 2 mkv \\mofo\Audio Video Media\TV 1293293 V_MPEG4/ISO/AVC AVC High@L4.1 5690000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 [/CODE]</p><p> </p><p>(I have no idea why the columns don't line up - they do in the output file and they do when I preview this forum posting. They just don't line up aftwards...) So the following may not seem clear from the table above, but its true:</p><p> </p><p>The 'DateWatched' column is blank for all 25000 episodes!</p><p> </p><p>What column is used in what table to indicate that an episode has been watched?</p></blockquote><p></p>
[QUOTE="dir, post: 1005546, member: 24485"] Ok, I hit a brick wall. I worked out the following: Tool to use to open / modify database: SQLITE3.exe commands used: .mode column .headers on .output blah.txt select * from local_episodes; .quit I examine the output and it shows: [CODE]EpisodeFilename OriginalComposite CompositeID SeriesID SeasonIndex EpisodeIndex LocalEpisodeName LocalImportProcessed CompositeUpdated AvailableSubtitles OriginalComposite2 CompositeID2 EpisodeIndex2 videoWidth videoHeight FileDateAdded FileDateCreated IsAvailable DateWatched ext VolumeLabel localPlaytime VideoCodec VideoFormat VideoFormatProfile VideoBitrate VideoFrameRate VideoAspectRatio AudioCodec AudioFormat AudioFormatProfile AudioBitrate AudioChannels AudioTracks TextCount StopTime ---------------------------------------------------------------------- ----------------- ----------- ---------- ----------- ------------ ---------------- -------------------- ---------------- ------------------ ------------------ ------------ ------------- ---------- ----------- ------------------- ------------------- ----------- ----------- ---------- --------------------------- ------------- --------------- ----------- ------------------ ------------ -------------- ---------------- ---------- ----------- ------------------ ------------ ------------- ----------- ---------- ---------- \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e01 - Pilot.mkv 248741_1x1 248741 1 1 Pilot 2 1 0 0 1920 1080 2013-06-11 14:20:09 2012-12-18 23:17:50 2 mkv \\mofo\Audio Video Media\TV 1319319 V_MPEG4/ISO/AVC AVC High@L4.1 12675000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e02 - And the B 248741_1x2 248741 1 2 And the Breakup 2 1 0 0 1920 1080 2013-06-11 14:42:28 2012-12-18 23:44:39 2 mkv \\mofo\Audio Video Media\TV 1286286 V_MPEG4/ISO/AVC AVC High@L4.1 8164000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e03 - And Strok 248741_1x3 248741 1 3 And Strokes of G 2 1 0 0 1280 720 2013-06-11 15:02:31 2012-12-18 17:46:46 2 mkv \\mofo\Audio Video Media\TV 1299299 V_MPEG4/ISO/AVC AVC High@L4.1 5657000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 \\mofo\Audio Video Media\TV\2 Broke Girls\Season 01\s01e04 - And the R 248741_1x4 248741 1 4 And the Rich Peo 2 1 0 0 1280 720 2013-06-11 15:20:25 2012-12-18 18:08:58 2 mkv \\mofo\Audio Video Media\TV 1293293 V_MPEG4/ISO/AVC AVC High@L4.1 5690000 23.976 1.778 A_DTS DTS -1 1509000 6 1 -1 [/CODE] (I have no idea why the columns don't line up - they do in the output file and they do when I preview this forum posting. They just don't line up aftwards...) So the following may not seem clear from the table above, but its true: The 'DateWatched' column is blank for all 25000 episodes! What column is used in what table to indicate that an episode has been watched? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
set ALL episodes in all series as unwatched (reset database for new users)
Contact us
RSS
Top
Bottom