Outro Problema :/

Riiicky · Outubro 13, 2011

Olá Pessoal do :XTibia_smile:

Na hora de criar a database mysql com

xampp na hora que faço upload do arquivo

da esse erro:

Erro

consulta SQL:

DROP TRIGGER IF EXISTS `oncreate_players` ;

Mensagens do MySQL : Documentação

#1046 - No database selected

Aqui ta o meu realserv.sql :

DROP TRIGGER IF EXISTS `oncreate_players`;
DROP TRIGGER IF EXISTS `oncreate_guilds`;

DROP TRIGGER IF EXISTS `ondelete_players`;

DROP TRIGGER IF EXISTS `ondelete_guilds`;

DROP TRIGGER IF EXISTS `ondelete_accounts`;

DROP TABLE IF EXISTS `player_depotitems`;

DROP TABLE IF EXISTS `tile_items`;

DROP TABLE IF EXISTS `tiles`;

DROP TABLE IF EXISTS `bans`;

DROP TABLE IF EXISTS `house_lists`;

DROP TABLE IF EXISTS `houses`;

DROP TABLE IF EXISTS `player_items`;

DROP TABLE IF EXISTS `player_namelocks`;

DROP TABLE IF EXISTS `player_skills`;

DROP TABLE IF EXISTS `player_storage`;

DROP TABLE IF EXISTS `player_viplist`;

DROP TABLE IF EXISTS `player_spells`;

DROP TABLE IF EXISTS `player_deaths`;

DROP TABLE IF EXISTS `killers`;

DROP TABLE IF EXISTS `environment_killers`;

DROP TABLE IF EXISTS `player_killers`;

DROP TABLE IF EXISTS `guild_ranks`;

DROP TABLE IF EXISTS `guilds`;

DROP TABLE IF EXISTS `guild_invites`;

DROP TABLE IF EXISTS `global_storage`;

DROP TABLE IF EXISTS `players`;

DROP TABLE IF EXISTS `accounts`;

DROP TABLE IF EXISTS `server_record`;

DROP TABLE IF EXISTS `server_motd`;

DROP TABLE IF EXISTS `server_reports`;

DROP TABLE IF EXISTS `server_config`;

DROP TABLE IF EXISTS `account_viplist`;

DROP TABLE IF EXISTS `poll_votes`;

DROP TABLE IF EXISTS `polls`;

CREATE TABLE `accounts`

(

`id` INT NOT NULL AUTO_INCREMENT,

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

`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,

`premdays` INT NOT NULL DEFAULT 0,

`lastday` INT UNSIGNED NOT NULL DEFAULT 0,

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

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

`blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT 'internal usage',

`warnings` INT NOT NULL DEFAULT 0,

`group_id` INT NOT NULL DEFAULT 1,

`vip_time` INT(15) NOT NULL DEFAULT 0,

PRIMARY KEY (`id`), UNIQUE (`name`)

) ENGINE = InnoDB;

INSERT INTO `accounts` VALUES (1, '1', '1', 65535, 0, '', '0', 0, 0, 1, 0);

CREATE TABLE `players`

