Reply to thread

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 post.

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.