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); }