MyList export template guidelines

From AniDB
Jump to: navigation, search

Contents

This page will try to give some pointers in to MyList Export Template creation.

Frequently Asked Questions

What are MyList Exports?

MyList exports are a way to export your MyList, providing off-line browsing capabilities, it's like a snapshot of the state of your MyList at the moment you requested the export.

Can I create my own template?

Yes, this page should help you starting with your own template.

What are the requirements for building a template?

Well, the only true *requirement* is a text editor, though if you want to test your template before submitting you will need Perl (v5.8.8+) to use the SDK.

Include images, ext. stylesheets/JavaScript files with templates?

Yes, you can even include subdirectories but please try to keep the size low.

How do I create files other than .htm?

Take a look at the csv-minimal theme. You need to create a file called extension.dat which only contains the desired extension, _without_ the dot!

What is that info.dat file?

It's meant to provide the user with a short info about the template. The content should not be too long but is otherwise left to the author of the template.
However, it is strongly recommended to begin the file with 3 special lines:
(C) 2003 by EXP
Version: 0.01 (08.07.2003)


1. copyright of the template author, you may include your email address here
2. version number and date
3. one empty line

About the SDK

About this SDK

This SDK is meant to allow you to test your templates for the AniDB MyList export function on your own pc. It should work under Windows and Linux. You might need to install some additional software (see bellow for Installing Perl).

Current version and where to get

Current release of the SDK is 0.13.4, get here: http://static.anidb.net/files/anidb_template_sdk_0.13.4.rar
Current version of the SDK on SVN is 0.13.5.

Resources

The new development forum
The old development forum (old forum)
The SDK thread (old forum)
Image pack

Installing Perl

This program needs Perl to create example html files from the templates. If you don't have Perl installed (preferably 5.8.8) you'll need to do so now.
Under Windows you'll need to download ActivePerl 5.8.8.820+ from activeperl.com:
http://www.activestate.com/activeperl/downloads
Install it to c:\perl (or some other directory, but remember where you installed it!).
Under Linux it should already be installed. If not get it from the link above.
If you are not using 5.8.8.820 it's possible you need to update Storable, try the following:
perl -MCPAN -eshell
install Storable
bye
Note If you installed 5.8.8.820 don't overwrite Perl's copy of Storable with the one in the SDK.

Additional Module HTML::Template::Expr

Under Windows with ActivePerl go to it's startmenu entry (might be called "ActiveState ActivePerl 5.8") and start "Perl Package Manager". Then enter
install HTML-Template-Expr
exit
Under Linux you have to do a:
perl -MCPAN -eshell
install HTML::Template::Expr
bye
You should now be able to execute export.pl, take a look at the provided bat file to see how it is used.
(export.pl takes one parameter which is the name of the template to use)


Note You can get more information about the HTML::Template::Expr here: http://html-template.sourceforge.net/html_template_expr.html

Changelog

Read here Mylist export SDK changelog

GIT Access

AniDB:Mylist_export_DEV

Template HowTo

Well, here's all you need to write templates for the MyList export function.
We really need better templates!

A theme consist out of one or multiple tpl files. Those are called:

  • mylist.tpl - (mandatory)
  • anime.tpl - (optional)
  • extension.dat - (optional)
  • info.dat - (mandatory)
  • changelog.txt - (optional)

All files, if possible, in Unix format. But dos format doesn't hurt either, I'll convert them, in that case.
The export script will parse the mylist.tpl file and create one output file called i.e. mylist.htm. So mylist.tpl get's parsed only once (because you only have one MyList).
However anime.tpl will be parsed once for every anime in your MyList. And for each a unique file will be created. The default file extension for the output files is "htm", however if you create a file called "extension.dat" and put only the extension in the first line of the file, i.e. "txt" then that extension will be used.

The file info.dat should contain at least the following 3 lines:

   (C) 2003 by EXP
   Version: 0.01 (08.07.2003)

1. copyright of the template author, you may include your email address here
2. version number and date
3. one empty line

The rest may be used for a short description of the template.
Please do not include the changelog in your info.dat file, instead create a separate changelog.txt file and put your changelog there.

Please also note that the content of the info.dat will be displayed on the AniDB MyList Export Page, so please make sure that your additional info is actually of interest to AniDB users who are trying to decide which theme to use.

