[HELP PLEASE] Most Powerfull Guilds on latestnews

[VitorNM]

Hello guys. I'm trying to place in my gesior latestnews the "most powerfull guilds" system, but in all cases, i have an error with this line: " LIMIT 0, 4;') as $guild)" PLEASE anybody can help me?

Sorry for my bad english, i'm trying :s

Here is the script i'm using:

Spoiler

$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="gold">Most powerfull guilds</font>
</td>
</tr>
</table>
</div>
</div>
<table border="0" cellspacing="3" cellpadding="4" width="100%" bgcolor="#D4C0A1">
<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, 4;') 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>';

the error is:
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\latestnews.php on line 42

#BUMP

 

[Codex NG]

There is no line 42 in the code you posted, it only goes up to line 34

 

[VitorNM]

i have posted only the most powerfull guilds script, not the latestnews full page... this error LIMIT 0, 4;') as $guild) is on line 42 the entire page's script.

#UP

 

[VitorNM]

#UP

 

[Hatsune Miku]

Post every script related to it or link us to where you got that script.. Easier to find the error.

 

[VitorNM]

i don't know where i take this, but i just copy and paste in latest news this spoiler... i think i need to execute any sql query, but i don't know

 

[Hatsune Miku]

Great solution:
Uninstall gesior cause it sucks and get znote.

https://otland.net/threads/znote-aac-most-powerful-guilds-tfs-0-3-4-and-1-0.209045/

Thats for most powerfull guilds.

If you need anything else go to ************