From 3c0ebfbbcd9d41b936ede928af05db9f15733d1a Mon Sep 17 00:00:00 2001
From: hitlerrip <git@hitler.rip>
Date: Tue, 29 Jul 2025 19:17:50 +0200
Subject: init

base to build this game off of
---
 backend/docker-test-env/compose.yml | 10 ++++++++++
 backend/index.php                   | 17 +++++++++++++++++
 2 files changed, 27 insertions(+)
 create mode 100644 backend/docker-test-env/compose.yml
 create mode 100644 backend/index.php

(limited to 'backend')

diff --git a/backend/docker-test-env/compose.yml b/backend/docker-test-env/compose.yml
new file mode 100644
index 0000000..fd109f9
--- /dev/null
+++ b/backend/docker-test-env/compose.yml
@@ -0,0 +1,10 @@
+services:
+  db:
+    image: mariadb:11
+    environment:
+      MARIADB_ROOT_PASSWORD: aA1234Aa
+      MARIADB_USER: db
+      MARIADB_PASSWORD: aA1234Aa
+      MARIADB_DATABASE: hitlerclicker
+    ports:
+      - 3306:3306
diff --git a/backend/index.php b/backend/index.php
new file mode 100644
index 0000000..dead696
--- /dev/null
+++ b/backend/index.php
@@ -0,0 +1,17 @@
+<?php
+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("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->execute();
+
+echo '{ "status": "online" }';
+
+?>
-- 
cgit v1.2.3