Hompage fehler

03/21/2015 15:32 infinty04#1
Hallo

kann mir einer sagen wo der fehler hier ist

Quote:
[21-Mar-2015 13:53:28 UTC] PHP Notice: Undefined variable: i in /home/darknig/public_html/root/index.php on line 112
[21-Mar-2015 13:53:35 UTC] PHP Notice: Undefined variable: i in /home/darknig/public_html/root/index.php on line 112
[21-Mar-2015 13:53:38 UTC] PHP Notice: Undefined variable: i in /home/darknig/public_html/root/index.php on line 112
[21-Mar-2015 13:53:56 UTC] PHP Notice: Undefined variable: i in /home/darknig/public_html/root/index.php on line 112
index php
Quote:
PHP Code:
<?PHP
    /*DEBUG*/
    //ini_set("display_errors", "1");
    ERROR_REPORTING(E_ALL);
    
    header('Content-Type: text/html; charset=UTF-8');
    session_name("m2hp");
    session_start();

    require("./inc/config.inc.php");
    require("./inc/rights.inc.php");
    require("./inc/functions.inc.php");

    $sqlHp = mysql_connect(SQL_HP_HOST, SQL_HP_USER, SQL_HP_PASS);
    mysql_query("SET NAMES 'utf8'");
    mysql_query("SET CHARACTER SET 'utf8'");
    $sqlServ = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS);

    if(!is_resource($sqlServ) OR !is_resource($sqlHp)) {
        exit("Verbindung zur Datenbank fehlgeschlagen: Abbruch");
    }
    require("./inc/head.inc.php");
