• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Please correct the error

di12345di

di12345di

New Member
Joined
Aug 1, 2012
Messages
105
Reaction score
0
Please correct the error

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\snowballwar.php on line 147

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\snowballwar.php on line 225

snowballwar.php
PHP: 
<?php
    $consulta = $SQL->query('SELECT `name`,`score`,`data`, `hora` FROM `snowballwar` ORDER BY `id` DESC LIMIT 20;');
    $consulta2 = $SQL->query('SELECT * FROM `players` ORDER BY `sbw_points` DESC LIMIT 3;');
    $number_of_rows = 0;
  
    $main_content .= '
        <center><h2>Evento Snowball War</h2></center><div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
                                                    <div class="TableContentContainer" >
                                                        <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >
                                                            <tr>
                                                                <td>O evento ser&aacute; executado todos os dias da semana as 16:00 horas.</td>
                                                            </tr>                                  
                                                        </table>
                                                    </div>
                                                </div>                                          
                                            <div class="TableShadowContainer" >
                                                <div class="TableBottomShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bm.gif);" >
                                                    <div class="TableBottomLeftShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bl.gif);" ></div>
                                                    <div class="TableBottomRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-br.gif);" ></div>
                                                </div>
                                            </div>
                                        </td>
                                    </tr>      
                                    <tr>
                                        <td>
                                            <div class="TableShadowContainerRightTop" >
                                                <div class="TableShadowRightTop" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rt.gif);" ></div>
                                            </div>
                                            <div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
                                                <div class="TableContentContainer" >
                                                    <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >  
                                                        </tr>
                                                            <td colspan="3" bgcolor="#505050">
                                                                <span class="style4">
                                                                    <font color="white">S&oacute; ter&atilde;o tr&ecirc;s ganhadores, os tr&ecirc;s que pontuar mais, os pr&ecirc;mios s&atilde;o:</font>
                                                                </span>
                                                            </td>
                                                        </tr>
                                                        <tr bgcolor="#f1e0c6">
                                                            <td width="15%">
                                                                <b>Pr&ecirc;mios:</b></td><td width="80%"><b>1 - </b> <u>25 Mega Coins e 70 Crystal Coins</u><br><b>2 - </b> <u>20 Mega Coins e 50 Crystal Coins</u><br><b>3 - </b> <u>15 Mega Coins e 30 Crystal Coins</u>
                                                            </td>
                                                        </tr>                                                                  
                                                    </table>
                                                </div>
                                            </div>                                          
                                            <div class="TableShadowContainer" >
                                                <div class="TableBottomShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bm.gif);" >
                                                    <div class="TableBottomLeftShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bl.gif);" ></div>
                                                    <div class="TableBottomRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-br.gif);" ></div>
                                                </div>
                                            </div>
                                        </td>
                                    </tr>  

        </br>
        <center>
