MyBB Hacks / MyBB Plugins / XThreads / threadfield wont show

 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 threadfield wont show
duhol Offline
Junior Member
**
Posts: 34
Joined: Mar 2011
Post: #1
threadfield wont show
Hi
I put code to index.php. Now how to put threadfield into tamplates (forum is based on XThreads Youtube Gallery)?

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
 
// Latest trailers


$xxx_trailers = 10;

	$altbg = alt_trow();
	
	$threadlist = '';
	$query = $db->query("
		SELECT t.*, u.username
		FROM ".TABLE_PREFIX."threads t

		LEFT JOIN ".TABLE_PREFIX."threadfields_data td ON  (td.tid=t.tid)



		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
		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['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>";

		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")."\";");

	}


My forum: http://www.filmtoks.pl
Left, down column named "zwiastuny". I want thumbail for each movie. How to make it?

THX

(This post was last modified: 04-13-2011 09:20 PM by duhol.)
04-13-2011 09:17 PM
Find all posts by this user Quote this message in a reply
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #2
RE: threadfield wont show
Use xthreads_sanitize_disp function to parse threadfield data into what can be displayed.  Of course, you'll need to actually pull the threadfield data from the query as well.

If you're using XThreads attachments for thumbnails, you'll need to also pull attachment info, and then parse it.
If examples help, maybe take a look at these:
http://mybbhacks.zingaburga.com/showthread.php?tid=474
http://mybbhacks.zingaburga.com/showthread.php?tid=486
Processing thumbnails:
http://mybbhacks.zingaburga.com/showthread.php?tid=738
http://mybbhacks.zingaburga.com/showthread.php?tid=327

Hope that helps.
My Blog
04-13-2011 09:38 PM
Find all posts by this user Quote this message in a reply
duhol Offline
Junior Member
**
Posts: 34
Joined: Mar 2011
Post: #3
RE: threadfield wont show
it isn't thumbail. it's xthreads youtube gallery. i only need field with "uIVyZkFbqJo" (youtube movie key).

how to take it from database? Erf
04-13-2011 09:57 PM
Find all posts by this user Quote this message in a reply
RateU Offline
Administrator
*******
Posts: 2,350
Joined: Mar 2010
Post: #4
RE: threadfield wont show
So, do you want to display YouTube Video thumbnail using the video id in your index page?
04-14-2011 01:41 AM
Find all posts by this user Quote this message in a reply
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
RateU Offline
Administrator
*******
Posts: 2,350
Joined: Mar 2010
Post: #6
RE: threadfield wont show
(04-14-2011 03:06 AM)duhol Wrote:  but still can't put aby xthread threadfield.

Because you need to do this:
(04-13-2011 09:38 PM)ZiNgA BuRgA Wrote:  Of course, you'll need to actually pull the threadfield data from the query as well.

I have a very simple Most Viewed Video plugin for XThreads YouTube Video Gallery. Maybe you can modify it as your needs.
I use ytvgalid key for the YouTube video id/URL, stored in threadfields_data table. You can see it in the query.


Attached File(s)
.php  xtmost_view_video.php (Size: 2.87 KB / Downloads: 450)
04-14-2011 03:26 AM
Find all posts by this user Quote this message in a reply
duhol Offline
Junior Member
**
Posts: 34
Joined: Mar 2011
Post: #7
RE: threadfield wont show
What can I say?
You are my personal Jezus Chrystus!
Plugin works perfect! Biggrin
04-14-2011 05:43 AM
Find all posts by this user Quote this message in a reply
RateU Offline
Administrator
*******
Posts: 2,350
Joined: Mar 2010
Post: #8
RE: threadfield wont show
Glad the plugin works.

Basically, if you want to pull out any data from XThreads custom thread fields, you need to do this:
(04-13-2011 09:38 PM)ZiNgA BuRgA Wrote:  you'll need to actually pull the threadfield data from the query as well.

In the example plugin above, because I need to pull out the video id which is stored in ytvgalid custom thread fields, so I need to put it in the select field list in the query.

Now, you can create your own XThreads plugin Smile
04-15-2011 07:21 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Threaded Mode | Linear Mode
 Standard Tools
Forum Jump:



Contact Us | MyBB Hacks | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication