Postado Setembro 28, 2014 10 anos alguém pode me ajuda com o erro a abaixo???? meu ot e 10.41 global. https://imageshack.com/i/p2ipyyvYp
Postado Setembro 28, 2014 10 anos Autor Pohh... ja troquei de sql mais da outro erro você não poderia me dizer que sql usar? to usando o ot do tópico http://www.tibiaking.com/forum/topic/36111-1037-at%C3%A9-1041-global-completo-o-melhor/
Postado Setembro 28, 2014 10 anos tenta ake 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', `viptime` int(15) NOT NULL DEFAULT '0', `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, `vip_time` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741028 ; INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `viptime`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES (1, '1', '1', '', 65535, 1315745304, '', 'b6589fc6ab0dc82cf120', 0, 0, 1, 0, 1315749556, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0), (6741027, '123456', '123456', '', 0, 1315745228, '[email protected]', '', 0, 0, 1, 0, 1314314775, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br', 0); 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`; END // DELIMITER ; Regras Gerais "Califórnia Brasileira "
Postado Setembro 28, 2014 10 anos Autor tenta ake 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', `viptime` int(15) NOT NULL DEFAULT '0', `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, `vip_time` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741028 ; INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `viptime`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES (1, '1', '1', '', 65535, 1315745304, '', 'b6589fc6ab0dc82cf120', 0, 0, 1, 0, 1315749556, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0), (6741027, '123456', '123456', '', 0, 1315745228, '[email protected]', '', 0, 0, 1, 0, 1314314775, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br', 0); 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`; END // DELIMITER ; Deu o mesmo erro só que menor https://imageshack.com/i/exSlv816p
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.