summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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-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-24Made field `name` in `char` table unique to prevent 3rd party tools from ↵kenpachi2k112-1/+3
making our data messy. (bugreport:5587) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16490 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-21Follow up r16466 - forgot the move the proper files over after editing them ↵kenpachi2k112-2/+2
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.kenpachi2k112-4/+3
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.jtynne2-3/+8
- 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-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-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-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-28* Standardized and added Shadow Chaser job quest! (bugreport:5834)euphyy2-6/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16350 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-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
2012-06-15Follow up r16253 - Replaced NULL with 0 in mob_db.sql and mob_db_re.sqlkenpachi2k112-2445/+2445
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16304 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-13git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16291 ↵rikimaru171-1/+1
54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-12Added SQL mob skills bugreport:5992flaid1-1/+1200
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16281 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-12Added iRO hats and matk fixes into SQLflaid2-1/+19
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Follow up r16249 - enabled double attack ability for all weapon types in all ↵kenpachi2k111-4/+4
item scripts that enables use of TF_DOUBLE. (bugreport:5935) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16266 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Fixed Concentrated White Potion(Z)s script. (bugreport:5895)kenpachi2k111-2/+2
Fixed Gym Pass Box' script. (bugreport:5976) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16261 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10- Added svn:eol-style=native property on some recently added text files.brianluau1-1594/+1594
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16258 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Follow up r16252 - replaced zeros with NULL and corrected syntax of ↵kenpachi2k112-2445/+2536
commented out entries in SQL mob databases. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16253 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Created renewal mob SQL database file and synchronizes both SQL mob ↵kenpachi2k112-1383/+2568
databases with their corresponding TXT databases. (bugreport:5281) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16252 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed Black Wing, Peuz's and Ur's sets, Scarlet Rose' (#5548) location and ↵kenpachi2k111-14/+14
Ebon Armors (#15014) job code. (bugreport:5895) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16251 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Fixed some Genetic items related to Pharmacy skill. (bugreport:5790)kenpachi2k111-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16250 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-09Follow up r16248 - changed table name for Canon Balls (#18000-#18004) to ↵kenpachi2k112-10/+22
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 ↵kenpachi2k112-9/+11
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-09Fixed Shining Electric Bulb Hairbands (#5310) script. (bugreport:5805)kenpachi2k111-1/+1
Fixed Imperial Guards (#2153) ViewID. (bugreport:5785) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16246 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)kenpachi2k112-2/+2
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-06-01- Replaced more -> rAthena (follow up to r15251).brianluau3-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16195 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-25- Fixed invalid item types in item_db.sqltr0n931-31/+31
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16148 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-24- Fixed a buy/sell zeny exploit (bugreport:5799), follow up to r16138 and ↵brianluau1-1/+1
bugreport:5781. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16141 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-12- Updated town.txt to allow Mailbox access in all the newer cities. ↵masao871-3/+0
bugreport:4457 - Removed easter.txt event and the corresponding mobs in mob_db2.txt and mob_db2.sql since they collide with Satan Morroc minions Mob ID's. bugreport:1240 - Updated Magical Amplify Power cast time to only be affected by item bonuses. bugreport:2777 - Added missing Economy check in agit_main and some missing close; also fixed bugreport:5030 - Added Credits for Ziu in Falcon Flute NPC. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16102 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-11- Added Baby Hunter and Baby Ranger check. bugreport:5728masao871-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16097 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-10- Added Falcon Flute Trader NPC.masao871-0/+1
- Added Falcon Flute to db/pre-re/item_db.txt, db/re/item_db.txt and item_db.sql. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16095 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-05-08Fixed Nydhorgg's Shadow Garbs (2554) bonus script. (bugreport:5648)kenpachi2k112-3/+3
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-04-22* Merged changes up to eAthena 15086.eathenabot2-1/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15926 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-22- Follow-up to r15923: fixed renamed file not being svn-copied (and lacking ↵brianluau1-1/+1
svn history). - Added svn:eol-style=native property for some recently added text files. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15924 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-21- Fixed a SQL error from r15885. (tid:62072)brianluau1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15896 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-20follow up r15885. Renamed upgrade_svn15885_log.sql to upgrade_svn15885.sql ↵shennetsind1-2/+0
and removed a leftover from the original file git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15888 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-20Initial support for Genetic, Sorcerer and Elemental Summons. Special Thanks ↵shennetsind2-0/+50
to 3CeAM for the base. Notice this revision onwards requires you to update your char sql table and add the elemental sql table (check sql-files/upgrade_svn15885_log.sql) If you step by any bugs, let us know at http://rathena.org/board/tracker/ Thank you very much. ARRIBA ARRIBA. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15885 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-10- Follow up to r15084.brianluau1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15841 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-31* Merged changes up to eAthena 15084.eathenabot2-1/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15818 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-22Added GM Sandman Skill (part of bugreport:5172). now available thru angra ↵shennetsind1-1/+1
manyu item. - Causes target player, mob, homunculus or mercenary to enter in endless sleep state until cast again (logoff cancels). - Cannot be cast on self git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15747 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-12Follow up r15679. Changed Hatii Baby to Baby Hatii.kenpachi2k111-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15680 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-12Fixed Garms iRO name. (bugreport:5421)kenpachi2k111-1/+1
Fixed some create_arrow_db.txt comments. (Follow up r15672.) Fixed Sura job change quest. (bugreport:5431) Corrected a NPC location in quests_veins.txt. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15679 54d463be-8e91-2dee-dedb-b68131a5f0ec