[ADDED IN 1.0.2] Link comments to video

DuttyRock · 2012-09-07 15:30:30

I see these comments but it would be awesome to find out which video they commenting about. So it would be nice to click the comment and it bring you to the video that was commented on.

symtab · 2012-09-07 15:54:52

Hmmm...in the admin panel?

DuttyRock · 2012-09-07 17:28:03

yeah. when i read a comment i have no idea what video they talking about.

Nuevolab · 2012-09-07 21:20:17

Need nice pro solution? Here you have.

Edir file /admin/modules/video/components/comments.php"
Find line:

"SELECT c.*, u.username

Change it to:

"SELECT c.*, u.username, v.title, v.slug

Find line:

LEFT JOIN #__user AS u ON (u.user_id = c.user_id)

Below insert new line:

LEFT JOIN #__video AS v ON (v.video_id = c.video_id)

Save changes to file.

Edit file /admin/templates/default/video_comments.tpl.php
Find line:

<td><?php echo long2ip($comment['ip']); ?></td>

Below insert new line:

<td width="15%" style="padding: 2px;"><?php echo '<a href="'.BASE_URL.'/'.$comment['video_id'].'/'.$comment['slug'].'">'. e(VText::truncate_chars($comment['title'], 16)).'</a>'; ?></td>

In next line change: width="50%"
To: width="35%"

Save changes to file.

Now you will have a link to video with shortened title of video (opens in new window)
Do changes carefully. Best backup 2 edited files first!

Last edited by Nuevolab (2012-09-10 14:19:19)

DuttyRock · 2012-09-08 18:31:50

Works perfect, thanks.

symtab · 2012-09-10 09:06:03

The url is BASE_URL.'/'.$comment['video_id'].'/' and you also need SLUG here. Also we have VText::truncate_chars($text, $limit=100, $replace=' ...', $preserve_words=FALSE) already included. You dont need to include any files, just use the static method and it will work.

Nuevolab · 2012-09-10 14:12:22

symtab wrote:

The url is BASE_URL.'/'.$comment['video_id'].'/' and you also need SLUG here.

I know it, anyway it's only for admin and finally your code redirects to correct url if only 'video_id' is correct :). But this is no problem to add slug to URL of course.

symtab wrote:

Also we have VText::truncate_chars($text, $limit=100, $replace=' ...', $preserve_words=FALSE) already included. You dont need to include any files, just use the static method and it will work.

I knew there must be truncate function somewhere, but was too lazy to look for it.

Updated code, I had to change truncate number parameter as your function works different (do not count dots)

Last edited by Nuevolab (2012-09-10 14:21:05)

symtab · 2012-09-11 13:01:19

Oki. Thanks for contributing.

videocasalinghi · 2012-09-11 13:42:59

Hi adrian

this option will be included in the next version?

symtab · 2012-09-14 04:34:46

Yes.

symtab · 2012-09-14 04:48:40

Added in 1.0.2

videocasalinghi · 2012-09-15 10:41:40

ok good :-)

rbmoss · 2012-10-29 07:36:26

that will be good as comments should be normally linked to videos

satty · 2012-10-29 12:11:53

ya thats an obvious feature.

Adult Script Pro Community Forums

#1 2012-09-07 15:30:30

[ADDED IN 1.0.2] Link comments to video

#2 2012-09-07 15:54:52

Re: [ADDED IN 1.0.2] Link comments to video

#3 2012-09-07 17:28:03

Re: [ADDED IN 1.0.2] Link comments to video

#4 2012-09-07 21:20:17

Re: [ADDED IN 1.0.2] Link comments to video

#5 2012-09-08 18:31:50

Re: [ADDED IN 1.0.2] Link comments to video

#6 2012-09-10 09:06:03

Re: [ADDED IN 1.0.2] Link comments to video

#7 2012-09-10 14:12:22

Re: [ADDED IN 1.0.2] Link comments to video

#8 2012-09-11 13:01:19

Re: [ADDED IN 1.0.2] Link comments to video

#9 2012-09-11 13:42:59

Re: [ADDED IN 1.0.2] Link comments to video

#10 2012-09-14 04:34:46

Re: [ADDED IN 1.0.2] Link comments to video

#11 2012-09-14 04:48:40

Re: [ADDED IN 1.0.2] Link comments to video

#12 2012-09-15 10:41:40

Re: [ADDED IN 1.0.2] Link comments to video

#13 2012-10-29 07:36:26

Re: [ADDED IN 1.0.2] Link comments to video

#14 2012-10-29 12:11:53

Re: [ADDED IN 1.0.2] Link comments to video

Board footer