if there is a way to get this, please tell me.
i havn't found something.
i want my files in Mylist to be checked, if there is a higher version of a file from the same group
for example - i have:
file id: 47692 - one piece 93 - by K-F - File Version: v1 - Version 1
this file exists too:
file id: 47912 - one piece 93 - by K-F - File Version: v2 - Version 2
so i want anidb to tell me this.
is there a way? if not, is there a chance to implement this?
thank you very much
bye
Search in Mylist for files with higher versions [CLOSED]
Moderator: AniDB
You can use the notification-function. Set it to 'group' and it will keep an eye on the series to see whether there are new episodes/files for that group.
I agree it`s only a workaround, but it should work well.
I would like to see (v1 -> v2 updates when in MyList) this as a new feature as well though.
I agree it`s only a workaround, but it should work well.
I would like to see (v1 -> v2 updates when in MyList) this as a new feature as well though.
-
- AniDB Staff
- Posts: 438
- Joined: Thu Apr 08, 2004 1:43 am
- Location: Portugal
that mylist report was thought by some people, i also thought about it on the exports, the trouble i think is that the code to implement what is asked is a bit heavy...Gambit wrote:You can use the notification-function. Set it to 'group' and it will keep an eye on the series to see whether there are new episodes/files for that group.
I agree it`s only a workaround, but it should work well.
I would like to see (v1 -> v2 updates when in MyList) this as a new feature as well though.
I dont know anidb database structure, but it looks not such problematic:
//assumming table names: user_files and all_files
If there is index all_files(aid,eid,gid,version) it should be rather fast query (only one check for key in index for every user file - which means small linear cost).
//assumming table names: user_files and all_files
Code: Select all
select uf.* from user_files uf where uid=<user_id>
where exists (select af.fid from all_files af
where af.aid=uf.aid -- same anime id
and af.eid = uf.eid -- same episode number
and af.gid=uf.gid -- same group id
and af.version = uf.version+1) -- and exactly next version