summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2013-03-05-Added Malangdo Enchantments, credits to EuphyStreusel1-0/+1
-Fixed Guillotine Cross job change, credits to Euphy -Updated message display of Malangdo NPC's, credits to Euphy -Updated item_db_re.sql
2013-03-05* Updated Endless Tower instance to latest official script.euphyy1-1/+32
-- String "Floor" changed to "Level". -- Warp portals open after a 5 second delay. * Renewal item database fixes (bugreport:7301, bugreport:7308). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17165 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-05- Fixed amount of item slots on orbs and assassin's glove thanks to letskay ↵playtester1-5/+5
(bugreport:7309 and bugreport:7312) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17164 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-04Followup 0241d0195558b7e57d2181f2f097cf774a1ef463shennetsind1-0/+1
git's commit-per-line thing fooled me, it skipped this line. Signed-off-by: shennetsind <ind@henn.et>
2013-03-04Introducing account-dependent character slot countshennetsind3-1/+6
As requested in http://hercules.ws/board/topic/248-reserved-slot-system/ Signed-off-by: shennetsind <ind@henn.et>
2013-02-25* Part one of fixing bugreport:6527. This does not yet change functionality.euphyy1-2/+2
-- Added 'disable_items' to all applicable scripts. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17160 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-02-21-Added new items (Credits to Muad_Dib)Streusel1-2/+2
-Fixed my previously incorrect bAllStats spelling -Removed & re-added most of my previously assigned unbreakable heagears -Fixed weight on 3 other already existing ones -Added Fly Wing to Poring & Lunatic in the mob_db_re.sql
2013-02-16Updated main.sql to reflect the latest `sql_updates` entriesshennetsind1-0/+1
Signed-off-by: shennetsind <ind@henn.et>
2013-02-15MySQL Update Checker: Updatedshennetsind3-2/+7
Added a primary key to the `sql_updates` table (special thanks to Trojal) Modified the parser to ignore new/empty lines and added support for "//" comments in the index file. Signed-off-by: shennetsind <ind@henn.et>
2013-02-14Fixed Bug #5018shennetsind3-0/+11
Skills granted through scripts are now permanent, until this date they were not relog persistent Signed-off-by: shennetsind <ind@henn.et>
2013-02-14Introducing MySQL DB Update Checkershennetsind20-89/+10
First version. Signed-off-by: shennetsind <ind@henn.et>
2013-02-08Reverting 4b41901d3ecb01930a57e9b1d230e729d5feba38shennetsind1-1/+0
I was using a different git client when I committed that, and it committed all my unstaged changes, not using that client anymore :[. Signed-off-by: shennetsind <ind@henn.et>
2013-02-08Fixing a logical issue in ST_RIDINGshennetsind1-0/+1
2013-02-04Getting rid of unused indexes.akrus1-11/+5
Source: http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3).
2013-02-04Merged some commits from rAthena.Matheus Macabu2-2/+2
2013-02-03Merged rAthena r17103Mysteries1-78/+113
Added and updated many Renewal item scripts (incl. bugreport:7162, bugreport:7147). Some formatting changes in Clothes Dyer script (incl. bugreport:7204).
2013-01-08- Added svn:eol-style=native property.brianluau2-26/+26
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17087 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-08* Renaming variable name from nsiuid to unique_id for better understanding ↵markzd3-8/+19
of its meaning, as requested on tid:69380. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07* Follow Up: r17080markzd1-0/+8
1. Removed an unnecessary update call. 2. Implemented interreg table at main.sql. * Follow Up: r17077, r17072, r17065 1. Fixed bugreport:7078, removed unnecessary checks. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17081 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07* Implemented Unique identifier for Non stackable items. (tid:69380)markzd3-0/+23
* Set as off by default, it can be changed in /src/config/core.h. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-30* Added Somotology Laboratory F4 quest (written by Ziu, translated by Heris, ↵euphyy2-1/+4
uses some iRO dialogues). * Updated quest_db with Somotology Laboratory F4 entries (5113-5125 are placeholders, may be incorrect). * Moving of warp files, reducing the number of duplicates in pre-re/re paths. * Added a note to documentation (bugreport:7065) and fixed a small mistake (bugreport:7068). * Follow-up r17056, missing $ (bugreport:7067) and added a missing item. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17063 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-29* Added more Malangdo scripts.euphyy1-4/+6
* Updated quest_db with more translated Malangdo entries. * Added and updated some newer items. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17060 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-24* Custom Quest Shop updated to v1.6, which adds support for bulk purchases.euphyy1-1/+1
* Follow-up r17014, fixed a typo in main.sql -- credits to Jeroen for finding that. * Follow-up r17039, missed a parameter -- thanks, clydelion/mkbu95! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17040 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-17- Fixed bugreport:7001, Nidhoggur Shadow Card: checks for High Wizard and ↵j-tkay1-1/+1
Warlock jobs. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17027 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-11Happy Holidays and Happy 12/12/12 :)rud0lp202-6/+17
Update Elemental summon to its official behavior - Fixed missing skill features of Ventus(bugreport:6792,bugreport:6723,bugreport:6511) - Note: upgrade_svn17014.sql - And other elemental skills are to follow :) Fixed bugreport:6889 updated const.txt where it cause error to some items. Fixed bugreport:6999 where matk damage deals miss atk to plant type targets. Fixed status calculation where it doesn't give accurate result or how official calculation does. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17014 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-29Fixed bugreport:5689 recoded/reimplement RE Matk formula(including RE Heal)rud0lp202-40/+40
Fixed bugreport:5745 WL_RECOGNIZED us now functional. Fixed bugreport:5663 where HW_MAGICPOWER shows glitch in status window. Fixed bugreport:6759 where items granting matk bonus didn't work. Follow up r16980 small performance enhancement...:) Done some TODO in skill_cast_db.txt git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16981 54d463be-8e91-2dee-dedb-b68131a5f0ec
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