blob: 841127b5ee54ad32245069c13c4eaaa9d8f11aae (
plain) (
blame)
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
|
<?php
/* hitler-clicker
* api for ranking users
* © 2025 hitler.rip <git@hitler.rip>
* licensed under AGPLv3-or-later; see LICENSE.md for more information
*/
header('Content-Type: application/json; charset=UTF-8');
try {
$pdo = new PDO("mysql:host=127.0.0.1;dbname=hitlerclicker", "root", "aA1234Aa");
} catch(PDOException $e) {
die('{ "status": "database offline" }');
};
$query = $pdo->prepare("SELECT name, team, clicks FROM users WHERE name LIKE '%' ORDER BY clicks DESC");
$query -> execute();
$found = $query->fetchALL(PDO::FETCH_ASSOC);
echo '{ ';
$i = 0;
foreach($found as $user):
$i++;
if ($i === sizeof($found)) {
echo " \"$user[name]\": { \"team\": \"$user[team]\", \"clicks\": \"$user[clicks]\" } ";
} else {
echo " \"$user[name]\": { \"team\": \"$user[team]\", \"clicks\": \"$user[clicks]\" }, ";
};
endforeach;
echo ' }';
?>
|
