<?php 

// Конфиг подключения к базе данных

$CONFIG['dbaddress'] = "localhost"; // Хост, по умолчанию localhost

$CONFIG['dbuser']    = "root";      // Логин к базе данных

$CONFIG['dbpass']     = "12345";     // Пароль к базе данных

$CONFIG['dbname']     = "l2d";       // База данных



$cont=mysql_connect($CONFIG['dbaddress'],$CONFIG['dbuser'],$CONFIG['dbpass'])or die("Could not connect");

mysql_select_db($CONFIG['dbname'],$cont);

$res = mysql_query("SELECT  name,value FROM server_variables 

WHERE (value='on' OR value='off') AND (name<>'transport') 

AND (name<>'NPCBuffer') AND (name<>'Tournament') AND (name<>'Bonus_event')",$cont);



while($row=mysql_fetch_row($res)){



$serch=array("on", "off");

$status=array(

                "<span style=\"color:#00ff00\">START</span>",

                "<span style=\"color:#ff0000\">STOP</span>");

$status_event=str_replace($serch,$status,$row[1]);



$se=array(

            "Christmas",

            "Bonus_event",

            "glitter",

            "l2day",

            "CofferofShadows");

$events=array(

                "Рождество",

                "Бонус",

                "Medal Collecting",

                "L2 Day",

                "Coffer of Shadows");

$event=str_replace($se,$events,$row[0]);



echo"

<div align=\"center\">

     <table border=\"0\">

         <tr>

               <td width=\"145\" align=\"left\"><font size = \"2\">[Event] {$event}</font> </td>

               <td width=\"40\" align=\"center\"><font size = \"2\">{$status_event}</font></td>

          </tr>

     </table>

</div>";

}

mysql_close($cont);