Problema shop offline by great

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Deconectat
Avatar utilizator
404Raiden
Nou Venit
Nou Venit
Mesaje: 11
Membru din: 24 Noi 2016
Status: Sunt bine mersi.
Mulțumiri acordate: 0
Mulțumiri primite: 0

Problema shop offline by great

Mesajde 404Raiden » 17 Apr 2018, 13:05

*Problemă: nu apare optiune magazin la great shop offline
Tipologie server: 40k
*Resursă folosită: Great shop offline
*ServerFiles utilizat: Cumparat
*Syserr: Gol peste tot :(
Poză:Imagine
*Detalii suplimentare: Nu mai am idee ce sa ii fac :( :(

Deconectat
Avatar utilizator
darak.darak2
Nivel 2
Nivel 2
Mesaje: 201
Membru din: 17 Feb 2017
Localitate: Guhdermoun
Status: Sunt bine mersi
Server Metin2: www.kor2.ro
Regat: Chunjo
Mulțumiri acordate: 7
Mulțumiri primite: 10
Contact:

Re: Problema shop offline by great

Mesajde darak.darak2 » 17 Apr 2018, 13:07

nu are functile int de numere bagate :|
Imagine


Imagine


Daca te-am ajutat, nu uita sa apesi pe butonul de Like. Multumesc
Ascunde conținutul
Trebuie să fii înregistrat sau logat pentru a vedea acest conținut.

Deconectat
Avatar utilizator
404Raiden
Nou Venit
Nou Venit
Mesaje: 11
Membru din: 24 Noi 2016
Status: Sunt bine mersi.
Mulțumiri acordate: 0
Mulțumiri primite: 0

Re: Problema shop offline by great

Mesajde 404Raiden » 17 Apr 2018, 13:09

darak.darak2 scrie:nu are functile int de numere bagate :|

Nu stii unde sunt sa le pot baga boss ca imi ia mult sa verific iar :(

Deconectat
Avatar utilizator
AndyOpris
Mister Just4Metin
Mister Just4Metin
Mesaje: 422
Membru din: 09 Iun 2015
Status: Pensionat
Server Metin2: -
Regat: Jinno
Mulțumiri acordate: 0
Mulțumiri primite: 149

Re: Problema shop offline by great

Mesajde AndyOpris » 17 Apr 2018, 13:12

Ai bagat partea SQL?
Imagine
Imagine

Deconectat
Avatar utilizator
404Raiden
Nou Venit
Nou Venit
Mesaje: 11
Membru din: 24 Noi 2016
Status: Sunt bine mersi.
Mulțumiri acordate: 0
Mulțumiri primite: 0

Re: Problema shop offline by great

Mesajde 404Raiden » 17 Apr 2018, 13:13

dap

Deconectat
Avatar utilizator
AndyOpris
Mister Just4Metin
Mister Just4Metin
Mesaje: 422
Membru din: 09 Iun 2015
Status: Pensionat
Server Metin2: -
Regat: Jinno
Mulțumiri acordate: 0
Mulțumiri primite: 149

Re: Problema shop offline by great

Mesajde AndyOpris » 17 Apr 2018, 13:14

Ruleaza acest query in tabelul player din mysql:

DROP TABLE IF EXISTS `player_shop`;
CREATE TABLE `player_shop` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`player_id` int(255) NOT NULL,
`shop_vid` int(255) NOT NULL,
`item_count` int(3) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
`status` enum('OK','CLOSED') COLLATE utf8_polish_ci NOT NULL DEFAULT 'OK',
`map_index` int(20) NOT NULL DEFAULT '0',
`x` int(30) NOT NULL DEFAULT '0',
`y` int(30) NOT NULL DEFAULT '0',
`z` int(30) NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_close` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0.0.0.0',
`gold` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
`cash` int(255) NOT NULL DEFAULT '0',
`channel` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`shop_vid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `shop_cost`;
CREATE TABLE `shop_cost` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL DEFAULT '0',
`time_type` enum('day','hour','normal_shop') NOT NULL DEFAULT 'day',
`cost` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12;

-- ----------------------------
-- Records of shop_cost
-- ----------------------------
INSERT INTO `shop_cost` VALUES ('5', '0', 'normal_shop', '5000000');
INSERT INTO `shop_cost` VALUES ('6', '1', 'hour', '100000');
INSERT INTO `shop_cost` VALUES ('7', '2', 'hour', '500000');
INSERT INTO `shop_cost` VALUES ('8', '3', 'hour', '1000000');
INSERT INTO `shop_cost` VALUES ('9', '1', 'day', '1500000');
INSERT INTO `shop_cost` VALUES ('10', '2', 'day', '2000000');
INSERT INTO `shop_cost` VALUES ('11', '3', 'day', '2500000');


DROP TABLE IF EXISTS `shop_limit`;
CREATE TABLE `shop_limit` (
`channel` int(2) DEFAULT NULL,
`map_index` int(11) DEFAULT NULL,
`shop_limit` varchar(255) DEFAULT NULL
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `player_gift`;
CREATE TABLE `player_gift` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`owner_id` int(255) NOT NULL,
`date_add` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_get` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` enum('WAIT','OK') COLLATE utf8_polish_ci NOT NULL DEFAULT 'WAIT',
`from` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
`reason` text COLLATE utf8_polish_ci NOT NULL,
`vnum` int(255) NOT NULL DEFAULT '0',
`count` bigint(255) NOT NULL DEFAULT '1',
`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` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue0` smallint(6) NOT NULL DEFAULT '0',
`applytype1` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue1` smallint(6) NOT NULL DEFAULT '0',
`applytype2` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue2` smallint(6) NOT NULL DEFAULT '0',
`applytype3` int(11) NOT NULL DEFAULT '0',
`applyvalue3` int(11) NOT NULL DEFAULT '0',
`applytype4` int(11) NOT NULL DEFAULT '0',
`applyvalue4` int(11) NOT NULL DEFAULT '0',
`applytype5` int(11) NOT NULL DEFAULT '0',
`applyvalue5` int(11) NOT NULL DEFAULT '0',
`applytype6` int(11) NOT NULL DEFAULT '0',
`applyvalue6` int(11) NOT NULL DEFAULT '0',
`applytype7` int(11) NOT NULL DEFAULT '0',
`applyvalue7` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
ALTER TABLE `player_gift` ADD UNIQUE `id` (`id`);

-- ----------------------------
-- Table structure for player_shop_items
-- ----------------------------
DROP TABLE IF EXISTS `player_shop_items`;
CREATE TABLE `player_shop_items` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`shop_id` int(255) NOT NULL,
`player_id` int(255) NOT NULL DEFAULT '0',
`vnum` int(255) NOT NULL DEFAULT '0',
`count` int(20) NOT NULL DEFAULT '1',
`pos` int(20) NOT NULL DEFAULT '0',
`display_pos` int(20) NOT NULL DEFAULT '0',
`price` bigint(255) 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` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue0` smallint(6) NOT NULL DEFAULT '0',
`applytype1` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue1` smallint(6) NOT NULL DEFAULT '0',
`applytype2` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue2` smallint(6) NOT NULL DEFAULT '0',
`applytype3` int(11) NOT NULL DEFAULT '0',
`applyvalue3` int(11) NOT NULL DEFAULT '0',
`applytype4` int(11) NOT NULL DEFAULT '0',
`applyvalue4` int(11) NOT NULL DEFAULT '0',
`applytype5` int(11) NOT NULL DEFAULT '0',
`applyvalue5` int(11) NOT NULL DEFAULT '0',
`applytype6` int(11) NOT NULL DEFAULT '0',
`applyvalue6` int(11) NOT NULL DEFAULT '0',
`applytype7` int(11) NOT NULL DEFAULT '0',
`applyvalue7` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;


si dupa da un reboot
Imagine
Imagine

Deconectat
Avatar utilizator
404Raiden
Nou Venit
Nou Venit
Mesaje: 11
Membru din: 24 Noi 2016
Status: Sunt bine mersi.
Mulțumiri acordate: 0
Mulțumiri primite: 0

Re: Problema shop offline by great

Mesajde 404Raiden » 17 Apr 2018, 13:21

AndyOpris scrie:Ruleaza acest query in tabelul player din mysql:

DROP TABLE IF EXISTS `player_shop`;
CREATE TABLE `player_shop` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`player_id` int(255) NOT NULL,
`shop_vid` int(255) NOT NULL,
`item_count` int(3) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
`status` enum('OK','CLOSED') COLLATE utf8_polish_ci NOT NULL DEFAULT 'OK',
`map_index` int(20) NOT NULL DEFAULT '0',
`x` int(30) NOT NULL DEFAULT '0',
`y` int(30) NOT NULL DEFAULT '0',
`z` int(30) NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_close` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0.0.0.0',
`gold` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
`cash` int(255) NOT NULL DEFAULT '0',
`channel` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`shop_vid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `shop_cost`;
CREATE TABLE `shop_cost` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL DEFAULT '0',
`time_type` enum('day','hour','normal_shop') NOT NULL DEFAULT 'day',
`cost` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12;

-- ----------------------------
-- Records of shop_cost
-- ----------------------------
INSERT INTO `shop_cost` VALUES ('5', '0', 'normal_shop', '5000000');
INSERT INTO `shop_cost` VALUES ('6', '1', 'hour', '100000');
INSERT INTO `shop_cost` VALUES ('7', '2', 'hour', '500000');
INSERT INTO `shop_cost` VALUES ('8', '3', 'hour', '1000000');
INSERT INTO `shop_cost` VALUES ('9', '1', 'day', '1500000');
INSERT INTO `shop_cost` VALUES ('10', '2', 'day', '2000000');
INSERT INTO `shop_cost` VALUES ('11', '3', 'day', '2500000');


DROP TABLE IF EXISTS `shop_limit`;
CREATE TABLE `shop_limit` (
`channel` int(2) DEFAULT NULL,
`map_index` int(11) DEFAULT NULL,
`shop_limit` varchar(255) DEFAULT NULL
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `player_gift`;
CREATE TABLE `player_gift` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`owner_id` int(255) NOT NULL,
`date_add` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_get` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` enum('WAIT','OK') COLLATE utf8_polish_ci NOT NULL DEFAULT 'WAIT',
`from` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
`reason` text COLLATE utf8_polish_ci NOT NULL,
`vnum` int(255) NOT NULL DEFAULT '0',
`count` bigint(255) NOT NULL DEFAULT '1',
`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` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue0` smallint(6) NOT NULL DEFAULT '0',
`applytype1` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue1` smallint(6) NOT NULL DEFAULT '0',
`applytype2` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue2` smallint(6) NOT NULL DEFAULT '0',
`applytype3` int(11) NOT NULL DEFAULT '0',
`applyvalue3` int(11) NOT NULL DEFAULT '0',
`applytype4` int(11) NOT NULL DEFAULT '0',
`applyvalue4` int(11) NOT NULL DEFAULT '0',
`applytype5` int(11) NOT NULL DEFAULT '0',
`applyvalue5` int(11) NOT NULL DEFAULT '0',
`applytype6` int(11) NOT NULL DEFAULT '0',
`applyvalue6` int(11) NOT NULL DEFAULT '0',
`applytype7` int(11) NOT NULL DEFAULT '0',
`applyvalue7` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
ALTER TABLE `player_gift` ADD UNIQUE `id` (`id`);

-- ----------------------------
-- Table structure for player_shop_items
-- ----------------------------
DROP TABLE IF EXISTS `player_shop_items`;
CREATE TABLE `player_shop_items` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`shop_id` int(255) NOT NULL,
`player_id` int(255) NOT NULL DEFAULT '0',
`vnum` int(255) NOT NULL DEFAULT '0',
`count` int(20) NOT NULL DEFAULT '1',
`pos` int(20) NOT NULL DEFAULT '0',
`display_pos` int(20) NOT NULL DEFAULT '0',
`price` bigint(255) 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` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue0` smallint(6) NOT NULL DEFAULT '0',
`applytype1` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue1` smallint(6) NOT NULL DEFAULT '0',
`applytype2` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue2` smallint(6) NOT NULL DEFAULT '0',
`applytype3` int(11) NOT NULL DEFAULT '0',
`applyvalue3` int(11) NOT NULL DEFAULT '0',
`applytype4` int(11) NOT NULL DEFAULT '0',
`applyvalue4` int(11) NOT NULL DEFAULT '0',
`applytype5` int(11) NOT NULL DEFAULT '0',
`applyvalue5` int(11) NOT NULL DEFAULT '0',
`applytype6` int(11) NOT NULL DEFAULT '0',
`applyvalue6` int(11) NOT NULL DEFAULT '0',
`applytype7` int(11) NOT NULL DEFAULT '0',
`applyvalue7` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;


si dupa da un reboot


Merge acum boss dar sysser client este asta si cum pot inchide magazinul? :O
0417 14:20:57261 :: File "game.py", line 2370, in BINARY_ServerCommand_Run

0417 14:20:57262 :: File "stringCommander.py", line 63, in Run

0417 14:20:57262 :: File "stringCommander.py", line 31, in __call__

0417 14:20:57263 :: File "stringCommander.py", line 20, in __call__

0417 14:20:57264 :: File "game.py", line 2994, in ShopAdd

0417 14:20:57265 :: File "uinewshop.py", line 783, in Load

0417 14:20:57265 :: TypeError
0417 14:20:57266 :: :
0417 14:20:57266 :: SAFE_SetStringEvent() takes exactly 3 arguments (4 given)
0417 14:20:57266 ::

Deconectat
Avatar utilizator
AndyOpris
Mister Just4Metin
Mister Just4Metin
Mesaje: 422
Membru din: 09 Iun 2015
Status: Pensionat
Server Metin2: -
Regat: Jinno
Mulțumiri acordate: 0
Mulțumiri primite: 149

Re: Problema shop offline by great

Mesajde AndyOpris » 17 Apr 2018, 13:26

404Raiden scrie:
AndyOpris scrie:Ruleaza acest query in tabelul player din mysql:

DROP TABLE IF EXISTS `player_shop`;
CREATE TABLE `player_shop` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`player_id` int(255) NOT NULL,
`shop_vid` int(255) NOT NULL,
`item_count` int(3) NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_polish_ci NOT NULL,
`status` enum('OK','CLOSED') COLLATE utf8_polish_ci NOT NULL DEFAULT 'OK',
`map_index` int(20) NOT NULL DEFAULT '0',
`x` int(30) NOT NULL DEFAULT '0',
`y` int(30) NOT NULL DEFAULT '0',
`z` int(30) NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_close` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0.0.0.0',
`gold` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
`cash` int(255) NOT NULL DEFAULT '0',
`channel` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`shop_vid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `shop_cost`;
CREATE TABLE `shop_cost` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL DEFAULT '0',
`time_type` enum('day','hour','normal_shop') NOT NULL DEFAULT 'day',
`cost` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12;

-- ----------------------------
-- Records of shop_cost
-- ----------------------------
INSERT INTO `shop_cost` VALUES ('5', '0', 'normal_shop', '5000000');
INSERT INTO `shop_cost` VALUES ('6', '1', 'hour', '100000');
INSERT INTO `shop_cost` VALUES ('7', '2', 'hour', '500000');
INSERT INTO `shop_cost` VALUES ('8', '3', 'hour', '1000000');
INSERT INTO `shop_cost` VALUES ('9', '1', 'day', '1500000');
INSERT INTO `shop_cost` VALUES ('10', '2', 'day', '2000000');
INSERT INTO `shop_cost` VALUES ('11', '3', 'day', '2500000');


DROP TABLE IF EXISTS `shop_limit`;
CREATE TABLE `shop_limit` (
`channel` int(2) DEFAULT NULL,
`map_index` int(11) DEFAULT NULL,
`shop_limit` varchar(255) DEFAULT NULL
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `player_gift`;
CREATE TABLE `player_gift` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`owner_id` int(255) NOT NULL,
`date_add` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_get` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` enum('WAIT','OK') COLLATE utf8_polish_ci NOT NULL DEFAULT 'WAIT',
`from` varchar(255) COLLATE utf8_polish_ci NOT NULL DEFAULT '0',
`reason` text COLLATE utf8_polish_ci NOT NULL,
`vnum` int(255) NOT NULL DEFAULT '0',
`count` bigint(255) NOT NULL DEFAULT '1',
`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` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue0` smallint(6) NOT NULL DEFAULT '0',
`applytype1` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue1` smallint(6) NOT NULL DEFAULT '0',
`applytype2` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue2` smallint(6) NOT NULL DEFAULT '0',
`applytype3` int(11) NOT NULL DEFAULT '0',
`applyvalue3` int(11) NOT NULL DEFAULT '0',
`applytype4` int(11) NOT NULL DEFAULT '0',
`applyvalue4` int(11) NOT NULL DEFAULT '0',
`applytype5` int(11) NOT NULL DEFAULT '0',
`applyvalue5` int(11) NOT NULL DEFAULT '0',
`applytype6` int(11) NOT NULL DEFAULT '0',
`applyvalue6` int(11) NOT NULL DEFAULT '0',
`applytype7` int(11) NOT NULL DEFAULT '0',
`applyvalue7` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
ALTER TABLE `player_gift` ADD UNIQUE `id` (`id`);

-- ----------------------------
-- Table structure for player_shop_items
-- ----------------------------
DROP TABLE IF EXISTS `player_shop_items`;
CREATE TABLE `player_shop_items` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`shop_id` int(255) NOT NULL,
`player_id` int(255) NOT NULL DEFAULT '0',
`vnum` int(255) NOT NULL DEFAULT '0',
`count` int(20) NOT NULL DEFAULT '1',
`pos` int(20) NOT NULL DEFAULT '0',
`display_pos` int(20) NOT NULL DEFAULT '0',
`price` bigint(255) 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` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue0` smallint(6) NOT NULL DEFAULT '0',
`applytype1` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue1` smallint(6) NOT NULL DEFAULT '0',
`applytype2` tinyint(4) NOT NULL DEFAULT '0',
`applyvalue2` smallint(6) NOT NULL DEFAULT '0',
`applytype3` int(11) NOT NULL DEFAULT '0',
`applyvalue3` int(11) NOT NULL DEFAULT '0',
`applytype4` int(11) NOT NULL DEFAULT '0',
`applyvalue4` int(11) NOT NULL DEFAULT '0',
`applytype5` int(11) NOT NULL DEFAULT '0',
`applyvalue5` int(11) NOT NULL DEFAULT '0',
`applytype6` int(11) NOT NULL DEFAULT '0',
`applyvalue6` int(11) NOT NULL DEFAULT '0',
`applytype7` int(11) NOT NULL DEFAULT '0',
`applyvalue7` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;


si dupa da un reboot


Merge acum boss dar sysser client este asta si cum pot inchide magazinul? :O
0417 14:20:57261 :: File "game.py", line 2370, in BINARY_ServerCommand_Run

0417 14:20:57262 :: File "stringCommander.py", line 63, in Run

0417 14:20:57262 :: File "stringCommander.py", line 31, in __call__

0417 14:20:57263 :: File "stringCommander.py", line 20, in __call__

0417 14:20:57264 :: File "game.py", line 2994, in ShopAdd

0417 14:20:57265 :: File "uinewshop.py", line 783, in Load

0417 14:20:57265 :: TypeError
0417 14:20:57266 :: :
0417 14:20:57266 :: SAFE_SetStringEvent() takes exactly 3 arguments (4 given)
0417 14:20:57266 ::


refa partea de client
Imagine
Imagine

Deconectat
Avatar utilizator
404Raiden
Nou Venit
Nou Venit
Mesaje: 11
Membru din: 24 Noi 2016
Status: Sunt bine mersi.
Mulțumiri acordate: 0
Mulțumiri primite: 0

Re: Problema shop offline by great

Mesajde 404Raiden » 17 Apr 2018, 13:43

Off nici won nu apare dupa ce deschid shop-ul :(((( ca eu am won

Deconectat
Avatar utilizator
Bughy
Helper
Helper
Mesaje: 202
Membru din: 10 Apr 2018
Localitate: Cluj
Reputație: Trial-Helper J4M
Helper J4M
Status: Mega-Image
Server Metin2: Toate =))
Regat: Jinno
Mulțumiri acordate: 2
Mulțumiri primite: 17
Contact:

Re: Problema shop offline by great

Mesajde Bughy » 20 Apr 2018, 13:16

Topic inactiv.
Arhivat
Imagine
Daca te-am ajutat lasa un like :) B-) :ymhug: ;)


Înapoi la “Arhivă Probleme şi Întrebări”

Cine este conectat

Utilizatori ce ce navighează pe acest forum: Bing [Bot] și 29 vizitatori