?>
<!DOCTYPE html>
<html>
    <head>
        <title>SoaMt2</title>
        <meta charset="utf-8">
        <!-- CSS -->
        <link rel="stylesheet" href="css/style.css">
        <!-- JS -->
        <script type="text/javascript" language="javascript" src="js/jquery-1.6.3.min.js"></script>
        <script type="text/javascript" language="javascript" src="js/main.js"></script>
        <script>
        function scrollWin() {
            window.scrollTo(0, 0);
        }
        </script>
    </head>
    <body>
        <div id="main_content">
            <div id="content">
                <a href="index.html"><div id="header"></div></a>
                <div id="content_mid">
                    <div id="navi">
                        <a href="index.php"><div id="navi_l1">Startseite</div></a>  
                         <a href="?s=rankings"><div id="navi_l2">Rangliste</div></a>  
                         <a href="?s=downloads"><div id="navi_download"></div></a>
                         <a href="?s=register"><div id="navi_l3">Registrieren</div></a>
                         <a href="#"><div id="navi_l4">Community</div></a>
                    </div>
                    <div id="navi2">
                        <div id="navi2_v4us"></div>
                        <div id="navi2_login">
                            
                        <?php
                        if(!isset($_SESSION['user_id'])) {
                    ?>
                            <form action="?s=login" method="post">
                                <div id="navi2_login_input">
                                    <input type="text" name="userid" class="input_l input_login_name" placeholder="Benutzername">
                                    <input type="password" name="userpass" class="input_r input_login_pw" placeholder="Passwort">
                                </div>
                                <div id="navi2_login_control">
                                    <a href="?s=lostpw"><button type="button" class="btn_pwlost"></button></a>
                                    <button type="submit" name="submit" class="btn_login"></button>
                                    <a href="?s=register"><button type="button" class="btn_register"></button></a>
                                </div>
                            </form>
            <?php
                        } else {
                    ?>
                                <div id="navi2_login_input"></div>
                                <div id="navi2_login_control" style="text-align:center;margin-top: 3px; color:#9ecbfb;">
                                    <a href="?s=login">User Panel</a> 
                                    <a href="?s=itemshop">Itemshop</a> 
                                    <a href="?s=vote">Vote4Coins</a> 
                                    <a href="?s=voucher">Spenden</a> 
                                    <a href="?s=logout">Logout</a>
                                </div>
            <?php
                        }
                    ?>

                        </div>
                        <div id="navi2_support"></div>
                    </div>
                    <div id="left_bar">
                        <div class="left_bar_item">
                            <div id="left_bar_server_online_head"></div>
                            <?php require("./inc/status.inc.php"); ?>
                        </div>
                        <div class="left_bar_item left_bar_item_topgilde">
                            <div id="left_bar_topgilden_head"></div>
                            <div id="left_bar_topgilden_content">
                                <table>
                                    <?PHP
                                    $sqlCmd = "SELECT guild.name, guild.master, guild.exp, guild.ladder_point, guild.win, player_index.empire
                                    FROM player.guild

                                    INNER JOIN player.player
                                    ON player.id=guild.master

                                    INNER JOIN player.player_index
                                    ON player_index.id=player.account_id

                                    ORDER BY guild.level DESC, guild.exp DESC, guild.win DESC, guild.ladder_point DESC 
                                    LIMIT 10";

                                    $sqlQry = mysql_query($sqlCmd, $sqlServ);
                                    while($getPlayers = mysql_fetch_object($sqlQry)) {
                                            $i++;
                                            echo '<tr>';
                                            if($i <= 3){
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content platz'.$i.'">';
                                            }else {
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content">';
                                            }
                                            
                                            echo $getPlayers->name.'<br>';
                                            echo $getPlayers->ladder_point.' Punkte Reich: ';
                                            
                                            if($getPlayers->empire == 1)
                                            {echo '<span style="color:red">Rot</span> ';}
                                            elseif($getPlayers->empire == 2)
                                            {echo '<span style="color:yellow">Gelb</span> ';}
                                            elseif($getPlayers->empire == 3)
                                            {echo '<span style="color:blue">Blau</span> ';}
                                            
                                            echo '</div></td></tr>'; 
                                    }
                            ?>
                              </table>
                            </div>
                        </div>
                        <div class="left_bar_item">
                            <div id="left_bar_social_head"></div>
                            <a href="#"><div id="left_bar_social_youtube"></div></a>
                            <a href="#"><div id="left_bar_social_facebook"></div></a>
                            <a href="#"><div id="left_bar_social_epvp"></div></a>
                        </div>
                    </div>
                    <div id="mid">
                        <?PHP
                            $includeDir = ".".DIRECTORY_SEPARATOR."pages".DIRECTORY_SEPARATOR;
                            $includeDefault = $includeDir."home.php";

                            if(isset($_GET['s']) && !empty($_GET['s']))
                            {

                                    $_GET['s'] = str_replace("\0", '', $_GET['s']);
                                    $includeFile = basename(realpath($includeDir.$_GET['s'].".php"));
                                    $includePath = $includeDir.$includeFile;

                                    if(!empty($includeFile) && file_exists($includePath)) 
                                    {
                                            include($includePath);
                                    }
                                    else 
                                    {
                                            include($includeDefault);
                                    }
                            } 
                            else 
                            {
                                    include($includeDefault);
                            }
            ?>
                  </div>
                    <div id="right_bar">
                        <div class="right_bar_item right_bar_item_topplayer">
                            <div id="right_bar_topplayer_head"></div>
                            <div id="right_bar_topplayer_content">
                                <table>
                                    <?PHP
                                    $sqlCmd = "SELECT player.id,player.name,player.level,player.exp, player.job, player_index.empire,guild.name AS guild_name 
                                    FROM player.player 
                                    LEFT JOIN player.player_index 
                                    ON player_index.id=player.account_id 
                                    LEFT JOIN player.guild_member 
                                    ON guild_member.pid=player.id 
                                    LEFT JOIN player.guild 
                                    ON guild.id=guild_member.guild_id
                                    INNER JOIN account.account 
                                    ON account.id=player.account_id
                                    WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' 
                                    ORDER BY player.level DESC, player.exp DESC , name ASC LIMIT 10";
                                    $i=0;
                                    $sqlQry = mysql_query($sqlCmd, $sqlServ);
                                    while($getPlayers = mysql_fetch_object($sqlQry)) {
                                            $i++;
                                            echo '<tr>';
                                            if($i <= 3){
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content platz'.$i.'">';
                                            }else {
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content">';
                                            }
                                            
                                            echo $getPlayers->name.'<br>';
                                            echo 'Lvl '.$getPlayers->level.' Reich: ';
                                            
                                            if($getPlayers->empire == 1)
                                            {echo '<span style="color:red">Rot</span> ';}
                                            elseif($getPlayers->empire == 2)
                                            {echo '<span style="color:yellow">Gelb</span> ';}
                                            elseif($getPlayers->empire == 3)
                                            {echo '<span style="color:blue">Blau</span> ';}

                                            if($getPlayers->job == 1)
                                            {echo 'Ninja';}
                                            elseif($getPlayers->job == 2)
                                            {echo 'Sura';}
                                            elseif($getPlayers->job== 3)
                                            {echo 'Schamane';}
                                            elseif($getPlayers->job == 4)
                                            {echo 'Kreiger';}
                                            
                                            echo '</div></td></tr>';    
                                    }
                                    ?>

                                   </table>
                            </div>
                        </div>
                        <div class="right_bar_item">
                            <div id="right_bar_status_head"></div>
                            <div id="right_bar_status_content">
                                <?php require("./inc/info.inc.php"); ?>
                            </div>
                        </div>
                        <div class="right_bar_item">
                            <div id="right_bar_ts3_head"></div>
                            <a href="#"><div id="right_bar_ts3_content"></div></a>
                        </div>
                    </div>
                </div>
                <a><div id="gotop" onclick="scrollWin();" ></div></a>
            </div>
            <div id="footer"></div>
        </div>
    </body>
