last updated topics

[CyberDruid]

Is there a mod or a possibility to show the "x" last edited topics?

If I show the 10 last messages, they are sometime from ONE Thread. That is pretty crapty on bigger boards.

Anyone an idea?

[Spaceman-Spiff]

there's currently no mods for that

if you have phpMyAdmin, we can give u the query to view that

[CyberDruid]

Yep.
"Welcome to phpMyAdmin 2.2.6-rc2"

If possible. Give me a detailed "plan" how to view it.
I can hardly use phpMy Admin

[Spaceman-Spiff]

SELECT * FROM yabbse_messages WHERE modifiedName != '' ORDER BY posterTime DESC;

change yabbse_ into your forum table prefix

[CyberDruid]

Sorry. I dont undertsand that. :/

I found: "SELECT * FROM `yabbse_messages` WHERE 1"

What shall I do? How can I add it to my forum?

[Spaceman-Spiff]

just click the textarea where the SELECT... stuff is (like you posted above), delete it, and replace with this code:
SELECT * FROM yabbse_messages WHERE modifiedName != '' ORDER BY posterTime DESC;

[CyberDruid]

OK. Now I see the latest topics in my admin view.
Is it possible for my board users to viewe this?

[Spaceman-Spiff]

what for? showing the last x edited post is kinda weird...

if you want to do that, you'll have to code it somewhere...

if this is why:

If I show the 10 last messages, they are sometime from ONE Thread. That is pretty crapty on bigger boards.

then you can just edit the last 10 topic to show from different topics, not posts from the same topics
i'll give the code later...

[CyberDruid]

Sorry Stiff.
My english isnt that good. I didnt understood what you said in your last post.

I want my board to show that 10 last editied topics to my users.
Normally it shows the 10 last posts. They normally come from spam posts :/

If it would show the 10 last edited topics some people can search new edited TOPIC threads from there.

Or is it possible to ignore a whole forum ("mod ideas" is a forum - for me) in the last 10 posts page?

[Spaceman-Spiff]

showing the 10 latest edited posts wont solve your problem
a better way to do it is to edit Recent.php, in function RecentPosts() search for:

Code Select Expand

            AND t.ID_TOPIC=m.ID_TOPICand replace it with:

Code Select Expand

            AND m.ID_MSG = t.ID_LAST_MSG
this will remove topic duplicates in 10 recent posts (will not show posts from the same topic)

[CyberDruid]

yeah! It works!
Thats a lot! That was exactly what I wanted!

* CyberDruid is happy