viewing paste Unknown #7605 | Plain text

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
<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>
 
Viewed 338 times, submitted by unknown.