Shop offline Timp

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
Senju
Nou Venit

Nou Venit
Mesaje: 43
Membru din: 08 Feb 2019, 00:03
Server: Senju II Romania
Aprecieri: 35  
Mulţumiri: 6  
Medalii

*Problemă/Întrebare:Nu imi apare timpul la shop offline
Tipologie server:-
*Resursă folosită:de la turci
*ServerFiles utilizat:Ceva clean
*Syserr:Gol
Poză:Imagine
*Detalii suplimentare:Nu imi apare timpul

Nu imi apare timpul cand dau sa creez magazin. am incercat deja rezolvarea asta : arhiva-prob/problema-shop-offline-great-t72142.html Am rulat acel .sql dar nu am rezolvat .. stie cineva ?

Am rulat acest sql:

Cod: Selectaţi tot

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;
EDIT: tocmai am descoperit ca am acest syserr in server pe channel1

Cod: Selectaţi tot

SYSERR: Jan 19 14:16:37 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.player_shop_items' doesn't exist
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
SYSERR: Jan 19 15:15:51 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.player_shop_items' doesn't exist
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
SYSERR: Jan 19 16:15:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.player_shop_items' doesn't exist
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
Din ce imi dau seama :-? .. imi spune ca nu am tabelul player_shop_items si player_shop in navicat .. dar eu le am :
https://prnt.sc/x7vkkf
Ultima oară modificat 19 Ian 2021, 17:06 de către Senju, modificat de 2 ori în total.
Sus
Avatar utilizator
MapshitoWork
Utilizator interzis !

Utilizator interzis !
Mesaje: 68
Membru din: 28 Iun 2020, 12:38
Regat: Jinno
Aprecieri: 4  
Mulţumiri: 223  
Discord: Copiază ID
Medalii

Iti apare ceva in sysser client?
Sus
Avatar utilizator
R.Sergiu
Nou Venit

Nou Venit
Mesaje: 7
Membru din: 30 Noi 2016, 12:00
Server: Mertin2Relax
Regat: Jinno
Aprecieri: 17  
Mulţumiri: 0
Medalii

query.sql sigur l-ai pus bine?
Sus
Avatar utilizator
Senju
Nou Venit

Nou Venit
Mesaje: 43
Membru din: 08 Feb 2019, 00:03
Server: Senju II Romania
Aprecieri: 35  
Mulţumiri: 6  
Medalii

nu am nimic syserr client. si da cred ca am pus bine query.sql, adica nu l-am pus pe cel din tutorial pentru ca nu imi functiona aveam o eroare. dar l-am adaugat pe acela din topicul de mai sus si a rulat ok mi-a creat tabelele
Sus
Avatar utilizator
Tommy Shelby
Utilizator interzis !

Utilizator interzis !
Mesaje: 432
Membru din: 31 Mai 2015, 20:42
Server: AOG2 soon
Regat: Jinno
Aprecieri: 58  
Mulţumiri: 579  
Discord: Copiază ID
Medalii

Arhivat

[ Postat de pe iPhone ] Imagine
Sus
Închis

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

  • Informaţie

  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 63 vizitatori

+ Anunțul tău aici + Anunțul tău aici + Anunțul tău aici + Anunțul tău aici