As I have never seen a post regarding this and I had a time figuring it out this morning, I figured I would put a little how-to here.
Category Structure (In-Game):
[Only registered and activated users can see links. Click Here To Register...]
As you can see above there are three columns:
Each column is basically a list, the _category_id is the index (position) on that list.
For example:
The image below would have the following ids:
[Only registered and activated users can see links. Click Here To Register...]
While the image below would have the following ids:
[Only registered and activated users can see links. Click Here To Register...]
In the above image all ids = 0 because each category selected is at the beginning of it's list (so the index/position = 0)
However in the image below the ids would be:
[Only registered and activated users can see links. Click Here To Register...]
Because the first (1/3) column is the second entry in that list. Making it's id = 1
Category Structure (Database):
[Only registered and activated users can see links. Click Here To Register...]
You should be familiar with high - low_category_id as explained above, but now I'll explain the rest:
Quick Note: dbo.MixCategoryResource services both 'Combine' and 'Enhance' formula windows, see 'mix_id' also a -1 in a _category_id means there is nothing to be displayed. E.g. 0, 0, -1 would only show first two menu and no third. 0,0,0 would show all three.
id - a unique mixcategory id (just make one that doesn't exist yet, for new formula)
mix_id - defines whether this formula is a 'combine' formula [1] or a 'enhance' formula [0]
local_flag - locks formula to show in specific regions (0,4,etc..etc..)
category_text_id - db_stringresource [code] for string to be displayed as category text
formal_text_id - db_stringresource [code] for string to be displayed as 'ingredients'
result_text_id - db_stringresource [code] for string to be displayed as 'result'
Saving Edits:
As always restart the server, issue a db_string and db_mixcategory update to your client (which must be restarted if already in operation.)
Category Structure (In-Game):
[Only registered and activated users can see links. Click Here To Register...]
As you can see above there are three columns:
- Column 1: high_category_id
- Column 2: middle_category_id
- Column 3: low_category_id
Each column is basically a list, the _category_id is the index (position) on that list.
For example:
The image below would have the following ids:
[Only registered and activated users can see links. Click Here To Register...]
- high_category_id = 0
- middle_category_id = 0
- low_category_id = -1
While the image below would have the following ids:
[Only registered and activated users can see links. Click Here To Register...]
- high_category_id = 0
- middle_category_id = 0
- low_category_id = 0
In the above image all ids = 0 because each category selected is at the beginning of it's list (so the index/position = 0)
However in the image below the ids would be:
[Only registered and activated users can see links. Click Here To Register...]
- high_category_id = 1
- middle_category_id = 0
- low_category_id = 0
Because the first (1/3) column is the second entry in that list. Making it's id = 1
Category Structure (Database):
[Only registered and activated users can see links. Click Here To Register...]
You should be familiar with high - low_category_id as explained above, but now I'll explain the rest:
Quick Note: dbo.MixCategoryResource services both 'Combine' and 'Enhance' formula windows, see 'mix_id' also a -1 in a _category_id means there is nothing to be displayed. E.g. 0, 0, -1 would only show first two menu and no third. 0,0,0 would show all three.
id - a unique mixcategory id (just make one that doesn't exist yet, for new formula)
mix_id - defines whether this formula is a 'combine' formula [1] or a 'enhance' formula [0]
local_flag - locks formula to show in specific regions (0,4,etc..etc..)
category_text_id - db_stringresource [code] for string to be displayed as category text
formal_text_id - db_stringresource [code] for string to be displayed as 'ingredients'
result_text_id - db_stringresource [code] for string to be displayed as 'result'
Saving Edits:
As always restart the server, issue a db_string and db_mixcategory update to your client (which must be restarted if already in operation.)
