2017-04-12, 15:02
Hey Guys -
I recently migrated over to using a mySQL database instead of individual DBs. When building it, I set everything up from scratch again. One thing I depend on is Trakt to sync things between different services I use like Plex. Even though I set everything up to import from NFO files plus installed Trakt, nothing is marked as watched. I searched online, but most of what I found wasn't relevant or really old.
Any suggestions? My advancedsettings.xml is below Thanks!
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.25</host>
<name>KodiVideo</name>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.25</host>
<name>KodiAudio</name>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
<recentlyaddeditems>75</recentlyaddeditems> <!-- How many items to list in "Recent" category -->
<hideemptyseries>true</hideemptyseries> <!-- set to "true" to hide empty series in the video library and prevent empty series from being removed during a library cleanup. -->
</videolibrary>
<video>
<timeseekforward>60</timeseekforward> <!-- Skip back time 60 s -->
<timeseekbackward>-15</timeseekbackward> <!-- Skip forward time 15 s -->
<subsdelayrange>150</subsdelayrange> <!-- Subtitle offset adjustment range -->
<playcountminimumpercent>85</playcountminimumpercent> <!--Minimum percentage that has to be played before it is marked as watched. Set to 101 to never auto-mark items as watched -->
<ignorepercentatend>15</ignorepercentatend> <!-- percentage of video to ignore at the end. If you stop watching the video here no resume point is created. Set to 101 to never save a resume point. The video is already marked as watched at 90%, see above. -->
<excludefromscan>
<regexp>-trailer</regexp>
<regexp>[!-._ \\/]rarbg[-._ \\/]</regexp>
<regexp>[!-._ \\/]sample[-._ \\/]</regexp>
<regexp>[!-._ \\/]preview[-._ \\/]</regexp>
<regexp>[!-._ \\/]extras[-._ \\/]</regexp>
<regexp>.*bonus.*</regexp>
<regexp>.*sample.*</regexp>
</excludefromscan>
<trailermatching> <!-- This regexp will match moviename_Trailer.avi -->
<regexp>(.*?)(-trailer)(\.[^.]+)$</regexp>
</trailermatching>
</video>
<pathsubstitution>
<substitute>
<from>special://profile/playlists/</from>
<to>smb://192.168.0.25/kodi/playlists/</to>
</substitute>
<substitute>
<from>special://profile/sources.xml</from>
<to>smb://192.168.0.25/kodi/sources.xml</to>
</substitute>
<substitute>
<from>special://profile/mediasources.xml</from>
<to>smb://192.168.0.25/kodi/mediasources.xml</to>
</substitute>
<substitute>
<from>special://profile/RssFeeds.xml</from>
<to>smb://192.168.0.25/kodi/RssFeeds.xml</to>
</substitute>
<substitute>
<from>special://profile/favourites.xml</from>
<to>smb://192.168.0.25/kodi/favourites.xml</to>
</substitute>
<substitute>
<from>special://profile/passwords.xml</from>
<to>smb://192.168.0.25/kodi/passwords.xml</to>
</substitute>
</pathsubstitution>
</advancedsettings>
I recently migrated over to using a mySQL database instead of individual DBs. When building it, I set everything up from scratch again. One thing I depend on is Trakt to sync things between different services I use like Plex. Even though I set everything up to import from NFO files plus installed Trakt, nothing is marked as watched. I searched online, but most of what I found wasn't relevant or really old.
Any suggestions? My advancedsettings.xml is below Thanks!
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.25</host>
<name>KodiVideo</name>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.25</host>
<name>KodiAudio</name>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
<recentlyaddeditems>75</recentlyaddeditems> <!-- How many items to list in "Recent" category -->
<hideemptyseries>true</hideemptyseries> <!-- set to "true" to hide empty series in the video library and prevent empty series from being removed during a library cleanup. -->
</videolibrary>
<video>
<timeseekforward>60</timeseekforward> <!-- Skip back time 60 s -->
<timeseekbackward>-15</timeseekbackward> <!-- Skip forward time 15 s -->
<subsdelayrange>150</subsdelayrange> <!-- Subtitle offset adjustment range -->
<playcountminimumpercent>85</playcountminimumpercent> <!--Minimum percentage that has to be played before it is marked as watched. Set to 101 to never auto-mark items as watched -->
<ignorepercentatend>15</ignorepercentatend> <!-- percentage of video to ignore at the end. If you stop watching the video here no resume point is created. Set to 101 to never save a resume point. The video is already marked as watched at 90%, see above. -->
<excludefromscan>
<regexp>-trailer</regexp>
<regexp>[!-._ \\/]rarbg[-._ \\/]</regexp>
<regexp>[!-._ \\/]sample[-._ \\/]</regexp>
<regexp>[!-._ \\/]preview[-._ \\/]</regexp>
<regexp>[!-._ \\/]extras[-._ \\/]</regexp>
<regexp>.*bonus.*</regexp>
<regexp>.*sample.*</regexp>
</excludefromscan>
<trailermatching> <!-- This regexp will match moviename_Trailer.avi -->
<regexp>(.*?)(-trailer)(\.[^.]+)$</regexp>
</trailermatching>
</video>
<pathsubstitution>
<substitute>
<from>special://profile/playlists/</from>
<to>smb://192.168.0.25/kodi/playlists/</to>
</substitute>
<substitute>
<from>special://profile/sources.xml</from>
<to>smb://192.168.0.25/kodi/sources.xml</to>
</substitute>
<substitute>
<from>special://profile/mediasources.xml</from>
<to>smb://192.168.0.25/kodi/mediasources.xml</to>
</substitute>
<substitute>
<from>special://profile/RssFeeds.xml</from>
<to>smb://192.168.0.25/kodi/RssFeeds.xml</to>
</substitute>
<substitute>
<from>special://profile/favourites.xml</from>
<to>smb://192.168.0.25/kodi/favourites.xml</to>
</substitute>
<substitute>
<from>special://profile/passwords.xml</from>
<to>smb://192.168.0.25/kodi/passwords.xml</to>
</substitute>
</pathsubstitution>
</advancedsettings>
