public static function changePostAmount($user_id, $thread_id, $change)
{
$res = self::findNumberOfMessages($user_id, $thread_id);
if ($res == NULL) {
$statement = 'INSERT INTO thread_user (user_id, thread_id, amount) VALUES (:user_id, :thread_id, :amount) ';
$amount = 0;
} else {
$statement = 'UPDATE thread_user SET amount=:amount WHERE thread_id=:thread_id AND user_id=:user_id';
$amount = $res['amount'];
}
$amount += $change;
if ($amount <= 0) {
self::deleteParticipation($user_id, $thread_id);
return;
}
$values = array('amount' => $amount, 'thread_id' => $thread_id, 'user_id' => $user_id);
DatabaseService::save($statement, $values);
}
public function updateLastpost($lastpost)
{
$statement = 'UPDATE thread SET lastpost=:lastpost WHERE id=:id';
$values = array('id' => $this->id, 'lastpost' => $lastpost);
DatabaseService::save($statement, $values);
}
public function update()
{
$statement = 'UPDATE message SET content=:content, modified=:modified WHERE id=:id';
$values = array('id' => $this->id, 'modified' => $this->modified, 'content' => $this->content);
DatabaseService::save($statement, $values);
}
