diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2007-08-15 17:32:48 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2007-08-15 17:32:48 +0000 |
| commit | 2bbd2fb1f97d4668e82c26badbe89c3d3fdc8169 (patch) | |
| tree | 3dbeba19d89b737a07cf7cc23b8c4693d35234ea /phpBB/includes/functions_privmsgs.php | |
| parent | 3ada3b76f0ce86274647758db029d84a0f404886 (diff) | |
| download | forums-2bbd2fb1f97d4668e82c26badbe89c3d3fdc8169.tar forums-2bbd2fb1f97d4668e82c26badbe89c3d3fdc8169.tar.gz forums-2bbd2fb1f97d4668e82c26badbe89c3d3fdc8169.tar.bz2 forums-2bbd2fb1f97d4668e82c26badbe89c3d3fdc8169.tar.xz forums-2bbd2fb1f97d4668e82c26badbe89c3d3fdc8169.zip | |
some bugs fixed
git-svn-id: file:///svn/phpbb/trunk@8033 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_privmsgs.php')
| -rw-r--r-- | phpBB/includes/functions_privmsgs.php | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/phpBB/includes/functions_privmsgs.php b/phpBB/includes/functions_privmsgs.php index 61f4648f4f..2a8990b607 100644 --- a/phpBB/includes/functions_privmsgs.php +++ b/phpBB/includes/functions_privmsgs.php @@ -1348,10 +1348,12 @@ function submit_pm($mode, $subject, &$data, $put_in_outbox = true) if (isset($data['address_list']['g']) && sizeof($data['address_list']['g'])) { - $sql = 'SELECT group_id, user_id - FROM ' . USER_GROUP_TABLE . ' - WHERE ' . $db->sql_in_set('group_id', array_keys($data['address_list']['g'])) . ' - AND user_pending = 0'; + $sql = 'SELECT u.user_type, ug.group_id, ug.user_id + FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . ' ug + WHERE ' . $db->sql_in_set('ug.group_id', array_keys($data['address_list']['g'])) . ' + AND ug.user_pending = 0 + AND u.user_id = ug.user_id + AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')'; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) |