[NOT A BUG] Mobile related videos

ivatigoal · 2015-11-01 20:14:23

If I use the mobile version the related videos of any video are all the same. Also I don't see anymore the option at the mobile module to the related to choose either simple or complex

symtab · 2015-11-04 10:38:33

The mobile part of the script never had any sphinx option. Will add this in a future version.

ivatigoal · 2015-12-10 17:47:24

You have to add this option at some point because the related videos feature in the mobile site is really not efficient. For example if we open a video and then we see the list of the related videos and we choose one of them then the related videos of that will be most of the times the same like the related like the first one. That is why I thought at the beginning that the related is always the same.

symtab · 2015-12-11 06:32:11

I could replace related videos via tags with related videos via full text match.

ivatigoal · 2015-12-11 11:45:40

We can try that, can u please let me know if it is easy what part of the code to change?

symtab · 2015-12-11 14:06:36

Edit mobile/components/video_view.php and find:

$this->tpl->related         = $this->get_related_videos($video_id, $video['tags']);

replace with:

 $this->tpl->related         = $this->get_related_videos($video_id, $video['title'], $video['tags']);

find:

        if (!$videos = $this->cache->get($cache_id, 86400)) {
            $tags       = explode(',', $tags);
            $sql_add    = array();
            foreach ($tags as $tag) {
                $sql_add[] = "'".$this->db->escape($tag)."'";
            }
    
            $sql    = "SELECT DISTINCT v.video_id, v.title, v.slug, v.description, v.thumb,
                                       v.rating, v.total_views, v.duration
                       FROM #__video_tags AS t
                       INNER JOIN #__video AS v ON (v.video_id = t.video_id AND v.status = 1 AND v.mobile = '1' AND v.video_id != ".$video_id.")
                       WHERE t.name IN (".implode(',', $sql_add).")
                       ORDER BY v.add_time DESC
                       LIMIT ".$this->mcfg['related_per_page'];
            $this->db->query($sql);
            if ($this->db->affected_rows()) {
                $videos = $this->db->fetch_rows();
                $this->cache->store($cache_id, $videos, 86400);
            } else {
                $videos = array();
            }
        }

replace with:

        if (!$videos = $this->cache->get($cache_id, 86400)) {
            $sql    = "SELECT v.video_id, v.title, v.slug, v.likes, v.rating, v.rated_by, v.duration, v.thumb,
                               v.thumbs, v.total_views, v.add_time, v.ext, v.hd, v.premium, v.type, u.username,
                                 MATCH (v.title) AGAINST ('".$title."') AS relevance
                        FROM #__video AS v
                        LEFT JOIN #__user AS u ON (u.user_id = v.user_id)
                        WHERE MATCH (v.title) AGAINST ('".$title."')
                        AND v.status = 1
                        AND v.video_id != ".$video_id."
                        AND v.mobile = '1'
                        ORDER BY relevance DESC LIMIT ".$this->mcfg['related_per_page'];
            $this->db->query($sql);
            if ($this->db->affected_rows()) {
                $videos = $this->db->fetch_rows();
                $this->cache->store($cache_id, $videos, 86400);
            } else {
                $videos = array();
            }
        }

ivatigoal · 2015-12-12 08:26:57

I get no related videos with this code

symtab · 2015-12-13 08:02:56

Oki. Will be updated in 2.0.13.

Adult Script Pro Community Forums

#1 2015-11-01 20:14:23

[NOT A BUG] Mobile related videos

#2 2015-11-04 10:38:33

Re: [NOT A BUG] Mobile related videos

#3 2015-12-10 17:47:24

Re: [NOT A BUG] Mobile related videos

#4 2015-12-11 06:32:11

Re: [NOT A BUG] Mobile related videos

#5 2015-12-11 11:45:40

Re: [NOT A BUG] Mobile related videos

#6 2015-12-11 14:06:36

Re: [NOT A BUG] Mobile related videos

#7 2015-12-12 08:26:57

Re: [NOT A BUG] Mobile related videos

#8 2015-12-13 08:02:56

Re: [NOT A BUG] Mobile related videos

Board footer