From 4f23ac6a3862cbf1b1cbd8bea240c9fdf9290937 Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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

