Changeset 1058 for trunk/common

Timestamp:

11/03/09 00:15:56 (3 years ago)

Author:

bogdan2412

Message:

Fix SMF not updating it's member stats.

Currently, SMF reports it has 7000 members and the latest member registered in February, 2008.

Apparently, SMF only updates it's member statistics when a new user is registered, so I adapted some of it's update statistics code and made it run when a new user is registered.

Reviewed: ​http://reviewboard.infoarena.ro/r/91/

File:

• trunk/common/db/smf.php (modified) (2 diffs)

trunk/common/db/smf.php

@@ -54 +54 @@
     );
 
-    return db_insert(IA_SMF_DB_PREFIX.'members', $fields);
+    $user_id = db_insert(IA_SMF_DB_PREFIX.'members', $fields);
+    smf_update_member_stats();
+    return $user_id;
+}
+
+// Adapted from updateStats function in smf/Sources/Subs.php
+function smf_update_member_stats() {
+    $changes = array(
+        'memberlist_updated' => time(),
+    );
+
+    // Get the latest member (highest ID_MEMBER) and count.
+    list($changes['totalMembers'], $changes['latestMember']) = array_values(
+        db_fetch("
+            SELECT COUNT(*), MAX(ID_MEMBER)
+            FROM `" . IA_SMF_DB_PREFIX . "members`"
+        )
+    );
+
+    // Get the latest member's display name.
+    list($changes['latestRealName']) = array_values(
+        db_fetch("
+            SELECT realName
+            FROM `" . IA_SMF_DB_PREFIX . "members`
+            WHERE ID_MEMBER = " . (int)$changes['latestMember'] . "
+            LIMIT 1"
+        )
+    );
+
+    // Update smf settings table.
+    // SMF also clears it's $modSettings cache at this point
+    // but, since infoarena and SMF don't use the same caching
+    // engine, I don't know how to handle this. The cache timeout
+    // is short though so it's ok to leave it like this.
+    foreach ($changes as $variable => $value)
+    {
+        db_query("
+            UPDATE `" . IA_SMF_DB_PREFIX . "settings`
+            SET value = " . db_quote($value) . "
+            WHERE variable = " . db_quote($variable) . "
+            LIMIT 1"
+        );
+    }
 }
 
@@ -61 +103 @@
     $fields = array(
         'memberName' => $ia_user['username'],
-        // 'dateRegistered' => time(),
+        //'dateRegistered' => time(),
         //'posts' => 0,
         //'lngfile' => '',