[УРОК] Проста статистика на phpBB за писан сайт

[NecheB]

Автор HybridMind
Демо:


Ако искате да имате иконките като на снимката, трябва да използвате 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";
         ?>