summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
AgeCommit message (Collapse)AuthorFilesLines
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
2012-09-08* Updated Renewal 'Mjolnir' item (bugreport:6646)euphyy1-3/+3
* Updated slots on RWC 2008 Dragon Helms (bugreport:6645) * Other minor changes... git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16765 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-22Fixed Angelic Rings (#2743) autobonus duration. (bugreport:6434)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16686 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-20Updated all glorious weapons. (bugreport:5013)kenpachi2k111-9/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16673 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-17Renamed bMatk and bWeaponMatk to make it easier to understand the bonus when ↵kenpachi2k111-9/+9
reading the DB file. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16649 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-13* Fixed cutin errors in Fortune script, bugreport:6466 (other\fortune.txt)euphyy1-1/+1
* Fixed item #5503, bugreport:6440 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-04* Added missing quotes around some skill names in item DB, thanks Kenpachi! ↵euphyy1-7/+7
(bugreport:6405) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16577 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28Follow up r16523 - Interchanged attack and atk:matk in pre-RE and RE item DB ↵kenpachi2k111-1/+1
creation script. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16524 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28Updated SQL item DBs to match with their TXT versions. (Now tested...)kenpachi2k111-3956/+3228
Follow up r16520 - applied mob DB changes to the DBs, too. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16523 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27Reverted item_db.sql and item_db_re.sql to r16512. (bugreport:6349)kenpachi2k111-3227/+3955
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16517 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27Follow up r16513 - My converter had one more bug where not all quotes were ↵kenpachi2k111-3/+3
escaped properly. More shame on me. :( git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16516 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27Follow up r16513 - My converter had a bug where comments where includded ↵kenpachi2k111-3/+3
into the OnUnequipScript. Shame on me. :( git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16514 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27Synced SQL DBs and added RE SQL-script for mob_skill_db.kenpachi2k111-3956/+3228
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16513 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-25Fixed some BRO Package item scripts. (bugreport:6319)kenpachi2k111-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16498 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-25Follow up r16494 - added bonus script to the SQL version of item #12311.kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16497 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21Follow up r16466 - forgot the move the proper files over after editing them ↵kenpachi2k111-1/+1
again. Sorry! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16467 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21Renamed bUseSPrateSkill to bSkillUseSPrate.kenpachi2k111-3/+2
Added bSkillUseSP. Added documentation for bSkillUseSPrate(bUseSPrateSkill), bSkillUseSP, bSkillCooldown, bSkillFixedCast, bSkillVariableCast, bSkillFixedCast and bVariableCastrate. (bugreport:6193) Fixed Enriched White PotionZs (#12428) and Enrich Celermine Juices (#12437) bonus script. (bugreport:5790) Fixed Mental Sticks (#1654) bonus script. (bugreport:6071) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16466 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21- Added proper scripts to Imp, Sleeper, Gryphon Hats.jtynne1-3/+3
- Fixed minor grammatical error in Sleeper Hat name. - Added proper RE bonus to Bradium Ring script. - Uncommented proper RE MATK bonus on Entweihen, Scaraba, Banshee Master, and Centipede Larva Cards. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16464 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-20* Optimized "Magic Books" quest, 60% size reduction ↵euphyy1-1/+1
(npc\re\quests\magic_books.txt) * Follow-up r16449, added missing SQL entry for bugreport:6132 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16455 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-20Added new status bonuses: SC_INCMHP and SC_INCMSP to increase maximum HP and ↵cookiecrumbs1-3/+3
SP by a FIXED amount. Fixed the following items in the /db/*re/item_db.txt and /sql-files/item_db.sql: Increase HP Potion (Small), Increase HP Potion (Medium), Increase HP Potion (Large). bugreport:5790 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16454 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-02* Neuralizer is no longer consumed upon failure (bugreport:6040)euphyy1-1/+1
* Some cleaning of the Sorcerer job change quest (jobs\3-2\sorcerer.txt) * Cleaning of "Bunny Band Quest" script (quests\bunnyband.txt) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16367 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-16Fixed a wrong SQL stat script.flaid1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16310 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-15item_db stat optimization and fix bugreport:6001flaid1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16307 54d463be-8e91-2dee-dedb-b68131a5f0ec