summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
AgeCommit message (Collapse)AuthorFilesLines
2015-07-08ItemDB SQL SyncHercules.ws1-6140/+6140
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-07-08Update Unique ID system to match official now it cover all cash items ↵Ibrahim Hossam1-0/+1
include stackable ones. Implement ForceSerial option in Package Item Database to force serial for any item. Implement ForceSerial option in item database to force serial for any item. Implement Merge Client interface to merge stackable items with serial numbers ( check npc/other/item_merge.txt ).
2015-06-25ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-24ItemDB SQL SyncHercules.ws1-8/+8
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-06-12ItemDB SQL SyncHercules.ws1-160/+160
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-04-26ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-01-25ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-07ItemDB SQL SyncHercules.ws1-3/+6
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-11/+11
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-29ItemDB SQL SyncHercules.ws1-17/+17
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31ItemDB SQL SyncHercules.ws1-6135/+6144
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31ItemDB SQL SyncHercules.ws1-28/+33
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-30ItemDB SQL SyncHercules.ws1-317/+317
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-18ItemDB SQL SyncHercules.ws1-9/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-17ItemDB SQL SyncHercules.ws1-317/+317
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-25ItemDB SQL SyncHercules.ws1-6135/+6135
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-6135/+6136
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-6177/+6161
Signed-off-by: Haru <haru@dotalux.com>
2013-10-24Added 4 missing items to pre-re which the quest db update relies uponshennetsind1-29/+33
Follow up 418dd821c91ae19723a7b7b531e64b9c4565d555 Thanks to ossi0110 Signed-off-by: shennetsind <ind@henn.et>
2013-10-24Updated Item_db sql files to match latest .txt versionshennetsind1-457/+457
Includes the skill name constant update e3d71d9455de45d5a9417dbebd74aa49a0e7ae6a Signed-off-by: shennetsind <ind@henn.et>
2013-10-24item_db.sql update to match .txtshennetsind1-13/+12
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-22Fixed Bug #7506shennetsind1-4/+4
Given the class is accessible under pre-re mode, its skills that rely on these catalysts are unable to function since the items they require do not exist. Adding them. http://hercules.ws/board/tracker/issue-7506-skill-items-missing-in-pre-re/ Signed-off-by: shennetsind <ind@henn.et>
2013-08-22Fixed Bug #7354shennetsind1-11/+12
Given mounting support is present in pre-re I'm adding the item to squash the warning away, the problem by having item_delay being shared by pre-re and re will be sorted in a upcoming update. http://hercules.ws/board/tracker/issue-7354-item-delaytxt/ Signed-off-by: shennetsind <ind@henn.et>
2013-08-22Pre-re SQL item db updateshennetsind1-95/+94
Thanks to Haruna, Closes #88 Signed-off-by: shennetsind <ind@henn.et>
2013-06-24Fixed db2sqlshennetsind1-92/+93
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-79/+79
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-86/+86
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-6573/+6168
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-1/+1
- 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-11* Initial implementation of Archangel Wing Enchants script.euphyy1-3/+3
* 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-02-04Merged some commits from rAthena.Matheus Macabu1-1/+1
2012-11-29Fixed bugreport:5689 recoded/reimplement RE Matk formula(including RE Heal)rud0lp201-8/+8
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
2012-11-25* Added the "Catalog Magician" NPC to merchants/buying_shops.txt, thanks to ↵euphyy1-5/+5
Muad_Dib! * Changed all commands in atcommands.txt to their defined names, not aliases, and added two more common aliases. * Documented 'makerune' in script_commands.txt. * Documented '@accinfo' in atcommands.txt. * Follow-up r16965, database update for rune crafting formula. * Updated Magic Mushroom DB according to 3CeAM revision 703. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16966 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-23* Removed duplicate isequipped() entries from item_db already written in ↵euphyy1-44/+44
item_combo_db (bugreport:6924). * Moved a few remaining isequipped() entries to item_combo_db. * Follow-up r16940: applied change to SQL and pre-re files, and renamed Size constants to Size_ for consistency. * Follow-up r16947: fixed mob modes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16955 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-21Replaced 'bonus2 bVariableCastrate' with 'bonus2 bCastrate' in pre-renewal ↵kenpachi2k111-11/+11
item databases. (bugreport:6913) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16938 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-20Updated all items which had groupranditem with getrandgroupitem (better ↵momacabu1-38/+38
implementation done by Ind) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16932 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-09Shiny Wing Gown was set to tame the wrong monster, fixed now.flaid1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16886 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-09- Removed backup.pl (for TXT servers) and vs9-to-vs8.php (outdated versions);momacabu1-1/+1
- Merged @killmonster2 with @killmonster tid:73632; - Fixed bugreport:6764, auction code was misplaced; - Follow up to r16753 (bugreport:6523), fixed bugreport:6673, using Gravitational Field with Safety Wall would keep the character immobilized. Blame myself, thankyou Lunar for the fix; - Fixed bugreport:6514, @slaveclone wouldn't be targeted by monster. Thanks to zippy; - Fixed bugreport:6837, some code was duplicated; - Fixed bugreport:6768, removed some leftovers from TXT removal; - Fixed bugreport:6868, Unequipping a weapon with Incantation Samurai card will not kill you if you have less than 999 hp and are on a non-pvp map; - Fixed wrong bit field on ai field in mob_data structure. Credits to Ind. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16881 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-27- Fixed more missing single quotes in item_db.sql, follow up to r16822.brianluau1-9/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16831 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-27- Fixed missing single quotes in item_db.sql, follow up to r16822.brianluau1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16830 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-25Fixed bCastrate function in item_combo_db. bugreport:6815spre1231-4/+4
Fixed Item 13694, Freyas Crown Box Changed getitem to the official rentitem Item Script(verified By Joseph and muad). Continuation of bugreport:6714 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16828 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-20major item update activating many script commands aswell as activating many ↵spre1231-193/+193
items that are now in the client this effects 250+ items. Bugreport:6714 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16822 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-26Updated Items, Uncommented the Traditional Cookie as it works fine and is ↵spre1231-1/+1
needed for a pet. Also updated The Groomers That sell it. Bugreport:6734 [Spre] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16798 54d463be-8e91-2dee-dedb-b68131a5f0ec