The export script will create the file (i.e.) mylist.htm and if anime.tpl was provided a folder "anime" where for each anime a file "a<animeid>.htm" will be created.
This can be used to created a linked animelist instead of one huge single html file with all data in it.
The tpl files are simple plain text or html files. So just put normal html code in them.

The export function uses the HTML::Template Perl module to create the output.
This means you have to use some special tags:


Examples

Example 1

<tmpl_var name=data_anime_name> 
will be replaced with the value of the specified variable, in this case the anime name.

Example 2

<tmpl_if name=status_anime_iswatched>anime is watched<tmpl_else>anime is unwatched</tmpl_if>
This is a simple if/else statement. This would write "anime is watched" or "anime is unwatched" into the resulting html file. Note that you can only check if a variable is defined, it is not possible to compare values. All variables beginning with status_ are meant to be used in ifs. They are either 0 or 1.

Example 3

<tmpl_unless name=status_anime_iswatched>anime is unwatched</tmpl_unless>
You can also used id variables, if the id is undef (0) they are false, otherwise they are true.

The negation of <tmpl_if> is <tmpl_unless> i.e.

This would only write "anime is unwatched" to the output file if status_anime_iswatched is 0.
Note that this tag is closed with /tmpl_unless and not tmpl_if.

Example 4

<tmpl_if expr="data_file_audcnt > 1">multiple audio streams</tmpl_if>
You can also check if a value is greater or smaller than something.

Example 5

You will also need loops to create a useful template. What are loops?
Well, to create html tables there will be some parts of the html code (mostly table rows) which need to be repeated over and over again and filled with anime/ep/file info.
This is specified like this:
<tmpl_loop name=loop_anime>

</tmpl_loop>

<tmpl_var name=data_anime_name>
This would create a table with a list of all anime titles.
Take a look at the included themes for more examples.

NOTE: the first and last lines in anime.tpl start/close a loop, this has internal reasons and you have to do this too, or your theme won't work.

ADVICE: the best way to write your own theme might be to take one of the existing ones and edit it.

List of variables

Global Vars

global_user 
AniDB Username
global_user_id 
AniDB Username ID
global_date 
Date of creation (i.e. 02.08.2003 12:18)
global_date_short 
Short date of creation (i.e. 02.08.03)
global_animecount 
Number of anime in MyList
global_totalepcount 
Total number of episodes in MyList, including both normal and special episodes
global_epcount 
Number of normal episodes in MyList
Normal excludes special episodes, such as S, C, T, O, and P episodes
global_spcount 
Number of special episodes in MyList
Special episodes only, such as S, C, T, O, and P episodes
global_filecount 
Number of files in MyList
global_bytecount 
Overall size of all files in MyList in Bytes
global_bytecount_h 
Same as global_bytecount but in kB, MB, GB, ...
global_animedburl 
URL to animedb, http://..../animedb.pl
global_userstat_animeadded 
Anime entries added by user to DB
global_userstat_epsadded 
Episode entries added by user to DB
global_userstat_filesadded 
Files added by user to DB
global_userstat_groupsadded 
Group entries added by user to DB
global_userstat_lamefiles 
Number of lame files user owns
global_userstat_lamefilesp 
Percentage of lame files in MyList
global_userstat_independencep 
Percentage of independence (AniDB_Stats:Most_Independent_User)
global_userstat_leechp 
Percentage of leechness (AniDB_Stats:Biggest_Leech0r)
global_userstat_reviews 
Total reviews written by user
global_userstat_votes 
Number of votes issued by user
global_userstat_totalviewedp 
Percentage of viewed episodes, from all DB
global_userstat_totalownedp 
Percentage of owned episodes, from all DB
global_userstat_ownviewedp 
Percentage of viewed episodes, from MyList
global_userstat_viewedepcnt 
Number of viewed episodes, from MyList

global_genren_loop

New global loop for the cat system NOTES: you should try to limit the usage of this loop to mylist.tpl

global_genren_id 
cat id
global_genren_name 
cat name
global_genren_parentid 
cat parent id
global_genren_ishentai 
is cat 18+ restricted

Loops, Subloops and Loopdata


loop_anime

