Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 threadfield wont show
duhol Offline
Junior Member
**
Posts: 34
Joined: Mar 2011
Post: #5
RE: threadfield wont show
(04-14-2011 01:41 AM)RateU Wrote:  So, do you want to display YouTube Video thumbnail using the video id in your index page?

yes Smile

i can subiect, tid, message, attach, and anything, but still can't put aby xthread threadfield.

i change code:

PHP Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
// Latest trailers


$xxx_trailers = 10;


$pids = '';
$tids = '';
$comma = '';
$query = $db->query("
	SELECT p.pid, p.message, p.tid
	FROM ".TABLE_PREFIX."posts p
	LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
	WHERE t.fid IN (".$xxx_trailers.") AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid
	ORDER BY t.dateline DESC 
	LIMIT 0, 12"
);
while($getid = $db->fetch_array($query))
{
	$pids .= ",'{$getid['pid']}'";
	$tids .= ",'{$getid['tid']}'";
	$posts[$getid['tid']] = $getid;
}
$pids = "pid IN(0{$pids})";



	$altbg = alt_trow();
	$threadlist = '';
	$query = $db->query("
		SELECT t.*, u.username
		FROM ".TABLE_PREFIX."threads t
		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
		LEFT JOIN ".TABLE_PREFIX."threadfields_data td ON (td.tid=t.tid)
		WHERE t.fid IN (".$xxx_trailers.") AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
		ORDER BY t.dateline DESC 
		LIMIT 0, 12"
	);

	while($thread = $db->fetch_array($query))
	{

	$thread['message'] = $posts[$thread['tid']]['message'];
	$thread['pid'] = $posts[$thread['tid']]['pid'];




		$thread['threadlink'] = get_thread_link($thread['tid']);

		$thread['forumlink'] = get_forum_link($thread['fid']);



if(my_strlen($thread['subject']) > 25)
		{
			$thread['subject'] = my_substr($thread['subject'], 0, 25) . "...";
		}


		$thread['subject'] = htmlspecialchars_uni($parser->parse_badwords($thread['subject']));

		$forumcache = $cache->read("forums");

		$thread['forumlink'] = "<a href=\"".get_forum_link($thread['fid'])."\">".$forumcache[$thread['fid']]['name']."</a>";


	$message = $parser->parse_message($thread['message'], $parser_options);

		eval("\$xxx_trailers_threadlist .= \"".$templates->get("xxx_index_trailers_latestthreads_thread")."\";");
		$altbg = alt_trow();
	}
	if($xxx_trailers_threadlist)
	{ 
		// Show the table only if there are threads
		eval("\$xxx_trailers_latestthreads = \"".$templates->get("xxx_index_trailers_latestthreads")."\";");

		eval("\$indexbox = \"".$templates->get("xxx_index_box")."\";");

	}

(This post was last modified: 04-14-2011 03:09 AM by duhol.)
04-14-2011 03:06 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
threadfield wont show - duhol - 04-13-2011, 09:17 PM
RE: threadfield wont show - ZiNgA BuRgA - 04-13-2011, 09:38 PM
RE: threadfield wont show - duhol - 04-13-2011, 09:57 PM
RE: threadfield wont show - RateU - 04-14-2011, 01:41 AM
RE: threadfield wont show - duhol - 04-14-2011 03:06 AM
RE: threadfield wont show - RateU - 04-14-2011, 03:26 AM
RE: threadfield wont show - duhol - 04-14-2011, 05:43 AM
RE: threadfield wont show - RateU - 04-15-2011, 07:21 AM

 Standard Tools
Forum Jump: