determine user last post?

[marcus123]

There is a lastpost row in the threads table now i wanna fetch the last one but I can't!

$q = $db->simple_select("threads", "*", "uid = 30");
    while($row = $db->fetch_array($q))
	{
	$time_check = $row['lastpost'];	
	echo $time_check;
	}

This returns all values but how to only return the last one which is the one I am interested in?

This one only returns the first

$q = $db->simple_select("threads", "*", "uid = 30");
   $row = $db->fetch_array($q)

	$time_check = $row['lastpost'];	
	echo $time_check;

Please help.


I this the correct way????

$q = $db->simple_select("threads", "*", "uid = 30", array('order_by' => 'lastpost', 'order_dir' => 'DESC', 'limit' => 1));

[Omar G.]

I this the correct way????

Not really.

[Crazycat]

The lastpost field is the timestamp of the last post in the thread, not its id.

If you want to have the last post of a member in a particular thread, you have to look in the posts table. And to have only a last element, the MAX() function in SQL is great.

[martec]

portal.php has great example:

$query = $db->query("
 SELECT t.tid, t.fid, t.uid, t.lastpost, t.lastposteruid, t.lastposter, t.subject, t.replies, t.views, u.username
 FROM ".TABLE_PREFIX."threads t
 LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
 WHERE 1=1 {$excludeforums}{$tunviewwhere} AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
 ORDER BY t.lastpost DESC
 LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
 );
 while($thread = $db->fetch_array($query))
 { }

so only need made small changes...

$query = $db->query("
 SELECT t.lastpost
 FROM ".TABLE_PREFIX."threads t
 WHERE 1=1 AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
 ORDER BY t.lastpost DESC
 LIMIT 0, 5"
 );
 while($row = $db->fetch_array($query))
 {
    $time_check = $row['lastpost'];
    echo $time_check;
 }

code above will return 5 last posts because of limit.
I removed {$excludeforums}{$tunviewwhere}, but you can add, see portal.php.
i not tested and i not know if work. and mysql not my strong area. But this already has answer in inside of mybb.

So please do a little research. And stop keep asking the answer. Try it yourself to solve the issue. You will never learn that way.

[marcus123]

@martec baby thanks so much! I don't get it how is it possible to SET LIMIT to 0.5?

I am usually back-tracking MYBB source code but some times I get stuck so thank yo very much you rock!

[Jones H]

"LIMIT 0, 5" means: start with element 0 and take 5.

[Crazycat]

Read: limit 5 offset 0

[marcus123]

cool thanks