Search in Mylist for files with higher versions [CLOSED]

old granted and denied feature requests

Moderator: AniDB

Locked
Desmond
Posts: 4
Joined: Fri May 19, 2006 8:42 am

Search in Mylist for files with higher versions [CLOSED]

Post by Desmond » Fri May 19, 2006 8:55 am

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

User avatar
Gambit
AniDB Staff
Posts: 555
Joined: Sun Oct 06, 2002 11:21 am

Post by Gambit » Fri May 19, 2006 10:55 am

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.

User avatar
fahrenheit
AniDB Staff
Posts: 438
Joined: Thu Apr 08, 2004 1:43 am
Location: Portugal

Post by fahrenheit » Fri May 19, 2006 4:32 pm

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.
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
AniDB Staff
Posts: 1227
Joined: Fri Mar 21, 2003 10:19 am

Post by Der Idiot » Fri May 19, 2006 10:21 pm

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

User avatar
Elias
Posts: 242
Joined: Tue Feb 17, 2004 4:55 pm

Post by Elias » Sat May 20, 2006 11:16 am

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
AniDB Staff
Posts: 1227
Joined: Fri Mar 21, 2003 10:19 am

Post by Der Idiot » Sat May 20, 2006 12:56 pm

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

Locked