If for some reason certain movies are not "In collection" even though they are linked to video files (and thus obviously you do have them), this query can help:

Edited by JeF : Thanks Vald, query added to first post with id 0128

Hi, I need a help:

I'd like to update my movie database, when I have a movie running a query in order to update the field "Wanted" (untick)

Can you help me?

Thanks!

Hi,
Could you give som details about the conditions to untick Wanted flag ?
Is it for movies previously wanted without downloaded infos or not in collection and which are now in collection (so in collection flag could be used to untick 'wanted' flag) ?
Is it for movies you've now seen (playing file will automatically set the 'seen' flag so wa can use it to untick 'wanted' flag ?
Other cases ?

Here is the query for previously cases :
Switch off 'Wanted' for movies which are 'in collection' or 'seen' ( Query added to first post with id 0129)
(in plugin, click import button and copy paste those lines)

Please let me know if it's what you're expecting. Otherwise, i'll post another query with the new rules you'll mention.


JeF

Hi, is it possible for a plugin for "all actors without a photo", thanks



Uploaded with ImageShack.us

Here it is (also added to first post)
See plugin post for 'how to' add that query to the plugin

JeF

thanks a lot Jef (but I mean for all the actors in the database)

You're welcome
You mean you'll manually add a photo for each person of the database ?
Then just erase [ in_collection=1 and ] from the query command. so this will look like


JeF

Waaauw , Thats it, thanks a lot Jef, grt

Can you help with a query that list how movies seen by actors?

Thanks so much!

Hi,
As i really did find the idea interesting, i added some extra counts : movies as actor, in collection movies and the requested seen count
So, here's the query (also added to first post) (for plugin use)

JeF