From 5fc857449011f76ed7677aad40576790310d23e1 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sun, 20 Apr 2025 16:06:19 +0500
Subject: feat: moved from SQLite to MySQL

---
 public/index.php | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

(limited to 'public/index.php')
diff --git a/public/index.php b/public/index.php
index 14d2c9a..5619208 100644
--- a/public/index.php
+++ b/public/index.php
@@ -1,3 +1,6 @@
+<?php
+include_once "../src/config.php";
+?>
 <html>
 
 <head>
@@ -25,11 +28,9 @@
 
             <div class="counter">
                 <?php
-                $db = new SQLite3("../database.db");
+                $db = new PDO(DB_URL, DB_USER, DB_PASS);
                 $results = $db->query("SELECT COUNT(*) FROM emotes");
-                $count = $results->fetchArray()[0];
-
-                $db->close();
+                $count = $results->fetch()[0];
 
                 foreach (str_split($count) as $c) {
                     echo "<img src=\"/static/img/counter/$c.png\" alt=\"\" />";
-- 
cgit v1.2.3

