summaryrefslogtreecommitdiff
path: root/sql-files/item_db_re.sql
AgeCommit message (Collapse)AuthorFilesLines
2015-01-22Removed name distinction between (sql) mob/item/mob_skill db and db_re variantsHaru1-8343/+8343
- Since there (currently and in future) is no difference between the table structure for renewal and pre-renewal databases, it makes no sense to have extra code that makes a distinction between their names. A server will always use either one or the other, never both at the same time. - If you have a mob_db_re, mob_skill_db_re and/or item_db_re table, please rename it to mob_db, mob_skill_db and/or item_db_re, respectively. - No upgrade script provided. I'd like to remind everyone that these tables are optional (and deprecated), and they are only offered for convenience for those who need them for web control panels and similar software. Signed-off-by: Haru <haru@dotalux.com>
2015-01-10ItemDB SQL SyncHercules.ws1-1/+10
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-12-07ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-07ItemDB SQL SyncHercules.ws1-3/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-04ItemDB SQL SyncHercules.ws1-0/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-03ItemDB SQL SyncHercules.ws1-2/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-02ItemDB SQL SyncHercules.ws1-77/+77
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-10-30ItemDB SQL SyncHercules.ws1-1/+18
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-10-30ItemDB SQL SyncHercules.ws1-3/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-10-24ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-09-20ItemDB SQL SyncHercules.ws1-17/+17
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-09-04ItemDB SQL SyncHercules.ws1-34/+34
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-31ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-29ItemDB SQL SyncHercules.ws1-17/+17
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-08ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-08ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-07ItemDB SQL SyncHercules.ws1-9/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-06ItemDB SQL SyncHercules.ws1-9/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-26ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-26ItemDB SQL SyncHercules.ws1-57/+57
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-18ItemDB SQL SyncHercules.ws1-11/+11
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31ItemDB SQL SyncHercules.ws1-8310/+8319
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31ItemDB SQL SyncHercules.ws1-28/+33
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-17ItemDB SQL SyncHercules.ws1-1394/+1538
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-13ItemDB SQL SyncHercules.ws1-1651/+1507
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-08ItemDB SQL SyncHercules.ws1-3320/+3464
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-04-25ItemDB SQL SyncHercules.ws1-2138/+2192
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-04-19ItemDB SQL SyncHercules.ws1-10/+10
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-01-16ItemDB SQL SyncHercules.ws1-0/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-30ItemDB SQL SyncHercules.ws1-362/+362
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-18ItemDB SQL SyncHercules.ws1-10/+10
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-17ItemDB SQL SyncHercules.ws1-362/+362
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-28ItemDB SQL SyncHercules.ws1-60/+60
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-25ItemDB SQL SyncHercules.ws1-8099/+8099
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-18ItemDB SQL SyncHercules.ws1-11/+11
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-18ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-15Official Item BindOnEquip Supportshennetsind1-8110/+8111
Implements the 'BindOnEquip' item db field which determines whether the piece of equipment should bind to the character upon being equipped. When a character tries to equip such a item for the first time a dialog shows up asking the character to confirm whether to equip the item or not, and notifying the character that by equipping the item it will become bound to the character, and therefore unable to be used by another character. Special Thanks to Beret for all the information, Haruna for testing. Signed-off-by: shennetsind <ind@henn.et>
2013-11-15Re-generated SQL item databases with the updated db2sql pluginHaru1-8159/+8134
Signed-off-by: Haru <haru@dotalux.com>
2013-10-24Updated Item_db sql files to match latest .txt versionshennetsind1-581/+581
Includes the skill name constant update e3d71d9455de45d5a9417dbebd74aa49a0e7ae6a Signed-off-by: shennetsind <ind@henn.et>
2013-10-24item_db.sql update to match .txtshennetsind1-22/+22
Thanks to ossi0110 for bringing it up. We will soon make this automatic like the hooking cache ( e.g. 491892212d338903179909b89a5bfc2385e52261 ) so that .sql dbs will always be up to date with the txt counterparts. Signed-off-by: shennetsind <ind@henn.et>
2013-09-16Corrected line endings and BOM issues with several filesHaru1-1/+1
- Ensured final end-of-line character in every file. - Corrected cases of mixed line endings (mostly CR and CRLF within the same file.) - Removed extra BOM from some scripts, since it causes a parsing error. Signed-off-by: Haru <haru@dotalux.com>
2013-08-04Fixed Bug #7610shennetsind1-567/+599
renewal item db price column fix. Special Thanks to Muad_Dib for pinpointing the source of the problem and providing a solution, and also providing us with data for 32 new items (some are new headgears :P) http://hercules.ws/board/tracker/issue-7610-wrong-price-for-iron-ore/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-31Fixed Cash Items Upper valuesshennetsind1-1224/+1224
Issue existed in renewal mode only; Special Thanks to Jezu for bringing it up. Signed-off-by: shennetsind <ind@henn.et>
2013-07-31Fixed Bug #7586Mysteries1-12/+12
Added bonuses for items: - 2917 - 2918 - 2919 - 2920 - 2921 - 2922 - 2923 - 2924 - 2925 - 2926 - 2927 - 2928
2013-07-29Follow up 1caae981b4f000b67bdd0b118fb76797c2bfa06cshennetsind1-2774/+2783
Applying the missed 'upper' flag updates. http://hercules.ws/board/topic/1778-ultimate-item-db-update/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-29Follow up 1caae981b4f000b67bdd0b118fb76797c2bfa06cshennetsind1-628/+640
Prioritising kRO-item-data above others whenever possible, Special Thanks to Yommy for the data and Haru for help on validating the output. http://hercules.ws/board/topic/1778-ultimate-item-db-update/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-29Ultimate Item DB Updateshennetsind1-4384/+4597
http://hercules.ws/board/topic/1778-ultimate-item-db-update/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-11Fix for Bug #7507shennetsind1-51/+133
Merged from rAthena, there is no commit to refer to as I've obtained the missing entries from their latest file. Special Thanks to jTynne http://hercules.ws/board/tracker/issue-7507-items-missing-from-item-d/ Signed-off-by: shennetsind <ind@henn.et>
2013-06-24Fixed db2sqlshennetsind1-113/+113
Wasn't taking in account the delay_consume flag which actually means the item type is 11 not 2. Also added a extra warning in the item packages parser. Special Thanks to ossi0110 for bringing this up. Signed-off-by: shennetsind <ind@henn.et>
2013-06-24Follow up fcba8a2161a392369db99ab9a516a24470c54796shennetsind1-150/+150
Fixed "random" item package rates, special thanks to Beret. Also, added the missing (+130) item package calls (special thanks to Streusel!) Signed-off-by: shennetsind <ind@henn.et>
generated by cgit v1.2.3-70-g09d2 (git 2.46.0) at 2024-10-14 08:14:12 +0000