From 974222a8d3f189083205bf5d330de04a43226ad3 Mon Sep 17 00:00:00 2001
From: Smokexyz <sagunkho@hotmail.com>
Date: Thu, 2 Mar 2017 19:24:48 +0800
Subject: 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)
---
 sql-files/logs.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'sql-files/logs.sql')

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`),
-- 
cgit v1.2.3-60-g2f50

