/**
* @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;
}
}
}
