pBase/players.php at master · f37ch/pBase · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<?php include("components/head.php");
$_GET["page"]="players";
include("components/header.php");
if (!getSetting("enable_players",true)) {
    header("Location: /");
    exit;
}
$page=isset($_GET["pg"])?intval($_GET["pg"]):1;
$limit=12;
$start=($page-1)*$limit;
$stypes=["Имя"=>"name","Последняя игра"=>"last_played","Регистрация"=>"registered","Последний онлайн"=>"last_online"];
$allowed_columns=array_values($stypes);
$sort_column="last_played";
if (isset($_GET["type"]) && in_array($_GET["type"],$allowed_columns,true)){
    $sort_column=$_GET["type"];
}
$where="";
if (isset($_GET["search"])&&$_GET["search"]!==""){
  $search=$database->real_escape_string($_GET["search"]);
  if (preg_match('/^7656\d{13}$/',$search)){
      $where="WHERE steamid = '$search'";
  } else {
      $where="WHERE name LIKE '%$search%'";
  }
}
$result=$database->query("SELECT * FROM users $where ORDER BY $sort_column DESC LIMIT $start, $limit")??NULL;
$countres=$database->query("SELECT count(steamid) AS cnt FROM users $where") ?? NULL;
$fetchedcount=$countres->fetch_all(MYSQLI_ASSOC);
$total=$fetchedcount[0]["cnt"];
$pages=ceil($total/$limit);
$prev=$page>1?$page-1:1;
$nxt=$page!=$pages?$page+1:$pages;
?>
<script>
href=new URL(location);
</script>
<div class="d-flex justify-content-between align-items-center mb-4">
  <div class="input-group" data-aos="flip-right" data-aos-delay="100" style="width: 100%;">
    <span class="input-group-text" id="da"><i class="bi bi-steam"></i></span>
    <input type="text" onchange="href.searchParams.delete('pg');href.searchParams.set('search',this.value); location = href.toString()" class="form-control shadow-none" placeholder="steamid64/ник" value="<?php echo $_GET["search"]??""?>" aria-describedby="da" >
    <select class="form-select shadow-none" name="svid" title="сортировка" style="width: 20px" onchange="href.searchParams.delete('pg');href.searchParams.set('type',this.value); location = href.toString()">
      <?php foreach ($stypes as $label => $type):?>
        <option value="<?php echo $type; ?>" <?php
            if ((isset($_GET["type"])&&$_GET["type"]==$type)||(!isset($_GET["type"])&&$type=="last_played")) echo "selected";
        ?>><?php echo $label; ?></option>
      <?php endforeach;?>
    </select>
    <span class="btn btn-secondary fw-bold bg-white pulse-green"><i class="bi bi-person-circle"></i> Всего игроков: <?=$total?></span>
  </div>
</div>
<div class="row d-flex flex-wrap justify-content-around column-gap-1 d-flex">
<?php
$result->data_seek(0);
$stype=$_GET["type"]??null;
while ($row=$result->fetch_assoc()):?>
    <div class="card mb-4 text-black hoverscale stuser" style="border-radius:25px; width:18em; cursor: pointer; display:inline-block;">
        <div class="card-body">
            <div class="row p-1 mb-1">
                <div class="col text-center">
                    <img class="col-auto rounded-circle mb-3" style="border: 4px solid #000;" src="<?=htmlspecialchars($row["avatarfull"]??"",ENT_QUOTES,"UTF-8")?>" onclick="location.href='/profile.php?id=<?=$row['steamid']?>'"><!-- width: 80px; adjust in style?-->
                    <h4 class='title my-0'><?=htmlspecialchars($row["name"]??"Unknown",ENT_QUOTES,"UTF-8")?></h4>

                    <button type="button" class="btn btn-sm btn-outline-secondary mt-2" style="font-weight: bold; width:100%" onclick="navigator.clipboard.writeText('<?=$row["steamid"]?>'); this.innerHTML='<i class=&quot;bi bi-steam&quot;></i> Скопировано!'; setTimeout(()=>{this.innerHTML='<i class=&quot;bi bi-steam&quot;></i> Копировать sid64';},1200);"><i class="bi bi-steam"></i> Копировать sid64</button>

                    <?php if ($stype==="registered"):?>
                        <small class="title" style="color:#46B7AA; font-weight: bold;">
                            Регистрация: <?=$row["registered"]?date("Y-m-d",$row["registered"]):"Никогда"?>
                        </small>
                    <?php elseif ($stype==="last_online"):?>
                        <small class="title" style="color:#46B7AA; font-weight: bold;">
                            Последний онлайн: <?=$row["last_online"]?elapsed($row["last_online"]):"Никогда"?>
                        </small>
                    <?php else: ?>
                        <small class="title" style="color:#46B7AA; font-weight: bold;">
                            Последняя игра: <?=$row["last_played"]?elapsed($row["last_played"]):"Никогда"?>
                        </small>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>
<?php endwhile; ?>
</div>

<?php if ($pages>1){ ?>
<ul class="pagination justify-content-left" data-aos-offset="0" data-aos="fade-up" data-aos-delay="200">
  <?php if($page>4) { ?>
    <li class="page-item" onclick="href.searchParams.set('pg',1); location = href.toString()">
      <a class="page-link text-black shadow-none">
        <span aria-hidden="true">&laquo;</span>
      </a>
    </li>
  <?php } ?>
  <li class="page-item <?= $page==1?"disabled":""; ?>" onclick="if (!this.classList.contains('disabled')){href.searchParams.set('pg','<?= $prev; ?>'); location = href.toString()}">
    <a class="page-link text-black shadow-none">
      <span aria-hidden="true">Prev</span>
    </a>
  </li>
  <?php for($i = max(1,$page-3); $i < min($pages+1,$page+3); $i++) { ?>
		<li class="page-item" onclick="href.searchParams.set('pg','<?= $i; ?>'); location = href.toString()"><a class="page-link shadow-none text-black <?= $page==$i?"active":""; ?>" ><?= $i; ?></a></li>
	<?php }; ?>
  <li class="page-item <?= $page==$pages?"disabled":""; ?>"onclick="if (!this.classList.contains('disabled')){href.searchParams.set('pg','<?= $nxt; ?>'); location = href.toString()}">
    <a class="page-link text-black shadow-none">
      <span aria-hidden="true">Next</span>
    </a>
  </li>
  <?php if($page<$pages-2) { ?>
    <li class="page-item" onclick="href.searchParams.set('pg','<?=$pages;?>'); location = href.toString()">
      <a class="page-link text-black shadow-none">
        <span aria-hidden="true">&raquo;</span>
      </a>
    </li>
  <?php } ?>
</ul>
<?php } ?>
<?php include("components/footer.php") ?>