Simply move the active users code in index_body.tpl to the location of your choice. If you know some HTML, you'll know exactly where to put it. If not, experiment and see. My HTML isn't that good, but when I did this, I used the language variables in the template file as a hint as to what styling is where. This approach may work for you as well.SMITH060 wrote:Does anyone know how to change it so that it is displayed at the header, instead of the footer of the index?
Thanks,
SMITH
and replace it with the following code$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, t.topic_type, t.topic_status, p.post_id, p.poster_id,
p.post_time, u.user_id, u.username, u.user_lastvisit
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE t.forum_id IN " . $auth_view_forum_sql . " AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
ORDER BY t.topic_last_post_id DESC";
Please note that only last line of the query is changed.$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, t.topic_type, t.topic_status, p.post_id, p.poster_id,
p.post_time, u.user_id, u.username, u.user_lastvisit
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE t.forum_id IN " . $auth_view_forum_sql . " AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
ORDER BY t.topic_last_post_id DESC limit 0, ".$board_config['topics_on_index'];
I only added to index.php and the line is viewed as entirely:genial.soul wrote:Please note that only last line of the query is changed.$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, t.topic_type, t.topic_status, p.post_id, p.poster_id,
p.post_time, u.user_id, u.username, u.user_lastvisit
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE t.forum_id IN " . $auth_view_forum_sql . " AND t.topic_id = p.topic_id
AND f.forum_id = t.forum_id
AND t.topic_status <> 2
AND p.post_id = t.topic_last_post_id
AND p.poster_id = u.user_id
ORDER BY t.topic_last_post_id DESC limit 0, ".$board_config['topics_on_index'];
I would like to request the mod author to correct this problem in the original download files.
Hi donbodo,donbodo wrote:I am new to this, and I have followed all of the original instructions, except for the first one:
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config ( config_name, config_value ) VALUES ('topics_on_index', '10');
I don't know exactly what this means and need someone to walk me through it.
I haven't this mod installed yet but I guess that you can adddonkeyslo wrote:I have a forum which can not be viewed by people, who are not logged in - they can only see the first page. This also means, that when you come to the page, you can not see the last topics - you have to log in to see them...is there any way to show the last topics to people who are not logged in?
Tnx for answering...
Matej
Code: Select all
<!-- BEGIN switch_user_logged_out -->
Code: Select all
<!-- END switch_user_logged_out -->