Stuff

?>
<script type="text/javascript">

function expandCollapse(newsId)
{
    var plusMinusImg = document.getElementById("plusminus"+newsId);
    var detailRow = document.getElementById("details"+newsId);

    if (detailRow.style.display == "none") {
        plusMinusImg.src = "<?=$GLOBALS["PIC_BASE_URL"].$GLOBALS["ss_uri"]?>/minus.gif";
        detailRow.style.display = "table-row";
    } else {
        plusMinusImg.src = "<?=$GLOBALS["PIC_BASE_URL"].$GLOBALS["ss_uri"]?>/plus.gif";
        detailRow.style.display = "none";
    }
}

</script>
<table cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
 <tr  class="tabletitle" width="100%">
        <td colspan="10" width="100%"><span class="normalfont"><center><img src="<?=$GLOBALS["PIC_BASE_URL"]?>newsticker.png" width="22" height="22" alt="" style="vertical-align: middle;"> <b>Tracker-Neuigkeiten 
<?

if ($CURUSER)
{
if (get_user_class() >= UC_ADMINISTRATOR)
        print(" <a href=\"news.php\"><img src=\"".$GLOBALS["PIC_BASE_URL"]."news_add.png\" width=\"22\" height=\"22\" alt=\"News hinzufügen\" title=\"News hinzufügen\" style=\"vertical-align: middle;border:none\"></a>");
?>

</b></center></span></td> 
 </tr><tr><td width="100%" class="tablea">
 <?
$res = mysql_query("SELECT * FROM news WHERE ADDDATE(added, INTERVAL 45 DAY) > NOW() ORDER BY added DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) > 0)
{
    $first = TRUE;
    begin_table(TRUE);
    while($array = mysql_fetch_array($res))
    {
        $user_id=$array['userid'];
        $res_username=mysql_query("SELECT username FROM users WHERE id=$user_id") or sqlerr(__FILE__, __LINE__);
        $username=mysql_fetch_array($res_username);
    
        $news_date=date("Y-m-d",strtotime($array['added']));
        $news_year=substr($news_date,0,4);
        $news_month=substr($news_date,5,2);
        $news_day=substr($news_date,8,2);
    
        $news_date=$news_day . "." . $news_month . "." . $news_year;
        $news_day=date("l",mktime(0,0,0,$news_month,$news_day,$news_year));
    
        if ($news_day == "Monday")
            $news_day="Montag";
        if ($news_day == "Tuesday")
            $news_day="Dienstag";
            if ($news_day == "Wednesday")
            $news_day="Mittwoch";
        if ($news_day == "Thursday")
            $news_day="Donnerstag";
        if ($news_day == "Friday")
            $news_day="Freitag";
        if ($news_day == "Saturday")
            $news_day="Samstag";
        if ($news_day == "Sunday")
            $news_day="Sonntag";


        echo "<tr><td class=tablecat align=left>";
        if ($first)
        print("<a href=\"javascript:expandCollapse('" . $array['id'] . "');\"><img id=\"plusminus" . $array['id'] . "\" src=\"".$GLOBALS["PIC_BASE_URL"].$GLOBALS["ss_uri"]."/minus.gif\" alt=\"Auf-/Zuklappen\" border=\"0\"></a>\n");
        else
        print("<a href=\"javascript:expandCollapse('" . $array['id'] . "');\"><img id=\"plusminus" . $array['id'] . "\" src=\"".$GLOBALS["PIC_BASE_URL"].$GLOBALS["ss_uri"]."/plus.gif\" alt=\"Auf-/Zuklappen\" border=\"0\"></a>\n");
        print("<b>".htmlspecialchars($array["title"])."</b> ");
        print("( " . $news_day . ", " . $news_date . ") ");
        if (get_user_class() >= UC_ADMINISTRATOR)
        {
    print(" <font class=middle><a class=altlink href=news.php?action=edit&newsid=" . $array['id'] . "&returnto=" . urlencode($_SERVER['PHP_SELF']) . "><img src=\"".$GLOBALS["PIC_BASE_URL"]."edit.png\" width=\"16\" height=\"16\" alt=\"Bearbeiten\" title=\"Bearbeiten\" border=\"0\" style=\"vertical-align:bottom\"></font>");
            print(" <font class=middle><a class=altlink href=news.php?action=delete&newsid=" . $array['id'] . "&returnto=" . urlencode($_SERVER['PHP_SELF']) . "><img src=\"".$GLOBALS["PIC_BASE_URL"]."editdelete.png\" width=\"16\" height=\"16\" alt=\"L&ouml;schen\" title=\"L&ouml;schen\" border=\"0\" style=\"vertical-align:bottom\"></a></font>");
        }
    
        if ($first)
            print("<tr id=\"details" . $array['id'] . "\" style=\"display:table-row;\">");
        else
        print("<tr id=\"details" . $array['id'] . "\" style=\"display:none;\">");
        print("<td class=\"tablea\" align=\"left\"><div align=\"justify\">" . stripslashes($array['body']));
        print("</td></tr>");
        $first = FALSE;
    }}
    end_table();
}

?>
</td></tr></table>