diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-11-22 01:22:13 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-11-22 01:22:13 +0000 |
| commit | 1551f13bb239ae1f47176e82c804c0eaaa959623 (patch) | |
| tree | 8fe2f8e879a8aab34e3946a356d1d16565450ed0 /phpBB/includes/ucp/ucp_pm_compose.php | |
| parent | 6cb0276788994f9bd348e8ef651851760055fc12 (diff) | |
| download | forums-1551f13bb239ae1f47176e82c804c0eaaa959623.tar forums-1551f13bb239ae1f47176e82c804c0eaaa959623.tar.gz forums-1551f13bb239ae1f47176e82c804c0eaaa959623.tar.bz2 forums-1551f13bb239ae1f47176e82c804c0eaaa959623.tar.xz forums-1551f13bb239ae1f47176e82c804c0eaaa959623.zip | |
#5562
major speed boost for Oracle :D
This took a while, every call to sql_query_limit() was checked out for having any implicit/explicit column issues... Hopefully, nothing has changed :D
git-svn-id: file:///svn/phpbb/trunk@6631 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/ucp/ucp_pm_compose.php')
| -rw-r--r-- | phpBB/includes/ucp/ucp_pm_compose.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/includes/ucp/ucp_pm_compose.php b/phpBB/includes/ucp/ucp_pm_compose.php index cc2494a611..f16b4b0841 100644 --- a/phpBB/includes/ucp/ucp_pm_compose.php +++ b/phpBB/includes/ucp/ucp_pm_compose.php @@ -131,7 +131,7 @@ function compose_pm($id, $mode, $action) } else { - $sql = 'SELECT t.*, p.*, u.username as quote_username + $sql = 'SELECT t.folder_id, p.*, u.username as quote_username FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . ' u WHERE t.user_id = ' . $user->data['user_id'] . " AND p.author_id = u.user_id @@ -147,7 +147,7 @@ function compose_pm($id, $mode, $action) } // check for outbox (not read) status, we do not allow editing if one user already having the message - $sql = 'SELECT p.*, t.* + $sql = 'SELECT p.*, t.folder_id FROM ' . PRIVMSGS_TO_TABLE . ' t, ' . PRIVMSGS_TABLE . ' p WHERE t.user_id = ' . $user->data['user_id'] . ' AND t.folder_id = ' . PRIVMSGS_OUTBOX . " |