22 lines
658 B
PHP
22 lines
658 B
PHP
<?php
|
|
require_once __DIR__ . '/config.php';
|
|
|
|
try {
|
|
$pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4", DB_USER, DB_PASS);
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
|
|
require_once 'functions.php';
|
|
|
|
function cleanupTags() {
|
|
global $pdo;
|
|
try {
|
|
$pdo->exec("DELETE FROM tags WHERE id NOT IN (SELECT tag_id FROM video_tags)");
|
|
} catch (Exception $e) {
|
|
// Fail silently
|
|
}
|
|
}
|
|
} catch (PDOException $e) {
|
|
die("Database Connection Error: " . $e->getMessage());
|
|
}
|
|
?>
|