From f402e0c96a52c73ab390b76f637af3ccde6ac8b2 Mon Sep 17 00:00:00 2001 From: UMTS at Teleco Date: Fri, 14 Feb 2025 03:12:25 +0100 Subject: initial upload ... somewhat cleaned up and "less" swearing included --- admin/.DS_Store | Bin 0 -> 6148 bytes admin/assets/.DS_Store | Bin 0 -> 6148 bytes admin/assets/svg/.DS_Store | Bin 0 -> 6148 bytes admin/assets/svg/teleco.svg | 242 ++++++++++++++++++++++++++++ admin/backup_database.php | 37 +++++ admin/index.php | 110 +++++++++++++ admin/tools/edit_database.php | 361 ++++++++++++++++++++++++++++++++++++++++++ admin/tools/edit_row.php | 80 ++++++++++ admin/tools/manage_files.php | 222 ++++++++++++++++++++++++++ 9 files changed, 1052 insertions(+) create mode 100644 admin/.DS_Store create mode 100644 admin/assets/.DS_Store create mode 100644 admin/assets/svg/.DS_Store create mode 100644 admin/assets/svg/teleco.svg create mode 100644 admin/backup_database.php create mode 100644 admin/index.php create mode 100644 admin/tools/edit_database.php create mode 100644 admin/tools/edit_row.php create mode 100644 admin/tools/manage_files.php (limited to 'admin') diff --git a/admin/.DS_Store b/admin/.DS_Store new file mode 100644 index 0000000..e7b14c9 Binary files /dev/null and b/admin/.DS_Store differ diff --git a/admin/assets/.DS_Store b/admin/assets/.DS_Store new file mode 100644 index 0000000..5c248b5 Binary files /dev/null and b/admin/assets/.DS_Store differ diff --git a/admin/assets/svg/.DS_Store b/admin/assets/svg/.DS_Store new file mode 100644 index 0000000..5008ddf Binary files /dev/null and b/admin/assets/svg/.DS_Store differ diff --git a/admin/assets/svg/teleco.svg b/admin/assets/svg/teleco.svg new file mode 100644 index 0000000..1cbb190 --- /dev/null +++ b/admin/assets/svg/teleco.svg @@ -0,0 +1,242 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/admin/backup_database.php b/admin/backup_database.php new file mode 100644 index 0000000..b945408 --- /dev/null +++ b/admin/backup_database.php @@ -0,0 +1,37 @@ + diff --git a/admin/index.php b/admin/index.php new file mode 100644 index 0000000..22fa311 --- /dev/null +++ b/admin/index.php @@ -0,0 +1,110 @@ + + + + + + + + Admin Panel + + + + +
+ +

Adminier Panel

+
+
+
+

Adminier Panel

+
+ + +
+ Backup Database + Edit das Database + Manger das Filet +
+
+

Welcome to the TC-C-CMS admin Panel

+

Feast your eyes! This is the last time you will see properish CSS in the admin panel.

+

Made with lots of love for PHP and pure hatred against JavaScript (has none) by T.B
TC-C-CMS means Teleco's Crappy Content Management System btw lol hahahaha ich chan das alles nümmeh!

+ +

