diff options
| author | shennetsind <ind@henn.et> | 2013-10-27 14:58:44 -0200 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-10-27 15:00:37 -0200 |
| commit | baef78f7954fa4e6fa2449f2c7de92a901c7f5f3 (patch) | |
| tree | 090c5aac3afd217d5b11752049a2517c4c58219c /sql-files | |
| parent | 8629562655cfcbd6aef97307e3e0c078235619ff (diff) | |
| download | hercules-baef78f7954fa4e6fa2449f2c7de92a901c7f5f3.tar.gz hercules-baef78f7954fa4e6fa2449f2c7de92a901c7f5f3.tar.bz2 hercules-baef78f7954fa4e6fa2449f2c7de92a901c7f5f3.tar.xz hercules-baef78f7954fa4e6fa2449f2c7de92a901c7f5f3.zip | |
Shadows System Base
http://hercules.ws/board/topic/581-implement-the-shadows-system/
Special Thanks to Yommy for all the client data, Haru for making it possible to get it out and rosfus for the details on the feature.
Shadows Feature requires packetver 20120925 or newer.
----------
Also: Updated all packets related to the shadows system, improved memory/processing of inventory/cart/storage/viewequip packets
Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 9 | ||||
| -rw-r--r-- | sql-files/upgrades/2013-10-27--16-47.sql | 6 | ||||
| -rw-r--r-- | sql-files/upgrades/index.txt | 3 |
3 files changed, 13 insertions, 5 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index 1f654ed14..8bd28c414 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `cart_inventory` ( `char_id` int(11) NOT NULL default '0', `nameid` int(11) NOT NULL default '0', `amount` int(11) NOT NULL default '0', - `equip` mediumint(8) unsigned NOT NULL default '0', + `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) NOT NULL default '0', @@ -332,7 +332,7 @@ CREATE TABLE IF NOT EXISTS `guild_storage` ( `guild_id` int(11) unsigned NOT NULL default '0', `nameid` int(11) unsigned NOT NULL default '0', `amount` int(11) unsigned NOT NULL default '0', - `equip` mediumint(8) unsigned NOT NULL default '0', + `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) unsigned NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', @@ -395,7 +395,7 @@ CREATE TABLE IF NOT EXISTS `inventory` ( `char_id` int(11) unsigned NOT NULL default '0', `nameid` int(11) unsigned NOT NULL default '0', `amount` int(11) unsigned NOT NULL default '0', - `equip` mediumint(8) unsigned NOT NULL default '0', + `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', @@ -659,6 +659,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474); INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541); INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728); INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003); +INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428); -- -- Table structure for table `sstatus` @@ -679,7 +680,7 @@ CREATE TABLE IF NOT EXISTS `storage` ( `account_id` int(11) unsigned NOT NULL default '0', `nameid` int(11) unsigned NOT NULL default '0', `amount` smallint(11) unsigned NOT NULL default '0', - `equip` mediumint(8) unsigned NOT NULL default '0', + `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) unsigned NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', diff --git a/sql-files/upgrades/2013-10-27--16-47.sql b/sql-files/upgrades/2013-10-27--16-47.sql new file mode 100644 index 000000000..e1a4a28f2 --- /dev/null +++ b/sql-files/upgrades/2013-10-27--16-47.sql @@ -0,0 +1,6 @@ +#1382892428 +ALTER TABLE `inventory` MODIFY `equip` int(11) unsigned NOT NULL default '0'; +ALTER TABLE `storage` MODIFY `equip` int(11) unsigned NOT NULL default '0'; +ALTER TABLE `cart_inventory` MODIFY `equip` int(11) unsigned NOT NULL default '0'; +ALTER TABLE `guild_storage` MODIFY `equip` int(11) unsigned NOT NULL default '0'; +INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);
\ No newline at end of file diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index 2996a07f0..4afcc5a0d 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -5,4 +5,5 @@ 2013-03-09--01-56.sql 2013-04-16--01-24.sql 2013-10-09--21-38.sql -2013-10-10--16-36.sql
\ No newline at end of file +2013-10-10--16-36.sql +2013-10-27--16-47.sql
\ No newline at end of file |