Ionuţ M. scrie: ↑10 Feb 2021, 01:05 ctrl+q in navicat si ruleaza asta, reboot si testeaza.

ABBC3_SPOILER_SHOW

-- ----------------------------
-- Table structure for offline_shop_npc
-- ----------------------------
DROP TABLE IF EXISTS `offline_shop_npc`;
CREATE TABLE `offline_shop_npc` (
`owner_id` int(11) NOT NULL DEFAULT '0',
`sign` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`x` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`z` int(11) DEFAULT NULL,
`mapIndex` int(11) DEFAULT NULL,
`channel` int(2) DEFAULT NULL,
PRIMARY KEY (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

daca iti cere si "offline_shop_item"
Baga si asta

ABBC3_SPOILER_SHOW

-- ----------------------------
-- Table structure for offline_shop_item
-- ----------------------------
DROP TABLE IF EXISTS `offline_shop_item`;
CREATE TABLE `offline_shop_item` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int(11) unsigned NOT NULL DEFAULT '0',
`pos` smallint(5) unsigned NOT NULL DEFAULT '0',
`count` tinyint(3) unsigned NOT NULL DEFAULT '0',
`vnum` int(11) unsigned NOT NULL DEFAULT '0',
`socket0` int(10) unsigned NOT NULL DEFAULT '0',
`socket1` int(10) unsigned NOT NULL DEFAULT '0',
`socket2` int(10) unsigned NOT NULL DEFAULT '0',
`socket3` int(10) unsigned NOT NULL DEFAULT '0',
`socket4` int(10) unsigned NOT NULL DEFAULT '0',
`socket5` int(10) unsigned NOT NULL DEFAULT '0',
`attrtype0` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue0` smallint(6) NOT NULL DEFAULT '0',
`attrtype1` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue1` smallint(6) NOT NULL DEFAULT '0',
`attrtype2` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue2` smallint(6) NOT NULL DEFAULT '0',
`attrtype3` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue3` smallint(6) NOT NULL DEFAULT '0',
`attrtype4` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue4` smallint(6) NOT NULL DEFAULT '0',
`attrtype5` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue5` smallint(6) NOT NULL DEFAULT '0',
`attrtype6` tinyint(4) NOT NULL DEFAULT '0',
`attrvalue6` smallint(6) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '0',
`status` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `owner_id_idx` (`owner_id`),
KEY `item_vnum_index` (`vnum`)
) ENGINE=MyISAM AUTO_INCREMENT=330000006 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;