Seus jogadores irao se divertir em uma emocionante partida de guerra de bolas de neve. O objetivo principal do evento e derrubar o numero maximo de jogadores durante uma partida - atirando bolas de neve contra seus inimigos. O top score points ao final da rodada sera o vencedor.
        </br>  
        <iframe width="560" height="315" src="https://www.youtube.com/embed/hpreUYM7rVI" frameborder="0" allowfullscreen></iframe>
        </center>
        </br>
        <div class="TableContainer">
            <div class="CaptionContainer">
            <div class="CaptionInnerContainer">
                <span class="CaptionEdgeLeftTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionEdgeRightTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionBorderTop" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
                <span class="CaptionVerticalLeft" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
                <div class="Text">Informacoes</div>
                <span class="CaptionVerticalRight" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
                <span class="CaptionBorderBottom" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
                <span class="CaptionEdgeLeftBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionEdgeRightBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
            </div>
        </div>
      
        <table class="Table1" cellpadding="0" cellspacing="0">
      
        <tbody><tr>
            <td>
                <div class="InnerTableContainer">
                    <table width="100%">
                        <tbody>
                        <tr style="background-color:#af2126;">
                            <td class="LabelV150"><b><font color="white">#</font></b></td>
                            <td class="LabelV150"><b><font color="white">Descricao</font></b></td>
                        </tr>
                        <tr style="background-color:'.$config['site']['lightborder'].';">
                            <td>
                                Atirar
                            </td>
                            <td>
                                Comando "!snowball atirar", lanca 1 bola de neve em seu adversario.
                            </td>
                        </tr>
                        <tr style="background-color:'.$config['site']['lightborder'].';">
                            <td>
                                Info. In-game
                            </td>
                            <td>
                                Comando "!snowball info", veja a sua quantia de bolas de neve que voce tem e sua quantia de pontos. Tambem o ranking geral dentro do evento.
                            </td>
                        </tr>
                        <tr style="background-color:'.$config['site']['lightborder'].';">
                            <td>
                                Recarregar
                            </td>
                            <td>
                                Se dirija ate ao centro do mapa do evento e recarregue clicando no gerador.
                            </td>
                        </tr>
            </tbody></table>
                </div>
            </td>
        </tr>
    </tbody></table>
        </div>
        </br>
        </br>
      
        <div class="TableContainer">
            <div class="CaptionContainer">
            <div class="CaptionInnerContainer">
                <span class="CaptionEdgeLeftTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionEdgeRightTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionBorderTop" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
                <span class="CaptionVerticalLeft" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
                <div class="Text">TOP Ranking</div>
                <span class="CaptionVerticalRight" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
                <span class="CaptionBorderBottom" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
                <span class="CaptionEdgeLeftBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionEdgeRightBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
            </div>
        </div><table class="Table1" cellpadding="0" cellspacing="0">
      
        <tbody><tr>
            <td>
                <div class="InnerTableContainer">
                    <table width="100%">
                        <tbody>
                        <tr>


                        ';

        foreach($consulta2 as $info2) {
    if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; }
        $number_of_rows++;
    $main_content .= '
        <td bgcolor="'.$config['site']['lightborder'].'">
        <center>
        </br>
        <a href="index.php?subtopic=characters&name='.urlencode($info2['name']).'">
            <b> '.$info2['name'].' </b>
        </a>
            </br>
            <img align="center" src="/images/outfit.php?id='.$info2['looktype'].'&addons='.$info2['lookaddons'].'&head='.$info2['lookhead'].'&body='.$info2['lookbody'].'&legs='.$info2['looklegs'].'&feet='.$info2['lookfeet'].'" width="94" height="94" style="width: 94px; height: 94px; margin-top:-30px; margin-left:-65px;  background-repeat: no-repeat;">
            </br></br>

            ';
            if ($number_of_rows == 1) {
                $main_content .= '
                    <img align="center" src="http://www.tibiawiki.com.br/images/a/a7/Golden_Goblet.gif" />
                ';
            }
            if ($number_of_rows == 2) {
                $main_content .= '
                    <img align="center" src="http://www.tibiawiki.com.br/images/9/90/Silver_Goblet.gif" />
                ';
              
            }
            if ($number_of_rows == 3) {
                $main_content .= '
                    <img align="center" src="http://www.tibiawiki.com.br/images/4/41/Bronze_Goblet.gif" />
            ';
            }
            $main_content .= '
            </br>
            <b>Pontos:</b> ' . $info2['sbw_points'] . '
        </td>
        </center>
      
        ';
    }
    $main_content .= '
        </tr>
    </tbody></table>
                </div>
            </td>
        </tr>
    </tbody></table>
        </div>
      
        </br></br>

      
      
        <div class="TableContainer">
            <div class="CaptionContainer">
            <div class="CaptionInnerContainer">
                <span class="CaptionEdgeLeftTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionEdgeRightTop" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionBorderTop" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
                <span class="CaptionVerticalLeft" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
                <div class="Text">Ultimos Ganhadores</div>
                <span class="CaptionVerticalRight" style="background-image:url(./layouts/tibiarl/images/content/box-frame-vertical.gif)"></span>
                <span class="CaptionBorderBottom" style="background-image:url(./layouts/tibiarl/images/content/table-headline-border.gif)"></span>
                <span class="CaptionEdgeLeftBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
                <span class="CaptionEdgeRightBottom" style="background-image:url(./layouts/tibiarl/images/content/box-frame-edge.gif)"></span>
            </div>
        </div><table class="Table1" cellpadding="0" cellspacing="0">
      
        <tbody><tr>
            <td>
                <div class="InnerTableContainer">
                    <table width="100%">
                        <tbody>
                        <tr style="background-color:#af2126;">
                            <td class="LabelV150"><b><font color="white">Nome</font></b></td>
                            <td class="LabelV150"><b><font color="white">Pontos</font></b></td>
                            <td class="LabelV150"><b><font color="white"> Data - Hora</font></b></td>
                        </tr>
    ';  
    foreach($consulta as $info) {
    if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; }
        $number_of_rows++;
    $main_content .= '
    <tr bgcolor="'.$config['site']['lightborder'].'">
        <td>
            <a href="index.php?subtopic=characters&name='.urlencode($info['name']).'">
            <b> '.$info['name'].' </b></a>
        </td>
        <td>
            ' . $info['score'] . '
        </td>
        <td>
                <b> ' . $info['data'] . '</b> - <b>' . $info['hora'] . '</b>
        </td>
    </tr>
        ';
    }
    $main_content .= '
    </tbody></table>
                </div>
            </td>
        </tr>
    </tbody></table>
