summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2012-11-27* Applied Renewal mob mode changes (bugreport:6150).euphyy2-27/+28
* Small documentation changes (incl. bugreport:6937). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16970 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-25* Added the "Catalog Magician" NPC to merchants/buying_shops.txt, thanks to ↵euphyy2-10/+10
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 ↵euphyy4-101/+101
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-23* Added Guillotine Cross job quest, again thanks to Muad_Dib! (bugreport:5834)euphyy2-4/+4
* Follow-up r16941: added documentation. * Updated WOE Controller script to v1.4, which modifies LoadEvent mapflag settings for easier cross-compatibility and standardizes script format. * Minor tweaks here and there. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16947 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-22-Apply EvilPuncker path from tid:71756glighta2-1/+2
-Fix and upd logzeny enumeration type bugreport:6897 -Upd @zeny to send a message when succed bugreport:6886 -Upd ChaosPanic to affect all bugreport:6893 -Upd bloodylust cooldown and disable endure effect bugreport:6547 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16940 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 ↵momacabu2-82/+82
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.flaid2-2/+2
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);momacabu2-2/+2
- 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-30- Added svn:eol-style=native property.brianluau1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16844 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:6815spre1232-5/+5
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-22- Follow up r16824.j-tkay1-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16825 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-22Forgot to add the upgrade sql file for the Small DB change to item_db_re.sql ↵spre1231-0/+1
Changing Defence from unsigned to accept negative Value do to some items having negative values. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16824 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 ↵spre1232-493/+493
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-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-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)euphyy2-7/+7
* 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-09-06sql-files folder redesign as discussed with other developers, all upgrade ↵shennetsind63-310/+0
files prior to rathena were removed (if you need them you can use the trac or download a earlier version of the folder). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16750 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-31- Standardized headers of /doc files.brianluau1-1/+1
- Added svn:eol-style=native property on some recently added text files. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16726 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-22Fixed Angelic Rings (#2743) autobonus duration. (bugreport:6434)kenpachi2k112-2/+2
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)kenpachi2k112-35/+35
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-18Added SQL script which creates item_db2 table in RE layout. (bugreport:6485)kenpachi2k111-0/+94
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16665 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-18Follow up r16663 added missing column to main.sql, superspecial thanks to ↵shennetsind1-0/+1
EvilPuncker for pointing out. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16664 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-18Fixed bugreport:6343 homun-s skill tree now is properly populated with ↵shennetsind1-0/+1
previous homun form skills, note the sql table update: upgrade_svn16663.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16663 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-17Renamed bMatk and bWeaponMatk to make it easier to understand the bonus when ↵kenpachi2k112-23/+23
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)kenpachi2k112-2/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16645 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-16- Added svn:eol-style=native property.brianluau1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16643 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. ↵kenpachi2k112-1892/+1893
(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)euphyy2-2/+2
* Fixed item #5503, bugreport:6440 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-10* Follow-up r16618, fixed SQL entry as well (sql-files/mob_db_re.sql)euphyy1-2/+2
* Follow-up r16616, forgot the pre-re/re split files... (npc/(pre-)re/kafras/) * Merged changes in eAthena 15164 and 15165 (doc/packet_struct_notation.txt) * Removed unreadable characters in various files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16619 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-09- Added svn:eol-style=native property on some recently added text files.brianluau2-1/+1
- Renamed upgrade_svn16517.sql to the correct SVN revision it was added in (r16518). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16614 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-07* Moved RE coordinates of Bullet/Magazine Dealers in Izlude, bugreport:6410euphyy1-0/+1
* Added "favorite" column to main.sql file, bugreport:6425 (sql-files\main.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16595 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-04* Added missing quotes around some skill names in item DB, thanks Kenpachi! ↵euphyy2-14/+14
(bugreport:6405) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16577 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-30- Added svn:eol-style=native property on some recently added text files.brianluau2-7749/+7749
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16534 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28Follow up r16523 - Interchanged attack and atk:matk in pre-RE and RE item DB ↵kenpachi2k112-2/+2
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...)kenpachi2k114-4321/+10512
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-28Added support for the "favorite item tab" feature. super-mega-thanks to ↵shennetsind1-0/+1
Judas, credits to Fatal Error. Be aware this update requires a new column in the inventory db, run upgrade_svn16517.sql in your database. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16518 54d463be-8e91-2dee-dedb-b68131a5f0ec