Adult Script Pro Community Forums

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.

#1 2014-02-06 04:47:15

hummy
Member
Registered: 2013-10-24
Posts: 27
Website

Video tags at bottom of each video?

Hola, how can i do for show video tags instead of rating bar at the botom of each video on FrontPage?

Offline

#2 2014-02-06 06:53:13

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Video tags at bottom of each video?

You need to edit a lot of files to be able to do this. Edit modules/frontpage/frontpage.php and replace:

u.username

with:
u.username, GROUP_CONCAT(t.name) AS tags
and for recent replace:

LEFT JOIN #__user AS u ON (u.user_id = v.user_id AND u.status = '1')
WHERE v.status = 1

with:

LEFT JOIN #__user AS u ON (u.user_id = v.user_id AND u.status = '1')
LEFT JOIN #__video_tags AS t ON (t.video_id = v.video_id)
WHERE v.status = 1
GROUP BY v.video_id

and for featured replace:

LEFT JOIN #__user AS u ON (u.user_id = v.user_id AND u.status = '1')

with:

LEFT JOIN #__video_tags AS t ON (t.video_id = v.video_id)
GROUP BY v.video_id

Once done edit templates/your-template/frontpage.tpl.php and add the following code where you want it in the design to appear:

<?php $tags = explode(',', $video['tags']); foreach ($tags as $tag): echo '<a href="'.RELATIVE_URL.'/tag/'.e($tag).'/">'.e($tag).'</a>'; endforeach; ?>

Please make sure to add css changes.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2014-02-06 11:24:45

hummy
Member
Registered: 2013-10-24
Posts: 27
Website

Re: Video tags at bottom of each video?

It Works perfect,

Thanks Adrian

Offline

#4 2014-06-14 13:46:23

hummy
Member
Registered: 2013-10-24
Posts: 27
Website

Re: Video tags at bottom of each video?

Tag with one Word work perfet but with more words get a White space in url between words. How can I fix this? Thanks

Offline

#5 2014-06-14 19:00:57

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Video tags at bottom of each video?

<?php $tags = explode(',', $video['tags']); foreach ($tags as $tag): $tag = str_replace(' ', '-', $tag); echo '<a href="'.RELATIVE_URL.'/tag/'.e($tag).'/">'.e($tag).'</a>'; endforeach; ?>

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#6 2014-06-15 00:50:32

hummy
Member
Registered: 2013-10-24
Posts: 27
Website

Re: Video tags at bottom of each video?

Perfect thanks

Offline

Board footer

Powered by FluxBB