Вопрос/Ответ для "чайников" - PHP-Fusion SF Russian Support Site

Psc написал:
<?php

@openside("TOP пользователей");

echo"<style>

.lvl_1{ background-color: #8D1B1B; border: 5px ridge #B22222; }

.lvl_2{ background-color: #6740E1; border: 5px ridge #4169E1; }

.lvl_3{ background-color: #8D8D8D; border: 5px ridge #D2D2D2; }

.lvl_4{ background-color: #CC8500; border: 5px ridge #FFA500; }

.lvl_5{ background-color: #5B781E; border: 5px ridge #6B8E23; }

.lvl_6{ background-color: #DE4900; border: 5px ridge #DE4D00; }

.lvl_7{ background-color: #5AC718; border: 5px ridge #5ACB00; }

.lvl_8{ background-color: #5B781E; border: 5px ridge #6B8E23; }

.lvl_9{ background-color: #C6C3C6; border: 5px ridge #BDBABD; }

.lvl_10{ background-color: #FFFF00; border: 5px ridge #FFFF7B; }

.pollstableborder {border: 1px solid;padding: 5px;}

</style>";

echo "<table width='96%' cellpadding='0' cellspacing='0'>";

$sql = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_level>='101' ORDER BY user_posts DESC,user_level DESC LIMIT 10");

while ($data = dbarray($sql)) {

$name = $data['user_name'];

$id = $data['user_id'];

//число новостей и статей

$news_ofuser = dbcount('(news_id)','news','news_name='.$id) ;

$articl_ofuser = dbcount('(article_id)','articles','article_name='.$id) ;



$icq = $data['user_icq'];

$result = dbquery("SELECT user_posts FROM ".$db_prefix."users WHERE user_id='".$data['user_id']."'");

$data2 = dbarray($result);

$num_posts = $data2['user_posts'];

$num_shout = dbcount("(shout_id)", "shoutbox", "shout_name='".$data['user_id']."'");

$num_comment = dbcount("(comment_id)", "comments", "comment_name='".$data['user_id']."'");

$rating = dbcount("(rating_id)", "ratings", "rating_user='".$data['user_id']."'");

$num_rang = ($num_shout+$num_comment+$rating+$num_posts);

if ($num_rang >= "0") {$rang = "10";$level = "1";}

if ($num_rang >= "10") {$rang = "25";$level = "2";}

if ($num_rang >= "25") {$rang = "50";$level = "3";}

if ($num_rang >= "50") {$rang = "100";$level = "4";}

if ($num_rang >= "100") {$rang = "250";$level = "5";}

if ($num_rang >= "250") {$rang = "500";$level = "6";}

if ($num_rang >= "500") {$rang = "1000";$level = "7";}

if ($num_rang >= "1000") {$rang = "2500";$level = "8";}

if ($num_rang >= "2500") {$rang = "5000";$level = "9";}

if ($num_rang >= "5000") {$rang = "10000";$level = "10";}

$poll_posts = $rang;

$opt_posts = ($poll_posts ? number_format(100 / $poll_posts * $num_rang) : 0);

$norang = ($rang - $num_rang);

echo"<tr><td><b><a href='profile.php?lookup=$id' class='side'>$name</a></td>

<td width='40%'>

(N:$news_ofuser/A:$articl_ofuser)<img src='".INFUSIONS."d_team_panel/images/blank.png' title='Уровень: ".$level."\n Очки: $num_rang ($opt_posts%)\n До след. уровня: $norang' height='1' width='$opt_posts%' class='lvl_$level'></td></tr>";

}



echo"</tr></table>";

@closeside();

?>
Полный код, пофиксено -

10 чел, выборка по постам,
добавлено - счетчик новостей и статей.