</html>
03/21/2015 17:30 methosiea#2
PHP Code:
<?PHP 
    /*DEBUG*/ 
    //ini_set("display_errors", "1"); 
    ERROR_REPORTING(E_ALL); 
     
    header('Content-Type: text/html; charset=UTF-8'); 
    session_name("m2hp"); 
    session_start(); 

    require("./inc/config.inc.php"); 
    require("./inc/rights.inc.php"); 
    require("./inc/functions.inc.php"); 

    $sqlHp = mysql_connect(SQL_HP_HOST, SQL_HP_USER, SQL_HP_PASS); 
    mysql_query("SET NAMES 'utf8'"); 
    mysql_query("SET CHARACTER SET 'utf8'"); 
    $sqlServ = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS); 

    if(!is_resource($sqlServ) OR !is_resource($sqlHp)) { 
        exit("Verbindung zur Datenbank fehlgeschlagen: Abbruch"); 
    } 
    require("./inc/head.inc.php"); 
?> 
<!DOCTYPE html> 
<html> 
    <head> 
        <title>SoaMt2</title> 
        <meta charset="utf-8"> 
        <!-- CSS --> 
        <link rel="stylesheet" href="css/style.css"> 
        <!-- JS --> 
        <script type="text/javascript" language="javascript" src="js/jquery-1.6.3.min.js"></script> 
        <script type="text/javascript" language="javascript" src="js/main.js"></script> 
        <script> 
        function scrollWin() { 
            window.scrollTo(0, 0); 
        } 
        </script> 
    </head> 
    <body> 
        <div id="main_content"> 
            <div id="content"> 
                <a href="index.html"><div id="header"></div></a> 
                <div id="content_mid"> 
                    <div id="navi"> 
                        <a href="index.php"><div id="navi_l1">Startseite</div></a>   
                         <a href="?s=rankings"><div id="navi_l2">Rangliste</div></a>   
                         <a href="?s=downloads"><div id="navi_download"></div></a> 
                         <a href="?s=register"><div id="navi_l3">Registrieren</div></a> 
                         <a href="#"><div id="navi_l4">Community</div></a> 
                    </div> 
                    <div id="navi2"> 
                        <div id="navi2_v4us"></div> 
                        <div id="navi2_login"> 
                             
                        <?php 
                        if(!isset($_SESSION['user_id'])) { 
                    ?> 
                            <form action="?s=login" method="post"> 
                                <div id="navi2_login_input"> 
                                    <input type="text" name="userid" class="input_l input_login_name" placeholder="Benutzername"> 
                                    <input type="password" name="userpass" class="input_r input_login_pw" placeholder="Passwort"> 
                                </div> 
                                <div id="navi2_login_control"> 
                                    <a href="?s=lostpw"><button type="button" class="btn_pwlost"></button></a> 
                                    <button type="submit" name="submit" class="btn_login"></button> 
                                    <a href="?s=register"><button type="button" class="btn_register"></button></a> 
                                </div> 
                            </form> 
            <?php 
                        } else { 
                    ?> 
                                <div id="navi2_login_input"></div> 
                                <div id="navi2_login_control" style="text-align:center;margin-top: 3px; color:#9ecbfb;"> 
                                    <a href="?s=login">User Panel</a>  
                                    <a href="?s=itemshop">Itemshop</a>  
                                    <a href="?s=vote">Vote4Coins</a>  
                                    <a href="?s=voucher">Spenden</a>  
                                    <a href="?s=logout">Logout</a> 
                                </div> 
            <?php 
                        } 
                    ?> 

                        </div> 
                        <div id="navi2_support"></div> 
                    </div> 
                    <div id="left_bar"> 
                        <div class="left_bar_item"> 
                            <div id="left_bar_server_online_head"></div> 
                            <?php require("./inc/status.inc.php"); ?> 
                        </div> 
                        <div class="left_bar_item left_bar_item_topgilde"> 
                            <div id="left_bar_topgilden_head"></div> 
                            <div id="left_bar_topgilden_content"> 
                                <table> 
                                    <?PHP 
                                    $sqlCmd = "SELECT guild.name, guild.master, guild.exp, guild.ladder_point, guild.win, player_index.empire 
                                    FROM player.guild 

                                    INNER JOIN player.player 
                                    ON player.id=guild.master 

                                    INNER JOIN player.player_index 
                                    ON player_index.id=player.account_id 

                                    ORDER BY guild.level DESC, guild.exp DESC, guild.win DESC, guild.ladder_point DESC  
                                    LIMIT 10"; 

                                    $sqlQry = mysql_query($sqlCmd, $sqlServ); 
                                    while($getPlayers = mysql_fetch_object($sqlQry)) { 
                                            $i++; 
                                            echo '<tr>'; 
                                            if($i <= 3){ 
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="http://www.elitepvpers.com/forum/images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content platz'.$i.'">'; 
                                            }else { 
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="http://www.elitepvpers.com/forum/images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content">'; 
                                            } 
                                             
                                            echo $getPlayers->name.'<br>'; 
                                            echo $getPlayers->ladder_point.' Punkte Reich: '; 
                                             
                                            if($getPlayers->empire == 1) 
                                            {echo '<span style="color:red">Rot</span> ';} 
                                            elseif($getPlayers->empire == 2) 
                                            {echo '<span style="color:yellow">Gelb</span> ';} 
                                            elseif($getPlayers->empire == 3) 
                                            {echo '<span style="color:blue">Blau</span> ';} 
                                             
                                            echo '</div></td></tr>';  
                                    } 
                            ?> 
                              </table> 
                            </div> 
                        </div> 
                        <div class="left_bar_item"> 
                            <div id="left_bar_social_head"></div> 
                            <a href="#"><div id="left_bar_social_youtube"></div></a> 
                            <a href="#"><div id="left_bar_social_facebook"></div></a> 
                            <a href="#"><div id="left_bar_social_epvp"></div></a> 
                        </div> 
                    </div> 
                    <div id="mid"> 
                        <?PHP 
                            $includeDir = ".".DIRECTORY_SEPARATOR."pages".DIRECTORY_SEPARATOR; 
                            $includeDefault = $includeDir."home.php"; 

                            if(isset($_GET['s']) && !empty($_GET['s'])) 
                            { 

                                    $_GET['s'] = str_replace("\0", '', $_GET['s']); 
                                    $includeFile = basename(realpath($includeDir.$_GET['s'].".php")); 
                                    $includePath = $includeDir.$includeFile; 

                                    if(!empty($includeFile) && file_exists($includePath))  
                                    { 
                                            include($includePath); 
                                    } 
                                    else  
                                    { 
                                            include($includeDefault); 
                                    } 
                            }  
                            else  
                            { 
                                    include($includeDefault); 
                            } 
            ?> 
                  </div> 
                    <div id="right_bar"> 
                        <div class="right_bar_item right_bar_item_topplayer"> 
                            <div id="right_bar_topplayer_head"></div> 
                            <div id="right_bar_topplayer_content"> 
                                <table> 
                                    <?PHP 
                                    $sqlCmd = "SELECT player.id,player.name,player.level,player.exp, player.job, player_index.empire,guild.name AS guild_name  
                                    FROM player.player  
                                    LEFT JOIN player.player_index  
                                    ON player_index.id=player.account_id  
                                    LEFT JOIN player.guild_member  
                                    ON guild_member.pid=player.id  
                                    LEFT JOIN player.guild  
                                    ON guild.id=guild_member.guild_id 
                                    INNER JOIN account.account  
                                    ON account.id=player.account_id 
                                    WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'  
                                    ORDER BY player.level DESC, player.exp DESC , name ASC LIMIT 10"; 
                                    $i=0; 
                                    $sqlQry = mysql_query($sqlCmd, $sqlServ); 
                                    while($getPlayers = mysql_fetch_object($sqlQry)) { 
                                            $i++; 
                                            echo '<tr>'; 
                                            if($i <= 3){ 
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="http://www.elitepvpers.com/forum/images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content platz'.$i.'">'; 
                                            }else { 
                                                echo '<td><div class="right_bar_topplayer_content_table_item_img" ><img src="http://www.elitepvpers.com/forum/images/Top10Player/Platz'.$i.'.png" /></div><div class="right_bar_topplayer_content_table_item_content">'; 
                                            } 
                                             
                                            echo $getPlayers->name.'<br>'; 
                                            echo 'Lvl '.$getPlayers->level.' Reich: '; 
                                             
                                            if($getPlayers->empire == 1) 
                                            {echo '<span style="color:red">Rot</span> ';} 
                                            elseif($getPlayers->empire == 2) 
                                            {echo '<span style="color:yellow">Gelb</span> ';} 
                                            elseif($getPlayers->empire == 3) 
                                            {echo '<span style="color:blue">Blau</span> ';} 

                                            if($getPlayers->job == 1) 
                                            {echo 'Ninja';} 
                                            elseif($getPlayers->job == 2) 
                                            {echo 'Sura';} 
                                            elseif($getPlayers->job== 3) 
                                            {echo 'Schamane';} 
                                            elseif($getPlayers->job == 4) 
                                            {echo 'Kreiger';} 
                                             
                                            echo '</div></td></tr>';     
                                    } 
                                    ?> 

                                   </table> 
                            </div> 
                        </div> 
                        <div class="right_bar_item"> 
                            <div id="right_bar_status_head"></div> 
                            <div id="right_bar_status_content"> 
                                <?php require("./inc/info.inc.php"); ?> 
                            </div> 
                        </div> 
                        <div class="right_bar_item"> 
                            <div id="right_bar_ts3_head"></div> 
                            <a href="#"><div id="right_bar_ts3_content"></div></a> 
                        </div> 
                    </div> 
                </div> 
                <a><div id="gotop" onclick="scrollWin();" ></div></a> 
            </div> 
            <div id="footer"></div> 
        </div> 
    </body> 
</html>
Für was soll das sein. Man sollte nie $i = 0 einfach so offen im Code beschreiben, ich empfehle dir das du das erst garnicht benutzt. Aber falls jemand eine andere Antwort weiss, bitte mitteilen.

Grüsse Allle