Changeset 13775 for trunk/modules/boonex/videos/classes/BxVideosSearch.php

Timestamp:

03/10/10 11:19:50 (2 years ago)

Author:

Leonid Sokushev

Message:

ticket #1900 + mem levels checking for sounds and videos blocks at profile page

File:

• trunk/modules/boonex/videos/classes/BxVideosSearch.php (modified) (4 diffs)

trunk/modules/boonex/videos/classes/BxVideosSearch.php

@@ -112 +112 @@
     function serviceGetVideoArray ($iPicId, $sImgType = 'browse') {
         $iPicId = (int)$iPicId;
-        $sqlQuery = "SELECT `ID` as `id`,
-                             `Title` as `title`,
-                             `Description` as `description`,
-                             `Uri` as `uri`,
-                             `Owner` as `owner`,
-                             `Date` as `date`,
-                             `Video`,
-                             `Source`,
-                             `id_album` as `album_id`
-                      FROM `RayVideoFiles`
-                      LEFT JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object` = `RayVideoFiles`.`ID`
-                      WHERE `ID`='$iPicId' AND `Status` != 'disapproved'";
+        $sqlQuery = "SELECT a.`ID` as `id`,
+                            a.`Title` as `title`,
+                            a.`Description` as `description`,
+                            a.`Uri` as `uri`,
+                            a.`Owner` as `owner`,
+                            a.`Date` as `date`,
+                            b.`id_album` as `album_id`
+                        FROM `RayVideoFiles` as a
+                        LEFT JOIN `sys_albums_objects` as b ON b.`id_object` = a.`ID`
+                        LEFT JOIN `sys_albums` as c ON c.`ID`=b.`id_album`
+                        WHERE a.`ID`='$iPicId' AND a.`Status`<>'approved' AND c.`Type`='bx_videos'";
         $aImageInfo = db_arr($sqlQuery);
 
@@ -211 +210 @@
         }
         else {
-            $sVideoTxt = _t('_bx_videos_wall_video');
+            $sVideoTxt = _t('_bx_videos_wall_video');
             $aOut = array( 
                 'title' => $aOwner['username'] . ' ' . $sAddedNewTxt . ' ' . $sVideoTxt,
@@ -220 +219 @@
                     'cpt_video_url' => $aVideo['url'],
                     'cpt_video' => $sVideoTxt,
-                    'cnt_player' => $this->oTemplate->getFileConcept($aEvent['object_id'], array('ext'=>$aVideo['video'], 'source'=>$aVideo['source'])),
+                    'cnt_player' => $this->_getSharedThumb($aEvent['object_id'], $aVideo['url']),
                     'post_id' => $aEvent['id']
                 ))
@@ -229 +228 @@
     
     function serviceProfileVideoBlock($iProfileId) {
-        $aVars = array (
+        if(!$this->checkMemAction($iProfileId, 'view'))
+            return '';
+        $aVars = array (
             'title' => false,
             'prefix' => 'id' . time() . '_' . rand(1, 999999),