(

`id` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(255) NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`group_id` INT NOT NULL DEFAULT 1,

`account_id` INT NOT NULL DEFAULT 0,

`level` INT NOT NULL DEFAULT 1,

`vocation` INT NOT NULL DEFAULT 0,

`health` INT NOT NULL DEFAULT 150,

`healthmax` INT NOT NULL DEFAULT 150,

`experience` BIGINT NOT NULL DEFAULT 0,

`lookbody` INT NOT NULL DEFAULT 0,

`lookfeet` INT NOT NULL DEFAULT 0,

`lookhead` INT NOT NULL DEFAULT 0,

`looklegs` INT NOT NULL DEFAULT 0,

`looktype` INT NOT NULL DEFAULT 136,

`lookaddons` INT NOT NULL DEFAULT 0,

`maglevel` INT NOT NULL DEFAULT 0,

`mana` INT NOT NULL DEFAULT 0,

`manamax` INT NOT NULL DEFAULT 0,

`manaspent` INT NOT NULL DEFAULT 0,

`soul` INT UNSIGNED NOT NULL DEFAULT 0,

`town_id` INT NOT NULL DEFAULT 0,

`posx` INT NOT NULL DEFAULT 0,

`posy` INT NOT NULL DEFAULT 0,

`posz` INT NOT NULL DEFAULT 0,

`conditions` BLOB NOT NULL,

`cap` INT NOT NULL DEFAULT 0,

`sex` INT NOT NULL DEFAULT 0,

`lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,

`lastip` INT UNSIGNED NOT NULL DEFAULT 0,

`save` TINYINT(1) NOT NULL DEFAULT 1,

`skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

`skulltime` INT NOT NULL DEFAULT 0,

`rank_id` INT NOT NULL DEFAULT 0,

`guildnick` VARCHAR(255) NOT NULL DEFAULT '',

`lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,

`blessings` TINYINT(2) NOT NULL DEFAULT 0,

`balance` BIGINT NOT NULL DEFAULT 0,

`stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT 'stored in miliseconds',

`direction` INT NOT NULL DEFAULT 2,

`loss_experience` INT NOT NULL DEFAULT 100,

`loss_mana` INT NOT NULL DEFAULT 100,

`loss_skills` INT NOT NULL DEFAULT 100,

`loss_containers` INT NOT NULL DEFAULT 100,

`loss_items` INT NOT NULL DEFAULT 100,

`premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',

`online` TINYINT(1) NOT NULL DEFAULT 0,

`marriage` INT UNSIGNED NOT NULL DEFAULT 0,

`marrystatus` INT UNSIGNED NOT NULL DEFAULT 0,

`promotion` INT NOT NULL DEFAULT 0,

`deleted` TINYINT(1) NOT NULL DEFAULT FALSE,

`description` VARCHAR(255) NOT NULL DEFAULT '',

PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),

KEY (`account_id`), KEY (`group_id`),

KEY (`online`), KEY (`deleted`),

FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 32360, 31782, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '');

CREATE TABLE `account_viplist`

(

`account_id` INT NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`player_id` INT NOT NULL,

KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),

FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_deaths`

(

`id` INT NOT NULL AUTO_INCREMENT,

`player_id` INT NOT NULL,

`date` BIGINT UNSIGNED NOT NULL,

`level` INT UNSIGNED NOT NULL,

PRIMARY KEY (`id`), INDEX (`date`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_depotitems`

(

`player_id` INT NOT NULL,

`sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',

`pid` INT NOT NULL DEFAULT 0,

`itemtype` INT NOT NULL,

`count` INT NOT NULL DEFAULT 0,

`attributes` BLOB NOT NULL,

KEY (`player_id`), UNIQUE (`player_id`, `sid`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_items`

(

`player_id` INT NOT NULL DEFAULT 0,

`pid` INT NOT NULL DEFAULT 0,

`sid` INT NOT NULL DEFAULT 0,

`itemtype` INT NOT NULL DEFAULT 0,

`count` INT NOT NULL DEFAULT 0,

`attributes` BLOB NOT NULL,

KEY (`player_id`), UNIQUE (`player_id`, `sid`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_namelocks`

(

`player_id` INT NOT NULL DEFAULT 0,

`name` VARCHAR(255) NOT NULL,

`new_name` VARCHAR(255) NOT NULL,

`date` BIGINT NOT NULL DEFAULT 0,

KEY (`player_id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_skills`

(

`player_id` INT NOT NULL DEFAULT 0,

`skillid` TINYINT(2) NOT NULL DEFAULT 0,

`value` INT UNSIGNED NOT NULL DEFAULT 0,

`count` INT UNSIGNED NOT NULL DEFAULT 0,

KEY (`player_id`), UNIQUE (`player_id`, `skillid`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_spells`

(

`player_id` INT NOT NULL,

`name` VARCHAR(255) NOT NULL,

KEY (`player_id`), UNIQUE (`player_id`, `name`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_storage`

(

`player_id` INT NOT NULL DEFAULT 0,

`key` INT UNSIGNED NOT NULL DEFAULT 0,

`value` VARCHAR(255) NOT NULL DEFAULT '0',

KEY (`player_id`), UNIQUE (`player_id`, `key`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_viplist`

(

`player_id` INT NOT NULL,

`vip_id` INT NOT NULL,

KEY (`player_id`), KEY (`vip_id`), UNIQUE (`player_id`, `vip_id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `killers`

(

`id` INT NOT NULL AUTO_INCREMENT,

`death_id` INT NOT NULL,

`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

PRIMARY KEY (`id`),

FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `player_killers`

(

`kill_id` INT NOT NULL,

`player_id` INT NOT NULL,

FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `environment_killers`

(

`kill_id` INT NOT NULL,

`name` VARCHAR(255) NOT NULL,

FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `houses`

(

`id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`owner` INT NOT NULL,

`paid` INT UNSIGNED NOT NULL DEFAULT 0,

`warnings` INT NOT NULL DEFAULT 0,

`lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,

`name` VARCHAR(255) NOT NULL,

`town` INT UNSIGNED NOT NULL DEFAULT 0,

`size` INT UNSIGNED NOT NULL DEFAULT 0,

`price` INT UNSIGNED NOT NULL DEFAULT 0,

`rent` INT UNSIGNED NOT NULL DEFAULT 0,

`doors` INT UNSIGNED NOT NULL DEFAULT 0,

`beds` INT UNSIGNED NOT NULL DEFAULT 0,

`tiles` INT UNSIGNED NOT NULL DEFAULT 0,

`guild` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

`clear` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,

UNIQUE (`id`, `world_id`)

) ENGINE = InnoDB;

CREATE TABLE `house_auctions`

(

`house_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`player_id` INT NOT NULL,

`bid` INT UNSIGNED NOT NULL DEFAULT 0,

`limit` INT UNSIGNED NOT NULL DEFAULT 0,

`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,

UNIQUE (`house_id`, `world_id`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,

FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `house_lists`

(

`house_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`listid` INT NOT NULL,

`list` TEXT NOT NULL,

UNIQUE (`house_id`, `world_id`, `listid`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `house_data`

(

`house_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`data` LONGBLOB NOT NULL,

UNIQUE (`house_id`, `world_id`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `tiles`

(

`id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`house_id` INT UNSIGNED NOT NULL,

`x` INT(5) UNSIGNED NOT NULL,

`y` INT(5) UNSIGNED NOT NULL,

`z` TINYINT(2) UNSIGNED NOT NULL,

UNIQUE (`id`, `world_id`),

KEY (`x`, `y`, `z`),

FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `tile_items`

(

`tile_id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`sid` INT NOT NULL,

`pid` INT NOT NULL DEFAULT 0,

`itemtype` INT NOT NULL,

`count` INT NOT NULL DEFAULT 0,

`attributes` BLOB NOT NULL,

UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),

FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `guilds`

(

`id` INT NOT NULL AUTO_INCREMENT,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`name` VARCHAR(255) NOT NULL,

`ownerid` INT NOT NULL,

`creationdata` INT NOT NULL,

`motd` VARCHAR(255) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE (`name`, `world_id`)

) ENGINE = InnoDB;

CREATE TABLE `guild_invites`

(

`player_id` INT NOT NULL DEFAULT 0,

`guild_id` INT NOT NULL DEFAULT 0,

UNIQUE (`player_id`, `guild_id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,

FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `guild_ranks`

(

`id` INT NOT NULL AUTO_INCREMENT,

`guild_id` INT NOT NULL,

`name` VARCHAR(255) NOT NULL,

`level` INT NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',

PRIMARY KEY (`id`),

FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `bans`

(

`id` INT UNSIGNED NOT NULL auto_increment,

`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',

`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',

`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',

`active` TINYINT(1) NOT NULL DEFAULT TRUE,

`expires` INT NOT NULL,

`added` INT UNSIGNED NOT NULL,

`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,

`comment` TEXT NOT NULL,

`reason` INT UNSIGNED NOT NULL DEFAULT 0,

`action` INT UNSIGNED NOT NULL DEFAULT 0,

`statement` VARCHAR(255) NOT NULL DEFAULT '',

PRIMARY KEY (`id`),

KEY `type` (`type`, `value`),

KEY `active` (`active`)

) ENGINE = InnoDB;

CREATE TABLE `global_storage`

(

`key` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`value` VARCHAR(255) NOT NULL DEFAULT '0',

UNIQUE (`key`, `world_id`)

) ENGINE = InnoDB;

CREATE TABLE `server_config`

(

`config` VARCHAR(35) NOT NULL DEFAULT '',

`value` INT NOT NULL,

UNIQUE (`config`)

) ENGINE = InnoDB;

INSERT INTO `server_config` VALUES ('db_version', 23);

CREATE TABLE `server_motd`

(

`id` INT UNSIGNED NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`text` TEXT NOT NULL,

UNIQUE (`id`, `world_id`)

) ENGINE = InnoDB;

INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');

CREATE TABLE `server_record`

(

`record` INT NOT NULL,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`timestamp` BIGINT NOT NULL,

UNIQUE (`record`, `world_id`, `timestamp`)

) ENGINE = InnoDB;

INSERT INTO `server_record` VALUES (0, 0, 0);

CREATE TABLE `server_reports`

(

`id` INT NOT NULL AUTO_INCREMENT,

`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,

`player_id` INT NOT NULL DEFAULT 1,

`posx` INT NOT NULL DEFAULT 0,

`posy` INT NOT NULL DEFAULT 0,

`posz` INT NOT NULL DEFAULT 0,

`timestamp` BIGINT NOT NULL DEFAULT 0,

`report` TEXT NOT NULL,

`reads` INT NOT NULL DEFAULT 0,

PRIMARY KEY (`id`),

KEY (`world_id`), KEY (`reads`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `polls`

(

`id` INTEGER AUTO_INCREMENT,

`player_id` INT(11) NOT NULL,

`poll` VARCHAR(255) NOT NULL,

`options` VARCHAR(255) NOT NULL,

`timestamp` INT(11) NOT NULL,

PRIMARY KEY (`id`),

FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

CREATE TABLE `poll_votes`

(

`poll_id` INT(11) NOT NULL,

`votes` VARCHAR(255) NOT NULL,

`account_id` VARCHAR(255) NOT NULL,

FOREIGN KEY (`poll_id`) REFERENCES `polls` (`id`) ON DELETE CASCADE

) ENGINE = InnoDB;

DELIMITER |

CREATE TRIGGER `ondelete_accounts`

BEFORE DELETE

ON `accounts`

FOR EACH ROW

BEGIN

DELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;

END|

CREATE TRIGGER `oncreate_guilds`

AFTER INSERT

ON `guilds`

FOR EACH ROW

BEGIN

INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);

INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);

INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);

END|

CREATE TRIGGER `ondelete_guilds`

BEFORE DELETE

ON `guilds`

FOR EACH ROW

BEGIN

UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);

END|

CREATE TRIGGER `oncreate_players`

AFTER INSERT

ON `players`

FOR EACH ROW

BEGIN

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);

END|

CREATE TRIGGER `ondelete_players`

BEFORE DELETE

ON `players`

FOR EACH ROW

BEGIN

DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;

UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;

END|

DELIMITER ;

Editado Outubro 13, 2011 por Riiicky

SkyDangerous · Outubro 13, 2011

Use esse


DROP TRIGGER IF EXISTS `oncreate_players`;
DROP TRIGGER IF EXISTS `oncreate_guilds`;
DROP TRIGGER IF EXISTS `ondelete_players`;
DROP TRIGGER IF EXISTS `ondelete_guilds`;
DROP TRIGGER IF EXISTS `ondelete_accounts`;

DROP TABLE IF EXISTS `player_depotitems`;
DROP TABLE IF EXISTS `tile_items`;
DROP TABLE IF EXISTS `tiles`;
DROP TABLE IF EXISTS `bans`;
DROP TABLE IF EXISTS `house_lists`;
DROP TABLE IF EXISTS `houses`;
DROP TABLE IF EXISTS `player_items`;
DROP TABLE IF EXISTS `player_namelocks`;
DROP TABLE IF EXISTS `player_skills`;
DROP TABLE IF EXISTS `player_storage`;
DROP TABLE IF EXISTS `player_viplist`;
DROP TABLE IF EXISTS `player_spells`;
DROP TABLE IF EXISTS `player_deaths`;
DROP TABLE IF EXISTS `killers`;
DROP TABLE IF EXISTS `environment_killers`;
DROP TABLE IF EXISTS `player_killers`;
DROP TABLE IF EXISTS `guild_ranks`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `guild_invites`;
DROP TABLE IF EXISTS `global_storage`;
DROP TABLE IF EXISTS `players`;
DROP TABLE IF EXISTS `accounts`;
DROP TABLE IF EXISTS `server_record`;
DROP TABLE IF EXISTS `server_motd`;
DROP TABLE IF EXISTS `server_reports`;
DROP TABLE IF EXISTS `server_config`;
DROP TABLE IF EXISTS `account_viplist`;
DROP TABLE IF EXISTS `poll_votes`;
DROP TABLE IF EXISTS `polls`;

CREATE TABLE `accounts`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(32) NOT NULL DEFAULT '',
`password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
`premdays` INT NOT NULL DEFAULT 0,
`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
`email` VARCHAR(255) NOT NULL DEFAULT '',
`key` VARCHAR(20) NOT NULL DEFAULT '0',
`blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT 'internal usage',
`warnings` INT NOT NULL DEFAULT 0,
`group_id` INT NOT NULL DEFAULT 1,
PRIMARY KEY (`id`), UNIQUE (`name`)
) ENGINE = InnoDB;

INSERT INTO `accounts` VALUES (1, '1', '1', 65535, 0, '', '0', 0, 0, 1, 0);

CREATE TABLE `players`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`group_id` INT NOT NULL DEFAULT 1,
`account_id` INT NOT NULL DEFAULT 0,
`level` INT NOT NULL DEFAULT 1,
`vocation` INT NOT NULL DEFAULT 0,
`health` INT NOT NULL DEFAULT 150,
`healthmax` INT NOT NULL DEFAULT 150,
`experience` BIGINT NOT NULL DEFAULT 0,
`lookbody` INT NOT NULL DEFAULT 0,
`lookfeet` INT NOT NULL DEFAULT 0,
`lookhead` INT NOT NULL DEFAULT 0,
`looklegs` INT NOT NULL DEFAULT 0,
`looktype` INT NOT NULL DEFAULT 136,
`lookaddons` INT NOT NULL DEFAULT 0,
`maglevel` INT NOT NULL DEFAULT 0,
`mana` INT NOT NULL DEFAULT 0,
`manamax` INT NOT NULL DEFAULT 0,
`manaspent` INT NOT NULL DEFAULT 0,
`soul` INT UNSIGNED NOT NULL DEFAULT 0,
`town_id` INT NOT NULL DEFAULT 0,
`posx` INT NOT NULL DEFAULT 0,
`posy` INT NOT NULL DEFAULT 0,
`posz` INT NOT NULL DEFAULT 0,
`conditions` BLOB NOT NULL,
`cap` INT NOT NULL DEFAULT 0,
`sex` INT NOT NULL DEFAULT 0,
`lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`lastip` INT UNSIGNED NOT NULL DEFAULT 0,
`save` TINYINT(1) NOT NULL DEFAULT 1,
`skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`skulltime` INT NOT NULL DEFAULT 0,
`rank_id` INT NOT NULL DEFAULT 0,
`guildnick` VARCHAR(255) NOT NULL DEFAULT '',
`lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`blessings` TINYINT(2) NOT NULL DEFAULT 0,
`balance` BIGINT NOT NULL DEFAULT 0,
`stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT 'stored in miliseconds',
`direction` INT NOT NULL DEFAULT 2,
`loss_experience` INT NOT NULL DEFAULT 100,
`loss_mana` INT NOT NULL DEFAULT 100,
`loss_skills` INT NOT NULL DEFAULT 100,
`loss_containers` INT NOT NULL DEFAULT 100,
`loss_items` INT NOT NULL DEFAULT 100,
`premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
`online` TINYINT(1) NOT NULL DEFAULT 0,
`marriage` INT UNSIGNED NOT NULL DEFAULT 0,
`marrystatus` INT UNSIGNED NOT NULL,
`promotion` INT NOT NULL DEFAULT 0,
`deleted` TINYINT(1) NOT NULL DEFAULT FALSE,
`description` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),
KEY (`account_id`), KEY (`group_id`),
KEY (`online`), KEY (`deleted`),
FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 32360, 31782, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, '', 0, 0, '');

CREATE TABLE `account_viplist`
(
`account_id` INT NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`player_id` INT NOT NULL,
KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),
FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_deaths`
(
`id` INT NOT NULL AUTO_INCREMENT,
`player_id` INT NOT NULL,
`date` BIGINT UNSIGNED NOT NULL,
`level` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`), INDEX (`date`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_depotitems`
(
`player_id` INT NOT NULL,
`sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
KEY (`player_id`), UNIQUE (`player_id`, `sid`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_items`
(
`player_id` INT NOT NULL DEFAULT 0,
`pid` INT NOT NULL DEFAULT 0,
`sid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL DEFAULT 0,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
KEY (`player_id`), UNIQUE (`player_id`, `sid`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_namelocks`
(
`player_id` INT NOT NULL DEFAULT 0,
`name` VARCHAR(255) NOT NULL,
`new_name` VARCHAR(255) NOT NULL,
`date` BIGINT NOT NULL DEFAULT 0,
KEY (`player_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_skills`
(
`player_id` INT NOT NULL DEFAULT 0,
`skillid` TINYINT(2) NOT NULL DEFAULT 0,
`value` INT UNSIGNED NOT NULL DEFAULT 0,
`count` INT UNSIGNED NOT NULL DEFAULT 0,
KEY (`player_id`), UNIQUE (`player_id`, `skillid`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_spells`
(
`player_id` INT NOT NULL,
`name` VARCHAR(255) NOT NULL,
KEY (`player_id`), UNIQUE (`player_id`, `name`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_storage`
(
`player_id` INT NOT NULL DEFAULT 0,
`key` INT UNSIGNED NOT NULL DEFAULT 0,
`value` VARCHAR(255) NOT NULL DEFAULT '0',
KEY (`player_id`), UNIQUE (`player_id`, `key`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_viplist`
(
`player_id` INT NOT NULL,
`vip_id` INT NOT NULL,
KEY (`player_id`), KEY (`vip_id`), UNIQUE (`player_id`, `vip_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `killers`
(
`id` INT NOT NULL AUTO_INCREMENT,
`death_id` INT NOT NULL,
`final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
`unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
PRIMARY KEY (`id`),
FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_killers`
(
`kill_id` INT NOT NULL,
`player_id` INT NOT NULL,
FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `environment_killers`
(
`kill_id` INT NOT NULL,
`name` VARCHAR(255) NOT NULL,
FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `houses`
(
`id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`owner` INT NOT NULL,
`paid` INT UNSIGNED NOT NULL DEFAULT 0,
`warnings` INT NOT NULL DEFAULT 0,
`lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,
`name` VARCHAR(255) NOT NULL,
`town` INT UNSIGNED NOT NULL DEFAULT 0,
`size` INT UNSIGNED NOT NULL DEFAULT 0,
`price` INT UNSIGNED NOT NULL DEFAULT 0,
`rent` INT UNSIGNED NOT NULL DEFAULT 0,
`doors` INT UNSIGNED NOT NULL DEFAULT 0,
`beds` INT UNSIGNED NOT NULL DEFAULT 0,
`tiles` INT UNSIGNED NOT NULL DEFAULT 0,
`guild` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
`clear` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

CREATE TABLE `house_auctions`
(
`house_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`player_id` INT NOT NULL,
`bid` INT UNSIGNED NOT NULL DEFAULT 0,
`limit` INT UNSIGNED NOT NULL DEFAULT 0,
`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
UNIQUE (`house_id`, `world_id`),
FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `house_lists`
(
`house_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`listid` INT NOT NULL,
`list` TEXT NOT NULL,
UNIQUE (`house_id`, `world_id`, `listid`),
FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `house_data`
(
`house_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`data` LONGBLOB NOT NULL,
UNIQUE (`house_id`, `world_id`),
FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tiles`
(
`id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`house_id` INT UNSIGNED NOT NULL,
`x` INT(5) UNSIGNED NOT NULL,
`y` INT(5) UNSIGNED NOT NULL,
`z` TINYINT(2) UNSIGNED NOT NULL,
UNIQUE (`id`, `world_id`),
KEY (`x`, `y`, `z`),
FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tile_items`
(
`tile_id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`sid` INT NOT NULL,
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `guilds`
(
`id` INT NOT NULL AUTO_INCREMENT,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`name` VARCHAR(255) NOT NULL,
`ownerid` INT NOT NULL,
`creationdata` INT NOT NULL,
`motd` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE (`name`, `world_id`)
) ENGINE = InnoDB;

CREATE TABLE `guild_invites`
(
`player_id` INT NOT NULL DEFAULT 0,
`guild_id` INT NOT NULL DEFAULT 0,
UNIQUE (`player_id`, `guild_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `guild_ranks`
(
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL,
`name` VARCHAR(255) NOT NULL,
`level` INT NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
PRIMARY KEY (`id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `bans`
(
`id` INT UNSIGNED NOT NULL auto_increment,
`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
`active` TINYINT(1) NOT NULL DEFAULT TRUE,
`expires` INT NOT NULL,
`added` INT UNSIGNED NOT NULL,
`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
`comment` TEXT NOT NULL,
`reason` INT UNSIGNED NOT NULL DEFAULT 0,
`action` INT UNSIGNED NOT NULL DEFAULT 0,
`statement` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type` (`type`, `value`),
KEY `active` (`active`)
) ENGINE = InnoDB;

CREATE TABLE `global_storage`
(
`key` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`value` VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE  (`key`, `world_id`)
) ENGINE = InnoDB;

CREATE TABLE `server_config`
(
`config` VARCHAR(35) NOT NULL DEFAULT '',
`value` INT NOT NULL,
UNIQUE (`config`)
) ENGINE = InnoDB;

INSERT INTO `server_config` VALUES ('db_version', 23);

CREATE TABLE `server_motd`
(
`id` INT UNSIGNED NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`text` TEXT NOT NULL,
UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');

CREATE TABLE `server_record`
(
`record` INT NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`timestamp` BIGINT NOT NULL,
UNIQUE (`record`, `world_id`, `timestamp`)
) ENGINE = InnoDB;

INSERT INTO `server_record` VALUES (0, 0, 0);

CREATE TABLE `server_reports`
(
`id` INT NOT NULL AUTO_INCREMENT,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`player_id` INT NOT NULL DEFAULT 1,
`posx` INT NOT NULL DEFAULT 0,
`posy` INT NOT NULL DEFAULT 0,
`posz` INT NOT NULL DEFAULT 0,
`timestamp` BIGINT NOT NULL DEFAULT 0,
`report` TEXT NOT NULL,
`reads` INT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY (`world_id`), KEY (`reads`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `polls` 
(
`id` INTEGER AUTO_INCREMENT,
`player_id` INT(11) NOT NULL,
`poll` VARCHAR(255) NOT NULL,
`options` VARCHAR(255) NOT NULL,
`timestamp` INT(11) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `poll_votes` 
(
 `poll_id` INT(11) NOT NULL,
 `votes` VARCHAR(255) NOT NULL,
 `account_id` VARCHAR(255) NOT NULL,
 FOREIGN KEY (`poll_id`) REFERENCES `polls` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;


DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
END|

CREATE TRIGGER `ondelete_guilds`
BEFORE DELETE
ON `guilds`
FOR EACH ROW
BEGIN
UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
END|

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;
UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

DELIMITER ;

Riiicky · Outubro 13, 2011

Nem funcionou está dando o mesmo erro

boors · Outubro 14, 2011

Voce ja criou a db e executou isso dentro de uma db? Ou está executando direto?

Editado Outubro 14, 2011 por Boors

Riiicky · Outubro 14, 2011

Voce ja criou a db e executou isso dentro de uma db? Ou está executando direto?

Eu fiz como no tutorial do doidin mais nao fiz nenhuma database só fiz upload do arquivo .sql e dei executar e da esse erro .

boors · Outubro 14, 2011

No phpmyadmin, cria uma database e importa o arquivo pra ela.

Riiicky · Outubro 14, 2011

No phpmyadmin, cria uma database e importa o arquivo pra ela.

a descupá no phpadmin eu criei a database antes sim só q na hora de importar que da aquele erro

agora está dando outro erro :

Erro

consulta SQL:

INSERT INTO `accounts`
VALUES ( 1, '1', '1', 65535, 0, '', '0', 0, 0, 1, 0 ) ;

Mensagens do MySQL : Documentação
#1136 - Column count doesn't match value count at row 1

Editado Outubro 14, 2011 por Riiicky

Entrar

Outro Problema :/

Posts Recomendados

Riiicky 1

Link para o comentário

Compartilhar em outros sites

SkyDangerous 395

Link para o comentário

Compartilhar em outros sites

Riiicky 1

Link para o comentário

Compartilhar em outros sites

boors 5

Link para o comentário

Compartilhar em outros sites

Riiicky 1

Link para o comentário

Compartilhar em outros sites

boors 5

Link para o comentário

Compartilhar em outros sites

Riiicky 1

Link para o comentário

Compartilhar em outros sites

Quem Está Navegando 0 membros estão online

Conteúdo Similar

Você só pode deslogar depois de 5 segundos

otserver Alguem poderia me ajudar ?? Com esse Mapa de POKETIBIA

Baiak Titan 8.6 200X - 24h/7 Dedicado BR (COM MONTARIAS)

script alguém pode me ajudar nessa spells aqui, queira que colocassem pro meu personagem ficar inatingível por 6 segundos e podendo atacar livremente

Cliente 10.00 Bug Quando o jogador usa qualquer magia ou posição

Fóruns

Tutoriais

Suporte