BLACK SHEEP MEMBER LOGIN
if ($_SERVER['REQUEST_METHOD'] == 'POST') { include('connection.php'); $citizenid = mysql_real_escape_string($_POST['citizenid']); $citizenpw = mysql_real_escape_string(sha1($_POST['citizenpw'])); $date = date("Y-m-d"); $time = date("h:i:sa T"); $sql = "SELECT * FROM bs_accounts WHERE CitizenID = '$citizenid' AND Password = '$citizenpw'"; $result = mysql_query($sql); $numrows = mysql_num_rows($result); $row = mysql_fetch_array($result); $citizenname = $row['CitizenName']; $loggedin = "Logged in"; if($numrows < 1) { echo "Soldier Account Not Found!"; } elseif($numrows == 1) { echo "User Authenticated. Please Wait..."; session_start(); $_SESSION['bs_member2'] = $citizenid; $sql2="INSERT INTO bs_slogs (Date, Time, CitizenName, Action) VALUES ('$date', '$time', '$citizenname', '$loggedin')"; $result2=mysql_query($sql2); ?> } mysql_close($db); } ?>