function doLogin() { $this->save("login"); if (empty($this->messages)) { $select = new Select("users"); $select->add(Exp::eq("username", $this->login["username"])); $user = DB::unique($select); if (empty($user)) { $this->addMsgMessage("error.fieldNotFound", "login.username"); Msg::save($this->messages); Apu::redirect("login"); } if ($user["password"] != $this->login["password"]) { $this->addMsgMessage("error.fieldNotFound", "login.password"); Msg::save($this->messages); Apu::redirect("login"); } $date = new Date(); Session::save(LOGIN_SCOPE, $user, "user"); Session::save(LOGIN_SCOPE, $date, "last_access"); $this->remove(); Apu::redirect("frame"); } else { Msg::save($this->messages); Apu::redirect("login"); } }
function sql() { $this->expressions = array(); $this->add(Exp::eq("id", $this->value["__ID__"])); $sql = sprintf("update %s set %s %s", $this->tableString(), $this->valueString(), $this->whereString()); return $sql; }
function sql() { $this->expressions = array(); $this->add(Exp::eq("id", $this->value["__ID__"])); $this->maxResults = 1; $sql = sprintf("delete from %s %s %s", $this->tableString(), $this->whereString(), $this->limitString()); return $sql; }
function byId($id, $table) { $select = new Select($table); $select->add(Exp::eq("id", $id)); return DB::unique($select); }