thumbails in similar threads

[duhol]

Hey, is it difficult to make thumbails in similiar threads in xthreads gallery forum?
THX

[RateU]

Try this:

showthread.php

Find:

PHP Code:

if($mybb->settings['showsimilarthreads'] != 0) {

---

Add this code after the code above:

PHP Code:

if($thread['fid'] == X){ $addfields = ', atf.updatetime, atf.md5hash, atf.uploadtime, atf.aid, atf.attachname, atf.filename, atf.thumbs'; $addfieldsjoin = ' LEFT JOIN '.TABLE_PREFIX.'xtattachments atf ON (atf.tid=t.tid)'; }

---

Replace the X with your images gallery forum id.

Find:

PHP Code:

1 2 3 4 5 6 7 8 9

$query = $db->query(" SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid) WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}' ORDER BY t.lastpost DESC LIMIT 0, {$mybb->settings['similarlimit']} ");

---

Replace it with:

PHP Code:

1 2 3 4 5 6 7 8 9

$query = $db->query(" SELECT t.*, t.username AS threadusername, p.displaystyle AS threadprefix, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance{$addfields} FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix) LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid){$addfieldsjoin} WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}' ORDER BY t.lastpost DESC LIMIT 0, {$mybb->settings['similarlimit']} ");

---

Find:

PHP Code:

eval("\$similarthreadbits .= \"".$templates->get("showthread_similarthreads_bit")."\";");

---

Add this code before the code above:

PHP Code:

if($thread['fid'] == X){ $xtimgsimilar_thread = '<img src="'.xthreads_get_xta_url($similar_thread).'/thumb160x120" alt="'.$similar_thread['subject'].'" />'; }

---

Replace X with your Images Gallery forum id, and 160x120 with the thumbnail size.

For displaying the thumbnail in your similar thread box, put this code in your showthread_similarthreads_bit template:

Code:

{$xtimgsimilar_thread}

---

[duhol]

What can I say. Works!! Thanks!!

[Jonatthu]

and if we want to show similar threads in video gallery of Youtube?

[Jonatthu]

if($thread['fid'] == 4){
     $xtimgsimilar_thread = 'http://i3.ytimg.com/vi/'.$GLOBALS['threadfields']['vidid'].'/mqdefault.jpg';
}

this is all I´ve could avanced but it not works because the thumbs is about the firts posts and not of similar threads, How can I fix this?

[ZiNgA BuRgA]

Instead of RateU's first replacement above, use this one instead:

PHP Code:

if($thread['fid'] == X){ $addfields = ', tfd.ytvgalid'; $addfieldsjoin = ' LEFT JOIN '.TABLE_PREFIX.'threadfields_data tfd ON (tfd.tid=t.tid)'; }

---

Then for the last one:

PHP Code:

if($thread['fid'] == X && $similar_thread['ytvgalid']){ xthreads_sanitize_disp($similar_thread['ytvgalid'], $threadfield_cache['ytvgalid']); $xtimgsimilar_thread = '<img src="http://img.youtube.com/vi/'.$similar_thread['ytvgalid'].'/default.jpg" alt="'.$similar_thread['subject'].'" />'; }

---

I'm too lazy to bother testing in my current state, so hope that helps.

[Jonatthu]

It was close thanks a lot but...

I did that and happened this.

if($thread['fid'] == 4){
     $xtimgsimilar_thread = 'http://img.youtube.com/vi/'.$similar_thread['vidid'].'/mqdefault.jpg';
}

URL= http://img.youtube.com/vi/http://www.you...http://img.youtube.com/vi/http://www.youtube.com/watch?v=uuZE_IRwLNI/mqd

Just the url is wrong I need only the ID of the video "uuZE_IRwLNI"

[ZiNgA BuRgA]

That's not how the Youtube gallery is set up.
Make sure you've set it up properly as described in RateU's thread.

[Jonatthu]

íts the same zinga vidid is just a key
i think its something like the text mask i dont know

[Jonatthu]

It is missing something, the text mask of the video (?) I don´t really know

if($thread['fid'] == 4){
$addfields = ', tfd.vidid';
$addfieldsjoin = ' LEFT JOIN '.TABLE_PREFIX.'threadfields_data tfd ON (tfd.tid=t.tid)';
}


if($thread['fid'] == 4){
     $xtimgsimilar_thread = 'http://img.youtube.com/vi/'.$similar_thread['vidid'].'/mqdefault.jpg';
}

URL= http://img.youtube.com/vi/ http://www.youtube.com /watch?v=EXZVCfmF_Zw/mqdefault.jpg


When I put {$threadfields['vidid']} the URL is fine just appear the ID of the video not the entire URL