Changeset 976259

Timestamp:

09/01/2014 05:42:26 AM (12 years ago)

Author:

hdflvplayer

Message:

Fixed video not displaying in video more page - Upgrade (2.7) issue

Location:

contus-video-gallery

Files:

• tags/2.7/front/views/videohome.php (modified) (2 diffs)
• tags/2.7/front/views/videomore.php (modified) (1 diff)
• trunk/front/views/videohome.php (modified) (2 diffs)
• trunk/front/views/videomore.php (modified) (1 diff)

contus-video-gallery/tags/2.7/front/views/videohome.php

@@ -387 +387 @@
             foreach ( $TypeOFvideos as $catList ) {
                 $sql = 'SELECT s.guid,w.* FROM ' . $wpdb->prefix . 'hdflvvideoshare as w
-                    INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play as m ON m.media_id = w.vid
-                    INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid
-                    INNER JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
+                    LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play as m ON m.media_id = w.vid
+                    LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid
+                    LEFT JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
                     WHERE w.publish=1 and p.is_publish=1 and m.playlist_id=' . intval( $catList->pid ) . ' GROUP BY w.vid LIMIT ' . $dataLimit;
                 $playLists     = $wpdb->get_results( $sql );
@@ -395 +395 @@
                                 //Get count video assign this category. 
                 $category_video = $wpdb->get_results('SELECT * FROM ' . $wpdb->prefix . 'hdflvvideoshare_med2play as m 
-                    INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid WHERE m.playlist_id='.intval($catList->pid).' AND p.is_publish=1');
+                    LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid WHERE m.playlist_id='.intval($catList->pid).' AND p.is_publish=1');
                 $video_count = count($category_video);
                                 // end of  get count

contus-video-gallery/tags/2.7/front/views/videomore.php

@@ -371 +371 @@
                 // Fetch videos for every category
                 $sql = 'SELECT s.guid,w.* FROM ' . $wpdb->prefix . 'hdflvvideoshare AS w
-                        INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play AS m ON m.media_id = w.vid
-                        INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist AS p on m.playlist_id = p.pid
-                        INNER JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
+                        LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play AS m ON m.media_id = w.vid
+                        LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist AS p on m.playlist_id = p.pid
+                        LEFT JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
                         WHERE w.publish=1 AND p.is_publish=1 AND m.playlist_id=' . intval ( $catList->pid ) . ' GROUP BY w.vid';
                 $playLists = $wpdb->get_results ( $sql );

contus-video-gallery/trunk/front/views/videohome.php

@@ -387 +387 @@
             foreach ( $TypeOFvideos as $catList ) {
                 $sql = 'SELECT s.guid,w.* FROM ' . $wpdb->prefix . 'hdflvvideoshare as w
-                    INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play as m ON m.media_id = w.vid
-                    INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid
-                    INNER JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
+                    LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play as m ON m.media_id = w.vid
+                    LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid
+                    LEFT JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
                     WHERE w.publish=1 and p.is_publish=1 and m.playlist_id=' . intval( $catList->pid ) . ' GROUP BY w.vid LIMIT ' . $dataLimit;
                 $playLists     = $wpdb->get_results( $sql );
@@ -395 +395 @@
                                 //Get count video assign this category. 
                 $category_video = $wpdb->get_results('SELECT * FROM ' . $wpdb->prefix . 'hdflvvideoshare_med2play as m 
-                    INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid WHERE m.playlist_id='.intval($catList->pid).' AND p.is_publish=1');
+                    LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist as p on m.playlist_id = p.pid WHERE m.playlist_id='.intval($catList->pid).' AND p.is_publish=1');
                 $video_count = count($category_video);
                                 // end of  get count

contus-video-gallery/trunk/front/views/videomore.php

@@ -371 +371 @@
                 // Fetch videos for every category
                 $sql = 'SELECT s.guid,w.* FROM ' . $wpdb->prefix . 'hdflvvideoshare AS w
-                        INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play AS m ON m.media_id = w.vid
-                        INNER JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist AS p on m.playlist_id = p.pid
-                        INNER JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
+                        LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_med2play AS m ON m.media_id = w.vid
+                        LEFT JOIN ' . $wpdb->prefix . 'hdflvvideoshare_playlist AS p on m.playlist_id = p.pid
+                        LEFT JOIN ' . $this->_wpdb->prefix . 'posts s ON s.ID=w.slug
                         WHERE w.publish=1 AND p.is_publish=1 AND m.playlist_id=' . intval ( $catList->pid ) . ' GROUP BY w.vid';
                 $playLists = $wpdb->get_results ( $sql );