Ir para conteúdo
  • 0

Shop Guild instalado,mais não aparece os itens Help


edilson22

Pergunta

http://imageshack.us...s/7/helpfz.png/

 

ERRO AI NA IMAGEM AJUDA!!

JÁ FIZ TUDO IGUAL ESSE TOPICO > http://www.xtibia.co...ebsite-scripts/

 

e a 2º query eu peguei nesse aqui >

http://www.xtibia.co...ionpagina-site/

 

Dessas 3 sql , só a primeira funcionou

Primeira -

 

 

CREATE TABLE IF NOT EXISTS `accounts` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(32) NOT NULL DEFAULT '',

`password` varchar(255) NOT NULL,

`salt` varchar(40) NOT NULL DEFAULT '',

`premdays` int(11) NOT NULL DEFAULT '0',

`lastday` int(10) unsigned NOT NULL DEFAULT '0',

`email` varchar(255) NOT NULL DEFAULT '',

`key` varchar(20) NOT NULL DEFAULT '0',

`blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',

`warnings` int(11) NOT NULL DEFAULT '0',

`group_id` int(11) NOT NULL DEFAULT '1',

`page_lastday` int(11) NOT NULL,

`email_new` varchar(255) NOT NULL,

`email_new_time` int(15) NOT NULL,

`created` int(11) NOT NULL DEFAULT '0',

`rlname` varchar(255) NOT NULL DEFAULT '',

`location` varchar(255) NOT NULL DEFAULT '',

`page_access` int(11) NOT NULL DEFAULT '0',

`email_code` varchar(255) NOT NULL DEFAULT '0',

`next_email` int(11) NOT NULL DEFAULT '0',

`premium_points` int(11) NOT NULL DEFAULT '0',

`vote` int(11) NOT NULL,

`last_post` int(11) NOT NULL DEFAULT '0',

`flag` varchar(255) NOT NULL,

`viptime` int(15) NOT NULL DEFAULT '0',

`vip_time` int(15) NOT NULL DEFAULT '0',

`vipdays` int(15) NOT NULL DEFAULT '0',

`guild_points` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9766198 ;

 

 

SEGUNDA -

 

 

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `viptime`, `vip_time`, `vipdays`, `guild_points`) VALUES

(1, '1', '765d7d1f3dcd58cb85c29482b2548c764caede3c', '', 65535, 0, 'eduardo.yhago@hotmail.com', '', 0, 0, 1, 1353015990, '', 0, 0, '', '', 6, '0', 0, 0, 0, 1274912789, '', 0, 0, 0, 0);

 

 

Terceira -

 

 

DROP TRIGGER IF EXISTS `ondelete_accounts`;

DELIMITER //

CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`

FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`;

 

 

help

Editado por HeroBaiak
Link para o comentário
Compartilhar em outros sites

5 respostass a esta questão

Posts Recomendados

×
×
  • Criar Novo...