1. extensia conform php 5 este depecrated (devalorizata ) asa ca trebuie sa va scoateti din cap prelurile din mysql_query()
2. <?php daca fisierul contine numai php nu mai inchdeti ?> nu este necesar si conform php5 nu se mai foloseste !
Am luat timp si am rescris codul daca apar probleme postati aici !
Continutul
- root/index.php | Afiseaza codul
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8"/>
<title>Extreamcs</title>
<script src="https://ajax.googleapis.com/ajax/libs/j ... "></script>
<script src="https://code.jquery.com/ui/1.11.3/jquer ... "></script>
<link rel="stylesheet" type="text/css" href="http://maxcdn.bootstrapcdn.com/bootswat ... ap.min.css"/>
<script src="http://maxcdn.bootstrapcdn.com/bootstra ... "></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/ ... "></script>
<script type="text/javascript">
var settimmer=0;$(function(){window.setInterval(function(){var timeCounter=$("b[id=show-time]").html(),updateTime=eval(timeCounter)-eval(1);$("b[id=show-time]").html(updateTime),0==updateTime&&(window.location="index.php")},1e3)}),$(document).ready(function(){$("#loadMe").click(function(){$("#myModal").modal("show")}),$("#SearchPlayers").click(function(){$("#SPModal").modal("show")}),$('[data-toggle="tooltip"]').tooltip({html:!0})});
</script>
<style type="text/css">
div.tooltip-inner {
text-align: center;
-webkit-border-radius: 0px;
-moz-border-radius: 0px;
border-radius: 0px;
margin-bottom: 6px;
background-color: #505050;
font-size: 14px;
max-width: 350px;
}
</style>
</head>
<body>
<?php
$admins = array('M0hikan', 'DeVe');
include("configuration/csa_function.php");
$limita = '10';
$query = CSA::getInstance()->sqli->query("SELECT SUM(playedTime) as `TotalHoursPlayed` FROM `player_time`;");
if($query->num_rows > 0) {
$zrow = $query->fetch_assoc();
}
$query = CSA::getInstance()->sqli->query("SELECT COUNT(steamid) as `TotalPlayers` FROM `player_time`;");
if($query->num_rows > 0) {
$trow = $query->fetch_assoc();
}
?>
<div class="container">
<div class="row">
<div class="page-header col-md-12" id="banner">
<div class="col-md-7">
<h1>Player time track</h1>
</div>
<div class="col-md-12">
<div class="col-md-1 pull-right">
<button id="SearchPlayers" class="btn btn-primary">Cauta jucatori</button>
</div>
</div>
<div id="foundPlayer" class="modal fade">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title"></h4>
</div>
<div class="modal-body">
<?php
if(isset($_POST['submit'])) {
$string = $_POST['srcCH'];
$query = CSA::getInstance()->sqli->query("SELECT `id`, `steamid`, `playedTime` FROM `player_time` WHERE `steamid` LIKE '%{$string}%';");
if($query->num_rows > 0) {
$row = $query->fetch_assoc();
}
$time = (CSA::getInstance()->convertToHoursMins($row['playedTime']));
print "
<div class='page-header'>
<h3 id='container'>Jucator cautat ".$string."</h3>
</div>
<p>".$row['steamid']." - ".$time['ora']." ".$time['minut']."</p>";
}
?>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div id="SPModal" class="modal fade">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">Cauta jucatori</h4>
</div>
<div class="modal-body">
<form action="" method="post">
<input type="text" size="24" name="srcCH" />
<input type="submit" name="submit" class="btn btn-primary" value="Cauta jucator" />
</form>
<?php
if(isset($_POST['submit'])) {
echo "<script type='text/javascript'>
$(function() {
$('#foundPlayer').modal('show');
});
</script>";
}
?>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<div class="col-md-3">
<blockquote>
(Update in <b id="show-time">3600</b> seconds)
<p><button id="loadMe" class="btn btn-success">Jucatori online</button></p>
</blockquote>
</div>
<div class="col-md-5">
<blockquote>
<p><span class="glyphicon glyphicon-globe"></span> <strong>Total ore jucate pe server de catre jucatori</strong></p>
<p><h4><?php print CSA::getInstance()->convertToHours($zrow['TotalHoursPlayed'], '%02d ore %02d minute'); ?></h4>
<small>Minutele sunt rotunjite.</small>
</p>
</blockquote>
</div>
<div class="col-md-4">
<blockquote>
<p><span class="glyphicon glyphicon-user"></span> <strong>Total jucatori server</strong></p>
<p><h4><?php print $trow['TotalPlayers']; ?> jucatori</h4>
<small>Jucatori steam si non-steam.</small>
</p>
</blockquote>
</div>
</div>
<div class="row">
<!-- table -->
<?php
echo "<table class='table table-striped table-hover'>
<thead>
<tr>
<th width='40'>#</th>
<th width='20'>Gametracker</th>
<th>Nume</th>
<th>Timp jucat</th>
</tr>
</thead>
<tbody>
<div class='col-md-3 pull-right'>
<ul class='pagination pagination-xs'>";
@$page = (!$_GET['page'] || $_GET['page'] < 0) ? "1" : $_GET['page'];
$page = ceil($page);
$limit = 14;
$start = $limit;
$end = $page*$limit-($limit);
$query = CSA::getInstance()->sqli->query("SELECT COUNT(*) as `players` FROM `player_time`;");
if($query->num_rows > 0) {
$getlist = $query->fetch_assoc();
}
$pages = ceil($getlist['players']/$limit);
$previous = ($page - 1 <= 0) ? "<li class='disabled'><a href='#'>« Prev</a></li>" : "<li><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".($page-1)."\">« Prev</a></li>";
$nextpage = ($page + 1 > $pages) ? "<li class='disabled'><a href='#'>Next »</a></li>" : "<li><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".($page + 1)."\">Next »</a></li>";
echo $previous;
for($i=1;$i<=$pages;$i++) {
$href = ($page == $i) ? "<li><a href='#'>".$i."</a></li>" : "<li class='active'><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".$i."\">".$i."</a></li>";
echo $href;
}
echo $nextpage;
echo "</ul>
</div>";
$query = CSA::getInstance()->sqli->query("SELECT `id`, `steamid`, `playedTime` FROM `player_time` ORDER BY `id` ASC LIMIT {$end},{$start};");
while($row = $query->fetch_assoc()){
//check if is admin
$adm = CSA::getInstance()->admin($row['steamid'], $admins);
$time = (convertToHoursMins($row['playedTime']));
print "<tr>
<td align='center'>{$row['id']}</td>
<td>
<a href='http://www.gametracker.com/search/?sear ... uery={$row['steamid']}' target='_blank' class='btn btn-default btn-xs'>Find on GT</a>
</td>
<td>
<span class='{$adm['class']}'>{$adm['rank']}</span>
<span data-toggle='tooltip' data-placement='right' title='' data-html='true' data-original-title='<blockquote>{$row['steamid']} ({$adm['rank']})<small>A jucat {$time['ora']} {$time['minut']}</small></blockquote>'>{$row['steamid']}</span>
</td>
<td><span class='glyphicon glyphicon-time'></span> {$time['ora']} {$time['minut']}</td>
</tr>";
}
echo "</tbody>
</table>
<div class='col-md-3 pull-right'>
<ul class='pagination pagination-xs'>";
@$page = (!$_GET['page'] || $_GET['page'] < 0) ? "1" : $_GET['page'];
$page = ceil($page);
$limit = 14;
$start = $limit;
$end = $page*$limit-($limit);
$query = CSA::getInstance()->sqli->query("SELECT COUNT(*) as `players` FROM `player_time`;");
if($query->num_rows > 0) {
$getlist = $query->fetch_assoc();
}
$pages = ceil($getlist['players']/$limit);
$previous = ($page-1 <= 0) ? "<li class='disabled'><a href='#'>« Prev</a></li>" : "<li><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".($page-1)."\">« Prev</a></li>";
$nextpage = ($page+1 > $pages) ? "<li class='disabled'><a href='#'>Next »</a></li>" : "<li><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".($page+1)."\">Next »</a></li>";
echo $previous;
for($i=1;$i<=$pages;$i++){
$href = ($page == $i) ? "<li><a href='#'>".$i."</a></li>" : "<li class='active'><a href=\"./categories-".CSA::getInstance()->sqli->real_escape_string($_GET['id'])."-".$i."\">".$i."</a></li>";
echo $href;
}
echo $nextpage;
echo "</ul>
</div>";
?>
</div>
<div id="myModal" class="modal fade">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title">Jucatori online</h4>
</div>
<div class="modal-body">
<table class="table table-striped table-hover">
<thead>
<tr><th width="40">#</th><th width="60">Name</th><th>Score</th><th>Time</th></tr>
</thead>
<tbody>
<?php
$xml = simplexml_load_file("http://api.gametracker.rs/demo/xml/serv ... .62:27015/");
$players = $xml->xpath('//player');
foreach($players as $player) {
echo "<tr>
<td>{$player->pid}</td>
<td>{$player->name}</td>
<td>{$player->score}</td>
<td>{$player->time}</td>
</tr>";
}
?>
</tbody>
</table>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
- root/configuration/csa_function.php | Afiseaza codul
<?php
class CSA {
private static $instance = null;
var $sqli = null;
public static function getInstance () {
if(isset(self::$instance) == null) {
self::$instance = new self();
}
return self::$instance;
}
private function __construct () {
require_once("config.php");
if(!$this->sqli = new mysqli(MYSQLI_HOST, MYSQLI_USER, MYSQLI_PASSWORD, MYSQLI_DATABASE)) {
exit("There was a problems whit connecting to the database, please report to your administrator to fix it.");
(bool)true;
}
$this->sqli->set_charset(MYSQLI_ENCODING);
}
function convertToHoursMins($time) {
settype($time, 'integer');
if ($time < 1) {
return;
}
$minutes = ($time % 60);
$hours = floor($time / 60);
$tFormat = array();
if($hours > 1){
$tFormat['ora'] = $hours.' ore';
} elseif($hours < 1) {
$tFormat['ora'] = $hours.' ore';
} elseif($hours == 1){
$tFormat['ora'] = $hours.' ora';
}
if($minutes > 1) {
$tFormat['minut'] = $minutes.' minute';
} elseif($minutes < 1) {
$tFormat['minut'] = $minutes.' minute';
} elseif($minutes == 1){
$tFormat['minut'] = $minutes.' minut';
}
return $tFormat;
}
function admin($search, $array){
$admin = "";
if(in_array($search, $array)){
$admin .= "Admin";
$gClass = 'label label-primary';
} else {
$admin .= "Player";
$gClass = 'label label-default';
}
return $value = array('rank' => $admin, 'class' => $gClass);
}
function convertToHours($time) {
settype($time, 'integer');
if ($time < 1) {
return;
}
$minutes = ($time % 60);
$hours = floor($time / 60);
$days = round($hours / 24);
$return = '';
if($hours > 1){
$return .= $hours . ' ore' . ($hours == 1 ? '' : ''). ' ';
} else {
$return .= $hours . ' ora' . ($hours == 1 ? '' : ''). ' ';
}
$return = trim($return);
return $return;
}
}
- root/configuration/config.php | Afiseaza codul
<?php
//====================================================================
// @license --> Please see the EULA file for the full End User License Agreement.
// @author --> Kommendante
// @Developer --> Cristian G. Danasel [ DeVe ]
//====================================================================
//------------------------------------------------------------------------------------------------
// MYSQLI Host is the MySQLi Database Hostname
// Default: 'localhost'
define('MYSQLI_HOST', 'localhost');
// MYSQLI User is the MySQLi Database Username
define('MYSQLI_USER', '');
// MYSQLI Password is the MySQLi Database Password
define('MYSQLI_PASSWORD', '');
// MSQLI Database is the MySQLi Database Name
define('MYSQLI_DATABASE', '');
// MYSQLI Encoding is the MySQLi Encoding on insert
define('MYSQLI_ENCODING', 'utf8');
//------------------------------------------------------------------------------------------------
//====================================================================
// Copyright (c) 2012 - 2015 All Rights Reserved.
//====================================================================
Nu am stat sa curat tot codul dar am optimizat aproape tot !
Aici aveti un download url
Success!
http://www.girlshare.ro/ - > remove
Imi cer scuze pentru ca nu am fost atent la detaliu cu paginatia!
Fixed in aceasta arhiva !
http://www.girlshare.ro/35117239.3
Am adaugat detectie in loc sa mai fie scris
- root/index.php | Afiseaza codul
<!-- REMOVE -->
@$page = (!$_GET['page'] || $_GET['page'] < 0) ? "1" : $_GET['page'];
$page = ceil($page);
<!-- REMOVE -->
<!-- ADD -->
if(!isset($_REQUEST['page']) || empty($_REQUEST['page'])) {
$_REQUEST['page'] = 1;
}
$page = ceil($_REQUEST['page']);
<!-- ADD -->