loop for anime entries

data_anime_id 
AniDB ID for anime entry
data_anime_eps 
Total of episodes
data_anime_eps_special 
Total number of special episodes
data_anime_eps_total 
Total number of episodes
data_anime_year 
Year of release/airing
data_anime_producer 
[deprecated] Producer
data_anime_url 
Official home page
data_anime_other 
Anime synopsis
data_anime_date 
Date of addition to DB
data_anime_date_short 
Short date of addition to DB
data_anime_update 
Last update date (in Unix time format)
data_anime_update_short 
Last update short date
data_anime_startdate 
Start airing/release date
data_anime_startdate_short 
Short start airing/release date
data_anime_enddate 
End airing/release date
data_anime_enddate_short 
Short end airing/release date
data_anime_rating 
Average rating
data_anime_votes 
Total votes
data_anime_tmprating 
Average temporal rating
data_anime_tmpvotes 
Total temporal votes
data_anime_reviewrating 
Average review rating
data_anime_reviews 
Number of reviews
data_anime_type_id 
Anime type ID (see ids.txt)
data_anime_type_name 
Anime type name
data_anime_animenfoid 
Old AnimeNfo ID (i.e. 954)
data_anime_animenfoid2 
New AnimeNfo ID (i.e. klmgzk)
data_anime_animenfourl 
Complete AnimeNfo URL (without <a href="">, just a plain URL)
data_anime_animenfourl_name 
AnimeNfo link name as displayed at AniDB (i.e. "ID: 954" or "ID: 954,klmgzk")
data_anime_annid 
Anime News Network ID

If only one file is present for an anime the following variables will have the same values as the ones for that file, if there is more than one file and all files have the same mystate it will match those. in any other case the mystate is undef

data_anime_mystate 
State of anime files (undef=-1, unknown=0, on hdd=1, on cd=2, deleted=3)
data_anime_mystate_string 
String representation of state (i.e. "unknown" or "on CD")
data_anime_mystate_icon 
AniDB URL to state icon (img tag already included)
data_anime_wishlist_type 
Wishlist type ID (0="unknown / unfiled", 1="to watch", 2="to get", 3="blacklist"),
data_anime_wishlist_type_name 
Wishlist type name
data_anime_wishlist_priority 
Wishlist priority (0="low", 1="medium", 3="high")
data_anime_wishlist_priority_name 
Wishlist priority string representation
data_anime_wishlist_comment 
Wishlist comment
data_anime_my_vote 
User vote for this anime
data_anime_my_tmpvote 
User temporal vote for this anime
data_anime_my_vote_date 
Date when vote for anime was last changed
data_anime_my_vote_date_short 
Same, short version
data_anime_my_tmpvote_date 
Date when temp vote for anime was last changed
data_anime_my_tmpvote_date_short 
Same, short version
data_anime_annurl 
Anime News Network URL
data_anime_allcinemaid 
AllCinema ID
data_anime_allcinemaurl 
AllCinema URL
data_anime_animeplanetid 
Anime-Planet ID (i.e. 415)
data_anime_animeplaneturl 
Anime-Planet Recommendation URL
data_anime_my_eps 
Number of non-special episodes in MyList
data_anime_my_eps_special 
Number of special episodes in MyList
data_anime_my_eps_total 
Number of non-special and special episodes in MyList
data_anime_my_watchedeps 
Number of watched episodes
data_anime_my_watchedeps_special 
Number of watched specials
data_anime_my_watchedeps_total 
Total number of watched episodes and specials
data_anime_my_unwatchedeps 
Number of unwatched episodes
data_anime_my_unwatchedeps_special 
Number of unwatched specials
data_anime_my_unwatchedeps_total 
Total number of unwatched episodes and specials
data_anime_my_size 
Overall size of all anime files in MyList in Bytes
data_anime_my_size_h 
Same as data_anime_my_size but in kB, MB, GB, ...
data_anime_name 
Default anime title (mostly Japanese romaji), always present
data_anime_name_langname 
Language name (ie: Japanese)
data_anime_name_langsname 
Language shortname (i.e.: ja)
data_anime_title_jap_kanji 
Anime title in Japanese kanji, optional
data_anime_title_eng 
Anime title in English, optional
data_anime_title_other 
Other official title in another language, optional
data_anime_awardicons 
Ready to use html string which displays the little award icons from AniDB. Empty string if no awards are present.

