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
You only want to change the language string, or also the videos?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Admin -> Extend -> Language Manager -> en-US -> frontpage and edit modules/frontpage/frontpage.php and replace:
$sql = "SELECT video_id, title, slug, rating, rated_by, duration, thumb, thumbs,
total_views, ext, add_time, premium
FROM #__video
WHERE status = 1
ORDER BY view_time DESC
LIMIT ".$fcfg['watched_per_page'];
with:
$sql = "SELECT video_id, title, slug, rating, rated_by, duration, thumb, thumbs,
total_views, ext, add_time, premium
FROM #__video_featured AS f
INNER JOIN #__video AS v ON (v.video_id = f.video_id AND v.status = 1)
ORDER BY f.feature_time DESC
LIMIT ".$fcfg['watched_per_page'];
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
get this error
Query: SELECT video_id, title, slug, rating, rated_by, duration, thumb, thumbs, total_views, ext, add_time, premium FROM video_featured AS f INNER JOIN video AS v ON (v.video_id = f.video_id AND v.status = 1) ORDER BY f.feature_time DESC LIMIT 4
Error Message: Column 'video_id' in field list is ambiguous
Error Number: 1052
Offline
SELECT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb, v.thumbs, v.total_views, v.ext, v.add_time, v.premium FROM video_featured AS f INNER JOIN video AS v ON (v.video_id = f.video_id AND v.status = 1) ORDER BY f.feature_time DESC LIMIT 4
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1