summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFelix Dörre <felix@dogcraft.de>2015-05-05 20:02:19 +0200
committerFelix Dörre <felix@dogcraft.de>2015-05-05 20:03:50 +0200
commit80d3a9af2c566fc5a041458b38c3a7fca00aaebf (patch)
tree543bd3ee723e2083b1e343036750a1f7bb1a6db3
parente12f929ab962e023f613a7411e49ebbbaad4700a (diff)
downloadcacert-devel-80d3a9af2c566fc5a041458b38c3a7fca00aaebf.tar.gz
cacert-devel-80d3a9af2c566fc5a041458b38c3a7fca00aaebf.tar.xz
cacert-devel-80d3a9af2c566fc5a041458b38c3a7fca00aaebf.zip
bug 1046: escape quotes in fix_assurer_flag-queries
-rw-r--r--includes/lib/account.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/lib/account.php b/includes/lib/account.php
index 6e17dda..f9c1399 100644
--- a/includes/lib/account.php
+++ b/includes/lib/account.php
@@ -49,7 +49,7 @@ function fix_assurer_flag($userID = NULL)
)
AND (
SELECT SUM(`awarded`) FROM `notary` AS `n`
- WHERE `n`.`to` = `u`.`id` AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to`
+ WHERE `n`.`to` = `u`.`id` AND `n`.`method` != \'Administrative Increase\' AND `n`.`from` != `n`.`to`
AND (`n`.`expire` > now()
OR `n`.`expire` IS NULL)
AND `n`.`deleted` = 0
@@ -82,7 +82,7 @@ function fix_assurer_flag($userID = NULL)
)
OR (
SELECT SUM(`awarded`) FROM `notary` AS `n`
- WHERE `n`.`to` = `u`.`id` AND `n`.`method` != 'Administrative Increase' AND `n`.`from` != `n`.`to`
+ WHERE `n`.`to` = `u`.`id` AND `n`.`method` != \'Administrative Increase\' AND `n`.`from` != `n`.`to`
AND (
`n`.`expire` > now()
OR `n`.`expire` IS NULL