diff options
| author | root <root@cacert1.(none)> | 2010-04-26 10:57:00 +0200 |
|---|---|---|
| committer | Michael Tänzer <neo@nhng.de> | 2010-11-30 21:10:04 +0100 |
| commit | 98f70ef22180480302cc4f07afa63a2675a71290 (patch) | |
| tree | 6f17a694cb0ec6f8ac85b78ff5f4dc8943315984 /pages/wot/10.php | |
| parent | 4145a1e31cf13340b417299f8a1fc87a90978d9d (diff) | |
| download | cacert-devel-98f70ef22180480302cc4f07afa63a2675a71290.tar.gz cacert-devel-98f70ef22180480302cc4f07afa63a2675a71290.tar.xz cacert-devel-98f70ef22180480302cc4f07afa63a2675a71290.zip | |
Show 'my points' in reverse order (newest points count, not oldest ones)
Needed for revoke of TTP-Assurances in November 2010
(cherry picked from commit 0bee978a0e84aedff45115e3f4e42af152cdfc4d)
Diffstat (limited to 'pages/wot/10.php')
| -rw-r--r-- | pages/wot/10.php | 22 |
1 files changed, 17 insertions, 5 deletions
diff --git a/pages/wot/10.php b/pages/wot/10.php index 51ed019..4a6afac 100644 --- a/pages/wot/10.php +++ b/pages/wot/10.php @@ -57,17 +57,29 @@ <td class="DataTD"><b><?=_("Method")?></b></td> </tr> <? - $query = "select * from `notary` where `to`='".intval($_SESSION['profile']['id'])."'"; + $points = 0; + $query = "select sum(points) as apoints from `notary` where `from`='".intval($_SESSION['profile']['id'])."' and `from`=`to` "; + $res = mysql_query($query); + $row = mysql_fetch_assoc($res); + + $maxpoints=intval($_SESSION['profile']['points'])-$row['apoints']; + + $points = 0; + $query = "select * from `notary` where `to`='".intval($_SESSION['profile']['id'])."' order by `id` desc "; $res = mysql_query($query); while($row = mysql_fetch_assoc($res)) { + $awarded = $row['awarded']; + if ($points+$awarded > $maxpoints) + $awarded = $maxpoints-$points; + $points = $points + $awarded; $fromuser = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($row['from'])."'")); ?> <tr> <td class="DataTD"><?=$row['id']?></td> <td class="DataTD"><?=$row['date']?></td> <td class="DataTD"><a href="wot.php?id=9&userid=<?=intval($row['from'])?>"><?=$fromuser['fname']." ".$fromuser['lname']?></td> - <td class="DataTD"><?=$row['points']?></td> + <td class="DataTD"><?=$awarded?></td> <td class="DataTD"><?=$row['location']?></td> <td class="DataTD"><?=_(sprintf("%s", $row['method']))?></td> </tr> @@ -93,12 +105,12 @@ </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 `to`!='".intval($_SESSION['profile']['id'])."' order by `id` desc"; $res = mysql_query($query); while($row = mysql_fetch_assoc($res)) { $fromuser = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($row['to'])."'")); - $points += $row['points']; + $points += $row['awarded']; $name = trim($fromuser['fname']." ".$fromuser['lname']); if($name == "") $name = _("Deleted before Verification"); @@ -109,7 +121,7 @@ <td class="DataTD"><?=intval($row['id'])?></td> <td class="DataTD"><?=$row['date']?></td> <td class="DataTD"><?=$name?></td> - <td class="DataTD"><?=intval($row['points'])?></td> + <td class="DataTD"><?=intval($row['awarded'])?></td> <td class="DataTD"><?=$row['location']?></td> <td class="DataTD"><?=$row['method']==""?"":_(sprintf("%s", $row['method']))?></td> </tr> |