Latest Discussions...

[nando99]

I've found mods for 3.6.8 that allow you to show the latest posts and latest threads but they're not what I'm looking for.

The latest thread shows the newest thread only and the latest posts shows the latest post but shows the post twice (or as many times as its been replied to) if its the latest post.

I'm looking for something that shows the latest post without showing the same post twice, only show the latest post of that post...

Let me know if I confused you :confused:, thanks in advance...

nando

[Dismounted]

SELECT threadid, title, lastposter
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
ORDER BY lastpost DESC
LIMIT 10

[nando99]

SELECT threadid, title, lastposter
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
ORDER BY lastpost DESC
LIMIT 10

Umm..... not to sound like total noob - but what do i do with that?

[MoT3rror]

That is the sql you need to run to get the latest threads on a page not including posts.

[nando99]

Still not understanding what I need to do....

I run this in phpmyadmin? or? Please explain from start to finish as I'm having a mindfart and have no idea what I should do... thanks.

[Dismounted]

You need to run that query to fetch the information you want. You will need at least some PHP knowledge.