Latest posts on your website

[Member 3639]

Easily possible will whip something up later today for you

 

[ToDie4]

Easily possible will whip something up later today for you

I appreciate that very much Liam, when you have the time mate, no rush.

 

[fattony69]

Does this put a burden on the server to keep pulling these threads?

 

[Member 3639]

Not at all it's a very simply single sql query, even shared hosting won't notice a difference, most websites pull a lot more than this does anyway.

 

[gordy]

Does this put a burden on the server to keep pulling these threads?

You can always cache it out to a static file every fifteen minutes are so too -

 

[makdeniss]

Check the first post, have updated it with new code that is tested here working fine: http://www.gamingonlinux.info/test.php

Thanks a lot!!!! Now everything works just perfect! Cheers, mate.
Is it although possible to display the last post date and author of the last post also?

 

[Member 3639]

I will put in the ability to grab a portion of the text or all of it, topic posts date, last reply date and author in next update for you guys

 

[makdeniss]

You know what else would be cool? When the links are displayed, clicking them would lead to the last post in the topic. Not the first one, like right now.

 

[makdeniss]

Ok, so if anybody is interested I have a working code that gets you to the last post of the thread, displays the last post author, last post date, post count, view count

 

[Member 3639]

If you want to post it here i can update the first post with it, haven't had time to do it myself recently

 

[gordy]

Ok, so if anybody is interested I have a working code that gets you to the last post of the thread, displays the last post author, last post date, post count, view count

Count me in

 

[Member 3639]

New version, check first post for changelog and new code.

Guys please leave off-topic posts for personal messages don't clog up my post if you don't mind.

 

[Paul B]

Off topic posts split off to here at the request of the thread author: http://xenforo.com/community/threads/bug-tracker.19053/

 

[Espen Espelund]

Any chance of bringing the last poster name and userimage using this?

 

[Espen Espelund]

I managed to get avatars like this. Guess it's a somewhat effective way to do it?

$user = XenForo_Model::create('XenForo_Model_User')->getUserById(1);
echo '<img src="' . XenForo_Template_Helper_Core::helperAvatarUrl($user, 's') . '" />';

 

[Member 3639]

That's pretty cool, thanks for the find

 

[bousaid]

Nice.. works perfect
how to add $forum_url in :

echo "<a href=\"$threadUrl\">$threadTitle</a> Views: {$thread['view_count']}, Comments: {$thread['reply_count']}<br />
<br />";

 

[ragtek]

There's 1 problem with your query

$node_id_list = implode($nodes_get, ',');

$sql_forum = "SELECT `title`, `thread_id`, `view_count`, `reply_count` FROM `xf_thread` WHERE `node_id` IN ($node_id_list) ORDER BY `last_post_date` DESC LIMIT {$limit}";

You check for viable nodes, BUT you don't check if the user is really allowed to view the thread.
It could be softdeleted or moderated(=> not viable for avarage joe) BUT your script would return it

 

[Vladislav Rastrusny]

It doesn't work if the script is not in the forum root. $forum_url has no effect now on how XenForo_Link::buildPublicLink builds links.

 

[bousaid]

It doesn't work if the script is not in the forum root. $forum_url has no effect now on how XenForo_Link::buildPublicLink builds links.

use this:

$threadUrl =$forum_url. XenForo_Link::buildPublicLink('threads', $thread);