diff options
Diffstat (limited to 'pages/account')
-rw-r--r-- | pages/account/43.php | 14 | ||||
-rw-r--r-- | pages/account/52.php | 10 | ||||
-rw-r--r-- | pages/account/55.php | 2 |
3 files changed, 13 insertions, 13 deletions
diff --git a/pages/account/43.php b/pages/account/43.php index 9a9d75f..dcfa378 100644 --- a/pages/account/43.php +++ b/pages/account/43.php @@ -21,7 +21,6 @@ include_once($_SESSION['_config']['filepath']."/includes/notary.inc.php"); $ticketno=''; $ticketvalidation=FALSE; - if (isset($_SESSION['ticketno'])) { $ticketno = $_SESSION['ticketno']; $ticketvalidation = valid_ticket_number($ticketno); @@ -32,6 +31,7 @@ if (isset($_SESSION['ticketmsg'])) { $ticketmsg = ''; } + // search for an account by email search, if more than one is found display list to choose if(intval(array_key_exists('userid',$_REQUEST)?$_REQUEST['userid']:0) <= 0) { @@ -132,14 +132,13 @@ if(intval($_REQUEST['userid']) > 0) { } else { $assurance = mysql_escape_string(intval($_REQUEST['assurance'])); $trow = 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) { $trow = mysql_fetch_assoc($res); - } - - mysql_query("update `notary` set `deleted`=NOW() where `id`='$assurance'"); - if ($trow) { - fix_assurer_flag($trow['to']); + mysql_query("update `notary` set `deleted`=NOW() where `id`='$assurance'"); + if ($trow) { + fix_assurer_flag($trow['to']); + } } } } elseif(array_key_exists('assurance',$_REQUEST) && $_REQUEST['assurance'] > 0 && $ticketvalidation == FALSE) { @@ -966,6 +965,7 @@ if(intval($_REQUEST['userid']) > 0) { <? // if(array_key_exists('assuredto',$_GET) && $_GET['assuredto'] == "yes") { + function showassuredto($ticketno) { ?> diff --git a/pages/account/52.php b/pages/account/52.php index 77a3bae..ce2025f 100644 --- a/pages/account/52.php +++ b/pages/account/52.php @@ -35,7 +35,7 @@ exit; } - $query = "select sum(`points`) as `points` from `notary` where `to`='$memid'"; + $query = "select sum(`points`) as `points` from `notary` where `to`='$memid' and `deleted` = 0"; $notary = mysql_fetch_assoc(mysql_query($query)); $query = "select * from `users` where `id`='$memid'"; $user = mysql_fetch_assoc(mysql_query($query)); @@ -65,7 +65,7 @@ <input type="hidden" name="oldid" value="<?=intval($_GET['id'])?>"> <input type="hidden" name="uid" value="<?=$uid?>"> </form> -<? } else { +<? } else { $query = "select * from `tverify` where `id`='$uid' and `modified`=1"; $res = mysql_query($query); if(mysql_num_rows($res) > 0) @@ -74,7 +74,7 @@ } else { if($uid) echo _("Unable to locate a valid request for that UID.")."<br/>"; } - + // Search for open requests: $query = "select * from `tverify` where `modified`=0"; $res = mysql_query($query); @@ -83,14 +83,14 @@ echo "<br/>"._("The following requests are still open:")."<br/><ul>"; while($row = mysql_fetch_assoc($res)) { - $uid=intval($row['id']); + $uid=intval($row['id']); $query3 = "select * from `tverify-vote` where `tverify`='$uid' and `memid`='".intval($_SESSION['profile']['id'])."'"; $rc3 = mysql_num_rows(mysql_query($query3)); if($rc3 <= 0) { echo "<li><a href='account.php?id=52&uid=".intval($row['id'])."'>".intval($row['id'])."</a></li>\n"; } - } + } echo "</ul>\n<br>\n"; } else diff --git a/pages/account/55.php b/pages/account/55.php index 38e9fb7..7e9710c 100644 --- a/pages/account/55.php +++ b/pages/account/55.php @@ -87,7 +87,7 @@ <tr><td colspan="3" class="DataTD"><a href="account.php?id=43&userid=<?=$user_id ?>">back</a></td></tr>
<? } else {
$query = 'SELECT `u`.id, `u`.`assurer`, SUM(`points`) FROM `users` AS `u`, `notary` AS `n` '.
- ' WHERE `u`.`id` = \''.(int)intval($_SESSION['profile']['id']).'\' AND `n`.`to` = `u`.`id` AND `expire` < now() '.
+ ' WHERE `u`.`id` = \''.(int)intval($_SESSION['profile']['id']).'\' AND `n`.`to` = `u`.`id` AND `expire` < now() and and `n`.`deleted` = 0'. ' GROUP BY `u`.id, `u`.`assurer`';
$res = mysql_query($query);
if (!$res) {
|