Latest X Posts in a templated Phorum-Page

> can somebody call "unallowed" files with the file.php too as far as he can find out the $_GET vars?)

I told you already, no! There is a "read-allowed"-check in file.php.


> has this been fixed in the newer version or can still anybody see "unallowed" threads?

try it. should work fine.

---

Thomas Seifert

Modified to allow imbeding into index.tpl to see the most recent thread per forum.

----edit----
Updated attachment in later post

http://www.krang.org



Edited 1 time(s). Last edit at 03/11/2005 11:53AM by Krang.

I made a small mistake in the template for the index embedding. I forgot the new flag indicator.

http://www.krang.org

Dear all,

we've finally made the switch from phpBB to Phorum and most things have gone quite well. There are a number of things which we need to tweak as integrating any forum within an existing website is quite a challenge...

Our users were soon screaming for a "newest" view and we were happy to find this exists already. I've looked at the base code. It seems strange that the query is date independent (ie. last 24 hours or since last login). So we'll be extending it allow for this. Assuming that this might be of interest to others - what do you think should be the criteria?

last login is not stored anywhere, so you can only go by time.
and having a fixed time is a strange criteria ... .

---

Thomas Seifert

Well, there is date_last_active... I'm currently thinking of how best to use this.
The default could be configurable and would be for non-logged in users essentially.

Charlie

date-last-active isn't set only on login but if you have a resonable update time set for this, yeah then you can use it.

---

Thomas Seifert

Yes, it's quite easy to compare timestamps (oh where are my datetime objects? ;-).

Our Forum is bilingual so this needs to be checked in the Query anyway.

This is my modified query for
phorum_db_get_recent_messages() in mysql.php

$sql = "SELECT {$PHORUM['message_table']}.*
FROM {$PHORUM['message_table']}
INNER JOIN {$PHORUM['forums_table']} ON
({$PHORUM['forums_table']}.forum_id = {$PHORUM['message_table']}.forum_id)
WHERE
language = '{$PHORUM['language']}'
AND status=".PHORUM_STATUS_APPROVED;

does this mod still just show the most recent in one phorum as opposed to across the whole board?

what about just reading the messages *before* posting?
[phorum.org]

---

Thomas Seifert