X-Git-Url: http://p2p-next.cs.pub.ro/gitweb/?a=blobdiff_plain;f=application%2Fmodels%2Fvideos_model.php;h=1ba9e8f67bbd516f6ef4d5134d882cf5c5eebd36;hb=954fc0210d9151cb86ca4dad6a955f59ba135915;hp=5c975914ab3d5a1ccfd8be934deb9138325efaa8;hpb=9e326b335014eac0c6c6476402654b19c57a396f;p=living-lab-site.git

diff --git a/application/models/videos_model.php b/application/models/videos_model.php
index 5c97591..1ba9e8f 100644
--- a/application/models/videos_model.php
+++ b/application/models/videos_model.php
@@ -7,7 +7,7 @@
  * @author		Călin-Andrei Burloiu
  */
 class Videos_model extends CI_Model {
-	private $db = NULL;
+	public $db = NULL;
 	
 	public function __construct()
 	{
@@ -29,11 +29,13 @@ class Videos_model extends CI_Model {
 	 * @param		int $offset
 	 * @param		int $count
 	 * @return		array	a list of videos, each one being an assoc array with:
-	 *   * id, name, title, duration, thumbs_count, default_thumb, views => from DB
-	 *   * shorted_title => ellipsized title
-	 *   * video_url => P2P-Tube video URl
-	 *   * TODO: user_id, user_name
-	 *   * thumbs => thumbnail images' URLs
+	 * <ul>
+	 *   <li>id, name, title, duration, thumbs_count, default_thumb, views => from DB</li>
+	 *   <li>shorted_title => ellipsized title</li>
+	 *   <li>video_url => P2P-Tube video URl</li>
+	 *   <li>TODO: user_id, user_name</li>
+	 *   <li>thumbs => thumbnail images' URLs</li>
+	 * </ul>
 	 */
 	public function get_videos_summary($category_id, $offset, $count)
 	{
@@ -101,20 +103,24 @@ class Videos_model extends CI_Model {
 	 * table. NULL means there is no name provided.
 	 * @return		array	an associative list with information about a video
 	 * with the following keys:
-	 *   * all columns form DB with some exceptions that are overwritten or new
-	 *   * formats content is moved in assets
-	 *   * assets => list of associative lists where each one represents a
+	 * <ul>
+	 *   <li>all columns form DB with some exceptions that are overwritten or new</li>
+	 *   <li>content is moved in assets</li>
+	 *   <li>assets => list of associative lists where each one represents a</li>
 	 * video asset having keys: "src", "res", "par" and "ext". Value of key
 	 * "src" is the video torrent formated as
-	 * {name}_{format}.{video_ext}.{default_torrent_ext}
-	 *   * user_name => TODO: user name from `users` table
-	 *   * category_title => a human-friendly category name
-	 *   * tags => associative list of "tag => score"
-	 *   * date => date and time when the video was created
-	 *   * thumbs => thumbnail images' URLs
+	 * {name}_{format}.{video_ext}.{default_torrent_ext}</li>
+	 *   <li>user_name => TODO: user name from `users` table</li>
+	 *   <li>category_title => a human-friendly category name</li>
+	 *   <li>tags => associative list of "tag => score"</li>
+	 *   <li>date => date and time when the video was created</li>
+	 *   <li>thumbs => thumbnail images' URLs</li>
+	 * </ul>
 	 */
 	public function get_video($id, $name = NULL)
 	{
+		$this->load->helper('video');
+		
 		$query = $this->db->query('SELECT * 
 								FROM `videos` 
 								WHERE id = ?', $id);
@@ -139,6 +145,12 @@ class Videos_model extends CI_Model {
 		asort($video['tags']);
 		$video['tags'] = array_reverse($video['tags'], TRUE);
 		
+		// Sort assets by their megapixels number.
+		function access_function($a) { return $a['res']; }
+		function assets_cmp($a, $b) 
+			{ return megapixels_cmp($a, $b, "access_function"); }
+		usort($video['assets'], "assets_cmp");
+		
 		// Torrents
 		$video['url'] = array();
 		foreach ($video['assets'] as & $asset)
@@ -164,6 +176,21 @@ class Videos_model extends CI_Model {
 		return $video;
 	}
 	
+	/**
+	 * Increment a video parameter from DB: `views`, `likes` or `dislikes`.
+	 * 
+	 * @param int $id	DB video id
+	 * @param string $param	DB parameter column name.
+	 * @return void
+	 */
+	public function inc_video_var($id, $var)
+	{
+		// TODO error report if query returns FALSE
+		$this->db->query('UPDATE `videos` '
+						. 'SET `'. $var. '`=`'. $var. '`+1 '
+						. 'WHERE id='. $id); 
+	}
+	
 	public function get_thumbs($name, $count)
 	{
 		$thumbs = array();