Search in Mylist for files with higher versions [CLOSED]

[Desmond]

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

[Gambit]

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.

[fahrenheit]

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.

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

[Der Idiot]

not just a bit...
each time i tried to write some sql command for it i ended up in an almost infinite loop. report took like 45min to generate

but i'm a sql noob so my code is inefficient as it could get...
it's still a darn expensive query though

[Elias]

I dont know anidb database structure, but it looks not such problematic:
//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

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

[Der Idiot]

you know the problem lies in the fact that versions are stored bitwise in the flags value. which also holds censoreship and crc status. anyway it's a pain and bitflags cause only problems for me