helpppppppp

[andre2005 0]

to no site gersor 0.3.8 olha oq acontece quando eu clico no high score

 

 

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Sao_Paulo' for '-3.0/no DST' instead in C:\xampp\htdocs\latestnews.php on line 122

 

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Sao_Paulo' for '-3.0/no DST' instead in C:\xampp\htdocs\latestnews.php on line 122

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in C:\xampp\htdocs\latestnews.php:238 Stack trace: #0 C:\xampp\htdocs\latestnews.php(238): PDO->query('SELECT `z_forum...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 238

 

e quando eu clico em war aparece isso sera q um tem a ve com outro?

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fatalfury.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

[patrick1997x 0]

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Sao_Paulo' for '-3.0/no DST' instead in C:\xampp\htdocs\latestnews.php on line 122

Va ate o C:\xampp\htdocs\latestnews.php, Adicione na primeira linha isso

<?php

date_default_timezone_set('America/Sao_Paulo');

?>

Feche e salve , e fassa a mesma coisa com os outros scripts que der o mesmo erro...

 

Voce tem que adiconar as tabelas no seu BANCO DE DADOS...

Eu sei qual gesior voce baixou , la em baixo no topico do cara tem o download das tables.

[andre2005 0]

olha como q ta

<?PHP

date_default_timezone_set('America/Sao_Paulo');

$time = time();

/////////////////////////////////////////////////////////////////////////////////////////

//The new edition of my script: Best Player, Last joined and something new Server Motd.//

/////////////////////////Everything in the new appearance.///////////////////////////////

//////////////////////////////////////by Aleh///////////////////////////////////////////

/////////////////////////////////////////////////////////////////////////////////////////

///Queries ///

$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` 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 `lastwarning`>1;')->fetch();

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

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

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

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

///End Queries ///

 

$main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>

<tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Welcome to '.$config['server']['serverName'].'</b></td></tr>

<tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>

 

<tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>, player number '.$query2['id'].'. Welcome and wish you a nice game!</center></td></tr>

<tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>

<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> '.$query['text'].'</center></td></tr>

<table border=0 cellpadding=0 cellspacing=1 width=100%>

<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$housesfree[0].'</center></td>

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

<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>

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

<tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Banned</b> accounts: '.$banned[0].'</center></td>

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

 

</table></td></tr></table>';

 

///Don't delete this! Please respect my work! I am counting on reputation.

$main_content .= '<div align="right"><small><b></b></small></div><br />';

///Don't delete this! Please respect my work! I am counting on reputation.

div>';';

 

//######################## SHOW TICKERS AND NEWS #######################

$time = time();

$main_content .= '<div class="NewsHeadline">

<div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">

<table border="0">

<tr>

<td style="text-align: center; font-weight: bold;">

<font color="white">Most powerfull guilds</font>

</td>

</tr>

</table>

</div>

</div>

<table border="0" cellspacing="3" cellpadding="4" width="100%">

<tr>';

 

foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,

`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`

FROM `killers` k

LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`

LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`

LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`

LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`

WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1

GROUP BY `name`

ORDER BY `frags` DESC, `name` ASC

LIMIT 0, 6;') as $guild)

$main_content .= ' <td style="width: 25%; text-align: center;">

<a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/><br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills

</td>';

 

$main_content .= ' </tr>

</table>';

if ($logged){

$players_from_account = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();

foreach($players_from_account as $player)

{

$str .= '<option value="'.$player['id'].'"';

if($player['id'] == $char_id)

$strt .= ' selected="selected"';

$str .= '>'.$player['name'].'</option>';

}

}

$time = time();

$news_content .= '<div id="newsticker" class="Box">

 

add isso dai ai fico dando esse daki

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in C:\xampp\htdocs\latestnews.php:275 Stack trace: #0 C:\xampp\htdocs\latestnews.php(275): PDO->query('SELECT `z_forum...') #1 C:\xampp\htdocs\index.php(63): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 275