query("select from users where name='".addslashesifnogpc($username)."'");
if($AEdb->num_rows($q)>0) return false;
$sql = "insert into users (name,password,email) values ('".addslashesifnogpc($username)."',PASSWORD('".addslashesifnogpc($password)."'),'".addslashesifnogpc($email)."')";
$AEdb->query($sql);
$q = $AEdb->query("select name from users where name='".addslashesifnogpc($username)."'");
if($AEdb->num_rows($q)>0) return true;
else return false;
}
/**
* A function to transform a category's display using a specific template.
*
* The category attributes can be referenced in the template by $attributename which will be replaced by the attribute value
* if it exists, even if its value is a blank string. If it does not exist, the string "$attributename" will be left intact in the rendered template.
* Getting a link to a file stored in the category can be done using %filename - you may wish to do something like
* 
