diff options
| author | INOPIAE <inopiae@cacert.org> | 2014-01-20 22:36:56 +0100 |
|---|---|---|
| committer | INOPIAE <inopiae@cacert.org> | 2014-01-20 22:36:56 +0100 |
| commit | 73fc407c07205e87d537338101ba133393aa80e2 (patch) | |
| tree | ddbed5c6edda56713f26493da7c4aa42abc2bc30 /pages/wot | |
| parent | 748e102c01f8f7b4f3d31489e319e5754a2a802e (diff) | |
| download | cacert-devel-73fc407c07205e87d537338101ba133393aa80e2.tar.gz cacert-devel-73fc407c07205e87d537338101ba133393aa80e2.tar.xz cacert-devel-73fc407c07205e87d537338101ba133393aa80e2.zip | |
bug 1138: added assurances to SE log, rework of assurance delete form delete assurance to deleted=Now()
Diffstat (limited to 'pages/wot')
| -rw-r--r-- | pages/wot/10.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/pages/wot/10.php b/pages/wot/10.php index bc76a86..e490af9 100644 --- a/pages/wot/10.php +++ b/pages/wot/10.php @@ -36,8 +36,8 @@ WHERE `users`.`id` = `notary`.`from` AND `notary`.`from` != `notary`.`to` GROUP BY `notary`.`from` HAVING count(*) > '$rc' ORDER BY `notary`.`when` DESC"; */ - $query = "SELECT count(*) AS `list` FROM `users` - inner join `notary` on `users`.`id` = `notary`.`from` + $query = "SELECT count(*) AS `list` FROM `users` + inner join `notary` on `users`.`id` = `notary`.`from` GROUP BY `notary`.`from` HAVING count(*) > '$rc'"; $rank = mysql_num_rows(mysql_query($query)) + 1; @@ -64,7 +64,7 @@ <td class="DataTD"><b><?=_("Method")?></b></td> </tr> <? - $query = "select * from `notary` where `to`='".intval($_SESSION['profile']['id'])."'"; + $query = "select * from `notary` where `deleted`=0 and `to`='".intval($_SESSION['profile']['id'])."'"; $res = mysql_query($query); while($row = mysql_fetch_assoc($res)) { @@ -114,7 +114,7 @@ if ($thawte) </tr> <? $points = 0; - $query = "select * from `notary` where `from`='".intval($_SESSION['profile']['id'])."' and `to`!='".intval($_SESSION['profile']['id'])."'"; + $query = "select * from `notary` where `from`='".intval($_SESSION['profile']['id'])."' and `deleted`=0 and `to`!='".intval($_SESSION['profile']['id'])."'"; $res = mysql_query($query); while($row = mysql_fetch_assoc($res)) { |