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