File manager

AAAA
AAAA

Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home2/techcff9/techcadd.com/wp-acc.php on line 90
File manager

File manager - Edit - /home2/techcff9/techcadd.com/.git/objects/3a/6f0a98b15d7d1b937f62362d19715ca72a1816

Back
x��=blob 49902�<?php require_once __DIR__ . '/web-config.php'; function cms_db() { static $pdo = null; if ($pdo !== null) { return $pdo; } try { $dsn = 'mysql:host=' . CMS_DB_HOST . ';dbname=' . CMS_DB_NAME . ';charset=utf8mb4'; $pdo = new PDO($dsn, CMS_DB_USER, CMS_DB_PASS, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ]); return $pdo; } catch (Exception $e) { return null; } } function cms_init_table($module) { $cfg = get_cms_config($module); if (!$cfg) { return; } $pdo = cms_db(); if (!$pdo) { return; } $table = $cfg['table']; try { if ($module === 'blogs') { cms_init_blog_taxonomy_tables(); cms_init_blog_comments_table(); $sql = "CREATE TABLE IF NOT EXISTS `$table` ( `id` INT NOT NULL AUTO_INCREMENT, `slug` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NOT NULL, `summary` TEXT NULL, `content` LONGTEXT NULL, `image` VARCHAR(255) NULL, `category_id` INT NULL, `author_id` INT NULL, `read_time` VARCHAR(50) NULL, `publish_date` DATE NULL, `link` VARCHAR(255) NULL, `meta_title` VARCHAR(255) NULL, `meta_description` TEXT NULL, `meta_keywords` VARCHAR(255) NULL, `canonical_url` VARCHAR(255) NULL, `og_image` VARCHAR(255) NULL, `robots` VARCHAR(50) NULL, `schema_json` LONGTEXT NULL, `comments_enabled` TINYINT(1) DEFAULT 1, `created_by` VARCHAR(255) NULL, `status` VARCHAR(20) DEFAULT 'published', `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"; $pdo->exec($sql); cms_ensure_blog_columns(); return; } $sql = "CREATE TABLE IF NOT EXISTS `$table` ( `id` INT NOT NULL AUTO_INCREMENT, `slug` VARCHAR(255) NOT NULL, `title` VARCHAR(255) NOT NULL, `summary` TEXT NULL, `content` LONGTEXT NULL, `image` VARCHAR(255) NULL, `category` VARCHAR(255) NULL, `author` VARCHAR(255) NULL, `read_time` VARCHAR(50) NULL, `publish_date` DATE NULL, `link` VARCHAR(255) NULL, `event_date` DATE NULL, `location` VARCHAR(255) NULL, `alt_text` VARCHAR(255) NULL, `description` TEXT NULL, `answer` LONGTEXT NULL, `meta_title` VARCHAR(255) NULL, `meta_description` TEXT NULL, `meta_keywords` VARCHAR(255) NULL, `canonical_url` VARCHAR(255) NULL, `og_image` VARCHAR(255) NULL, `robots` VARCHAR(50) NULL, `schema_json` LONGTEXT NULL, `created_by` VARCHAR(255) NULL, `status` VARCHAR(20) DEFAULT 'published', `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"; $pdo->exec($sql); cms_ensure_module_columns($module); } catch (PDOException $e) { // END TRY BLOCK, START CATCH BLOCK error_log("CMS: Error initializing table for module $module: " . $e->getMessage()); } } function cms_ensure_blog_columns() { $pdo = cms_db(); if (!$pdo) { return; } $columns = $pdo->query("SHOW COLUMNS FROM `cms_blogs`")->fetchAll(); $columnNames = array_map(function ($col) { return $col['Field']; }, $columns); $addColumn = function ($name, $definition) use ($pdo, $columnNames) { if (!in_array($name, $columnNames, true)) { $pdo->exec("ALTER TABLE `cms_blogs` ADD COLUMN `$name` $definition"); } }; $addColumn('category_id', 'INT NULL'); $addColumn('author_id', 'INT NULL'); $addColumn('read_time', 'VARCHAR(50) NULL'); $addColumn('meta_title', 'VARCHAR(255) NULL'); $addColumn('meta_description', 'TEXT NULL'); $addColumn('meta_keywords', 'VARCHAR(255) NULL'); $addColumn('canonical_url', 'VARCHAR(255) NULL'); $addColumn('og_image', 'VARCHAR(255) NULL'); $addColumn('robots', 'VARCHAR(50) NULL'); $addColumn('schema_json', 'LONGTEXT NULL'); $addColumn('summary', 'TEXT NULL'); $addColumn('content', 'LONGTEXT NULL'); $addColumn('image', 'VARCHAR(255) NULL'); $addColumn('publish_date', 'DATE NULL'); $addColumn('link', 'VARCHAR(255) NULL'); $addColumn('comments_enabled', 'TINYINT(1) DEFAULT 1'); $addColumn('created_by', 'VARCHAR(255) NULL'); } function cms_init_blog_taxonomy_tables() { $pdo = cms_db(); if (!$pdo) { return; } $pdo->exec("CREATE TABLE IF NOT EXISTS `cms_categories` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `slug` VARCHAR(255) NOT NULL, `description` TEXT NULL, `meta_title` VARCHAR(255) NULL, `meta_description` TEXT NULL, `meta_keywords` VARCHAR(255) NULL, `canonical_url` VARCHAR(255) NULL, `og_image` VARCHAR(255) NULL, `robots` VARCHAR(50) NULL, `schema_json` LONGTEXT NULL, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"); $pdo->exec("CREATE TABLE IF NOT EXISTS `cms_tags` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `slug` VARCHAR(255) NOT NULL, `description` TEXT NULL, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"); $pdo->exec("CREATE TABLE IF NOT EXISTS `cms_authors` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `slug` VARCHAR(255) NOT NULL, `bio` TEXT NULL, `avatar` VARCHAR(255) NULL, `role` VARCHAR(255) NULL, `social_links` TEXT NULL, `meta_title` VARCHAR(255) NULL, `meta_description` TEXT NULL, `meta_keywords` VARCHAR(255) NULL, `canonical_url` VARCHAR(255) NULL, `og_image` VARCHAR(255) NULL, `robots` VARCHAR(50) NULL, `schema_json` LONGTEXT NULL, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug_unique` (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"); $pdo->exec("CREATE TABLE IF NOT EXISTS `cms_blog_tags` ( `blog_id` INT NOT NULL, `tag_id` INT NOT NULL, PRIMARY KEY (`blog_id`, `tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"); } function cms_init_blog_comments_table() { $pdo = cms_db(); if (!$pdo) { return; } $pdo->exec("CREATE TABLE IF NOT EXISTS `cms_blog_comments` ( `id` INT NOT NULL AUTO_INCREMENT, `blog_id` INT NOT NULL, `parent_id` INT NULL, `name` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NULL, `content` LONGTEXT NOT NULL, `status` VARCHAR(20) DEFAULT 'pending', `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `blog_idx` (`blog_id`), KEY `parent_idx` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"); } function cms_slugify($text) { $text = strtolower(trim($text)); $text = preg_replace('/[^a-z0-9\s-]/', '', $text); $text = preg_replace('/[\s-]+/', '-', $text); return trim($text, '-'); } function cms_decode_content($value) { $html = html_entity_decode($value ?? '', ENT_QUOTES, 'UTF-8'); if ($html === '') { return $html; } $html = preg_replace_callback( '/(<(?:img\|source\|video)\s+[^>]src=["\"])\s([^"\"]+)\s(["\"])\s/i', function ($matches) { $prefix = $matches[1]; $src = $matches[2]; $quote = $matches[3]; if (preg_match('/^https?:\/\//i', $src)) { return $prefix . $src . $quote; } $src = ltrim($src, '/'); if (stripos($src, 'cms/tinymce-upload/') === 0) { return $prefix . '/' . $src . $quote; } if (stripos($src, 'tinymce-upload/') === 0) { return $prefix . '/cms/' . $src . $quote; } if (stripos($src, 'uploads/') === 0) { return $prefix . '/cms/tinymce-upload/' . substr($src, strlen('uploads/')) . $quote; } return $prefix . $src . $quote; }, $html ); return $html; } function cms_get_base_url() { if (defined('CMS_BASE_URL') && CMS_BASE_URL !== '') { return rtrim(CMS_BASE_URL, '/'); } if (empty($_SERVER['HTTP_HOST'])) { return null; } $scheme = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https' : 'http'; return $scheme . '://' . $_SERVER['HTTP_HOST']; } function cms_should_update_sitemap($module) { return in_array($module, ['blogs', 'events', 'gallery', 'pages'], true); } function cms_generate_sitemap($baseUrl = null) { if (!defined('CMS_SITEMAP_AUTO') \|\| CMS_SITEMAP_AUTO !== true) { return false; } if (php_sapi_name() === 'cli') { return false; } $rootDir = realpath(__DIR__ . '/..'); if (!$rootDir) { return false; } $baseUrl = rtrim($baseUrl ?: cms_get_base_url(), '/'); if ($baseUrl === '' \|\| $baseUrl === null) { return false; } $sitemapPath = $rootDir . '/sitemap.xml'; $excludeFiles = [ 'admin-auth.php', 'admin-dashboard.php', 'blog-comment-submit.php', 'course-page.php', 'course-pagination.php', 'enquiry_modal.php', 'foot.php', 'nav.php' ]; $entries = []; $addUrl = function (&$entries, $loc, $lastmod = null, $changefreq = 'weekly', $priority = '0.7') { if (!filter_var($loc, FILTER_VALIDATE_URL)) { return; } $key = $loc; if (!isset($entries[$key])) { $entries[$key] = [ 'loc' => $loc, 'lastmod' => $lastmod, 'changefreq' => $changefreq, 'priority' => $priority ]; return; } if ($lastmod && (!isset($entries[$key]['lastmod']) \|\| $entries[$key]['lastmod'] < $lastmod)) { $entries[$key]['lastmod'] = $lastmod; } }; foreach (glob($rootDir . '/.php') as $file) { $name = basename($file); if (preg_match('/^(cms-\|admin-)/', $name)) { continue; } if (in_array($name, $excludeFiles, true)) { continue; } $loc = ($name === 'index.php') ? ($baseUrl . '/') : ($baseUrl . '/' . $name); $lastmod = date('Y-m-d', @filemtime($file) ?: time()); $addUrl($entries, $loc, $lastmod, 'monthly', '0.6'); } $modules = [ 'blogs' => function ($slug) use ($baseUrl) { return $baseUrl . '/techcadd-blog.php?slug=' . urlencode($slug); }, 'events' => function ($slug) use ($baseUrl) { return $baseUrl . '/event-details.php?slug=' . urlencode($slug); }, 'gallery' => function ($slug) use ($baseUrl) { return $baseUrl . '/gallery-details.php?slug=' . urlencode($slug); }, 'pages' => function ($slug) use ($baseUrl) { return $baseUrl . '/' . rawurlencode($slug); } ]; foreach ($modules as $module => $urlBuilder) { $items = cms_get_items($module); foreach ($items as $item) { if (($item['status'] ?? 'published') !== 'published') { continue; } $slug = $item['slug'] ?? cms_slugify($item['title'] ?? ''); if ($slug === '') { continue; } if ($module === 'pages') { $rawSlug = trim((string)$slug); $query = parse_url($rawSlug, PHP_URL_QUERY); if ($query) { parse_str($query, $params); if (!empty($params['slug'])) { $rawSlug = $params['slug']; } } $slug = ltrim($rawSlug, '/'); } $loc = $urlBuilder($slug); $lastmod = ''; if (!empty($item['updated_at'])) { $ts = strtotime($item['updated_at']); if ($ts) { $lastmod = date('Y-m-d', $ts); } } $addUrl($entries, $loc, $lastmod ?: null, 'weekly', '0.8'); } } $xml = new DOMDocument('1.0', 'UTF-8'); $xml->formatOutput = true; $urlset = $xml->createElement('urlset'); $urlset->setAttribute('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($entries as $entry) { $url = $xml->createElement('url'); $locNode = $xml->createElement('loc', $entry['loc']); $url->appendChild($locNode); if (!empty($entry['lastmod'])) { $lastmodNode = $xml->createElement('lastmod', $entry['lastmod']); $url->appendChild($lastmodNode); } $changefreqNode = $xml->createElement('changefreq', $entry['changefreq']); $priorityNode = $xml->createElement('priority', $entry['priority']); $url->appendChild($changefreqNode); $url->appendChild($priorityNode); $urlset->appendChild($url); } $xml->appendChild($urlset); return @file_put_contents($sitemapPath, $xml->saveXML()) !== false; } function cms_table_columns($table) { $pdo = cms_db(); if (!$pdo) { return []; } $columns = $pdo->query("SHOW COLUMNS FROM `$table`")->fetchAll(); return array_map(function ($col) { return $col['Field']; }, $columns); } function cms_ensure_module_columns($module) { $cfg = get_cms_config($module); if (!$cfg) { return; } $pdo = cms_db(); if (!$pdo) { return; } $table = $cfg['table']; $columns = cms_table_columns($table); $addColumn = function ($name, $definition) use ($pdo, $table, $columns) { if (!in_array($name, $columns, true)) { $pdo->exec("ALTER TABLE `$table` ADD COLUMN `$name` $definition"); } }; // All modules get created_by $addColumn('created_by', 'VARCHAR(255) NULL'); if ($module === 'events') { $addColumn('summary', 'TEXT NULL'); $addColumn('content', 'LONGTEXT NULL'); $addColumn('image', 'VARCHAR(255) NULL'); $addColumn('event_date', 'DATE NULL'); $addColumn('location', 'VARCHAR(255) NULL'); $addColumn('meta_title', 'VARCHAR(255) NULL'); $addColumn('meta_description', 'TEXT NULL'); $addColumn('meta_keywords', 'VARCHAR(255) NULL'); $addColumn('canonical_url', 'VARCHAR(255) NULL'); $addColumn('og_image', 'VARCHAR(255) NULL'); $addColumn('robots', 'VARCHAR(50) NULL'); $addColumn('schema_json', 'LONGTEXT NULL'); } if ($module === 'gallery') { $addColumn('image', 'VARCHAR(255) NULL'); $addColumn('alt_text', 'VARCHAR(255) NULL'); $addColumn('category', 'VARCHAR(255) NULL'); $addColumn('description', 'TEXT NULL'); $addColumn('video_url', 'VARCHAR(255) NULL'); $addColumn('media_type', 'VARCHAR(20) NULL'); $addColumn('meta_title', 'VARCHAR(255) NULL'); $addColumn('meta_description', 'TEXT NULL'); $addColumn('meta_keywords', 'VARCHAR(255) NULL'); $addColumn('canonical_url', 'VARCHAR(255) NULL'); $addColumn('og_image', 'VARCHAR(255) NULL'); $addColumn('robots', 'VARCHAR(50) NULL'); $addColumn('schema_json', 'LONGTEXT NULL'); } if ($module === 'faq') { $addColumn('answer', 'LONGTEXT NULL'); $addColumn('category', 'VARCHAR(255) NULL'); $addColumn('meta_title', 'VARCHAR(255) NULL'); $addColumn('meta_description', 'TEXT NULL'); $addColumn('meta_keywords', 'VARCHAR(255) NULL'); $addColumn('canonical_url', 'VARCHAR(255) NULL'); $addColumn('og_image', 'VARCHAR(255) NULL'); $addColumn('robots', 'VARCHAR(50) NULL'); $addColumn('schema_json', 'LONGTEXT NULL'); } if ($module === 'pages') { $addColumn('summary', 'TEXT NULL'); $addColumn('content', 'LONGTEXT NULL'); $addColumn('hero_image', 'VARCHAR(255) NULL'); $addColumn('overview_image', 'VARCHAR(255) NULL'); $addColumn('gallery_image_1', 'VARCHAR(255) NULL'); $addColumn('gallery_image_2', 'VARCHAR(255) NULL'); $addColumn('overview_content', 'LONGTEXT NULL'); $addColumn('techcadd_content', 'LONGTEXT NULL'); $addColumn('future_content', 'LONGTEXT NULL'); $addColumn('reviews_content', 'LONGTEXT NULL'); $addColumn('faq_content', 'LONGTEXT NULL'); $addColumn('reviews_items', 'LONGTEXT NULL'); $addColumn('faq_items', 'LONGTEXT NULL'); $addColumn('meta_title', 'VARCHAR(255) NULL'); $addColumn('meta_description', 'TEXT NULL'); $addColumn('meta_keywords', 'VARCHAR(255) NULL'); $addColumn('canonical_url', 'VARCHAR(255) NULL'); $addColumn('og_image', 'VARCHAR(255) NULL'); $addColumn('robots', 'VARCHAR(50) NULL'); $addColumn('schema_json', 'LONGTEXT NULL'); } if ($module === 'reviews') { $addColumn('name', 'VARCHAR(255) NULL'); $addColumn('profession', 'VARCHAR(255) NULL'); $addColumn('rating', 'TINYINT NULL'); $addColumn('review_content', 'LONGTEXT NULL'); $addColumn('image', 'VARCHAR(255) NULL'); $addColumn('google_link', 'VARCHAR(255) NULL'); $addColumn('status', 'VARCHAR(20) DEFAULT "published"'); } } function cms_get_items($module) { $pdo = cms_db(); $cfg = get_cms_config($module); if (!$pdo \|\| !$cfg) { return []; } cms_init_table($module); $table = $cfg['table']; if ($module === 'blogs') { $rows = $pdo->query("SELECT b., c.name AS category_name, a.name AS author_name FROM `cms_blogs` b LEFT JOIN `cms_categories` c ON b.category_id = c.id LEFT JOIN `cms_authors` a ON b.author_id = a.id ORDER BY b.updated_at DESC")->fetchAll(); } else { $rows = $pdo->query("SELECT * FROM `$table` ORDER BY updated_at DESC")->fetchAll(); } $items = []; foreach ($rows as $row) { if ($module === 'blogs') { $tagRows = $pdo->prepare("SELECT t.id, t.name FROM `cms_tags` t INNER JOIN `cms_blog_tags` bt ON t.id = bt.tag_id WHERE bt.blog_id = ?"); $tagRows->execute([$row['id']]); $tagData = $tagRows->fetchAll(); $tagIds = array_column($tagData, 'id'); $tagNames = array_column($tagData, 'name'); $items[] = [ 'id' => $row['id'], 'slug' => $row['slug'], 'title' => $row['title'], 'summary' => $row['summary'], 'content' => $row['content'], 'image' => $row['image'], 'category_id' => $row['category_id'], 'category_name' => $row['category_name'], 'author_id' => $row['author_id'], 'author_name' => $row['author_name'], 'tag_ids' => $tagIds, 'tags' => $tagNames, 'readTime' => $row['read_time'], 'publish_date' => $row['publish_date'], 'link' => $row['link'], 'comments_enabled' => $row['comments_enabled'] ?? 1, 'meta_title' => $row['meta_title'], 'meta_description' => $row['meta_description'], 'meta_keywords' => $row['meta_keywords'], 'canonical_url' => $row['canonical_url'], 'og_image' => $row['og_image'], 'robots' => $row['robots'], 'schema_json' => $row['schema_json'], 'created_by' => $row['created_by'] ?? null, 'status' => $row['status'], 'updated_at' => $row['updated_at'] ]; } else { $items[] = [ 'id' => $row['id'] ?? null, 'slug' => $row['slug'] ?? '', 'title' => $row['title'] ?? '', 'summary' => $row['summary'] ?? null, 'content' => $row['content'] ?? null, 'image' => $row['image'] ?? null, 'hero_image' => $row['hero_image'] ?? null, 'overview_image' => $row['overview_image'] ?? null, 'gallery_image_1' => $row['gallery_image_1'] ?? null, 'gallery_image_2' => $row['gallery_image_2'] ?? null, 'overview_content' => $row['overview_content'] ?? null, 'techcadd_content' => $row['techcadd_content'] ?? null, 'future_content' => $row['future_content'] ?? null, 'reviews_content' => $row['reviews_content'] ?? null, 'faq_content' => $row['faq_content'] ?? null, 'reviews_items' => $row['reviews_items'] ?? null, 'faq_items' => $row['faq_items'] ?? null, 'category' => $row['category'] ?? null, 'author' => $row['author'] ?? null, 'readTime' => $row['read_time'] ?? null, 'publish_date' => $row['publish_date'] ?? null, 'link' => $row['link'] ?? null, 'event_date' => $row['event_date'] ?? null, 'location' => $row['location'] ?? null, 'alt_text' => $row['alt_text'] ?? null, 'description' => $row['description'] ?? null, 'video_url' => $row['video_url'] ?? null, 'media_type' => $row['media_type'] ?? null, 'answer' => $row['answer'] ?? null, 'meta_title' => $row['meta_title'] ?? null, 'meta_description' => $row['meta_description'] ?? null, 'meta_keywords' => $row['meta_keywords'] ?? null, 'canonical_url' => $row['canonical_url'] ?? null, 'og_image' => $row['og_image'] ?? null, 'robots' => $row['robots'] ?? null, 'schema_json' => $row['schema_json'] ?? null, 'created_by' => $row['created_by'] ?? null, 'status' => $row['status'] ?? null, 'updated_at' => $row['updated_at'] ?? null, // Review-specific fields 'name' => $row['name'] ?? null, 'profession' => $row['profession'] ?? null, 'rating' => $row['rating'] ?? null, 'review_content' => $row['review_content'] ?? null, 'google_link' => $row['google_link'] ?? null ]; } } return $items; } function cms_save_blog($data) { $pdo = cms_db(); if (!$pdo) { return; } cms_init_table('blogs'); $data['title'] = trim($data['title'] ?? ''); $data['slug'] = trim($data['slug'] ?? ''); $data['status'] = $data['status'] ?? 'published'; if ($data['slug'] === '' && $data['title'] !== '') { $data['slug'] = cms_slugify($data['title']); } $stmt = $pdo->prepare("SELECT id FROM `cms_blogs` WHERE slug = ?"); $stmt->execute([$data['slug']]); $existing = $stmt->fetch(); $payload = [ 'slug' => $data['slug'], 'title' => $data['title'], 'summary' => $data['summary'] ?? null, 'content' => $data['content'] ?? null, 'image' => $data['image'] ?? null, 'category_id' => !empty($data['category_id']) ? (int)$data['category_id'] : null, 'author_id' => !empty($data['author_id']) ? (int)$data['author_id'] : null, 'read_time' => $data['readTime'] ?? null, 'publish_date' => $data['publish_date'] ?? null, 'link' => $data['link'] ?? null, 'meta_title' => $data['meta_title'] ?? null, 'meta_description' => $data['meta_description'] ?? null, 'meta_keywords' => $data['meta_keywords'] ?? null, 'canonical_url' => $data['canonical_url'] ?? null, 'og_image' => $data['og_image'] ?? null, 'robots' => $data['robots'] ?? null, 'schema_json' => $data['schema_json'] ?? null, 'comments_enabled' => isset($data['comments_enabled']) ? (int)$data['comments_enabled'] : 1, 'status' => $data['status'] ?? 'published' ]; if ($existing) { $sql = "UPDATE `cms_blogs` SET title = :title, summary = :summary, content = :content, image = :image, category_id = :category_id, author_id = :author_id, read_time = :read_time, publish_date = :publish_date, link = :link, meta_title = :meta_title, meta_description = :meta_description, meta_keywords = :meta_keywords, canonical_url = :canonical_url, og_image = :og_image, robots = :robots, schema_json = :schema_json, comments_enabled = :comments_enabled, status = :status WHERE slug = :slug"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); $blogId = (int)$existing['id']; } else { $payload['created_by'] = $data['created_by'] ?? null; $sql = "INSERT INTO `cms_blogs` ( slug, title, summary, content, image, category_id, author_id, read_time, publish_date, link, meta_title, meta_description, meta_keywords, canonical_url, og_image, robots, schema_json, comments_enabled, status, created_by ) VALUES ( :slug, :title, :summary, :content, :image, :category_id, :author_id, :read_time, :publish_date, :link, :meta_title, :meta_description, :meta_keywords, :canonical_url, :og_image, :robots, :schema_json, :comments_enabled, :status, :created_by )"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); $blogId = (int)$pdo->lastInsertId(); } $tags = $data['tags'] ?? []; if (!is_array($tags)) { $tags = []; } $pdo->prepare("DELETE FROM `cms_blog_tags` WHERE blog_id = ?")->execute([$blogId]); foreach ($tags as $tagId) { $tagId = (int)$tagId; if ($tagId <= 0) { continue; } $pdo->prepare("INSERT INTO `cms_blog_tags` (blog_id, tag_id) VALUES (?, ?)")->execute([$blogId, $tagId]); } cms_generate_sitemap(); } function cms_save_item($module, $data) { if ($module === 'blogs') { cms_save_blog($data); return; } $cfg = get_cms_config($module); if (!$cfg) { return; } $data['title'] = trim($data['title'] ?? ''); $data['slug'] = trim($data['slug'] ?? ''); $data['status'] = $data['status'] ?? 'published'; // For reviews module, use 'name' as title/slug basis when title is empty if ($module === 'reviews' && $data['title'] === '' && !empty($data['name'])) { $data['title'] = $data['name']; } if ($data['slug'] === '' && $data['title'] !== '') { $data['slug'] = cms_slugify($data['title']); } $pdo = cms_db(); if (!$pdo) { return; } cms_init_table($module); $table = $cfg['table']; // Ensure unique slug for new items if ($data['slug'] !== '') { $baseSlug = $data['slug']; $counter = 1; $checkStmt = $pdo->prepare("SELECT id FROM `$table` WHERE slug = ?"); $checkStmt->execute([$data['slug']]); $existingCheck = $checkStmt->fetch(); // Only make slug unique if this is a new item (not editing existing) if ($existingCheck && empty($data['id'])) { while (true) { $counter++; $data['slug'] = $baseSlug . '-' . $counter; $checkStmt = $pdo->prepare("SELECT id FROM `$table` WHERE slug = ?"); $checkStmt->execute([$data['slug']]); if (!$checkStmt->fetch()) { break; } } } } // Determine if editing an existing item (by id or slug) $existing = null; $updateById = false; if (!empty($data['id'])) { $stmt = $pdo->prepare("SELECT id, slug FROM `$table` WHERE id = ?"); $stmt->execute([(int)$data['id']]); $existing = $stmt->fetch(); if ($existing) { $updateById = true; } } if (!$existing && $data['slug'] !== '') { $stmt = $pdo->prepare("SELECT id, slug FROM `$table` WHERE slug = ?"); $stmt->execute([$data['slug']]); $existing = $stmt->fetch(); } $valueMap = [ 'slug' => $data['slug'], 'title' => $data['title'], 'summary' => $data['summary'] ?? null, 'content' => $data['content'] ?? null, 'image' => $data['image'] ?? null, 'category' => $data['category'] ?? null, 'author' => $data['author'] ?? null, 'read_time' => $data['readTime'] ?? null, 'publish_date' => $data['publish_date'] ?? null, 'link' => $data['link'] ?? null, 'event_date' => $data['event_date'] ?? null, 'location' => $data['location'] ?? null, 'alt_text' => $data['alt_text'] ?? null, 'description' => $data['description'] ?? null, 'hero_image' => $data['hero_image'] ?? null, 'overview_image' => $data['overview_image'] ?? null, 'gallery_image_1' => $data['gallery_image_1'] ?? null, 'gallery_image_2' => $data['gallery_image_2'] ?? null, 'overview_content' => $data['overview_content'] ?? null, 'techcadd_content' => $data['techcadd_content'] ?? null, 'future_content' => $data['future_content'] ?? null, 'reviews_content' => $data['reviews_content'] ?? null, 'faq_content' => $data['faq_content'] ?? null, 'reviews_items' => $data['reviews_items'] ?? null, 'faq_items' => $data['faq_items'] ?? null, 'answer' => $data['answer'] ?? null, 'meta_title' => $data['meta_title'] ?? null, 'meta_description' => $data['meta_description'] ?? null, 'meta_keywords' => $data['meta_keywords'] ?? null, 'canonical_url' => $data['canonical_url'] ?? null, 'og_image' => $data['og_image'] ?? null, 'robots' => $data['robots'] ?? null, 'schema_json' => $data['schema_json'] ?? null, 'status' => $data['status'] ?? 'published', // Review-specific fields 'name' => $data['name'] ?? null, 'profession' => $data['profession'] ?? null, 'rating' => $data['rating'] ?? null, 'review_content' => $data['review_content'] ?? null, 'google_link' => $data['google_link'] ?? null, // Track who created this item (manually entered) 'created_by' => $data['created_by'] ?? null ]; $columns = cms_table_columns($table); $payload = array_filter($valueMap, function ($key) use ($columns) { return in_array($key, $columns, true); }, ARRAY_FILTER_USE_KEY); if ($existing) { $setCols = array_keys($payload); // Never update created_by — it tracks the original creator $setCols = array_filter($setCols, function ($col) { return $col !== 'created_by'; }); if (!$updateById) { $setCols = array_filter($setCols, function ($col) { return $col !== 'slug'; }); } $setSql = implode(', ', array_map(function ($col) { return "`$col` = :$col"; }, $setCols)); if ($updateById) { $sql = "UPDATE `$table` SET $setSql WHERE id = :_update_id"; $execPayload = []; foreach ($setCols as $col) { $execPayload[$col] = $payload[$col]; } $execPayload['_update_id'] = (int)$existing['id']; $stmt = $pdo->prepare($sql); $stmt->execute($execPayload); } else { $sql = "UPDATE `$table` SET $setSql WHERE slug = :slug"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); } } else { $insertCols = array_filter($columns, function ($col) { return !in_array($col, ['id', 'created_at', 'updated_at'], true); }); $insertCols = array_values(array_filter($insertCols, function ($col) use ($payload) { return array_key_exists($col, $payload); })); $colSql = implode(', ', array_map(function ($col) { return "`$col`"; }, $insertCols)); $valSql = implode(', ', array_map(function ($col) { return ":$col"; }, $insertCols)); $sql = "INSERT INTO `$table` ($colSql) VALUES ($valSql)"; $execPayload = []; foreach ($insertCols as $col) { $execPayload[$col] = $payload[$col]; } $stmt = $pdo->prepare($sql); $stmt->execute($execPayload); } if (cms_should_update_sitemap($module)) { cms_generate_sitemap(); } } function cms_delete_item($module, $slug) { $pdo = cms_db(); $cfg = get_cms_config($module); if (!$pdo \|\| !$cfg) { return; } $table = $cfg['table']; $stmt = $pdo->prepare("DELETE FROM `$table` WHERE slug = ?"); $stmt->execute([$slug]); if (cms_should_update_sitemap($module)) { cms_generate_sitemap(); } } function cms_delete_item_by_id($module, $id) { $pdo = cms_db(); $cfg = get_cms_config($module); if (!$pdo \|\| !$cfg) { return; } $table = $cfg['table']; $stmt = $pdo->prepare("DELETE FROM `$table` WHERE id = ?"); $stmt->execute([(int)$id]); if (cms_should_update_sitemap($module)) { cms_generate_sitemap(); } } function cms_add_blog_comment($blogId, $data) { $pdo = cms_db(); if (!$pdo) { return false; } cms_init_blog_comments_table(); $name = trim($data['name'] ?? ''); $email = trim($data['email'] ?? ''); $content = trim($data['content'] ?? ''); if ($name === '' \|\| $content === '') { return false; } $stmt = $pdo->prepare("INSERT INTO `cms_blog_comments` (blog_id, parent_id, name, email, content, status) VALUES (?, NULL, ?, ?, ?, 'pending')"); return $stmt->execute([(int)$blogId, $name, $email, $content]); } function cms_add_comment_reply($commentId, $content, $adminName = 'Admin') { $pdo = cms_db(); if (!$pdo) { return false; } cms_init_blog_comments_table(); $stmt = $pdo->prepare("SELECT blog_id FROM `cms_blog_comments` WHERE id = ?"); $stmt->execute([(int)$commentId]); $row = $stmt->fetch(); if (!$row) { return false; } $content = trim($content ?? ''); if ($content === '') { return false; } $pdo->prepare("UPDATE `cms_blog_comments` SET status = 'approved' WHERE id = ?")->execute([(int)$commentId]); $stmt = $pdo->prepare("INSERT INTO `cms_blog_comments` (blog_id, parent_id, name, email, content, status) VALUES (?, ?, ?, NULL, ?, 'approved')"); return $stmt->execute([(int)$row['blog_id'], (int)$commentId, $adminName, $content]); } function cms_update_comment_status($commentId, $status) { $pdo = cms_db(); if (!$pdo) { return false; } $allowed = ['pending', 'approved', 'rejected']; if (!in_array($status, $allowed, true)) { return false; } $stmt = $pdo->prepare("UPDATE `cms_blog_comments` SET status = ? WHERE id = ?"); return $stmt->execute([$status, (int)$commentId]); } function cms_delete_comment($commentId) { $pdo = cms_db(); if (!$pdo) { return false; } $stmt = $pdo->prepare("DELETE FROM `cms_blog_comments` WHERE id = ? OR parent_id = ?"); return $stmt->execute([(int)$commentId, (int)$commentId]); } function cms_get_blog_comments($blogId, $status = 'approved') { $pdo = cms_db(); if (!$pdo) { return []; } cms_init_blog_comments_table(); $params = [(int)$blogId]; $statusSql = ''; if ($status !== null) { $statusSql = ' AND status = ?'; $params[] = $status; } $stmt = $pdo->prepare("SELECT * FROM `cms_blog_comments` WHERE blog_id = ?$statusSql ORDER BY created_at ASC"); $stmt->execute($params); $rows = $stmt->fetchAll(); $byId = []; foreach ($rows as $row) { $row['replies'] = []; $byId[$row['id']] = $row; } foreach ($byId as $row) { if (!empty($row['parent_id']) && isset($byId[$row['parent_id']])) { $byId[$row['parent_id']]['replies'][] = $row; } } $items = []; foreach ($byId as $row) { if (empty($row['parent_id'])) { $items[] = $row; } } return $items; } function cms_get_all_comments($status = null) { $pdo = cms_db(); if (!$pdo) { return []; } cms_init_blog_comments_table(); $params = []; $statusSql = ''; if ($status !== null && $status !== '') { $statusSql = ' WHERE c.status = ?'; $params[] = $status; } $stmt = $pdo->prepare("SELECT c., b.title AS blog_title, b.slug AS blog_slug FROM `cms_blog_comments` c LEFT JOIN `cms_blogs` b ON c.blog_id = b.id $statusSql ORDER BY c.created_at DESC"); $stmt->execute($params); return $stmt->fetchAll(); } function cms_get_creators($range = 'all') { $pdo = cms_db(); if (!$pdo) return []; global $CMS_MODULES; $creators = []; $where = "1=1"; if ($range === 'today') { $where = "DATE(created_at) = CURDATE()"; } elseif ($range === 'yesterday') { $where = "DATE(created_at) = DATE_SUB(CURDATE(), INTERVAL 1 DAY)"; } elseif ($range === 'week') { $where = "DATE(created_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)"; } // URL patterns for frontend view links $urlMap = [ 'blogs' => 'techcadd-blog.php?slug=', 'events' => 'event-details.php?slug=', 'pages' => 'course-page.php?slug=', 'gallery' => 'gallery-details.php?slug=', ]; foreach ($CMS_MODULES as $mod => $cfg) { $table = $cfg['table']; try { $cols = cms_table_columns($table); if (!in_array('created_by', $cols, true)) continue; $rows = $pdo->query("SELECT id, title, slug, created_by FROM `$table` WHERE created_by IS NOT NULL AND created_by != '' AND $where ORDER BY id DESC")->fetchAll(); foreach ($rows as $row) { $name = trim($row['created_by']); if ($name === '') continue; if (!isset($creators[$name])) $creators[$name] = []; $creators[$name][] = [ 'module' => $mod, 'id' => $row['id'], 'title' => $row['title'], 'slug' => $row['slug'], 'view_url' => isset($urlMap[$mod]) ? $urlMap[$mod] . urlencode($row['slug']) : null, ]; } } catch (Exception $e) { continue; } } ksort($creators); return $creators; } function cms_get_team_progress($range = 'all') { $pdo = cms_db(); if (!$pdo) return []; global $CMS_MODULES; $stats = []; $where = "1=1"; if ($range === 'today') { $where = "DATE(created_at) = CURDATE()"; } elseif ($range === 'yesterday') { $where = "DATE(created_at) = DATE_SUB(CURDATE(), INTERVAL 1 DAY)"; } elseif ($range === 'week') { $where = "DATE(created_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)"; } foreach ($CMS_MODULES as $mod => $cfg) { $table = $cfg['table']; try { $cols = cms_table_columns($table); if (!in_array('created_by', $cols, true)) continue; $sql = "SELECT created_by, COUNT() as count FROM `$table` WHERE created_by IS NOT NULL AND created_by != '' AND $where GROUP BY created_by"; $rows = $pdo->query($sql)->fetchAll(); foreach ($rows as $row) { $name = trim($row['created_by']); if (!isset($stats[$name])) { $stats[$name] = [ 'total' => 0, 'breakdown' => [] ]; } $stats[$name]['total'] += (int)$row['count']; $stats[$name]['breakdown'][$mod] = (int)$row['count']; } } catch (Exception $e) { continue; } } uasort($stats, function($a, $b) { return $b['total'] - $a['total']; }); return $stats; } function cms_escape($value) { return htmlspecialchars($value ?? '', ENT_QUOTES, 'UTF-8'); } function cms_count_today($table) { return cms_count_by_range($table, 'today'); } function cms_count_by_range($table, $range = 'today') { $pdo = cms_db(); if (!$pdo) return 0; try { $where = "DATE(created_at) = CURDATE()"; if ($range === 'yesterday') { $where = "DATE(created_at) = DATE_SUB(CURDATE(), INTERVAL 1 DAY)"; } elseif ($range === 'week') { $where = "DATE(created_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)"; } $stmt = $pdo->query("SELECT COUNT(*) FROM `$table` WHERE $where"); return (int)$stmt->fetchColumn(); } catch (Exception $e) { return 0; } } function cms_get_categories() { $pdo = cms_db(); if (!$pdo) { return []; } cms_init_blog_taxonomy_tables(); return $pdo->query("SELECT id, name FROM cms_categories ORDER BY name ASC")->fetchAll(); } function cms_get_tags() { $pdo = cms_db(); if (!$pdo) { return []; } cms_init_blog_taxonomy_tables(); return $pdo->query("SELECT id, name FROM cms_tags ORDER BY name ASC")->fetchAll(); } function cms_get_authors() { $pdo = cms_db(); if (!$pdo) { return []; } cms_init_blog_taxonomy_tables(); return $pdo->query("SELECT id, name FROM cms_authors ORDER BY name ASC")->fetchAll(); } function cms_save_category($data) { $pdo = cms_db(); if (!$pdo) { return; } cms_init_blog_taxonomy_tables(); $data['name'] = trim($data['name'] ?? ''); $data['slug'] = trim($data['slug'] ?? '') ?: cms_slugify($data['name']); $stmt = $pdo->prepare("SELECT id FROM cms_categories WHERE slug = ?"); $stmt->execute([$data['slug']]); $existing = $stmt->fetch(); $payload = [ 'name' => $data['name'], 'slug' => $data['slug'], 'description' => $data['description'] ?? null, 'meta_title' => $data['meta_title'] ?? null, 'meta_description' => $data['meta_description'] ?? null, 'meta_keywords' => $data['meta_keywords'] ?? null, 'canonical_url' => $data['canonical_url'] ?? null, 'og_image' => $data['og_image'] ?? null, 'robots' => $data['robots'] ?? null, 'schema_json' => $data['schema_json'] ?? null ]; if ($existing) { $sql = "UPDATE cms_categories SET name = :name, description = :description, meta_title = :meta_title, meta_description = :meta_description, meta_keywords = :meta_keywords, canonical_url = :canonical_url, og_image = :og_image, robots = :robots, schema_json = :schema_json WHERE slug = :slug"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); } else { $sql = "INSERT INTO cms_categories (name, slug, description, meta_title, meta_description, meta_keywords, canonical_url, og_image, robots, schema_json) VALUES (:name, :slug, :description, :meta_title, :meta_description, :meta_keywords, :canonical_url, :og_image, :robots, :schema_json)"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); } } function cms_save_tag($data) { $pdo = cms_db(); if (!$pdo) { return; } cms_init_blog_taxonomy_tables(); $data['name'] = trim($data['name'] ?? ''); $data['slug'] = trim($data['slug'] ?? '') ?: cms_slugify($data['name']); $stmt = $pdo->prepare("SELECT id FROM cms_tags WHERE slug = ?"); $stmt->execute([$data['slug']]); $existing = $stmt->fetch(); if ($existing) { $stmt = $pdo->prepare("UPDATE cms_tags SET name = ?, description = ? WHERE slug = ?"); $stmt->execute([$data['name'], $data['description'] ?? null, $data['slug']]); } else { $stmt = $pdo->prepare("INSERT INTO cms_tags (name, slug, description) VALUES (?, ?, ?)"); $stmt->execute([$data['name'], $data['slug'], $data['description'] ?? null]); } } function cms_save_author($data) { $pdo = cms_db(); if (!$pdo) { return; } cms_init_blog_taxonomy_tables(); $data['name'] = trim($data['name'] ?? ''); $data['slug'] = trim($data['slug'] ?? '') ?: cms_slugify($data['name']); $stmt = $pdo->prepare("SELECT id FROM cms_authors WHERE slug = ?"); $stmt->execute([$data['slug']]); $existing = $stmt->fetch(); $payload = [ 'name' => $data['name'], 'slug' => $data['slug'], 'bio' => $data['bio'] ?? null, 'avatar' => $data['avatar'] ?? null, 'role' => $data['role'] ?? null, 'social_links' => $data['social_links'] ?? null, 'meta_title' => $data['meta_title'] ?? null, 'meta_description' => $data['meta_description'] ?? null, 'meta_keywords' => $data['meta_keywords'] ?? null, 'canonical_url' => $data['canonical_url'] ?? null, 'og_image' => $data['og_image'] ?? null, 'robots' => $data['robots'] ?? null, 'schema_json' => $data['schema_json'] ?? null ]; if ($existing) { $sql = "UPDATE cms_authors SET name = :name, bio = :bio, avatar = :avatar, role = :role, social_links = :social_links, meta_title = :meta_title, meta_description = :meta_description, meta_keywords = :meta_keywords, canonical_url = :canonical_url, og_image = :og_image, robots = :robots, schema_json = :schema_json WHERE slug = :slug"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); } else { $sql = "INSERT INTO cms_authors (name, slug, bio, avatar, role, social_links, meta_title, meta_description, meta_keywords, canonical_url, og_image, robots, schema_json) VALUES (:name, :slug, :bio, :avatar, :role, :social_links, :meta_title, :meta_description, :meta_keywords, :canonical_url, :og_image, :robots, :schema_json)"; $stmt = $pdo->prepare($sql); $stmt->execute($payload); } } function cms_delete_category($slug) { $pdo = cms_db(); if (!$pdo) { return; } $stmt = $pdo->prepare("DELETE FROM cms_categories WHERE slug = ?"); $stmt->execute([$slug]); } function cms_delete_tag($slug) { $pdo = cms_db(); if (!$pdo) { return; } $stmt = $pdo->prepare("DELETE FROM cms_tags WHERE slug = ?"); $stmt->execute([$slug]); } function cms_delete_author($slug) { $pdo = cms_db(); if (!$pdo) { return; } $stmt = $pdo->prepare("DELETE FROM cms_authors WHERE slug = ?"); $stmt->execute([$slug]); } ?> ��C�f