# 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 ("
Repeat submission of Angel data cancelled.

Timism Homepage

Barnett For Congress

Save Atlantic Coastline from Dominion's Pipeline

CaveGarden

"); } #Payables appending of $Src="L"; #Loan $Details="Angel Funding"; $db="Payables"; if (substr_count($Defaults,"TESTDB")) $db.="Test"; $sql="INSERT INTO $db (ID,Email,Src,LfhrWarrants,DollarsUS,Details,Submitted) VALUES ('$ID','$MemberEmail','$Src','$Lfhrs','$LoanAmt','$Details','$Now')"; mysqli_query($con, $sql) or die(mysqli_error($con) . " db: $db"); #echo "Payables updated
";