From 4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937 Mon Sep 17 00:00:00 2001 From: skotlex Date: Sat, 8 Apr 2006 06:08:29 +0000 Subject: - 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 --- sql-files/upgrade_svn5951.sql | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 sql-files/upgrade_svn5951.sql (limited to 'sql-files/upgrade_svn5951.sql') 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; + + -- cgit v1.2.3-70-g09d2