summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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>
2017-04-09ItemDB SQL SyncHercules.ws3-16221/+16224
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-04-09Merge pull request #1598 from Smokexyz/IROHaru4-9/+189
Implementation of Item Options System.
2017-04-04Implementation of Item Options System.Smokexyz4-9/+189
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)
2017-03-14ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>