 | The last Five and the Five popular (answers/views) on index.php |  |
 Posted: 11/25/2006 10:56 PM |
 |
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
 |
|
|
|
Joined: Oct 29, 2006
Local time: 8:23 AM
Location: Klang, Malaysia
|
|
|
|
|
 |
I was add this mod on my forum..after it ..i go into my forum and i see got the 3 new columns ..but after i try reply or post the new topic..i don't seen that function to be working. Can i know what happen? This is a code :
| Code:
|
########################################################
## Mod Title: The last Five and the Five popular (answers/views) on index.php
## Mod Version: 1.1.0
## Author: Andrey Politov aka Sergeant < >
## Hack Updated to phpBB 2.0.11 Compatibility by: Thoul <thoul@users.sourceforge.net>
## Hack Updated based on code created by FB-ke
## 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.
##
## 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.
##
########################################################
#
#-----[ OPEN ]------------------------------------------
#
index.php
#
#-----[ FIND ]------------------------------------------
#
//
// Okay, let's build the index
//
for($i = 0; $i < $total_categories; $i++)
{
$cat_id = $category_rows[$i]['cat_id'];
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//-------------------------------------------------------------------- ----
// Top Topics on Index 1.1.0 - Begin Code Addition
//
$template->assign_vars(array(
'L_TOPICSRECENT' => $lang['TopicsRecent'],
'L_TOPICSPOPULAR' => $lang['TopicsPopular'],
'L_TOPICSPOPULARVIEW' => $lang['TopicsPopularView'])
);
// Get forum auth information to insure privacy of hidden topics
$topics_auth = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata);
$topics_auth_sql = '';
foreach($topics_auth as $k=>$v)
{
if( $v['auth_view'] && $v['auth_read'] )
{
$topics_auth_sql .= (( empty($topics_auth_sql) ) ? '': ', ') . $k;
}
}
if( empty($topics_auth_sql) )
{
$template->assign_block_vars('topicrecentpopular', array(
'TOPICSPOPULAR' => $lang['No_Posts'],
'TOPICSPOPULARVIEW' => $lang['No_Posts'],
'TOPICSRECENT' => $lang['No_Posts']
));
}
else
{
//
// Okay, let's build the topic recent and popular
//
$active_topics_sql = 'SELECT t.topic_id, t.topic_title, t.topic_replies, t.topic_views, t.topic_last_post_id
FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE. ' f
WHERE t.forum_id IN (' . $topics_auth_sql . ')
AND f.forum_id = t.forum_id
ORDER BY %1$s DESC
LIMIT 0,5';
$active_topics_sql_a = sprintf($active_topics_sql, 'topic_last_post_id');
$active_topics_sql_b = sprintf($active_topics_sql, 'topic_replies');
$active_topics_sql_c = sprintf($active_topics_sql, 'topic_views');
$recent_row = $popular_row = $viewed_row = array();
if( !$active_topics_a = $db->sql_query($active_topics_sql_a))
{
message_die(GENERAL_ERROR, 'Could not retrieve recent topics', '', __LINE__, __FILE__, $active_topics_sql_a);
}
$recent_row = $db->sql_fetchrowset($active_topics_a);
$db->sql_freeresult($active_topics_a);
if( !$active_topics_b = $db->sql_query($active_topics_sql_b))
{
message_die(GENERAL_ERROR, 'Could not retrieve popular topics', '', __LINE__, __FILE__, $active_topics_sql_b);
}
$popular_row = $db->sql_fetchrowset($active_topics_b);
$db->sql_freeresult($active_topics_b);
if( !$active_topics_c = $db->sql_query($active_topics_sql_c))
{
message_die(GENERAL_ERROR, 'Could not retrieve most viewed topics', '', __LINE__, __FILE__, $active_topics_sql_c);
}
$viewed_row = $db->sql_fetchrowset($active_topics_c);
$db->sql_freeresult($active_topics_c);
for( $i = 0; $i < 5; $i++ )
{
$recent_topic_title = $recent_row[$i]['topic_title'];
$popular_topic_title = $popular_row[$i]['topic_title'];
$viewed_topic_title = $viewed_row[$i]['topic_title'];
if( strlen($recent_topic_title) > 40 )
{
$recent_topic_title = substr($recent_topic_title, 0, 40) . '...';
}
if( strlen($popular_topic_title) > 40 )
{
$popular_topic_title = substr($popular_topic_title, 0, 40) . '...';
}
if( strlen($viewed_topic_title) > 40 )
{
$viewed_topic_title = substr($viewed_topic_title, 0, 40) . '...';
}
$recent_post = '<a href="viewtopic.php?' . POST_TOPIC_URL . '=' . $recent_row[$i]['topic_id'] . '" title="' . $recent_row[$i]['topic_title'] . '">' . $recent_topic_title . '</a>';
$popular_post = '<a href="viewtopic.php?' . POST_TOPIC_URL . '=' . $popular_row[$i]['topic_id'] . '" title="' . $popular_row[$i]['topic_title'] . '">' . $popular_topic_title . '</a>';
$popular_total_replies = $popular_row[$i]['topic_replies'];
$viewed_post = '<a href="viewtopic.php?' . POST_TOPIC_URL . '=' . $viewed_row[$i]['topic_id'] . '" title="' . $viewed_row[$i]['topic_title'] . '">' . $viewed_topic_title . '</a>';
$viewed_total_replies = $viewed_row[$i]['topic_views'];
$template->assign_block_vars('topicrecentpopular', array(
'TOPICSPOPULAR' => $popular_post,
'TOPICSPOPULARC' => $popular_total_replies,
'TOPICSPOPULARVIEW' => $viewed_post,
'TOPICSPOPULARVIEWC' => $viewed_total_replies,
'TOPICSRECENT' => $recent_post)
);
}
}
//
// Top Topics on Index 1.1.0 - End Code Addition
//-------------------------------------------------------------------- ----
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/index_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<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 -->
#
#-----[ BEFORE, ADD ]------------------------------------------
#
<!-- Top Topics on Index 1.1.0 - Begin Code Addition -->
<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>
<!-- Top Topics on Index 1.1.0 - End Code Addition -->
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
//
// That's all, Folks!
// -------------------------------------------------
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//-------------------------------------------------------------------- ----
// Top Topics on Index 1.1.0 - Begin Code Addition
//
$lang['TopicsRecent'] = "Recent Topics";
$lang['TopicsPopular'] = "Popular Topics (by reply)";
$lang['TopicsPopularView'] = "Popular Topics (by view)";
//
// Top Topics on Index 1.1.0 - End Code Addition
//-------------------------------------------------------------------- ----
#
#-----[ OPEN ]------------------------------------------
#
language/lang_russian/lang_main.php
#
#-----[ FIND ]------------------------------------------
#
//
// That's all, Folks!
// -------------------------------------------------
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//-------------------------------------------------------------------- ----
// Top Topics on Index 1.1.0 - Begin Code Addition
//
$lang['TopicsRecent'] = "Ïîñëåäíèå òåìû";
$lang['TopicsPopular'] = "Ïîïóëÿðíûå òåìû (ïî îòâåòàì)";
$lang['TopicsPopularView'] = "Ïîïóëÿðíûå òåìû (ïî ïðîñìîòðàì)";
//
// Top Topics on Index 1.1.0 - End Code Addition
//-------------------------------------------------------------------- ----
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# End
|
|
|
|
|
|
| Back to Top |
|
|
| Re: The last Five and the Five popular (answers/views) on index.php | |
| Posted: 11/26/2006 12:30 AM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 8:23 AM
Location: Klang, Malaysia
|
|
|
|
|
|
Ok..the problem is fix now..but if i put that columns on up place..it cannot be working..if i put on down place..it can be working back..nightrider, can help me to solve this problem? You go visit my forum see at the down.. the mod can be working if i install on the L_whos online place..if i install on the top ..it cannot be working..i dunno where i need to paste..  |
|
|
|
|
| Back to Top |
|
|
| Re: The last Five and the Five popular (answers/views) on index.php | |
| Posted: 11/26/2006 2:31 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:23 AM
Location: St Pete, FL
|
|
|
|
|
|
Are you saying that you want the following to display on the top of your Index page? If so, where exactly do you want it???
 |
