summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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>
2017-01-28ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>