diff options
author | Joas Schilling <nickvergessen@gmx.de> | 2014-11-21 21:04:11 +0100 |
---|---|---|
committer | Joas Schilling <nickvergessen@gmx.de> | 2014-11-21 21:04:11 +0100 |
commit | f719803fdc8f16430ed3e85625dd337da1de52d9 (patch) | |
tree | 942e8aaef0d54de632262079b8fa9d96ab4eb929 /phpBB/phpbb | |
parent | d56da0d68f5b7bdba21a475cf08e88fa6a9fbde2 (diff) | |
parent | 556565d072c7e7d94ac4282baf2ff0bb2c2bdb8c (diff) | |
download | forums-f719803fdc8f16430ed3e85625dd337da1de52d9.tar forums-f719803fdc8f16430ed3e85625dd337da1de52d9.tar.gz forums-f719803fdc8f16430ed3e85625dd337da1de52d9.tar.bz2 forums-f719803fdc8f16430ed3e85625dd337da1de52d9.tar.xz forums-f719803fdc8f16430ed3e85625dd337da1de52d9.zip |
Merge pull request #3144 from marc1706/ticket/13337
[ticket/13337] Do not use SQL IN comparison with empty array
Diffstat (limited to 'phpBB/phpbb')
-rw-r--r-- | phpBB/phpbb/notification/manager.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/phpbb/notification/manager.php b/phpBB/phpbb/notification/manager.php index 971a53a16a..dd611e1dd1 100644 --- a/phpBB/phpbb/notification/manager.php +++ b/phpBB/phpbb/notification/manager.php @@ -292,7 +292,7 @@ class manager WHERE notification_time <= " . (int) $time . (($notification_type_name !== false) ? ' AND ' . (is_array($notification_type_name) ? $this->db->sql_in_set('notification_type_id', $this->get_notification_type_ids($notification_type_name)) : 'notification_type_id = ' . $this->get_notification_type_id($notification_type_name)) : '') . - (($item_parent_id !== false) ? ' AND ' . (is_array($item_parent_id) ? $this->db->sql_in_set('item_parent_id', $item_parent_id) : 'item_parent_id = ' . (int) $item_parent_id) : '') . + (($item_parent_id !== false) ? ' AND ' . (is_array($item_parent_id) ? $this->db->sql_in_set('item_parent_id', $item_parent_id, false, true) : 'item_parent_id = ' . (int) $item_parent_id) : '') . (($user_id !== false) ? ' AND ' . (is_array($user_id) ? $this->db->sql_in_set('user_id', $user_id) : 'user_id = ' . (int) $user_id) : ''); $this->db->sql_query($sql); } |