summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2013-11-15Official Item BindOnEquip Supportshennetsind3-14333/+14273
Implements the 'BindOnEquip' item db field which determines whether the piece of equipment should bind to the character upon being equipped. When a character tries to equip such a item for the first time a dialog shows up asking the character to confirm whether to equip the item or not, and notifying the character that by equipping the item it will become bound to the character, and therefore unable to be used by another character. Special Thanks to Beret for all the information, Haruna for testing. Signed-off-by: shennetsind <ind@henn.et>
2013-11-15Re-generated SQL item databases with the updated db2sql pluginHaru2-14336/+14295
Signed-off-by: Haru <haru@dotalux.com>
2013-11-15Added item_db2.sql conversion script to the new structureHaru2-1/+107
- For those using a SQL item_db2, I provided a convenience script to update to the new structure without having to delete and re-import your data. - The script requires at least MySQL 5.0 (tested on MySQL 5.6) and works for both Pre-Renewal and Renewal tables. If you're running an older version (Oracle advises to upgrade for security reasons by the way!), open the upgrade script in your text editor, and you'll find the queries you can run manually instead. - Special thanks to Ind. Signed-off-by: Haru <haru@dotalux.com>
2013-11-14Removed redundant item_db2_re.sqlHaru2-166/+72
- Both databases have the same format now. - Special thanks to Ind. Signed-off-by: Haru <haru@dotalux.com>
2013-11-10Update rAthena-main-upgrade.sqljaBote1-0/+5
Now it deletes all entries on the sc_data table since it's dangerous if we port the sc data as is. WARNING, this ends all active SCs on the previous server! Even jailed state!
2013-11-10Added rAthena to Hercules logs database upgraderjaBote1-0/+13
This has been added because a lot of people were suggesting this on the forums. Check the news topic for more info: http://hercules.ws/board/topic/2906-introducing-rathena-to-hercules-database-converters/?p=19260
2013-11-10Added rAthena to Hercules main database upgrader.jaBote1-0/+80
This has been added because a lot of people were suggesting this on the forums. Check the news topic for more info: http://hercules.ws/board/topic/2906-introducing-rathena-to-hercules-database-converters/?p=19260
2013-11-08Adjusted account-modifiers default values to 100.shennetsind3-4/+11
Special Thanks to Haruna, ossi0110. Signed-off-by: shennetsind <ind@henn.et>
2013-11-07Further item bind adjustmentsshennetsind1-1/+1
Thanks to Haruna! Signed-off-by: shennetsind <ind@henn.et>
2013-11-07Item Bound Fixes/Adjustments/Improvementsshennetsind3-2/+6
Special Thanks to Haruna Signed-off-by: shennetsind <ind@henn.et>
2013-11-06Merge remote-tracking branch 'origin/master'shennetsind2-0/+8
Signed-off-by: shennetsind <ind@henn.et> Conflicts: conf/messages.conf src/common/mmo.h src/map/pc_groups.c src/map/pc_groups.h
2013-11-02Updated to latest Herculesshennetsind2-0/+5
Signed-off-by: shennetsind <ind@henn.et>
2013-11-02Merge remote-tracking branch 'upstream/master'shennetsind3-5/+6
Signed-off-by: shennetsind <ind@henn.et> Conflicts: sql-files/main.sql sql-files/upgrades/index.txt src/common/mmo.h
2013-10-31No error after compilation, but when logging in at map server it will crash.sevenzz232-0/+8
Im pretty sure its on the clif.c Signed-off-by: sevenzz23 <sevenzz23@yahoo.com>
2013-10-30Official Font Supportshennetsind3-1/+7
Fonts are now relog-persistent. Font items are now toggle-on/off, they no longer go away on use, they go away when their rental duration is over (and the font effect goes back to original). Special Thanks to Yommy for all the data! Signed-off-by: shennetsind <ind@henn.et>
2013-10-30Account-wide Exp/Drop/Death Modifiersshennetsind3-1/+11
Attempting to mimic the official as suggested in http://hercules.ws/board/topic/250-official-vip-system/ The variables can be read and modified thru scripting as well as sql, the patch introduces 3 new pc-arams 'ModExp','ModDrop' and 'ModDeath' for that purpose. The OnLogin modifier display is not the real deal though -- wasn't able to get it to output properly (though that might have been my client files failt) Up for review. Signed-off-by: shennetsind <ind@henn.et>
2013-10-27Shadows System Baseshennetsind3-5/+13
http://hercules.ws/board/topic/581-implement-the-shadows-system/ Special Thanks to Yommy for all the client data, Haru for making it possible to get it out and rosfus for the details on the feature. Shadows Feature requires packetver 20120925 or newer. ---------- Also: Updated all packets related to the shadows system, improved memory/processing of inventory/cart/storage/viewequip packets Signed-off-by: shennetsind <ind@henn.et>
2013-10-24Added 4 missing items to pre-re which the quest db update relies uponshennetsind1-29/+33
Follow up 418dd821c91ae19723a7b7b531e64b9c4565d555 Thanks to ossi0110 Signed-off-by: shennetsind <ind@henn.et>
2013-10-24Updated Item_db sql files to match latest .txt versionshennetsind2-1038/+1038
Includes the skill name constant update e3d71d9455de45d5a9417dbebd74aa49a0e7ae6a Signed-off-by: shennetsind <ind@henn.et>
2013-10-24item_db.sql update to match .txtshennetsind2-35/+34
Thanks to ossi0110 for bringing it up. We will soon make this automatic like the hooking cache ( e.g. 491892212d338903179909b89a5bfc2385e52261 ) so that .sql dbs will always be up to date with the txt counterparts. Signed-off-by: shennetsind <ind@henn.et>
2013-10-10Follow up c5c3381Streusel1-0/+1
Thanks to QQfoolsorellina
2013-10-10Follow up c5c3381b0b8b0b59c669d474acf749db82d7edb1shennetsind2-1/+9
Missed account_data table in the upgrade file, thanks to ossi0110 Signed-off-by: shennetsind <ind@henn.et>
2013-10-10Introducing Bank Supportshennetsind3-0/+20
http://hercules.ws/board/topic/2455-introducing-bank-support/ Thanks to Yommy, Haru! Signed-off-by: shennetsind <ind@henn.et>
2013-09-16Corrected line endings and BOM issues with several filesHaru10-10/+10
- Ensured final end-of-line character in every file. - Corrected cases of mixed line endings (mostly CR and CRLF within the same file.) - Removed extra BOM from some scripts, since it causes a parsing error. Signed-off-by: Haru <haru@dotalux.com>
2013-08-22Fixed Bug #7506shennetsind1-4/+4
Given the class is accessible under pre-re mode, its skills that rely on these catalysts are unable to function since the items they require do not exist. Adding them. http://hercules.ws/board/tracker/issue-7506-skill-items-missing-in-pre-re/ Signed-off-by: shennetsind <ind@henn.et>
2013-08-22Fixed Bug #7354shennetsind1-11/+12
Given mounting support is present in pre-re I'm adding the item to squash the warning away, the problem by having item_delay being shared by pre-re and re will be sorted in a upcoming update. http://hercules.ws/board/tracker/issue-7354-item-delaytxt/ Signed-off-by: shennetsind <ind@henn.et>
2013-08-22Fixed Bug #7503shennetsind1-1/+1
128 being higher than the maximum available value for pre-re mode (in pre-re def is 'char/int-8', unlike renewal mode in which it is 'short/int-16') http://hercules.ws/board/tracker/issue-7503-mob-parse-dbrow/ Signed-off-by: shennetsind <ind@henn.et>
2013-08-22Pre-re SQL item db updateshennetsind1-95/+94
Thanks to Haruna, Closes #88 Signed-off-by: shennetsind <ind@henn.et>
2013-08-04Fixed Bug #7610shennetsind1-567/+599
renewal item db price column fix. Special Thanks to Muad_Dib for pinpointing the source of the problem and providing a solution, and also providing us with data for 32 new items (some are new headgears :P) http://hercules.ws/board/tracker/issue-7610-wrong-price-for-iron-ore/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-31Fixed Cash Items Upper valuesshennetsind1-1224/+1224
Issue existed in renewal mode only; Special Thanks to Jezu for bringing it up. Signed-off-by: shennetsind <ind@henn.et>
2013-07-31Fixed Bug #7586Mysteries1-12/+12
Added bonuses for items: - 2917 - 2918 - 2919 - 2920 - 2921 - 2922 - 2923 - 2924 - 2925 - 2926 - 2927 - 2928
2013-07-29Follow up 1caae981b4f000b67bdd0b118fb76797c2bfa06cshennetsind1-2774/+2783
Applying the missed 'upper' flag updates. http://hercules.ws/board/topic/1778-ultimate-item-db-update/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-29Follow up 1caae981b4f000b67bdd0b118fb76797c2bfa06cshennetsind1-628/+640
Prioritising kRO-item-data above others whenever possible, Special Thanks to Yommy for the data and Haru for help on validating the output. http://hercules.ws/board/topic/1778-ultimate-item-db-update/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-29Ultimate Item DB Updateshennetsind1-4384/+4597
http://hercules.ws/board/topic/1778-ultimate-item-db-update/ Signed-off-by: shennetsind <ind@henn.et>
2013-07-14Fixed missing tableMr.Postman1-1/+1
2013-07-11Fix for Bug #7507shennetsind1-51/+133
Merged from rAthena, there is no commit to refer to as I've obtained the missing entries from their latest file. Special Thanks to jTynne http://hercules.ws/board/tracker/issue-7507-items-missing-from-item-d/ Signed-off-by: shennetsind <ind@henn.et>
2013-06-24Fixed db2sqlshennetsind2-205/+206
Wasn't taking in account the delay_consume flag which actually means the item type is 11 not 2. Also added a extra warning in the item packages parser. Special Thanks to ossi0110 for bringing this up. Signed-off-by: shennetsind <ind@henn.et>
2013-06-24Follow up fcba8a2161a392369db99ab9a516a24470c54796shennetsind2-229/+229
Fixed "random" item package rates, special thanks to Beret. Also, added the missing (+130) item package calls (special thanks to Streusel!) Signed-off-by: shennetsind <ind@henn.et>
2013-06-23Official Item Group/Package/Chainshennetsind2-210/+230
http://hercules.ws/board/topic/1244-official-item-grouppackagechain/ Also Further implemented itemdb.c/storage.c interfaces, and a minor update to db2sql plugin. Signed-off-by: shennetsind <ind@henn.et>
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