[CGI] groups / categories in mylist [tracked]

old granted and denied feature requests

Moderator: AniDB

Locked
Elberet
Posts: 778
Joined: Sat Jul 19, 2003 8:14 pm

[CGI] groups / categories in mylist [tracked]

Post by Elberet »

Basically, the same thing that eMule 0.26+ does...

Purpose:
To better sort, order and manage the animes in the mylist so that, for example, friends looking at the mylist can instantly find your personal favorites. Would also help with separating movies from series and ongoing series from completed ones.


Possible user interface solution:

- Add a link to a category management page in the mylist menu's utils section. In the category manager, users can create, rename and delete mylist categories.

- Add a dropdown control and "Select" button at the top, just below the character bar. The dropdown contains all currently existing categories. Selecting a category will hide all files that are in a different or no category. A default category "all" will ignore the category assignment and simply show all files, as it does right now.

- Add a second dropdown control and "Move" button close to the actions dropdown.

- Extend the mylist table to include a category id for each file. The category can be assigned by editing the mylist entry or using the move button.

- On anime pages, add a mylist category dropdown to the "seen" and "state" dropdowns.

Alternatives:
- Place the category selector into the right border in the mylist, below the menu.
- Allow category names to be typed in; if a category with that name doesn't exist, it is created on the fly.
- More to come... ;)
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp »

hm,

dunno, it's not that easy with all the caching going on @ mylist.
and the way you describe it one cat per anime/file won't be enough.
ppl would want to be able to assign multiple cats to one anime/file.

another thing, what gain is there in making this file based?

BYe!
EXP
Elberet
Posts: 778
Joined: Sat Jul 19, 2003 8:14 pm

Post by Elberet »

exp wrote:another thing, what gain is there in making this file based?
Probably none, but since I don't know your database layout, I'm still making up my suggestions based on the assumption that the mylist is a 1:n relation between users and files with some additional meta data per relation entry. If that is the case, adding a category column to the relation table is a kinda simple thing to do, whereas assigning them to animes and episodes requires a whole new relations table.

But as I said, that's based on assumptions, so if making it per-anime or per-episode is easier, don't strain yourself to make it per-file. ;)
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp »

Elberet wrote:Probably none, but since I don't know your database layout, I'm still making up my suggestions based on the assumption that the mylist is a 1:n relation between users and files with some additional meta data per relation entry. If that is the case, adding a category column to the relation table is a kinda simple thing to do, whereas assigning them to animes and episodes requires a whole new relations table.
you are correct there @ 1:n relation users<->files
however making it file based would introduce lots of additional overhead @ cachecreation & edit.
so _if_ i implement it i'd rather add a new table to store that info. and as i see it atm i would probably make that info anime based.
i.e.
uid int4
aid int4
type int4
with (uid, aid) unique

BYe!
EXP
Elberet
Posts: 778
Joined: Sat Jul 19, 2003 8:14 pm

Post by Elberet »

Hmm, why would that one additional column cause a big overhead during cache creation?

At least having the category-associations in a separate table would really allow us to have an anime or file in more then one category - but then, the small dropdown control needs to be replaced with an array of checkboxes or even a separate "edit category" page. ;)
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp »

Elberet wrote:Hmm, why would that one additional column cause a big overhead during cache creation?
i would have to ensure that all files for one anime have the same cat set.
that would require quite some changes and additional sql queries in a lot of places.
and the mylist overview does not query the mylist table directly but a seperate anime based mylist cache table. that would would need to be kept up to date with the cat settings of the mylist entries for each anime.

BYe!
EXP
Elberet
Posts: 778
Joined: Sat Jul 19, 2003 8:14 pm

Post by Elberet »

exp wrote:i would have to ensure that all files for one anime have the same cat set.
Why? Instead of working hard to prevent this, make it a feauture - tho the only benefit gained from this would probably be for people like me who use the mylist as a download queue... <innocent look>
exp wrote:and the mylist overview does not query the mylist table directly but a seperate anime based mylist cache table. that would would need to be kept up to date with the cat settings of the mylist entries for each anime.
If you make it per-file, there wouldn't be so much problems. During cache generation, the category setting can be copied 1:1 to the cache table. During live-updates, it would be the same thing that happens when a user edits a mylist entry. I figure the edit results in two queries to update the main mylist table and the cache table, or not?

The only problem I see here is that it is impossible to show exact eps and seen stats for animes that are split over more then one category. But you could call that a feauture, too: "unified anime-stats"... ;)
Locked