Invalid citizen ID; your citizen ID is the set of numbers in your profile link!
'; } else { $sql1="SELECT * FROM bs_accounts WHERE CitizenID='$citid'"; $result1=mysql_query($sql1); $numrows1=mysql_num_rows($result1); if($numrows1 < 1) { $sql2="INSERT INTO bs_applications (CitizenID, CitizenName, ApplyDate, Referrer, Password, IP, Team) VALUES ('$citid','$citname','$date','$referrer','$password','$ip','$team')"; $result2=mysql_query($sql2); mysql_close($db); echo '
Application Submitted! We will contact you shortly. :)
To get set up as soon as possible, visit us on IRC here.
If you\'re employed, please quit your job (if you can\'t do it today, send a message to your employer asking him/her to fire you).
'; } elseif($numrows1 <= 1) { echo '
Citizen Already Found in Roster System
'; } } } else { echo '
BLACK SHEEP NEW MEMBER APPLICATION
'; } ?>