<?php
// Altered by Mark Coudriet
include_once ($path_pre . "cm/cm_lib.inc.php");
if (!$tdwidth) { $cm_tdwidth = (600 + 12); } else { $cm_tdwidth = (($tdwidth * 2) + 12); }
if ($tr_hover) { $cm_hover = $terminfarbe; } else { $cm_hover = ""; }
echo "<table cellpadding=\"3\" cellspacing=\"1\" border=\"0\"><tr><td>";
$result2 = db_query("select cmdb_title, cmdb_directory, cmdb_parentdir, cmdb_abstract, cmdb_date_update, cmdb_type from content3 where cmdb_parentdir like '/%' and cmdb_type like '%" . CM_HITTYPE_ANNOUNCE . "%' " . fcm_access_sqldef ($user_kurz) . " order by cmdb_date_update desc") or db_die();
if ( $result2 ) echo "<b>New Announcements</b>";
while ($row2 = db_fetch_row($result2)) {
   // Give Special Announces an experation date
   if (fcm_diffdate_days ($row2[4]) < ($cm_sum_oldestleafallowed * 1.5)) {
      fcm_articlelist_nostyle ($row2[1], $row2[0], $row2[3], $row2[4], fcm_is_cleditable ($row2[1], $user_kurz, $row2[5]), true, $cm_tdwidth, $terminfarbe, "");
      $trip_flag = 1;
   }
}
if (!$trip_flag) { echo "<br>No new announcements.."; }
else $trip_flag = "";
echo "</td></tr></table>";
echo "<table cellpadding=\"3\" cellspacing=\"1\" border=\"0\"><tr><td>";
$cm_rowcolor = $bgcolor1;
$result2 = "";
$result2 = db_query("select cmdb_title, cmdb_directory, cmdb_parentdir, cmdb_abstract, cmdb_date_update, cmdb_type from content3 where cmdb_directory like '/%' and cmdb_type like '%" . CM_HITTYPE_PAGE . "%' and cmdb_type not like '%" . CM_HITTYPE_ANNOUNCE . "%' " . fcm_access_sqldef ($user_kurz) . " order by cmdb_date_update desc") or db_die();
if ( $result2 ) echo "<b>New Articles</b>";
while ($row2 = db_fetch_row($result2)) {
  if (fcm_diffdate_days ($row2[4]) < $cm_sum_oldestleafallowed) {
    fcm_articlelist_nostyle ($row2[1], $row2[0], $row2[3], $row2[4], fcm_is_cleditable ($row2[1], $user_kurz, $row2[5]), false, $cm_tdwidth, $cm_rowcolor, $cm_hover);
   $trip_flag = 1;
    if ($cm_rowcolor == $bgcolor1) { $cm_rowcolor = $bgcolor2; } else { $cm_rowcolor = $bgcolor1; }
  }
}
if (!$trip_flag) { echo "<br>No new articles..."; }
echo "</td></tr></table>";
?>

if ( $result2 ) echo "<b>New Announcements</b> <i>(Last ". ($cm_sum_oldestleafallowed * 1.5) ." days)</i>";

if ( $result2 ) echo "<b>New Articles</b> <i>(Last ". $cm_sum_oldestleafallowed ." days)</i>";

$result2 = db_query ("select ID, kurz from users where kurz = '$cm_username'") or db_die();

$result2 = db_query ("select ID, kurz from ".DB_PREFIX."users where kurz = '$cm_username'") or db_die();