Bug Stein

[KillHumans]

I can't put stone at weaphon/armour.


What I need to change at the database?


Thank.

[lfcmaus]

last field set 3 see it on a standard querry

[KillHumans]

I have socket_pct at 3 (database) in the armor, but I can't add stone at the armor.

query example 1 stone:

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `item_proto_copy`;
CREATE TABLE `item_proto_copy` (
`vnum` int(11) unsigned NOT NULL default '0',
`name` varbinary(200) NOT NULL default 'Noname ',
`locale_name` varbinary(24) NOT NULL default 'Noname ',
`type` tinyint(2) NOT NULL default '0',
`subtype` tinyint(2) NOT NULL default '0',
`weight` tinyint(3) default '0',
`size` tinyint(3) default '0',
`antiflag` int(11) default '0',
`flag` int(11) default '0',
`wearflag` int(11) default '0',
`immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON', 'TERROR') NOT NULL default '',
`gold` int(11) default '0',
`shop_buy_price` int(10) unsigned NOT NULL default '0',
`refined_vnum` int(10) unsigned NOT NULL default '0',
`refine_set` smallint(11) unsigned NOT NULL default '0',
`refine_set2` smallint(5) unsigned NOT NULL default '0',
`magic_pct` tinyint(4) NOT NULL default '0',
`limittype0` tinyint(4) default '0',
`limitvalue0` int(11) default '0',
`limittype1` tinyint(4) default '0',
`limitvalue1` int(11) default '0',
`applytype0` tinyint(4) default '0',
`applyvalue0` int(11) default '0',
`applytype1` tinyint(4) default '0',
`applyvalue1` int(11) default '0',
`applytype2` tinyint(4) default '0',
`applyvalue2` int(11) default '0',
`value0` int(11) default '0',
`value1` int(11) default '0',
`value2` int(11) default '0',
`value3` int(11) default '0',
`value4` int(11) default '0',
`value5` int(11) default '0',
`socket0` tinyint(4) default '-1',
`socket1` tinyint(4) default '-1',
`socket2` tinyint(4) default '-1',
`socket3` tinyint(4) default '-1',
`socket4` tinyint(4) default '-1',
`socket5` tinyint(4) default '-1',
`specular` tinyint(4) NOT NULL default '0',
`socket_pct` tinyint(4) NOT NULL default '0',
`addon_type` smallint(6) NOT NULL default '0',
PRIMARY KEY (`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

INSERT INTO `item_proto_copy` VALUES ('28530', 0xC5F5BFB5BCAE2B3520202020202020202020202020202020 , 0x50656472612064612050656E65747261E7E36F2B35, '10', '0', '0', '1', '0', '0', '16', '', '80000', '80000', '0', '704', '0', '0', '0', '0', '0', '0', '16', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

Thank.