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

diff --git a/application/models/videos_model.php b/application/models/videos_model.php
index 02aef22..da7cdfe 100644
--- a/application/models/videos_model.php
+++ b/application/models/videos_model.php
@@ -129,7 +129,7 @@ class Videos_model extends CI_Model {
 	 * 
 	 * @param int $category_id
 	 * @param mixed $user	an user_id (as int) or an username (as string)
-	 * @return int	number of videos or NULL if an error occured
+	 * @return int	number of videos or FALSE if an error occured
 	 */
 	public function get_videos_count($category_id = NULL, $user = NULL)
 	{
@@ -157,7 +157,7 @@ class Videos_model extends CI_Model {
 			return $query->row()->count;
 		
 		// Error
-		return NULL;
+		return FALSE;
 	}
 	
 	/**
@@ -242,6 +242,79 @@ class Videos_model extends CI_Model {
 		return $video;
 	}
 	
+	/**
+	 * Retrieves comments for a video.
+	 * 
+	 * @param int $video_id
+	 * @param int $offset
+	 * @param int $count
+	 * @param string $ordering	control comments ording by these possibilities:
+	 * <ul>
+	 *   <li><strong>'hottest':</strong> newest most appreciated first. An
+	 *   appreciated comment is one which has a bigger
+	 *   score = likes - dislikes.</li>
+	 *   <li><strong>'newest':</strong> newest first.</li>
+	 * </ul>
+	 * @return array	an array with comments
+	 */
+	public function get_video_comments($video_id, $offset, $count,
+			$ordering = 'newest')
+	{
+		// Ordering
+		switch ($ordering)
+		{
+		case 'newest':
+			$order_statement = "ORDER BY time DESC";
+			break;
+		case 'hottest':
+			$order_statement = "ORDER BY time DESC, score DESC";
+			break;
+				
+		default:
+			$order_statement = "";
+		}
+		
+		$query = $this->db->query(
+			"SELECT c.*, u.username, (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");
+		
+		if ($query->num_rows() == 0)
+			return array();
+		
+		$comments = $query->result_array();
+		
+		return $comments;
+	}
+	
+	public function get_video_comments_count($video_id)
+	{
+		$query = $this->db->query(
+					"SELECT COUNT(*) count
+						FROM `videos_comments`
+						WHERE video_id = $video_id");
+				
+		if ($query->num_rows() == 0)
+			return FALSE;
+		
+		return $query->row()->count;
+	}
+	
+	/**
+	 * Insert in DB a comment for a video.
+	 * 
+	 * @param int $video_id
+	 * @param int $user_id
+	 * @param string $content
+	 */
+	public function comment_video($video_id, $user_id, $content)
+	{
+		return $query = $this->db->query(
+			"INSERT INTO `videos_comments` (video_id, user_id, content, time)
+			VALUES ($video_id, $user_id, '$content', UTC_TIMESTAMP())");
+	}
+	
 	/**
 	 * Increments views count for a video.
 	 *