Analysis of the default Journal.2da

From Djinni Wiki

Contents 1 Headline text 2 Category 3 Picture 4 EntryId 5 CategoryOverride 6 BigPicture 7 SexPicture 8 AlchemyRecipe

[edit] Headline text

The journal is a .2da file, with the following columns:

	Category   	Picture        	EntryId             	CategoryOverride	BigPicture	SexPicture     	AlchemyRecipe
0	Visited    	****           	Q1012_For_sale      	****            	****      	****           	****         
1	Plot       	****           	Q1014_wanted        	****            	****      	****           	****         
2	Visited    	****           	Q1022_redhood       	****            	****      	****           	****         
3	Visited    	****           	Q1005_body          	****            	****      	****           	****         
4	Visited    	****           	Q1005_Isa           	****            	****      	****           	****         
5	Visited    	****           	Q1011_Julio         	****            	****      	****           	****         
6	Plot       	****           	Q2014_coca01        	****            	****      	****           	****         
7	Plot       	****           	Q2014_coca02        	****            	****      	****           	****         
8	Plot       	****           	Q2016_PC            	****            	****      	****           	****         
9	Plot       	****           	Q2016_zygfryd       	****            	****      	****           	****         
10	Hint       	****           	Q2105_h_proof       	****            	****      	****           	****         
11	Hint       	****           	Q2105_h_witns       	****            	****      	****           	****         
12	Hint       	****           	Q2105_h_beren       	****            	****      	****           	****         

The main file has 1127 lines, implying 1126 records (plus the header). As in all .2da files, null is represented as '****'.

Meaning of the columns seems to be as follows

[edit] Category

The category of this article. Values which occur in the official file (there's probably a separate .2da defining these) are:

1. aether
2. alchemy
3. bestiary
4. Bestiary
5. character
6. Character
7. Gameplay
8. Girlfriend
9. Hidden
10. Hint
11. hydragenum
12. Info
13. Picture
14. Place
15. Plot
16. quebrith
17. rebis
18. recipe
19. recipe_bomb
20. recipe_oil
21. tutorial
22. Tutorial
23. unique
24. vermilion
25. Visited
26. vitriol

Note that several appear in both all-lowers and initial-cap, implying the value probably isn't case sensitive.

[edit] Picture

Filenames of .dds (Microsoft DirectDraw Surface) files which are stored in the _textures00 directory within the BIF archive.

[edit] EntryId

A distinct token. I assume this is the file which defines these tokens. I assume these tokens are keys into i18n lookup files, but if so those files are not stored in the _2da00 directory. There are 347 distinct values in this column, of which 115 are not unique. 'jp_g_book' occurs most frequently with 61 occurrences. 392 records have null in this column.

[edit] CategoryOverride

There two blank rows and 1088 null rows in this column. There are only five actual values, as follows:

• 1 Info
• 3 Hidden
• 4 Place
• 12 boss
• 16 character

[edit] BigPicture

Values are null or '1'. All the records which have '1' in this column also have a value in the 'Picture' column, so I assume that '1' in this column means 'the picture is a big picture'.

[edit] SexPicture

There are 24 distinct values in this column, which appear to refer to sex card images. All are unique except 'sp_sex_hooker2' which occurs twice. All appear to be names of .DDS files occurring in the _localized00 subdirectory.

[edit] AlchemyRecipe

There are 50 distinct values in this column, all referring to potions or oils.