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
