Applicable Jobs Help

[_Dynosawr_]

I wanted to know the format for Jobs in the item database;

(From http://rathena.org/wiki/Custom_Items)

• Job: Which jobs this item is available for. Values below can be combined to achieve availability for multiple job classes, i. e. 0x2|0x4 -> 0x6 (Swordman+Mage)
  

(S.) Novice (2^00): 0x00000001

Swordman (2^01): 0x00000002

Mage (2^02): 0x00000004

Archer (2^03): 0x00000008

Acolyte (2^04): 0x00000010

Merchant (2^05): 0x00000020

Thief (2^06): 0x00000040

Knight (2^07): 0x00000080

Priest (2^08): 0x00000100

Wizard (2^09): 0x00000200

Blacksmith (2^10): 0x00000400

Hunter (2^11): 0x00000800

Assassin (2^12): 0x00001000

Unused (2^13): 0x00002000

Crusader (2^14): 0x00004000

Monk (2^15): 0x00008000

Sage (2^16): 0x00010000

Rogue (2^17): 0x00020000

Alchemist (2^18): 0x00040000

Bard/Dancer (2^19): 0x00080000

Unused (2^20): 0x00100000

Taekwon (2^21): 0x00200000

StarGladiator (2^22): 0x00400000

Soul Linker (2^23): 0x00800000

Gunslinger (2^24): 0x01000000

Ninja (2^25): 0x02000000

All Classes : 0xFFFFFFFF

Every Job Except Novice : 0xFFFFFFFE

Are those accurate or is the format different? Because when I looked in my item_db, it says "4294967295" as all jobs.

Edited June 10, 2012 by Joey

[en_dev]

yes thats accurate, when it queries in database, the 0xFFFFFFFF is converted to decimal. vice versa,

[Brian]

Yes, these are accurate.

0xFFFFFFFF (in hex) is equal to 4294967295 (in decimal).

In the /db/ files and in the SQL files, they are written as hexadecimal numbers because it's easier to see the on/off bits.

[_Dynosawr_]

Ah okay, thanks alot guys! ^^

[LCDTheOG]

somone should update these decimals into the wiki for sql =o

[_Dynosawr_]

What are the decimals anyways? o.o *has no idea and needs to find out*

Edit: I figured them out, nevermind.

Edited June 10, 2012 by Joey

[Brian]

somone should update these decimals into the wiki for sql =o

like list the hexadecimal numbers and their decimal equivalents next to each other? Custom_Items#Structure

(S.) Novice         (2^00): 0x00000001
Swordman            (2^01): 0x00000002
Mage                (2^02): 0x00000004
Archer              (2^03): 0x00000008
Acolyte             (2^04): 0x00000010
Merchant            (2^05): 0x00000020
Thief               (2^06): 0x00000040
Knight              (2^07): 0x00000080
Priest              (2^08): 0x00000100
Wizard              (2^09): 0x00000200
Blacksmith          (2^10): 0x00000400
Hunter              (2^11): 0x00000800
Assassin            (2^12): 0x00001000
Unused              (2^13): 0x00002000
Crusader            (2^14): 0x00004000
Monk                (2^15): 0x00008000
Sage                (2^16): 0x00010000
Rogue               (2^17): 0x00020000
Alchemist           (2^18): 0x00040000
Bard/Dancer         (2^19): 0x00080000
Unused              (2^20): 0x00100000
Taekwon             (2^21): 0x00200000
StarGladiator       (2^22): 0x00400000
Soul Linker         (2^23): 0x00800000
Gunslinger          (2^24): 0x01000000
Ninja               (2^25): 0x02000000
All Classes               : 0xFFFFFFFF
Every Job Except Novice   : 0xFFFFFFFE