Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
2020-05-10 | Update SQL database | Kenpachi Developer | 1 | -5/+17 | |
* 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-02 | Unify size of columns holding string variable values to 255 | Kenpachi Developer | 1 | -3/+4 | |
2020-04-05 | Add UNIQUE KEY to column `login`.`userid` | Kenpachi Developer | 1 | -2/+3 | |
2020-03-22 | Expand column size of `ipbanlist`.`list` from 13 to 39 | Kenpachi Developer | 1 | -1/+2 | |
2020-02-09 | Add expanded barter shop sql scripts | Andrei Karas | 1 | -0/+44 | |
2020-01-13 | Update copyright headers for year 2020 | Haru | 1 | -2/+2 | |
Signed-off-by: Haru <haru@dotalux.com> | |||||
2019-12-15 | Merge pull request #2580 from Asheraf/winmariadbconnector | Haru | 1 | -487/+487 | |
Replace the windows mysql connector with MariaDB C Connector | |||||
2019-11-23 | Fix for https://github.com/HerculesWS/Hercules/issues/2349. | Kenpachi Developer | 1 | -1/+2 | |
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-19 | Fix some sql warnings with mysql servers v8 | Asheraf | 1 | -487/+487 | |
2019-11-17 | Added SQL Files | Dastgir | 1 | -0/+1 | |
2019-10-06 | Updates status changes to also keep their total time | Guilherme Menaldo | 1 | -0/+2 | |
- This allows clients to continue the "timer" display after you login again | |||||
2019-09-22 | Convert castles ids to match client side ids | Asheraf | 1 | -0/+1 | |
2019-06-02 | Use separate field hotkey_rowshift for each hotkeys group | Andrei Karas | 1 | -0/+2 | |
2019-05-05 | Add sql update for guild_expulsion table | Andrei Karas | 1 | -0/+2 | |
Add field char_id into table guild_expulsion. | |||||
2019-04-08 | Fix an issue with named/brewed/forged items getting saved with the wrong ↵ | Ibrahim Zidan | 1 | -0/+1 | |
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-14 | Add support for saving/loading barter shops from sql table. | Andrei Karas | 1 | -0/+10 | |
Also allow add duplicated item id to barter shops if price is different. | |||||
2018-12-14 | Add inventory size field into db and using it in server. | Andrei Karas | 1 | -0/+2 | |
2018-11-13 | Add the available information to the charlog when renaming a character | Haru | 1 | -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-09-23 | Merge pull request #2205 from dastgirp/issue/2187 | Haru | 1 | -28/+30 | |
Fixed issue #2187 | |||||
2018-09-18 | add missing `IF NOT EXISTS` clause to the `char_achievements` table creation ↵ | gumi | 1 | -1/+1 | |
query | |||||
2018-09-02 | Fixed issue #2187 | Dastgir | 1 | -28/+30 | |
card field is changed to INT in tables | |||||
2018-07-28 | Merge pull request #2067 from dastgirp/1-achievement | Haru | 1 | -0/+25 | |
Implemented Achievement System and Title System | |||||
2018-07-24 | Implemented Title System. | Dastgir | 1 | -0/+2 | |
2018-07-24 | Correct wrong attribute used for pet evolution egg hiding | Asheraf | 1 | -0/+1 | |
2018-07-24 | Add SQL Upgrades for Achievements | smokexyz | 1 | -0/+23 | |
Co-authored-by: "Dastgir" <dastgirp@gmail.com> | |||||
2018-06-25 | Implemented Pet Autofeeding | Dastgir | 1 | -0/+2 | |
2018-04-07 | Implementation of Attendance system | Asheraf | 1 | -0/+3 | |
2018-03-08 | Fixed RoDEX mail return not working correctly | Guilherme G. Menaldo | 1 | -1/+3 | |
2018-01-25 | Implementation of Official Clan System | Murilo Pereti Tavares | 1 | -0/+4 | |
All official features work including the autokick for inactive members And the system is completely customizable. | |||||
2017-11-18 | Implement Homunculus autofeeding | Asheraf | 1 | -0/+2 | |
2017-07-30 | Implementation of RoDEX | KirieZ | 1 | -1/+54 | |
2017-04-04 | Implementation of Item Options System. | Smokexyz | 1 | -9/+71 | |
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-26 | zenylog missing type 'K' for Bank Transactions | Smokexyz | 1 | -0/+1 | |
Fixes bug filed here - http://herc.ws/board/topic/13618-db-error-data-truncated-zenylog/ | |||||
2016-10-22 | Added Summoner Class. | Dastgir Pojee | 1 | -1/+3 | |
(Only Placeholder, other things related to summoner will follow-up soon) Added SQL-Upgrade: Added `class` column in charlog | |||||
2016-07-08 | Add sql upgrade scripts for convert date/datetime default values. | Andrei Karas | 1 | -0/+2 | |
2016-07-07 | Replace in sql files fields with default date/datetime into default NULL. | Andrei Karas | 1 | -6/+6 | |
2016-03-14 | Add missing update into main.sql. | Andrei Karas | 1 | -0/+1 | |
2016-01-09 | typo fix in main.sql | Dastgir | 1 | -1/+1 | |
2016-01-05 | Fix battle config Hp/Sp overflow value | AnnieRuru | 1 | -5/+6 | |
- 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-05 | Added Support for BodyStyle | Dastgir | 1 | -0/+2 | |
Closes #974 as merged | |||||
2015-12-15 | Added GPL-compliant header to sql files | Haru | 1 | -0/+19 | |
Signed-off-by: Haru <haru@dotalux.com> | |||||
2015-09-17 | Added redundancy to some SQL statements. | GammCrucis | 1 | -35/+34 | |
Closes #641 Signed-off-by: Haru <haru@dotalux.com> | |||||
2015-08-27 | Hotkey Rotate Packet Implemented | Dastgir | 1 | -0/+2 | |
2015-08-10 | Corrected an issue with the last SQL update | Haru | 1 | -0/+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-09 | Removed unused tables sstatus and interreg | Haru | 1 | -20/+0 | |
Signed-off-by: Haru <haru@dotalux.com> | |||||
2015-07-08 | Update Unique ID system to match official now it cover all cash items ↵ | Ibrahim Hossam | 1 | -0/+1 | |
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 ). | |||||
2014-11-04 | Added missing sql_updates query in main.sql | dastgir | 1 | -0/+1 | |
2014-11-03 | Introducing 2014-10-22, Roulette and Per-Char Gender! | shennetsind | 1 | -0/+1 | |
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-02 | Fixes wrong data type in SQL for base_exp,base_drop and base_death. | Dastgir | 1 | -3/+4 | |
2014-07-17 | Fixed minor issues in the sql files from 3ecf877b | Haru | 1 | -11/+11 | |
Signed-off-by: Haru <haru@dotalux.com> |