diff options
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/includes/ucp/ucp_register.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/includes/ucp/ucp_register.php b/phpBB/includes/ucp/ucp_register.php index 2e22cf5519..3d7df02850 100644 --- a/phpBB/includes/ucp/ucp_register.php +++ b/phpBB/includes/ucp/ucp_register.php @@ -427,7 +427,7 @@ class ucp_register $str = ''; if (!$change_lang) { - $sql = 'SELECT c.session_id + $sql = 'SELECT c.confirm_id FROM ' . CONFIRM_TABLE . ' c LEFT JOIN ' . SESSIONS_TABLE . ' s ON (c.session_id = s.session_id) WHERE s.session_id IS NULL'; @@ -438,14 +438,14 @@ class ucp_register $sql_in = array(); do { - $sql_in[] = (string) $row['session_id']; + $sql_in[] = (string) $row['confirm_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) . ' + WHERE ' . $db->sql_in_set('confirm_id', $sql_in) . ' AND confirm_type = ' . CONFIRM_REG; $db->sql_query($sql); } |