loop_anime_genren

loop for new genres (categories)

data_anime_genren_id 
Genre (Category) ID
data_anime_genren_name 
Genre (Category) name
data_anime_genren_parentid 
Parent genre (category) ID
data_anime_genren_ishentai 
This genre (category) is hentai related
data_anime_genren_weight 
Weight of the category
data_anime_genren_weight_name 
Textual notation of the category weight

loop_anime_tag

loop for user defined tags

data_anime_tag_id 
Tag ID
data_anime_tag_name 
Tag name
data_anime_tag_date 
Date of creation

loop_anime_company

loop for all involved companies

data_anime_company_id 
Company ID
data_anime_company_name 
Company name
data_anime_company_shortname 
Company short name
data_anime_company_othername 
Company other name
data_anime_company_type 
Company type ID (see ids.txt)
data_anime_company_url 
Company URL
data_anime_company_picurl 
Company logo URL
data_anime_company_aptype 
Company role for the anime (see ids.txt)
data_anime_company_type_name 
company type string (company, organization, individual, etc.)
data_anime_company_aptype_name 
company relation to given anime string (production, music, etc.)

loop_anime_title_official

loop for official titles

data_anime_title_official_name 
Official title (data_anime_name is not included, data_anime_title_jap_kanji and data_anime_title_eng are included)
data_anime_title_official_langid 
Language ID
data_anime_title_official_langname 
Language name (ie: Japanese)
data_anime_title_official_langsname 
Language shortname (ie: ja)

loop_anime_title_alias

loop for synonyms

data_anime_title_alias_name 
Synonyms (data_anime_name and data_anime_title_* are not included)
data_anime_title_alias_langid 
Language ID
data_anime_title_alias_langname 
Language name (ie: Japanese)
data_anime_title_alias_langsname 
Language shortname (ie: ja)

loop_anime_title_short

loop for short titles

data_anime_title_short_name 
Short titles
data_anime_title_short_langid 
Language ID
data_anime_title_short_langname 
Language name (ie: Japanese)
data_anime_title_short_langsname 
Language shortname (ie: ja)
loop_anime_titles

loop for all titles

data_anime_title_name 
Title
data_anime_title_langid 
Language ID
data_anime_title_type_id 
Type ID (1 = main, 2 = syn, 3 = short, 4 = official)
data_anime_title_type_string 
Type name (main, syn, short, official)
data_anime_title_langname 
Language name (ie: Japanese)
data_anime_title_langsname 
Language shortname (ie: ja)

loop_anime_award_types

loop for award types

Award types describe the types of awards which were assigned to this anime. Typically that would be AniDB TOP10 or ARC Awards, however this is likely to be extended in the future without notice, your template should not depend on the id.

data_anime_award_type_id 
Award type ID
data_anime_award_type_name 
Award type name
data_anime_award_type_img 
Award type image (full html image tag)

loop_anime_awards

loop for Awards

These are the actual awards which are assigned to this anime. These are things like the AniDB TOP10 award, ARC Best Anime, ARC Best Action Anime, etc. Again a template should not depend on the ids.

data_anime_award_id 
Award ID
data_anime_award_name 
Award name
data_anime_award_type 
Award type
data_anime_award_url 
Award URL (URL assigned to this award, i.e. overview over all awards of this type)
data_anime_award_picurl : URL to pic only [this was removed since AniDB v0.1.47]

loop_anime_genre

loop of anime genres (old system)

data_anime_genre_id 
Genre ID
data_anime_genre_name 
Genre name

loop_anime_groups

loop of anime groups

data_anime_group_id 
Group ID
data_anime_group_agid 
Group AGID
data_anime_group_name 
Group name
data_anime_group_sname 
Group shortname
data_anime_group_state 
Group state (complete, dropped, etc)
data_anime_group_lastep 
Last episode released
data_anime_group_lastup 
Last update date (dd.mm.yyyy hh:mm)
data_anime_group_votes 
Number of votes
data_anime_group_rating 
Rating
data_anime_group_cmts 
Number of comments
data_anime_group_epcnt 
Normal episode count
data_anime_group_sepcnt 
Specials count (S + O + C + T + P eps)
data_anime_group_myvote 
My vote or '-' if none
data_anime_group_myvote_date 
My vote date (dd.mm.yyyy hh:mm)
data_anime_group_eprange 
episode range for a given group (as in AniDB)

