summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2013-06-14Whitespace, TABs & SpellingsAkkarinage2-2/+8
Replaced indents using spaces with tabs, reducing file sizes and conforming to standards.
2013-06-14Updating .sql item db filesshennetsind4-14152/+13999
Also Introducing the official DB2SQL plugin to quickly update the .sql db files. http://hercules.ws/board/topic/1105-hercules-wpe-free-june-14th-patch Signed-off-by: shennetsind <ind@henn.et>
2013-04-29Fixed bug report #6396Kenpachi2-8/+8
- Updated bonus scripts of Chemical Protection scrolls to ensure that skill requirements are fulfilled. http://hercules.ws/board/tracker/issue-6396-chemical-protection/
2013-04-29Fixed bug report #7202Kenpachi2-2/+2
- Updated bonus order of 12218 to enable correct showing of skill effects. http://hercules.ws/board/tracker/issue-7202-assumptio-effect-on-scrolls/
2013-04-29Fixed bug report #7156Kenpachi2-10/+10
- Removed double entries for item 6441 and 6442 and updated their names according to fRO database. (http://rns.gamona.de/index.php?show=viewitem&itemid=6441, http://rns.gamona.de/index.php?show=viewitem&itemid=6442) - Updated name of 12416 in all 4 item database files. (LUcky -> Lucky) - Updated order of 19533 and 19534 in /db/re/item_db.txt. - Updated AegisName of 4853-4858. http://hercules.ws/board/tracker/issue-7156-double-items/
2013-04-27Fixed missing default in upgrade fileshennetsind1-1/+1
All credits to kyeme! thank you! Signed-off-by: shennetsind <ind@henn.et>
2013-04-15Fixed Bug #7127shennetsind2-1/+8
Also Implemented allow party invitations state. Implemented saving of client options (atm show_equip and allow party invitation) http://hercules.ws/board/tracker/issue-7127-view-equipment/ Signed-off-by: shennetsind <ind@henn.et>
2013-04-15Fixed Bug #7154shennetsind2-1/+5
http://hercules.ws/board/tracker/issue-7154-equipment-based-skills-skill-891-for-example-persisting-through-resetsremoving-gears/ Merge of 3a9bacc515674885f079391899b22a5ccd8c2e31 Special Thanks to akinari1087 http://hercules.ws/board/topic/410-skill-script-command-updatefix/ Signed-off-by: shennetsind <ind@henn.et>
2013-04-11Fixed missing apostropheshennetsind1-1/+1
all credits to the awesome jTynne :3 thank you! Signed-off-by: shennetsind <ind@henn.et>
2013-04-11* Added remaining Malangdo coin traders.euphyy2-37/+55
* Renewal item database update: -- Implemented nearly all remaining Malangdo items. -- Added Upg_* boxes (follow-up r17180). -- Corrected many kRO names. * Updated Renewal item_trade database for Dewata, Malangdo, and Upg_* boxes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17186 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11* Initial implementation of Archangel Wing Enchants script.euphyy2-26/+26
* Added some Malangdo coin exchange NPCs, more will come later. * Updated Malangdo warp portals. * Fixed item ID 12220 and clarified documentation of 'getiteminfo' types 11 and 14 (bugreport:7256). * Minor Renewal item database update. * Applied changes from r17171 to SQL databases. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17172 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-11* Renewal item updates, mostly misc items (incl. bugreport:7167).euphyy1-64/+87
* A couple of quest_db updates. * Moved El Dicastes Guide to a separate file and fixed viewpoint syntax. * Fixed bugreport:7238, two mob skill mode changes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17122 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-27Introducing Slot Change featureshennetsind2-0/+5
Special Thanks to Yommy for providing the packet structure/data. Signed-off-by: shennetsind <ind@henn.et>
2013-03-17Follow up 7436a70cde2220c42cd249cee6368d308b0bd040shennetsind1-2/+4
Added in-file instructions Signed-off-by: shennetsind <ind@henn.et>
2013-03-17Adding eAthena -> Hercules SQL Upgrade Fileshennetsind1-0/+76
As Requested in http://hercules.ws/board/topic/273-sql-upgrade-files-not-exits/ Signed-off-by: shennetsind <ind@henn.et>
2013-03-14Start to standardize the database files.lemongrass31103-200/+212
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17198 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-14-Updated DB, Credits to Euphy & LemongrassStreusel1-0/+2
-Added coin_exchange.txt Credits to EUphy & Lemongrass
2013-03-10-Vellum's aegis name is Velum, display name is VellumStreusel1-17/+17
2013-03-09-Added Upg items, Credits to EuphyStreusel1-26/+37
-Renamed Bellum items to Vellum -Updated sql file according to above listed changes
2013-03-09Hercules Renewal'd Pin Codeshennetsind4-3/+15
Feature is not, I repeat, NOT complete. the decryption is not fully functional which leads to dial values different from the ones the player used. Credits: lemongrass3110 for the base yommy for the packets LightFighter for the decrypt function (altho its not stable :P) Signed-off-by: shennetsind <ind@henn.et>
2013-03-06Updated dewata to match the official scripts.lemongrass31102-29/+121
This commit includes a optional SQL upgrade file, that will reset all the dewata quests and the related variables, that your users have done. Thanks to Euphy for helping me and additionally thanks to Flaid for taking his time to test our conversion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17178 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-06-Updated EXP tableStreusel1-8/+21
-Updated healing items & costume items -Updates item_db_re.sql for last commits healing item update, Credits to Euphy
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