Демо:
Ако искате да имате иконките като на снимката, трябва да използвате fontawesome.
Кода:
Код: Избери целия код
<?php
// total anonymous
$mysql=mysqli_query($conn,"select session_user_id,COUNT(session_user_id) as count_sess_anony from `$bb_db`.".$bb_prefix."_sessions s INNER JOIN `$bb_db`.".$bb_prefix."_users u ON u.user_id = s.session_user_id WHERE session_user_id = 1 AND (session_time + 300) > UNIX_TIMESTAMP(NOW())") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$online_sessions_anony = $fetchrow['count_sess_anony'];
// total users
$mysql = mysqli_query($conn,"SELECT count(user_id) as total_users FROM `$bb_db`.".$bb_prefix."_users WHERE group_id!=6 AND group_id!=1 AND user_type!=1") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$total_users = $fetchrow['total_users'];
// total topics
$mysql = mysqli_query($conn,"SELECT count(topic_id) as total_topics FROM `$bb_db`.".$bb_prefix."_topics WHERE topic_posts_approved = '1'") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$total_topics = $fetchrow['total_topics'];
// total forums
$mysql = mysqli_query($conn,"SELECT count(forum_id) as total_forums FROM `$bb_db`.".$bb_prefix."_forums WHERE forum_type=1") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$total_forums = $fetchrow['total_forums'];
// total posts
$mysql = mysqli_query($conn,"SELECT count(post_id) as total_posts FROM `$bb_db`.".$bb_prefix."_posts WHERE post_visibility=1") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$total_posts = $fetchrow['total_posts'];
// total bans
$mysql = mysqli_query($conn,"SELECT count(ban_id) as total_banned FROM `".$bb_prefix."_banlist`") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$total_banned = $fetchrow['total_banned'];
// last user
$mysql = mysqli_query($conn,"SELECT * FROM `".$bb_prefix."_users` ORDER BY user_id DESC LIMIT 1") or die(mysqli_error($conn));
$fetchrow = mysqli_fetch_assoc($mysql);
$last_user = $fetchrow['username'];
$last_userid = $fetchrow['user_id'];
echo "
<i class='fa fa-plus' aria-hidden='true'></i> Най-нов: <a href='$forum_path//memberlist.php?mode=viewprofile&u=$last_userid'>$last_user</a><br />
<i class='fa fa-minus' aria-hidden='true'></i> Общо гости: $online_sessions_anony<br />
<i class='fa fa-users' aria-hidden='true'></i> Общо потребители: $total_users<br />
<i class='fa fa-pencil' aria-hidden='true'></i> Общо теми: $total_topics<br />
<i class='fa fa-bars' aria-hidden='true'></i> Общо раздели: $total_forums<br />
<i class='fa fa-comments-o' aria-hidden='true'></i> Общо мнения: $total_posts<br />
<i class='fa fa-ban' aria-hidden='true'></i> Общо баннати: $total_banned";
?>