(Resolvido)ERRO GUILD POINTS Query

[mullino 39]

OLA GALERINHA DO TK 

Estou com um Problema no guild points tabela Query toda vez q execulta o comando !guildpoints nao da certo e aparece esse eerro na distro

 

Message: Unknown column 'last_execute_points' in 'field list'
[Error - mysql_store_result] Query: SELECT `last_execute_points` FROM `guilds` W
HERE id = '8'
Message: Unknown column 'last_execute_points' in 'field list'

 Aguem pode me ajudar

+REP

 

[Vodkart 2156]

executa no seu banco de dados

 

                 ALTER TABLE `accounts` ADD `guild_points` INTEGER(11) NOT NULL DEFAULT 0;
                ALTER TABLE `accounts` ADD `guild_points_stats` INT NOT NULL DEFAULT '0';
                 ALTER TABLE `guilds` ADD `last_execute_points` INT NOT NULL DEFAULT '0';
                  CREATE TABLE `z_shopguild_offer` (
                        `id` int(11) NOT NULL auto_increment,
                        `points` int(11) NOT NULL default '0',
                        `itemid1` int(11) NOT NULL default '0',
                        `count1` int(11) NOT NULL default '0',
                        `itemid2` int(11) NOT NULL default '0',
                        `count2` int(11) NOT NULL default '0',
                        `offer_type` varchar(255) default NULL,
                        `offer_description` text NOT NULL,
                        `offer_name` varchar(255) NOT NULL,
                        `pid` INT(11) NOT NULL DEFAULT '0',
                  PRIMARY KEY (`id`))
                  CREATE TABLE `z_shopguild_history_item` (
                        `id` int(11) NOT NULL auto_increment,
                        `to_name` varchar(255) NOT NULL default '0',
                        `to_account` int(11) NOT NULL default '0',
                        `from_nick` varchar(255) NOT NULL,
                        `from_account` int(11) NOT NULL default '0',
                        `price` int(11) NOT NULL default '0',
                        `offer_id` int(11) NOT NULL default '0',
                        `trans_state` varchar(255) NOT NULL,
                        `trans_start` int(11) NOT NULL default '0',
                        `trans_real` int(11) NOT NULL default '0',
                  PRIMARY KEY (`id`))
                  CREATE TABLE `z_shopguild_history_pacc` (
                        `id` int(11) NOT NULL auto_increment,
                        `to_name` varchar(255) NOT NULL default '0',
                        `to_account` int(11) NOT NULL default '0',
                        `from_nick` varchar(255) NOT NULL,
                        `from_account` int(11) NOT NULL default '0',
                        `price` int(11) NOT NULL default '0',
                        `pacc_days` int(11) NOT NULL default '0',
                        `trans_state` varchar(255) NOT NULL,
                        `trans_start` int(11) NOT NULL default '0',
                        `trans_real` int(11) NOT NULL default '0',
                  PRIMARY KEY (`id`))

 

[mullino 39]

Obrigado Vodcart Funcionouu perfeitamente

  Em 05/04/2018 em 18:21, Vodkart disse:

executa no seu banco de dados

 

                 ALTER TABLE `accounts` ADD `guild_points` INTEGER(11) NOT NULL DEFAULT 0;
                ALTER TABLE `accounts` ADD `guild_points_stats` INT NOT NULL DEFAULT '0';
                 ALTER TABLE `guilds` ADD `last_execute_points` INT NOT NULL DEFAULT '0';
                  CREATE TABLE `z_shopguild_offer` (
                        `id` int(11) NOT NULL auto_increment,
                        `points` int(11) NOT NULL default '0',
                        `itemid1` int(11) NOT NULL default '0',
                        `count1` int(11) NOT NULL default '0',
                        `itemid2` int(11) NOT NULL default '0',
                        `count2` int(11) NOT NULL default '0',
                        `offer_type` varchar(255) default NULL,
                        `offer_description` text NOT NULL,
                        `offer_name` varchar(255) NOT NULL,
                        `pid` INT(11) NOT NULL DEFAULT '0',
                  PRIMARY KEY (`id`))
                  CREATE TABLE `z_shopguild_history_item` (
                        `id` int(11) NOT NULL auto_increment,
                        `to_name` varchar(255) NOT NULL default '0',
                        `to_account` int(11) NOT NULL default '0',
                        `from_nick` varchar(255) NOT NULL,
                        `from_account` int(11) NOT NULL default '0',
                        `price` int(11) NOT NULL default '0',
                        `offer_id` int(11) NOT NULL default '0',
                        `trans_state` varchar(255) NOT NULL,
                        `trans_start` int(11) NOT NULL default '0',
                        `trans_real` int(11) NOT NULL default '0',
                  PRIMARY KEY (`id`))
                  CREATE TABLE `z_shopguild_history_pacc` (
                        `id` int(11) NOT NULL auto_increment,
                        `to_name` varchar(255) NOT NULL default '0',
                        `to_account` int(11) NOT NULL default '0',
                        `from_nick` varchar(255) NOT NULL,
                        `from_account` int(11) NOT NULL default '0',
                        `price` int(11) NOT NULL default '0',
                        `pacc_days` int(11) NOT NULL default '0',
                        `trans_state` varchar(255) NOT NULL,
                        `trans_start` int(11) NOT NULL default '0',
                        `trans_real` int(11) NOT NULL default '0',
                  PRIMARY KEY (`id`))

 

Expand   Mostrar mais  

 

ae vodcart agora nao ta entregando os items mais nao nem o shop normal!

compra mas nao entrega ao player

ja arrumei era so relogar o ot dhuasdhasuhdasu descupa ae