Solved [Gesior acc] Most powerfull guilds link error

[Xavicrak]

i have 1 problem with this script:
--link guild not work: when i click in any guild and appear this menssage: "The Following Errors Have Occurred:
Invalid guild name format."

i used this script:

   $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, 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>';

any idea??

 

[Cronox]

Change for this..

<?PHP
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
if($action == "") {
$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, 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>';

 

[Xavicrak]

;( same error:
The Following Errors Have Occurred:
Invalid guild name format.

 

[Cronox]

Upload your photo to the error so it's faster to see

 

[Xavicrak]

here

 

[Cronox]

change your guilds.php for this
guilds.php - Speedy Share - upload your files here

 

[Xavicrak]

solved thanks

 

[konolo22]

please reup guilds.php ;/
have some error

 

[Cleto24]

please reup guilds.php ;/
have some error

Yeah please reup same error :/