summaryrefslogtreecommitdiff
path: root/sql-files/item_db_re.sql
AgeCommit message (Collapse)AuthorFilesLines
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-53/+53
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-20Updated all items which had groupranditem with getrandgroupitem (better ↵momacabu1-44/+44
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-25Fixed bCastrate function in item_combo_db. bugreport:6815spre1231-1/+1
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-24Fixed/Changed the rest of the RE Items with the reversed/broken bcastrate ↵spre1231-51/+51
with bVariableCastrate So it actually works as intended(ONLY RE needed this update). bugreport:6548 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16826 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-21* Updated Thanatos Tower quest to Episode 13.1 - huge thanks to Muad_Dib! ↵euphyy1-3/+3
(bugreport:4498) * Fixed some syntax in item_db_re.sql (bugreport:6714) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16823 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-20major item update activating many script commands aswell as activating many ↵spre1231-300/+300
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-29Updated bonus2 bCastrate items. Cast reducing equipment should now function ↵spre1231-12/+12
properly. Bugreport:6745 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16808 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-26...I am tired I suppose, Forgot to add the item_db_re.sql in with the Last ↵spre1231-1/+1
revision Update. So Follow up on 16798 and Bugreport:6734 [Spre] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16799 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-22* Fixed applicable job on Ebone Armor (bugreport:6705)euphyy1-1/+1
* Follow-up r16790 / r16791, formatting and strncmp -> strcmp (src\map\atcommand.c) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16792 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-10* Optimized Splendide coin merchant and merged it to a template with Manuk's ↵euphyy1-1/+1
(merchants\coin_exchange.txt) * Fixed and enabled a Manuk NPC (cities\manuk.txt) * Other small changes and fixes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16773 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-09* Added and updated duplicate coordinates in custom Healer (custom\healer.txt)euphyy1-1/+1
* Follow-up r16765, forgot a bonus (bugreport:6646) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16767 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-08* Updated Renewal 'Mjolnir' item (bugreport:6646)euphyy1-4/+4
* 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-22Fixed Ur's Seals (#2883) bonus script. (bugreport:5895)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16684 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-21Sleipnir fix in renewal bugreport:6524flaid1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16674 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-20Updated all glorious weapons. (bugreport:5013)kenpachi2k111-26/+26
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16673 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-20Updated some EP 13.2 accessories. (bugreport:5128)kenpachi2k111-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16670 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-17Renamed bMatk and bWeaponMatk to make it easier to understand the bonus when ↵kenpachi2k111-14/+14
reading the DB file. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16649 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-16Follow up r16641 - updated table layout for item_db_re. (bugreport:6478)kenpachi2k111-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16645 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-15Follow up r16641 - Updated Ahura Mazdahs DEF and Angra Manyus ATK/MATK ↵kenpachi2k111-2/+2
again. (Found a newer file...) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16642 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-15Fixed Angra Manyus and Ahura Mazdah script and ATK/MATK/DEF. Additionally ↵kenpachi2k111-2/+2
corrected some descriptions in item_bonus.txt. (bugreport:5172) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16641 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-15Added support for the new min and max equip level in the SQL item database. ↵kenpachi2k111-1892/+1892
(Follow up r16632) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16639 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-364/+7281
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-7281/+364
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-364/+7281
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16513 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-24Renamed leftovers REMODE to RENEWAL in documentation.xazax-hun1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16493 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-1/+1
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-0/+5
- 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-06* Added missing pre-re item database entries (bugreport:6177)euphyy1-3/+3
* Fixed a couple wrong SQL item database entries (bugreport:6133) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16379 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-01* Fixed Elemental Sword database entry, bugreport:6134euphyy1-1/+2
* Clarified documentation for "doevent" and "donpcevent", as per bugreport:428 (doc\script_commands.txt) * A major cleanup/rewrite of the "Whisper System" documentation (doc\whisper_sys.txt) * A few other minor documentation corrections git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16358 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-19Fixed bugreport:6063 in the thana_quest ,because it was giving the wrong exp ↵rikimaru171-0/+3
amount and fixed bugreport:6064 ,where Bone Plate was giving a wrong def amount git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16320 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-12Added iRO hats and matk fixes into SQLflaid1-0/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Follow up r16248 - changed table name for Canon Balls (#18000-#18004) to ↵kenpachi2k111-6/+18
item_db_re. Added some books to the renewal database because of their MATK changes. (bugreport:5921) Changed bonus bDoubleRate to skill "TF_DOUBLE" because bonus bDoubleRate isn't enough and the official script explicitly states that the skill should be given. (bugreport:5935) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16249 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Follow up r16245 and r16247 - changed table name for Megingjard (#2629) and ↵kenpachi2k111-2/+10
Tao Gunka Card (#4302) to `item_db_re`. Fixed job code for Bone Plate (#15000). (bugreport:5816) Added Wizardry Staff (#1473) to renewal SQL database. (bugreport:5904) Moved Cannon Balls (#18000-#18004) from pre-renewal to renewal database and changed their weigth to 1. (SQL DB only) (bugreport:5907) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16248 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Moved a few merchants and mob spawns to separate files to prevent error ↵kenpachi2k111-1/+4
message when running server in pre-RE mode and with TXT databases. (bugreport:5846) Fixed Tao Gunka Cards (#4302) renewal effect. (bugreport:5866) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16247 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Updated MATK of several Staff weapons in renewal databases. (bugreport:5646)kenpachi2k111-0/+50
Updated Megingjards (#2629) renewal bonus script. (bugreport:5694) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16245 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed Barricades (#1905) HP in pre-renewal database. (bugreport:5423)kenpachi2k111-1/+1
Changed Poison Bottles (#678) script to use SC_ASPDPOTION3 instead of SC_ASPDPOTION2. (bugreport:1996) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16244 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-08Fixed Nydhorgg's Shadow Garbs (2554) bonus script. (bugreport:5648)kenpachi2k111-1/+1
Fixed bonus3 bSPDrainRate documentation. (bugreport:5648) Fixed Tao Gunka Cards bonus script.(bugreport:5711) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16087 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-10Fixed Poison Bottles (ID:678) script. (bugreport:5246)kenpachi2k111-0/+6
Added Bradium Golem to mob_race2_db.txt (bugreport:5257) Fixed Pile Bunkers (ID:1549) job requirements. (bugreport:5394) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15669 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19Follow up r15619: Added missing apostrophes in ATK field in item_db_re.sql. ↵kenpachi2k111-1/+1
(Glorious Arc Wand) Removed left over refine_db.txt in /db/ folder. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15623 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19Fixed Refined Quadrilles bonus script. (bugreport:4835)kenpachi2k111-0/+1
Fixed Glorious Arc Wands MATK values and added its entry to item_db_re.sql. (bugreport:4708) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15619 54d463be-8e91-2dee-dedb-b68131a5f0ec