diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2007-08-21 15:26:44 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2007-08-21 15:26:44 +0000 |
| commit | b629d5d36a83da31ef84cbe2f5e0444d90616c24 (patch) | |
| tree | 78f91d92d0033e3dc1fb509d8e30aa5c131f785c /phpBB | |
| parent | ff3843b39e714ef879a91f245ee6170534947503 (diff) | |
| download | forums-b629d5d36a83da31ef84cbe2f5e0444d90616c24.tar forums-b629d5d36a83da31ef84cbe2f5e0444d90616c24.tar.gz forums-b629d5d36a83da31ef84cbe2f5e0444d90616c24.tar.bz2 forums-b629d5d36a83da31ef84cbe2f5e0444d90616c24.tar.xz forums-b629d5d36a83da31ef84cbe2f5e0444d90616c24.zip | |
using distinct... david, please review and make sure it works on all supported dbms.
git-svn-id: file:///svn/phpbb/trunk@8062 89ea8834-ac86-4346-8a33-228a782c2dd0
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 d6391a4821..ca44260760 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 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'; @@ -438,14 +438,14 @@ class ucp_register $sql_in = array(); do { - $sql_in[(string) $row['session_id']] = 1; + $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', array_keys($sql_in)) . ' + WHERE ' . $db->sql_in_set('session_id', $sql_in) . ' AND confirm_type = ' . CONFIRM_REG; $db->sql_query($sql); } |