show our post and thread in member.php
bekti Offline
Junior Member
**
Posts: 43
Joined: Mar 2012
Post: #3
RE: show our post and thread in member.php
how to make it without plugin?

i have already make this code

Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$query = $db->query("
		SELECT p.pid, t.subject, p.message, p.tid, t.uid, t.username, t.replies, t.dateline, p.smilieoff
        FROM ".TABLE_PREFIX."posts p
        LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
        WHERE t.uid = '1' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid
        ORDER BY t.dateline DESC
        LIMIT 3");
while($threads = $db->fetch_array($query))
{
	 $threads['threadlink'] = get_thread_link($threads['tid']);
        $threads['profilelink'] = build_profile_link($threads['username'], $threads['uid']);
        $threads['date'] = my_date($mybb->settings['dateformat'], $threads['dateline']);
        $threads['time'] = my_date($mybb->settings['timeformat'], $threads['dateline']);
        $threads['lastpostlink'] = get_thread_link($threads['tid'], 0, "lastpost");
	$threads['message'] = my_substr($threads['message'], 0, 250) . "...";
	eval("\$memberlatest_threads .= \"".$templates->get("member_latest_threads_threads")."\";");
}


but the code just show our thread if i see other member profile...anyone can help?

09-30-2012 12:36 PM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

Messages In This Thread
RE: show our post and thread in member.php - bekti - 09-30-2012 12:36 PM

 Standard Tools
Forum Jump: