<?
session_start();
include('admin/db.php');
$id = mysql_real_escape_string($_GET[id]);
$title = 'Account Verification'; 
$headertitle = 'Account Verification';
$result = mysql_query("SELECT * FROM users WHERE validate = '$id' && validate != ''");
if(mysql_num_rows($result) < 1) {
	$message = "Invalid validation code!"; 
}
else {
	$message = "Your account has been successfully verified, and you may now <a href='/login.php'>login</a>.";
	mysql_query("UPDATE users SET validate = '' WHERE validate = '$id'");
}
include($basepath.'/templates/template.overall_header.php'); 
echo $message;
include($basepath.'/templates/template.overall_footer.php'); ?>