summaryrefslogtreecommitdiff
path: root/sql-files/upgrades/index.txt
AgeCommit message (Collapse)AuthorFilesLines
2020-07-29Remove unused dirsAndrei Karas1-66/+0
2020-05-10Update SQL databaseKenpachi Developer1-0/+1
* Add separate tables for global integer and string variables. * Copy data from mapreg table to new map_reg_*_db tables. * Remove mapreg table.
2020-05-02Unify size of columns holding string variable values to 255Kenpachi Developer1-0/+1
2020-04-05Add UNIQUE KEY to column `login`.`userid`Kenpachi Developer1-0/+1
2020-03-22Expand column size of `ipbanlist`.`list` from 13 to 39Kenpachi Developer1-0/+1
2020-02-09Add expanded barter shop sql scriptsAndrei Karas1-0/+1
2019-11-23Fix for https://github.com/HerculesWS/Hercules/issues/2349.Kenpachi Developer1-0/+1
ipban_log() only inserts the first 3 octets of an IP and an asterisk for last one, so we can set the columns length to 13.
2019-11-17Added SQL FilesDastgir1-0/+1
2019-10-06Updates status changes to also keep their total timeGuilherme Menaldo1-0/+1
- This allows clients to continue the "timer" display after you login again
2019-09-22Convert castles ids to match client side idsAsheraf1-0/+1
2019-06-02Use separate field hotkey_rowshift for each hotkeys groupAndrei Karas1-0/+1
2019-05-05Add sql update for guild_expulsion tableAndrei Karas1-0/+1
Add field char_id into table guild_expulsion.
2019-04-08Fix an issue with named/brewed/forged items getting saved with the wrong ↵Ibrahim Zidan1-0/+1
character id The isue was triggered by the refactoring of old undocumented code that relied on the overflow behavior during assignment from int32 to int16 and from uint16 to int16, and by a subsequent clamping to SMALLINT range operated by the SQL server. Credits: Haru <haru@dotalux.com> Fixes #2409 Signed-off-by: Ibrahim Zidan <brahem@aotsw.com>
2019-01-14Add support for saving/loading barter shops from sql table.Andrei Karas1-0/+1
Also allow add duplicated item id to barter shops if price is different.
2018-12-14Add inventory size field into db and using it in server.Andrei Karas1-0/+1
2018-09-02Fixed issue #2187Dastgir1-0/+1
card field is changed to INT in tables
2018-07-28Merge pull request #2067 from dastgirp/1-achievementHaru1-0/+2
Implemented Achievement System and Title System
2018-07-24Implemented Title System.Dastgir1-0/+1
2018-07-24Correct wrong attribute used for pet evolution egg hidingAsheraf1-0/+1
2018-07-24Add SQL Upgrades for Achievementssmokexyz1-0/+1
Co-authored-by: "Dastgir" <dastgirp@gmail.com>
2018-06-25Implemented Pet AutofeedingDastgir1-0/+1
2018-04-07Implementation of Attendance systemAsheraf1-0/+1
2018-03-08Fixed RoDEX mail return not working correctlyGuilherme G. Menaldo1-0/+1
2018-01-25Implementation of Official Clan SystemMurilo Pereti Tavares1-0/+2
All official features work including the autokick for inactive members And the system is completely customizable.
2017-11-18Implement Homunculus autofeedingAsheraf1-0/+1
2017-07-30Implementation of RoDEXKirieZ1-0/+1
2017-04-25Add some missing entries to sql/upgrades/index.txtHaru1-0/+5
This adds some entries from recent and old updates that were missed when adding the corresponding migrations. Signed-off-by: Haru <haru@dotalux.com>
2016-10-26zenylog missing type 'K' for Bank TransactionsSmokexyz1-0/+1
Fixes bug filed here - http://herc.ws/board/topic/13618-db-error-data-truncated-zenylog/
2016-10-22Added Summoner Class.Dastgir Pojee1-0/+1
(Only Placeholder, other things related to summoner will follow-up soon) Added SQL-Upgrade: Added `class` column in charlog
2016-07-08Add sql upgrade scripts for convert date/datetime default values.Andrei Karas1-0/+2
2016-03-10Update sql scripts.Andrei Karas1-0/+1
2016-01-05Added Support for BodyStyleDastgir1-1/+2
Closes #974 as merged
2015-08-30Follow up@2b4b33b06a964e83bf5df9f7f0b795ddf76f9dd0malufett1-0/+1
- missing sql upgrade index. Signed-off-by: malufett <malufett.eat.my.binaries@gmail.com>
2015-08-09Removed unused tables sstatus and interregHaru1-1/+2
Signed-off-by: Haru <haru@dotalux.com>
2015-07-08Update Unique ID system to match official now it cover all cash items ↵Ibrahim Hossam1-1/+2
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 ).
2014-11-03Follow up 239d480487e24294975f35ed55f210837ad1088eshennetsind1-0/+1
Added missing sql upgrade index entry Signed-off-by: shennetsind <ind@henn.et>
2014-09-02Fixes wrong data type in SQL for base_exp,base_drop and base_death.Dastgir1-0/+1
2014-05-17Renamed incuvate of Pet System.Shido1-0/+1
2014-05-13Fixed several files with a missing EOL at EOFHaru1-1/+1
- 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 to 93584f7, Fixed issue with Character Creation, column doesn't ↵MrKeiKun1-1/+2
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 Hossam1-1/+2
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-02-19Follow up 9132878d911cfe720eaad94ad3d4a5dd11958f99shennetsind1-1/+2
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 MegaPatchshennetsind1-0/+1
http://hercules.ws/board/topic/3886-hercules-1st-2014-megapatch/ Signed-off-by: shennetsind <ind@henn.et>
2014-01-08Introducing Hercules Autotrade Persistencyshennetsind1-1/+2
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 Supportshennetsind1-0/+1
Info: http://hercules.ws/board/topic/3614-christmas-patch-gifto/ Signed-off-by: shennetsind <ind@henn.et>
2013-11-18Follow-up to 1f5161a2bd3c7934373146d8cac3c131536758baHaru1-1/+2
- 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-16Introducing Character Ban Support.shennetsind1-1/+2
@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-15Updated `account_data` upgrade filesshennetsind1-0/+1
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-15Added item_db2.sql conversion script to the new structureHaru1-1/+2
- 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>
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-07-02 08:45:49 +0000