The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
I have a problems with related videos under the player, because a lot of embeeded videos are old like 3-5 years and they are not working anymore. How to change, that related videos will be the "newest" related videos? Like only few months old ...
tnx
Offline
what version of the script are you running?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
You have to edit modules/video/components/view.php and replace the get_related_simple function as following:
private function get_related_simple($video_id, $title)
{
$title = $this->db->escape($title);
$sql_count = "SELECT COUNT(*) AS total_related
FROM #__video AS v WHERE v.status = 1";
return array(
'total' => $this->db->get_field($sql_count, 'total_related'),
'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 v.status = 1
AND v.video_id != ".$video_id."
ORDER BY v.add_time DESC LIMIT ".VCfg::get('video.related_per_page')
);
}Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1