diff options
| author | Smokexyz <sagunkho@hotmail.com> | 2017-03-02 19:24:48 +0800 |
|---|---|---|
| committer | Smokexyz <sagunkho@hotmail.com> | 2017-04-04 13:38:16 +0800 |
| commit | 974222a8d3f189083205bf5d330de04a43226ad3 (patch) | |
| tree | b78280b9dad90616196ee37c3992c3e46962b906 /sql-files/logs.sql | |
| parent | 20145c61053479b9acd8ed50c75a80c2a861e349 (diff) | |
| download | hercules-974222a8d3f189083205bf5d330de04a43226ad3.tar.gz hercules-974222a8d3f189083205bf5d330de04a43226ad3.tar.bz2 hercules-974222a8d3f189083205bf5d330de04a43226ad3.tar.xz hercules-974222a8d3f189083205bf5d330de04a43226ad3.zip | |
Implementation of Item Options System.
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)
Diffstat (limited to 'sql-files/logs.sql')
| -rw-r--r-- | sql-files/logs.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql-files/logs.sql b/sql-files/logs.sql index 82c1c944c..c75fc37d2 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -152,6 +152,16 @@ CREATE TABLE IF NOT EXISTS `picklog` ( `card1` INT(11) NOT NULL DEFAULT '0', `card2` INT(11) NOT NULL DEFAULT '0', `card3` INT(11) NOT NULL DEFAULT '0', + `opt_idx0` smallint(5) unsigned NOT NULL default '0', + `opt_val0` smallint(5) unsigned NOT NULL default '0', + `opt_idx1` smallint(5) unsigned NOT NULL default '0', + `opt_val1` smallint(5) unsigned NOT NULL default '0', + `opt_idx2` smallint(5) unsigned NOT NULL default '0', + `opt_val2` smallint(5) unsigned NOT NULL default '0', + `opt_idx3` smallint(5) unsigned NOT NULL default '0', + `opt_val3` smallint(5) unsigned NOT NULL default '0', + `opt_idx4` smallint(5) unsigned NOT NULL default '0', + `opt_val4` smallint(5) unsigned NOT NULL default '0', `unique_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `map` VARCHAR(11) NOT NULL DEFAULT '', PRIMARY KEY (`id`), |