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/ro... ============================================================================== --- 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);