summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
AgeCommit message (Collapse)AuthorFilesLines
2014-04-26Follow up c1f1ca708d54jaBote1-2/+5
Updated rAthena to Hercules database upgrade to latest main files.
2014-04-26Follow-up to 93584f7, Fixed issue with Character Creation, column doesn't ↵MrKeiKun2-1/+5
contain default value. Signed-off-by: MrKeiKun <the.keikun@gmail.com>
2014-04-18Rewritten NSI_UNIQUE_ID system to get rid of the cross-database interreg ↵Ibrahim Hossam2-1/+5
dependency - Removes the need for map-server to access the interreg table to store the last used ID. - Login, char and map databases can now be hosted separately. - Note: the unique_id structure has changed, and it now contains the generator character ID in its upper 32 bits. - Now NSI_UNIQUE_ID System is enabled always Special thanks to Haruna.
2014-03-31Updated documentation for pc_statusup2 and pc_statusuppanikon1-1/+2
(fixed issue: 7916 http://hercules.ws/board/tracker/issue-7916-wrong-comment-in-pc-statusup2/) Now pc_statusup2 returns stat increase amount as stated in previous documentation Updated *statusup documentation it was wrong Added last update in upgrade index @console.c/.h Documented partially Now two different parsing categories can have functions with same name e.g. - server exit - sql exit
2014-03-26Update rAthena-main-upgrade.sqljaBote1-1/+6
Following up latest commit that alters the database (4b1cc23085b858364a332bdf03d634656778b1e6). Logs converter isn't needing an upgrade yet.
2014-03-25Added new return values to make_new_char_sqlpanikon1-0/+3
Added char_id to charlog Corrected RE check in skill_magic_reflect (see commit c9310f3)
2014-03-22Fixed issue 7338 (added new char configuration char_aegis_delete)panikon2-2/+2
http://hercules.ws/board/tracker/issue-7338-deleting-character/ As @jaBote requested in 26f2ada, renamed "rathena-logs-database-upgrade" to "rAthena-logs-upgrade.sql" and updated 'last revision'. Added a 'FIXME' in db_obj_put
2014-03-21Update rAthena-main-upgrade.sqljaBote1-27/+231
Added in the differences from some months ago. Very special thanks to @dastgirpojee for the autotrade saving script! None of us could test with actual data, so feel free to try it and point out any flaws you can see.
2014-02-19Follow up 9132878d911cfe720eaad94ad3d4a5dd11958f99shennetsind2-1/+6
Fixed issue (8023) with sc rows (only those of tick = -1, aka permanent scs) duplicating due to lack of primary index. Special Thanks to Flash, Haru. Note that the upgrade script will clear the permanent statuses from your sc_data table (e.g. lex aeterna, carts) to ensure no issues are left. Signed-off-by: shennetsind <ind@henn.et>
2014-01-11Hercules 1st 2014 MegaPatchshennetsind2-0/+62
http://hercules.ws/board/topic/3886-hercules-1st-2014-megapatch/ Signed-off-by: shennetsind <ind@henn.et>
2014-01-08Introducing Hercules Autotrade Persistencyshennetsind2-1/+18
Aka autotrading merchants survive server restarts. Originally sekai's (aka me). Special Thanks to Haruna, Michieru. Signed-off-by: shennetsind <ind@henn.et>
2013-12-24Christmas Patch - 2013-12-23 Supportshennetsind2-0/+9
Info: http://hercules.ws/board/topic/3614-christmas-patch-gifto/ Signed-off-by: shennetsind <ind@henn.et>
2013-11-18Follow-up to 1f5161a2bd3c7934373146d8cac3c131536758baHaru2-1/+67
- Added explicit column names in the item_db query, to ensure it will throw a SQL error in case some are missing, rahter than silently failing and returning incorrect data. - Added sql upgrade file to add the bindonequip column to the item_db2 table for those who have it. - As with all the item_db2 upgrade scripts, you need at least MySQL 5.0 in order to run it. If your version is not compatible, or if the script fails for any reason, manual upgrade instructions are provided within the script. - Special thanks to Mumbles. Signed-off-by: Haru <haru@dotalux.com>
2013-11-16Update rAthena-main-upgrade.sqljaBote1-1/+2
Follow-up aee2f6317e1c927847993801b5973d7e2e27a418
2013-11-16Introducing Character Ban Support.shennetsind2-1/+5
@charban/@charunban, can temporarily block any accounts as opposed to the usual account-wide block. Special Thanks to Haruna, Yommy! Signed-off-by: shennetsind <ind@henn.et>
2013-11-15Update rAthena-main-upgrade.sql. Follow-up ↵jaBote1-0/+1
40262e063a7d503104667a4135c564d996bc49c6 Just added the new SQL update on the converter =)
2013-11-15Merge branch 'master' of https://github.com/HerculesWS/Herculesshennetsind1-10/+10
2013-11-15Updated `account_data` upgrade filesshennetsind3-3/+9
to avoid issues as demonstrated by report 7824 http://hercules.ws/board/tracker/issue-7824-exp-and-drop-rates-in-lat/ Special Thanks to Yommy! Signed-off-by: shennetsind <ind@henn.et>
2013-11-15Update rAthena-main-upgrade.sqljaBote1-10/+10
Made the converter keep some more data (rAthena's `moves` column is equivalent to our `slotchange` in the `login` table) and made it a tidbit more efficient since with their last updates their DB is now more similar to ours :D
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-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.shennetsind2-1/+7
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/Improvementsshennetsind2-2/+5
Special Thanks to Haruna Signed-off-by: shennetsind <ind@henn.et>
2013-11-06Merge remote-tracking branch 'origin/master'shennetsind1-0/+4
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 Herculesshennetsind1-0/+1
Signed-off-by: shennetsind <ind@henn.et>
2013-11-02Merge remote-tracking branch 'upstream/master'shennetsind2-1/+4
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.sevenzz231-0/+4
Im pretty sure its on the clif.c Signed-off-by: sevenzz23 <sevenzz23@yahoo.com>
2013-10-30Official Font Supportshennetsind2-1/+5
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 Modifiersshennetsind2-1/+7
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 Baseshennetsind2-1/+8
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-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 Supportshennetsind2-0/+4
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 filesHaru8-8/+8
- 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-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 #7127shennetsind1-0/+4
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-11* Added remaining Malangdo coin traders.euphyy1-1/+1
* 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-03-27Introducing Slot Change featureshennetsind1-0/+3
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-09Hercules Renewal'd Pin Codeshennetsind3-2/+10
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.lemongrass31101-0/+7
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-04Introducing account-dependent character slot countshennetsind2-1/+5
As requested in http://hercules.ws/board/topic/248-reserved-slot-system/ Signed-off-by: shennetsind <ind@henn.et>
2013-02-15MySQL Update Checker: Updatedshennetsind2-1/+5
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 #5018shennetsind2-0/+8
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 Checkershennetsind19-89/+0
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>