summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2020-05-27MobDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-05-10Update SQL databaseKenpachi Developer3-5/+61
* 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-10ItemDB SQL SyncHercules.ws2-10/+10
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-05-10Merge pull request #2705 from Kenpachi2k13/string_var_sizeHaru3-3/+30
Cap string variable value length and unify corresponding SQL columns size
2020-05-03MobDB SQL SyncHercules.ws2-0/+39
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-05-03ItemDB SQL SyncHercules.ws1-2/+48
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-05-02Unify size of columns holding string variable values to 255Kenpachi Developer3-3/+30
2020-04-05Add UNIQUE KEY to column `login`.`userid`Kenpachi Developer3-2/+28
2020-04-05Merge pull request #2665 from Kenpachi2k13/alter_ipbanlist_tableHaru3-1/+26
Expand column size of `ipbanlist`.`list` from 13 to 39
2020-04-05ItemDB SQL SyncHercules.ws2-9/+18
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-03-22Expand column size of `ipbanlist`.`list` from 13 to 39Kenpachi Developer3-1/+26
2020-03-09ItemDB SQL SyncHercules.ws2-21/+21
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-03-08ItemDB SQL SyncHercules.ws2-14/+14
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-02-10ItemDB SQL SyncHercules.ws2-201/+201
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-02-09MobDB SQL SyncHercules.ws1-0/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-02-09ItemDB SQL SyncHercules.ws1-7/+17
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-02-09ItemDB SQL SyncHercules.ws2-10/+10
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-02-09Add expanded barter shop sql scriptsAndrei Karas3-0/+108
2020-01-13Update copyright headers for year 2020Haru76-84/+84
Signed-off-by: Haru <haru@dotalux.com>
2020-01-12ItemDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-01-12MobDB SQL SyncHercules.ws6-6/+6
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2020-01-12ItemDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-12-15Merge pull request #2580 from Asheraf/winmariadbconnectorHaru2-532/+532
Replace the windows mysql connector with MariaDB C Connector
2019-11-23Fix for https://github.com/HerculesWS/Hercules/issues/2349.Kenpachi Developer3-1/+26
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-19Fix some sql warnings with mysql servers v8Asheraf2-532/+532
2019-11-18Fix syntax errors in sql scriptsAndrei Karas2-5/+5
2019-11-17Added SQL FilesDastgir4-1/+26
2019-10-18Merge pull request #2551 from guilherme-gm/201910-fix-sc-timesHaru3-0/+31
Fixes status changes effect timer when relogging
2019-10-18ItemDB SQL SyncHercules.ws2-2/+2
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-10-06Updates status changes to also keep their total timeGuilherme Menaldo3-0/+31
- This allows clients to continue the "timer" display after you login again
2019-09-23MobDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-09-23ItemDB SQL SyncHercules.ws2-0/+1234
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-09-23ItemDB SQL SyncHercules.ws2-18/+18
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2019-09-22Implementation of new guild ui client featuresAsheraf1-1/+1
2019-09-22Convert castles ids to match client side idsAsheraf3-0/+97
2019-07-28ItemDB SQL SyncHercules.ws1-10/+10
Signed-off-by: HerculesWSAPI <dev@herc.ws>
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