diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-04-08 06:08:29 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-04-08 06:08:29 +0000 |
| commit | 4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937 (patch) | |
| tree | f4e4422d5cb25f76dcf4dd3053ee13f057c5cae5 /sql-files/upgrade_svn5951.sql | |
| parent | 2dadd8a880bdea8b94d69d83a1dd8b6569552ada (diff) | |
| download | hercules-4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937.tar.gz hercules-4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937.tar.bz2 hercules-4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937.tar.xz hercules-4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937.zip | |
- Modified the equip_job field in the item_db to be a hexadecimal value for easier handling.
- Updated item_db.sql to this new file format (even though it's equip_jobs field is still a integer)
- Added upgrade_svn5951.sql for those who would like to convert their existing items.
- Added doc/item_db.txt to explain each of the fields in db/item_db.txt
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5951 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn5951.sql')
| -rw-r--r-- | sql-files/upgrade_svn5951.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn5951.sql b/sql-files/upgrade_svn5951.sql new file mode 100644 index 000000000..67e9460f6 --- /dev/null +++ b/sql-files/upgrade_svn5951.sql @@ -0,0 +1,28 @@ +#Delete 2^13 (Peco Knight) +update item_db set equip_jobs = equip_jobs&~0x2000 where equip_jobs&0x2000; +#Move 2^20 -> 2^19 (Dancer -> Bard) +update item_db set equip_jobs = (equip_jobs|0x80000)&~0x100000 where equip_jobs&0x100000; +#Remove 2^21 (Peco Crusader) +update item_db set equip_jobs = equip_jobs&~0x200000 where equip_jobs&0x200000; +#Remove 2^22 (Wedding) +update item_db set equip_jobs = equip_jobs&~0x400000 where equip_jobs&0x400000; +#Remove 2^23 (S. Novice) +update item_db set equip_jobs = equip_jobs&~0x800000 where equip_jobs&0x800000; +#Move 2^24 -> 2^21 (TK) +update item_db set equip_jobs = (equip_jobs|0x200000)&~0x1000000 where equip_jobs&0x1000000; +#Move 2^25 -> 2^22 (SG) +update item_db set equip_jobs = (equip_jobs|0x400000)&~0x2000000 where equip_jobs&0x2000000; +#Move 2^26 -> 2^23 (SL) +update item_db set equip_jobs = (equip_jobs|0x800000)&~0x8000000 where equip_jobs&0x8000000; +#Move 2^28 -> 2^24 (GS) +update item_db set equip_jobs = (equip_jobs|0x1000000)&~0x4000000 where equip_jobs&0x4000000; +#Move 2^27 -> 2^25 (NJ) +update item_db set equip_jobs = (equip_jobs|0x2000000)&~0x10000000 where equip_jobs&0x10000000; +#Make items usable by everyone into 0xFFFFFFFF +update item_db set equip_jobs = 0xFFFFFFFF where equip_jobs = 0x3EFDFFF; +#Make items usable by everyone but novice into 0xFFFFFFFE +update item_db set equip_jobs = 0xFFFFFFFE where equip_jobs = 0x0EFDFFE; +#Update items usable by everyone except acolyte/priest/monk/gunslinger +update item_db set equip_jobs = 0xDFFF7EEF where equip_jobs = 0x28F5EEF; + + |