</div>
    </br>
  
<br>
<b>Event Coins & NPC Mega Events<br></b>
<br>
<div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
                                                        <div class="TableContentContainer" >
                                                            <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >
                                                                <tr>
                                                                    <td><b>150 Events Coins, + 1 premium point</b><b></b>.</td>
                                                                </tr>                                  
                                                            </table>
                                                        </div>
                                                    </div>
<div class="TableShadowContainer" >
                                                        <div class="TableBottomShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bm.gif);" >
                                                            <div class="TableBottomLeftShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-bl.gif);" ></div>
                                                            <div class="TableBottomRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-br.gif);" ></div>
                                                        </div>
                                                    </div>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    <div class="TableShadowContainerRightTop" >
                                                        <div class="TableShadowRightTop" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rt.gif);" ></div>
                                                    </div>
                                                    <div class="TableContentAndRightShadow" style="background-image:url(./layouts/tibiarl/images/global/content/table-shadow-rm.gif);" >
                                                        <div class="TableContentContainer" >
                                                            <table class="TableContent" width="100%"  style="border:1px solid #faf0d7;" >
                                                                <tr>
                                                                    <td width="50%"><b></b></br><img src="snowball.png"></td><td width="50%"></br></td>
                                                                </tr>                                  
                                                            </table>
                                                        </div>
                                                    </div>              

<br>

  
';

?>
 
Last edited:
Sort by date Sort by votes
http://php.net/manual/en/control-structures.foreach.php
foreach (array_expression as $value)
Click to expand...
array_expression's are "$consulta2" and "$consulta" - in code you have provided they are defined as SQL query results, thus it suggest you could:
  • have no connection to db - check it first before executing a loop
  • result is empty or invalid - can you profide result for those 2 SQL queries?
In general your code is very bad, please use templating engine and do not write inline HTML.
 
Upvote 0 Downvote

Similar threads

V
  • Question
AAC reset system geisor
Replies
0
Views
308
vitorelias1
V
Hokku
  • Question
Featured article problem with db
Replies
2
Views
323
Hokku
Hokku
J
  • Question
gallery stopped working -oldschool znoteacc
Replies
3
Views
351
Jeyci
J
OTcreator
  • Question
MyACC [ONI TEMPLATE] Outfit on TOP5.
Replies
1
Views
383
Addams
Addams
O
  • Question
help name of the invisible towns in myacc
Replies
2
Views
425
tobi132
T
Back
Top