diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2012-05-31 11:48:56 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2012-05-31 12:15:46 +0200 |
| commit | 9ab5ad2986a836554bbf137d577c38155540c0a8 (patch) | |
| tree | 893b5becd963249eb21146b9b32fb4d25f4d6ccc /phpBB | |
| parent | 643a86504a30f6b9fbe0f073bb03009b4fbd0f43 (diff) | |
| download | forums-9ab5ad2986a836554bbf137d577c38155540c0a8.tar forums-9ab5ad2986a836554bbf137d577c38155540c0a8.tar.gz forums-9ab5ad2986a836554bbf137d577c38155540c0a8.tar.bz2 forums-9ab5ad2986a836554bbf137d577c38155540c0a8.tar.xz forums-9ab5ad2986a836554bbf137d577c38155540c0a8.zip | |
[ticket/10751] Use sql_lower_text() in view_log(). log_data is a text column.
PHPBB3-10751
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 0e1a11b4aa..204fa9a43d 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -2557,7 +2557,8 @@ function view_log($mode, &$log, &$log_count, $limit = 0, $offset = 0, $forum_id { $sql_keywords .= $db->sql_in_set('l.log_operation', $operations) . ' OR '; } - $sql_keywords .= 'LOWER(l.log_data) ' . implode(' OR LOWER(l.log_data) ', $keywords) . ')'; + $sql_lower = $db->sql_lower_text('l.log_data'); + $sql_keywords .= "$sql_lower " . implode(" OR $sql_lower ", $keywords) . ')'; } if ($log_count !== false) |