From afcc61d3e035e9343a16abf58eb8bcfc5b563925 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sat, 25 Oct 2025 21:05:55 +0500
Subject: feat: save sounds in the database

---
 sounds/upload.php | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'sounds')

diff --git a/sounds/upload.php b/sounds/upload.php
index 035775b..eecf9c5 100644
--- a/sounds/upload.php
+++ b/sounds/upload.php
@@ -3,6 +3,8 @@ include_once $_SERVER['DOCUMENT_ROOT'] . '/lib/config.php';
 include_once $_SERVER['DOCUMENT_ROOT'] . '/lib/sounds.php';
 
 if ($_SERVER['REQUEST_METHOD'] == 'POST') {
+    $db = new PDO(DB_URL, DB_USER, DB_PASS);
+
     try {
         if (!isset($_FILES['file'], $_POST['name'], $_POST['tos'])) {
             throw new RuntimeException("Not a valid request.");
@@ -30,10 +32,19 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') {
             mkdir(SOUND_DIRECTORY, 0777, true);
         }
 
-        compress_sound($file['tmp_name'], sprintf('%s/test.ogg', SOUND_DIRECTORY));
+        $db->prepare('INSERT INTO sounds(code) VALUES (?)')
+            ->execute([$_POST['name']]);
+
+        $id = $db->lastInsertId();
+
+        compress_sound($file['tmp_name'], sprintf('%s/%s.ogg', SOUND_DIRECTORY, $id));
 
         exit("Uploaded!");
     } catch (Exception $e) {
+        if (isset($id)) {
+            $db->prepare('DELETE FROM sounds WHERE id = ?')
+                ->execute([$id]);
+        }
         exit($e->getMessage());
     }
 }
-- 
cgit v1.2.3