Normal [AJUDA] Talvez problema com database? <- POR FAVOR LEIA

[VitorNM 31]

Seguinte, ultimamente venho tentando adicionar algumas coisas em meu site, porém os erros sempre apontam em linhas parecidas...

Para explicar melhor, quando tentei colocar o Most Powerfull Guilds em meu latestnews.php, o erro fica nessa linha:

 

"LIMIT 0, 4;') as $guild)"

 

E quando fui tentar colocar o widget Top 5 level, o erro persiste nessa linha:

 

"foreach($skills as $skill)"

 

--

 

E os dois erros aparecem no seguinte padrão: "Warning: Invalid argument supplied for foreach()"

 

 

Segue o trecho do "Most Powerfull Guilds" do arquivo latestnews.php:

//######################## MOST POWERFUL GUILDS #######################

$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=' . $guilds['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>';

 

Segue o widget_rank.php:

<?php

$skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < '.$config['site']['players_group_id_block'].' AND account_id != 1 ORDER BY level DESC LIMIT 5');

?>

<style type="text/css" media="all">

  .Toplevelbox {

    position: relative;

    margin-bottom: 12px;

    width: 180px;

    height: 225px;

  }

  .top_level {

    position: absolute;

    top: 30px;

    left: 6px;

    height: 180px;

    width: 168px;

    z-index: 20;

    text-align: center;

    padding-top: 6px;

    font-family: Tahoma, Geneva, sans-serif;

    font-size: 9.2pt;

    color: #FFF;

    font-weight: bold;

    text-align: right;

    text-decoration: inherit;

    text-shadow: 0.1em 0.1em #333

  }

  #Topbar a {

  text-decoration: none;

  cursor: hand;

  }

  a.topfont {

    font-family: Verdana, Arial, Helvetica;

    font-size: 13px;

    color: #0F0;

    text-decoration: none

  }

  a:hover.topfont {

    font-family: Verdana, Arial, Helvetica;

    font-size: 13px; 

    color: #CCC;

    text-decoration:none

  }

  .Bottom1 {

  position: relative;

  bottom: -12px;

  left: -5px;

  height: 12px;

  width: 180px;

}

</style>

<div id="Topbar" class="Toplevelbox" style="background-image:url(<?PHP echo $layout_name; ?>/images/top_level.png);">

  <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/bg_top.png)" align="left">

    <?php

    $a = 1;

    foreach($skills as $skill) {

 echo '<div align="left"><a href="?subtopic=characters&name='.$skill['name'].'" class="topfont">

   <font color="#CCC">&nbsp;&nbsp;&nbsp;&nbsp;'.$a.' - </font>'.$skill['name'].'

   <br>

   <small><font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Level: ('.$skill['level'].')</font></small>

   <br>

 </a>

 </div>';

 $a++;

    }

    ?>

<br>

<br>

<br>

<br>

    <div class="Bottom1" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);">

    </div>

  </div>

</div>

 

Poxa, por favor, se alguém puder me ajudar, não quero desistir, não mesmo, mas já há alguns dias que estou persistindo no erro :/

 

 

--- EDIT ---

 

 

Meus dois problemas foram resolvidos, corri bastante atrás e estou satisfeito com o resultado...

Resolução:

 

• Referente ao problema do Most Powerfull Guilds no latestnews.php, basta alterar o código mencionado acima por esse, foi essa minha solução:

$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%"><tr>';

   

    foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;') 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>';

 

• Referente ao problema com o Widget de Top 5 Leveis do servidor, fiz uma alteração do trecho '.$config['site']['players_group_id_block'].' por 2    Sim, isso mesmo, bastava mudar aquele trecho pelo número 2... Resultando nesse widget_rank.php:

<?php

$skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < 2 AND account_id != 1 ORDER BY level DESC LIMIT 5');

?>

<style type="text/css" media="all">

  .Toplevelbox {

    position: relative;

    margin-bottom: 12px;

    width: 180px;

    height: 225px;

  }

  .top_level {

    position: absolute;

    top: 30px;

    left: 6px;

    height: 180px;

    width: 168px;

    z-index: 20;

    text-align: center;

    padding-top: 6px;

    font-family: Tahoma, Geneva, sans-serif;

    font-size: 9.2pt;

    color: #FFF;

    font-weight: bold;

    text-align: right;

    text-decoration: inherit;

    text-shadow: 0.1em 0.1em #333

  }

  #Topbar a {

  text-decoration: none;

  cursor: hand;

  }

  a.topfont {

    font-family: Verdana, Arial, Helvetica;

    font-size: 13px;

    color: #0F0;

    text-decoration: none

  }

  a:hover.topfont {

    font-family: Verdana, Arial, Helvetica;

    font-size: 13px; 

    color: #CCC;

    text-decoration:none

  }

  .Bottom1 {

  position: relative;

  bottom: -12px;

  left: -5px;

  height: 12px;

  width: 180px;

}

</style>

<div id="Topbar" class="Toplevelbox" style="background-image:url(<?PHP echo $layout_name; ?>/images/top_level.png);">

  <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/bg_top.png)" align="left">

    <?php

    $a = 1;

foreach($skills as $skill)

{

 echo '<div align="left"><a href="?subtopic=characters&name='.$skill['name'].'" class="topfont">

   <font color="#CCC">&nbsp;&nbsp;&nbsp;&nbsp;'.$a.' - </font>'.$skill['name'].'

   <br>

   <small><font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Level: ('.$skill['level'].')</font></small>

   <br>

 </a>

 </div>';

 $a++;

    }

    ?>

    <div class="Bottom1" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);">

    </div>

  </div>

</div>

 

 

Tópico resolvido e encerrado.

Editado Setembro 22, 2015 por VitorNM (veja o histórico de edições)