[ bluesman @ 24.12.2002. 21:52 ] @
Imam jedan problem. Poslao 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) "; 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; 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? |