summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2019-06-02Use separate field hotkey_rowshift for each hotkeys groupAndrei Karas3-0/+25
2019-06-01MobDB SQL SyncHercules.ws1-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-05-31ItemDB SQL SyncHercules.ws1-0/+6
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-05-05Add sql update for guild_expulsion tableAndrei Karas3-0/+27
Add field char_id into table guild_expulsion.
2019-04-08Fix an issue with named/brewed/forged items getting saved with the wrong ↵Ibrahim Zidan3-0/+31
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-04-07MobDB SQL SyncHercules.ws2-125/+125
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-01-14Add support for saving/loading barter shops from sql table.Andrei Karas3-0/+40
Also allow add duplicated item id to barter shops if price is different.
2019-01-13MobDB SQL SyncHercules.ws6-6/+6
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-01-13ItemDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-12-16ItemDB SQL SyncHercules.ws2-0/+2
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-12-14Add inventory size field into db and using it in server.Andrei Karas3-0/+27
2018-11-13Add the available information to the charlog when renaming a characterHaru1-1/+1
All the necessary information was already available (charlog fields are part of the shortdata, which is already loaded by `char_rename_char_sql()`), but it wasn't used by the charlog insert query. Signed-off-by: Haru <haru@dotalux.com>
2018-10-22ItemDB SQL SyncHercules.ws2-0/+985
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-09-23Merge pull request #2205 from dastgirp/issue/2187Haru3-28/+94
Fixed issue #2187
2018-09-23MobDB SQL SyncHercules.ws3-7444/+7749
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-09-18add missing `IF NOT EXISTS` clause to the `char_achievements` table creation ↵gumi1-1/+1
query
2018-09-02Fixed issue #2187Dastgir3-28/+94
card field is changed to INT in tables
2018-07-28MobDB SQL SyncHercules.ws1-0/+8
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-07-28ItemDB SQL SyncHercules.ws2-1/+18
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-07-28Merge pull request #2067 from dastgirp/1-achievementHaru4-0/+91
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-25Merge pull request #2117 from HerculesWS/seaottercard_fixHaru2-2/+2
Fix Sea-Otter Card not increasing Sushi Heal Rate
2018-07-25ItemDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-07-24Implemented Title System.Dastgir3-0/+27
2018-07-24Correct wrong attribute used for pet evolution egg hidingAsheraf3-0/+24
2018-07-24Add SQL Upgrades for Achievementssmokexyz3-0/+64
Co-authored-by: "Dastgir" <dastgirp@gmail.com>
2018-07-23ItemDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-07-03Fix Sea-Otter Card not increasing Sushi Heal Rateskyleo2-2/+2
Fixes Issue #2116
2018-06-29ItemDB SQL SyncHercules.ws1-0/+29
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-06-25Implemented Pet AutofeedingDastgir3-0/+27
2018-06-04ItemDB SQL SyncHercules.ws2-0/+10
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-04-07Merge pull request #1990 from Asheraf/attendance_uiHaru3-0/+28
Implementation of Attendance system
2018-04-07ItemDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-04-07Implementation of Attendance systemAsheraf3-0/+28
2018-04-03ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-03-08Fixed RoDEX mail return not working correctlyGuilherme G. Menaldo3-1/+10
2018-01-25Implementation of Official Clan SystemMurilo Pereti Tavares5-1/+54
All official features work including the autokick for inactive members And the system is completely customizable.
2018-01-09MobDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2018-01-09ItemDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-11-18Implement Homunculus autofeedingAsheraf3-0/+9
2017-09-17Item DB SQL UpdateHaru1-27/+27
Signed-off-by: Haru <haru@dotalux.com>
2017-09-17Item DB SQL UpdateHaru1-1/+1
Signed-off-by: Haru <haru@dotalux.com>
2017-09-17Item DB SQL UpdateHaru3-16224/+16227
Signed-off-by: Haru <haru@dotalux.com>
2017-07-30Implementation of RoDEXKirieZ3-1/+129
2017-06-13ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-06-03ItemDB SQL SyncHercules.ws2-225/+225
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-06-03ItemDB SQL SyncHercules.ws2-57/+57
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-05-04ItemDB SQL SyncHercules.ws2-12/+12
Signed-off-by: HerculesWSAPI <dev@herc.ws>
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-21ItemDB SQL SyncHercules.ws2-50/+50
Signed-off-by: HerculesWSAPI <dev@herc.ws>
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-06-01 23:10:26 +0000