summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
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