public static function findByUser($user_id) { $statement = 'SELECT message.*, thread.name as thread_name' . ' FROM message' . ' LEFT JOIN thread' . ' ON message.thread_id = thread.id' . ' WHERE message.user_id = :user_id' . ' ORDER BY created ASC'; $values = array('user_id' => $user_id); $messages = DatabaseService::get($statement, $values); return $messages; }
public static function findByUser($user_id) { $statement = 'SELECT thread.*, forumuser.username as username' . ' FROM thread INNER JOIN forumuser' . ' ON thread.user_id = forumuser.id' . ' WHERE thread.user_id = :user_id'; $values = array('user_id' => $user_id); $thread = DatabaseService::get($statement, $values); return $thread; }
private static function findNumberOfMessages($user_id, $thread_id) { $statement = 'SELECT amount FROM thread_user WHERE user_id = :user_id AND thread_id = :thread_id'; $values = array('user_id' => $user_id, 'thread_id' => $thread_id); $result = DatabaseService::get($statement, $values, TRUE); return $result; }