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/account/delete.php | 20 +++++++++-----------
 1 file changed, 9 insertions(+), 11 deletions(-)

(limited to 'public/account/delete.php')

diff --git a/public/account/delete.php b/public/account/delete.php
index af8a093..ecfcc80 100644
--- a/public/account/delete.php
+++ b/public/account/delete.php
@@ -1,5 +1,6 @@
 <?php
 include "../../src/utils.php";
+include_once "../../src/config.php";
 
 session_start();
 
@@ -10,26 +11,23 @@ if (!isset($_SESSION["user_id"])) {
 
 $id = $_SESSION["user_id"];
 
-$db = new SQLite3("../../database.db");
+$db = new PDO(DB_URL, DB_USER, DB_PASS);
 
-$stmt = $db->prepare("UPDATE emotes SET uploaded_by = NULL WHERE uploaded_by = :id");
-$stmt->bindValue(":id", $id);
-$stmt->execute();
+$stmt = $db->prepare("UPDATE emotes SET uploaded_by = NULL WHERE uploaded_by = ?");
+$stmt->execute([$id]);
 
-$stmt = $db->prepare("DELETE FROM connections WHERE user_id = :id");
-$stmt->bindValue(":id", $id);
-$stmt->execute();
+$stmt = $db->prepare("DELETE FROM connections WHERE user_id = ?");
+$stmt->execute([$id]);
 
-$stmt = $db->prepare("DELETE FROM users WHERE id = :id");
-$stmt->bindValue(":id", $id);
-$stmt->execute();
+$stmt = $db->prepare("DELETE FROM users WHERE id = ?");
+$stmt->execute([$id]);
 
 session_unset();
 session_destroy();
 
 setcookie("secret_key", "", time() - 1000);
 
-$db->close();
+$db = null;
 
 $path = "../static/userdata/avatars/$id";
 if (is_file($path)) {
-- 
cgit v1.2.3