summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
AgeCommit message (Collapse)AuthorFilesLines
2019-06-02Use separate field hotkey_rowshift for each hotkeys groupAndrei Karas2-0/+23
2019-05-05Add sql update for guild_expulsion tableAndrei Karas2-0/+25
Add field char_id into table guild_expulsion.
2019-04-08Fix an issue with named/brewed/forged items getting saved with the wrong ↵Ibrahim Zidan2-0/+30
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 Karas2-0/+30
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 Karas2-0/+25
2018-09-02Fixed issue #2187Dastgir2-0/+64
card field is changed to INT in tables
2018-07-28Merge pull request #2067 from dastgirp/1-achievementHaru3-0/+66
Implemented Achievement System and Title System
2018-07-26Fix syntax error in sql update file 2018-07-24--03-23.sqlAndrei Karas1-1/+1
2018-07-24Implemented Title System.Dastgir2-0/+25
2018-07-24Correct wrong attribute used for pet evolution egg hidingAsheraf2-0/+23
2018-07-24Add SQL Upgrades for Achievementssmokexyz2-0/+41
Co-authored-by: "Dastgir" <dastgirp@gmail.com>
2018-06-25Implemented Pet AutofeedingDastgir2-0/+25
2018-04-07Implementation of Attendance systemAsheraf2-0/+25
2018-03-08Fixed RoDEX mail return not working correctlyGuilherme G. Menaldo2-0/+7
2018-01-25Implementation of Official Clan SystemMurilo Pereti Tavares3-0/+49
All official features work including the autokick for inactive members And the system is completely customizable.
2017-11-18Implement Homunculus autofeedingAsheraf2-0/+7
2017-07-30Implementation of RoDEXKirieZ2-0/+75
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>
2017-04-04Implementation of Item Options System.Smokexyz2-0/+108
Allows the infusing of equipments with bonus item options. This feature is constrained to clients of packet versions greater than or equal to `20150226`. Item Options and their effects are defined server-side in `db/item_options.conf` and client side in `data/luafiles514/lua files/datainfo/addrandomoptionnametable.lub` The ID of the option must tally with the correct index of the description provided in the client side lua file to avoid bugs. IT_OPT_* keys and MAX_ITEM_OPTIONS macro are also exported from the source as constants. An additional flag `disable_options` has been added to sql, and as `DisableOptions: true/false (boolean, defaults to false !!for equipments only!!)` to item_db.conf files. Script commands documentation is also included. SQL file updates are included. Credits: [Smokexyz](https://github.com/Smokexyz) Style and Script Fixes by [Asheraf](https://github.com/Asheraf) Initial design Idea by [secretdataz](https://github.com/secretdataz)
2016-10-26zenylog missing type 'K' for Bank TransactionsSmokexyz2-0/+24
Fixes bug filed here - http://herc.ws/board/topic/13618-db-error-data-truncated-zenylog/
2016-10-22Added Summoner Class.Dastgir Pojee2-0/+24
(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 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.
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-07-01 05:49:46 +0000