hi, i looked all the codes but i could not really see it - i dont really understand coding-. after registration this website send an activation code but i want to make the user active when they actually register. when they register their status is set to A but for them to be active it needs to be P on the database. below is the closest code i could find.
can you please help me what i should look for or what can i do make the user active when they register?
thnank you
function verifyMember($username, $password) {
$this->setDebugMsg("Method: verifyMember()");
$ret = 0;
$q = sprintf("SELECT id, member_status_code FROM member WHERE username='%s' AND password='%s' LIMIT 1",
mysql_real_escape_string($username),
mysql_real_escape_string($password)
);
$rs = $this->db->query($q);
if ($rs) {
if($this->db->numRows($rs) > 0)
{
$row = $this->db->fetchAssoc($rs);
if ($row["member_status_code"]!="A")
{
$ret = $row["member_status_code"];
}
else
{
$ret = $row["id"];
}
}
else
{
$ret = 0;
}
}
return $ret;
}