[pLog-svn] r2776 - plog/trunk

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-01-12 22:17:57 +0000 (Thu, 12 Jan 2006)
New Revision: 2776

Modified:
   plog/trunk/wizard.php
Log:
good that nobody used this yet, it would have messed up completely all dates :)


Modified: plog/trunk/wizard.php
===================================================================
--- plog/trunk/wizard.php	2006-01-12 20:54:26 UTC (rev 2775)
+++ plog/trunk/wizard.php	2006-01-12 22:17:57 UTC (rev 2776)
@@ -1537,7 +1537,8 @@
                 $query = "UPDATE ".$this->dbPrefix."articles SET num_comments = {$totalComments},
                           num_nonspam_comments = {$totalActiveComments},
                           num_trackbacks = {$totalTrackbacks},
-                          num_nonspam_trackbacks = 0
+                          num_nonspam_trackbacks = 0,
+                          date = date
                           WHERE id = {$artId}";
                           
                 // and execute it
@@ -1601,12 +1602,14 @@
                 
                 // build the update query
                 $query = "UPDATE ".$this->dbPrefix."articles_categories SET num_articles = {$totalArticles},
-                          num_published_articles = {$totalActiveArticles}
+                          num_published_articles = {$totalActiveArticles},
+                          last_modification = last_modification
                           WHERE id = {$catId}";
                           
                 // and execute it
                 $result = $this->db->Execute( $query );
                 if( !$result ) {
+                print(" cat update query error = $query<br/>");                
                     $this->message .= "Error updating category with id {$catId}<br/>";
                 }
                 else
@@ -1816,7 +1819,7 @@
                 if( $totalLinks == '' ) $totalLinks = 0;
                 
                 // build the update query
-                $query = "UPDATE ".$this->dbPrefix."mylinks_categories SET num_links = {$totalLinks}
+                $query = "UPDATE ".$this->dbPrefix."mylinks_categories SET num_links = {$totalLinks}, last_modification = last_modification
                           WHERE id = {$catId}";
                           
                 // and execute it
@@ -1862,7 +1865,7 @@
                 $commentId = $row["id"];                
                 $blogId = $commentBlogIds[$commentId];
                 $query = "UPDATE ".$this->dbPrefix."articles_comments
-                          SET blog_id = {$blogId} WHERE id = {$commentId}";
+                          SET blog_id = {$blogId}, date = date WHERE id = {$commentId}";
                 // and execute it
                 $res = $this->db->Execute( $query );
                 if( !$res )
@@ -1920,7 +1923,7 @@
                 if( $children == "" ) $children = 0;                
                 // build the query
                 $query = "UPDATE ".$this->dbPrefix."gallery_albums
-                          SET num_children = {$children}, num_resources = {$resources}
+                          SET num_children = {$children}, num_resources = {$resources}, date = date
                           WHERE id = {$albumId}";
                 // and execute it
                 $res = $this->db->Execute( $query );