Carlitos Flow
Developer (lvl*1)
- Joined
- Mar 2, 2011
- Messages
- 156
- Solutions
- 4
- Reaction score
- 10
Good day OTland, i get an error in my console saying that ever than save:
I only added most powerful guild to my website, and it start to send this error, what could be? please help, here is the first part of my lastest new.php (i put this)
Please guys help me, thanks
I only added most powerful guild to my website, and it start to send this error, what could be? please help, here is the first part of my lastest new.php (i put this)
LUA:
?PHP
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
$query =$SQL->query("SELECT * FROM `players` ORDER BY `experience` DESC")->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();
$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 ///
// top kills - guilds
$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, 3;') as $guild)
$main_content .=' <td style="width: 25%; text-align: center;">
<a href="?subtopic=guilds&action=show&guild='.$guild['id'].'"><img src="guild_image.php?id='.$guild['id'].'" width="64" height="64" border="0"/> <br />'.$guild['name'].'</a><br />'.$guild['frags'].' kills
</td>';
$main_content .=' </tr>
</table>';
Please guys help me, thanks