X-Git-Url: http://p2p-next.cs.pub.ro/gitweb/?a=blobdiff_plain;f=application%2Fmodels%2Fvideos_model.php;h=2b0add64285893cfeb93895ed351dc4c54ab85c4;hb=497b76b61faee6e2e8d72ce6d9ed8eacd45107d2;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..2b0add6 100644
--- a/application/models/videos_model.php
+++ b/application/models/videos_model.php
@@ -225,6 +225,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'));
@@ -260,6 +261,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 +271,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 +280,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 +322,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 +390,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();