Reply to thread

Message

<blockquote data-quote="dihoff" data-source="post: 809543" data-attributes="member: 99120">hi all,installed a mediaportal update recently, and lost all of my config, including the watched flag for my movies! <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown&nbsp; &nbsp; :(" loading="lazy" data-shortname=":(" /> i started setting the watched flag again manually, but it's way too time consuming.can someone help me with the sql for setting the watched flag? i have all my directories named with ratings, e.g. &quot;Toy Story 3 c2010_++++&quot; - if there's a + it would indicate that the movie has been watched.i've installed sql lite, and opened the database, as per this <a href="https://forum.team-mediaportal.com/moving-pictures-284/database-movingpictures-stored-69467/" target="_blank">post</a>.now, i just need the sql, so, something like:update user_movie_settingsset watched = 1where user_movie_settings.id = local_media.idand local_media.fullpath like '%+%'this obviously being incorrect.tia,dh.</blockquote>

[QUOTE="dihoff, post: 809543, member: 99120"] hi all, installed a mediaportal update recently, and lost all of my config, including the watched flag for my movies! :( i started setting the watched flag again manually, but it's way too time consuming. can someone help me with the sql for setting the watched flag? i have all my directories named with ratings, e.g. "Toy Story 3 c2010_++++" - if there's a + it would indicate that the movie has been watched. i've installed sql lite, and opened the database, as per this [URL="https://forum.team-mediaportal.com/moving-pictures-284/database-movingpictures-stored-69467/"]post[/URL]. now, i just need the sql, so, something like: update user_movie_settings set watched = 1 where user_movie_settings.id = local_media.id and local_media.fullpath like '%+%' this obviously being incorrect. tia, dh. [/QUOTE]

Verification