summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
AgeCommit message (Collapse)AuthorFilesLines
2016-07-08Add sql upgrade scripts for convert date/datetime default values.Andrei Karas7-0/+111
2016-03-12Corrected header in the latest SQL upgradeHaru1-1/+1
Follow-up to ca5f133 Signed-off-by: Haru <haru@dotalux.com>
2016-03-10Update sql scripts.Andrei Karas3-1/+24
2016-01-05Fix battle config Hp/Sp overflow valueAnnieRuru1-0/+26
- client can't handle value over 21474836 - SQL also can't save value over 16777215 due to mediumint unsigned Closes #965 as merged Signed-off-by: Haru <haru@dotalux.com>
2016-01-05Added Support for BodyStyleDastgir2-1/+24
Closes #974 as merged
2015-12-20Split eathena-upgrade in two filesmaqc12-19/+44
Split eathena-upgrade in two files, one for main and one for logs (as is it for rAthena-upgrade) Closes #946 as merged
2015-12-20Added a missing parse on line 59 of eathena_upgrade.sqlmaqc11-1/+1
Closes #945 as merged Signed-off-by: Haru <haru@dotalux.com>
2015-12-15Added GPL-compliant header to sql filesHaru35-0/+667
Signed-off-by: Haru <haru@dotalux.com>
2015-08-30Follow up@2b4b33b06a964e83bf5df9f7f0b795ddf76f9dd0malufett1-0/+1
- missing sql upgrade index. Signed-off-by: malufett <malufett.eat.my.binaries@gmail.com>
2015-08-27Hotkey Rotate Packet ImplementedDastgir1-0/+3
2015-08-10Corrected an issue with the last SQL updateHaru1-1/+1
- Follow-up to 8caa0e564b5331a88d8dc1712513368b37ba9694 - It's safe to re-apply the related sql update script (sql-files/upgrades/2015-07-08--13-08.sql) in order to get rid of the 'detected 1 new SQL updates' message. - Thanks to KirieZ Signed-off-by: Haru <haru@dotalux.com>
2015-08-09Removed unused tables sstatus and interregHaru2-1/+8
Signed-off-by: Haru <haru@dotalux.com>
2015-07-08Update Unique ID system to match official now it cover all cash items ↵Ibrahim Hossam2-1/+58
include stackable ones. Implement ForceSerial option in Package Item Database to force serial for any item. Implement ForceSerial option in item database to force serial for any item. Implement Merge Client interface to merge stackable items with serial numbers ( check npc/other/item_merge.txt ).
2015-06-02Follow up to 712812bMysteries1-1/+1
- More link changes - Added proper link to Roulette topic
2014-11-03Follow up 239d480487e24294975f35ed55f210837ad1088eshennetsind1-0/+1
Added missing sql upgrade index entry Signed-off-by: shennetsind <ind@henn.et>
2014-11-03Introducing 2014-10-22, Roulette and Per-Char Gender!shennetsind1-0/+3
Details in http://hercules.ws/board/topic/7618-2014-10-22-roulette-and-per-char-gender/ Special Thanks to the all-mighty Yommy, Ziu and Haruna! Signed-off-by: shennetsind <ind@henn.et>
2014-09-02Fixes wrong data type in SQL for base_exp,base_drop and base_death.Dastgir2-0/+6
2014-07-22Update rAthena-main-upgrade.sqljaBote1-9/+43
Updating to adapt the database from current latest rAthena server. Couldn't test since I haven't got a test database right now, but looks good enough. Any issue should happen with it, please address me at Hercules forums rather than here.
2014-07-22Update rAthena-logs-upgrade.sqljaBote1-4/+13
2014-07-10Updated sql-upgrade files.Shido25-225/+242
2014-05-23Update rAthena-main-upgrade.sqljaBote1-0/+5
Following up 3591de7e7ac2db4e3eeaa9bad2615648e7f94b3a. Upgrader should be up to date as of now.
2014-05-18Follow-up 5f5380e and a42f880e, Fixed crappy coding with sql-update ↵Shido1-1/+1
file(Special thanks to QQfoolsorellina)
2014-05-17Follow-up to 5f5380e8d5fa2e6042813e35101cb33b656e3972Haru1-1/+1
- Fixed a missing semicolon in the upgrade script. Special thanks to QQfoolsorellina Signed-off-by: Haru <haru@dotalux.com>
2014-05-17Renamed incuvate of Pet System.Shido2-0/+4
2014-05-13Fixed some charset issuesHaru1-1/+1
- Fixed files with mixed character set or invalid CP949 characters. - Uncommented '#music' script in the_sign_quest.txt (now the soundeffect filename should be fixed). - Added a note to the header of CP949 files not to read or save them as UTF8, since it'd break their encoding. It should be safe enough to read them as EUC-KR if your text editor doesn't offer CP949 as an option. - Added FIXME notes about untranslated strings in assassin_skills.txt and WolfchevLaboratory.txt. Signed-off-by: Haru <haru@dotalux.com>
2014-05-13Fixed several files with a missing EOL at EOFHaru12-12/+12
- All text files should end with an EOL. Period. - See http://robots.thoughtbot.com/no-newline-at-end-of-file for info on how to configure the most common text editors to do it automatically for you. Signed-off-by: Haru <haru@dotalux.com>
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>