Topic-ID on IndexMake that all links to posts from index-page contains topic-id's (even if a 'last_post' is present)
May helpfull for Snippets/Mods or as Inspiration
To make this possible, it adds 2 additional SQL Queries to your board
openindex.php
findCode:
page_header($user->lang['INDEX']);
before addCode:
if (($user->data['user_id'] !== ANONYMOUS) && !$user->data['is_bot'])
{
$config_row_forum_last_post_id = explode(',', $config[(int)$user->data['user_id'] . '_last_post_id']);
$sql = 'SELECT forum_id, topic_id, post_id
FROM ' . POSTS_TABLE . '
WHERE ' . $db->sql_in_set('post_id', $config_row_forum_last_post_id) . '
GROUP BY forum_id';
$result = $db->sql_query_limit($sql, sizeof($config_row_forum_last_post_id));
$topic_id_format = append_sid($phpbb_root_path . 'viewtopic.' . $phpEx, array('f' => '%1$s', 't' => '%2$s', 'p' => '%3$s', '#' => 'p' . '%3$s'));
$config_row_forum_last_post_id = array_flip($config_row_forum_last_post_id);
while ($row = $db->sql_fetchrow($result)){
$rownr = $config_row_forum_last_post_id[$row['post_id']];
$topic_id_url = sprintf($topic_id_format, $row['forum_id'], $row['topic_id'], $row['post_id']);
$template->alter_block_array('forumrow', array(
'U_LAST_POST' => $topic_id_url
), $rownr, 'change');}
$db->sql_freeresult($result);
}
openincludes/functions_display.php
findCode:
foreach ($forum_rows as $row)
{
after addCode:
$row_forum_last_post_id[] = $row['forum_last_post_id'];
findCode:
$last_catless = $catless;
}
after addCode:
if (($user->data['user_id'] !== ANONYMOUS) && !$user->data['is_bot']){
$row_forum_last_post_id = implode(',', $row_forum_last_post_id);
if(isset($config[(int)$user->data['user_id'] . '_last_post_id'])){
if($row_forum_last_post_id !== $config[(int)$user->data['user_id'] . '_last_post_id']){
set_config((int)$user->data['user_id'] . '_last_post_id', $row_forum_last_post_id);}}
else{set_config((int)$user->data['user_id'] . '_last_post_id', $row_forum_last_post_id);}}
Note: You must be logged in at least 1 time as normal user, to see it as guest..
Login
Register
FAQ
Search
Members
