projects
/
living-lab-site.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
bug fixes solved before pushing a new version to production
[living-lab-site.git]
/
application
/
models
/
videos_model.php
diff --git
a/application/models/videos_model.php
b/application/models/videos_model.php
index
2b0add6
..
711b967
100644
(file)
--- a/
application/models/videos_model.php
+++ b/
application/models/videos_model.php
@@
-189,6
+189,7
@@
class Videos_model extends CI_Model {
public function get_video($id, $name = NULL)
{
$this->load->helper('video');
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
$query = $this->db->query("SELECT v.*, u.username
FROM `videos` v, `users` u
@@
-240,6
+241,10
@@
class Videos_model extends CI_Model {
// Thumbnails
$video['thumbs'] = $this->get_thumbs($video['name'], $video['thumbs_count']);
// Thumbnails
$video['thumbs'] = $this->get_thumbs($video['name'], $video['thumbs_count']);
+ // Shorted description
+ $video['shorted_description'] = character_limiter(
+ $video['description'], 128);
+
return $video;
}
return $video;
}
@@
-515,8
+520,8
@@
class Videos_model extends CI_Model {
else
{
// TODO select data, description if details are needed
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";
(views + likes - dislikes) AS score,
$relevance";
$order = "ORDER BY relevance DESC, score DESC";
@@
-529,8
+534,8
@@
class Videos_model extends CI_Model {
$category_cond = "";
$str_query = "SELECT $selected_columns
$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>";
$order
$limit";
// echo "<p>$str_query</p>";