[dgoette] 421: fix row colors for translations

Author: dgoette
Date: Fri May 22 19:04:47 2009
New Revision: 421

URL: http://svn.reactos.org/svn/reactos?rev=421&view=rev
Log:
fix row colors for translations

Modified:
    branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntryTable.class.php

Modified: branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntryTable.class.php
URL: http://svn.reactos.org/svn/reactos/branches/danny-web/www/www.reactos.org/ro...
==============================================================================
--- branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntryTable.class.php [iso-8859-1] (original)
+++ branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntryTable.class.php [iso-8859-1] Fri May 22 19:04:47 2009
@@ -108,7 +108,7 @@
       echo '<view curpos="'.$page_offset.'" pagelimit="'.$this->page_limit.'" pagemax="'.$ptm_entries.'" tblcols="'.($this->column_list !== false ? '|'.$this->column_list.'|' : '').'" />';

// prepare for usage in loop
-      $stmt_trans=&DBConnection::getInstance()->prepare("SELECT r.data_id, d.name, d.type, r.id, r.version, r.lang_id, r.datetime, r.user_id FROM ".ROSCMST_ENTRIES." d JOIN ".ROSCMST_REVISIONS." r ON r.data_id=d.id WHERE d.id = :data_id AND r.version > 0 AND r.lang_id = :lang AND r.archive = :archive LIMIT 1");
+      $stmt_trans=&DBConnection::getInstance()->prepare("SELECT r.data_id, d.name, d.type, r.id, r.version, r.lang_id, r.datetime, r.user_id FROM ".ROSCMST_ENTRIES." d JOIN ".ROSCMST_REVISIONS." r ON r.data_id=d.id WHERE d.id = :data_id AND r.status = 'stable' AND r.lang_id = :lang AND r.archive = :archive LIMIT 1");
       $stmt_trans->bindParam('archive',$this->archive_mode,PDO::PARAM_BOOL);
       $stmt_trans->bindParam('lang',$this->translation_lang,PDO::PARAM_INT);
       $stmt_stext=&DBConnection::getInstance()->prepare("SELECT content FROM ".ROSCMST_STEXT." WHERE rev_id = :rev_id AND name = 'title' LIMIT 1");
@@ -185,7 +185,7 @@
           }
           // translation already exists
           else {
-            if ($row['datetime'] > $translated_entry['datetime']) {
+            if (strtotime($row['datetime']) < strtotime($translated_entry['datetime'])) {
               $line_status = 'transg';
             }
             else {