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 '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).
Citizen Already Found in Roster System
';
}
}
}
else {
echo 'BLACK SHEEP NEW MEMBER APPLICATION
';
}
?>