Php Easy

[Vrotz]

I need one latestnews.php idem this: Throne OT - Latest News

where the Top Guilds is one "Feature".

I've create one but idk i have error of "T_STRING" ¬¬"

Tks

 

[T0MBIE]

well, first of all, you could start by posting your SQL table struckture of guilds and news ?

 

[Ninja]

Here you go.

//most powerfull guilds
$news_content .= '
<div id="featuredarticle" class="Box">
   <div class="Corner-tl" style="background-image: url('.$layout_name.'/images/content/corner-tl.gif);"></div>
   <div class="Corner-tr" style="background-image: url('.$layout_name.'/images/content/corner-tr.gif);"></div>
   <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>
   <div class="BorderTitleText" style="background-image: url('.$layout_name.'/images/content/title-background-green.gif);"></div>
   <img class="Title" src="headline.php?txt=Most Powerful Guilds" alt="Contentbox headline" />
   <div class="Border_2">
       <div class="Border_3">
           <div class="BoxContent" style="background-image: url("'.$layout_name.'/images/content/scroll.gif");">
               <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, 1;') as $guild)
                    $news_content .= '
                       <td style="width: 20%; text-align: center;">
                           <a rel="nofollow" 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 /><font color="#00BF00"><b>' . $guild['frags'] . '</b></font> kills
                       </td>';
 
$news_content .= '
                   </tr>
               </table>
           </div>
       </div>
   </div>
   <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>
   <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>
   <div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div>
</div>';

 

[Vrotz]

REP+, Thanks, Ninja..