RosCMS update:

* website status page: add day counter and "date colors"
Modified: trunk/web/reactos.org/htdocs/roscms/colors.php
Added: trunk/web/reactos.org/htdocs/roscms/inc/tools.php
Modified: trunk/web/reactos.org/htdocs/roscms/inc/website_status.php

Modified: trunk/web/reactos.org/htdocs/roscms/colors.php
--- trunk/web/reactos.org/htdocs/roscms/colors.php	2005-12-14 19:49:09 UTC (rev 20173)
+++ trunk/web/reactos.org/htdocs/roscms/colors.php	2005-12-14 19:51:53 UTC (rev 20174)
@@ -23,5 +23,7 @@
 	$roscms_intern_color0="#5984C3"; // table head line
 	$roscms_intern_color1="#E2E2E2"; // table color1
 	$roscms_intern_color2="#EEEEEE"; // table color2
+	$roscms_intern_color_new="#339900"; // new content
+	$roscms_intern_color_old="#FF3300"; // new content
 
 ?>
\ No newline at end of file

Added: trunk/web/reactos.org/htdocs/roscms/inc/tools.php
--- trunk/web/reactos.org/htdocs/roscms/inc/tools.php	2005-12-14 19:49:09 UTC (rev 20173)
+++ trunk/web/reactos.org/htdocs/roscms/inc/tools.php	2005-12-14 19:51:53 UTC (rev 20174)
@@ -0,0 +1,45 @@
+<?php
+    /*
+    RosCMS - ReactOS Content Management System
+    Copyright (C) 2005  Klemens Friedl <frik85@reactos.org>
+
+    This program is free software; you can redistribute it and/or modify
+    it under the terms of the GNU General Public License as published by
+    the Free Software Foundation; either version 2 of the License, or
+    (at your option) any later version.
+
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+    GNU General Public License for more details.
+
+    You should have received a copy of the GNU General Public License
+    along with this program; if not, write to the Free Software
+    Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
+    */
+
+
+	function compareDate ($i_sFirstDate, $i_sSecondDate)
+	{
+		// Break the Date strings into seperate components
+		$arrFirstDate = explode ("-", $i_sFirstDate);
+		$arrSecondDate = explode ("-", $i_sSecondDate);
+		
+		$intFirstYear = $arrFirstDate[0];
+		$intFirstMonth = $arrFirstDate[1];
+		$intFirstDay = $arrFirstDate[2];
+		
+		$intSecondYear = $arrSecondDate[0];
+		$intSecondMonth = $arrSecondDate[1];
+		$intSecondDay = $arrSecondDate[2];
+		
+		
+		// Calculate the diference of the two dates and return the number of days
+		$intDate1Jul = gregoriantojd($intFirstMonth, $intFirstDay, $intFirstYear);
+		$intDate2Jul = gregoriantojd($intSecondMonth, $intSecondDay, $intSecondYear);
+//		echo "|".$intDate1Jul."|".$intDate2Jul."|";
+		return $intDate1Jul - $intDate2Jul;
+	
+	} // end Compare Date
+	
+?>
\ No newline at end of file
Property changes on: trunk/web/reactos.org/htdocs/roscms/inc/tools.php
___________________________________________________________________
Name: svn:eol-style
   + native

Modified: trunk/web/reactos.org/htdocs/roscms/inc/website_status.php
--- trunk/web/reactos.org/htdocs/roscms/inc/website_status.php	2005-12-14 19:49:09 UTC (rev 20173)
+++ trunk/web/reactos.org/htdocs/roscms/inc/website_status.php	2005-12-14 19:51:53 UTC (rev 20174)
@@ -31,15 +31,22 @@
 	include('securitylog.php'); // open security log
 	die("Hacking attempt");
 }
+
+include("inc/tools.php");
+
 ?>
 <h1><a href="http://www.reactos.org/?page=dev">ReactOS Development</a> &gt; Website  Status</h1>
 <h2>Website Status</h2>
+<ul>
+  <li><a href="#sec1">Website Content Updates</a></li>
+  <li><a href="#sec2">Website Translation Status</a></li>
+</ul>
+<a name="sec1"></a>
 <h3>Website Content Updates</h3>
 <table cellpadding="1" cellspacing="1">
   <tr bgcolor="#5984C3">
     <td width="200">
     <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Title</strong></font></div></td>
-    <td width="250"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></div></td>
     <td width="200"><div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Name</strong></font></div></td>
     <td width="150">
     <div align="center"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif"><strong>Language</strong></font></div></td>
@@ -53,7 +60,7 @@
 									AND `content_visible` = 1
 									AND `content_type` = 'default'
 									ORDER BY `content_id` DESC 
-									LIMIT 0 , 15 ;") ;
+									LIMIT 0 , 20 ;") ;
 	$color="";
 	$color1=$roscms_intern_color1;
 	$color2=$roscms_intern_color2;
@@ -107,17 +114,6 @@
 			}
 		?>
     </font></td>
-    <td valign="middle" bgcolor="<?php echo $color; ?>"><font face="Arial, Helvetica, sans-serif" size="2">
-      <?php 
-							 
-			if ($result_count_title[0] == "0" || $result_count_title[0] == "") {
-				// temp
-			}
-			else { 
-				echo substr($result_lang_page_name_update['page_description'], 0, 40);
-			}
-		?>
-    </font></td>
     <td valign="middle" bgcolor="<?php echo $color; ?>"><font face="Arial, Helvetica, sans-serif" size="2"><b>
       <?php 
 							 
