Lara bekommts mal wieder net gebacken...
Hab den Mod eingebaut, der die letzten Themen im Index anzeigt.
Möchte den erweitern, das bei den letzten Themen die postingtime und der User angezeigt wird...
Code: Alles auswählen
########################################################
## Mod Title: The last Five and the Five popular (answers/views) on index.php
## Mod Version: 1.0.0
## Author: Andrey Politov aka Sergeant < andypolv@mail.ru >
## Description: Adds small table (3 columns) on the top of the forum index with 5 last posts, 5 popular
## (with maximum answers) and 5 popular (with maximum views). It helps to provide easy access to the last topics
## and keep on the top interesting topics. You can see example of this Mod: http://playland.ru/forum/
##
## Installation Level: Easy
## Installation Time: 5 Minutes
## Files To Edit: 3 (4 if you have Russian language installed)
## index.php
## templates/subSilver/index_body.tpl
## language/lang_english/lang_main.php
## language/lang_russian/lang_main.php
##
## Included Files: none
##
########################################################
##
## Before Adding This hack To Your Forum,
## You Should Back Up All Files Related To This hack
##
########################################################
##
## Installation Notes:
##
## Follow the steps below.
##
########################################################
#
#-----[ FIND IN index.php ]-----------------------------------------
#
//
// Okay, let's build the index
//
for($i = 0; $i < $total_categories; $i++)
{
$cat_id = $category_rows[$i]['cat_id'];
#
#-----[ ADD BEFORE ]------------------------------
#
//
// Okay, let's build the topic recent and popular
//
$active_topics_sql="SELECT a.topic_id,a.topic_title, a.topic_replies, a.topic_last_post_id, c.post_time
FROM phpbb_topics a, phpbb_users b, phpbb_posts c, phpbb_forums d
where a.topic_last_post_id=c.post_id and b.user_id=c.poster_id
and d.forum_id=a.forum_id
and d.auth_view=0
ORDER BY topic_last_post_id DESC
LIMIT 5";
$active_topics = $db->sql_query($active_topics_sql);
$active_topics_sql2="SELECT a.topic_id,a.topic_title, a.topic_replies, a.topic_last_post_id, c.post_time
FROM phpbb_topics a, phpbb_users b, phpbb_posts c, phpbb_forums d
where a.topic_last_post_id=c.post_id and b.user_id=c.poster_id
and d.forum_id=a.forum_id
and d.auth_view=0
ORDER BY topic_replies DESC
LIMIT 5";
$active_topics2 = $db->sql_query($active_topics_sql2);
$active_topics_sql3="SELECT a.topic_id,a.topic_title, a.topic_views, a.topic_replies, a.topic_last_post_id, c.post_time
FROM phpbb_topics a, phpbb_users b, phpbb_posts c, phpbb_forums d
where a.topic_last_post_id=c.post_id and b.user_id=c.poster_id
and d.forum_id=a.forum_id
and d.auth_view=0
ORDER BY topic_views DESC
LIMIT 5";
$active_topics3 = $db->sql_query($active_topics_sql3);
while (($line = mysql_fetch_array($active_topics)) and ($line2 = mysql_fetch_array($active_topics2)) and ($line3 = mysql_fetch_array($active_topics3)))
{
if (strlen($line['topic_title']) > 40)
{
$line_topic_title = substr($line['topic_title'], 0, 40)." ...";
}
else
{
$line_topic_title = $line['topic_title'];
}
if (strlen($line2['topic_title']) > 40)
{
$line_topic_title2 = substr($line2['topic_title'], 0, 40)." ...";
}
else
{
$line_topic_title2 = $line2['topic_title'];
}
if (strlen($line3['topic_title']) > 40)
{
$line_topic_title3 = substr($line3['topic_title'], 0, 40)." ...";
}
else
{
$line_topic_title3 = $line3['topic_title'];
}
$lastpost = "<a href=\"".$phpbb_root_path."viewtopic.php?t=" . $line['topic_id'] . "\" title=\"" . $line['topic_title'] ."\">" . $line_topic_title . "</a>";
$poppost = "<a href=\"".$phpbb_root_path."viewtopic.php?t=" . $line2['topic_id'] . "\" title=\"" . $line2['topic_title'] ."\">" . $line_topic_title2 . "</a>";
$poppostc = $line2['topic_replies'];
$popviewpost = "<a href=\"".$phpbb_root_path."viewtopic.php?t=" . $line3['topic_id'] . "\" title=\"" . $line3['topic_title'] ."\">" . $line_topic_title3 . "</a>";
$popviewpostc = $line3['topic_views'];
$template->assign_block_vars('topicrecentpopular', array(
'TOPICSPOPULAR' => $poppost,
'TOPICSPOPULARC' => $poppostc,
'TOPICSPOPULARVIEW' => $popviewpost,
'TOPICSPOPULARVIEWC' => $popviewpostc,
'TOPICSRECENT' => $lastpost)
);
}
#
#-----[ SAVE & CLOSE index.php ]------------------------------
#
#
#-----[ FIND IN templates/subSilver/index_body.tpl ]------------------------------
#
<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
<tr>
<th colspan="2" class="thCornerL" height="25" nowrap="nowrap"> {L_FORUM} </th>
<th width="50" class="thTop" nowrap="nowrap"> {L_TOPICS} </th>
<th width="50" class="thTop" nowrap="nowrap"> {L_POSTS} </th>
<th class="thCornerR" nowrap="nowrap"> {L_LASTPOST} </th>
</tr>
<!-- BEGIN catrow -->
#
#-----[ ADD BEFORE ]------------------------------
#
<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
<tr>
<th width="25%" class="thTop" nowrap="nowrap"> {L_TOPICSRECENT} </th>
<th width="38%" colspan="2" class="thTop" nowrap="nowrap"> {L_TOPICSPOPULAR} </th>
<th width="37%" colspan="2" class="thTop" nowrap="nowrap"> {L_TOPICSPOPULARVIEW} </th>
</tr>
<!-- BEGIN topicrecentpopular -->
<tr>
<td width="29%" class="row2" align="left" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSRECENT}</span></td>
<td width="31%" class="row2" align="left" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULAR}</span></td>
<td width="6%" class="row2" align="center" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULARC}</span></td>
<td width="29%" class="row2" align="left" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULARVIEW}</span></td>
<td width="6%" class="row2" align="center" valign="middle"><span class="gensmall">{topicrecentpopular.TOPICSPOPULARVIEWC}</span></td>
</tr>
<!-- END topicrecentpopular -->
</table>
#
#-----[ SAVE & CLOSE templates/subSilver/index_body.tpl ]------------------------------
#
#
#-----[ FIND IN language/lang_english/lang_main.php ]------------------------------
#
$lang['Topics'] = 'Topics';
#
#-----[ ADD AFTER ]------------------------------
#
$lang['TopicsRecent'] = "Recent Topics";
$lang['TopicsPopular'] = "Popular Topics (by reply)";
$lang['TopicsPopularView'] = "Popular Topics (by view)";
#
#-----[ SAVE & CLOSE language/lang_english/lang_main.php ]------------------------------
#
könnte mir jemand bei Gelegenheit helfen ?
Ist aber ne Sache, die nicht eilt.
Oh und noch eine Frage....In meiner Error_log Datei befinden sich noch 3 Fehler....die sich auf ein Verweis zu einem Template beziehen, welches nicht vorhanden ist und auf den neuen Style umgeschrieben werden müssten.
In der log Datei steht document 1498 oder so.....
Kann ich irgenwie genau eben dieses Doc. ausfindig machen ? Oder bleibt mir nichts anderes übrig wie die tpls einzeln zu durchsuchen ?
