public function storeLogin(Login $login) { $stmntSingup = $this->db->prepare("\n\t\t\tINSERT INTO login SET\n\t\t\t\tusername = ?,\n\t\t\t\temail = ?,\n\t\t\t\tpassword = ?,\n\t\t\t\tregisteredby = ?,\n\t\t\t\tsalt = ?,\n\t\t\t\tconfirmed = NULL,\n\t\t\t\tactive = ?,\n\t\t\t\tlastlogin = NULL,\n\t\t\t\twronglogins = 0\n\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t\tusername = ?,\n\t\t\t\temail = ?,\n\t\t\t\tactive = ?,\n\t\t\t\tpassword = ?,\n\t\t\t\tsalt = ?\n\t\t"); $userID = $this->db->insert($stmntSingup, array($login->getUsername(), $login->getEmail(), $login->getPassword(), $login->getRegisteredBy(), $login->getSalt(), (int) $login->getActive(), $login->getUsername(), $login->getEmail(), (int) $login->getActive(), $login->getPassword(), $login->getSalt())); return $login->getID() === null ? $userID : $login->getID(); }