From 6b3e92478de8225ac1d2db9deb448c65d4732fca Mon Sep 17 00:00:00 2001 From: hitlerrip Date: Sat, 2 Aug 2025 22:20:13 +0200 Subject: anon clicks - changed plans and simply added a variable called "fromanon" to each team that tracks anonymous clicks --- backend/index.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/backend/index.php b/backend/index.php index dc97812..844e0f8 100644 --- a/backend/index.php +++ b/backend/index.php @@ -15,13 +15,13 @@ try { }; /* +*/ $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 = $pdo->prepare("CREATE TABLE IF NOT EXISTS `hitlerclicker`.`stats` ( `team` VARCHAR(256) NOT NULL DEFAULT uuid() , `clicks` INT(128) unsigned NOT NULL DEFAULT '0' , `fromanon` INT(128) unsigned 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 , `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(); -- cgit v1.2.3