diff options
| author | Henry Sudhof <kellanved@phpbb.com> | 2007-09-13 15:15:27 +0000 |
|---|---|---|
| committer | Henry Sudhof <kellanved@phpbb.com> | 2007-09-13 15:15:27 +0000 |
| commit | 052025bb1f144337952236c5c4774826818037d4 (patch) | |
| tree | 3557f8a43c06a3944ed2f0de1b5835a3289d8d09 /phpBB/includes/ucp | |
| parent | 685282c2cbe8a6d8c7abd77d3801d7242d0ae693 (diff) | |
| download | forums-052025bb1f144337952236c5c4774826818037d4.tar forums-052025bb1f144337952236c5c4774826818037d4.tar.gz forums-052025bb1f144337952236c5c4774826818037d4.tar.bz2 forums-052025bb1f144337952236c5c4774826818037d4.tar.xz forums-052025bb1f144337952236c5c4774826818037d4.zip | |
-#14438
-Refactor the confirm table cleanup
-Add confirm table cleanup to session garbage collection. Might require own pseudo-cron.
git-svn-id: file:///svn/phpbb/trunk@8089 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/ucp')
| -rw-r--r-- | phpBB/includes/ucp/ucp_register.php | 27 |
1 files changed, 2 insertions, 25 deletions
diff --git a/phpBB/includes/ucp/ucp_register.php b/phpBB/includes/ucp/ucp_register.php index ca44260760..6f133a9ed4 100644 --- a/phpBB/includes/ucp/ucp_register.php +++ b/phpBB/includes/ucp/ucp_register.php @@ -427,31 +427,8 @@ class ucp_register $str = ''; if (!$change_lang) { - $sql = 'SELECT DISTINCT c.session_id - FROM ' . CONFIRM_TABLE . ' c - LEFT JOIN ' . SESSIONS_TABLE . ' s ON (c.session_id = s.session_id) - WHERE s.session_id IS NULL'; - $result = $db->sql_query($sql); - - if ($row = $db->sql_fetchrow($result)) - { - $sql_in = array(); - do - { - $sql_in[] = (string) $row['session_id']; - } - while ($row = $db->sql_fetchrow($result)); - - if (sizeof($sql_in)) - { - $sql = 'DELETE FROM ' . CONFIRM_TABLE . ' - WHERE ' . $db->sql_in_set('session_id', $sql_in) . ' - AND confirm_type = ' . CONFIRM_REG; - $db->sql_query($sql); - } - } - $db->sql_freeresult($result); - + $user->confirm_gc(CONFIRM_REG); + $sql = 'SELECT COUNT(session_id) AS attempts FROM ' . CONFIRM_TABLE . " WHERE session_id = '" . $db->sql_escape($user->session_id) . "' |