diff options
Diffstat (limited to 'backend/index.php')
| -rw-r--r-- | backend/index.php | 37 |
1 files changed, 35 insertions, 2 deletions
diff --git a/backend/index.php b/backend/index.php index dead696..2aba190 100644 --- a/backend/index.php +++ b/backend/index.php @@ -4,14 +4,47 @@ 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) { + echo "$e"; die('{ "status": "database offline" }'); }; +/* +$query = $pdo->prepare("DROP TABLE `hitlerclicker`.`stats`"); +$query->execute(); +$query = $pdo->prepare("DROP TABLE `hitlerclicker`.`users`"); +$query->execute(); +*/ + $query = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`stats` ( `team` VARCHAR(256) NOT NULL DEFAULT uuid() , `clicks` INT(128) unsigned zerofill NOT NULL DEFAULT '0', PRIMARY KEY (`team`) ) ENGINE = InnoDB;"); $query->execute(); -$query = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`users` ( `name` VARCHAR(256) NOT NULL DEFAULT uuid() , `password` VARCHAR(256) NOT NULL , `team` VARCHAR(256) NOT NULL DEFAULT 'axis' , `clicks` INT(128) unsigned zerofill NOT NULL DEFAULT '0', PRIMARY KEY (`name`) ) ENGINE = InnoDB;"); +$query = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`users` ( `name` VARCHAR(256) NOT NULL DEFAULT uuid() , `password` VARCHAR(256) NOT NULL , `token` VARCHAR(256) NOT NULL DEFAULT uuid() , `team` VARCHAR(256) NOT NULL DEFAULT 'axis' , `clicks` INT(128) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`name`) ) ENGINE = InnoDB;"); +$query->execute(); + +$query = $pdo->prepare("INSERT IGNORE INTO `stats` (`team`) VALUES (:team)"); +$query->execute([ "team" => "axis" ]); +$query = $pdo->prepare("INSERT IGNORE INTO `stats` (`team`) VALUES (:team)"); +$query->execute([ "team" => "allies" ]); +$query = $pdo->prepare("INSERT IGNORE INTO `stats` (`team`) VALUES (:team)"); +$query->execute([ "team" => "soviet" ]); + +$query = $pdo->prepare("SELECT team, clicks FROM stats WHERE team LIKE '%' ORDER BY clicks DESC"); $query->execute(); +$found = $query->fetchALL(PDO::FETCH_ASSOC); + +echo '{ "status": "online", '; + +$i = 0; +foreach($found as $row): + + $i++; + if ($i === sizeof($found)) { + echo " \"$row[team]\": \"$row[clicks]\" "; + } else { + echo " \"$row[team]\": \"$row[clicks]\", "; + }; + +endforeach; -echo '{ "status": "online" }'; +echo ' }'; ?> |