data_anime_group_alangs_loop

loops group audio languags

data_anime_group_alang_id 
audio language id (i.e.: 1)
data_anime_group_alang_name 
audio language name (Chinese, English, etc)
data_anime_group_alang_sname 
audio language short name (ja, ne, etc)

data_anime_group_slangs_loop

loops group subtitle languags

data_anime_group_slang_id 
sub language id (i.e.: 1)
data_anime_group_slang_name 
sub language name (Chinese, English, etc)
data_anime_group_slang_sname 
sub language short name (ja, ne, etc)

Status variables
status_anime_iscomplete 
Anime is complete (0/1)
status_anime_iswatched 
Anime is completely watched (0/1)
status_anime_genre_<genrename> 
[deprecated] i.e. status_anime_genre_action = 1, if the anime has genre action added. Genres are all lower case and spaces are replaced with _.
status_anime_my_isvoted 
User voted for this anime (0/1)
status_anime_my_istmpvoted 
User temporally voted for this anime (0/1)
status_anime_mystate_undef 
Has undefined state (0/1)
status_anime_mystate_unknown 
Has unknown state (0/1)
status_anime_mystate_onhdd 
Has onhdd state (0/1)
status_anime_mystate_oncd 
Has oncd state (0/1)
status_anime_mystate_deleted 
Has deleted state (0/1)
status_anime_isinwishlist 
Anime is in wishlist
status_anime_hasawards 
Has awards (0/1)
status_anime_title_has_other 
Has other title (0/1)
status_anime_title_has_jap_kanji 
Has kanji title (0/1)
status_anime_title_has_eng 
Has English title (0/1)
status_anime_allcinema_listed 
All Cinema is listed (0/1)
status_anime_animeplanet_listed 
Anime-Planet is listed (0/1)
status_anime_ann_listed 
Anime News Network is listed (0/1)
status_anime_isrestricted 
Anime has +18 restricted audience (0/1)

loop_ep

loop for episodes

data_ep_id 
Episode ID (as in DB)
data_ep_epno 
Episode number
data_ep_name 
Episode name
data_ep_name_romaji 
Romaji episode name
data_ep_name_kanji 
Kanji episode name
data_ep_length 
Episode length, in minutes
data_ep_aired 
Date of first airing
data_ep_aired_short 
Short date of first airing
data_ep_other 
Other information related to episode
data_ep_rating 
Average rating
data_ep_votes 
Total votes
data_ep_myvote 
My vote for a given episode
data_ep_myvote_date 
My vote date for a given episode
data_ep_date 
Date of addition to DB
data_ep_date_short 
Short date of addition to DB
data_ep_update 
Last update date
data_ep_update_short 
Last update short date
data_ep_state 
Episode state (1=Special, 2=Recap, 4=OP/ED/Credits, 32=Trailer, 64=Parody, 128=Others)

Note that the values can be added together, so 3 would be a special which is also a recap. 4, 32, 64 and 128 are exclusive If only one file is present for an ep the following variables will have the same values as the ones for that file, if there is more than one file and all files have the same mystate it will match those. in any other case the mystate is undef

data_ep_mystate 
State of anime episode (undef=-1, unknown=0, on hdd=1, on cd=2, deleted=3)
data_ep_mystate_string 
String representation of state (i.e. "unknown" or "on cd")
data_ep_mystate_icon 
AniDB url to state icon (img tag already included)

loop: data_ep_titles
data_ep_title_name 
Episode title (includes data_ep_name, data_ep_name_romaji and data_ep_name_kanji)
data_ep_title_langid 
Language ID

