summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
2012-07-27Reverted item_db.sql and item_db_re.sql to r16512. (bugreport:6349)kenpachi2k112-10508/+4319
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 ↵kenpachi2k112-6/+6
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 ↵kenpachi2k112-6/+6
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.kenpachi2k116-11896/+24083
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16513 54d463be-8e91-2dee-dedb-b68131a5f0ec
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