summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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>
2017-01-03Merge pull request #1491 from Smokexyz/patch-1Ibrahem Hossam4-1/+26
zenylog missing type 'K' for Bank Transactions
2017-01-02MobDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2017-01-02ItemDB SQL SyncHercules.ws3-3/+3
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-11-21ItemDB SQL SyncHercules.ws2-1279/+1284
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-11-08ItemDB SQL SyncHercules.ws1-40/+40
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-11-02ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-26zenylog missing type 'K' for Bank TransactionsSmokexyz4-1/+26
Fixes bug filed here - http://herc.ws/board/topic/13618-db-error-data-truncated-zenylog/
2016-10-22ItemDB SQL SyncHercules.ws2-0/+47
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-22Added Summoner Class.Dastgir Pojee3-1/+27
(Only Placeholder, other things related to summoner will follow-up soon) Added SQL-Upgrade: Added `class` column in charlog
2016-10-16ItemDB SQL SyncHercules.ws2-11/+11
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-07ItemDB SQL SyncHercules.ws1-18/+18
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-05ItemDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-03ItemDB SQL SyncHercules.ws3-7/+7
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-10-02ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-09-02ItemDB SQL SyncHercules.ws2-21/+21
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-08-26MobDB SQL SyncHercules.ws1-0/+13
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-08-26ItemDB SQL SyncHercules.ws1-0/+1
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-08-17MobDB SQL SyncHercules.ws1-0/+8
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-08-17ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-08-02MobDB SQL SyncHercules.ws1-0/+5
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-07-20MobDB SQL SyncHercules.ws1-15/+24
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-07-20ItemDB SQL SyncHercules.ws1-3/+12
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-07-18ItemDB SQL SyncHercules.ws1-4/+4
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-07-11ItemDB SQL SyncHercules.ws1-0/+13
Signed-off-by: HerculesWSAPI <dev@herc.ws>
2016-07-09MobDB SQL SyncHercules.ws2-2687/+2687
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-07-09ItemDB SQL SyncHercules.ws2-16145/+16145
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-07-08Add sql upgrade scripts for convert date/datetime default values.Andrei Karas8-0/+113
2016-07-07Replace in sql files fields with default date/datetime into default NULL.Andrei Karas2-14/+14
2016-07-02MobDB SQL SyncHercules.ws3-0/+6
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-07-02ItemDB SQL SyncHercules.ws3-0/+6
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-03-18Re-generated mob_skill_db*.sqlHaru2-60/+60
Fixes #1180 Signed-off-by: Haru <haru@dotalux.com>
2016-03-14Add missing update into main.sql.Andrei Karas1-0/+1
2016-03-14ItemDB SQL SyncHercules.ws2-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-03-12Corrected header in the latest SQL upgradeHaru1-1/+1
Follow-up to ca5f133 Signed-off-by: Haru <haru@dotalux.com>
2016-03-10Update sql scripts.Andrei Karas4-2/+25
2016-03-06ItemDB SQL SyncHercules.ws2-16146/+16146
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-03-06Added support for the textual "Job" field to the itemdb2sql converterHaru2-2/+2
Signed-off-by: Haru <haru@dotalux.com>
2016-03-06ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-03-01ItemDB SQL SyncHercules.ws2-4/+4
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-02-29MobDB SQL SyncHercules.ws1-5/+5
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-02-28MobDB SQL SyncHercules.ws3-5/+5
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2016-02-21ItemDB SQL SyncHercules.ws2-3305/+3305
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>