/** * @brief getUser 获取用户数据 * * @return array */ public function getUser() { if (!$this->uid && !$this->name) { return FALSE; } $where = ''; if ($this->uid) { $where .= " AND `uid`={$this->uid}"; } if ($this->name) { $where .= " AND `username`='{$this->name}'"; } return Database::fetchOneArray("SELECT * FROM `{$this->prefix}users` WHERE 1=1{$where}"); }
/** * @brief getNext 获取下一篇文章 * * @TODO 获取同分类的下一篇文章 * * @param $pid 文章 ID * * @return array */ public function getNext($pid) { return Database::fetchOneArray("SELECT * FROM `{$this->prefix}posts` WHERE `pid`>{$pid} AND `type`=1 ORDER BY `pid` ASC LIMIT 0,1"); }
/** * @brief movRelation 修改 Meta 与 Post 的对应关系 * * @param $mid Meta ID * @param $oldPID Post ID * @param $newPID Post ID * @param $isMovePID 移动的是否为 PID * * @return bool */ public function movRelation($mid, $oldPID, $newPID, $isMovePID = true) { if ($isMovePID) { if ($r = Database::fetchOneArray("SELECT * FROM `{$this->prefix}posts_relation` WHERE `pid`={$oldPID} AND `mid`={$mid}", FALSE)) { return Database::query("UPDATE `{$this->prefix}posts_relation` SET `pid`={$newPID} WHERE `rid`={$r['rid']}"); } else { return FALSE; } } else { if ($r = Database::fetchOneArray("SELECT * FROM `{$this->prefix}posts_relation` WHERE `pid`={$mid} AND `mid`={$oldPID}", FALSE)) { $this->incReply($newPID); $this->decReply($oldPID); return Database::query("UPDATE `{$this->prefix}posts_relation` SET `mid`={$newPID} WHERE `rid`={$r['rid']}"); } else { return FALSE; } } }