Top posters MOD
Verfasst: 15.02.2004 13:00
ich war gerade dabei den MOD Title: Top posters on index or ezPortal
zu installen da traf ich in den Zeilen:
#
#-----[ OPEN ]------------------------------------------
#
index.php or portal.php
#
#-----[ FIND ]------------------------------------------
#
// Fenerate page
#
#-----[ BEFORE ADD ]------------------------------------------
#
// Start Top 5 Posters hack
$sql = "SELECT post_id FROM " . POSTS_TABLE . " ORDER BY post_id DESC LIMIT 1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$total_post_perc = $row['post_id'];
$perc_mult = 3;
$perc_mult_set = 0;
$rank = 0;
$sql = "SELECT user_id, username, user_posts FROM " . USERS_TABLE ." WHERE user_id <> -1 ORDER BY user_posts DESC LIMIT 5";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result)) {
$rank++;
if (!($rank % 2)) $class = 'row2'; else $class= 'row1';
$percentage = round(100 * $row['user_posts'] / get_db_stat('postcount'),0);
$bar_perc = round($percentage * $perc_mult,0);
$template->assign_block_vars("users", array(
'RANK' => $rank,
'CLASS' => $class,
'USERNAME' => $row['username'],
'PERCENTAGE' => $percentage,
'URL' => $phpbb_root_path . "profile.php?mode=viewprofile&u=" . $row['user_id'],
'BAR' => $bar_perc,
'POSTS' => $row['user_posts'])
);
}
// End Top 5 Posters hack
#-----[ FIND ]------------------------------------------
#
// Fenerate page............ wo soll das bitte sein?!
Bin dankbar für jede Hilfe!
zu installen da traf ich in den Zeilen:
#
#-----[ OPEN ]------------------------------------------
#
index.php or portal.php
#
#-----[ FIND ]------------------------------------------
#
// Fenerate page
#
#-----[ BEFORE ADD ]------------------------------------------
#
// Start Top 5 Posters hack
$sql = "SELECT post_id FROM " . POSTS_TABLE . " ORDER BY post_id DESC LIMIT 1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$total_post_perc = $row['post_id'];
$perc_mult = 3;
$perc_mult_set = 0;
$rank = 0;
$sql = "SELECT user_id, username, user_posts FROM " . USERS_TABLE ." WHERE user_id <> -1 ORDER BY user_posts DESC LIMIT 5";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result)) {
$rank++;
if (!($rank % 2)) $class = 'row2'; else $class= 'row1';
$percentage = round(100 * $row['user_posts'] / get_db_stat('postcount'),0);
$bar_perc = round($percentage * $perc_mult,0);
$template->assign_block_vars("users", array(
'RANK' => $rank,
'CLASS' => $class,
'USERNAME' => $row['username'],
'PERCENTAGE' => $percentage,
'URL' => $phpbb_root_path . "profile.php?mode=viewprofile&u=" . $row['user_id'],
'BAR' => $bar_perc,
'POSTS' => $row['user_posts'])
);
}
// End Top 5 Posters hack
#-----[ FIND ]------------------------------------------
#
// Fenerate page............ wo soll das bitte sein?!
Bin dankbar für jede Hilfe!