Sempre fui fã do trabalho da Equipe, aguardei desesperadamente o novo Alissow, e vale a pena, Parabéns a toda Equipe !!

  Em 12/05/2014 em 15:02, dila disse:

Ninguém pode colocar o OT com as DLLs e tudo já para colocar o OT Online? ta muito complicado !

 

Tenho um pack com as Dll's 32 bits

 

http://www.4shared.com/rar/Aa17sBxSba/DllPack_32bits_OpenTibia.html?

Estou com os seguintes problemas, poderia disponibilizar as querys para adicionar as tabelas que faltam ?

Quando tento logar:

Mostrar conteúdo oculto

[Error - mysql_real_query] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 16777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 16777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `reason`, `expires_at`, (SELECT `name`
FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 1
6777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT `reason`, `expires_at`, (SELECT `name
` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` =
 16777343
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = '1334029'
Message: Unknown column 'type' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `name`, `password`, `type`, `premdays`, `lastday` FROM `accounts` WHERE `name` = '1334029'
Message: Unknown column 'type' in 'field list'

Quando executo a TFS:

Mostrar conteúdo oculto

[Error - mysql_real_query] Query: SELECT `data` FROM `tile_store`
Message: Table 'franalin.tile_store' doesn't exist
[Error - mysql_store_result] Query: SELECT `data` FROM `tile_store`
Message: Table 'franalin.tile_store' doesn't exist
>> Initializing gamestate
[Error - mysql_real_query] Query: TRUNCATE TABLE `players_online`
Message: Table 'franalin.players_online' doesn't exist
[Error - mysql_real_query] Query: DELETE FROM `players` WHERE `deletion` != 0 AND `deletion` < 1401406844
Message: Unknown column 'deletion' in 'where clause'
[Error - mysql_real_query] Query: DELETE FROM `ip_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1401406844
Message: Table 'franalin.ip_bans' doesn't exist
[Error - mysql_real_query] Query: DELETE FROM `market_history` WHERE `inserted`<= 1398814844
Message: Table 'franalin.market_history' doesn't exist
[Error - mysql_real_query] Query: SELECT * FROM `account_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1401406844
Message: Table 'franalin.account_bans' doesn't exist
[Error - mysql_store_result] Query: SELECT * FROM `account_bans` WHERE `expires_at` != 0 AND `expires_at` <= 1401406844
Message: Table 'franalin.account_bans' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < 1401406844
Message: Unknown column 'highest_bidder' in 'field list'
[Error - mysql_store_result] Query: SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < 1401406844
Message: Unknown column 'highest_bidder' in 'field list'
[Error - mysql_real_query] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 0 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 0 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_real_query] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 1 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_store_result] Query: SELECT `id`, `amount`, `price`, `itemtype`, `player_id` FROM `market_offers` WHERE `sale` = 1 AND `created` <= 1398814844
Message: Table 'franalin.market_offers' doesn't exist
[Error - mysql_real_query] Query: SELECT `sale` AS `sale`, `itemtype` AS `itemtype`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`
Message: Table 'franalin.market_history' doesn't exist
[Error - mysql_store_result] Query: SELECT `sale` AS `sale`, `itemtype` AS `item type`, COUNT(`price`) AS `num`, MIN(`price`) AS `min`, MAX(`price`) AS `max`, SUM(`price`) AS `sum` FROM `market_history` WHERE `state` = 3 GROUP BY `itemtype`, `sale`
Message: Table 'franalin.market_history' doesn't exist

eu não estou conseguindo colocar ele online ... falta a db dele ou como eu criaria uma nova ?

roda no xp?