summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
2012-03-10Fixed Poison Bottles (ID:678) script. (bugreport:5246)kenpachi2k112-1/+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-03-07Enabled some headgears. (Follow up r15662.)kenpachi2k111-48/+48
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15664 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-06Enabled some headgears. (Inspired by bugreport:1849)kenpachi2k111-65/+65
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15662 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-24- Clarified the comment about spaces in 'server_name' config. (bugreport:2656)brianluau2-0/+2
- Grouped all the log file/table settings together, follow up to r15253 (ea:15042). - Added "DROP TABLE" statements to the mob_skill_db SQL files. (bugreport:5284) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15629 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)kenpachi2k112-2/+3
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
2012-02-19Fixed Bradium Golems (2049) mode. (bugreport:4476)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15614 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19Updated Guillotines (1369) bonus script. (bugreport:4904)kenpachi2k111-2/+2
Updated Hyuke's Black Cat Ears' (5360) bonus script. (bugreport:5055) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15611 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-17Corrected two mercenary names. (bugreport:4976)kenpachi2k111-4/+4
Updated Chemical Protection Scrolls bonus script. (bugreport:4944) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15605 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-17Updated Shadow Walks (2426) bonus script. (bugreport:4893)kenpachi2k111-3/+3
Added cash shop version of Wasteland Outlaw (13109) and updated Western Outlaw Box' rentitem script. (bugreport:4840) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15604 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-17Updated Guarana Candys (12414) bonus script. (bugreport:5338)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15601 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-13Follow up to r15572: renamed column `level` to `group_id` (`login` table) in ↵kenpachi2k111-1/+1
/sql-files/main.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15575 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-13 - Added `libconfig` (configuration file library: ↵gepard19841-0/+3
http://www.hyperrealm.com/libconfig/): - Updated VS9/10 project files. - Updated `configure` & `Makefile`s. - New GM, Commands & Permissions system: - '''This is a backwards compatibility breaking update''', please read tid:58877 - Replaced GM levels with Player Groups. - Commands permissions & other privileges now depend on group, not GM level. - `@help` command improvements: requires "commandname" param and shows more detailed info about commands. - Modified GM whisper system to deliver messages basing on permissions, not GM level. - Remote trade request is now possible only if player is allowed to use `@trade` command as well. - Added a proper permission to use `/changemaptype` command. - `clif_displaymessage` is now capable of displaying multiline messages. - All `ACMD_FUNC`s are static now, and the only way to invoke them is with `is_atcommand()`; all client commands (starting with `/`) are now translated into corresponding atcommands (with exception of `/kick` used on monster, as there is no atcommand to kill single monster). - Removed nonsense "bot check" triggering when player blocked (`/ex`) Server. - Merged `@monster`, `@monsterbig` and `@monstersmall`. - Improved flow of atcommand execution to avoid revealing info about online players or existing commands to non-privileged players. - Merged `atcommand` and `charcommand` script functions (`charcommand` is aliased to `atcommand`). - Fixed `atcommand` script function reading unknown memory area (possible access violation). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15572 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-12Removed remaining Fire Ivy database entries. (bugreport:5306)kenpachi2k111-4/+0
Removed some double entries from item DB. Added lost of entries to item_trade.txt and cleand it a little. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15571 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-07Updated some monster slaves. (bugreport:4689)kenpachi2k111-8/+10
Added description for monster spawn event in monster() script command. (bugreport:5251) Removed some items from db/item_trade.txt. (bugreport:5301) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15545 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-06Follow up [rev=15252]: Updated comments in sql-files/logs.sql according to ↵kenpachi2k111-8/+8
conf/inter_athena.conf default settings. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15543 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-31 * Fixes and improvements related to MVP rewards (bugreport:1259):gepard19843-1269/+1487
- removed obsolete (since r1!) ExpPer column from mob_db - official way to drop MVP rewards (always starts from first slot) - added MAX_MVP_DROP as define for max possible MVP reward slots * Updated mob_db SQL scripts. * Removed some renewal only monsters from pre-RE mob_db (were commented out anyway). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15531 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-26 * Modified drop system to allow overriding global item drop rates on ↵gepard19841-2/+2
per-item basis. For detailed explanation read source:trunk/db/mob_item_ratio.txt (topic:56118). * Added missing update to `logs.sql` (follow-up to r15519). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15521 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-25Added two picklog types to distinguish regular monster drops (M) from stolen ↵gepard19841-0/+3
items (D) and MVP prizes (U)(bugreport:4590). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15519 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-11- SVN Copied exp.txt, exp_guild.txt, exp_homun.txt to /db/pre-re/ and /db/re/brianluau16-17/+15
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15423 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-11Picklog improvements:gepard19842-2/+6
- now it is finally possible to log every item players gain or lose - added 3 log types: `I` for auctioned items, `B` for buying shop transactions and `X` for all other items transactions that don't fall into another category (for detailed explanation on all log types read `conf/log_athena.conf`) - it also fixes items being logged as picked up/gained by player when in fact they were dropped on the ground due to full inventory git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15420 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-04*Fixed a bug where a boss card was dropped from OCA.Chilly01231-2/+2
*Fixed drops and drop rates for a few mobs. *Added mob_chat for Nidhoggur's Memory mobs. *Updated item_db_re with all weapons that have a MATK bonus and added more items that have different DEF values in renewal. *Updated mob_boss and mob_branch with official episode 13.3 aegis spawns (special thanks to Muad_Dib) *Updated mob's skills to Malaya Port. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15387 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-04` Updated item_db.sql file to match the contents of the txt versionxantara1-363/+878
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15385 54d463be-8e91-2dee-dedb-b68131a5f0ec
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-07-19 02:13:37 +0000