public function get_video($id, $name = NULL)
{
$this->load->helper('video');
+ $this->load->helper('text');
$query = $this->db->query("SELECT v.*, u.username
FROM `videos` v, `users` u
// Thumbnails
$video['thumbs'] = $this->get_thumbs($video['name'], $video['thumbs_count']);
+ // Shorted description
+ $video['shorted_description'] = character_limiter(
+ $video['description'], 128);
+
return $video;
}
else
{
// TODO select data, description if details are needed
- $selected_columns = "id, name, title, duration, user_id, views,
- thumbs_count, default_thumb,
+ $selected_columns = "v.id, name, title, duration, user_id, views,
+ thumbs_count, default_thumb, u.username,
(views + likes - dislikes) AS score,
$relevance";
$order = "ORDER BY relevance DESC, score DESC";
$category_cond = "";
$str_query = "SELECT $selected_columns
- FROM `videos`
- WHERE $category_cond ( $search_cond )
+ FROM `videos` v, `users` u
+ WHERE v.user_id = u.id AND $category_cond ( $search_cond )
$order
$limit";
// echo "<p>$str_query</p>";