Episode status variables
status_ep_mystate_undef 
Has undefined state (0/1)
status_ep_mystate_unknown 
Has unknown state (0/1)
status_ep_mystate_onhdd 
Has onhdd state (0/1)
status_ep_mystate_oncd 
Has oncd state (0/1)
status_ep_mystate_deleted 
Has deleted state (0/1)
status_ep_state_special 
Episode is a special (0/1)
status_ep_state_recap 
Episode is a recap (0/1)
status_ep_state_op 
Episode is an opening (0/1)
status_ep_state_end 
Episode is an ending (0/1)
status_ep_iswatched 
Episode was watched (0/1)
status_ep_hasfile 
Episode has files (0/1)
status_ep_hasname_kanji 
Has kanji episode name (0/1)
status_ep_hasname_romaji 
Has romaji episode name (0/1)

loop_file

loop for files

data_file_id 
File ID (as in DB)
data_file_size 
File size in bytes (with dots)
data_file_size_plain 
File size in bytes (without dots)
data_file_size_h 
Same as data_file_size_plain but in MB
data_file_filetype 
File type (extension, i.e. avi or mkv)
data_file_crc 
CRC for file
data_file_md5 
MD5 hash for file
data_file_sha1 
SHA1 hash for file
data_file_tth 
TTH hash for file
data_file_ed2k_link 
Full ed2k link
data_file_ed2k_hash 
ed2k hash for file
data_file_ed2k_name 
ed2k file name
data_file_group_id 
ID for the group who released the file
data_file_group_name 
Group name
data_file_group_shortname 
Short group name
data_file_released 
Date of release
data_file_released_short 
Short date of release
data_file_qual_id 
Quality ID
data_file_qual_name 
Quality string representation
data_file_res_name 
Video resolution
data_file_vidcnt 
Count for video streams (1 for media files, 0 for others)
data_file_ar 
Aspect ratio
data_file_ar_name 
The AR string (4:3, 16:9, etc)
data_file_fps 
Frames per second
data_file_vbitrate 
Video bit rate
data_file_vcodec_id 
Video codec ID (see ids.txt)
data_file_vcodec_name 
Video codec name
data_file_vflags 
Video Flags (see ids.txt)
data_file_audcnt 
Count for audio streams (for now just 2)
data_file_atype 
audio type id (stream #1)
data_file_atype_name 
audio type string (stream #1)
data_file_abitrate 
Audio bitrate
data_file_acodec_id 
Audio codec ID (see ids.txt)
data_file_acodec_name 
Audio codec name
data_file_chantype 
Number of audio channels (see ids.txt)
data_file_chantype_name 
channel string (Mono, Stereo, etc) (stream #1)
data_file_lang_id 
Language ID (see ids.txt)
data_file_lang_name 
Language name
data_file_lang_sname 
Language shortname (ie: ja)
data_file_atype2 
audio type id (stream #2)
data_file_atype_name2 - audio type string (stream #2)
data_file_abitrate2 
Audio bitrate, for second stream
data_file_acodec_id2 
Audio codec ID (see ids.txt), for second stream
data_file_acodec_name2 
Audio codec name, for second stream
data_file_chantype2 
Number of audio channels (see ids.txt), for second stream
data_file_chantype_name2 
channel string (Mono, Stereo, etc) (stream #2)
data_file_lang_id2 
Language ID (see ids.txt), for second stream
data_file_lang_name2 
Language name, for second stream
data_file_lang_sname2 
Language shortname (ie: ja)
data_file_subcnt 
Count for subtitle streams (for now just 2)
data_file_sflags 
Subtitle flags describing the kind of subtitles (see ids.txt)
data_file_stype 
Subtitle type (see ids.txt)
data_file_stypename 
subtitle type string (stream #1)
data_file_sub_id 
Subtitle language ID (see ids.txt)
data_file_sub_name 
Subtitle language name
data_file_sub_sname 
Language shortname (ie: ja)
data_file_sflags2 
Subtitle flags describing the kind of subtitles (see ids.txt), for second stream
data_file_stype2 
Subtitle type (see ids.txt), for second stream
data_file_stypename2 - subtitle type string (stream #2)
data_file_sub_id2 
Subtitle language ID (see ids.txt), for second stream
data_file_sub_name2 
Subtitle language name, for second stream
data_file_sub_sname2 
Language shortname (ie: ja)
data_file_length 
File length in seconds
data_file_type 
File type (see ids.txt)
data_file_typename 
file type string (video,audio,etc)
data_file_type_id 
File source ID
data_file_type_name 
File source name
data_file_date 
Date of addition to DB
data_file_date_short 
Short date of addition to DB
data_file_update 
Last update date
data_file_update_short 
Last update short date
data_file_ldate 
Date when file was added to MyList
data_file_ldate_short 
Same, short version
data_file_storage 
User defined string for storage
data_file_source 
User defined string for source
data_file_other 
File comments
data_file_viewdate 
Date when viewed
data_file_viewdate_short 
Short date when viewed
data_file_state 
File state (1=CRC ok, 2=CRC error, 4=is v2, 8=is v3, 16=is v4, 32=is v5, 64=is uncensored, 128=is censored)
data_file_state_versionname 
File release version in string (including v1)
data_file_mystate 
File state (unknown=0, on hdd=1, on cd=2, deleted=3)
data_file_mystate_string 
String representation of file state (i.e. "unknown" or "on cd")
data_file_mystate_icon 
AniDB url to state icon (img tag already included)
data_file_myfilestate 
User file mystate ID (0=normal, 1=invalid crc, 2=self edited, 10=self ripped, 11=on dvd, 12 on vhs, 13=on tv, 14=theater, 20=filler ep, 100=other)
data_file_myfilestate_string 
String representation of user file mystate ID
data_file_myfilestate_icon 
AniDB url to mystate icon (img tag already included)

loop: loop_data_file_filerel

loops available file<->file relations

data_file_filerel_fid 
one end of the relation
data_file_filerel_otherfid 
the other end of the relation
data_file_filerel_type 
type of the relation (subtitle file, etc)

loop: loop_data_file_fileeprel

loops available file<->ep relations

data_file_fileeprel_fid 
the fid that spans eps
data_file_fileeprel_eid 
the episode
data_file_fileeprel_startp 
start percentage
data_file_fileeprel_endp 
end percentage

File status variables
status_file_isgeneric 
Is a generic (0/1) (Files:Generic_files)
status_file_hascomment 
Has comment (0/1)
status_file_iswatched 
File was watched (0/1)
status_file_state_crcok 
File has verified CRC (0/1)
status_file_state_crcfailed 
File has failed CRC (0/1)
status_file_state_crcunverified 
File has unverified CRC (0/1)
status_file_state_isv2 
File is second release (0/1)
status_file_state_isv3 
File is third release (0/1)
status_file_state_isv4 
File is fourth release (0/1)
status_file_state_isv5 
File is fifth release (0/1)
status_file_mystate_unknown 
Has unknown state (0/1)
status_file_mystate_onhdd 
Has onhdd state (0/1)
status_file_mystate_oncd 
Has oncd state (0/1)
status_file_mystate_deleted 
Has deleted state (0/1)
status_file_myfilestate_normal 
File is normal mystate (0/1)
status_file_myfilestate_invalidcrc 
File is invalidcrc mystate (0/1)
status_file_myfilestate_selfedited 
File is sefedited mystate (0/1)
status_file_myfilestate_selfripped 
File is selfripped mystate (0/1)
status_file_myfilestate_ondvd 
File is ondvd mystate (0/1)
status_file_myfilestate_onvhs 
File is onvhs mystate (0/1)
status_file_myfilestate_ontv 
File is ontv mystate (0/1)
status_file_myfilestate_theater 
File is theater mystate (0/1)
status_file_myfilestate_other 
File is other mystate (0/1)

List of Ids

Should this list be outdated you can also check the HTML code of the corresponding drop-downs at AniDB.


Anime Categories

unknown
TV
OVA
Movie
Web
Other
TV Special

All Languages (both Audio and Subs use the same ids)

unknown
japanese
chinese (unspecified)
english
german
french
italian
spanish
15 
russian
17 
korean
18 
polish
19 
swedish
20 
arabic
21 
portuguese
23 
norwegian
25 
brazilian
26 
catalan
27 
czech
28 
danish
29 
dutch
30 
finish
31 
greek
32 
hebrew
33 
hungarian
34 
instrumental (only on Audio Languages)
35 
lithuanian
37 
thai
38 
turkish
41 
chinese (mandarin) (not in Sub Languages)
42 
chinese (cantonese) (not in Sub Languages)
43 
taiwanese
58 
other
61 
romanian
62 
malay
63 
slovak
64 
slovenian
65 
tartar
67 
latvian
68 
georgian
69 
latin

File Types

10 
video file
20 
subtitle file
30 
audio file
90 
generic file
100 
other

Audio Codecs

unknown
AC3
WMA (also DivX Audio)
MP3 CBR
MP3 VBR
MSAudio
Vorbis (Ogg Vorbis)
AAC
10 
PCM
11 
MP2
13 
DTS

Audio Types

10 
normal audio
20 
commentary
30 
fandub
40 
alternative voiceover
100 
other

Channel Types

10 
1.0 - mono
20 
2.0 - stereo
30 
4.0 - dolby surround
40 
5.1 - 5.1 surround
50 
6.1 - 6.1 surround
60 
7.1 - 7.1 surround
100 
other
200 
unknown

Subtitle types

10 
hard sub
20 
soft sub
30 
supplementary soft sub (i.e. sign translations)
100 
other
200 
unknown

Subtitle Flags (bits)

none
additional explanations
dubsubbed
hearing impaired subs
image subs
16 
karaoke subbed
32 
signs translated
64 
styled subs
128 
subs for commentary audio stream
256 
unstyled subs

Video Flags (bits)

none
anamorphic
wrong aspect ratio
variable frame rate
clean video (no hardsubs...)

Video Codecs

unknown
DivX UNK
DivX3
DivX4
DivX5 (also DivX6)
MPEG-1
10 
MPEG-2
11 
ASP Other
12 
Other (non-ASP)
14 
RealVideo Other
17 
XviD
18 
MS MP4x (also WMV1/2)
19 
WMV9 (also WMV3)
20 
RealVideo 9/10 (also RV40)
22 
H264/AVC

Quality Ratings

unknown
very high
high
med
low
very low
corrupted
eyecancer

File Source Type

unknown
camcorder
TV
VHS
DTV
LD
DVD
SVCD
VCD
10 
HKDVD
11 
www

Aspect Ratio Ids

10 
4:3
20 
16:9
30 
1.66:1
40 
1.85:1
50 
2.00:1
60 
2.21:1
70 
2.35:1
100 
other
200 
unknown

File extensions

do not have ids


Company Ids

10 
Company
20 
Organization
30 
Individual

Company Role

10 
Financial Production
20 
Animation Production
30 
Original Story
40 
Music Production
50 
Animation Co-Production
500 
Original Work
510 
Production
520 
Production Assistance
530 
Production Studio
540 
Work
550 
Work Assistance
560 
Work Studio
570 
Animation
580 
Animation Work
590 
Animation Work Assistance
600 
Music Work
610 
Photography
620 
Animation Assistance
630 
Publication
640 
Music Work Assistance
650 
Music Assistance
660 
Music Production
670 
Assistance/Cooperation
1000 
Unknown Relation

Genres

Deprecated

Action
Adventure
26 
Cars
Comedy
25 
Dementia
10 
Demons
35 
Detective
Drama
Ecchi
11 
Fantasy
33 
Game
34 
Ghibli
Hentai
12 
Historical
Horror
27 
Kids
14 
Magic
15 
Martial Arts
16 
Mecha
28 
Music
17 
Mystery
18 
Parody
Romance
19 
Samurai
20 
School
SciFi
31 
Shoujo
37 
Shoujo Ai
30 
Shounen
38 
Shounen Ai
21 
Space
22 
Sports
23 
Super Power
24 
Vampires
29 
Yaoi
36 
Yuri

Status of anime files

-1 
undefined
unknown
on hdd
on cd
deleted

Wishlist types

unknown / unfiled
to watch
to get
blacklist

Wishlist priority

low
medium
high

Episode states (bits)

Special
Recap
OP/ED/Credits
32 
Trailer
64 
Parody
128 
Others

Episode MyList status

-1 
mixed
unknown
on hdd
on cd
deleted

File state (bits)

CRC ok
CRC invalid
is v2
is v3
16 
is v4
32 
is v5
64 
is uncensored
128 
is censored

MyList file status

unknown
on hdd
on cd
deleted

MyList filestate

normal
invalid crc
self-editer
10 
self-ripped
11 
on dvd
12 
on vhs
13 
on tv
14 
theather
20 
filler ep
100 
other