Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 15:10

  • Please register to post and access all features, it's quick, easy and FREE!

 

[HOW-TO] Work with MixCategoryResource

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
[HOW-TO] Work with MixCategoryResource

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):

You must register and activate your account in order to view images.

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:

You must register and activate your account in order to view images.
  • high_category_id = 0
  • middle_category_id = 0
  • low_category_id = -1

While the image below would have the following ids:

You must register and activate your account in order to view images.
  • 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:

You must register and activate your account in order to view images.
  • 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):

You must register and activate your account in order to view images.

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.)



ismokedrow is offline  
Thanks
7 Users
Old   #2
 
elite*gold: 0
Join Date: Oct 2013
Posts: 382
Received Thanks: 25
thanks


Sherock is offline  
Old   #3
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
LOL just noticed someone gave this a bad rating. Go figure, trololololo
ismokedrow is offline  
Old   #4
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 961
Quote:
Originally Posted by ismokedrow View Post
LOL just noticed someone gave this a bad rating. Go figure, trololololo
The ingrates.
ThunderNikk is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 15:10.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.