aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/phpbb/db/driver/driver.php
diff options
context:
space:
mode:
authorGeolim4 <contact@geolim4.com>2014-08-08 15:06:12 +0200
committerGeolim4 <contact@geolim4.com>2014-08-08 16:40:33 +0200
commit6b60153ab4ac036bcd4eaaa90806d9898fc1e9a2 (patch)
treed378a9a0aa46968a08a0f20dcbbe4b4e2c049f3a /phpBB/phpbb/db/driver/driver.php
parentf6da2661091a9f068956a23df7e70450cec9ee74 (diff)
downloadforums-6b60153ab4ac036bcd4eaaa90806d9898fc1e9a2.tar
forums-6b60153ab4ac036bcd4eaaa90806d9898fc1e9a2.tar.gz
forums-6b60153ab4ac036bcd4eaaa90806d9898fc1e9a2.tar.bz2
forums-6b60153ab4ac036bcd4eaaa90806d9898fc1e9a2.tar.xz
forums-6b60153ab4ac036bcd4eaaa90806d9898fc1e9a2.zip
[ticket/12671] Possibility to use NOT LIKE expression
PHPBB3-12671
Diffstat (limited to 'phpBB/phpbb/db/driver/driver.php')
-rw-r--r--phpBB/phpbb/db/driver/driver.php11
1 files changed, 11 insertions, 0 deletions
diff --git a/phpBB/phpbb/db/driver/driver.php b/phpBB/phpbb/db/driver/driver.php
index 3e9110d8bc..ed650bd6a9 100644
--- a/phpBB/phpbb/db/driver/driver.php
+++ b/phpBB/phpbb/db/driver/driver.php
@@ -372,6 +372,17 @@ abstract class driver implements driver_interface
/**
* {@inheritDoc}
*/
+ function sql_not_like_expression($expression)
+ {
+ $expression = utf8_str_replace(array('_', '%'), array("\_", "\%"), $expression);
+ $expression = utf8_str_replace(array(chr(0) . "\_", chr(0) . "\%"), array('_', '%'), $expression);
+
+ return $this->_sql_like_expression('NOT LIKE \'' . $this->sql_escape($expression) . '\'');
+ }
+
+ /**
+ * {@inheritDoc}
+ */
public function sql_case($condition, $action_true, $action_false = false)
{
$sql_case = 'CASE WHEN ' . $condition;