|
|
|
|
| Back to Top |
|
|
| Re: The last Five and the Five popular (answers/views) on index.php | |
| Posted: 11/26/2006 9:23 PM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 8:23 AM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
Are you saying that you want the following to display on the top of your Index page? If so, where exactly do you want it???
|
Ya..i want it at TOP on my index page!! Does this MOD can show on my Ezportal page also? |
|
|
|
|
| Back to Top |
|
|
| Re: The last Five and the Five popular (answers/views) on index.php | |
| Posted: 11/27/2006 1:40 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:23 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, it wasn't hard to rearrange everything. You just need to remember to move the entire table, not just pieces of it. I also installed the code on the Portal page. I created a MOD to do it...
 |
|
|
|
|
| Back to Top |
|
|
| Re: The last Five and the Five popular (answers/views) on index.php | |
| Posted: 11/27/2006 10:02 PM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 8:23 AM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
Ok, it wasn't hard to rearrange everything. You just need to remember to move the entire table, not just pieces of it. I also installed the code on the Portal page. I created a MOD to do it...
|
Ya..i got do it on my portal page last night..but dunno which line to paste the code.. last night i was try yaking 20 minutes..after ..only have the new column but didn't see the word. And the script error..i dunno where the line are current to paste the code. I just only can success install the flash clock on my portal page.. Thanks so much again. |
|
|
|
|
| Back to Top |
|
|
| Re: The last Five and the Five popular (answers/views) on index.php | |
| Posted: 11/28/2006 1:56 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:23 AM
Location: St Pete, FL
|
|
|
|
|
|
You're welcome...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
