summaryrefslogtreecommitdiff
path: root/www
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2013-11-11 01:11:04 +0100
committerBenny Baumann <BenBE@geshi.org>2013-11-19 23:24:09 +0100
commit8f72f0692164e88165741ba79fbea77df039e949 (patch)
tree379baab4cddc06398adf274a540ef6776ff73436 /www
parent8c702e67919146c1a2e61b25d3609c4c32d987e0 (diff)
downloadcacert-devel-8f72f0692164e88165741ba79fbea77df039e949.tar.gz
cacert-devel-8f72f0692164e88165741ba79fbea77df039e949.tar.xz
cacert-devel-8f72f0692164e88165741ba79fbea77df039e949.zip
bug 1221: fixed typo, added `deleted` = 0 to wot.php
Diffstat (limited to 'www')
-rw-r--r--www/wot.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/www/wot.php b/www/wot.php
index 8395a58..aef5a01 100644
--- a/www/wot.php
+++ b/www/wot.php
@@ -225,7 +225,7 @@ function send_reminder()
}
$query = "select * from `notary` where `from`='".$_SESSION['profile']['id']."' and
- `to`='".$_SESSION['_config']['notarise']['id']."'";
+ `to`='".$_SESSION['_config']['notarise']['id']."' and `deleted` = 0";
$res = mysql_query($query);
if(mysql_num_rows($res) > 0)
{
@@ -332,7 +332,7 @@ $iecho= "c";
if($newpoints < 0)
$newpoints = $awarded = 0;
- $query = "select sum(`points`) as `total` from `notary` where `to`='".$_SESSION['_config']['notarise']['id']."' group by `to`";
+ $query = "select sum(`points`) as `total` from `notary` where `to`='".$_SESSION['_config']['notarise']['id']."' and `deleted` = 0 group by `to`";
$res = mysql_query($query);
$drow = mysql_fetch_assoc($res);
@@ -352,7 +352,7 @@ $iecho= "c";
`to`='".$_SESSION['_config']['notarise']['id']."' AND
`awarded`='$awarded' AND
`location`='".mysql_escape_string(stripslashes($_POST['location']))."' AND
- `date`='".mysql_escape_string(stripslashes($_POST['date']))."'";
+ `date`='".mysql_escape_string(stripslashes($_POST['date']))."' and `deleted` = 0";
$res = mysql_query($query);
if(mysql_num_rows($res) > 0)
{
@@ -512,7 +512,7 @@ $iecho= "c";
$userid = intval($_REQUEST['userid']);
$user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='$userid' and `listme`=1"));
$points = mysql_num_rows(mysql_query("select sum(`points`) as `total` from `notary`
- where `to`='".$user['id']."' group by `to` HAVING SUM(`points`) > 0"));
+ where `to`='".$user['id']."' and `deleted` = 0 group by `to` HAVING SUM(`points`) > 0"));
if($points > 0)
{
$my_translation = L10n::get_translation();