X-Git-Url: http://p2p-next.cs.pub.ro/gitweb/?a=blobdiff_plain;f=application%2Fmodels%2Fvideos_model.php;h=711b967a0930f36f0a01b4c9d00a0a28891d7bd1;hb=8889adf32898adeff7a85cc040f5f409d3bce36c;hp=da7cdfe6b174ef1020fe98ad06f7ba369522b13e;hpb=faf92fa039c2be353c94d0d0e8e488e56eaa5058;p=living-lab-site.git

diff --git a/application/models/videos_model.php b/application/models/videos_model.php
index da7cdfe..711b967 100644
--- 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');
+		$this->load->helper('text');
 		
 		$query = $this->db->query("SELECT v.*, u.username 
 								FROM `videos` v, `users` u
@@ -225,6 +226,7 @@ class Videos_model extends CI_Model {
 		foreach ($video['assets'] as & $asset)
 		{
 			$def = substr($asset['res'], strpos($asset['res'], 'x') + 1) . 'p';
+			$asset['def'] = $def;
  			$asset['src'] = site_url('data/torrents/'. $video['name'] . '_'
  				. $def . '.'. $asset['ext']
  				. '.'. $this->config->item('default_torrent_ext'));
@@ -239,6 +241,10 @@ class Videos_model extends CI_Model {
 		// Thumbnails
 		$video['thumbs'] = $this->get_thumbs($video['name'], $video['thumbs_count']);
 		
+		// Shorted description
+		$video['shorted_description'] = character_limiter(
+				$video['description'], 128);
+		
 		return $video;
 	}
 	
@@ -260,6 +266,9 @@ class Videos_model extends CI_Model {
 	public function get_video_comments($video_id, $offset, $count,
 			$ordering = 'newest')
 	{
+		$this->load->helper('date');
+		$cond_hottest = '';
+		
 		// Ordering
 		switch ($ordering)
 		{
@@ -267,7 +276,8 @@ class Videos_model extends CI_Model {
 			$order_statement = "ORDER BY time DESC";
 			break;
 		case 'hottest':
-			$order_statement = "ORDER BY time DESC, score DESC";
+			$order_statement = "ORDER BY score DESC, time DESC";
+			$cond_hottest = "AND c.likes + c.dislikes > 0";
 			break;
 				
 		default:
@@ -275,16 +285,23 @@ class Videos_model extends CI_Model {
 		}
 		
 		$query = $this->db->query(
-			"SELECT c.*, u.username, (c.likes + c.dislikes) AS score
+			"SELECT c.*, u.username, u.time_zone, (c.likes + c.dislikes) AS score
 				FROM `videos_comments` c, `users` u
-				WHERE c.user_id = u.id AND video_id = $video_id
-				$order_statement");
+				WHERE c.user_id = u.id AND video_id = $video_id $cond_hottest
+				$order_statement
+				LIMIT $offset, $count");
 		
 		if ($query->num_rows() == 0)
 			return array();
 		
 		$comments = $query->result_array();
 		
+		foreach ($comments as & $comment)
+		{
+			$comment['local_time'] = human_gmt_to_human_local($comment['time'],
+				$comment['time_zone']);
+		}
+		
 		return $comments;
 	}
 	
@@ -310,6 +327,11 @@ class Videos_model extends CI_Model {
 	 */
 	public function comment_video($video_id, $user_id, $content)
 	{
+		// Prepping content.
+		$content = substr($content, 0, 512);
+		$content = htmlspecialchars($content);
+		$content = nl2br($content);
+		
 		return $query = $this->db->query(
 			"INSERT INTO `videos_comments` (video_id, user_id, content, time)
 			VALUES ($video_id, $user_id, '$content', UTC_TIMESTAMP())");
@@ -373,6 +395,51 @@ class Videos_model extends CI_Model {
 		return FALSE;
 	}
 	
+	public function vote_comment($comment_id, $user_id, $like = TRUE)
+	{
+		if ($like)
+		{
+			$col = 'likes';
+			$action = 'like';
+		}
+		else
+		{
+			$col = 'dislikes';
+			$action = 'dislike';
+		}
+	
+		$query = $this->db->query("SELECT * FROM `users_actions`
+				WHERE user_id = $user_id
+					AND target_id = $comment_id
+					AND target_type = 'vcomment'
+					AND action = '$action'
+					AND date = CURDATE()");
+		// User already voted today
+		if ($query->num_rows() > 0)
+			return -1;
+	
+		$this->db->query("UPDATE `videos_comments`
+				SET $col = $col + 1
+				WHERE id = $comment_id");
+	
+		// Mark this action so that the user cannot repeat it today.
+		$this->db->query("INSERT INTO `users_actions`
+					(user_id, action, target_type, target_id, date)
+				VALUES ( $user_id, '$action', 'vcomment', $comment_id, CURDATE() )");
+	
+		$query = $this->db->query("SELECT $col FROM `videos_comments`
+				WHERE id = $comment_id");
+	
+		if ($query->num_rows() === 1)
+		{
+			$row = $query->row_array();
+			return $row[ $col ];
+		}
+	
+		// Error
+		return FALSE;
+	}
+	
 	public function get_thumbs($name, $count)
 	{
 		$thumbs = array();
@@ -453,8 +520,8 @@ class Videos_model extends CI_Model {
 		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";
@@ -467,8 +534,8 @@ class Videos_model extends CI_Model {
 			$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>";