<?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 ' }';

?>