diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2002-04-30 17:56:50 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2002-04-30 17:56:50 +0000 |
| commit | 52c0d86c95aaacd3e57866a5d57fce82b599236f (patch) | |
| tree | 605ba287aaf5451ad9fdc5ab4c60cff277efbfff /phpBB/update_script.php | |
| parent | 559dff21b7eb18188c4022efa2e0bb5ddc7de784 (diff) | |
| download | forums-52c0d86c95aaacd3e57866a5d57fce82b599236f.tar forums-52c0d86c95aaacd3e57866a5d57fce82b599236f.tar.gz forums-52c0d86c95aaacd3e57866a5d57fce82b599236f.tar.bz2 forums-52c0d86c95aaacd3e57866a5d57fce82b599236f.tar.xz forums-52c0d86c95aaacd3e57866a5d57fce82b599236f.zip | |
Changed code so it stores total users in config table to remove a slightly costly query
git-svn-id: file:///svn/phpbb/trunk@2549 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/update_script.php')
| -rw-r--r-- | phpBB/update_script.php | 31 |
1 files changed, 29 insertions, 2 deletions
diff --git a/phpBB/update_script.php b/phpBB/update_script.php index dcaddb46b5..d1ae12fdd2 100644 --- a/phpBB/update_script.php +++ b/phpBB/update_script.php @@ -59,7 +59,34 @@ if ( $row = $db->sql_fetchrow($result) ) break; } break; - + case '.1.0 [20020421]': + $user_data_sql = "SELECT COUNT(user_id) AS total_users, MAX(user_id) AS newest_user_id FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS; + if($result = $db->sql_query($user_data_sql)) + { + $row = $db->sql_fetchrow($result); + $user_count = $row['total_users']; + $newest_user_id = $row['newest_user_id']; + + $username_sql = "SELECT username FROM " . USERS_TABLE . " WHERE user_id = $newest_user_id"; + if(!$result = $db->sql_query($username_sql)) + { + die('Could not get username to update to [20020430]'); + } + $row = $db->sql_fetchrow($result); + $newest_username = $row['username']; + } + else + { + die('Could not get user count for update to [20020430]'); + } + + $sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) + VALUES ('newest_user_id', $newest_user_id)"; + $sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) + VALUES ('newest_username', '$newest_username')"; + $sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) + VALUES ('num_users', $user_count)"; + break; default; echo 'No updates made<br /><br />'; } @@ -77,7 +104,7 @@ if ( $row = $db->sql_fetchrow($result) ) } $sql = "UPDATE " . CONFIG_TABLE . " - SET config_value = '.1.0 [20020421]' + SET config_value = '.1.0 [20020430]' WHERE config_name = 'version'"; if ( !($result = $db->sql_query($sql)) ) { |