[ros-diffs] [dgoette] 423: fixes for forum subsystem: * update user count * update newest user

[dgoette at svn.reactos.org]

Author: dgoette
Date: Fri May 29 00:21:51 2009
New Revision: 423

URL: http://svn.reactos.org/svn/reactos?rev=423&view=rev
Log:
fixes for forum subsystem:
* update user count
* update newest user

Modified:
    branches/danny-web/www/www.reactos.org/roscms/lib/subsystem/Subsystem_PHPBB.class.php

Modified: branches/danny-web/www/www.reactos.org/roscms/lib/subsystem/Subsystem_PHPBB.class.php
URL: http://svn.reactos.org/svn/reactos/branches/danny-web/www/www.reactos.org/roscms/lib/subsystem/Subsystem_PHPBB.class.php?rev=423&r1=422&r2=423&view=diff
==============================================================================
--- branches/danny-web/www/www.reactos.org/roscms/lib/subsystem/Subsystem_PHPBB.class.php [iso-8859-1] (original)
+++ branches/danny-web/www/www.reactos.org/roscms/lib/subsystem/Subsystem_PHPBB.class.php [iso-8859-1] Fri May 29 00:21:51 2009
@@ -178,6 +178,21 @@
     $stmt->bindParam('user_id',$phpbb_user_id,PDO::PARAM_INT);
     $stmt->execute() or die('DB error (subsys_phpbb #19)');
 
+    // update forum statistics
+      // num_users
+      DBConnection::getInstance()->exec("UPDATE ".self::DB_NAME.".phpbb_config SET config_value = (SELECT COUNT(*) FROM ".$this->user_table.") WHERE config_name = 'num_users'");
+
+      // newest_user_id
+      $stmt=&DBConnection::getInstance()->prepare("UPDATE ".self::DB_NAME.".phpbb_config SET config_value = :user_id WHERE config_name = 'newest_user_id'");
+      $stmt->bindParam('user_id',$phpbb_user_id,PDO::PARAM_INT);
+      $stmt->execute();
+
+      // newest_username
+      $stmt=&DBConnection::getInstance()->prepare("UPDATE ".self::DB_NAME.".phpbb_config SET config_value = :user_name WHERE config_name = 'newest_username'");
+      $stmt->bindParam('user_name',$name,PDO::PARAM_STR);
+      $stmt->execute();
+    // end update forum statistics
+
     // Finally, insert a row in the mapping table
     $stmt=&DBConnection::getInstance()->prepare("INSERT INTO ".ROSCMST_SUBSYS." (user_id, subsys, subsys_user_id) VALUES(:roscms_user, 'phpbb', :phpbb_user)");
     $stmt->bindParam('roscms_user',$user_id,PDO::PARAM_INT);