[Erro] sql xampp

Postado Setembro 28, 2014 10 anos

alguém pode me ajuda com o erro a abaixo???? :buon:

meu ot e 10.41 global.

https://imageshack.com/i/p2ipyyvYp

Citar

Mention

Respostas 11
Visualizações 439
Created 10 anos10 anos
Última resposta 10 anos10 anos

Popular Days

Set 28 2014 11 posts

Postado Setembro 28, 2014 10 anos

alguma parte do sql ta errado pega original ou de algum outro ot

Citar

Mention

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/

Citar

Mention

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 "

Citar

Mention

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

Citar

Mention