https://www.mediawiki.org/wiki/Special:Code/MediaWiki/114718

Revision: 114718
Author:   kaldari
Date:     2012-04-04 22:22:03 +0000 (Wed, 04 Apr 2012)
Log Message:
-----------
we just want to record the timestamp for when the article was created for now

Modified Paths:
--------------
    trunk/extensions/PageTriage/PageTriage.hooks.php

Modified: trunk/extensions/PageTriage/PageTriage.hooks.php
===================================================================
--- trunk/extensions/PageTriage/PageTriage.hooks.php    2012-04-04 21:58:49 UTC 
(rev 114717)
+++ trunk/extensions/PageTriage/PageTriage.hooks.php    2012-04-04 22:22:03 UTC 
(rev 114718)
@@ -107,13 +107,25 @@
         * Add page to page triage queue
         */
        private static function addToPageTriageQueue( $pageId ) {
+               $dbr = wfGetDB( DB_SLAVE );
                $dbw = wfGetDB( DB_MASTER );
-                       
+               
+               // Pull page creation date from database
+               $res = $dbr->select(
+                       'revision',
+                       'MIN(rev_timestamp) AS creation_date',
+                       array( 'rev_page' => $pageId ),
+                       __METHOD__
+               );
+               foreach ( $res as $row ) {
+                       $creationDate = $row->creation_date;
+               }
+               
                $row = array(
-                               'ptrp_page_id' => $pageId,
-                               'ptrp_triaged' => 0,
-                               'ptrp_timestamp' => $dbw->timestamp( 
wfTimestampNow() )
-                       );
+                       'ptrp_page_id' => $pageId,
+                       'ptrp_triaged' => 0,
+                       'ptrp_timestamp' => $creationDate
+               );
 
                $dbw->replace( 'pagetriage_page', array( 'ptrp_page_id' ), 
$row, __METHOD__ );  
        }


_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs

Reply via email to