+ +
+
+ + \ No newline at end of file diff --git a/admin/tools/edit_database.php b/admin/tools/edit_database.php new file mode 100644 index 0000000..bc5489a --- /dev/null +++ b/admin/tools/edit_database.php @@ -0,0 +1,361 @@ +query("SELECT name FROM sqlite_master WHERE type='table' AND name != 'sqlite_sequence'"); +$tables = []; +while ($row = $tablesResult->fetchArray(SQLITE3_ASSOC)) { + $tables[] = $row['name']; +} + +if ($selectedTable && in_array($selectedTable, $tables)) { + $_SESSION['selectedTable'] = $selectedTable; + $columnsResult = $db->query("PRAGMA table_info($selectedTable)"); + while ($row = $columnsResult->fetchArray(SQLITE3_ASSOC)) { + $columns[] = $row['name']; + } + if ($selectedTable == 'content' && in_array('date', $columns)) { + $orderBy = "ORDER BY date DESC"; // das hier machen default sorting nach datum und ziiht de neuschti row zerscht will susch isch das unmanagebar + } else { + $orderBy = in_array('date', $columns) ? "ORDER BY date $sortOrder" : "ORDER BY id ASC"; + } + $rowsResult = $db->query("SELECT * FROM $selectedTable $orderBy"); + while ($row = $rowsResult->fetchArray(SQLITE3_ASSOC)) { + $rows[] = $row; + } +} else { + $selectedTable = ''; + $_SESSION['selectedTable'] = ''; +} + +if (isset($_POST['edit_row'])) { + header("Location: edit_row.php?table=$selectedTable&id=" . $_POST['id']); + exit(); +} + +if (isset($_POST['delete_row'])) { + $idsToDelete = $_POST['ids'] ?? []; + foreach ($idsToDelete as $id) { + $stmt = $db->prepare("DELETE FROM $selectedTable WHERE id = :id"); + $stmt->bindValue(':id', $id, SQLITE3_INTEGER); + $stmt->execute(); + } + $message = "Selected rows deleted successfully (most likely)."; +} + +if (isset($_POST['insert_row'])) { + $values = $_POST['values']; + $highestIdResult = $db->querySingle("SELECT MAX(id) as max_id FROM $selectedTable"); + $highestId = $highestIdResult ? $highestIdResult : 0; + $values['id'] = $highestId + 1; + if ($selectedTable == 'content') { + if (empty($values['date'])) { + $values['date'] = date('Y-m-d H:i:s'); + } + } + $columnsString = implode(", ", array_keys($values)); + $placeholders = implode(", ", array_fill(0, count($values), "?")); + $stmt = $db->prepare("INSERT INTO $selectedTable ($columnsString) VALUES ($placeholders)"); + $index = 1; + foreach ($values as $value) { + $stmt->bindValue($index, $value ?: null, SQLITE3_TEXT); + $index++; + } + $stmt->execute(); + $message = "Row inserted successfully. (maybe)"; +} + +if (isset($_POST['swap_row'])) { + $id = $_POST['id']; + $targetId = $_POST['target_id']; + $db->exec("BEGIN TRANSACTION"); + $db->exec("UPDATE $selectedTable SET id = -1 WHERE id = $id"); + $db->exec("UPDATE $selectedTable SET id = $id WHERE id = $targetId"); + $db->exec("UPDATE $selectedTable SET id = $targetId WHERE id = -1"); + $db->exec("COMMIT"); + $message = "Row swapped successfully for sure."; +} + +if (isset($_POST['push_row'])) { + $id = $_POST['id']; + $targetId = $_POST['target_id']; + $tempTable = $selectedTable . '_temp'; + $db->exec("BEGIN TRANSACTION"); + $db->exec("CREATE TEMPORARY TABLE $tempTable AS SELECT * FROM $selectedTable"); + $db->exec("UPDATE $tempTable SET id = -1 WHERE id = $id"); + if ($id < $targetId) { + $db->exec("UPDATE $tempTable SET id = id - 1 WHERE id > $id AND id <= $targetId"); + } else { + $db->exec("UPDATE $tempTable SET id = id + 1 WHERE id < $id AND id >= $targetId"); + } + $db->exec("UPDATE $tempTable SET id = $targetId WHERE id = -1"); + $db->exec("DELETE FROM $selectedTable"); + $db->exec("INSERT INTO $selectedTable SELECT * FROM $tempTable"); + $db->exec("DROP TABLE $tempTable"); + $db->exec("COMMIT"); + $message = "Row pushed successfully (perhaps)."; +} + +if (isset($_POST['reassign_ids'])) { + $tempBackup = $backupDir . '/' . $timestamp . '_temp.db'; + copy($source, $tempBackup); + + try { + $db->exec("BEGIN TRANSACTION"); + $tempTable = $selectedTable . '_temp'; + $db->exec("CREATE TEMPORARY TABLE $tempTable AS SELECT * FROM $selectedTable"); + $db->exec("DELETE FROM $selectedTable"); + + if (in_array('date', $columns)) { + $orderBy = "ORDER BY date ASC"; + } else { + $orderBy = "ORDER BY id ASC"; + } + + $rowsResult = $db->query("SELECT * FROM $tempTable $orderBy"); + $newId = 1; + while ($row = $rowsResult->fetchArray(SQLITE3_ASSOC)) { + $row['id'] = $newId++; + $columnsString = implode(", ", array_keys($row)); + $placeholders = implode(", ", array_fill(0, count($row), "?")); + $stmt = $db->prepare("INSERT INTO $selectedTable ($columnsString) VALUES ($placeholders)"); + $index = 1; + foreach ($row as $value) { + $stmt->bindValue($index, $value ?: null, SQLITE3_TEXT); + $index++; + } + $stmt->execute(); + } + + $db->exec("DROP TABLE $tempTable"); + $db->exec("COMMIT"); + $message = "IDs reassigned successfully."; + } catch (Exception $e) { + copy($tempBackup, $source); + $message = "Failed to reassign IDs. Database restored from backup. (probably)"; + } finally { + unlink($tempBackup); + } +} +?> + + + + + + Edit Database + + +
+ +
+

Edit Database

+
+ + +
+
+ +
+ +

+ +
+ + +
+
+ +
+ +

Editing Table:

+ +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Select + + + Sort by Date + + Actions
+ + + + + + + + +
+ + + + +
+ + +
+
+ + + + +
+
+ + + + +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Select + + + Sort by Datum + + Actions
+ + + + +
+ + +
+
+ + + + +
+
+ + + + + + + + + + + +
+ + + + + +

No das table selected. Please select das table to editieren.

+ + + \ No newline at end of file diff --git a/admin/tools/edit_row.php b/admin/tools/edit_row.php new file mode 100644 index 0000000..ceb59f3 --- /dev/null +++ b/admin/tools/edit_row.php @@ -0,0 +1,80 @@ +query("PRAGMA table_info($table)"); +while ($row = $columnsResult->fetchArray(SQLITE3_ASSOC)) { + $columns[] = $row['name']; +} + +$stmt = $db->prepare("SELECT * FROM $table WHERE id = :id"); +$stmt->bindValue(':id', $id, SQLITE3_INTEGER); +$result = $stmt->execute(); + +if ($result) { + $row = $result->fetchArray(SQLITE3_ASSOC); +} else { + $row = null; +} + +if (isset($_POST['save_changes'])) { + foreach ($columns as $column) { + $value = $_POST[$column] ?: null; + if ($column == 'date' && empty($value)) { + $value = date('Y-m-d H:i:s'); + } + if ($table == 'content' && $column == 'custom_html') { + $value = $value ? 1 : 0; + } + $stmt = $db->prepare("UPDATE $table SET $column = :value WHERE id = :id"); + $stmt->bindValue(':value', $value, SQLITE3_TEXT); + $stmt->bindValue(':id', $id, SQLITE3_INTEGER); + $stmt->execute(); + } + header("Location: edit_database.php?table=$table"); + exit(); +} +?> + + + + + + Edit Row + + +

Edit Row in Table:

+
+ + + + + + + +
+ + +
+ Back to Table + + diff --git a/admin/tools/manage_files.php b/admin/tools/manage_files.php new file mode 100644 index 0000000..f7d9592 --- /dev/null +++ b/admin/tools/manage_files.php @@ -0,0 +1,222 @@ + + + + + + + + Manage Files + + +
+
+ +
+

File Manager

+
+ + +
+ +

+ +

Current Directory:

+
+ +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
.. (Parent Directory)
Folders
+
+ + +
+
+ + + +
+
Files
+
+ + +
+
+ + + +
+ Download +
+

Upload File

+
+ + +
+
+

Create Folder

+
+ + +
+
+

Backup Folder

+
+ +
+
+
+ + -- cgit v1.2.3-70-g09d2