Salut am o problema la shop off deci deschid shop-ul offline si cand dau adauga item si adaug un item in offline shop imi pica sv si in sysser ch1 imi apare asta
SYSERR: Aug 25 05:27:10 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM offline_shop_item WHERE owner_id = 31284 and pos = 53' at line 1
query: SELECT pos,count,vnum,price,socket0,socket1,socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, FROM offline_shop_item WHERE owner_id = 31284 and pos = 53
problema shop offline
Tu in sursa ai pentru shop offline sa iti selecteze din tabelul 'offline shop' si bonusurile obiectelor (applyvalue0, applytype 0..pana la 7), iar in navicat tu nu ai aceste coloane cel mai probabil.
Du-te in winscp/.../mysql/player/. Stergi tot ce tine de offline shop (cel mai probabil ai 4 fisiere sau 6).
Apoi mergi in navicat, dai un refresh si rulezi acest query:
Aici:
Lasi 'bigint' daca ai yang nelimitat pe server sau modifici in 'int' daca ai limita clasica (2.000.000.000 yang)
Du-te in winscp/.../mysql/player/. Stergi tot ce tine de offline shop (cel mai probabil ai 4 fisiere sau 6).
Apoi mergi in navicat, dai un refresh si rulezi acest query:
Cod: Selectaţi tot
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- 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',
`applytype0` int(4) NOT NULL DEFAULT '0',
`applyvalue0` int(6) NOT NULL DEFAULT '0',
`applytype1` int(4) NOT NULL DEFAULT '0',
`applyvalue1` int(6) NOT NULL DEFAULT '0',
`applytype2` int(4) NOT NULL DEFAULT '0',
`applyvalue2` int(6) NOT NULL DEFAULT '0',
`applytype3` int(4) NOT NULL DEFAULT '0',
`applyvalue3` int(6) NOT NULL DEFAULT '0',
`applytype4` int(4) NOT NULL DEFAULT '0',
`applyvalue4` int(6) NOT NULL DEFAULT '0',
`applytype5` int(4) NOT NULL DEFAULT '0',
`applyvalue5` int(6) NOT NULL DEFAULT '0',
`applytype6` int(4) NOT NULL DEFAULT '0',
`applyvalue6` int(6) NOT NULL DEFAULT '0',
`applytype7` int(4) NOT NULL DEFAULT '0',
`applyvalue7` int(6) NOT NULL DEFAULT '0',
`price` bigint(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;
-- ----------------------------
-- 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=MyISAM DEFAULT CHARSET=latin1;
Cod: Selectaţi tot
`price` bigint(11) NOT NULL DEFAULT '0',
Inactiv de peste 3 zile. Mutat in arhiva probleme si intrebari.
de
Răspunsuri
1 Vizualizări
615
1 Vizualizări
615
de -
- Informaţie
-
Cine este conectat
Utilizatori ce ce navighează pe acest forum: marian261 și 43 vizitatori