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

diff --git a/application/models/videos_model.php b/application/models/videos_model.php
index 922efd4..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()
 	{
@@ -119,6 +119,8 @@ class Videos_model extends CI_Model {
 	 */
 	public function get_video($id, $name = NULL)
 	{
+		$this->load->helper('video');
+		
 		$query = $this->db->query('SELECT * 
 								FROM `videos` 
 								WHERE id = ?', $id);
@@ -143,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)
@@ -168,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();