# Update Member Account Moved below, replaced by IDUpdate
$dbMemberAcct="MemberAcct";
if (substr_count($Defaults,"TESTDB"))
{$dbMemberAcct.="Test";} #echo "dbMemberAcct $dbMemberAcct .. ID:$ID
";}
$sql="SELECT * FROM $dbMemberAcct WHERE ID='$ID'";
$result = mysqli_query($con, $sql) or die("Arg1: ".$Arg1." ". Mysqli_error($con));
While($row=mysqli_fetch_array($result))
{$LastAccess=$row['LastAccess'];
$PriorMmbrLfhrCredits=$row['LfhrCredits'];
$PriorMmbrLfhrWarrants=$row['LfhrWarrants'];
$Xacts=$row['Xacts'];
#echo "1 $NewMmbrLfhrCredits ... $Xacts
";
}
$Xacts+="1";
$NewMmbrLfhrCredits=$PriorMmbrLfhrCredits+$Lfhrs;
$NewMmbrLfhrWarrants=$PriorMmbrLfhrWarrants+$Lfhrs;
$sql = "UPDATE $dbMemberAcct
SET Xacts='$Xacts',
LfhrCredits='$NewMmbrLfhrCredits',
LfhrWarrants='$NewMmbrLfhrWarrants',
LastAccess='$Now'
WHERE ID='$ID'";
mysqli_query($con, $sql) or die("Update failed: ". mysqli_error($con));
die ("EOF");
# Update Angels tally
$sql="SELECT * FROM $db WHERE LOAN='1'";
$result = mysqli_query($con, $sql) or die("Angel Loan Tally in $db ". Mysqli_error($con));
While($row=mysqli_fetch_array($result))
{$PriorAngelTotal=$row['LoanAmount'];
$LastAccess=$row['LastAccess'];
$PriorAngelWarrants=$row['Warrants'];
}
$NewAngelLoanTotal = $PriorAngelTotal+$LoanAmt;
$NewAngelWarrants=$PriorAngelWarrants+$Lfhrs;
#echo $Now . " $".$NewAngelLoanTotal;
$sql="UPDATE $db
SET LoanAmount='$NewAngelLoanTotal',
Warrants='$NewAngelWarrants',
LastAccess='$Now'
Where LOAN='1'";
mysqli_query($con, $sql) or die("Update failed: ". mysqli_error($con));
#######################
#Resubmission check
#Replaced by NoRepeats
$sql="SELECT * FROM $db WHERE ID='$ID' and LastAccess='$Now'";
$result = mysqli_query($con, $sql) or die("Angel Loan problem in $db ". Mysqli_error($con));
While($row=mysqli_fetch_array($result))
{die ("