public function save(User $user) { $query = "SELECT * FROM users WHERE username = ?"; $this->db->query($query, [$user->getUsername()]); $result = $this->db->row(); if ($result) { echo 'The username already taken!'; die; } $query = "\n INSERT INTO users (username, email, cash, roleId, password)\n VALUES (?, ?, ?, ?, ?)\n "; $params = [$user->getUsername(), $user->getEmail(), floatval($user->getCash()), $user->getRole(), $user->getPassword()]; if ($user->getId()) { $query = "UPDATE players SET username = ?, password = ? WHERE id = ?"; $params[] = $user->getId(); } $this->db->query($query, $params); return $this->db->rows() > 0; }
/** * Declares an association between this object and a ChildUser object. * * @param ChildUser $v * @return $this|\Models\Group The current object (for fluent API support) * @throws PropelException */ public function setOwner(ChildUser $v = null) { if ($v === null) { $this->setOwnerId(NULL); } else { $this->setOwnerId($v->getId()); } $this->aOwner = $v; // Add binding for other direction of this n:n relationship. // If this object has already been added to the ChildUser object, it will not be re-added. if ($v !== null) { $v->addMyGroup($this); } return $this; }
public function getId() { $this->_load(); return parent::getId(); }
/** * {@inheritDoc} */ public function getId() { if ($this->__isInitialized__ === false) { return (int) parent::getId(); } $this->__initializer__ && $this->__initializer__->__invoke($this, 'getId', array()); return parent::getId(); }
/** * Exclude object from result * * @param ChildUser $user Object to remove from the list of results * * @return $this|ChildUserQuery The current query, for fluid interface */ public function prune($user = null) { if ($user) { $this->addUsingAlias(UserTableMap::COL_ID, $user->getId(), Criteria::NOT_EQUAL); } return $this; }
/** * Filter the query by a related \Models\User object * * @param \Models\User|ObjectCollection $user The related object(s) to use as filter * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL * * @throws \Propel\Runtime\Exception\PropelException * * @return ChildCategoryQuery The current query, for fluid interface */ public function filterByUser($user, $comparison = null) { if ($user instanceof \Models\User) { return $this->addUsingAlias(CategoryTableMap::COL_USER_ID, $user->getId(), $comparison); } elseif ($user instanceof ObjectCollection) { if (null === $comparison) { $comparison = Criteria::IN; } return $this->addUsingAlias(CategoryTableMap::COL_USER_ID, $user->toKeyValue('PrimaryKey', 'Id'), $comparison); } else { throw new PropelException('filterByUser() only accepts arguments of type \\Models\\User or Collection'); } }
/** * Salva o cookie de autenticação * @param \Models\User $user Objeto \Models\User do usuário logado */ public static function saveSessionCookieForUser(\Models\User $user) { $cookieData = ['id' => $user->getId(), 'token' => $user->getToken()]; // 2592000 = 60 * 60 * 24 * 30, ou seja, 30 dias em segundos setcookie(AUTH_USER_COOKIE_NAME, serialize($cookieData), time() + 2592000); }
/** * Filter the query by a related \Models\User object * * @param \Models\User $user The related object to use as filter * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL * * @throws \Propel\Runtime\Exception\PropelException * * @return ChildSharedQuery The current query, for fluid interface */ public function filterByUser($user, $comparison = null) { if ($user instanceof \Models\User) { return $this->addUsingAlias(SharedTableMap::COL_TO_TYPE, 'user', $comparison)->addUsingAlias(SharedTableMap::COL_TO_ID, $user->getId(), $comparison); } else { throw new PropelException('filterByUser() only accepts arguments of type \\Models\\User'); } }
private static function update(User $model) { $db = Database::getInstance('app'); $query = "UPDATE users SET username= :username, email= :email, password= :password, role_id= :role_id, f_name= :f_name, l_name= :l_name, gender= :gender, date_of_birth= :date_of_birth, registered_at= :registered_at WHERE id = :id"; $result = $db->prepare($query); $result->execute([':id' => $model->getId(), ':username' => $model->getUsername(), ':email' => $model->getEmail(), ':password' => $model->getPassword(), ':role_id' => $model->getRole_id(), ':f_name' => $model->getF_name(), ':l_name' => $model->getL_name(), ':gender' => $model->getGender(), ':date_of_birth' => $model->getDate_of_birth(), ':registered_at' => $model->getRegistered_at()]); }
public function updateUser(User $user) { $result = $this->db->prepare("\n\t\t\tUPDATE user\n\t\t\tSET money = ?,\n\t\t\t\tbanned = ?\n\t\t\tWHERE id = ?\n\t\t"); $result->execute([$user->getMoney(), $user->getBanned(), $user->getId()]); }
/** * ### Starts a session for the given user * * @param \Models\User $user */ private static function startSession($user) { $_SESSION['logged_in'] = 1; $_SESSION['user'] = $user->getId(); }
private static function update(User $model) { $db = Database::getInstance('app'); $query = "UPDATE user SET username= :username, password= :password, registerDate= :registerDate, emailVerified= :emailVerified, email= :email, createdAt= :createdAt, updatedAt= :updatedAt WHERE id = :id"; $result = $db->prepare($query); $result->execute([':id' => $model->getId(), ':username' => $model->getUsername(), ':password' => $model->getPassword(), ':registerDate' => $model->getRegisterDate(), ':emailVerified' => $model->getEmailVerified(), ':email' => $model->getEmail(), ':createdAt' => $model->getCreatedAt(), ':updatedAt' => $model->getUpdatedAt()]); }
/** * Declares an association between this object and a ChildUser object. * * @param ChildUser $v * @return $this|\Models\Notification The current object (for fluent API support) * @throws PropelException */ public function setOriginUser(ChildUser $v = null) { if ($v === null) { $this->setOriginType(null); } else { $this->setOriginType('user'); } if ($v === null) { $this->setOriginId(NULL); } else { $this->setOriginId($v->getId()); } $this->aOriginUser = $v; // Add binding for other direction of this n:n relationship. // If this object has already been added to the ChildUser object, it will not be re-added. if ($v !== null) { $v->addNotificationRelatedByOriginTypeOriginId($this); } return $this; }