@@ -139,8 +135,13 @@
 		echo $result_lang_name_update['lang_name'];
 	?>
     </font></div></td>
-    <td valign="middle" bgcolor="<?php echo $color; ?>"><div align="center"><font face="Arial, Helvetica, sans-serif" size="2">
-        <?php 
+    <td valign="middle" bgcolor="<?php echo $color; ?>" title="<?php
+
+		$accountinfo_query = @mysql_query("SELECT user_name, user_id FROM users WHERE user_id = '".$result_updates['content_usrname_id']."'") or die('DB error (website status page)!');
+		$accountinfo_result = @mysql_fetch_array($accountinfo_query);
+		echo $accountinfo_result['user_name']." (".$result_updates['content_usrname_id'].")"; 
+	 
+	 ?>"><div align="center"><font face="Arial, Helvetica, sans-serif" size="2"><?php 
 		echo "<b>".$result_updates['content_date'].' '.$result_updates['content_time']."</b>";
 
 	?>
@@ -150,6 +151,7 @@
 	}	// end while
 ?>
 </table>
+<a name="sec2"></a>
 <h3>Website Translation Status</h3>
 <p>This page show the current website translation status.</p>
 <table cellpadding="1" cellspacing="1">
@@ -236,14 +238,35 @@
 				$link_current_line = true;
 			}
 		?></font></td>
-    <td valign="middle" bgcolor="<?php echo $color; ?>"><div align="center"><font face="Arial, Helvetica, sans-serif" size="2"><?php 
+    <td valign="middle" bgcolor="<?php 
+	
+		echo $color;
+		
+	 ?>"><div align="center"><font face="Arial, Helvetica, sans-serif" size="2"><?php 
+	 
 		if ($link_current_line == "true") {
 			echo '<a href="../?page='.$result_page['content_name'].'&amp;lang=en">'. $result_page['content_date'] .'</a>';
 		}
 		else {
 			echo $result_page['content_date'];
 		}
-	?></font></div></td>
+
+		if (compareDate((date('Y')."-".date('m')."-".date('d')),$result_page['content_date']) == 0) {
+			echo '<table width="100%"  border="0" cellpadding="0" cellspacing="0"><tr><td bgcolor="'.$roscms_intern_color_new.'"><div align="center"><strong><font color="#FFFFFF" size="2">';
+			echo 'today';
+			echo '</font></strong></div></td></tr></table>';
+		}
+		elseif (compareDate((date('Y')."-".date('m')."-".date('d')),$result_page['content_date']) <= 7) {
+			//echo '<br /><font color="'.$roscms_intern_color_new.'"><b>'.compareDate((date('Y')."-".date('m')."-".date('d')),$result_page['content_date']).' days</font>';
+			echo '<table width="100%"  border="0" cellpadding="0" cellspacing="0"><tr><td bgcolor="'.$roscms_intern_color_new.'"><div align="center"><strong><font color="#FFFFFF" size="2">';
+			echo compareDate((date('Y')."-".date('m')."-".date('d')),$result_page['content_date']).' days';
+			echo '</font></strong></div></td></tr></table>';
+		}
+		else { 
+			echo "<br />".compareDate((date('Y')."-".date('m')."-".date('d')),$result_page['content_date'])." days";
+		}
+	?>
+	</font></div></td>
 	<?php
 		$query_lang_name = mysql_query("SELECT * 
 									FROM `languages` 
@@ -277,6 +300,19 @@
 				else {
 					echo $result_lang_item2['content_date'];
 				}
+				
+				if (compareDate($result_page['content_date'],$result_lang_item2['content_date']) <= 0) {
+					echo '<br /><font color="'.$roscms_intern_color_new.'">+ '.compareDate($result_lang_item2['content_date'],$result_page['content_date']).' days</font>';
+					/*echo '<table width="100%"  border="0" cellpadding="0" cellspacing="0"><tr><td bgcolor="'.$roscms_intern_color_new.'"><div align="center"><strong><font color="#FFFFFF" size="2">';
+					echo compareDate($result_lang_item2['content_date'],$result_page['content_date']).' days';
+					echo '</font></strong></div></td></tr></table>';*/
+				}
+				else { 
+					echo '<br /><font color="'.$roscms_intern_color_old.'">- '.compareDate($result_page['content_date'],$result_lang_item2['content_date']).' days</font>';
+					/*echo '<table width="100%"  border="0" cellpadding="0" cellspacing="0"><tr><td bgcolor="'.$roscms_intern_color_old.'"><div align="center"><strong><font color="#FFFFFF" size="2">';
+					echo compareDate($result_page['content_date'],$result_lang_item2['content_date']).' days';
+					echo '</font></strong></div></td></tr></table>';*/
+				}
 			}
 	?></font></div></td>
 	<?php	
@@ -288,4 +324,4 @@
 	}	// end while
 ?>
 </table>
-<p>All entries that are marked with &quot;done&quot; are NOT by all means completely translated!</p>
+<p>&nbsp;</p>