index.php - panel

<?php
if(!defined('panel'))
	die('Nope.');

			$qz = Config::$g_con->prepare('SELECT * FROM `updates` ORDER BY date DESC LIMIT 1');
			$qz->execute();
			$update = $qz->fetch(PDO::FETCH_OBJ);
      $updatetext = htmlspecialchars($update->text, ENT_COMPAT);

      $su = Config::$g_con->prepare('SELECT * FROM `supdates` ORDER BY date DESC LIMIT 1');
      $su->execute();
      $supdate = $su->fetch(PDO::FETCH_OBJ);
      $supdates = htmlspecialchars($supdate->text, ENT_COMPAT);
?>
<div id="fb-root"></div>


<?php
$q = Config::$g_con->prepare('SELECT * FROM `users` WHERE `name` = ?');
$q->execute(array(Config::$_url[1]));

$data = $q->fetch(PDO::FETCH_OBJ);
$houses = Config::rows('houses');
$businesses = Config::rows('bizz');
$cars = Config::rows('cars');

?>
<title><?php echo Config::$_SITE_NAME ?></title>

<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>Dashboard</h1>
      <ol class="breadcrumb">
        <li><a href="<?php echo Config::$_PAGE_URL ?>"><i class="fa fa-dashboard"></i> Home</a></li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="content">
      <!-- Small boxes (Stat box) -->
	  <?php // if(isset($_SESSION['msg'])) { echo $_SESSION['msg']; $_SESSION['msg'] = ''; } ?>
     <div class="row">
          <div class="col-md-12">
            <div class="panel panel-default">
              <div class="panel-body">
                <div class="col-md-3 col-sm-6 col-xs-12" style="margin-bottom: -15px;">
                  <div class="info-box bg-red">
                    <span class="info-box-icon"><i class="ion ion-android-person"></i></span>

                    <div class="info-box-content">
                      <span class="info-box-text">Online <a href="<?php echo Config::$_PAGE_URL; ?>online" style="color: #f4f4f4;"> <i class="fa fa-external-link"></i></a></span>
                      <?php

         	        $q = Config::$g_con->prepare("SELECT * FROM `Jucatori`");
                        $q->execute();

                        $procent = $q->RowCount() / Config::$_SERVER_SLOTS;
                        $procent2 = $procent * 250;
                      ?>
                      <span class="info-box-number"><?php echo $q->RowCount() ?>/<?php echo Config::$_SERVER_SLOTS; ?></span>
                        <div class="progress">
                          <div class="progress-bar" style="width: <?php echo $procent2; ?>%"></div>
                        </div>
                        <?php
                          $q = Config::$g_con->prepare("SELECT * FROM `users`");
                          $q->execute();

                          $qs = Config::$g_con->prepare("SELECT * FROM `bans`");
                          $qs->execute();
                        ?>
                        <span class="progress-description"><?php echo $q->RowCount(); ?> accounts</span>
                    </div>
                    <!-- /.info-box-content -->
                  </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12"  style="margin-bottom: -15px;">
                  <div class="info-box bg-green">
                    <span class="info-box-icon"><i class="ion ion-ios-home-outline"></i></span>

                    <div class="info-box-content">
                      <span class="info-box-text">Houses<a href="<?php echo Config::$_PAGE_URL; ?>houses" style="color: #f4f4f4;"> <i class="fa fa-external-link"></i></a></span>
                      <?php
                        $q = Config::$g_con->prepare("SELECT * FROM `houses` WHERE `Owner` != 'AdmBot'");
                        $q->execute();

                        $ownedhouses = $q->rowCount();
                      ?>
                      <span class="info-box-number"><?php echo $houses; ?></span>

                        <span class="progress-description"><?php echo $ownedhouses ?> houses are owned</span>
                    </div>
                    <!-- /.info-box-content -->
                  </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12"  style="margin-bottom: -15px;">
                  <div class="info-box bg-yellow">
                    <span class="info-box-icon"><i class="ion ion-cash"></i></span>

                    <div class="info-box-content">
                      <span class="info-box-text">Business<a href="<?php echo Config::$_PAGE_URL; ?>business" style="color: #f4f4f4;"> <i class="fa fa-external-link"></i></a></span>
                      <span class="info-box-number"><?php echo $businesses; ?></span>
                      <?php
                        $q = Config::$g_con->prepare("SELECT * FROM `bizz` WHERE `Owner` != 'AdmBot'");
                        $q->execute();

                        $ownedbiz = $q->rowCount();
                      ?>
                        <span class="progress-description"><?php echo $ownedbiz ?> business are owned</span>
                    </div>
                    <!-- /.info-box-content -->
                  </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12" style="margin-bottom: -15px;">
                  <div class="info-box bg-purple">
                    <span class="info-box-icon"><i class="ion ion-android-car"></i></span>
                    <?php
                      $q = Config::$g_con->prepare("SELECT * FROM `cars`");
                      $q->execute();
                      $vipcars = $cars - $q->RowCount();
                    ?>
                    <div class="info-box-content">
                      <span class="info-box-text">Vehicles<a href="<?php echo Config::$_PAGE_URL; ?>vehicles" style="color: #f4f4f4;"> <i class="fa fa-external-link"></i></a></span>
                      <span class="info-box-number"><?php echo $cars; ?></span>
                      <span class="progress-description"><?php echo $cars ?> normal vehicles</span>
                    </div>

                    <!-- /.info-box-content -->
                  </div>
                </div>
              </div>
            </div>
        </div><div class="col-md-8">
			<div class="nav-tabs-custom">
            <ul class="nav nav-tabs pull-right">
              <li class="active"><a href="#faction" data-toggle="tab" aria-expanded="false">Factions History</a></li>
              <li class=""><a href="#update" data-toggle="tab" aria-expanded="false">Updates</a></li>
              <li class="pull-left header"><i class="fa fa-rss"></i> Server</li>
            </ul>
            <div class="tab-content">
              <div class="tab-pane active" id="faction">
                <?php
                  $q = Config::$g_con->prepare('SELECT * FROM `faction_logs` ORDER BY `id` DESC Limit 10');
                  $q->execute();
				  echo "<ul class = 'timelines timelines-inverse'>";
                  while($row = $q->fetch(PDO::FETCH_OBJ)) {
                    echo
                    "
                    <li>"; ?>
					<img src="<?php echo Config::$_PAGE_URL ?>resources/avatars/<?php echo Config::getData('users', 'CChar', $row->player) ?>.png" class="img-circle"
						style="border: 2px solid #e2e2e2;">
						<?php
						echo "
						<div class='timelines-item'
							style='margin-top: -41px; border: 1px solid #e2e2e2; background: #fbfbfb; color: #797979;'>
							<span class='time'>
								<i class='fa fa-clock-o'></i> ";
								echo Config::timeAgo($row->time);
							echo "</span>
							<div class='timelines-body'>
								{$row->Text}
							</div>
						</div>
					</li><br>";
                  }
                ?>
              </ul></div>
              <div class="tab-pane" id="update">
                <div class="box-header with-border">
					<i><small class="pull-right">posted on <?php echo $update->date; ?></small></i>
					<a href="<?php echo Config::$_PAGE_URL ?>update/list"><b style="font-size:17px"><?php echo $update->name; ?></b></a>

				</div>
				<div class="box-body">
					<?php echo $update->text ?>
					<hr>
					<center><a href="<?php echo Config::$_PAGE_URL ?>update/list">See all</a></center>
				</div>
              </div>
            </div>
          </div>
        </div>
        <!-- /.Left col -->
        <!-- right col (We are only adding the ID to make the widgets sortable)-->

       <section class="col-md-4 connectedSortable">
        </div>
        </section>
      </div>
    </section>
  </div>