public function mailPassword($user){

            $username = preg_replace("/[^a-zA-Z0-9\s]/", " ",addslashes($user->username));


            $sql = "SELECT * FROM spotted_admin WHERE username = '$username'";

            $result = mysql_query($sql);
            $rows = array();
            while($row = mysql_fetch_assoc($result)) $rows[] = $row;

            $opgehaaldeUser = $rows[0];
            $mail = $opgehaaldeUser["email"];

            $fileToString= file_get_contents("mail/mail.php",true);
            $fileToString = str_replace("FIELD_USERNAME",$opgehaaldeUser["username"],$fileToString);

            //making up the special code
            $dbCode = rand(0,getrandmax());
            $qsCode = base64_encode($dbCode);

            $fileToString = str_replace("FIELD_PASSWORD",$qsCode,$fileToString);



          if($opgehaaldeUser["username"] == ($username))
          {
            //hier komt de code voor het mailen
                $to = $mail;

                // subject
                $subject = 'Activate new password.';

                // message
                $message = $fileToString;

                // To send HTML mail, the Content-type header must be set
                $headers  = 'MIME-Version: 1.0' . "\r\n";
                $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

                // Additional headers
                $headers .= 'To:'. $row->username .' <'.$row->email.'>' . "\r\n";
                $headers .= 'From:Spotted Admin Service <spotted@thomasv.be>' . "\r\n";

                // Mail it
                if(mail($to, $subject, $message, $headers)){
                $sqlChange = "UPDATE spotted_admin SET passReq=1 WHERE username = '$username'";

                $changePasswordSQL = "UPDATE spotted_admin SET password= '$dbCode' WHERE username= '$username'";
                mysql_query($changePasswordSQL);

                return  mysql_query($sqlChange);

                }else{

                    return false;
                    }


          }

       }