|
bax
Junior Member
141 Posts |
 Posted - 18 September 2002 : 23:11:31
|
There should be a script for this around somewhere - check out the mods.
If not, you could really easily write this yourself. Here's some SQL to get 10 most recent PUBLIC posts (you'll need to adapt this to accomodate Snitz table names).
select top 10 ft.cat_id, ft.forum_id, ft.topic_id, ft.t_subject, ft.t_author, ft.t_date,
fm.m_name, fm.m_FirstName
from forum_topics ft
inner join forum_forum ff
on ft.forum_id = ff.forum_id
inner join forum_members fm
on ft.t_author = fm.member_id
where ff.f_privateForums = 0
order by ft.t_date desc
--order by the date they were posted, in descending order.... |
 |
|
Topic Locked
I want to have 10 last post on my first page, can someone tell me what should I do ?