Code: Select all
(f.status=2 OR f.status=6 OR f.status=10 OR f.status=18 OR f.status=34)
Code: Select all
OR l.type=xx OR l.type=yy
Notification when file in Mylist is changed via CREQ [DONE]
Moderator: AniDB
And what about files which have set by adding 'corrupted version' or 'self edited' Type? I think this part of query
should be extended by:
(i dont know exact field names and values, but i pressume it is stored in this table)
well,
the question is how you want to use that list.
As i understand it most ppl mainly want to have a way to hunt down corrupted versions in their collection which they are unaware of.
The mylist filestates corrupted&co are always selected explicitly by the user. That means he's obviously aware that the file is corrupted.
If seen from that point I don't think it's a good idea to list files with mylist filestate corrupted too.
BYe!
EXP
the question is how you want to use that list.
As i understand it most ppl mainly want to have a way to hunt down corrupted versions in their collection which they are unaware of.
The mylist filestates corrupted&co are always selected explicitly by the user. That means he's obviously aware that the file is corrupted.
If seen from that point I don't think it's a good idea to list files with mylist filestate corrupted too.
BYe!
EXP