Rafael142

Vão aí mais alguns bugs. Beregar está com monstros, e tem um orshabaal no fim (está inacessível, mas mesmo assim) Mas scientist não dropa boh Como já falaram, o exevo frigo hur tira mais que o exori frigo, o que é incorreto Taxa de rates dos loots da medusa estão muito baixas, o medusa shield, por exemplo, é semi-raro Wisps não atacam seres humanos, correm deles Wisps dropam moon backpack (é muito raro, porém dropam) Mad scientist no térreo em um lugar de yalahar, lugar aberto que deveria ser fechado (coordenadas: X: 668 Y: 553 Z: 7) Erro num lugar que deveria ser uma escada (coodernadas: X: 672 Y: 554 Z: 5) No último andar de uma torre existem 2 mad scientist e 1 ou 2 dark magicians, não sei ao certo, quando eu confirmar edito aqui (coordenadas: X: 654 Y: 544 Z: 7) (não sei se isso é pegar pesado demais, porém você disse que queria um server mais próximo possível ao global, se for exagero, me desculpe) Resistências do bog raider, estão invertidas. Ao invés de ser -80 a resistência de fire deveria ser 80, e assim vai. Essa área é protection zone (coordenadas: X: 32357 Y: 31689 Z: 7) Eu realmente tenho confiança nesse projeto, torço pra que ele vá pra frente. Parabéns à toda equipe.

Olha, não sei se eu fiz certo, mas aqui eu coloquei a database com o nome que eu criei a database pelo localhost, e deu certo.

Consegui, aleluia Agradeço pela paciência. OT muito bom, parabéns. Se eu achar algum bug eu falo aqui. @edit Seguem alguns erros, a maioria é erro de loot. Infernalist não dropa boots of hasteMedusa não dropa worm Medusa não dropa power bolt Medusa não dropa green mushroom Medusa não dropa gemmed book Medusa não dropa life ring Medusa não dropa boots of haste Medusa não dropa charmer tiara Medusa não dropa dragon scale mail Medusa não dropa energy ring Medusa não dropa fire sword Medusa não dropa golden mug Medusa não dropa snakebite rod Medusa não dropa life crystal Medusa não dropa small sapphire Medusa não dropa strange helmet Medusa não dropa tower shield Medusa dropa platinum coins [0-2] Medusa dropa small emerald [0-3] Medusa dropa ultimate health potion [0-2] Medusa dropa great mana potions [0-2] Medusa dropa white pearl Medusa dropa terra amulet Medusa dropa titan axe Medusa dropa medusa shield Medusa dropa rusty armor (a armor rara, acho que o id é 9809) Medusa dropa warrior helmet Medusa dropa terra mantle Medusa dropa terra legs Medusa dropa sacred tree amulet Mad scientist não dropa soulfire rune Mad scientis não dropa boots of haste Mad scientist não dropa 'slain hellfire fighter' O outfit do nomad tá errado, é mais ou menos esse (pode ter erro nas cores): <look type="146" addons="2" head="61" body="39" legs="40" feet="21" corpse="6080" /> Outfit do dark apprentice errado, é mais ou menos esse (mesma coisa pro do nomad, pode ter erro nas cores): <look type="133" head="78" body="76" legs="95" feet="132" addons="1" corpse="6080"/> Duração do dwarven ring (o dwarven dura apenas 5 minutos, enquanto o certo é durar 60 minutos) Dark apprentice dropa wand of dragonbreath Outfit do assassin errado, o outfit é esse (pode ter erro nas cores): <look type="152" head="114" body="114" legs="114" feet="114" addons="3" corpse="6080"/> Wisps correm dos seres humanos Wisps dropam moon backpack Onyx Flail está assim: You see an item of type 7421, please report it to gamemaster. Coconut shoes está assim: You see an item of type 9931, please report it to gamemaster. Flower dress está assim: You see an item of type 9929, please report it to gamemaster. Flower Wreath está assim: You see an item of type 9928, please report it to gamemaster. Os loots foram comparados entre o arquivo e o que tinha no tibiawiki.

