Статистика форума - PHP-Fusion SF Russian Support Site

echo "
<table width='100%' cellpadding='0' cellspacing='0' align='center'>
<tr>
<table border='0' cellpadding='0' cellspacing='1' width='100%' class='tbl-border' align='center'><tr>
<td class='forum-caption' align='left'>Статистика форума
<tr><td width='100%' align='left' class='tbl1'>";

// Online Users Panel Code
if ($settings['maintenance'] != "1") {
$cond = ($userdata['user_level'] != 0 ? "'".$userdata['user_id']."'" : "'0' AND online_ip='".FUSION_IP."'");
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user=".$cond."");
if (dbrows($result) != 0) {
$result = dbquery("UPDATE ".$db_prefix."online SET online_lastactive='".time()."' WHERE online_user=".$cond."");
} else {
$name = ($userdata['user_level'] != 0 ? $userdata['user_id'] : "0");
$result = dbquery("INSERT INTO ".$db_prefix."online VALUES('$name', '".FUSION_IP."', '".time()."')");
}
if (isset($_POST['login'])) {
$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_user='0' AND online_ip='".FUSION_IP."'");
} else if (isset($logout)) {
$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_ip='".FUSION_IP."'");
}
$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_lastactive<".(time()-60)."");
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user='0'");
echo "".$locale['011']." ".dbrows($result)." \n";
$result = dbquery(
"SELECT ton.*, user_id,user_name FROM ".$db_prefix."online ton
LEFT JOIN ".$db_prefix."users tu ON ton.online_user=tu.user_id
WHERE online_user!='0'"
);
$usersPosts = dbcount("(user_id)", "users", "user_posts != '0'");

function daysBetween($day1,$day2){
return round((strtotime($day2)-strtotime($day1))/(24*60*60),0);
}

$useRealPosts = TRUE; //set to false if you want to use the posts stored in profile for calculations rather than real amount of posts

$topPoster = ($useRealPosts ? dbarray(dbquery("SELECT ".$db_prefix."users.*,count(post_id) AS user_posts
FROM ".$db_prefix."users LEFT JOIN ".$db_prefix."posts ON ".$db_prefix."users.user_id = ".$db_prefix."posts.post_author
GROUP BY ".$db_prefix."users.user_id ORDER BY user_posts DESC LIMIT 0,1")) : dbarray(dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_posts DESC")));

$daysInCommunity = daysBetween(date("Y/m/d", $topPoster['user_joined']), date("Y/m/d"));
$topUserPost = ($topPoster['user_posts'] ? $topPoster['user_posts'] : 0);
$postsDaily = (!empty($topUserPost) && $topUserPost != 0 ? number_format($daysInCommunity / $topUserPost, 2) : "0");

// This code reads the amount of Forum Post from the Database
$facount = dbquery("SELECT count(post_id) FROM ".$db_prefix."posts");
$facount2 = dbquery("SELECT count(thread_id) FROM ".$db_prefix."threads");
//echo "На форуме сообщений: ".dbresult($facount, 0)." ";
//echo "На форуме ".dbresult($facount, 0)." сообщений в ".dbresult($facount2, 0)." темах ";
echo "";
// Ends Forum Post code

$members = dbrows($result);
if ($members != 0) {
$i = 1;
echo $locale['012'];
while($data = dbarray($result)) {
echo "<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a>";
if ($i != $members) echo ", ";
$i++;
}
echo " \n";
} else {
echo $locale['013']." \n";
}

$online = dbcount("(online_user)","online");
if ($settings['record_count'] < $online) {
$result = dbquery("UPDATE ".$db_prefix."settings SET record_datestamp='".time()."', record_count='$online'");
}
echo "Рекорд посещаемости форума - ".$settings['record_count'].", зафиксирован - ".showdate("longdate", $settings['record_datestamp'])." ";

echo " На форуме ".dbresult($facount, 0)." сообщений в ".dbresult($facount2, 0)." темах, оставленные ".$usersPosts." пользователями ";
$result = dbquery("SELECT user_id,user_name FROM ".$db_prefix."users ORDER BY user_joined DESC");
$total = dbrows($result);
$data = dbarray($result);
echo "Зарегистрировано пользователей: ".$total."\n";

if ($settings['admin_activation'] == "1") echo "".$locale['015'].dbcount("(user_id)", "users", "user_status='2'")." \n";
$data = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));

