malo cudnih stvari PHP-mysqlPoslao mi lik mail gde kaze da ne moze da se registruje, taman sam hteo da ga napljujem kada sam provalio da covek nije kriv a ja ne znam sta se desava.
Dakle, lik je pokusao da se registruje kao "david". Imam pored ostalih promena i deo gde proveravam da li postoji izabrani username i e-mail koji izgleda otprilike ovako
Code:
// now check if username or e-mail already exists in the database
$sQuery = "SELECT mem_username, DECODE(mem_email,\"".$this->encodeString."\") as eml FROM members WHERE (mem_username=\"".$username."\" OR ENCODE(\"".$email."\",\"".$this->encodeString."\") = mem_email) ";
// now check if username or e-mail already exists in the database
$sQuery = "SELECT mem_username, DECODE(mem_email,\"".$this->encodeString."\") as eml FROM members WHERE (mem_username=\"".$username."\" OR ENCODE(\"".$email."\",\"".$this->encodeString."\") = mem_email) ";
a onda radi proveru
Code:
if ($this->dbClass->records[0]["mem_username"] == $username)
$arrErrors[] = "The username \"".$username."\" is already in use. Please enter another username!".$strLostPassword;
elseif ($this->dbClass->records[0]["eml"] == $email)
$arrErrors[] = "The email address \"".$email."\" already exists in our database!".$strLostPassword;
if ($this->dbClass->records[0]["mem_username"] == $username)
$arrErrors[] = "The username \"".$username."\" is already in use. Please enter another username!".$strLostPassword;
elseif ($this->dbClass->records[0]["eml"] == $email)
$arrErrors[] = "The email address \"".$email."\" already exists in our database!".$strLostPassword;
Sta se desilo? 'Ladno je propustio "david" iako u bazi ima "David" ali ga nije dodao u tabelu. Napominjem da polje nije BINARY vec VARCHAR(15) i kada covek pokusa da se loguje naravno invalid password jer cita password za "David".
Jel' ima neko ideju zasto se to dogadja?
Goran Pilipović fka bluesman