O que o nosso amigo falou realmente funcionou, o server abre. Porém, tá dando vários erros. [31/07/2009 02:18:56] mysql_real_query(): ALTER TABLE `players` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT 0 AFTER `blessings`; - MYSQL ERROR: Unknown column 'blessings' in 'players' (1054) [31/07/2009 02:18:56] mysql_real_query(): ALTER TABLE `players` ADD `stamina` BIGINT UNSIGNED NOT NULL DEFAULT 201660000 AFTER `balance`; - MYSQL ERROR: Unknown column 'balance' in 'players' (1054) [31/07/2009 02:18:56] mysql_real_query(): ALTER TABLE `players` ADD `loss_items` INT NOT NULL DEFAULT 10 AFTER `loss_skills`; - MYSQL ERROR: Unknown column 'loss_skills' in 'players' (1054) [31/07/2009 02:18:56] mysql_real_query(): UPDATE `players` SET `loss_experience` = 10, `loss_mana` = 10, `loss_skills` = 10, `loss_items` = 10; [center][/center]- MYSQL ERROR: Unknown column 'loss_experience' in 'field list' (1054) [31/07/2009 02:18:56] mysql_real_query(): ALTER TABLE `player_deaths` DROP `is_player`; - MYSQL ERROR: Table 'otserv.player_deaths' doesn't exist (1146) [31/07/2009 02:18:56] > Database has been updated to version: 1. [31/07/2009 02:18:56] > Updating database to version: 2... [31/07/2009 02:18:57] mysql_real_query(): SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 30018 AND `value` > 0 - MYSQL ERROR: Table 'otserv.player_storage' doesn't exist (1146) [31/07/2009 02:18:57] mysql_real_query(): DELETE FROM `player_storage` WHERE `key` = 30018; - MYSQL ERROR: Table 'otserv.player_storage' doesn't exist (1146) [31/07/2009 02:18:57] mysql_real_query(): ALTER TABLE `player_items` CHANGE `attributes` `attributes` BLOB NOT NULL; - MYSQL ERROR: Table 'otserv.player_items' doesn't exist (1146) [31/07/2009 02:18:57] > Database has been updated to version: 2. [31/07/2009 02:18:57] > Updating database to version: 3... [31/07/2009 02:18:57] > Database has been updated to version: 3. [31/07/2009 02:18:57] > Updating database to version: 4... [31/07/2009 02:18:58] > Database has been updated to version: 4. [31/07/2009 02:18:58] > Updating database to version: 5... [31/07/2009 02:18:58] mysql_real_query(): ALTER TABLE `player_deaths` ADD `altkilled_by` VARCHAR(255) NOT NULL; - MYSQL ERROR: Table 'otserv.player_deaths' doesn't exist (1146) [31/07/2009 02:18:58] > Database has been updated to version: 5. [31/07/2009 02:18:58] > Updating database to version: 6... [31/07/2009 02:18:58] mysql_real_query(): ALTER TABLE `player_storage` CHANGE `value` `value` VARCHAR(255) NOT NULL DEFAULT '0' - MYSQL ERROR: Table 'otserv.player_storage' doesn't exist (1146) [31/07/2009 02:18:58] mysql_real_query(): ALTER TABLE `tiles` CHANGE `x` `x` INT(5) UNSIGNED NOT NULL, CHANGE `y` `y` INT(5) UNSIGNED NOT NULL, CHANGE `z` `z` TINYINT(2) UNSIGNED NOT NULL; - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:18:58] mysql_real_query(): ALTER TABLE `tiles` ADD INDEX (`x`, `y`, `z`); - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:18:58] mysql_real_query(): ALTER TABLE `tile_items` ADD INDEX (`sid`); - MYSQL ERROR: Table 'otserv.tile_items' doesn't exist (1146) [31/07/2009 02:18:58] > Database has been updated to version: 6. [31/07/2009 02:18:58] > Updating database to version: 7... [31/07/2009 02:18:58] mysql_real_query(): SELECT `r`.`id`, `r`.`guild_id` FROM `guild_ranks` r LEFT JOIN `guilds` g ON `r`.`guild_id` = `g`.`id` WHERE `g`.`ownerid` = `g`.`id` AND `r`.`level` = 3; - MYSQL ERROR: Table 'otserv.guild_ranks' doesn't exist (1146) [31/07/2009 02:18:58] > Database has been updated to version: 7. [31/07/2009 02:18:58] > Updating database version to: 8... [31/07/2009 02:19:00] mysql_real_query(): ALTER TABLE `guilds` ADD UNIQUE (`name`, `world_id`); - MYSQL ERROR: Key column 'name' doesn't exist in table (1072) [31/07/2009 02:19:00] mysql_real_query(): ALTER TABLE `house_lists` ADD `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0; - MYSQL ERROR: Table 'otserv.house_lists' doesn't exist (1146) [31/07/2009 02:19:00] mysql_real_query(): ALTER TABLE `house_lists` ADD UNIQUE (`house_id`, `world_id`, `listid`); - MYSQL ERROR: Table 'otserv.house_lists' doesn't exist (1146) [31/07/2009 02:19:00] mysql_real_query(): ALTER TABLE `houses` CHANGE `id` `id` INT NOT NULL; - MYSQL ERROR: Unknown column 'id' in 'houses' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `houses` ADD UNIQUE (`id`, `world_id`); - MYSQL ERROR: Key column 'id' doesn't exist in table (1072) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `tiles` CHANGE `id` `id` INT NOT NULL; - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `tiles` ADD `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0; - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `tiles` ADD UNIQUE (`id`, `world_id`); - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `tile_items` ADD `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0; - MYSQL ERROR: Table 'otserv.tile_items' doesn't exist (1146) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `tile_items` ADD UNIQUE (`tile_id`, `world_id`, `sid`); - MYSQL ERROR: Table 'otserv.tile_items' doesn't exist (1146) [31/07/2009 02:19:01] > Database has been updated to version: 8. [31/07/2009 02:19:01] > Updating database to version: 9... [31/07/2009 02:19:01] > Database has been updated to version: 9. [31/07/2009 02:19:01] > Updating database to version: 10... [31/07/2009 02:19:01] > Database has been updated to version: 10. [31/07/2009 02:19:01] > Updating database to version: 11... [31/07/2009 02:19:01] > Database has been updated to version: 11. [31/07/2009 02:19:01] > Updating database to version: 12... [31/07/2009 02:19:01] mysql_real_query(): UPDATE `players` SET `stamina` = 151200000 WHERE `stamina` > 151200000; - MYSQL ERROR: Unknown column 'stamina' in 'where clause' (1054) [31/07/2009 02:19:01] mysql_real_query(): UPDATE `players` SET `loss_experience` = `loss_experience` * 10, `loss_mana` = `loss_mana` * 10, `loss_skills` = `loss_skills` * 10, `loss_items` = `loss_items` * 10; - MYSQL ERROR: Unknown column 'loss_experience' in 'field list' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` CHANGE `stamina` `stamina` INT NOT NULL DEFAULT 151200000; - MYSQL ERROR: Unknown column 'stamina' in 'players' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` CHANGE `loss_experience` `loss_experience` INT NOT NULL DEFAULT 100; - MYSQL ERROR: Unknown column 'loss_experience' in 'players' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` CHANGE `loss_mana` `loss_mana` INT NOT NULL DEFAULT 100; - MYSQL ERROR: Unknown column 'loss_mana' in 'players' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` CHANGE `loss_skills` `loss_skills` INT NOT NULL DEFAULT 100; - MYSQL ERROR: Unknown column 'loss_skills' in 'players' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` CHANGE `loss_items` `loss_items` INT NOT NULL DEFAULT 100; - MYSQL ERROR: Unknown column 'loss_items' in 'players' (1054) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` ADD `loss_containers` INT NOT NULL DEFAULT 100 AFTER `loss_skills`; - MYSQL ERROR: Unknown column 'loss_skills' in 'players' (1054) [31/07/2009 02:19:01] > Database has been updated to version: 12. [31/07/2009 02:19:01] > Updating database to version: 13... [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `accounts` DROP KEY `group_id`; - MYSQL ERROR: Can't DROP 'group_id'; check that column/key exists (1091) [31/07/2009 02:19:01] mysql_real_query(): ALTER TABLE `players` DROP KEY `group_id`; - MYSQL ERROR: Can't DROP 'group_id'; check that column/key exists (1091) [31/07/2009 02:19:01] mysql_real_query(): DROP TABLE `groups`; - MYSQL ERROR: Unknown table 'groups' (1051) [31/07/2009 02:19:01] > Database has been updated to version: 13. [31/07/2009 02:19:01] > Updating database to version: 14... [31/07/2009 02:19:02] > Database has been updated to version: 14. [31/07/2009 02:19:02] > Updating database to version: 15... [31/07/2009 02:19:02] mysql_real_query(): DROP TABLE `player_deaths`; - MYSQL ERROR: Unknown table 'player_deaths' (1051) [31/07/2009 02:19:02] mysql_real_query(): 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, FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE, PRIMARY KEY(`id`), INDEX(`date`)) ENGINE = InnoDB; - MYSQL ERROR: Can't create table 'otserv.player_deaths' (errno: 150) (1005) [31/07/2009 02:19:02] mysql_real_query(): CREATE TABLE `killers`( `id` INT NOT NULL AUTO_INCREMENT, `death_id` INT NOT NULL, `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, PRIMARY KEY(`id`), FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE) ENGINE = InnoDB; - MYSQL ERROR: Can't create table 'otserv.killers' (errno: 150) (1005) [31/07/2009 02:19:02] mysql_real_query(): 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; - MYSQL ERROR: Can't create table 'otserv.player_killers' (errno: 150) (1005) [31/07/2009 02:19:02] mysql_real_query(): 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; - MYSQL ERROR: Can't create table 'otserv.environment_killers' (errno: 150) (1005) [31/07/2009 02:19:02] > Database has been updated to version: 15. [31/07/2009 02:19:02] > Updating database to version: 16... [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `killers` ADD `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE; - MYSQL ERROR: Table 'otserv.killers' doesn't exist (1146) [31/07/2009 02:19:03] > Database has been updated to version: 16. [31/07/2009 02:19:03] > Updating database to version: 17... [31/07/2009 02:19:03] mysql_real_query(): CREATE TABLE IF NOT EXISTS `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; - MYSQL ERROR: Can't create table 'otserv.player_namelocks' (errno: 150) (1005) [31/07/2009 02:19:03] > Database has been updated to version: 17. [31/07/2009 02:19:03] > Updating database to version: 18... [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `player_depotitems` DROP KEY `player_id`; - MYSQL ERROR: Table 'otserv.player_depotitems' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `player_depotitems` DROP `depot_id`; - MYSQL ERROR: Table 'otserv.player_depotitems' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `player_depotitems` ADD KEY (`player_id`); - MYSQL ERROR: Table 'otserv.player_depotitems' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `house_data` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Can't create table 'otserv.#sql-3870_b6' (errno: 150) (1005) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `house_lists` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Table 'otserv.house_lists' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Table 'otserv.guild_invites' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `guild_invites` ADD FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE; - MYSQL ERROR: Table 'otserv.guild_invites' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `tiles` ADD `house_id` INT UNSIGNED NOT NULL AFTER `world_id`; - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:19:03] mysql_real_query(): ALTER TABLE `tiles` ADD FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE; - MYSQL ERROR: Table 'otserv.tiles' doesn't exist (1146) [31/07/2009 02:19:03] > Database has been updated to version: 18. [31/07/2009 02:19:03] > Updating database to version: 19... [31/07/2009 02:19:03] mysql_real_query(): 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; - MYSQL ERROR: Can't create table 'otserv.house_auctions' (errno: 150) (1005) [31/07/2009 02:19:03] > Database has been updated to version: 19. [31/07/2009 02:19:03] > Updating database to version: 20... [31/07/2009 02:19:04] > Database has been updated to version: 20. [31/07/2009 02:19:04] > Trigger: oncreate_guilds does not exist, creating it... [31/07/2009 02:19:04] mysql_real_query(): 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; - MYSQL ERROR: Unknown column 'id' in 'NEW' (1054) [31/07/2009 02:19:04] > Trigger: ondelete_guilds does not exist, creating it... [31/07/2009 02:19:04] mysql_real_query(): 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; - MYSQL ERROR: Unknown column 'id' in 'OLD' (1054) [31/07/2009 02:19:04] > Trigger: oncreate_players does not exist, creating it... Eu não consigo logar em nenhum char, acho que fiz algo errado, mas já refiz o tutorial, desde o começo, e não adiantou. Dá pra perceber que não tenho muita experiência com Mysql, né? :tongue2:

Sim, eu fiz isso, porém não deu certo. Quando eu clico em "Segurança" pelo localhost, aparece isso: Eu fui pelo link direto que tinha no tutorial, será que pode ser isso?

Então, segui o tutorial e tal. Daí fui abrir e deu isso: Failed connecting to database - MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: YES) (1045) ERROR: Couldn't estabilish connection to SQL database!

ERROR: Couldn't estabilish connection to SQL database! O que pode ser isso? Estou fazendo algo errado?