Sql Value

Hi,

im doing a php page to see whois online and i wanted to add the class of the char but i would need those value.

Plz take note that i dont have server installed or any access to a real database so im doing this for my own pleasure :)

ok under Gamedb, in the table cabal_character_table i think that the column style is for the class and the column rank is for the rank.

i need to know what those number mean. for example under style 25854356 mean warrior ? blader ?

and for rank 2570 mean rank 18, rank 19 ??

hope that some1 have the answer.

Thanks !!!!

Style and Rank are bitflags.

My head's not very clear atm (damn anxiety...), so I'm not sure how well I'd be able to explain Style, so I'm just going to post a snippet of code. It explains how to get the values from a style bitflag (excluding class rank):

Code:

---

var style = BitConverter.ToUInt32(message, 0x0A);
var _class = BitConverter.GetBytes(style)[0];
_class ^= 8;
style >>= 8;
var face = BitConverter.GetBytes(style)[0];
style >>= 8;
var colour = (byte)(face >> 5);
face -= (byte)(colour << 5);
var hair = BitConverter.GetBytes(style)[0];
hair >>= 1;
style >>= 8;
var gender = (BitConverter.GetBytes(style)[0] != 0);

---

I'll post a detailed explanation in the morning...

EDIT: Here's the more detailed explanation:

Quote:

---

BINARY
00000000000000000000000000001000

Class
Face Style
Hair Colour
Hair Style
Gender

---

I can't remember where class rank is. It's probably in there with the Gender bits somewhere. I'd have to look later.



Rank is the skill rank, not class rank. It's arranged like this:

Quote:

---

BINARY
000000000000

Sword Rank Padding Magic Rank

---

eg. If you wanted Sword Rank 5 and Magic Rank 1, you would use:

Quote:

---

BINARY
010100000001

HEX
0501

DECIMAL
1281

---

I hope this makes sense.

ok thanks...problem solved.