Example #1
0
File: area.php Project: anqh/forum
 /**
  * Find private message topics
  *
  * @static
  * @param   Model_User  $user
  * @param   integer     $offset
  * @param   integer     $limit
  * @return  Model_Forum_Private_Topic[]
  */
 public static function find_topics(Model_User $user, $offset = 0, $limit = 10)
 {
     $topic = new Model_Forum_Private_Topic();
     return $topic->load(DB::select_array($topic->fields())->join('forum_private_recipients')->on('forum_private_topics.id', '=', 'forum_private_recipients.forum_topic_id')->where('user_id', '=', $user->id)->order_by('last_post_id', 'DESC')->offset($offset), $limit);
 }