/Templates/Admin/server_info.tpl
Smarty Template | 150 lines | 149 code | 1 blank | 0 comment | 0 complexity | c2e87d76329c9b104a96413c63831490 MD5 | raw file
- <?php
- #################################################################################
- ## ##
- ## -= YOU MUST NOT REMOVE OR CHANGE THIS NOTICE =- ##
- ## ##
- ## --------------------------------------------------------------------------- ##
- ## ##
- ## Project: ZravianX ##
- ## Version: 2011.11.10 ##
- ## Filename: Templates/Admin/server_info.tpl ##
- ## Developed by: Dzoki ##
- ## Edited by: ZZJHONS ##
- ## License: Creative Commons BY-NC-SA 3.0 ##
- ## Copyright: ZravianX (c) 2011 - All rights reserved ##
- ## URLs: http://zravianx.zzjhons.com ##
- ## Source code: http://www.github.com/ZZJHONS/ZravianX ##
- ## ##
- #################################################################################
- $tribe1 = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE tribe = 1");
- $tribe2 = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE tribe = 2");
- $tribe3 = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE tribe = 3");
- $tribe4 = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE tribe = 4");
- $tribe5 = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE tribe = 5");
- $tribes = Array(mysql_num_rows($tribe1),mysql_num_rows($tribe2),mysql_num_rows($tribe3),mysql_num_rows($tribe4),mysql_num_rows($tribe5));
- ?>
- <br />
- <br />
- <table id="profile">
- <thead>
- <tr>
- <th colspan="2">Players Stadistics</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>Registered players</td>
- <td><?php echo $users; ?></td>
- </tr>
- <tr>
- <td>Active players</td>
- <td>
- <?php
- $result = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."active");
- $num_rows = mysql_num_rows($result);
- echo $num_rows;
- ?>
- </td>
- </tr>
- <tr>
- <td>Players online</td>
- <td>
- <?php
- $t =time();
- $result = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE ".$t." - timestamp < 300") or die(mysql_error());;
- $num_rows = mysql_num_rows($result);
- echo $num_rows;
- ?>
- </td>
- </tr>
- <tr>
- <td>Players Banned</td>
- <td>
- <?php
- $result = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users WHERE access = 0");
- $num_rows = mysql_num_rows($result);
- echo $num_rows;
- ?>
- </td>
- </tr>
- <tr>
- <td>Villages settled</td>
- <td>
- <?php
- $result = mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."vdata");
- $num_rows = mysql_num_rows($result);
- echo $num_rows;
- ?>
- </td>
- </tr>
- </tbody>
- </table>
- <br />
- <table id="profile">
- <thead>
- <tr>
- <th colspan="3">Player Information</th>
- </tr>
- <td class="b">Tribe</td>
- <td class="b">Registered</td>
- <td class="b">Percent</td>
- </thead>
- <tbody>
- <tr>
- <td>Romans</td>
- <td><?php echo $tribes[0]; ?></td>
- <td>
- <?php
- $percents = 100*($tribes[0] / $users);
- echo $percents = intval ($percents);
- echo "%";
- ?>
- </td>
- </tr>
- <tr>
- <td>Teutons</td>
- <td><?php echo $tribes[1]; ?></td>
- <td>
- <?php
- $percents = 100*($tribes[1] / $users);
- echo $percents = intval ($percents);
- echo "%";
- ?>
- </td>
- </tr>
- <tr>
- <td>Gauls</td>
- <td><?php echo $tribes[2]; ?></td>
- <td>
- <?php
- $percents = 100*($tribes[2] / $users);
- echo $percents = intval ($percents);
- echo "%";
- ?>
- </td>
- </tr>
- <tr>
- <td>Nature</td>
- <td><?php echo $tribes[3]; ?></td>
- <td>
- <?php
- $percents = 100*($tribes[3] / $users);
- echo $percents = intval ($percents);
- echo "%";
- ?>
- </td>
- </tr>
- <tr>
- <td>Natars</td>
- <td><?php echo $tribes[4]; ?></td>
- <td>
- <?php
- $percents = 100*($tribes[4] / $users);
- echo $percents = intval ($percents);
- echo "%";
- ?>
- </td>
- </tr>
- </tbody>
- </table>