summaryrefslogtreecommitdiff
path: root/pages/account/43.php
diff options
context:
space:
mode:
authorBenny Baumann <BenBE@geshi.org>2013-11-19 22:53:49 +0100
committerBenny Baumann <BenBE@geshi.org>2013-11-19 23:24:09 +0100
commit8c702e67919146c1a2e61b25d3609c4c32d987e0 (patch)
treec2947b88750a9c22555f2b3b88fb4c39abf08271 /pages/account/43.php
parentbe7573a378a88bdc8574a613a068097503f40d6d (diff)
downloadcacert-devel-8c702e67919146c1a2e61b25d3609c4c32d987e0.tar.gz
cacert-devel-8c702e67919146c1a2e61b25d3609c4c32d987e0.tar.xz
cacert-devel-8c702e67919146c1a2e61b25d3609c4c32d987e0.zip
bug 1221: changed delete assurance to update "deleted = NOW()", added `deleted` = 0 to all queries on notary
Diffstat (limited to 'pages/account/43.php')
-rw-r--r--pages/account/43.php10
1 files changed, 5 insertions, 5 deletions
diff --git a/pages/account/43.php b/pages/account/43.php
index 53b24d3..a81d9a3 100644
--- a/pages/account/43.php
+++ b/pages/account/43.php
@@ -23,11 +23,11 @@ include_once($_SESSION['_config']['filepath']."/includes/notary.inc.php");
{
$assurance = mysql_escape_string(intval($_REQUEST['assurance']));
$row = 0;
- $res = mysql_query("select `to` from `notary` where `id`='$assurance'");
+ $res = mysql_query("select `to` from `notary` where `id`='$assurance' and `deleted` = 0");
if ($res) {
$row = mysql_fetch_assoc($res);
}
- mysql_query("delete from `notary` where `id`='$assurance'");
+ mysql_query("update `notary` set `deleted`=NOW() where `id`='$assurance'");
if ($row) {
fix_assurer_flag($row['to']);
}
@@ -108,7 +108,7 @@ include_once($_SESSION['_config']['filepath']."/includes/notary.inc.php");
echo _("I'm sorry, the user you were looking for seems to have disappeared! Bad things are a foot!");
} else {
$row = mysql_fetch_assoc($res);
- $query = "select sum(`points`) as `points` from `notary` where `to`='".intval($row['id'])."'";
+ $query = "select sum(`points`) as `points` from `notary` where `to`='".intval($row['id'])."' and `deleted` = 0";
$dres = mysql_query($query);
$drow = mysql_fetch_assoc($dres);
$alerts = mysql_fetch_assoc(mysql_query("select * from `alerts` where `memid`='".intval($row['id'])."'"));
@@ -828,7 +828,7 @@ function showassuredto()
<td class="DataTD"><b><?=_("Revoke")?></b></td>
</tr>
<?
- $query = "select * from `notary` where `to`='".intval($_GET['userid'])."'";
+ $query = "select * from `notary` where `to`='".intval($_GET['userid'])."' and `deleted` = 0";
$dres = mysql_query($query);
$points = 0;
while($drow = mysql_fetch_assoc($dres))
@@ -874,7 +874,7 @@ function showassuredby()
<td class="DataTD"><b><?=_("Revoke")?></b></td>
</tr>
<?
- $query = "select * from `notary` where `from`='".intval($_GET['userid'])."'";
+ $query = "select * from `notary` where `from`='".intval($_GET['userid'])."' and `deleted` = 0";
$dres = mysql_query($query);
$points = 0;
while($drow = mysql_fetch_assoc($dres))