setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); // AUTO-PATCHER: Prevents 500 Errors by silently injecting missing columns individually $user_cols = [ 'email' => 'VARCHAR(255) NULL', 'is_active' => 'TINYINT(1) DEFAULT 1', 'reset_token' => 'VARCHAR(100) NULL', 'avatar_path' => 'VARCHAR(255) NULL' ]; foreach ($user_cols as $col => $def) { try { $pdo->query("SELECT `$col` FROM dle_users LIMIT 1"); } catch (PDOException $e) { $pdo->exec("ALTER TABLE dle_users ADD COLUMN `$col` $def"); } } try { $pdo->exec("INSERT IGNORE INTO dle_settings (key_name, value) VALUES ('mail_enabled', '0'), ('mail_from', 'noreply@site.com')"); } catch (PDOException $e) {} try { $pdo->query("SELECT featured_image FROM dle_posts LIMIT 1"); } catch (PDOException $patchError) { $pdo->exec("ALTER TABLE dle_posts ADD COLUMN featured_image VARCHAR(255) NULL"); } } catch (PDOException $e) { die("

Database Connection Error

The system could not connect to the database. Please check your credentials or delete dle_config.json to reinstall.

" . htmlspecialchars($e->getMessage()) . "
"); } } } elseif ($action !== 'install') { header("Location: ?action=install"); exit; } function slugify($text) { $text = preg_replace('~[^\pL\d]+~u', '-', $text); $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text); $text = preg_replace('~[^-\w]+~', '', $text); $text = trim($text, '-'); $text = preg_replace('~-+~', '-', $text); return strtolower($text); } function handle_upload($input_name, $allowed_types = ['jpg', 'jpeg', 'png', 'gif', 'webp', 'ico']) { global $uploads_dir; if (isset($_FILES[$input_name]) && $_FILES[$input_name]['error'] === UPLOAD_ERR_OK) { $ext = strtolower(pathinfo($_FILES[$input_name]['name'], PATHINFO_EXTENSION)); if (in_array($ext, $allowed_types)) { $filename = uniqid() . '_' . time() . '.' . $ext; $target = $uploads_dir . '/' . $filename; if (move_uploaded_file($_FILES[$input_name]['tmp_name'], $target)) { return 'uploads/' . $filename; } } } return false; } function send_dle_mail($to, $subject, $message) { global $settings; if (empty($settings['mail_enabled']) || $settings['mail_enabled'] === '0') return true; $from = !empty($settings['mail_from']) ? $settings['mail_from'] : 'noreply@' . $_SERVER['HTTP_HOST']; $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=utf-8\r\n"; $headers .= "From: {$settings['site_title']} <{$from}>\r\n"; return @mail($to, $subject, $message, $headers); } $settings = [ 'site_title' => 'DataLife Engine Clone', 'seo_desc' => 'Soft & News Portal Powered by SQL', 'seo_keys' => '', 'logo_path' => '', 'favicon_path' => '', 'mail_enabled' => '0', 'mail_from' => '', 'site_rules' => '

Welcome to our site! Please follow the rules.

' ]; $categories = []; $current_user = null; if ($pdo) { try { $stmt = $pdo->query("SELECT * FROM dle_settings"); while ($row = $stmt->fetch()) { $settings[$row['key_name']] = $row['value']; } $stmt = $pdo->query("SELECT * FROM dle_categories ORDER BY name ASC"); $categories = $stmt->fetchAll(); if (isset($_SESSION['user_id'])) { $stmt = $pdo->prepare("SELECT * FROM dle_users WHERE id = ?"); $stmt->execute([$_SESSION['user_id']]); $current_user = $stmt->fetch(); } } catch (PDOException $e) { die("Settings Load Error: " . htmlspecialchars($e->getMessage())); } } if ($action === 'install' && $_SERVER['REQUEST_METHOD'] === 'POST') { $db_host = $_POST['db_host'] ?? 'localhost'; $db_name = $_POST['db_name'] ?? ''; $db_user = $_POST['db_user'] ?? ''; $db_pass = $_POST['db_pass'] ?? ''; $admin_user = $_POST['admin_user'] ?? 'admin'; $admin_pass = $_POST['admin_pass'] ?? 'password'; $admin_email = $_POST['admin_email'] ?? 'admin@site.com'; try { $temp_pdo = new PDO("mysql:host=$db_host;charset=utf8mb4", $db_user, $db_pass); $temp_pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $temp_pdo->exec("CREATE DATABASE IF NOT EXISTS `$db_name`"); $temp_pdo->exec("USE `$db_name`"); // Schema Generation $temp_pdo->exec("CREATE TABLE IF NOT EXISTS dle_settings (key_name VARCHAR(100) PRIMARY KEY, value TEXT)"); $temp_pdo->exec("CREATE TABLE IF NOT EXISTS dle_users (id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50), email VARCHAR(255), password VARCHAR(255), role VARCHAR(20), is_active TINYINT(1) DEFAULT 1, reset_token VARCHAR(100), avatar_path VARCHAR(255))"); $temp_pdo->exec("CREATE TABLE IF NOT EXISTS dle_categories (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), slug VARCHAR(100))"); $temp_pdo->exec("CREATE TABLE IF NOT EXISTS dle_posts (id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255), slug VARCHAR(255), content TEXT, category_id INT, author_id INT, featured_image VARCHAR(255), created_at DATETIME)"); // Initial Data $temp_pdo->exec("INSERT IGNORE INTO dle_settings (key_name, value) VALUES ('site_title', 'My DLE Portal'), ('seo_desc', 'Soft & News Portal Powered by SQL'), ('seo_keys', 'news, soft'), ('mail_enabled', '0')"); $temp_pdo->exec("INSERT IGNORE INTO dle_categories (name, slug) VALUES ('Software', 'software'), ('News', 'news')"); $hash = password_hash($admin_pass, PASSWORD_DEFAULT); $temp_pdo->prepare("INSERT INTO dle_users (username, email, password, role, is_active) VALUES (?, ?, ?, 'admin', 1)")->execute([$admin_user, $admin_email, $hash]); // Generate .htaccess for SEO URLs $base_path = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH); $base_dir = rtrim(dirname($base_path), '/\\'); $base_dir = ($base_dir === '') ? '/' : $base_dir . '/'; $ht_content = "RewriteEngine On\nRewriteBase {$base_dir}\nRewriteCond %{REQUEST_FILENAME} !-f\nRewriteCond %{REQUEST_FILENAME} !-d\nRewriteRule ^(.*)$ index.php?route=$1 [QSA,L]\n"; file_put_contents($htaccess_file, $ht_content); // Save Config file_put_contents($config_file, json_encode(['db_host' => $db_host, 'db_name' => $db_name, 'db_user' => $db_user, 'db_pass' => $db_pass])); header("Location: /"); exit; } catch (PDOException $e) { $error = "SQL Installation Error: " . $e->getMessage(); } } if ($action === 'login' && $_SERVER['REQUEST_METHOD'] === 'POST') { $username = $_POST['login_user'] ?? ''; $password = $_POST['login_pass'] ?? ''; $stmt = $pdo->prepare("SELECT * FROM dle_users WHERE username = ?"); $stmt->execute([$username]); $user = $stmt->fetch(); if ($user && password_verify($password, $user['password'])) { if ($user['is_active'] == 0) { $error = "Your account is not activated. Please check your email."; } else { $_SESSION['user_id'] = $user['id']; $_SESSION['username'] = $user['username']; $_SESSION['role'] = $user['role']; header("Location: /"); exit; } } else { $error = "Invalid username or password."; } } if ($action === 'logout') { session_destroy(); header("Location: /"); exit; } if ($action === 'upload_avatar' && isset($_SESSION['user_id']) && $_SERVER['REQUEST_METHOD'] === 'POST') { $avatar = handle_upload('avatar_file'); if ($avatar) { $stmt = $pdo->prepare("UPDATE dle_users SET avatar_path = ? WHERE id = ?"); $stmt->execute([$avatar, $_SESSION['user_id']]); $success = "Avatar successfully updated!"; // Refresh active user state $current_user['avatar_path'] = $avatar; } else { $error = "Failed to upload avatar. Allowed formats: JPG, PNG, GIF, WEBP."; } $action = ''; // return home } if ($action === 'register' && $_SERVER['REQUEST_METHOD'] === 'POST') { $user = trim($_POST['reg_user'] ?? ''); $email = trim($_POST['reg_email'] ?? ''); $pass = $_POST['reg_pass'] ?? ''; if (!empty($user) && !empty($email) && !empty($pass)) { $stmt = $pdo->prepare("SELECT id FROM dle_users WHERE username = ? OR email = ?"); $stmt->execute([$user, $email]); if ($stmt->fetch()) { $error = "Username or email already exists."; } else { $hash = password_hash($pass, PASSWORD_DEFAULT); $token = bin2hex(random_bytes(16)); $is_active = ($settings['mail_enabled'] === '1') ? 0 : 1; $stmt = $pdo->prepare("INSERT INTO dle_users (username, email, password, role, is_active, reset_token) VALUES (?, ?, ?, 'user', ?, ?)"); $stmt->execute([$user, $email, $hash, $is_active, $token]); if ($is_active === 0) { $link = "http://" . $_SERVER['HTTP_HOST'] . "/?action=activate&token=" . $token; $msg = "Hello $user,

Please click the link below to activate your account:
$link"; send_dle_mail($email, "Account Activation", $msg); $success = "Registration successful! Please check your email to activate your account."; } else { $success = "Registration successful! You may now log in."; } $action = ''; } } } if ($action === 'activate' && isset($_GET['token'])) { $stmt = $pdo->prepare("UPDATE dle_users SET is_active = 1, reset_token = NULL WHERE reset_token = ?"); $stmt->execute([$_GET['token']]); if ($stmt->rowCount() > 0) { $success = "Account activated successfully! You can now log in."; } else { $error = "Invalid or expired activation link."; } $action = ''; } if ($action === 'reset_pass' && $_SERVER['REQUEST_METHOD'] === 'POST') { $email = trim($_POST['reset_email'] ?? ''); $stmt = $pdo->prepare("SELECT * FROM dle_users WHERE email = ?"); $stmt->execute([$email]); if ($user = $stmt->fetch()) { $token = bin2hex(random_bytes(16)); $pdo->prepare("UPDATE dle_users SET reset_token = ? WHERE id = ?")->execute([$token, $user['id']]); $link = "http://" . $_SERVER['HTTP_HOST'] . "/?action=new_pass&token=" . $token; $msg = "Click here to reset your password: $link"; send_dle_mail($email, "Password Reset", $msg); $success = "If your email exists in our system, a password reset link has been sent."; } $action = ''; } if ($action === 'new_pass_save' && $_SERVER['REQUEST_METHOD'] === 'POST') { $token = $_POST['token'] ?? ''; $pass = $_POST['new_pass'] ?? ''; $hash = password_hash($pass, PASSWORD_DEFAULT); $stmt = $pdo->prepare("UPDATE dle_users SET password = ?, reset_token = NULL WHERE reset_token = ?"); $stmt->execute([$hash, $token]); if ($stmt->rowCount() > 0) { $success = "Password updated! You can now log in."; } else { $error = "Invalid token."; } $action = ''; } $is_admin = isset($_SESSION['role']) && $_SESSION['role'] === 'admin'; if ($action === 'admin_save_settings' && $is_admin && $_SERVER['REQUEST_METHOD'] === 'POST') { $updates = [ 'site_title' => $_POST['site_title'] ?? '', 'seo_desc' => $_POST['seo_desc'] ?? '', 'seo_keys' => $_POST['seo_keys'] ?? '', 'mail_enabled' => isset($_POST['mail_enabled']) ? '1' : '0', 'mail_from' => $_POST['mail_from'] ?? '', 'site_rules' => $_POST['site_rules'] ?? '' ]; $logo = handle_upload('logo_upload'); if ($logo) $updates['logo_path'] = $logo; $favicon = handle_upload('favicon_upload'); if ($favicon) $updates['favicon_path'] = $favicon; $stmt = $pdo->prepare("REPLACE INTO dle_settings (key_name, value) VALUES (?, ?)"); foreach ($updates as $key => $val) { $stmt->execute([$key, $val]); } header("Location: ?action=admin&success=Settings updated"); exit; } if ($action === 'admin_add_category' && $is_admin && $_SERVER['REQUEST_METHOD'] === 'POST') { $cat_name = trim($_POST['cat_name']); if (!empty($cat_name)) { $stmt = $pdo->prepare("INSERT INTO dle_categories (name, slug) VALUES (?, ?)"); $stmt->execute([$cat_name, slugify($cat_name)]); header("Location: ?action=admin&success=Category Added"); exit; } } if ($action === 'admin_edit_category_exec' && $is_admin && $_SERVER['REQUEST_METHOD'] === 'POST') { $stmt = $pdo->prepare("UPDATE dle_categories SET name = ?, slug = ? WHERE id = ?"); $stmt->execute([trim($_POST['cat_name']), slugify($_POST['cat_name']), $_POST['cat_id']]); header("Location: ?action=admin&success=Category Updated"); exit; } if ($action === 'delete_category_execute' && $is_admin && isset($_POST['confirm_delete_cat'])) { $stmt = $pdo->prepare("DELETE FROM dle_categories WHERE id = ?"); $stmt->execute([$_POST['cat_id']]); header("Location: ?action=admin&success=Category Deleted"); exit; } if ($action === 'admin_update_core' && $is_admin && $_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_FILES['core_file']) && $_FILES['core_file']['error'] === UPLOAD_ERR_OK) { $ext = strtolower(pathinfo($_FILES['core_file']['name'], PATHINFO_EXTENSION)); if ($ext === 'php') { if (move_uploaded_file($_FILES['core_file']['tmp_name'], __FILE__)) { header("Location: ?action=admin&success=System Core Patched Successfully"); exit; } else { $error = "Failed to overwrite core file. Check permissions."; } } else { $error = "Only .php files allowed for core update."; } } $action = 'admin'; } if ($action === 'add_post' && $is_admin && $_SERVER['REQUEST_METHOD'] === 'POST') { $title = $_POST['post_title'] ?? ''; $cat_id = $_POST['category_id'] ?? 1; $content = $_POST['post_content'] ?? ''; $featured_image = handle_upload('featured_image'); if (!empty($title) && !empty($content)) { $stmt = $pdo->prepare("INSERT INTO dle_posts (title, slug, content, category_id, author_id, featured_image, created_at) VALUES (?, ?, ?, ?, ?, ?, NOW())"); $stmt->execute([$title, slugify($title), $content, $cat_id, $_SESSION['user_id'], $featured_image]); header("Location: /"); exit; } } if ($action === 'delete_post_execute' && $is_admin && isset($_POST['confirm_delete'])) { $stmt = $pdo->prepare("DELETE FROM dle_posts WHERE id = ?"); $stmt->execute([$_POST['post_id']]); header("Location: /"); exit; } if ($action === 'edit_post_execute' && $is_admin && $_SERVER['REQUEST_METHOD'] === 'POST') { $post_id = $_POST['post_id'] ?? 0; $title = $_POST['post_title'] ?? ''; $cat_id = $_POST['category_id'] ?? 1; $content = $_POST['post_content'] ?? ''; $featured_image = handle_upload('featured_image'); if (!empty($title) && !empty($content) && $post_id) { if ($featured_image) { $stmt = $pdo->prepare("UPDATE dle_posts SET title = ?, slug = ?, content = ?, category_id = ?, featured_image = ? WHERE id = ?"); $stmt->execute([$title, slugify($title), $content, $cat_id, $featured_image, $post_id]); } else { $stmt = $pdo->prepare("UPDATE dle_posts SET title = ?, slug = ?, content = ?, category_id = ? WHERE id = ?"); $stmt->execute([$title, slugify($title), $content, $cat_id, $post_id]); } header("Location: /post/" . slugify($title)); exit; } } $posts = []; $single_post = null; if ($pdo) { if ($action === 'read_post' && !empty($slug)) { $stmt = $pdo->prepare("SELECT p.*, c.name as category_name, u.username as author_name FROM dle_posts p LEFT JOIN dle_categories c ON p.category_id = c.id LEFT JOIN dle_users u ON p.author_id = u.id WHERE p.slug = ?"); $stmt->execute([$slug]); $single_post = $stmt->fetch(); } elseif ($action === 'category' && !empty($slug)) { $stmt = $pdo->prepare("SELECT p.*, c.name as category_name, u.username as author_name FROM dle_posts p JOIN dle_categories c ON p.category_id = c.id LEFT JOIN dle_users u ON p.author_id = u.id WHERE c.slug = ? ORDER BY p.created_at DESC"); $stmt->execute([$slug]); $posts = $stmt->fetchAll(); } else { $stmt = $pdo->query("SELECT p.*, c.name as category_name, u.username as author_name FROM dle_posts p LEFT JOIN dle_categories c ON p.category_id = c.id LEFT JOIN dle_users u ON p.author_id = u.id ORDER BY p.created_at DESC"); $posts = $stmt->fetchAll(); } } ?> <?= htmlspecialchars($settings['site_title']) ?>
Logo
Soft & News Portal Powered by SQL
๐Ÿ  Home Feed ๐Ÿ“Š Site Rules
โš™๏ธ Admin Control Panel
๐Ÿš€ SQL Database Auto-Installer

Welcome! Please provide your MySQL database credentials. The system will auto-patch all tables.

โš™๏ธ Control Panel
CMS Engine Ultimate

Dashboard Overview

Manage your portal configuration and categories.

๐ŸŒ

Site, SEO & Mail Configuration

โœ“ Active logo installed
"; ?>

๐Ÿ“ง Mail & Registration Engine

โœ“ Favicon active
"; ?>
๐Ÿ“

Category Manager

prepare("SELECT * FROM dle_categories WHERE id = ?"); $stmt->execute([$_GET['edit_cat']]); $edit_cat = $stmt->fetch(); } if ($edit_cat): ?>
Cancel
โš ๏ธ

System Update & Patcher

Upload a new .php core script to instantly upgrade the CMS without using FTP. This will overwrite the current index.php file safely.

Delete Confirmation

Cancel

Delete Category

Cancel
๐Ÿ“ User Registration
Cancel
๐Ÿ” Reset Password
Cancel
๐Ÿ”‘ Enter New Password
๐Ÿ“Š Site Rules
No rules have been set yet.

' ?>
โž• Compose Article
Cancel
prepare("SELECT * FROM dle_posts WHERE id = ?"); $stmt->execute([$_GET['id']]); $edit_post = $stmt->fetch(); if ($edit_post): ?>
โœ๏ธ Edit Article
Cancel
Article not found.

Date: Author: Category:
Edit Post Delete Post
Date: Author: Category:
Full Story
Edit Delete
No articles published yet.
๐Ÿ”’ User Panel
โš™๏ธ Admin Panel ๐Ÿ“ Add Article ๐Ÿšช Logout
Forgot password? Register
๐Ÿ“ Categories