########################################################
## Mod Title: last_topic_title_index
## Mod Version: 1.0.0
## Author: Adam Ismay <
admin@boardz.tk>
## Description: Gives the topic title in the last post box
## on index.
##
## Installation Level: fairly easy
## Installation Time: 3-5 minutes
## Files To Edit: index.php
## templates/????/index_body.tpl
########################################################
## Security Disclaimer: This MOD Cannot Be Posted To Or Added At Any Non-Official phpBB Sites
##############################################################
## Notes: Does not do anything on Postgres or Oracle. The topic
## title is shortened to 25. This can be changed in the code
## or you can add $board_config['topic_title_index_size'] = ??;
## in the template config file which will override this
## value. Topic titles are not displayed if the user does
## not have the right to read the forum. The link goes to
## the start of the topic, the existing link to last post is
## unaffected.
#########################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
#########################################################
#
#---- [ OPEN ] --------
#
index.php
#
#----- [ FIND (line 156) ] ----
#
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order";
#
#---- [ REPLACE WITH ] ----
#
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_title, t.topic_id
FROM ((( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_id = p.topic_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order";
#
# --- [ FIND (line 250) ] ----
#
$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);
#
#-----[ REPLACE WITH ] -----
#
$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);
if (!isset($board_config['topic_title_index_size'])){
$board_config['topic_title_index_size'] = 25; //Set this to size limit
}
#
# --- [ FIND (line 430) ] ----
#
'MODERATORS' => $moderator_list,
#
# ---- [ AFTER, ADD ] ---
#
'LAST_TOPIC' => $is_auth_ary[$forum_data[$j]['forum_id']]['auth_read'] ? (strlen($forum_data[$j]['topic_title']) > $board_config['topic_title_index_size']) ? substr($forum_data[$j]['topic_title'], 0, ($board_config['topic_title_index_size'] - 2)) . "..." : $forum_data[$j]['topic_title'] : "",
'U_LAST_TOPIC' => append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $forum_data[$j]['topic_id']),
#
#-----[ OPEN ]----
#
templates/subSilver/index_body.tpl
#
#----[ FIND ]-------
#
<td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"> <span class="gensmall">{catrow.forumrow.LAST_POST}</span></td>
#
#-----[ REPLACE WITH ]---------
#
<td class="row2" align="center" valign="middle" height="50" nowrap="nowrap"> <span class="gensmall">
<a href="{catrow.forumrow.U_LAST_TOPIC}">{catrow.forumrow.LAST_TOPIC}</a><br />{catrow.forumrow.LAST_POST}</span></td>
#
#-----[ SAVE ALL FILES ]------------------------------------------
#
# EoM
