<html>
<title>EndlessRO Patchnotes</title>
<head>
<style>
</style>
</head>
<body>
<link rel="stylesheet" href="style.css" type="text/css">
<?php
$heute = date("d.m.Y");
?>
<p>
<?php
$ip = "XXXX";
$login = "XXXX";
$pass = "XXXX";
$db = "XXX";
mysql_connect($ip,
$login,$pass) or die
("DB ERROR");
mysql_select_db($db) or die
("NO DATABASE FOUND");
$categories = array(1=>"Update", 2=>"News", 3=>"Events");
$announces = array();
$abfrage = "SELECT * FROM `cp_choko_news` WHERE `news_category` >=0 ORDER BY `id` DESC LIMIT 15";
$ausgabe = mysql_query($abfrage);
$cnt = 0;
while($row = mysql_fetch_object($ausgabe))
{
$announce = htmlentities($row->news_content, ENT_QUOTES);
if ($lastannounce != $announce)
{
$date = $row->news_date_posted;
$tag = (substr($date, 8,2));
$monat = (substr($date, 5,2));
$jahr = (substr($date, 0,4));
$cat = $categories[$row->news_category];
if ($lastdate != $date)
{
echo "<b><font color=#0f6b8f><font size=4>Maintenance Changelogs $tag.$monat.$jahr</font></b><br>";
echo "<b><font color=#0f6b8f><font size=2>$cat</font></b><br>";
echo "<b><font color=#0f6b8f><font size=4>-----------------------------------------------</font></b><br>";
echo "<li><font size=4><font color=#a63701>$announce</font><br>";
echo "<b><font color=#0f6b8f><font size=4>-----------------------------------------------</font></b><br>";
}
else
{
echo "<li><font color=#2C288D>$announce</font><br>";
}
}
$lastannounce = $announce;
$lastdate = $date;
}
mysql_close();
?>
</p>
</body>
</html>