summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
2012-01-03- Follow up r15363.masao871-9/+9
* Enabled Item Scripts for Job change specific Items. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15364 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-03- Added first Version of Warlock Job change Quest.masao871-1/+1
- Updated mob/fields/splendide.txt for Warlock Job change Quest. - Fix for previous commit r15352 . git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15363 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-02- Kenpachi asked for it, so here is also the change for the item_db ;Pmasao871-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15354 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-27` Updated item_db_re.sql to match item_db_re.txtxantara1-60/+275
` Renamed a function to say RE instead of RR git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15286 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Updated several card scripts according to their description. (bugreport:4751)kenpachi2k111-9/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15276 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Removed Atros duplicate from mob_boss.txt. (bugreport:4651)kenpachi2k111-4/+4
Took over Tantan Noodle (12395) script from item_db.txt to item_db.sql. (bugreport:4722) Updated RWC 2008 Dragon Helm (5451, 5452, 5453) bonus. (bugreport:4730) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15272 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Added the two new bonuses from r15269 and r15270 to item_bonus.txt.kenpachi2k111-3/+3
Updated Refined Bloody Roar (1273) bonus. (bugreport:4767) Updated Entweihen Crothen Card (4451) bonus. (bugreport:4486) Updated Angeling Hat (5132) DEF and required level. (bugreport:4517) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15271 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-25Updated October Fest Cap (5807) bonus. Assumed 2% chance until we get more ↵kenpachi2k111-5/+5
information. (bugreport:4475) Updated Shield of Naga (2134) bonus. (bugreport:4379) Updated Well-Chewed Pencil (5574) bonus. (bugreport:4381) Updated Parade Hat (5225) bonus. (bugreport:4481) Removed changes from r15112 / bugreport:4356. (Was a custom iRO bonus.) Updated Speed Potion drop chance in First Aid Kit. (bugreport:5157) Fixed item_bonus.txt where x/10000 should be x/100. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15259 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-24Fixed typo in item_db.sql (bugreport:5153)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15258 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-22Fixed s-quote escapes in updated mob_db.sql. Thanks Brian!!calciumkid1-13/+13
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15206 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-22Replicated sql-files\mob_db.sql to match db\mob_db.txtcalciumkid1-1175/+1230
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15204 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18- Set svn:eol-style=native for some recently added text files (follow up to ↵brianluau2-6489/+6489
r15155). - Changed urls in README to http (https is when you're logged-in to SourceForge). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15159 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18mob_read_sqlskilldb func followup 2calciumkid1-6354/+6354
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15157 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18mob_read_sqlskilldb func followup [CalciumKid]calciumkid1-73/+73
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15156 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18mob_read_sqlskilldb func [CalciumKid]calciumkid2-0/+6489
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-14Updated Rideword Hat bonus. (bugreport:4356)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15112 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-14Updated Kasa Card bonus. (bugreport:2499)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15110 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Updated Water Lilly Hats DEF value. (bugreport:4304)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15097 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed some job codes. (bugreport:4254)kenpachi2k111-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15095 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed some items. (bugreport:4274)kenpachi2k111-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed comment in exp.txtkenpachi2k111-4/+4
Updated Luxurious Keycards (7509) trading behaviour. (bugreport:3718) Updated Sleipnirs (2410) bonus script according to iRO Wiki. (bugreport:5118) Updated Soldier Grenade Launchers bonus effect and trading behaviour. (bugreport:4133) Updated Full Plates (2316/2317) DEF value. (bugreport:4260) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15093 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-12Fixed bonus for Valorous Assaulter's Katzbalger (1184). (Bugreport:3021)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15082 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-12Fixed bonuses for Kafra Dolls (ItemIDs 5340, 5341, 5342, 5343, 5344 5345) ↵kenpachi2k111-6/+6
and added a missing semicolon in item_bonus.txt. (bugreport:3129) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-11Fixxed Mole Card bonus.(bugreport:2230)kenpachi2k111-2/+2
Fixxed The Sign bonus.(bugreport:5116) Fixxed documentation for Guardian() and GuardianInfo script commands.(bugreport:5117) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15058 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-10Corrected an issue with Sprint Ring adjusting bDelayRate the wrong way. ↵jmanfffreak1-1/+1
(bugreport:5070) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15055 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Fixed typo in item_db_re.sql, bugreport:5108shennetsind1-6/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15049 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09- Added a blank line at EOF to make SVN and some compilers happy. ↵brianluau2-103/+103
(bugreport:5107) - Removed trailing tabs in /doc/script_commands.txt - Set svn:eol-style=native for some recently added text files (follow up to r15009). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15043 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Removed the Worn Out Scroll giving a Jellopy (bugreport:5053).jmanfffreak1-1/+1
Also removed /db/item_scroll.txt, since that item was the only thing pulling data from it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15042 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Fixed Pussy Cat Ears not being able to be equipped by all jobs. bugreport:5102jmanfffreak1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15041 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Added item_db_re.sql -- missed this little guy when RREmu was merged in.shennetsind1-0/+102
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15040 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-05Merging RREmu into rAthena -- quite a few stuff yet to be renamed, but we'll ↵shennetsind2-1/+2
get it sorted. Some of the stuff included in RREmu that is now part of rAthena: - RE Drop Rate Modifier - RE Experience Rate Modifier - RE Weapon MATK - RE Shield ASPD job-specific penalty - RE Cast Time - Renewal-specific item DEF - 3.1 classes. - All-New Mounts - Official Magical Reflection - And other perks, such as fully-functional @mapflag also merged eAthena 15006 into rAthena. For Bugs, Comments and Suggestions: http://rathena.org/board/tracker/ git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15009 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-10-31- Removed .gat from map names.brianluau2-2/+0
- Removed trailing tabs in some warp portal files. - Removed `loginlog` table from convert_engine SQL scripts, because it's in the log database. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14987 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-09-10- Fixed some typos in item_db.txt (bugreport:5048)brianluau2-1726/+2299
- Updated SQL item/mob databases to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14956 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16* Added support for visible garments/robes.ai4rei2-0/+2
- For SQL apply upgrade_svn14797.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself. - This also fixes NPCs not being visible with clients 2011-01-11aRagexeRE+ (bugreport:4865). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14797 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16* Updated field `weapon` in table `char` to default to '0' (bare-handed) ↵ai4rei2-1/+2
rather than '1' (knife) (follow up to r11696). - Apply upgrade_svn14796.sql to reflect the change on existing setups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14796 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-15* Fixed some `mob_db` columns being too small for currently used values ↵Gepard2-12/+12
(bugreport:4866, since r14727). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14794 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-24- Removed extra <TAB> from const.txtbrianluau2-4/+8
- Changed the card columns in `cart_inventory` table to SMALLINT(11), to match other tables. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14759 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-01- Updated SQL item/mob databases to latest. (thanks Peter)brianluau2-1558/+1890
- Updated item/mob txt-to-sql converter scripts to append a blank line at EOF. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14727 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-02-19* Implemented buying store system (aka. reverse vending, purchase shop) ↵ai4rei2-4/+8
together with related skill and items, without NPCs. - For SQL apply upgrade_svn14713_log.sql to upgrade tables `picklog` and `zenylog`; for TXT no action is necessary. - Requires 2010-04-20aRagexeRE or later and can be disabled in 'conf/battle/feature.conf'. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14713 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-02-08* Added support for new delayed character deletion.ai4rei2-0/+2
- Asks for birth date associated with the account and has a waiting time of 24 hours by default (setting). - For SQL apply upgrade_svn14700.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself. - This completes support for clients 2010-08-03aRagexeRE and later. * Updated login sql engine version, missed during `birthdate` addition (follow up to r14672). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14700 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-01-14* Added 'birthdate' field to account data. For SQL apply ↵ai4rei2-0/+2
upgrade_svn14672.sql to upgrade table `login`; for TXT no action is necessary, as it upgrades itself. - Control panel developers are encouraged to enable players to modify this value, as it is required for new character deletion (2010-08-03aRagexeRE and later, not yet implemented). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14672 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-12-12* Removed `motd` from `ragsrvinfo` table in main.sql, missed in previous ↵ai4rei1-2/+1
commit (follow up to r14579). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-12-12* Updates to dynamic server information `ragsrvinfo` on SQL.ai4rei1-0/+1
- Fixed exp and drop rates (int) getting truncated (short) when sent to char-server. - Removed `motd` from `ragsrvinfo` as it is not dynamically changed by the server and as such can be read by 3rd party applications directly from conf/motd.txt if required. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14579 54d463be-8e91-2dee-dedb-b68131a5f0ec