echo " Приветствуем нового пользователя <a href='".BASEDIR."profile.php?lookup=".$data['user_name']."' class='side'>".$data['user_name']."</a> \n";
//начало последний визит
$results = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='".$data['user_id']."'");
$datas = dbarray($results);
//$profile .= "Ваш последний визит: ".($datas['user_lastvisit'] != 0 ? showdate("longdate", $datas['user_lastvisit']) : никогда)."\n";
$profile .= "Ваш последний визит: ".($userdata['user_lastvisit'] != 0 ? showdate("longdate", $userdata['user_lastvisit']) : $locale['u049'])."";
//echo"Последний визит: ".ucwords(showdate("longdate", time()))." ";
echo $profile;
//конец последний визит

//еще статистика

$yourposts = ($useRealPosts ? dbcount("(post_id)", "posts", "post_author=".$userdata['user_id']) : $userdata['user_posts']);
$facount = dbcount("(post_id)", "posts");
$result = dbquery("SELECT tp.*, tf.* FROM ".$db_prefix."posts tp INNER JOIN ".$db_prefix."forums tf USING(forum_id) WHERE ".groupaccess('forum_access')." AND tp.post_datestamp>'$lastvisited'");

//if ($facount){
if ($yourposts == 0) {
$postInfo = "s".$facount."ы"." ";
} else {
$yourperc = number_format((($yourposts/$facount)*100),2);
$postInfo = " Вы оставили: ".$yourposts." сообщений, это ".$yourperc."% из всех постов форума ";
}
//} else {
//$postInfo = "No posts at all on this forum yet. ";
//}

echo $postInfo;
$activ = dbcount("(forum_id)", "posts", "post_author='".$userdata['user_id']."'");

$topflood = ($useRealPosts ? dbarray(dbquery("SELECT ".$db_prefix."users.*,count(post_id) AS user_posts
FROM ".$db_prefix."posts LEFT JOIN ".$db_prefix."posts ON ".$db_prefix."users.user_id = ".$db_prefix."posts.post_author
GROUP BY ".$db_prefix."users.user_id ORDER BY user_posts DESC LIMIT 0,1")) : dbarray(dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_posts DESC")));
echo"Наибольшая активность в ".$topflood['user_name']."";

$resultes = dbquery("SELECT tp.*, tf.* FROM ".$db_prefix."posts tp INNER JOIN ".$db_prefix."forums tf USING(forum_id) WHERE ".groupaccess('forum_access')." AND tp.post_datestamp>'$lastvisited'");
//if (dbrows($resultes) != 0){
$resultesw = dbquery("SELECT tp.*, tf.*, tu.user_id,user_name FROM ".$db_prefix."posts tp
INNER JOIN ".$db_prefix."forums tf USING(forum_id)
LEFT JOIN ".$db_prefix."users tu ON tp.post_author=tu.user_id
WHERE ".groupaccess('forum_access')." AND tp.post_datestamp>'$lastvisited' ORDER BY post_datestamp DESC LIMIT 0,1");
$data = dbarray($resultesw);
//echo" Последнее сообщение в теме \"<a href='".BASEDIR."forum/viewthread.php?forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."
;&pid=".$data['post_id']."#post_".$data['post_id']."'>".$data['post_subject']."</a>
\"";
echo" С момента вашего последнего визита ".dbrows($resultes)." новых сообщения, последнее сообщение в теме \"<a href='".BASEDIR."forum/viewthread.php?forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."
;&pid=".$data['post_id']."#post_".$data['post_id']."'>".$data['post_subject']."</a>
\"";
//конец
//}
echo" Наибольший флудер: <a href='".BASEDIR."profile.php?lookup=".$topPoster['user_id']."'>".$topPoster['user_name']."<
;/a>, с ".$topPoster['user_posts']." постами (".$postsDaily." постов в день)";

}
// End Online Users Panel Code

echo "</div></td>
</tr> 
</td></tr></td></tr></table>\n";