summaryrefslogtreecommitdiff
path: root/sql-files/item_db_re.sql
AgeCommit message (Collapse)AuthorFilesLines
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>
2013-06-23Official Item Group/Package/Chainshennetsind1-124/+144
http://hercules.ws/board/topic/1244-official-item-grouppackagechain/ Also Further implemented itemdb.c/storage.c interfaces, and a minor update to db2sql plugin. Signed-off-by: shennetsind <ind@henn.et>
2013-06-14Updating .sql item db filesshennetsind1-7541/+7791
Also Introducing the official DB2SQL plugin to quickly update the .sql db files. http://hercules.ws/board/topic/1105-hercules-wpe-free-june-14th-patch Signed-off-by: shennetsind <ind@henn.et>
2013-04-29Fixed bug report #6396Kenpachi1-4/+4
- Updated bonus scripts of Chemical Protection scrolls to ensure that skill requirements are fulfilled. http://hercules.ws/board/tracker/issue-6396-chemical-protection/
2013-04-29Fixed bug report #7202Kenpachi1-1/+1
- Updated bonus order of 12218 to enable correct showing of skill effects. http://hercules.ws/board/tracker/issue-7202-assumptio-effect-on-scrolls/
2013-04-29Fixed bug report #7156Kenpachi1-9/+9
- Removed double entries for item 6441 and 6442 and updated their names according to fRO database. (http://rns.gamona.de/index.php?show=viewitem&itemid=6441, http://rns.gamona.de/index.php?show=viewitem&itemid=6442) - Updated name of 12416 in all 4 item database files. (LUcky -> Lucky) - Updated order of 19533 and 19534 in /db/re/item_db.txt. - Updated AegisName of 4853-4858. http://hercules.ws/board/tracker/issue-7156-double-items/
2013-04-11Fixed missing apostropheshennetsind1-1/+1
all credits to the awesome jTynne :3 thank you! Signed-off-by: shennetsind <ind@henn.et>
2013-04-11* Added remaining Malangdo coin traders.euphyy1-36/+54
* Renewal item database update: -- Implemented nearly all remaining Malangdo items. -- Added Upg_* boxes (follow-up r17180). -- Corrected many kRO names. * Updated Renewal item_trade database for Dewata, Malangdo, and Upg_* boxes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17186 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11* Initial implementation of Archangel Wing Enchants script.euphyy1-23/+23
* Added some Malangdo coin exchange NPCs, more will come later. * Updated Malangdo warp portals. * Fixed item ID 12220 and clarified documentation of 'getiteminfo' types 11 and 14 (bugreport:7256). * Minor Renewal item database update. * Applied changes from r17171 to SQL databases. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17172 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11* Renewal item updates, mostly misc items (incl. bugreport:7167).euphyy1-64/+87
* A couple of quest_db updates. * Moved El Dicastes Guide to a separate file and fixed viewpoint syntax. * Fixed bugreport:7238, two mob skill mode changes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17122 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-14-Updated DB, Credits to Euphy & LemongrassStreusel1-0/+2
-Added coin_exchange.txt Credits to EUphy & Lemongrass
2013-03-10-Vellum's aegis name is Velum, display name is VellumStreusel1-17/+17
2013-03-09-Added Upg items, Credits to EuphyStreusel1-26/+37
-Renamed Bellum items to Vellum -Updated sql file according to above listed changes
2013-03-06Updated dewata to match the official scripts.lemongrass31101-29/+114
This commit includes a optional SQL upgrade file, that will reset all the dewata quests and the related variables, that your users have done. Thanks to Euphy for helping me and additionally thanks to Flaid for taking his time to test our conversion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17178 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-06-Updated EXP tableStreusel1-8/+21
-Updated healing items & costume items -Updates item_db_re.sql for last commits healing item update, Credits to Euphy
2013-03-05-Added Malangdo Enchantments, credits to EuphyStreusel1-0/+1
-Fixed Guillotine Cross job change, credits to Euphy -Updated message display of Malangdo NPC's, credits to Euphy -Updated item_db_re.sql
2013-03-05* Updated Endless Tower instance to latest official script.euphyy1-1/+32
-- String "Floor" changed to "Level". -- Warp portals open after a 5 second delay. * Renewal item database fixes (bugreport:7301, bugreport:7308). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17165 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-05- Fixed amount of item slots on orbs and assassin's glove thanks to letskay ↵playtester1-5/+5
(bugreport:7309 and bugreport:7312) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17164 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-02-25* Part one of fixing bugreport:6527. This does not yet change functionality.euphyy1-2/+2
-- Added 'disable_items' to all applicable scripts. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17160 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-02-04Merged some commits from rAthena.Matheus Macabu1-1/+1
2013-02-03Merged rAthena r17103Mysteries1-78/+113
Added and updated many Renewal item scripts (incl. bugreport:7162, bugreport:7147). Some formatting changes in Clothes Dyer script (incl. bugreport:7204).
2012-12-30* Added Somotology Laboratory F4 quest (written by Ziu, translated by Heris, ↵euphyy1-0/+2
uses some iRO dialogues). * Updated quest_db with Somotology Laboratory F4 entries (5113-5125 are placeholders, may be incorrect). * Moving of warp files, reducing the number of duplicates in pre-re/re paths. * Added a note to documentation (bugreport:7065) and fixed a small mistake (bugreport:7068). * Follow-up r17056, missing $ (bugreport:7067) and added a missing item. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17063 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-29* Added more Malangdo scripts.euphyy1-4/+6
* Updated quest_db with more translated Malangdo entries. * Added and updated some newer items. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17060 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-17- Fixed bugreport:7001, Nidhoggur Shadow Card: checks for High Wizard and ↵j-tkay1-1/+1
Warlock jobs. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17027 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-29Fixed bugreport:5689 recoded/reimplement RE Matk formula(including RE Heal)rud0lp201-32/+32
Fixed bugreport:5745 WL_RECOGNIZED us now functional. Fixed bugreport:5663 where HW_MAGICPOWER shows glitch in status window. Fixed bugreport:6759 where items granting matk bonus didn't work. Follow up r16980 small performance enhancement...:) Done some TODO in skill_cast_db.txt git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16981 54d463be-8e91-2dee-dedb-b68131a5f0ec