Erro No Meu Site: War Statistics E Trade System.

Gualdani · Setembro 15, 2011

Bom galera, tenho varias duvidas, só que duas estão me incomodando mais:

•Primeiro: quando clico no War Statistics, apareçe o seguinte erro

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.guild_wars' doesn't exist' in C:\xampp\htdocs\wars.php:69 Stack trace: #0 C:\xampp\htdocs\wars.php(69): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(93): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\wars.php on line 69

•Segundo: quando clico no Trade System, apareçe o seguinte erro

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.auction_system' doesn't exist' in C:\xampp\htdocs\auctionsystem.php:2 Stack trace: #0 C:\xampp\htdocs\auctionsystem.php(2): PDO->query('SELECT `auction...') #1 C:\xampp\htdocs\index.php(87): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\auctionsystem.php on line 2

Acredito que sejam consigurações no Xampp. Uso a versão 1.7.3 e com o Gesior 0.4.0 e meu server é 8.6

• Agora é a ultima duvida, quando vou no meu site, clico em Library>Server Info, nao apareçe as informações do meu site, aonde devo ir para mudar essas configurações ?

agradeço a quem responder, e dou REP :button_ok:

Isbigo · Setembro 15, 2011

Vá em seu Localhost/phpmyadmin.

Adicione as seguintes SQL:

CREATE TABLE IF NOT EXISTS `auction_system` (
 `id` int(11) NOT NULL auto_increment,
 `player` int(11) default NULL,
 `item_id` int(11) default NULL,
 `item_name` varchar(255) default NULL,
 `count` int(11) default NULL,
 `cost` int(11) default NULL,
 `date` int(11) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

é essas aqui também.

CREATE TABLE IF NOT EXISTS `guild_wars` (
 `id` INT NOT NULL AUTO_INCREMENT,
 `guild_id` INT NOT NULL,
 `enemy_id` INT NOT NULL,
 `begin` BIGINT NOT NULL DEFAULT '0',
 `end` BIGINT NOT NULL DEFAULT '0',
 `frags` INT UNSIGNED NOT NULL DEFAULT '0',
 `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
 `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
 `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
 `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 KEY `status` (`status`),
 KEY `guild_id` (`guild_id`),
 KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB;

ALTER TABLE `guild_wars`
 ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
 ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

CREATE TABLE IF NOT EXISTS `guild_kills` (
 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 `guild_id` INT NOT NULL,
 `war_id` INT NOT NULL,
 `death_id` INT NOT NULL
) ENGINE = InnoDB;

ALTER TABLE `guild_kills`
 ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
 ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
 ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

Teste novamente é verifique se ocorre algum erro valeu.

Agora quando ao Serverinfo. faça o seguinte!!!

Vá em "C:/xampp/htdcos" abra o arquivo chamado Serverinfo.php

Apague tudo que tiver dentro e coloque o seguinte:

<?PHP

if($config['site']['serverinfo_page'])

{

$stages = simplexml_load_file($config['site']['server_path'].'/data/XML/stages.xml');

$servers = simplexml_load_file($config['site']['server_path'].'/data/XML/servers.xml');

$talkactions = simplexml_load_file($config['site']['server_path'].'/data/talkactions/talkactions.xml');

$main_content .= '<br><center>

<td colspan="2"><font class="white"><b>Status</b></font></td>

</tr>

<td width="50%"><font class="white">Name</font></td><td><font class="white">Value</font></td>

</tr>

<td>Server</td><td>'.(($config['status']['serverStatus_online'] == 1) ? '<font color="grenn"><b>On line</b></font>' : '<font color="red"><b>Off line</b></font>').'</td>

</tr>

<td>Player Online</td><td>'.$config['status']['serverStatus_players'].'</td>

</tr>

<td>UpTime</td><td>'.$config['status']['serverStatus_uptime'].'</td>

</tr>

<td>Monster</td><td>'.$config['status']['serverStatus_monsters'].'</td>

</tr>

<td>NPC</td><td>'.$config['status']['serverStatus_npcs'].'</td>

</tr>

</table>

<br>';

if($config['server']['experienceStages'] == false)

$rateExperience .= $config['server']['rateExperience'].'x';

else

{

$rateExperience .= '<table width="100%">';

foreach($stages as $exp1)

{

$i = 0;

$ots = (int) $exp1["id"];

if($ots > 0)

$rateExperience .= '<tr align="center" bgcolor="'.$config['site']['vdarkborder'].'"><td colspan="3"><strong>Experience Stages on '.$config['site']['worlds'][$ots].'</strong></td></tr>';

$rateExperience .= '<tr align="center" bgcolor="'.$config['site']['vdarkborder'].'"><td class="white">From Level</td><td class="white">To Level</td><td class="white">Rate</td></tr>';

foreach($exp1 as $exp)

{

if(isset($exp["maxlevel"]))

$max = $exp["maxlevel"];

else

$max = "-";

if(is_int($i/2))

$bgcolor=$config['site']['lightborder'];

else

$bgcolor=$config['site']['darkborder'];

$rateExperience .= '<tr align="center" bgcolor="'.$bgcolor.'"><td>'.$exp["minlevel"].'</td><td>'.$max.'</td><td>'.$exp["multiplier"].'x</td></tr>';

$i++;

}

$rateExperience .= '</table>';

}

$main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="95%">

<td colspan="2"><font class="white"><b>Rates</b></font></td>

</tr>

<td><font class="white">Name</font></td><td><font class="white">Value</font></td>

</tr>

<td width="50%">Experience</td><td>'.$rateExperience.'</td>

</tr>

<td>Skill</td><td>'.$config['server']['rateSkill'].'x</td>

</tr>

<td>Magic</td><td>'.$config['server']['rateMagic'].'x</td>

</tr>

<td>Loot</td><td>'.$config['server']['rateLoot'].'x</td>

</tr>

<td>Spawn</td><td>'.$config['server']['rateSpawn'].'x</td>

</tr>

</table><br>';

foreach($servers as $server)

{

$v1 = $server['versionMin'];

$v2 = $server['versionMax'];

if($v1 == $v2)

{

$version = str_split($v1);

$version = $version[0].'.'.$version[1].$version[2];

}

else

{

$v1 = str_split($v1);

$v2 = str_split($v2);

$version = $v1[0].'.'.$v1[1].$v1[2].'~'.$v2[0].'.'.$v2[1].$v2[2];

}

///Queries ///

$query = $SQL->query('SELECT `name`, `id`, `level`, `experience` FROM `players` WHERE players.group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1 ORDER BY `level` DESC, `experience` DESC LIMIT 1;')->fetch();

$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();

$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();

$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();

$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();

$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();

$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();

$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();

///End Queries ///

$main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="95%">

<td colspan="2"><font class="white"><b>Info Server</b></font></td>

</tr>

<td width="50%"><font class="white">Name</font></td><td><font class="white">Value</font></td>

</tr>

<td>World Type</td><td>'.$config['server']['worldType'].'</td>

</tr>

<td>Client Version</td><td>'.$version.'</td>

</tr>

<td>Server motd</td><td>'.$config['server']['motd'].'</td>

</tr>

<td>Last joined</td><td><a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a></td>

</tr>

<td>Best Level</td><td><a href="index.php?subtopic=characters&name='.urlencode($query['name']).'">'.$query['name'].'</a> ('.$query['level'].')</td>

</tr>

<td>Free Houses</td><td>'.$housesfree[0].'</td>

</tr>

<td>Rented Houses:</td><td>'.$housesrented[0].'</td>

</tr>

<td>Banned accounts:</td><td>'.$banned[0].'</td>

</tr>

<td>Accounts in database:</td><td>'.$accounts[0].'</td>

</tr>

<td>Players in database:</td><td>'.$players[0].'</td>

</tr>

<td>Guilds in databese:</td><td>'.$guilds[0].'</td>

</tr>

</table><br>';

$main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="95%">

<td colspan="2"><font class="white"><b>Commands</b></font></td>

</tr>';

$i = 1;

$k = 0;

foreach($talkactions as $command)

{

if(empty($command["access"]) or $command["access"] == 0)

{

if(is_int($k/2))

$bgcolor=$config['site']['lightborder'];

else

$bgcolor=$config['site']['darkborder'];

if(is_int($i/2))

$main_content .= '<td width="50%">'.$command["words"].'</td></tr>';

else

{

$main_content .= '<tr align="center" bgcolor="'.$bgcolor.'"><td width="50%">'.$command["words"].'</td>';

$k++;

}

$i++;

}

$main_content .= '</table><br>';

$whiteSkullTime = explode("*", $config['server']['whiteSkullTime']);

$whiteSkullTime = $whiteSkullTime[0].(count($whiteSkullTime) == 3 ? ' minutes' : ' seconds');

# Info for Red Skull

$redSkullLength = explode("*", $config['server']['redSkullLength']);

$redSkullLength = $redSkullLength[0].(count($redSkullLength) == 4 ? ' days' : ' hours');

$fragsToRedSkull = 'Daily: '.$config['server']['dailyFragsToRedSkull'].' | Weekly: '.$config['server']['weeklyFragsToRedSkull'].' | Monthly: '.$config['server']['monthlyFragsToRedSkull'];

# Info for Ban

$killsBanLength = explode("*", $config['server']['killsBanLength']);

$killsBanLength = $killsBanLength[0].(count($killsBanLength) == 4 ? ' days' : ' hours');

$kill_daily = is_numeric($config['server']['dailyFragsToBanishment']) ? $config['server']['dailyFragsToBanishment'] : $config['server']['dailyFragsToRedSkull'];

$kill_weekly = is_numeric($config['server']['weeklyFragsToBanishment']) ? $config['server']['weeklyFragsToBanishment'] : $config['server']['weeklyFragsToRedSkull'];

$kill_monthly = is_numeric($config['server']['monthlyFragsToBanishment']) ? $config['server']['monthlyFragsToBanishment'] : $config['server']['monthlyFragsToRedSkull'];

$fragsToBanishment = 'Daily: '.$kill_daily.' | Weekly: '.$kill_weekly.' | Monthly: '.$kill_monthly;

# Info for Black Skull

if($config['server']['useBlackSkull'] == true)

{

$blackSkullLength = explode("*", $config['server']['blackSkullLength']);

$blackSkullLength = $blackSkullLength[0].(count($blackSkullLength) == 4 ? ' days' : ' hours');

$black_daily = is_numeric($config['server']['dailyFragsToBlackSkull']) ? $config['server']['dailyFragsToBlackSkull'] : $config['server']['dailyFragsToRedSkull'];

$black_weekly = is_numeric($config['server']['weeklyFragsToBlackSkull']) ? $config['server']['weeklyFragsToBlackSkull'] : $config['server']['weeklyFragsToRedSkull'];

$black_monthly = is_numeric($config['server']['monthlyFragsToBlackSkull']) ? $config['server']['monthlyFragsToBlackSkull'] : $config['server']['monthlyFragsToRedSkull'];

$fragsToBlackSkull = 'Daily: '.$black_daily.' | Weekly: '.$black_weekly.' | Monthly: '.$black_monthly;

$blackSkull = $blackSkullLength;

}

else

{

$blackSkull = "Disabled";

$fragsToBlackSkull = "Disabled";

}

$main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="95%">

<td colspan="2"><font class="white"><b>Frags</b></font></td>

</tr>

<td width="50%"><font class="white">Name</font></td><td><font class="white">Value</font></td>

</tr>

<td>White Skull Time</td><td>'.$whiteSkullTime.'</td>

</tr>

<td>Red Skull Time</td><td>'.$redSkullLength.'</td>

</tr>

<td>Black Skull Time</td><td>'.$blackSkull.'</td>

</tr>

<td>Black Skull Time</td><td>'.$killsBanLength.'</td>

</tr>

<td>Frags to Red Skull</td><td>'.$fragsToRedSkull.'</td>

</tr>

<td>Frags to Black Skull</td><td>'.$fragsToBlackSkull.'</td>

</tr>

<td>Frags to Ban</td><td>'.$fragsToBanishment.'</td>

</tr>

</table><br>';

$idleKickTime = explode("*", $config['server']['idleKickTime']);

$idleKickTime = $idleKickTime[0].(count($idleKickTime) == 4 ? ' hours' : ' minuts');

$pzLocked = explode("*", $config['server']['pzLocked']);

$pzLocked = $pzLocked[0].(count($pzLocked) == 3 ? ' minuts' : ' seconds');

if($config['server']['freePremium'] == true)

$freePremium = "Free";

else

$freePremium = 'Not Free';

if($config['server']['bankSystem'] == true)

$bankSystem = "Enabled";

else

$bankSystem = "Disabled";

if($config['server']['guildHalls'] == true)

$guildHalls = "Enabled";

else

$guildHalls = "Disabled";

$main_content .= '<table border="0" cellpadding="4" cellspacing="1" width="95%">

<td colspan="2"><font class="white"><b>Onther information</b></font></td>

</tr>

<td width="50%"><font class="white">Name</font></td><td><font class="white">Value</font></td>

</tr>

<td>Premium</td><td>'.$freePremium.'</td>

</tr>

<td>Bank System</td><td>'.$bankSystem.'</td>

</tr>

<td>Guild halls</td><td>'.$guildHalls.'</td>

</tr>

<td>Kick Time</td><td>'.$idleKickTime.'</td>

</tr>

<td>PZ Lock</td><td>'.$pzLocked.'</td>

</tr>

<td>Protection Level</td><td>'.$config['server']['protectionLevel'].'</td>

</tr>

<td>Level to buy house</td><td>'.$config['server']['levelToBuyHouse'].'</td>

</tr>

<td>Level to create guild</td><td>'.$config['site']['guild_need_level'].'</td>

</tr>

<!--

</tr>

</tr>

-->

</table><br>';

$main_content .= '</center>';

}

else

$main_content .= "Invalid subtopic. Can't load page.";

?>

Ajudei ? rep+ ae.

Editado Setembro 15, 2011 por Isbigo

Gualdani · Setembro 16, 2011

Ajudou sim, e MUITO.

Problema resolvido.

REP :button_ok: ja adicionado.

Obrigado!

gmdelix · Outubro 22, 2011

Cara eu vi aii, mais aonde eu tenho que colocar, por exemplo no meu aqui eu não tenho guilds_wars dai eu tenho que criar ?

ou eu coloco no que tá só "wars" ??

me ajuda ai fazendo favor =D

valeu se eu conseguir aqui eu do REP++

Isbigo · Outubro 24, 2011

Abra seu Localhost/phpmyadmin entre em sua conta

Acesse seu database

Click na aba SQL que vai ter no lado superior direito.

Coloque esses codicos e click em executar.!

thalesloks · Outubro 30, 2011

o meu no website do meu ot eli aparece mais quando eu escrevo comando no tibia o comando nao funfa.

AJuda Plix !

Isbigo · Outubro 31, 2011

Você tem que usar o distro TFS0.4 com capacidade para war system.

thalesloks · Outubro 31, 2011

Tipo como instala esse TFS0.4 ?

ajuda ai plix

biel1010 · Novembro 8, 2011

Estava Com o MESMO Problema que o Gualdani, Voce me Ajudou Muito, Gratto (REP+)

Editado Novembro 8, 2011 por biel1010

Entrar

Erro No Meu Site: War Statistics E Trade System.

Posts Recomendados

Gualdani 1

Link para o comentário

Compartilhar em outros sites

Isbigo 32

Link para o comentário

Compartilhar em outros sites

Gualdani 1

Link para o comentário

Compartilhar em outros sites

gmdelix 0

Link para o comentário

Compartilhar em outros sites

Isbigo 32

Link para o comentário

Compartilhar em outros sites

thalesloks 1

Link para o comentário

Compartilhar em outros sites

Isbigo 32

Link para o comentário

Compartilhar em outros sites

thalesloks 1

Link para o comentário

Compartilhar em outros sites

biel1010 1

Link para o comentário

Compartilhar em outros sites

Quem Está Navegando 0 membros estão online

Conteúdo Similar

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

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

Letreiro ao entrar em local

poketibia Problemas com mapa

Fóruns

Tutoriais

Suporte