How to display all threads (of all forums) in one Threadt UI? [message #161031] |
Wed, 11 November 2009 03:54 |
hvacol
Messages: 12 Registered: April 2009
Karma: 0
|
Junior Member |
|
|
Hi professionals,
this is very good now to display thread according to different cats.
some times i want to display threads and messages of all forums just like mnav explore,but the interface is like "threadt" ?
you know,for exsample, 50 thread per page to display all forums threads(messages) just like threadt.
how can i do that?
i test to copy threadt.php.t as all.php.t, copy threadt.tmpl to
all.tmpl
modify
{PHP_FILE: input: all.php.t; output: all.php;}
and modefied all.php.t (i am poor in mysql and php)
$r = uq('SELECT
t.views, t.tdescr, t.moved_to, t.thread_opt, t.root_msg_id, r.last_view,
m.subject, m.length, m.reply_to, m.poll_id, m.attach_cnt, m.icon, m.poster_id, m.post_stamp, m.thread_id, m.id,
u.alias
// FROM {SQL_TABLE_PREFIX}tv_'.$frm->id.' tv
FROM {SQL_TABLE_PREFIX}tv_* tv
INNER JOIN {SQL_TABLE_PREFIX}thread t ON tv.thread_id=t.id
INNER JOIN {SQL_TABLE_PREFIX}msg m ON t.id=m.thread_id AND m.apr=1
LEFT JOIN {SQL_TABLE_PREFIX}users u ON m.poster_id=u.id
LEFT JOIN {SQL_TABLE_PREFIX}read r ON t.id=r.thread_id AND r.user_id='._uid.'
WHERE tv.seq BETWEEN '.($lwi - ($cur_frm_page * $THREADS_PER_PAGE) + 1).' AND '.($lwi - (($cur_frm_page - 1) * $THREADS_PER_PAGE)).'
ORDER BY tv.seq DESC, m.id');
and modyfied the URL with &frm_id=*
...forum/index.php?t=all&frm_id=*&S=680c6a4dc9fb6e3dccd92731b25e441e
rebuild theme (it is ok)
no it can not work,
How can i do that?
(fudforum is so powerful ,customizable,stretching... But some times i can not get it)
Thank you very much!
Best regards,
[Updated on: Wed, 11 November 2009 05:03] Report message to a moderator
|
|
|
|
thereis nothing to display [message #161042 is a reply to message #161037] |
Thu, 12 November 2009 01:12 |
hvacol
Messages: 12 Registered: April 2009
Karma: 0
|
Junior Member |
|
|
naudefj wrote on Wed, 11 November 2009 14:25hvacol wrote on Wed, 11 November 2009 05:54no it can not work,
What do you mean, do you get an error?
I did not get an error, there is nothing to display,the page is blank
i need to added a option in forumsel popup menu: display All forums ,
just like
Goto Forum:
----------------------
Display All forums
--cat 1
forum1
forum2
.
.
.
forumn
--cat2
forum1
.
.
.
----------------------
Go
it is display all forum's threads(messages) according to threadt(or thread) mode
how can do this?
thank you very much!
best regards,
[Updated on: Thu, 12 November 2009 01:27] Report message to a moderator
|
|
|
|