AniDB

The brand-new eMule 0.46b supports "emule collection" files, i. e. small files (limited to 10 kB) with the extension ".emulecollection" that contain a list of ed2k file hashes and are automatically transferred with top priority. It would be neat to enable the aniDB data model as ...

exp wrote:please try again.

Done, and this time it worked.

Rar wrote:Side point I feel needs reiterating: Alien 9 is great.

That's why I'm even adding files to it in a language I don't speak myself...

The File with ID 18743 has a playing time of 27:43 min and was released by the group "Trilium". I tried to "request edit" the file entry but aniDB misinterpreted this as adding the file, which led to a hash conflict... I've added the other files of this release, and tagged them w...

You can judge whether a review is helpful a lot better (and with a lot less bias) when you haven't seen the anime it's about. I don't think I can agree about this point. How can I rate whether a review covers the relevant aspects of an anime as long as I don't have an opinion about what they are? I...

If this dialog were to be enhanced I'd like to have SHA hash and playing time columns in the mass add table as well, any maybe columns for kb/sec values of video and audio. Plus one field to add a generic comment to all files.

It is characteristic for my reviewing style to compare anime to other anime, and to build some semantic network amongst related anime (whatever I consider "related"). As support this method within my reviews in aniDB I'd like to have the ability to link to other aniDB reviews (of the same ...

I wonder if a separate table is the idea I'd support here. What about an additional column of the "mylist" table? I should be required to know an anime whose reviews I vote on, right? "mylist" already provides links to reviews for those animes; I'd like to get additional links to...

Instead of this separate display I'd prefer an additional column in the MyReviews table that shows the date of the most recent vote I've received for each of my review. Thus I would be able to sort this table by this column and get the information windmage was asking for as well. (I'd probably even ...

Raptor wrote:The graph of votes is the only way to have an idea of what the anime is really worth i dont want this to be destroyed.

Merging both group of votes wouldn't necessarily destroy the graph of votes, as permanent and temporary votes might be displayed as parts of each column with different colors.

I think you are mixing SQL with classic languages like C or Java Surely the HTML output isn't generated directly via SQL but by using some third generation algorithmic language that is sure capable of building trees with pointers. All this language (most likely Perl or PHP) needs as input is the se...

The current separation between permanent and temporary voting makes it impossible to give honest ratings for some people. The current system forces everyone not completing a series to either bash the series (by voting permanently) or push this series (by not voting permanently), both of which I cons...

The mylist reports are meant to help people who contribute to the content, right? If so, then these people wouldn't care about the performance for the calculation of the reports as they still save them hours of tedious work. Please don't disable the reports, you prevent the contributors from doing t...

while i agree with the common sense tree idea (since the real tree would be IMO way better but seem rather impossible to actually do in SQL) A tree is a set of nodes, each of which contains a pointer to its parent node and an (indexed) ID of the tree it belongs to. No problem at all to retrieve the...

i disagree temp votes are not just for show. They are there for one freaking thing and thats peoples who have not seen everything. If you cast a perm vote without seeing everything then you are quite simply cheating or do not understand the system. But if so then all the good ratings will be in the...

Very interesting topic. We had a similar discussion at some anime review site but nothing half as complex came to our mind. As a normal user of aniDB, submitting files but not anime so far (but willing to submit categories if that were helpful), I would like to add my opinion: I think a complex syst...