-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: hosttiller_hosttiller
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client_services`
--

DROP TABLE IF EXISTS `client_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `group` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT 'Active',
  `billing_cycle` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT 0.00,
  `currency` varchar(255) DEFAULT 'USD',
  `next_due` varchar(255) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `server` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `created_at_date` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client_services`
--

LOCK TABLES `client_services` WRITE;
/*!40000 ALTER TABLE `client_services` DISABLE KEYS */;
INSERT INTO `client_services` VALUES (4,3,'Starter Web Hosting','Shared Hosting','Active','Monthly',6.99,'USD','2026-10-01 16:22:05','demo-client.com','srv-01.hosttiller.com','democlient',NULL,'2026-08-31 16:22:05','2026-08-31 16:22:05'),(5,3,'Business Pro Hosting','Shared Hosting','Active','Annually',79.90,'USD','2027-07-01 16:22:05','business.demo-client.com','srv-02.hosttiller.com','bizclient',NULL,'2026-08-31 16:22:05','2026-08-31 16:22:05'),(6,3,'Starter Web Hosting','Shared Hosting','Suspended','Monthly',6.99,'USD','2026-08-26 16:22:06','old-demo-client.com','srv-03.hosttiller.com','oldclient',NULL,'2026-08-31 16:22:06','2026-08-31 16:22:06');
/*!40000 ALTER TABLE `client_services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faqs`
--

DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `faqs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faqs`
--

LOCK TABLES `faqs` WRITE;
/*!40000 ALTER TABLE `faqs` DISABLE KEYS */;
INSERT INTO `faqs` VALUES (89,'Can I migrate my existing website for free?','Yes. Every customer gets a free professional migration. Open a support ticket with your cPanel access and our team will move your site, databases and emails ΓÇö usually within 24 hours ΓÇö with zero downtime.',1,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(90,'What kind of uptime guarantee do you offer?','We guarantee 99.9% network and server uptime. If availability drops below that, we credit your account automatically. Status is transparent and live at status.hosttiller.com.',2,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(91,'Do you take automatic backups?','Absolutely. Backups run automatically every day for shared plans and every hour for VPS. You can restore anything ΓÇö a file, the database, or the whole account ΓÇö from the dashboard in one click.',3,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(92,'Will my site load fast on Shared hosting?','Our shared plans run on LiteSpeed enterprise servers with NVMe storage, HTTP/3, object cache and a free global CDN. Most customers see faster performance on HostTiller Shared than on other hostsΓÇÖ VPS plans.',4,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(93,'What happens after the 30-day money-back guarantee?','You can cancel at any time from your dashboard with no cancellation fee, and we refund the unused portion of your billing period. Data is exported or migrated on request.',5,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(94,'Do you charge for SSL certificates?','No. Every plan ΓÇö including Starter ΓÇö includes a free LetΓÇÖs Encrypt SSL certificate automatically installed, plus auto-renewal so your padlock never disappears.',6,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(95,'Can I upgrade my plan later without downtime?','Yes. Upgrades are instant and prorated. You keep the same account, emails and files, and we never require you to rebuild anything.',7,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(96,'What payment methods do you accept?','We accept all major credit/debit cards, PayPal, bank transfer and popular local payment methods. Annual and biennial plans unlock extra savings.',8,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(97,'Do you accept bKash, Nagad or rocket payments?','Yes. Bangladeshi customers can pay in Taka via bKash, Nagad and rocket directly from their mobile wallet. We also accept bank transfer and international cards for larger orders like dedicated servers.',9,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(98,'Is your hosting fast for visitors inside Bangladesh?','Yes. Our servers connect to BDIX (Bangladesh Internet Exchange), so Bangladeshi visitors get very low latency from Dhaka, Chittagong and other cities. VPS and dedicated plans include BDIX bandwidth plus international connectivity for global visitors.',10,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(99,'Do you support .com.bd domain registration?','Yes, we help register and renew .com.bd and .bd domains for local businesses through accredited registrars. Contact us with your trade licence and we will guide you through the process.',11,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(100,'Can you migrate my website from another Bangladeshi host?','Yes. Migration is free on every plan. Just open a ticket with your current cPanel access and our team moves your site, databases and emails, usually within 24 hours and with zero downtime.',12,1,'2026-09-07 16:45:41','2026-09-07 16:45:41'),(101,'Do you offer discounts for annual or festival offers?','We run regular promotions for new customers plus annual-plan discounts. Watch the offers page and our social channels for festival deals during Eid, Pohela Boishakh and 10:10 shopping days.',13,1,'2026-09-07 16:45:41','2026-09-07 16:45:41');
/*!40000 ALTER TABLE `faqs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `features`
--

DROP TABLE IF EXISTS `features`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `features` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) DEFAULT 'star',
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `features`
--

LOCK TABLES `features` WRITE;
/*!40000 ALTER TABLE `features` DISABLE KEYS */;
INSERT INTO `features` VALUES (53,'shield','99.9% Uptime SLA','Redundant power, networking and enterprise hardware keep your site online.',1,1,'2026-09-04 13:54:03','2026-09-04 13:54:03'),(54,'zap','NVMe SSD Speed','LiteSpeed servers with NVMe drives load pages up to 10x faster.',2,1,'2026-09-04 13:54:03','2026-09-04 13:54:03'),(55,'backup','Daily Automatic Backups','Restore any previous day in one click. Your data is never lost.',3,1,'2026-09-04 13:54:03','2026-09-04 13:54:03'),(56,'globe','Free SSL + CDN','Security and a global edge network included in every single plan.',4,1,'2026-09-04 13:54:03','2026-09-04 13:54:03');
/*!40000 ALTER TABLE `features` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice_items`
--

DROP TABLE IF EXISTS `invoice_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoice_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `qty` int(11) DEFAULT 1,
  `amount` decimal(10,2) DEFAULT 0.00,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_items`
--

LOCK TABLES `invoice_items` WRITE;
/*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */;
INSERT INTO `invoice_items` VALUES (3,3,'Starter Web Hosting - Monthly',1,6.99,'2026-08-31 16:22:06','2026-08-31 16:22:06'),(4,4,'Business Pro Hosting - Annual',1,79.90,'2026-08-31 16:22:06','2026-08-31 16:22:06');
/*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `number` varchar(255) NOT NULL,
  `date_due` varchar(255) NOT NULL,
  `total` decimal(10,2) DEFAULT 0.00,
  `currency` varchar(255) DEFAULT 'USD',
  `status` varchar(255) DEFAULT 'Unpaid',
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES (3,3,'INV-DEMO-1001','2026-09-07 16:22:06',6.99,'USD','Unpaid','2026-08-31 16:22:06','2026-08-31 16:22:06'),(4,3,'INV-DEMO-1002','2026-08-24 16:22:06',79.90,'USD','Paid','2026-08-31 16:22:06','2026-08-31 16:22:06');
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kb_articles`
--

DROP TABLE IF EXISTS `kb_articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kb_articles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `slug` varchar(160) NOT NULL,
  `title` varchar(255) NOT NULL,
  `summary` text NOT NULL,
  `steps` text DEFAULT NULL,
  `views` int(11) DEFAULT 0,
  `minutes` int(11) DEFAULT 3,
  `updated_label` varchar(255) DEFAULT '2 days ago',
  `status` int(11) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `kb_articles_slug_unique` (`slug`),
  KEY `kb_articles_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kb_articles`
--

LOCK TABLES `kb_articles` WRITE;
/*!40000 ALTER TABLE `kb_articles` DISABLE KEYS */;
INSERT INTO `kb_articles` VALUES (1,'getting-started','how-to-order-a-hosting-plan','How to order a hosting plan','Step-by-step guide to buying your first hosting package with HostTiller.','[\"Visit the pricing page and choose the plan that fits your needs (Shared, WordPress, VPS, etc.).\",\"Click \\u201cOrder\\u201d and select your billing cycle \\u2014 monthly or yearly (yearly saves up to 15%).\",\"Enter your domain or register a new one during checkout.\",\"Complete your payment securely via card or bank transfer.\",\"Your services are provisioned automatically \\u2014 you will receive email login details within minutes.\",\"Log in to your client area and open cPanel to start building.\"]',1240,4,'2 days ago',1,1,'2026-08-31 14:43:29','2026-08-31 14:43:29'),(2,'getting-started','logging-in-to-your-cpanel-for-the-first-time','Logging in to your cPanel for the first time','Find your cPanel URL and learn the essentials of the control panel.','[\"Log in to your HostTiller client area and open the \\u201cServices\\u201d tab.\",\"Select your hosting package and click \\u201cLogin to cPanel\\u201d (or use the cPanel URL from your welcome email).\",\"Enter your cPanel username and password (included in your welcome email).\",\"Once inside, bookmark the address for quick access next time.\",\"Explore the File Manager, Email Accounts, Domains and Databases sections.\"]',980,6,'3 days ago',1,2,'2026-08-31 14:43:29','2026-08-31 14:43:29'),(3,'website','install-wordpress-in-one-click','Install WordPress in one click','Use Softaculous to install WordPress with SSL, cache and security pre-configured.','[\"Log in to cPanel and open the \\u201cSoftaculous Apps Installer\\u201d.\",\"Click the WordPress icon and then \\u201cInstall\\u201d.\",\"Choose your domain and directory (leave blank to install at the root).\",\"Enter your site name, admin username and a strong password.\",\"Select a theme and language, then click \\u201cInstall\\u201d.\",\"WordPress is installed in seconds \\u2014 click your domain to start customising.\"]',2100,5,'1 day ago',1,3,'2026-08-31 14:43:29','2026-08-31 14:43:29'),(4,'website','connect-your-domain-to-hosting','Connect your domain to hosting','Point your registered domain to HostTiller nameservers or an A-record.','[\"Find your nameservers in your HostTiller welcome email (e.g. ns1.hosttiller.com \\/ ns2.hosttiller.com).\",\"Log in to your domain registrar, not HostTiller.\",\"Open the DNS or Nameserver settings and replace the current nameservers.\",\"Save the changes. Propagation usually completes within 24\\u201348 hours.\",\"If you only want to point one subdomain, create an A-record to your server IP instead.\"]',1750,7,'4 days ago',1,4,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(5,'email','create-an-email-account-in-cpanel','Create an email account in cPanel','Set up professional email addresses under your own domain.','[\"Log in to cPanel and open \\u201cEmail Accounts\\u201d.\",\"Enter the mailbox name (e.g. info) and choose your domain.\",\"Set a strong password and a storage quota.\",\"Click \\u201cCreate\\u201d. Your email is ready to use immediately.\",\"Configure the account in Outlook, Gmail or your phone using the IMAP\\/POP3 settings shown.\"]',890,4,'2 days ago',1,5,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(6,'email','configure-outlook-for-your-email','Configure Outlook for your email','Automatic and manual setup of your hosting email in Microsoft Outlook.','[\"Open Outlook and go to File \\u2192 Add Account.\",\"Enter your full email address, then click \\u201cConnect\\u201d.\",\"Enter the password. Outlook will attempt automatic configuration via autodiscover.\",\"If manual setup is needed, choose IMAP:\",\"IMAP server: mail.yourdomain.com, port 993 (SSL).\",\"SMTP server: mail.yourdomain.com, port 465 (SSL) or 587 (TLS) with your full email as username.\"]',640,8,'5 days ago',1,6,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(7,'security','install-a-free-ssl-certificate','Install a free SSL certificate','Secure your site with a free LetΓÇÖs Encrypt or AutoSSL certificate.','[\"Log in to cPanel and open \\u201cSSL\\/TLS Status\\u201d.\",\"HostTiller provides Automatic SSL (AutoSSL) on all domains.\",\"If the certificate is not issued yet, click \\u201cRun AutoSSL\\u201d.\",\"Certificate issues within minutes. Ensure your domain resolves correctly first.\",\"Verify the padlock by visiting https:\\/\\/yourdomain.com\"]',1530,3,'1 day ago',1,7,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(8,'vps','deploy-a-vps-and-connect-via-ssh','Deploy a VPS and connect via SSH','Provision your KVM VPS and log in securely for the first time.','[\"Order a VPS and choose your region \\u2014 Dhaka, Frankfurt, Singapore or US East.\",\"Select an OS image (Ubuntu, Debian, CentOS, AlmaLinux, Rocky or Windows).\",\"Your VPS is deployed in seconds. You will receive the IP, root password and SSH info.\",\"Open a terminal and run:  ssh root@YOUR_IP\",\"Enter the password from your email, then change it immediately with the passwd command.\",\"Install Docker, a web stack or your favourite apps to get started.\"]',1120,9,'2 days ago',1,8,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(9,'domains','transfer-your-domain-to-hosttiller','Transfer your domain to HostTiller','Bring your domain under one roof with our simple transfer process.','[\"Unlock your domain at your current registrar and request an EPP\\/authorisation code.\",\"Search your domain in the transfer tool at HostTiller and add it to cart.\",\"Enter the EPP code and complete payment \\u2014 the transfer fee renews your domain for a year.\",\"We start the transfer request; you approve it via the email from your old registrar.\",\"The transfer completes automatically within 5\\u20137 days.\"]',720,6,'3 days ago',1,9,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(10,'billing','how-invoice-and-renewal-billing-works','How invoice and renewal billing works','Understand invoices, due dates, automatic renewals and grace periods.','[\"Invoices are generated automatically 7 days before each billing cycle ends.\",\"HostTiller sends a reminder by email \\u2014 no action means automatic debit if a card is stored.\",\"If you miss the due date, services enter a grace period before suspension.\",\"You can pay any unpaid invoice anytime from the \\u201cInvoices\\u201d section of your client area.\",\"Switch between monthly and yearly billing anytime to save on discounts.\"]',830,4,'4 days ago',1,10,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(11,'troubleshooting','website-not-loading-quick-fixes','Website not loading? Quick fixes','Diagnose 500 errors, white screens and DNS issues step by step.','[\"Check if the issue affects only you \\u2014 use an online \\u201cdown for everyone\\u201d tool.\",\"Refresh your DNS by clearing your browser cache or using a private window.\",\"Restart your PHP or check for a recent plugin\\/theme change in WordPress.\",\"Review cPanel error logs under \\u201cMetrics \\u2192 Errors\\u201d for the root cause.\",\"Verify your domain still points to the correct nameservers.\",\"If nothing resolves it, submit a support ticket with the exact error message.\"]',1980,6,'6 hours ago',1,11,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(12,'security','enable-ddos-protection-for-your-site','Enable DDoS protection for your site','Always-on shielding keeps your website online during attacks.','[\"All HostTiller plans include always-on DDoS protection at the network level.\",\"For VPS and dedicated servers, ensure your traffic is routed through our protected IP.\",\"Contact support to raise the protection mode for sustained large attacks.\",\"Consider a CDN for extra application-level protection and caching.\"]',460,3,'5 days ago',1,12,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(13,'website','upload-your-website-with-file-manager','Upload your website with File Manager','Add files and build your site directly from cPanel without FTP.','[\"Log in to cPanel and open \\u201cFile Manager\\u201d.\",\"Navigate to public_html \\u2014 this is your website root.\",\"Click \\u201cUpload\\u201d and choose your files, or use \\u201cNew Folder\\u201d to organise.\",\"Your index file (index.html, index.php) will be served automatically.\",\"Set permissions if needed, though defaults work for most cases.\"]',610,5,'2 days ago',1,13,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(14,'domains','add-a-subdomain-to-your-hosting','Add a subdomain to your hosting','Create subdomains like blog.yourdomain.com in minutes.','[\"Open cPanel \\u2192 \\u201cSubdomains\\u201d.\",\"Enter the subdomain name (e.g. blog) and choose your main domain.\",\"Set the document root (default is recommended).\",\"Click \\u201cCreate\\u201d. A folder is created where its files are served.\",\"Upload files to that folder to make the subdomain live.\"]',380,4,'6 days ago',1,14,'2026-08-31 14:43:30','2026-08-31 14:43:30'),(15,'billing','upgrade-your-hosting-plan','Upgrade your hosting plan','Move to a bigger plan without any downtime.','[\"Log in to your client area and open the service you want to upgrade.\",\"Click \\u201cUpgrade \\/ Downgrade options\\u201d.\",\"Choose your new plan \\u2014 the system calculates the price difference automatically.\",\"Complete payment; the upgrade applies instantly with no data loss.\",\"Your site keeps running throughout \\u2014 zero downtime.\"]',540,5,'3 days ago',1,15,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(16,'email','fix-emails-not-sending-or-receiving','Fix emails not sending or receiving','Common causes and solutions for email delivery problems.','[\"Check your outbound port: use SMTP port 465 or 587, not 25 (often blocked).\",\"Confirm SPF and DKIM records exist in cPanel \\u2192 \\u201cEmail Deliverability\\u201d.\",\"Ensure the mailbox is not full \\u2014 check quota usage.\",\"Verify MX records point to mail.yourdomain.com.\",\"Test sending to a different provider to isolate the issue.\",\"Open a ticket with the exact bounce-back error for fast diagnosis.\"]',990,7,'1 day ago',1,16,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(17,'vps','install-docker-on-your-vps','Install Docker on your VPS','Set up Docker and run containers in a few commands.','[\"Connect to your VPS via SSH.\",\"Run: curl -fsSL https:\\/\\/get.docker.com | sh\",\"Add your user to the docker group: usermod -aG docker $USER\",\"Log out and back in, then test with: docker run hello-world\",\"Use docker compose for multi-container apps.\"]',710,8,'2 days ago',1,17,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(18,'troubleshooting','fix-your-connection-is-not-private','Fix ΓÇ£Your connection is not privateΓÇ¥','Resolve broken padlock errors caused by SSL issues.','[\"Ensure SSL is installed for your exact domain (including www).\",\"In cPanel, open \\u201cSSL\\/TLS Status\\u201d and run AutoSSL.\",\"If your site loads mixed content, force HTTPS via .htaccess or plugin.\",\"Clear browser cache and re-try.\",\"For a freshly connected domain, wait for DNS propagation then re-issue SSL.\"]',760,3,'4 days ago',1,18,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(19,'security','create-a-database-with-phpmyadmin','Create a database with phpMyAdmin','Set up MySQL databases for WordPress or custom apps.','[\"In cPanel, open \\u201cMySQL Databases\\u201d.\",\"Create a new database and give it a name.\",\"Create a MySQL user and set a strong password.\",\"Add the user to the database with \\u201cAll Privileges\\u201d.\",\"Open phpMyAdmin to import or manage your data.\"]',520,5,'5 days ago',1,19,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(20,'getting-started','the-hosttiller-client-area-explained','The HostTiller client area explained','Everything you can do from your account dashboard at a glance.','[\"Services: view and manage all your hosting, domains and add-ons.\",\"Invoices: see pending and paid invoices, and make payments.\",\"Domains: manage DNS, renewals and privacy for your domains.\",\"Support: open tickets, view your knowledgebase history and chat with us.\",\"Downloads: access license keys, backups and documentation.\"]',690,5,'2 days ago',1,20,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(21,'website','point-an-a-record-to-your-server','Point an A-record to your server','Use a bare A-record to connect hosting without changing nameservers.','[\"Find your server IP in your welcome email or client area.\",\"Go to your DNS provider (often your registrar).\",\"Create or edit an A-record for @ pointing to your server IP.\",\"Add a second A-record for www pointing to the same IP.\",\"Propagation takes a few minutes to 24 hours.\"]',430,4,'6 days ago',1,21,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(22,'vps','take-and-restore-a-vps-snapshot','Take and restore a VPS snapshot','Protect your server with on-demand and scheduled snapshots.','[\"Open your VPS in the client area and go to \\u201cSnapshots\\u201d.\",\"Click \\u201cCreate Snapshot\\u201d to save the current state.\",\"Schedule automatic snapshots for daily or weekly protection.\",\"To restore, select a snapshot and click \\u201cRestore\\u201d.\",\"Snapshots capture the full disk, so you can roll back any change.\"]',300,4,'3 days ago',1,22,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(23,'billing','update-your-payment-method','Update your payment method','Add, remove or change the card used for renewals.','[\"Log in to your client area and open \\u201cAccount \\u2192 Payment Methods\\u201d.\",\"Click \\u201cAdd Payment Method\\u201d to enter a new card or bank details.\",\"Set it as default for automatic renewals.\",\"Remove old methods once replaced.\",\"You can also pay each invoice manually from the Invoices page.\"]',410,3,'5 days ago',1,23,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(24,'getting-started','set-up-2fa-on-your-account','Set up 2FA on your account','Add an extra layer of security to your HostTiller login.','[\"Log in and go to \\u201cAccount \\u2192 Security\\u201d.\",\"Click \\u201cEnable Two-Factor Authentication\\u201d.\",\"Scan the QR code with an authenticator app (like Google Authenticator).\",\"Enter the 6-digit code shown to verify.\",\"Save your backup codes \\u2014 you will need them if you lose your phone.\"]',350,6,'4 days ago',1,24,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(25,'website','enable-litespeed-cache-for-wordpress','Enable LiteSpeed Cache for WordPress','Boost page speed with server-level caching in one click.','[\"Log in to your WordPress admin dashboard.\",\"Go to Plugins \\u2192 Add New and search for \\u201cLiteSpeed Cache\\u201d.\",\"Install and activate the plugin.\",\"Run the setup wizard: it enables caching, image optimisation and CDN.\",\"Test your site speed \\u2014 most sites see a dramatic improvement.\"]',1880,5,'12 hours ago',1,25,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(26,'troubleshooting','my-site-is-slow-what-should-i-check','My site is slow ΓÇö what should I check?','A quick performance checklist to speed up a sluggish website.','[\"Enable caching (LiteSpeed Cache for WordPress, or server-level cache).\",\"Compress images \\u2014 use lossy formats like WebP.\",\"Minify CSS and JavaScript, and remove unused plugins.\",\"Check your PHP version \\u2014 newer versions are much faster.\",\"Offload large files to a CDN or object storage.\",\"Review resource usage in cPanel to see if you need a bigger plan.\"]',1340,8,'1 day ago',1,26,'2026-08-31 14:43:31','2026-08-31 14:43:31'),(27,'security','enable-backups-and-restore-your-site','Enable backups and restore your site','Automatic off-site backups with one-click restore.','[\"HostTiller runs daily off-site backups on all plans.\",\"To restore, open cPanel \\u2192 \\u201cBackups\\u201d or use JetBackup if installed.\",\"Select a backup date and choose files or a full restore.\",\"You can also download a backup to keep off-platform.\",\"Verify your restore to confirm everything works.\"]',820,4,'3 days ago',1,27,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(28,'domains','renew-your-domain-before-it-expires','Renew your domain before it expires','Keep your domain safe with timely and multi-year renewals.','[\"Check your domain expiry date in the client area \\u201cDomains\\u201d tab.\",\"Renew manually anytime to lock in the current price.\",\"Enable auto-renew to avoid accidental loss.\",\"Renew for multiple years to save and secure the name long-term.\",\"After expiry, a redemption grace period applies before release.\"]',480,3,'2 days ago',1,28,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(29,'vps','resize-or-upgrade-your-vps','Resize or upgrade your VPS','Scale CPU, RAM and storage up without reinstalling.','[\"Open your VPS in the client area and choose \\u201cResize \\/ Upgrade\\u201d.\",\"Pick the new size (more vCPU, RAM or NVMe).\",\"Confirm \\u2014 the upgrade applies with very brief downtime.\",\"For a live resize, no OS reinstall is needed.\",\"Your data, apps and IP stay intact.\"]',380,5,'5 days ago',1,29,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(30,'email','create-an-email-forwarder','Create an email forwarder','Forward emails from one address to another automatically.','[\"Open cPanel \\u2192 \\u201cForwarders\\u201d.\",\"Click \\u201cAdd Forwarder\\u201d.\",\"Enter the address to forward from and the destination address.\",\"Click \\u201cAdd\\u201d. Forwarding is active immediately.\",\"Use a catch-all forwarder to capture mail to any address on your domain.\"]',290,3,'6 days ago',1,30,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(31,'whmcs','how-to-use-your-whmcs-license','How to use your WHMCS license','Install your HostTiller license key and fix the version-locked License.php file after any update.','[\"After ordering, download the License.php file and your license key from the HostTiller client area (or contact support on WhatsApp: +880 1911336699).\",\"Upload your original WHMCS files to the folder where your billing system runs (public_html or a subdomain).\",\"Locate the license file in your install at: YOUR-WHMCS-PATH\\/vendor\\/whmcs\\/whmcs-foundation\\/lib\\/License.php\",\"Back up the existing License.php, then replace it with the fresh file you downloaded from HostTiller.\",\"Restart the PHP process or clear the WHMCS template cache so the new license takes effect.\",\"Log in to your WHMCS admin area to confirm the license validates correctly.\"]',860,8,'1 day ago',1,31,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(32,'whmcs','update-whmcs-and-fix-license-errors','Update WHMCS (and fix license errors)','Run the built-in or manual updater and resolve the common license error page after upgrading.','[\"Method 1 \\u2014 Automatic updater: log in to the WHMCS admin area and open \\u201cUpdates\\u201d to install the newest release automatically.\",\"Method 2 \\u2014 Manual browser update: upload the latest package over your existing install and follow the on-screen upgrade wizard.\",\"If you see a license error page after upgrading, your License.php version no longer matches \\u2014 this is expected after major updates.\",\"Download a fresh License.php file from the HostTiller client area (or contact support on WhatsApp: +880 1911336699).\",\"Replace the file at YOUR-WHMCS-PATH\\/vendor\\/whmcs\\/whmcs-foundation\\/lib\\/License.php with the new one.\",\"If WHMCS also requires a newer PHP version, upgrade PHP using cPanel \\u201cMultiPHP\\u201d \\u2014 WHMCS publishes a guided walkthrough at help.whmcs.com.\"]',720,9,'2 days ago',1,32,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(33,'getting-started','open-and-manage-a-support-ticket','Open and manage a support ticket','How to reach our 24/7 team, submit a ticket and get the fastest resolution.','[\"Log in to your HostTiller client area and click \\u201cSupport \\u2192 Open Ticket\\u201d.\",\"Choose the department that best matches your issue (Billing, Technical, Sales).\",\"Select the related service\\/product so we can see your account context instantly.\",\"Write a clear subject and include error messages, screenshots or the exact URL.\",\"Submit and you will get an email confirmation \\u2014 reply to that email to add details.\",\"Average first response is under 4 minutes, around the clock.\"]',1540,4,'4 hours ago',1,33,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(34,'getting-started','access-your-files-with-ftp-or-sftp','Access your files with FTP or SFTP','Connect to your hosting account with an FTP client for fast bulk transfers.','[\"Create an FTP account in cPanel \\u2192 \\u201cFTP Accounts\\u201d.\",\"Note the hostname (ftp.yourdomain.com) and the username\\/password you set.\",\"Open an FTP client like FileZilla and enter Host \\/ Username \\/ Password \\/ Port 21.\",\"For encrypted connections, use SFTP with port 22 and your cPanel login.\",\"Connect, and drag files between your computer and public_html.\",\"Always keep an index file (index.html \\/ index.php) at the root to display your site.\"]',680,6,'3 days ago',1,34,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(35,'website','back-up-your-website-before-big-changes','Back up your website before big changes','Protect against mistakes by taking a manual backup before updates or edits.','[\"Log in to cPanel and open \\u201cBackup\\u201d or \\u201cJetBackup\\u201d.\",\"Generate a \\u201cFull Backup\\u201d and download it to your computer.\",\"For WordPress, you can also export your content from the admin dashboard.\",\"Export your databases separately via phpMyAdmin \\u2192 \\u201cExport\\u201d.\",\"Store backups in two places \\u2014 locally and on cloud storage.\",\"Test a restore beforehand so you know the process works.\"]',910,5,'1 day ago',1,35,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(36,'website','migrate-a-site-from-another-host','Migrate a site from another host','Move your WordPress or static site to HostTiller with minimal downtime.','[\"Back up your files and database from your old host.\",\"Set up your domain at HostTiller (add addon\\/subdomain or point nameservers).\",\"Upload your files to public_html via File Manager or FTP.\",\"Create a matching database in cPanel \\u2192 \\u201cMySQL Databases\\u201d and import your SQL dump.\",\"Update the database connection details in your config file (e.g. wp-config.php).\",\"Update the site URL in the database to the new domain if needed.\",\"Test the site, then update DNS\\/nameservers to complete the cutover.\",\"Request a free migration from support \\u2014 we often handle this for you.\"]',740,12,'2 days ago',1,36,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(37,'email','set-up-spf-dkim-and-dmarc','Set up SPF, DKIM and DMARC','Authenticate your email so messages reach the inbox, not spam.','[\"Open cPanel \\u2192 \\u201cEmail Deliverability\\u201d to see your current authentication records.\",\"Ensure an SPF record exists: v=spf1 +a +mx ~all (or use your mail provider).\",\"Enable DKIM so your emails carry a signed, trusted header.\",\"Add a DMARC record for reporting, e.g. v=DMARC1; p=none; rua=mailto:you@yourdomain.com.\",\"Your hosting nameservers manage these automatically \\u2014 just confirm they are active.\",\"Wait up to 24 hours for DNS to propagate, then test with an online mailbox validator.\"]',830,7,'6 hours ago',1,37,'2026-08-31 14:43:32','2026-08-31 14:43:32'),(38,'email','configure-email-on-your-iphone-or-android','Configure email on your iPhone or Android','Set up your hosting email using POP3/IMAP on your phone.','[\"Open your device Settings and go to Mail \\u2192 Accounts \\u2192 Add Account \\u2192 Other.\",\"Choose \\u201cAdd Mail Account\\u201d and enter your name, email address and password.\",\"Select IMAP (recommended) or POP3 and enter the incoming server: mail.yourdomain.com.\",\"Set the outgoing (SMTP) server to mail.yourdomain.com, port 587 (TLS) or 465 (SSL).\",\"Use your full email address as the username for both incoming and outgoing.\",\"Save and verify by sending a test email from your phone.\"]',560,6,'4 days ago',1,38,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(39,'domains','point-nameservers-from-your-registrar','Point nameservers from your registrar','Connect a domain registered elsewhere to your HostTiller hosting.','[\"Find the nameservers in your HostTiller welcome email, e.g. ns1.hosttiller.com and ns2.hosttiller.com.\",\"Log in to the registrar where your domain is registered (GoDaddy, Namecheap, etc.).\",\"Open the domain\\u2019s DNS or Nameserver management page.\",\"Replace the existing nameservers with the HostTiller ones.\",\"Save. Propagation typically completes within 24\\u201348 hours.\",\"Your site and email become fully hosted with us once DNS resolves.\"]',490,4,'3 days ago',1,39,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(40,'domains','enable-domain-whois-privacy','Enable domain WHOIS privacy','Hide your personal details from public WHOIS lookups.','[\"Log in to your client area and open the \\u201cDomains\\u201d section.\",\"Select your domain and go to privacy \\/ WHOIS protection settings.\",\"Enable \\u201cWHOIS Privacy Protection\\u201d to mask your contact details.\",\"Some hosts include this free; otherwise it is offered as an optional add-on.\",\"Confirm the change in your profile and re-check after 24 hours with a WHOIS lookup.\"]',320,3,'5 days ago',1,40,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(41,'security','harden-your-wordpress-site','Harden your WordPress site','Simple steps to block the most common WordPress attacks.','[\"Keep WordPress core, themes and plugins always up to date.\",\"Change your admin username from \\u201cadmin\\u201d and use a strong, unique password.\",\"Enable two-factor authentication with a security plugin (Wordfence, iThemes).\",\"Limit login attempts to slow down brute-force attacks.\",\"Disable file editing and hide the wp-config.php file.\",\"Install LiteSpeed or a security plugin to add a web application firewall.\",\"Run regular scans and keep backups in case you still get hacked.\"]',1180,9,'8 hours ago',1,41,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(42,'security','update-your-site-and-php-version-safely','Update your site and PHP version safely','Keep software patched and choose a supported PHP version.','[\"Open cPanel \\u2192 \\u201cSelect PHP Version\\u201d (MultiPHP Manager).\",\"Choose the latest stable PHP version supported by your application (8.x recommended).\",\"Review your site for compatibility after switching \\u2014 check error logs.\",\"Update WordPress, themes and plugins from the admin dashboard.\",\"Make a backup before major updates and test on a staging copy if possible.\",\"Supported PHP versions stay secure; end-of-life versions (5.x\\/7.x) are a risk.\"]',700,6,'2 days ago',1,42,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(43,'security','protect-your-account-from-malware','Protect your account from malware','Detect and remove viruses, plus how to recover if your site is hacked.','[\"Run a security scan with a plugin or cPanel \\u201cMalware Scanner\\u201d.\",\"Revoke any unknown FTP users and reset all passwords immediately.\",\"Remove any files you do not recognise, especially in public_html.\",\"Reinstall core files by downloading a clean copy for the same version.\",\"Restore from a clean backup taken before the infection.\",\"Open a support ticket \\u2014 we can help clean up and secure your account.\",\"Enable automatic backups so you always have a safe restore point.\"]',520,5,'1 day ago',1,43,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(44,'vps','set-up-a-firewall-on-your-vps','Set up a firewall on your VPS','Restrict access with UFW (Ubuntu) or firewalld (CentOS).','[\"Connect to your VPS via SSH.\",\"On Ubuntu\\/Debian: sudo apt install ufw && sudo ufw default deny incoming.\",\"Allow essential services first: sudo ufw allow 22\\/tcp (SSH), 80, 443.\",\"Enable the firewall: sudo ufw enable.\",\"On CentOS\\/AlmaLinux: sudo systemctl enable --now firewalld, then firewall-cmd --add-service=http.\",\"Always allow SSH before enabling, or you may lock yourself out.\"]',410,7,'4 days ago',1,44,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(45,'vps','automate-tasks-with-cron-jobs','Automate tasks with cron jobs','Schedule backups, cache clearing and cleanups on a timer.','[\"Open cPanel \\u2192 \\u201cCron Jobs\\u201d.\",\"Choose how often in minutes, hours, days, months and weekdays.\",\"Enter the command to run, e.g. \\/usr\\/bin\\/php \\/home\\/user\\/public_html\\/backup.php.\",\"Enter an email to receive the output\\/logs from each run.\",\"Click \\u201cAdd New Cron Job\\u201d \\u2014 the schedule becomes active immediately.\",\"Test the command manually once to make sure it works.\"]',350,5,'5 days ago',1,45,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(46,'website','create-redirects-301-302','Create redirects (301 & 302)','Point old URLs or change www vs non-www with proper redirects.','[\"Open cPanel \\u2192 \\u201cRedirects\\u201d.\",\"Choose the type: permanent (301) for moved-forever pages, temporary (302) for short-term.\",\"Enter the old path you want redirected and the destination URL.\",\"Select whether to redirect with or without www.\",\"Create the redirect \\u2014 it takes effect immediately.\",\"Alternatively use an .htaccess file for more advanced rules.\"]',460,5,'3 days ago',1,46,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(47,'billing','claim-a-refund-under-our-policy','Claim a refund under our policy','How our 5-day / 30-day money-back guarantees work.','[\"Refunds are available on shared, cloud, reseller and VPS hosting, and domains.\",\"Monthly plans qualify for a 5-day money-back guarantee.\",\"Annual plans qualify for a 30-day money-back guarantee.\",\"Submit a request from the client area or open a billing support ticket.\",\"Refunds are processed to the original payment method within a few business days.\",\"Add-on or domain registrations may not be refundable \\u2014 check the terms.\"]',620,3,'2 days ago',1,47,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(48,'billing','change-or-cancel-your-subscription','Change or cancel your subscription','Control auto-renewals, cancel services and export your data first.','[\"Log in to your client area and open the service under \\u201cServices\\u201d.\",\"To stop auto-renewal, disable \\u201cAuto Renew\\u201d on the service or payment method.\",\"To cancel, click the cancellation request option and confirm the reason.\",\"Before cancellation, back up your files, databases and email.\",\"Review your invoices so you understand any final payment due.\",\"Reach out if you only want to downgrade instead of cancel.\"]',380,4,'4 days ago',1,48,'2026-08-31 14:43:33','2026-08-31 14:43:33'),(49,'troubleshooting','how-to-clear-your-dns-cache','How to clear your DNS cache','Fix ΓÇ£site not loading / DNS errorΓÇ¥ by flushing your resolver cache on any operating system.','[\"Your computer caches IP addresses of sites you have visited \\u2014 if an IP changes, you may see errors until the cache updates.\",\"Windows: press Start, type \\u201ccmd\\u201d, right-click Command Prompt and choose \\u201cRun as administrator\\u201d.\",\"Windows: run the command  ipconfig \\/flushdns  \\u2014 you should see \\u201cSuccessfully flushed the DNS Resolver Cache\\u201d.\",\"macOS (10.10.4 or newer): open Applications \\u2192 Utilities \\u2192 Terminal and run  sudo killall -HUP mDNSResponder .\",\"ChromeOS: open a new tab, go to chrome:\\/\\/net-internals , select \\u201cDNS\\u201d and click \\u201cClear host cache\\u201d.\",\"Ubuntu: run  sudo resolvectl flush-caches . Other Linux: run  systemctl restart nscd .\",\"After flushing, your computer re-queries nameservers and caches the fresh IP addresses.\",\"If problems persist, check your \\/etc\\/hosts file for outdated entries (skip this on shared cloud hosting).\"]',1120,5,'1 day ago',1,49,'2026-08-31 14:43:34','2026-08-31 14:43:34'),(50,'security','take-a-full-backup-with-the-backup-wizard','Take a full backup with the Backup Wizard','Back up your entire cPanel account ΓÇö files, emails, databases and settings ΓÇö in a few clicks.','[\"Keep regular backups as a healthy habit \\u2014 essential before any migration or major change.\",\"Log in to cPanel at https:\\/\\/yourdomain.com:2083 or https:\\/\\/yourdomain.com\\/cpanel.\",\"Open \\u201cFiles \\u2192 Backup Wizard\\u201d.\",\"Click \\u201cBack Up\\u201d to start the backup process.\",\"Choose \\u201cFull Account Backup\\u201d to capture everything \\u2014 files, emails, databases, forwarders, filters and FTP accounts.\",\"Select a \\u201cBackup Destination\\u201d (e.g. Home Directory) and add a notification email, or choose no email.\",\"Click \\u201cGenerate Backup\\u201d and wait for completion \\u2014 the file lands in your chosen destination.\",\"Optional: send the backup to a Remote FTP Server or Secure Copy (SCP) destination using the requested credentials.\"]',980,6,'2 days ago',1,50,'2026-08-31 14:43:34','2026-08-31 14:43:34'),(51,'website','ecommerce-hosting-in-bangladesh','E-commerce hosting for online shops in Bangladesh','What to look for when hosting an online store in Bangladesh ΓÇö speed, SSL, SSLCommercer/bKash checkout, and load handling.','[\"Online shops in Bangladesh sell to local customers, so hosting with BDIX connectivity gives fast page loads for Dhaka, Chittagong and Sylhet shoppers.\",\"Choose web hosting that includes a free SSL certificate so your checkout page is secure and shows the padlock \\u2014 essential for customer trust and Google.\",\"Make sure your plan can handle product images and transactions: daily backups, NVMe SSD storage and enough bandwidth for traffic spikes.\",\"For stores running WooCommerce or other CMS platforms, use shared or WordPress hosting with LiteSpeed cache so the shop stays fast under load.\",\"Accept local payments: ensure your store connects to bKash, Nagad, rocket or SSLCommerz gateways, which pair well with WHMCS-based billing.\",\"Start on a shared or WordPress plan, then scale to VPS when your store grows to thousands of daily visits.\"]',1860,7,'1 week ago',1,51,'2026-09-07 15:00:15','2026-09-07 15:58:36'),(52,'domains','com-bd-vs-com-domain-bangladesh','.com.bd vs .com for a Bangladeshi business','Understand the difference between .com.bd, .bd and .com ΓÇö and which is right for your brand in Bangladesh.','[\".com.bd and .bd are Bangladesh\\u2019s official country-code domains; .com is the global favourite.\",\".com.bd signals a local Bangladeshi business and is run by BTRC through registered registrars, whereas .com is managed internationally and can be registered instantly.\",\"A .com.bd (or .bd) domain helps with local trust and geo-relevance, while a .com is easier to remember for international customers.\",\"Many Bangladeshi companies register both \\u2014 the .com for global reach and the .com.bd to protect their local brand \\u2014 then point both to the same website.\",\"Check availability with HostTiller, then connect the domain to web hosting in Bangladesh so it resolves and loads fast for local visitors.\",\"Both work with your hosting DNS; you can forward one domain to the other to avoid duplicate content.\"]',1420,6,'1 week ago',1,52,'2026-09-07 15:00:15','2026-09-07 15:58:36'),(53,'vps','offshore-hosting-for-bangladesh','Offshore hosting and German servers for Bangladesh','Why some Bangladeshi businesses host outside the country ΓÇö and when to choose a Germany or offshore node.','[\"Offshore hosting means hosting your website or server in a country other than your own \\u2014 commonly Germany, the Netherlands or Singapore.\",\"German (Frankfurt) servers are a popular choice for Bangladeshi businesses that want GDPR-grade data protection, strong privacy laws and European reach.\",\"Offshore hosting can help with content restrictions, cross-border e-commerce, and better performance for customers in Europe or the USA.\",\"Because the physical distance is far, offshore nodes are best for international audiences \\u2014 for Bangladeshi visitors, a BDIX-connected Dhaka server is still fastest.\",\"HostTiller lets you choose a Dhaka, Frankfurt, Singapore or US East region for dedicated and VPS servers.\",\"Many companies run a hybrid: a Dhaka server for local users and a German offshore node for redundancy, privacy or foreign customers.\"]',1280,6,'1 week ago',1,53,'2026-09-07 15:00:15','2026-09-07 15:58:36');
/*!40000 ALTER TABLE `kb_articles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `media`
--

DROP TABLE IF EXISTS `media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `size` int(11) DEFAULT 0,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `media`
--

LOCK TABLES `media` WRITE;
/*!40000 ALTER TABLE `media` DISABLE KEYS */;
/*!40000 ALTER TABLE `media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menus`
--

DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT 'none',
  `href` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `badge` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT 'header',
  `external` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `children` text DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menus`
--

LOCK TABLES `menus` WRITE;
/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
INSERT INTO `menus` VALUES (1,'Home','none','/',NULL,NULL,'header',0,1,0,'[]','2026-08-30 15:59:48','2026-09-03 21:40:11'),(2,'Hosting','rows',NULL,NULL,NULL,'header',0,1,1,'[{\"label\":\"Web Hosting\",\"href\":\"\\/bdix-web-hosting\",\"icon\":\"folder\",\"desc\":\"LiteSpeed NVMe SSD web hosting\",\"external\":false},{\"label\":\"WordPress Hosting\",\"href\":\"\\/wordpress-hosting-in-bangladesh\",\"icon\":\"wind\",\"desc\":\"Managed WP plans on NVMe\",\"external\":false}]','2026-08-30 15:59:48','2026-09-03 21:40:11'),(3,'Reseller Hosting','rows',NULL,NULL,NULL,'header',0,1,2,'[{\"label\":\"Reseller Hosting\",\"href\":\"\\/reseller-hosting-in-bangladesh\",\"icon\":\"layers\",\"desc\":\"Setup your own brand and sell hosting to unlimited clients\",\"external\":false},{\"label\":\"Root Reseller\",\"href\":\"\\/root-reseller-hosting-bangladesh\",\"icon\":\"rocket\",\"desc\":\"Full root access to configure everything yourself\",\"external\":false}]','2026-08-30 15:59:48','2026-09-04 04:46:34'),(4,'Servers','rows',NULL,NULL,NULL,'header',0,1,3,'[{\"label\":\"VPS Server\",\"href\":\"\\/vps-hosting-bangladesh\",\"icon\":\"server\",\"desc\":\"KVM NVMe VPS \\u2014 BD & Germany\",\"external\":false},{\"label\":\"Dedicated Server\",\"href\":\"\\/dedicated-server-in-bangladesh\",\"icon\":\"database\",\"desc\":\"Full-root dedicated machines\",\"external\":false}]','2026-08-30 15:59:48','2026-09-03 21:40:11'),(5,'Domains','none','/buy-domain-in-bangladesh',NULL,NULL,'header',0,1,4,'[]','2026-08-30 15:59:48','2026-09-03 21:40:11'),(7,'Support','rows',NULL,NULL,NULL,'header',0,1,6,'[{\"label\":\"Contact Us\",\"href\":\"\\/contact\",\"icon\":\"mail\",\"desc\":null,\"external\":false},{\"label\":\"About Us\",\"href\":\"\\/about-us\",\"icon\":\"help\",\"desc\":null,\"external\":false},{\"label\":\"Knowledgebase\",\"href\":\"\\/knowledgebase\",\"icon\":\"file\",\"desc\":null,\"external\":false},{\"label\":\"Network Status\",\"href\":\"\\/serverstatus\",\"icon\":\"globe\",\"desc\":null,\"external\":false},{\"label\":\"Terms And Conditions\",\"href\":\"\\/terms-and-conditions\",\"icon\":\"file\",\"desc\":null,\"external\":false},{\"label\":\"Privacy Policy\",\"href\":\"\\/privacy-policy\",\"icon\":\"lock\",\"desc\":null,\"external\":false}]','2026-08-30 15:59:49','2026-09-03 21:40:11'),(8,'Hosting','rows',NULL,'folder',NULL,'footer',0,1,0,'[{\"label\":\"Web Hosting\",\"href\":\"\\/bdix-web-hosting\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"VPS Hosting\",\"href\":\"\\/vps-hosting-bangladesh\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Dedicated Server\",\"href\":\"\\/dedicated-server-in-bangladesh\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Reseller\",\"href\":\"\\/reseller-hosting-in-bangladesh\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Root Reseller\",\"href\":\"\\/root-reseller-hosting-bangladesh\",\"icon\":null,\"desc\":null,\"external\":false}]','2026-09-03 21:10:02','2026-09-03 21:38:35'),(9,'Service','rows',NULL,'layers',NULL,'footer',0,1,1,'[{\"label\":\"Web Site Service\",\"href\":\"\\/web-service\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Server Maintain\",\"href\":\"\\/server-maintain\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"RC License Combo\",\"href\":\"\\/rc-license\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Sis Combo License\",\"href\":\"\\/sis-license\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Seo Service\",\"href\":\"\\/seo\",\"icon\":\"rocket\",\"desc\":null,\"external\":false}]','2026-09-03 21:10:02','2026-09-03 21:38:35'),(10,'Domains','rows',NULL,'globe',NULL,'footer',0,1,2,'[{\"label\":\"Register a domain\",\"href\":\"\\/domain\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Transfer a domain\",\"href\":\"https:\\/\\/www.hosttiller.com\\/clients\\/cart.php?a=add&domain=transfer\",\"icon\":null,\"desc\":null,\"external\":true},{\"label\":\"WHOIS lookup\",\"href\":\"https:\\/\\/www.hosttiller.com\\/clients\\/cart.php?a=add&domain=register\",\"icon\":null,\"desc\":null,\"external\":true},{\"label\":\"Network Status\",\"href\":\"\\/serverstatus\",\"icon\":null,\"desc\":null,\"external\":true},{\"label\":\"Offer\",\"href\":\"\\/offer\",\"icon\":\"bolt\",\"desc\":null,\"external\":false}]','2026-09-03 21:10:02','2026-09-03 22:30:20'),(11,'Support','rows',NULL,'headphones',NULL,'footer',0,1,3,'[{\"label\":\"About Us\",\"href\":\"\\/about-us\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Contact Us\",\"href\":\"\\/contact\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Terms & Conditions\",\"href\":\"\\/terms-and-conditions\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Privacy Policy\",\"href\":\"\\/privacy-policy\",\"icon\":null,\"desc\":null,\"external\":false},{\"label\":\"Knowledgebase\",\"href\":\"\\/knowledgebase\",\"icon\":null,\"desc\":null,\"external\":false}]','2026-09-03 21:10:03','2026-09-03 21:55:48'),(12,'Service','rows','/pricing',NULL,NULL,'header',0,1,5,'[{\"label\":\"Web Site Service\",\"href\":\"\\/web-site-service\",\"icon\":\"globe\",\"desc\":null,\"external\":false},{\"label\":\"Server Maintain\",\"href\":\"\\/server-maintain\",\"icon\":\"cpu\",\"desc\":null,\"external\":false},{\"label\":\"RC Combo License\",\"href\":\"\\/rc-license\",\"icon\":\"bookmark\",\"desc\":null,\"external\":false},{\"label\":\"Sis Combo License\",\"href\":\"\\/sis-license\",\"icon\":\"bookmark\",\"desc\":null,\"external\":false},{\"label\":\"Seo Service\",\"href\":\"\\/seo\",\"icon\":\"rocket\",\"desc\":null,\"external\":false}]','2026-09-03 21:33:10','2026-09-07 16:29:04');
/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `is_read` int(11) DEFAULT 0,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_08_29_000000_create_content_tables',1),(5,'2026_08_30_000000_create_menus_table',2),(6,'2026_08_30_000001_create_pages_table',3),(7,'2026_08_30_000002_add_product_to_plans_table',4),(8,'2026_08_31_000000_create_kb_articles_table',5),(9,'2026_08_31_000100_add_client_fields_to_users_table',6),(10,'2026_08_31_000200_create_client_services_table',6),(11,'2026_08_31_000300_create_invoices_table',6),(12,'2026_08_31_000400_create_support_tickets_table',6),(13,'2026_09_07_000000_add_slug_to_kb_articles',7);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pages`
--

DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `hero_eyebrow` varchar(255) DEFAULT NULL,
  `hero_title` varchar(255) DEFAULT NULL,
  `hero_subtitle` text DEFAULT NULL,
  `hero_primary_text` varchar(255) DEFAULT NULL,
  `hero_primary_url` varchar(255) DEFAULT NULL,
  `hero_secondary_text` varchar(255) DEFAULT NULL,
  `hero_secondary_url` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pages`
--

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES (1,'web-hosting','Shared Web Hosting','Web Hosting','Fast, Secure & Reliable Shared Hosting','Launch your website on high-speed NVMe servers with free SSL, daily backups, LiteSpeed caching and 24/7 expert support.','View Plans','/pricing','Compare Plans','#plans','Web Hosting in Bangladesh | Cheap NVMe SSD Hosting','Cheap web hosting in Bangladesh on LiteSpeed NVMe SSD. Free SSL, daily backups, free migration and 99.99% uptime with 24/7 Bangladesh-friendly support.',1,1,'2026-08-30 18:38:29','2026-09-07 16:43:20'),(2,'wordpress-hosting','WordPress Hosting','WordPress Hosting','WordPress Hosting Built for Speed','Managed WordPress hosting with LiteSpeed, WP-optimized caching and automatic updates ΓÇö your site stays fast and secure.','Choose a Plan','/pricing','Learn More','#features','WordPress Hosting in Bangladesh | Managed WP on NVMe','Managed WordPress hosting in Bangladesh built for speed. LiteSpeed cache, auto updates, free SSL and daily backups ΓÇö get more from your WordPress site.',1,2,'2026-08-30 18:38:29','2026-09-07 16:43:20'),(3,'domain','Domain Names','Domains','Find Your Perfect Domain Name','Search, register and manage domains with free privacy protection, easy DNS management and unbeatable prices.','Search Domains','#search','View Pricing','#pricing','Buy Domain in Bangladesh | Register & Transfer Domains','Buy a domain name in Bangladesh at competitive prices. Register and transfer domains, get free WHOIS privacy and manage everything from one dashboard.',1,3,'2026-08-30 18:38:29','2026-09-07 16:43:20'),(4,'vps','Virtual Private Servers (VPS)','Cloud VPS','Cloud VPS with Full Root Access','Guaranteed resources, NVMe storage, 1 Gbps network and full root access ΓÇö deploy any OS in minutes.','View VPS Plans','/pricing','Explore Features','#features','VPS Hosting in Bangladesh | Cheap BDIX KVM NVMe VPS','Cheap VPS hosting in Bangladesh with BDIX connectivity. KVM NVMe dedicated cores, instant deployment, full root access and 24/7 support for local low-latency servers.',1,4,'2026-08-30 18:38:29','2026-09-07 16:43:20'),(5,'dedicated-server','Dedicated Servers','Dedicated Servers','Enterprise-Grade Dedicated Servers','Bare-metal power for high-traffic and resource-hungry applications, with fully managed options available.','View Servers','/pricing','Talk to Sales','/contact','Dedicated Server in Bangladesh | Affordable Servers','Affordable dedicated server hosting in Bangladesh and Germany. Full root access, NVMe storage, DDoS protection and 24/7 engineered support.',1,5,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(6,'reseller','Reseller Hosting','Reseller Hosting','Start Your Hosting Business Today','White-label reseller hosting with your own branding, free WHM and full control over pricing for your clients.','View Reseller Plans','/pricing','Learn More','#features','Reseller Hosting in Bangladesh | Wholesale BDIX Hosting','Start a reseller hosting business in Bangladesh. Wholesale hosting with BDIX connectivity, white-label cPanel/WHM, huge margins and daily backups.',1,6,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(7,'root-reseller','Root Reseller Hosting','Root Reseller','Full-Control Root Reseller Hosting','Complete root access to create unlimited accounts, custom nameservers and resell with total freedom.','View Plans','/pricing','Contact Sales','/contact','Root Reseller Hosting in Bangladesh | Full Root','Root reseller hosting for Bangladeshi providers. Run your own hosting business with full root access, WHM and wholesale BDIX server resources.',1,7,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(8,'offer','Special Offers & Deals','Offers','Hosting Discounts & Special Offers','Save big on hosting plans, domains and more with our latest promotions. Grab the deal before it expires.','See Current Deals','#offers','View Plans','/pricing','Hosting Offers & Promo Codes in Bangladesh | Save Now','Save on hosting in Bangladesh with exclusive offers and promo codes for shared, VPS and reseller plans at HostTiller.',1,8,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(9,'server-status','Network & Server Status','Status','Live Network & Server Status','Real-time status and uptime of our data centers, network and services. Transparency you can rely on.','View Live Status','#status','Report an Issue','/contact','Network Status & Uptime | Live Hosting Status','Live network status and uptime for HostTiller servers across Bangladesh, USA and Germany.',1,9,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(10,'about-us','About HostTiller','About Us','The Story Behind HostTiller','We are a team of engineers and hosting veterans on a mission to make serious web hosting simple, fast and reliable for everyone.','Our Story','#story','Contact Us','/contact','About Us | Cheap Reliable Hosting in Bangladesh','HostTiller is a Bangladeshi web hosting company offering cheap, reliable NVMe SSD hosting, VPS, reseller and dedicated servers with 24/7 support.',1,10,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(11,'blog','Blog & Guides','Blog','Guides, Tips & Product News','Fresh, useful content to help you get the most out of the web ΓÇö from hosting tutorials to performance deep-dives.','Latest Posts','#posts','Categories','#categories','Blog & Guides | Hosting Tips for Business in Bangladesh','Practical web hosting guides and tips for businesses in Bangladesh ΓÇö build, launch and grow a faster, safer online presence.',1,11,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(12,'contact','Contact Us','Contact','We Are Here to Help','Questions about hosting, billing or anything else? Reach out ΓÇö our team replies within minutes.','Send a Message','#contact-form','Call Sales','tel:+15551234567','Contact Us | 24/7 Hosting Support & Sales','Contact HostTiller for cheap web hosting in Bangladesh. 24/7 sales and support for shared hosting, VPS, reseller and dedicated servers.',1,12,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(13,'terms-and-conditions','Terms & Conditions','Legal','Terms & Conditions','The rules that keep things fair and transparent. Please read them carefully before using our services.','Read the Terms','#terms',NULL,NULL,'Terms & Conditions','Read the HostTiller terms and conditions covering web hosting, VPS, reseller and dedicated server services.',1,13,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(14,'privacy-policy','Privacy Policy','Legal','Privacy Policy','How we collect, use and protect your personal information. Your privacy matters to us.','Read the Policy','#privacy',NULL,NULL,'Privacy Policy','Read the HostTiller privacy policy to understand how we protect your personal data.',1,14,'2026-08-30 18:38:30','2026-09-07 16:43:20'),(16,'knowledgebase','Knowledgebase','Help Center','Knowledgebase','Self-serve answers, guides and troubleshooting for everything hosting ΓÇö from your first cPanel login to deploying a full server.','Browse Articles','#kb-articles','Open a Ticket','/contact','Knowledgebase | Hosting Help & How-To Guides','Browse the HostTiller knowledgebase for step-by-step guides on hosting, domains, cPanel and resolving common issues.',1,15,'2026-08-31 14:20:53','2026-09-07 16:43:20'),(17,'pricing','Pricing & Hosting Plans','Pricing','Cheap Hosting Prices in Bangladesh, in Taka','Transparent BDT pricing for shared, WordPress, VPS, reseller and dedicated hosting. Pay with bKash, Nagad or card ΓÇö every plan includes free SSL, LiteSpeed speed and 24/7 support.','View Plans','#plans','Compare Hosting','/bdix-web-hosting','Hosting Prices in Bangladesh in Taka | Cheap Plans & VPS','Cheap web hosting prices in Bangladesh in Taka. Compare shared, WordPress, VPS and reseller plans with free SSL, NVMe speed, daily backups and bKash/Nagad payment.',1,0,'2026-09-07 16:43:20','2026-09-07 16:43:20'),(18,'seo','SEO Services','SEO Services','Rank #1 on Google in Bangladesh','Professional SEO in Bangladesh ΓÇö keyword research, on-page optimisation, local SEO and technical fixes that move you up Google for your market.','View SEO Plans','#plans','Get a Quote','/contact','SEO Services in Bangladesh | Rank #1 on Google','SEO company in Bangladesh to rank your website #1 on Google. Keyword research, on-page, local SEO and technical audit services with transparent BDT pricing.',1,16,'2026-09-07 16:43:20','2026-09-07 16:43:20'),(19,'server-maintain','Server Maintenance','Server Maintenance','Managed Server Maintenance For Peace of Mind','Patching, security hardening, monitoring and performance tuning for your servers ΓÇö handled by real engineers around the clock.','View Plans','#plans','Talk to an Engineer','/contact','Managed Server Maintenance Services in Bangladesh','Managed server maintenance for Bangladeshi businesses ΓÇö security patching, hardening, monitoring and performance tuning by engineers, with 24/7 incident response.',1,17,'2026-09-07 16:43:20','2026-09-07 16:43:20'),(20,'web-site-service','Web Design & Development','Web Design & Development','Fast, SEO-Ready Websites That Convert','Custom website design and development in Bangladesh ΓÇö responsive, secure and built to rank on Google and turn visitors into customers.','Start a Project','#plans','Contact Us','/contact','Web Design & Development in Bangladesh | SEO-Ready','Professional web design and development services in Bangladesh ΓÇö fast, secure, SEO-ready websites and online stores built to grow your business.',1,18,'2026-09-07 16:43:20','2026-09-07 16:43:20'),(21,'sis-license','SysLic License Combo','SysLic License','Affordable Server License Combos','cPanel, WHM, LiteSpeed and security licenses bundled at wholesale prices for Bangladeshi hosting providers.','View License Plans','#plans','Ask a Question','/contact','SysLic License Combo in Bangladesh | cPanel & Server Licenses','Compare SysLic license combo pricing at HostTiller ΓÇö affordable cPanel, WHM and server license bundles at wholesale prices for Bangladeshi hosts.',1,19,'2026-09-07 16:43:20','2026-09-07 16:43:20'),(22,'rc-license','RC License Combo','RC License','RC License Combos at Wholesale Prices','Server and hosting license bundles for resellers ΓÇö get industry-standard licenses at wholesale Bangladeshi pricing with instant delivery.','View License Plans','#plans','Contact Sales','/contact','RC License Combo in Bangladesh | Server & Hosting Licenses','Compare RC license combo pricing at HostTiller ΓÇö server and hosting license bundles at wholesale prices for Bangladeshi hosting resellers.',1,20,'2026-09-07 16:43:20','2026-09-07 16:43:20');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plans`
--

DROP TABLE IF EXISTS `plans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `tagline` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT 'USD',
  `setup_fee` decimal(10,2) DEFAULT 0.00,
  `price_monthly` decimal(10,2) DEFAULT 0.00,
  `price_yearly` decimal(10,2) DEFAULT NULL,
  `features` text DEFAULT NULL,
  `is_featured` int(11) DEFAULT 0,
  `badge` varchar(255) DEFAULT NULL,
  `button_text` varchar(255) DEFAULT 'Get Started',
  `button_url` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  `product` varchar(255) DEFAULT 'shared',
  `specs` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plans`
--

LOCK TABLES `plans` WRITE;
/*!40000 ALTER TABLE `plans` DISABLE KEYS */;
INSERT INTO `plans` VALUES (192,'Starter','home-starter','Perfect for a first website or a personal blog.','USD',0.00,3.99,39.90,'10 GB NVMe SSD storage\n1 website\nFree SSL certificate\n50 GB bandwidth\n10 email accounts\nFree domain (1st year)\n24/7 live-chat support',0,NULL,'Choose Starter',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','home','[{\"label\":\"Storage\",\"value\":\"10 GB NVMe\"},{\"label\":\"Websites\",\"value\":\"1\"},{\"label\":\"Bandwidth\",\"value\":\"50 GB\"},{\"label\":\"Emails\",\"value\":\"10\"}]'),(193,'Professional','home-professional','The sweet spot for growing sites and online stores.','USD',0.00,8.99,89.90,'Unlimited SSD storage\n3 websites\nFree SSL + Wildcard\nUnlimited bandwidth\n50 email accounts\nFree global CDN\nDaily automatic backups\nLiteSpeed + caching\nPriority ticket support',1,'Most Popular','Choose Professional',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','home','[{\"label\":\"Storage\",\"value\":\"Unlimited SSD\"},{\"label\":\"Websites\",\"value\":\"3\"},{\"label\":\"Bandwidth\",\"value\":\"Unlimited\"},{\"label\":\"Emails\",\"value\":\"50\"}]'),(194,'Business','home-business','Serious power for agencies and high-traffic sites.','USD',0.00,15.99,159.90,'Unlimited NVMe SSD storage\nUnlimited websites\nFree SSL + Wildcard\nUnlimited bandwidth\nUnlimited email accounts\nFree global CDN + Edge caching\nHourly backups + staging\nDedicated IP address\nLiteSpeed enterprise server\nVIP priority support',0,'Best Value','Choose Business',NULL,1,3,'2026-09-07 16:50:27','2026-09-07 16:50:27','home','[{\"label\":\"Storage\",\"value\":\"Unlimited NVMe\"},{\"label\":\"Websites\",\"value\":\"Unlimited\"},{\"label\":\"Bandwidth\",\"value\":\"Unlimited\"},{\"label\":\"Emails\",\"value\":\"Unlimited\"}]'),(195,'Cloud VPS','home-cloud-vps','Full root access and guaranteed resources on demand.','USD',0.00,24.99,249.90,'4 vCPU cores\n8 GB DDR5 RAM\n120 GB NVMe SSD\n5 TB transfer\n1 GBPS network\nRoot access + snapshots\nFree Control Panel\nAny OS available\n24/7 sysadmin support',0,NULL,'Choose VPS',NULL,1,4,'2026-09-07 16:50:27','2026-09-07 16:50:27','home','[{\"label\":\"vCPU\",\"value\":\"4 Core\"},{\"label\":\"RAM\",\"value\":\"8 GB DDR5\"},{\"label\":\"Storage\",\"value\":\"120 GB NVMe\"},{\"label\":\"Transfer\",\"value\":\"5 TB\"}]'),(196,'Starter','starter','Perfect for a first website or a personal blog.','USD',0.00,3.99,39.90,'10 GB NVMe SSD storage\n1 website\nFree SSL certificate\n50 GB bandwidth\n10 email accounts\nFree domain (1st year)\n24/7 live-chat support',0,NULL,'Choose Starter',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','shared','[{\"label\":\"Storage\",\"value\":\"10 GB NVMe\"},{\"label\":\"Websites\",\"value\":\"1\"},{\"label\":\"Bandwidth\",\"value\":\"50 GB\"},{\"label\":\"Emails\",\"value\":\"10\"}]'),(197,'Professional','professional','The sweet spot for growing sites and online stores.','USD',0.00,8.99,89.90,'Unlimited SSD storage\n3 websites\nFree SSL + Wildcard\nUnlimited bandwidth\n50 email accounts\nFree global CDN\nDaily automatic backups\nLiteSpeed + caching\nPriority ticket support',1,'Most Popular','Choose Professional',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','shared','[{\"label\":\"Storage\",\"value\":\"Unlimited SSD\"},{\"label\":\"Websites\",\"value\":\"3\"},{\"label\":\"Bandwidth\",\"value\":\"Unlimited\"},{\"label\":\"Emails\",\"value\":\"50\"}]'),(198,'Business','business','Serious power for agencies and high-traffic sites.','USD',0.00,15.99,159.90,'Unlimited NVMe SSD storage\nUnlimited websites\nFree SSL + Wildcard\nUnlimited bandwidth\nUnlimited email accounts\nFree global CDN + Edge caching\nHourly backups + staging\nDedicated IP address\nLiteSpeed enterprise server\nVIP priority support',0,'Best Value','Choose Business',NULL,1,3,'2026-09-07 16:50:27','2026-09-07 16:50:27','shared','[{\"label\":\"Storage\",\"value\":\"Unlimited NVMe\"},{\"label\":\"Websites\",\"value\":\"Unlimited\"},{\"label\":\"Bandwidth\",\"value\":\"Unlimited\"},{\"label\":\"Emails\",\"value\":\"Unlimited\"}]'),(199,'Cloud VPS','cloud-vps','Full root access and guaranteed resources on demand.','USD',0.00,24.99,249.90,'4 vCPU cores\n8 GB DDR5 RAM\n120 GB NVMe SSD\n5 TB transfer\n1 GBPS network\nRoot access + snapshots\nFree Control Panel\nAny OS available\n24/7 sysadmin support',0,NULL,'Choose VPS',NULL,1,4,'2026-09-07 16:50:27','2026-09-07 16:50:27','shared','[{\"label\":\"vCPU\",\"value\":\"4 Core\"},{\"label\":\"RAM\",\"value\":\"8 GB DDR5\"},{\"label\":\"Storage\",\"value\":\"120 GB NVMe\"},{\"label\":\"Transfer\",\"value\":\"5 TB\"}]'),(200,'WP Starter','wp-starter','Kick off a single WordPress site the managed way.','USD',0.00,5.99,59.90,'1 WordPress site\n20 GB NVMe SSD\nManaged WordPress\nLiteSpeed + LSCache\nFree SSL\nAutomatic updates\nDaily backups',0,NULL,'Start with WP',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','wordpress','[{\"label\":\"Websites\",\"value\":\"1\"},{\"label\":\"Storage\",\"value\":\"20 GB NVMe\"},{\"label\":\"Visits\",\"value\":\"~25k\\/mo\"},{\"label\":\"CDN\",\"value\":\"Free\"}]'),(201,'WP Pro','wp-pro','Serious speed and headroom for growing stores & blogs.','USD',0.00,11.99,119.90,'10 WordPress sites\n60 GB NVMe SSD\nManaged WordPress\nLiteSpeed + LSCache + Object cache\nFree SSL + Wildcard\nAutomatic updates + staging\nDaily backups\nPriority support',1,'Most Popular','Go Pro',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','wordpress','[{\"label\":\"Websites\",\"value\":\"10\"},{\"label\":\"Storage\",\"value\":\"60 GB NVMe\"},{\"label\":\"Visits\",\"value\":\"~150k\\/mo\"},{\"label\":\"CDN\",\"value\":\"Free + Edge\"}]'),(202,'WP Agency','wp-agency','Unlimited WordPress for studios and agencies.','USD',0.00,22.99,229.90,'Unlimited WordPress sites\n150 GB NVMe SSD\nManaged WordPress\nLiteSpeed + LSCache + Object cache\nFree SSL + Wildcard\nAutomatic updates + staging\nHourly backups\nDedicated IP\nVIP priority support',0,'Best Value','Choose Agency',NULL,1,3,'2026-09-07 16:50:27','2026-09-07 16:50:27','wordpress','[{\"label\":\"Websites\",\"value\":\"Unlimited\"},{\"label\":\"Storage\",\"value\":\"150 GB NVMe\"},{\"label\":\"Visits\",\"value\":\"Unlimited\"},{\"label\":\"CDN\",\"value\":\"Global edge\"}]'),(203,'Starter Reseller','starter-reseller','Best for Testing & Freelancers','BDT',0.00,1200.00,12000.00,'30 GB NVMe Storage\n15 cPanel Accounts\n500 GB Bandwidth\n100% White-Label Nameservers\nWHM / cPanel Access\nLiteSpeed + LSCache\nFree SSL (Let\'s Encrypt)\nBDIX Speed Optimization\n24/7 support',0,NULL,'Choose Starter',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','reseller','[{\"label\":\"Storage\",\"value\":\"30 GB NVMe\"},{\"label\":\"Accounts\",\"value\":\"15\"},{\"label\":\"Bandwidth\",\"value\":\"500 GB\"},{\"label\":\"RAM\",\"value\":\"1 Core \\/ 1 GB\"},{\"label\":\"Connectivity\",\"value\":\"BDIX + Global\"}]'),(204,'Standard Reseller','standard-reseller','Best Value for Small Hosting Businesses','BDT',0.00,2500.00,25000.00,'75 GB NVMe Storage\n35 cPanel Accounts\n1.5 TB Bandwidth\nWHM / cPanel Access\nFree Automated SSL\nDaily Remote Backups\nLiteSpeed + LSCache\nWhite-label Branding\n24/7 support',1,'Most Popular','Choose Standard',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','reseller','[{\"label\":\"Storage\",\"value\":\"75 GB NVMe\"},{\"label\":\"Accounts\",\"value\":\"35\"},{\"label\":\"Bandwidth\",\"value\":\"1.5 TB\"},{\"label\":\"RAM\",\"value\":\"1 Core \\/ 1.5 GB\"},{\"label\":\"Connectivity\",\"value\":\"BDIX + Global\"}]'),(205,'Business Reseller','business-reseller','High Performance & Automation','BDT',0.00,4500.00,45000.00,'150 GB NVMe Storage\n75 cPanel Accounts\n3 TB Bandwidth\nWHM + Free WHMCS License\nJetBackup/Acronis Support\nLiteSpeed + LSCache\nBilling Automation\nDomain Registration via WHMCS\n24/7 priority support',0,NULL,'Choose Business',NULL,1,3,'2026-09-07 16:50:27','2026-09-07 16:50:27','reseller','[{\"label\":\"Storage\",\"value\":\"150 GB NVMe\"},{\"label\":\"Accounts\",\"value\":\"75\"},{\"label\":\"Bandwidth\",\"value\":\"3 TB\"},{\"label\":\"RAM\",\"value\":\"1 Core \\/ 2 GB\"},{\"label\":\"WHMCS\",\"value\":\"Free License\"}]'),(206,'Enterprise Pro','enterprise-pro','Maximum Scalability','BDT',0.00,8000.00,80000.00,'300 GB NVMe Storage\n150 cPanel Accounts\nUnlimited Bandwidth\nWHM + Free WHMCS\n2 Cores / 2 GB RAM per Account\nPriority 24/7 BDIX Support\nCustom Nameservers\nImunify360 / CageFS Security\nIdeal for High-Traffic WooCommerce',0,'Enterprise','Choose Enterprise',NULL,1,4,'2026-09-07 16:50:27','2026-09-07 16:50:27','reseller','[{\"label\":\"Storage\",\"value\":\"300 GB NVMe\"},{\"label\":\"Accounts\",\"value\":\"150\"},{\"label\":\"Bandwidth\",\"value\":\"Unlimited\"},{\"label\":\"RAM\",\"value\":\"2 Cores \\/ 2 GB\"},{\"label\":\"WHMCS\",\"value\":\"Free License\"}]'),(207,'VPS-1','vps-1','Entry KVM with room to grow.','USD',0.00,5.99,NULL,'1 dedicated vCPU Core\n2 GB RAM\n50 GB NVMe SSD\n2 TB bandwidth\nFull root access\nInstant deployment\nDDoS protection',0,NULL,'Deploy VPS-1',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','vps','[{\"label\":\"vCPU\",\"value\":\"1 Core\"},{\"label\":\"RAM\",\"value\":\"2 GB\"},{\"label\":\"NVMe\",\"value\":\"50 GB\"},{\"label\":\"Bandwidth\",\"value\":\"2 TB\"}]'),(208,'VPS-2','vps-2','The balanced pick for most workloads.','USD',0.00,9.99,NULL,'2 dedicated vCPU Cores\n4 GB RAM\n80 GB NVMe SSD\n4 TB bandwidth\nFull root access\nInstant deployment\nSnapshot backups\nDDoS protection',1,'Most Popular','Deploy VPS-2',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','vps','[{\"label\":\"vCPU\",\"value\":\"2 Core\"},{\"label\":\"RAM\",\"value\":\"4 GB\"},{\"label\":\"NVMe\",\"value\":\"80 GB\"},{\"label\":\"Bandwidth\",\"value\":\"4 TB\"}]'),(209,'VPS-3','vps-3','Serious power for apps and databases.','USD',0.00,17.99,NULL,'4 dedicated vCPU Cores\n8 GB RAM\n160 GB NVMe SSD\n8 TB bandwidth\nFull root access\nInstant deployment\nSnapshot backups\nDDoS protection',0,NULL,'Deploy VPS-3',NULL,1,3,'2026-09-07 16:50:27','2026-09-07 16:50:27','vps','[{\"label\":\"vCPU\",\"value\":\"4 Core\"},{\"label\":\"RAM\",\"value\":\"8 GB\"},{\"label\":\"NVMe\",\"value\":\"160 GB\"},{\"label\":\"Bandwidth\",\"value\":\"8 TB\"}]'),(210,'VPS-4','vps-4','Top-end KVM for demanding workloads.','USD',0.00,29.99,NULL,'6 dedicated vCPU Cores\n16 GB RAM\n320 GB NVMe SSD\n16 TB bandwidth\nFull root access\nInstant deployment\nSnapshot backups\nDDoS protection',0,NULL,'Deploy VPS-4',NULL,1,4,'2026-09-07 16:50:27','2026-09-07 16:50:27','vps','[{\"label\":\"vCPU\",\"value\":\"6 Core\"},{\"label\":\"RAM\",\"value\":\"16 GB\"},{\"label\":\"NVMe\",\"value\":\"320 GB\"},{\"label\":\"Bandwidth\",\"value\":\"16 TB\"}]'),(211,'DS-1','ds-1','Affordable bare-metal starter.','USD',0.00,79.99,NULL,'Intel Xeon E3\n16 GB ECC RAM\n512 GB NVMe SSD\n10 TB bandwidth\n1 Gbps uplink\nFull root access\nIPMI included\nAnti-DDoS',0,NULL,'Deploy DS-1',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','dedicated','[{\"label\":\"CPU\",\"value\":\"Intel Xeon E3\"},{\"label\":\"RAM\",\"value\":\"16 GB\"},{\"label\":\"Storage\",\"value\":\"512 GB NVMe\"},{\"label\":\"Bandwidth\",\"value\":\"10 TB\"}]'),(212,'DS-2','ds-2','Dual-core Xeon with headroom to scale.','USD',0.00,129.99,NULL,'Intel Xeon E5\n32 GB ECC RAM\n1 TB NVMe SSD\n20 TB bandwidth\n1 Gbps uplink\nFull root access\nIPMI included\nAnti-DDoS',1,'Most Popular','Deploy DS-2',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','dedicated','[{\"label\":\"CPU\",\"value\":\"Intel Xeon E5\"},{\"label\":\"RAM\",\"value\":\"32 GB\"},{\"label\":\"Storage\",\"value\":\"1 TB NVMe\"},{\"label\":\"Bandwidth\",\"value\":\"20 TB\"}]'),(213,'VPS Reseller Lite','vps-reseller-lite','Starter root environment for micro web hosts & freelancers.','BDT',0.00,2800.00,28000.00,'2 Virtual CPU Cores\n4 GB ECC RAM\n80 GB NVMe SSD\n2 TB bandwidth (BDIX + Int\'l)\nFull Root Access (SSH)\nAlmaLinux / CloudLinux OS support\ncPanel / CyberPanel support\n1 Dedicated IPv4\nIdeal for 5-10 high-resource client sites',0,NULL,'Choose Lite',NULL,1,1,'2026-09-07 16:50:27','2026-09-07 16:50:27','root-reseller','[{\"label\":\"vCPU\",\"value\":\"2 Virtual Cores\"},{\"label\":\"RAM\",\"value\":\"4 GB ECC\"},{\"label\":\"Storage\",\"value\":\"80 GB NVMe\"},{\"label\":\"Bandwidth\",\"value\":\"2 TB\"},{\"label\":\"Root\",\"value\":\"SSH \\/ Full Root\"},{\"label\":\"BDIX\",\"value\":\"1 Gbps Port\"}]'),(214,'VPS Reseller Pro','vps-reseller-pro','Agency master reseller for growing hosting agencies.','BDT',0.00,5500.00,55000.00,'4 Dedicated CPU Cores\n8 GB ECC RAM\n180 GB NVMe SSD\n4 TB bandwidth (BDIX + Int\'l)\nRoot SSH Access\nWHM / cPanel License (up to 100 accounts)\nLiteSpeed Enterprise (2-Core)\n2 Dedicated IPv4s\nWhite-label reseller hosting for sub-clients',1,'Most Popular','Choose Pro',NULL,1,2,'2026-09-07 16:50:27','2026-09-07 16:50:27','root-reseller','[{\"label\":\"vCPU\",\"value\":\"4 Dedicated Cores\"},{\"label\":\"RAM\",\"value\":\"8 GB ECC\"},{\"label\":\"Storage\",\"value\":\"180 GB NVMe\"},{\"label\":\"Bandwidth\",\"value\":\"4 TB\"},{\"label\":\"Root\",\"value\":\"SSH \\/ Full Root\"},{\"label\":\"BDIX\",\"value\":\"1 Gbps Port\"}]'),(215,'VPS Reseller Business','vps-reseller-business','Automated host business with billing modules.','BDT',0.00,9500.00,95000.00,'8 Dedicated CPU Cores\n16 GB ECC RAM\n350 GB NVMe SSD\n8 TB bandwidth (BDIX + Int\'l)\nFull Root Access\nWHMCS Starter License\ncPanel / WHM Premier\nImunify360 (Unlimited)\n3 Dedicated IPv4s\nbKash / Nagad / SSLCommerz gateway modules',0,'Automated','Choose Business',NULL,1,3,'2026-09-07 16:50:27','2026-09-07 16:50:27','root-reseller','[{\"label\":\"vCPU\",\"value\":\"8 Dedicated Cores\"},{\"label\":\"RAM\",\"value\":\"16 GB ECC\"},{\"label\":\"Storage\",\"value\":\"350 GB NVMe\"},{\"label\":\"Bandwidth\",\"value\":\"8 TB\"},{\"label\":\"Root\",\"value\":\"SSH \\/ Full Root\"},{\"label\":\"BDIX\",\"value\":\"10 Gbps Port\"}]'),(216,'VPS Reseller Enterprise','vps-reseller-enterprise','Data-heavy high-speed tier for enterprise providers.','BDT',0.00,16500.00,165000.00,'16 Dedicated CPU Cores\n32 GB ECC RAM\n700 GB NVMe SSD\nUnlimited bandwidth\nFull Root Access\nFree WHMCS Plus\nLiteSpeed Web Server\nConfigServer Security & Firewall (CSF)\n5 Dedicated IPv4s\nBuilt for heavy e-commerce / WooCommerce workloads',0,'Enterprise','Choose Enterprise',NULL,1,4,'2026-09-07 16:50:27','2026-09-07 16:50:27','root-reseller','[{\"label\":\"vCPU\",\"value\":\"16 Dedicated Cores\"},{\"label\":\"RAM\",\"value\":\"32 GB ECC\"},{\"label\":\"Storage\",\"value\":\"700 GB NVMe\"},{\"label\":\"Bandwidth\",\"value\":\"Unlimited\"},{\"label\":\"Root\",\"value\":\"SSH \\/ Full Root\"},{\"label\":\"BDIX\",\"value\":\"10 Gbps Port\"}]'),(217,'Starter Site','wds-starter','Perfect for personal sites & small businesses','USD',199.00,19.00,190.00,'Up to 5 custom pages\nMobile-responsive design\nContact form & map\nBasic on-page SEO\nGoogle Analytics setup\n1 round of revisions',0,NULL,'Start Project',NULL,1,1,'2026-09-07 16:50:37','2026-09-07 16:50:37','web-site-service',NULL),(218,'Business Site','wds-business','For businesses ready to win online','USD',499.00,39.00,470.00,'Up to 15 custom pages\nPremium custom design\nCMS / WordPress build\nAdvanced SEO + speed opt\nWhatsApp & live-chat integration\n3 rounds of revisions\n30 days free support',1,'Most Popular','Launch With Business',NULL,1,2,'2026-09-07 16:50:37','2026-09-07 16:50:37','web-site-service',NULL),(219,'E-Commerce Pro','wds-ecommerce','A complete online store, ready to sell','USD',1199.00,79.00,1150.00,'Unlimited products & categories\nCart, checkout & payments\nInventory & order management\nPayment gateway integration\nAdvanced SEO + analytics\nUnlimited revisions\n60 days priority support',0,NULL,'Build My Store',NULL,1,3,'2026-09-07 16:50:37','2026-09-07 16:50:37','web-site-service',NULL),(220,'Essential Care','sm-essential','For single servers that need a safety net','USD',0.00,49.00,NULL,'1 server covered\nDaily automated backups\nNightly security patches\nBasic uptime monitoring\nMonthly performance report\nEmail support (24h response)\nServer health checks',0,NULL,'Choose Essential',NULL,1,1,'2026-09-07 16:50:37','2026-09-07 16:50:37','server-maintain',NULL),(221,'Pro Maintenance','sm-pro','Full management for growing infrastructures','USD',0.00,149.00,NULL,'Up to 5 servers\n15-min incident monitoring\nReal-time 24/7 alerts\nFully managed security hardening\nPerformance optimisation\nAutomated off-site backups\nPriority phone & chat support\nRoot-cause analysis reports',1,'Most Popular','Start Pro Plan',NULL,1,2,'2026-09-07 16:50:37','2026-09-07 16:50:37','server-maintain',NULL),(222,'Enterprise Ops','sm-enterprise','Dedicated ops team for mission-critical stacks','USD',0.00,399.00,NULL,'Unlimited servers\n24/7 dedicated ops engineer\nSLA-backed 99.99% uptime\nZero-downtime migrations\nCustom infrastructure design\nDisaster recovery planning\nOn-call escalation, 5-min response\nQuarterly strategy workshops',0,NULL,'Talk to Sales',NULL,1,3,'2026-09-07 16:50:37','2026-09-07 16:50:37','server-maintain',NULL),(223,'Starter SEO','seo-starter','Perfect for new websites & local businesses','USD',0.00,299.00,NULL,'15 targeted keywords\nTechnical SEO audit & fixes\nOn-page optimisation (10 pages)\n1 blog post per month\nGoogle Business Profile setup\nMonthly performance report',0,NULL,'Start with Starter',NULL,1,1,'2026-09-07 16:50:37','2026-09-07 16:50:37','seo',NULL),(224,'Growth SEO','seo-growth','For established businesses ready to scale','USD',0.00,599.00,NULL,'40+ targeted keywords\nFull technical SEO + Core Web Vitals\nOn-page optimisation (25 pages)\n4 blog posts per month\nWhite-hat link building (10/mo)\nCompetitor & SERP analysis\nMonthly strategy call\nDetailed analytics dashboard',1,'Most Popular','Scale With Growth',NULL,1,2,'2026-09-07 16:50:37','2026-09-07 16:50:37','seo',NULL),(225,'Enterprise SEO','seo-enterprise','Complete domination for large-scale sites','USD',0.00,1499.00,NULL,'Unlimited keyword targeting\nFull technical + e-commerce SEO\nOn-page optimisation (all pages)\n8 blog posts + content upgrades\nPremium link building (25/mo)\nDigital PR & brand authority\nDedicated SEO account manager\nBi-weekly reporting & calls\nPriority 24/7 support',0,NULL,'Go Enterprise',NULL,1,3,'2026-09-07 16:50:37','2026-09-07 16:50:37','seo',NULL),(226,'Starter Combo','rc-starter','Essential licenses for a single VPS / VDS','USD',0.00,39.00,31.00,'cPanel / WHM ΓÇö VPS, VDS & Dedicated Server\nLiteSpeed License (4 Core)\nSoftaculous License\nKernelCare License\nFree installation service\nUnlimited IP changes',0,'Save 20%','Get Starter',NULL,1,1,'2026-09-07 16:50:37','2026-09-07 16:50:37','rc-license',NULL),(227,'Business Combo','rc-business','Full stack for a growing business','USD',0.00,79.00,63.00,'cPanel / WHM ΓÇö VPS, VDS & Dedicated Server\nJetBackup License\nSoftaculous License\nSitePad License\nLiteSpeed License (8 Core)\nFleetSSL License\nImunify360 License\nFree installation service',1,'Save 35%','Get Business',NULL,1,2,'2026-09-07 16:50:37','2026-09-07 16:50:37','rc-license',NULL),(228,'Enterprise Combo','rc-enterprise','Complete suite for infrastructure','USD',0.00,169.00,135.00,'cPanel / WHM ΓÇö VPS, VDS & Dedicated Server\nLiteSpeed License (X Core)\nJetBackup + Softaculous + SitePad\nFleetSSL + CloudLinux Manager\nImunify360 + KernelCare\nWHM Reseller Plugin License\nDedicated license manager\nPriority 24/7 support',0,'Save 45%','Go Enterprise',NULL,1,3,'2026-09-07 16:50:37','2026-09-07 16:50:37','rc-license',NULL),(229,'Starter Combo','sys-starter','Essential licenses for a single VPS / VDS','USD',0.00,39.00,31.00,'cPanel / WHM ΓÇö VPS, VDS & Dedicated Server\nLiteSpeed License (4 Core)\nSoftaculous License\nKernelCare License\nFree installation service\nUnlimited IP changes',0,'Save 20%','Get Starter',NULL,1,1,'2026-09-07 16:50:37','2026-09-07 16:50:37','sis-license',NULL),(230,'Business Combo','sys-business','Full stack for a growing business','USD',0.00,79.00,63.00,'cPanel / WHM ΓÇö VPS, VDS & Dedicated Server\nJetBackup License\nSoftaculous License\nSitePad License\nLiteSpeed License (8 Core)\nFleetSSL License\nImunify360 License\nFree installation service',1,'Save 35%','Get Business',NULL,1,2,'2026-09-07 16:50:37','2026-09-07 16:50:37','sis-license',NULL),(231,'Enterprise Combo','sys-enterprise','Complete suite for infrastructure','USD',0.00,169.00,135.00,'cPanel / WHM ΓÇö VPS, VDS & Dedicated Server\nLiteSpeed License (X Core)\nJetBackup + Softaculous + SitePad\nFleetSSL + CloudLinux Manager\nImunify360 + KernelCare\nWHM Reseller Plugin License\nDedicated license manager\nPriority 24/7 support',0,'Save 45%','Go Enterprise',NULL,1,3,'2026-09-07 16:50:37','2026-09-07 16:50:37','sis-license',NULL);
/*!40000 ALTER TABLE `plans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `excerpt` varchar(255) DEFAULT NULL,
  `body` text NOT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `published_at` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` VALUES (34,'How to Move Your Website to a New Host Without Any Downtime','move-website-without-downtime','Switching hosts is easier than you think. Follow this step-by-step guide to migrate your site safely with zero downtime.','<h2>Why migrate?</h2><p>Whether you have outgrown your current plan, your host keeps dropping, or you simply found a better price, moving hosts is one of the smartest upgrades you can make ΓÇö when it is done right.</p><h2>Before you start</h2><p>Take a full backup of your files and database. Export your email accounts and note every DNS record you use. You will need these during cut-over.</p><h2>The migration checklist</h2><p><strong>1. Back it all up.</strong> Download files via FTP and export the database via phpMyAdmin.<br/><strong>2. Upload to the new host.</strong> Most hosts, including HostTiller, offer free professional migrations ΓÇö ours even run while you sleep.<br/><strong>3. Update DNS.</strong> Point your nameservers to the new host and let propagation finish (usually under 24 hours).<br/><strong>4. Test everything.</strong> Check pages, emails, and forms before and after cut-over.<br/><strong>5. Kill the old host.</strong> Only cancel the old account once you are 100% happy.</p><h2>The result</h2><p>Done right, nobody will even notice the move. Their next visit will simply load faster.</p>',NULL,'The HostTiller Team','migration, guide, hosting',1,'2026-09-05 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(35,'LiteSpeed vs Apache: Why Your Web Server Choice Matters','litespeed-vs-apache','A deep dive into how the right web server can cut your TTFB in half and keep your site fast even during traffic spikes.','<h2>The invisible performance battle</h2><p>Most people never think about their web server ΓÇö until their site slows to a crawl on a busy day. Apache runs the majority of the web, but it is not always the fastest option.</p><h2>What is LiteSpeed?</h2><p>LiteSpeed is a drop-in Apache-compatible web server that handles the same configurations but processes them far more efficiently. It brings built-in caching, HTTP/2 and HTTP/3, and it is up to 10x faster at serving static content with far lower resource use.</p><h2>What it means for you</h2><p>With LiteSpeed, common WordPress cache plugins ΓÇö like LSCache ΓÇö can serve entire pages from memory. During Black Friday traffic spikes we see shared customers sustain 50x their normal load without breaking a sweat.</p><h2>Bottom line</h2><p>Your web server directly affects your speed, your SEO and your visitorsΓÇÖ patience. That is why every HostTiller plan is powered by LiteSpeed from day one.</p>',NULL,'Aisha Khan','litespeed, apache, performance',1,'2026-09-01 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(36,'The 8 Habits of Super-Fast Websites in 2026','super-fast-websites-2026','Speed wins customers. Here are the eight habits the fastest websites on the internet all share ΓÇö and how to apply them today.','<h2>Speed is a feature</h2><p>A one-second delay in load time costs roughly 7% of conversions. Fast websites not only rank higher ΓÇö they print money. The good news: the winning habits are simple to adopt.</p><h2>The eight habits</h2><p><strong>1. Use NVMe storage.</strong> Database and file I/O dominates response time.<br/><strong>2. Cache everything.</strong> Full-page, object, browser ΓÇö layers of cache are non-negotiable.<br/><strong>3. Serve from a CDN.</strong> Edge nodes turn a ΓÇ£fastΓÇ¥ server into a globally fast website.<br/><strong>4. Compress aggressively.</strong> Brotli + modern image formats (WebP/AVIF) shrink bytes automatically.<br/><strong>5. Reduce round trips.</strong> HTTP/3 and connection reuse cut almost all network latency.<br/><strong>6. Optimise images.</strong> Lazy-load below the fold and serve responsive sizes.<br/><strong>7. Cut the JavaScript.</strong> Ship less, load faster.<br/><strong>8. Measure monthly.</strong> Track Core Web Vitals and ALWAYS act on the outliers.</p><p>Adopt these eight habits and the average site load time drops from 2.5s to under 1s ΓÇö often in a single week.</p>',NULL,'Marcus Webb','performance, web vitals, CDN',1,'2026-08-26 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(37,'Best Web Hosting in Bangladesh (2026): An Honest Comparison','best-web-hosting-bangladesh-2026','Compare shared, WordPress, VPS and reseller hosting in Bangladesh - speed, BDIX connectivity, price in Taka and which one is right for you this year.','<h2>What \'best\' really means for a Bangladeshi website</h2><p>For most business owners in Dhaka, Chittagong or Sylhet, the best web hosting in Bangladesh is the one that loads fast locally, never goes down, and costs in Taka - not dollars. A host with good BDIX connectivity and servers inside the country will always beat a distant one for local visitors.</p><h2>Shared web hosting</h2><p>Shared hosting is the right starting point for personal sites, small businesses and WordPress blogs. It is the cheapest option and bundles everything you need: free SSL, email, daily backups and one-click installers. If your site is new or has modest traffic, start here. See our shared plans on the <a href=\"/bdix-web-hosting\">web hosting page</a> or check prices on <a href=\"/pricing\">pricing page</a>.</p><h2>WordPress hosting</h2><p>WordPress hosts handle updates, caching and security for you. For bloggers and online shops, managed WordPress hosting on LiteSpeed keeps pages fast without touching a server. Our managed WordPress plans are built for exactly this workload.</p><h2>VPS hosting</h2><p>A VPS gives you dedicated CPU and RAM on a virtual server with full root access. It is the step-up choice for growing apps, custom software, bots and development sites. With BDIX-connected KVM NVMe VPS options, you get very low latency for Bangladeshi users. Compare options on the <a href=\"/vps\">VPS page</a>.</p><h2>Reseller hosting</h2><p>If you want to run your own hosting business, reseller hosting in Bangladesh is one of the most profitable entry points. You buy wholesale, sell at retail, and keep the margin. Read more on the <a href=\"/reseller\">reseller page</a>.</p><h2>Our honest bottom line</h2><p>There is no single \'best\' host for everyone - the best web hosting in Bangladesh for <em>you</em> depends on your budget and workload. HostTiller covers all four tiers with BDIX connectivity, local support in Bangladeshi time and payments in Taka (bKash, Nagad, rocket). Talk to us any time on the <a href=\"/contact\">contact page</a> and we will help you choose - no upsell.</p>',NULL,'The HostTiller Team','web hosting, bangladesh, best hosting, comparison',1,'2026-09-06 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(38,'How to Start a Reseller Hosting Business in Bangladesh','start-reseller-hosting-business-bangladesh','A step-by-step playbook for launching your own hosting brand in Bangladesh - wholesale pricing, WHM, branding, clients and payments in BDT.','<h2>Why reseller hosting is a smart business in Bangladesh</h2><p>Thousands of small businesses, schools and startups go online every year and most of them do not want to deal with servers. A reseller service lets you sell hosting, domains and email under your own brand, without owning any infrastructure yourself.</p><h2>Step 1 - Buy wholesale</h2><p>Start with a reseller plan that includes cPanel and WHM. WHM lets you create as many client accounts as you need and white-label everything. Our reseller hosting includes full branding: your logo, your prices, your control panels. See plans on the <a href=\"/reseller\">reseller hosting page</a>.</p><h2>Step 2 - Set your pricing in Taka</h2><p>Package your plans in BDT and accept bKash, Nagad and rocket. Bangladeshi buyers compare on price in Taka and local payment is a huge trust signal. Keep the wholesale margin generous - most resellers set 30-50% above wholesale.</p><h2>Step 3 - Sell a service, not just server space</h2><p>Win clients with free migration, free SSL and quick support via WhatsApp. Happy clients renew for years and refer others - renewal income is what makes hosting businesses valuable.</p><h2>Step 4 - Scale up</h2><p>Once your accounts grow past your reseller quota, move to <a href=\"/pricing\">root reseller or dedicated resources</a> so you keep control and margin as you scale.</p><h2>Start today</h2><p>You can launch your own hosting company this week. Our team helps you with branding, WHM setup and pricing. Message us on the <a href=\"/contact\">contact page</a> and we will get you live.</p>',NULL,'Aisha Khan','reseller hosting, bangladesh, business, wholesale, whm',1,'2026-09-04 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(39,'Web Hosting vs VPS: Which One Do You Actually Need in Bangladesh?','web-hosting-vs-vps-bangladesh','Shared hosting or a VPS? Compare speed, control, BDIX latency and monthly cost in Taka to decide which is right for your website.','<h2>The question every growing site faces</h2><p>Shared web hosting and VPS look similar on paper - both keep your site online - but they serve very different needs. Picking wrong means either overpaying or hitting limits at the worst moment.</p><h2>Web hosting (shared)</h2><p>Shared hosting is managed for you: cPanel, email, SSL, backups and updates are handled by the host. It is the right choice for WordPress sites, business websites, blogs and online shops with normal traffic. Speed is still excellent because LiteSpeed caches serve most pages from memory. It is also the cheapest - plans are priced in Taka on our <a href=\"/pricing\">pricing page</a>.</p><h2>VPS</h2><p>A VPS gives you guaranteed CPU, RAM and NVMe storage plus full root access. You can install any software, run bots or custom services, and scale resources without a full dedicated server. It suits developers, agencies, trading tools and apps that outgrow shared limits. For Bangladeshi users, BDIX-connected VPS keeps latency very low. Compare the options on the <a href=\"/vps\">VPS page</a>.</p><h2>A simple rule of thumb</h2><p>If your site runs WordPress or a standard website and under about 100K visits a month, shared hosting is enough and saves you money. If you need root access, custom software, or guaranteed resources at peak times, choose a VPS.</p><h2>Still unsure?</h2><p>Both are covered by migration and 24/7 support, and you can upgrade from shared to VPS without downtime. Ask us on the <a href=\"/contact\">contact page</a> and we will recommend based on your actual traffic - no upsell.</p>',NULL,'The HostTiller Team','web hosting, vps, bangladesh, comparison, hosting guide',1,'2026-09-03 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(40,'How to Choose the Right Web Hosting in Bangladesh: A Beginner Guide','choose-right-web-hosting-bangladesh','New to hosting? Use this simple checklist - uptime, speed, BDIX, backups, support and price in BDT - to pick a plan you will not regret.','<h2>Hosting is the foundation of your website</h2><p>Cheap traffic, great design and strong content mean nothing if your site takes ten seconds to load. Choosing the right web hosting in Bangladesh matters more than most people think.</p><h2>The checklist</h2><p><strong>1. Uptime.</strong> Look for a 99.9% guarantee. Downtime loses visitors, money and Google trust.<br/><strong>2. Local speed (BDIX).</strong> A host with BDIX connectivity gives Bangladeshi visitors noticeably faster loading - consider this essential.<br/><strong>3. Backups.</strong> Daily automatic backups mean one click restores your site after any mistake.<br/><strong>4. SSL and security.</strong> Free SSL plus an active firewall (like Imunify360) should come standard.<br/><strong>5. Support.</strong> Real 24/7 support - not ticket queues - answered in your time zone.<br/><strong>6. Price in Taka.</strong> Transparent BDT pricing with bKash, Nagad and rocket payment options.</p><h2>Where to start</h2><p>For 9 out of 10 beginners, shared web hosting is the right first move. Start on a basic plan, pay monthly in BDT, and upgrade when traffic grows. Browse starter plans on the <a href=\"/pricing\">pricing page</a>.</p><h2>Common mistakes to avoid</h2><p>Do not pay for a VPS you will not use, do not pick a host with no daily backups, and never skip checking local loading speed. Guides like this are also available in our <a href=\"/knowledgebase\">knowledgebase</a> if you want to dig deeper.</p><h2>Ready?</h2><p>Our team will help you pick a plan that fits your budget and traffic. Reach us on <a href=\"/contact\">contact page</a> or start with our free migration - we move your existing site for free, forever.</p>',NULL,'Aisha Khan','web hosting, beginners guide, bangladesh, choose hosting',1,'2026-09-02 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(41,'BDIX Hosting Explained: Why Local Servers Are Faster in Bangladesh','bdix-hosting-explained-bangladesh','What is BDIX and why does it matter for Bangladeshi websites? Learn how BDIX-connected servers in Dhaka cut latency compared to overseas hosting.','<h2>What is BDIX?</h2><p>BDIX (Bangladesh Internet Exchange Limited) is the national internet exchange where all Bangladeshi ISPs interconnect. When a hosting server connects directly to BDIX, traffic between Bangladeshi visitors and the server never leaves the country.</p><h2>Why BDIX matters for Bangladeshi websites</h2><p>Most international hosts route Bangladeshi traffic through Singapore, Frankfurt or the USA. Every extra hop adds latency - often 100-300ms. A BDIX-connected server in Dhaka typically answers in under 10-20ms for local visitors, which translates to noticeably faster page loads and better SEO.</p><h2>Who benefits most</h2><p><strong>E-commerce stores</strong> in Bangladesh - checkout conversions rise when pages load instantly.<br/><strong>Local businesses</strong> whose customers are in Dhaka, Chittagong, Sylhet or Khulna.<br/><strong>Gaming and live platforms</strong> where ping matters.<br/><strong>News and media sites</strong> serving peak local traffic during Eid and other festivals.</p><h2>Do you lose international speed?</h2><p>No. The best setups offer dual connectivity: BDIX for local visitors plus international bandwidth for the rest of the world. Our VPS, web hosting and dedicated servers include both.</p><h2>Check your latency</h2><p>If your site loads slowly for mobile users in Bangladesh, check the server location first. A BDIX-connected plan is usually the fastest fix. See the <a href=\"/pricing\">BDIX hosting plans</a> on our pricing page.</p>',NULL,'The HostTiller Team','bdix, bangladesh hosting, latency, local server',1,'2026-08-31 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(42,'How to Pay for Hosting in Bangladesh: bKash, Nagad, Rocket & Cards','pay-hosting-bangladesh-bkash-nagad','Pay for web hosting in Taka with bKash, Nagad, rocket, bank transfer or international cards. Compare the options for buying hosting in Bangladesh.','<h2>Pay for hosting the Bangladeshi way</h2><p>Most international hosts require a foreign card or PayPal, which is painful for Bangladeshi buyers. Local providers make it easy by accepting the payment methods you already use.</p><h2>bKash, Nagad and rocket</h2><p>These mobile wallet services are the most popular ways to pay for hosting in Bangladesh. You pay instantly from your mobile number, no bank account needed. Renewals are just as easy - set a reminder and top up from your wallet in seconds.</p><h2>Bank transfer and cards</h2><p>For larger orders (dedicated servers, reseller packages), bank transfer and international debit/credit cards (Visa, Mastercard) are also supported. Some buyers prefer this for their accounting records.</p><h2>Look for Taka pricing</h2><p>Always compare hosting prices in BDT (Taka) instead of USD - currency swings can silently increase your renewal cost. Transparent Taka pricing avoids surprise charges.</p><h2>Pay with HostTiller</h2><p>We accept bKash, Nagad, rocket, bank transfer and international cards across all <a href=\"/pricing\">hosting plans</a>. Need help paying? Contact <a href=\"/contact\">our support team</a> anytime.</p>',NULL,'The HostTiller Team','bkash, nagad, rocket, payment, bangladesh hosting',1,'2026-08-30 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(43,'VPS for Forex and MT4 Trading in Bangladesh: What You Need','vps-forex-mt4-trading-bangladesh','Forex traders in Bangladesh need a low-latency VPS close to brokers. Here is how to pick a Windows or Linux VPS for MT4/MT5 trading.','<h2>Why traders use a VPS</h2><p>Forex and MT4/MT5 trading lags or disconnects when your home PC sleeps, your internet drops, or a power cut hits Dhaka. A VPS runs your trading terminal 24/7 in a data center with redundant power and internet - your expert advisors (EAs) keep working even when you sleep.</p><h2>Choose a VPS close to your broker</h2><p>Latency matters in trading. Pick a VPS in the same region as your broker\'s matching engine - often in the UK, Singapore or Germany. For Bangladeshi-based services, a VPS with good international connectivity keeps ping low.</p><h2>Windows VPS for MT4/MT5</h2><p>MT4 and MT5 run natively on Windows RDP servers. Look for a <strong>Windows VPS with at least 2 vCPU and 2GB RAM</strong>, NVMe or SSD storage, and a dedicated IP. Some retail brokers even block datacenter IPs - a dedicated clean IP avoids that.</p><h2>Testing your setup</h2><p>Run a ping and traceroute test from the VPS to your broker\'s server before paying for a long term. A good trading VPS responds in under 30ms to the matching engine.</p><h2>Get a trading-ready VPS</h2><p>Our <a href=\"/vps\">VPS plans</a> include Windows options and low-latency international routes. Talk to us on the <a href=\"/contact\">contact page</a> and we will help you pick the right node for your broker location.</p>',NULL,'Marcus Webb','vps, forex, mt4, mt5, trading, bangladesh',1,'2026-08-28 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(44,'How to Register a .com.bd Domain in Bangladesh (Step by Step)','register-com-bd-domain-bangladesh','A practical guide to registering and renewing a .com.bd Bangladesh domain - requirements, registrars, cost in BDT and how to connect it to hosting.','<h2>What is .com.bd?</h2><p>.com.bd is the official country-code domain for Bangladeshi businesses, managed by BTRC through accredited registrars. If you want to rank and be trusted locally, a .com.bd builds immediate credibility with Bangladeshi customers.</p><h2>Requirements</h2><p>To register .com.bd, your business should have a valid trade licence or a company registration. Individual registrations may be limited depending on the registrar. Check specific requirements with your registrar before ordering.</p><h2>Registration steps</h2><p><strong>1.</strong> Check availability with a registrar.<br/><strong>2.</strong> Submit your business documents (trade licence / company certificate).<br/><strong>3.</strong> Pay the annual fee in BDT.<br/><strong>4.</strong> Complete DNS or nameserver setup to connect the domain to your hosting.</p><h2>.com.bd vs .com</h2><p>.com is faster to register and works for international audiences, while .com.bd signals a trusted local business to Bangladeshi searchers. Many companies register both and point them at one site. To protect your brand, do the same.</p><h2>Connect it to hosting</h2><p>Once registered, point your .com.bd to fast hosting inside Bangladesh for the best local speed. Compare <a href=\"/pricing\">hosting plans</a> or ask our team on the <a href=\"/contact\">contact page</a>.</p>',NULL,'Aisha Khan','.com.bd, domain registration, bangladeshi domain, btrc',1,'2026-08-29 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15'),(45,'Best E-commerce Hosting in Bangladesh for Online Stores (WooCommerce)','ecommerce-hosting-woocommerce-bangladesh','What to look for in e-commerce hosting in Bangladesh - free SSL, fast BDIX checkout, bKash/Nagad gateways and load handling for WooCommerce.','<h2>Your store lives or dies on hosting</h2><p>Online stores in Bangladesh have one hard requirement: the checkout must load fast on mobile. If buying a product takes too long, shoppers abandon the cart. E-commerce hosting is what keeps your store fast, secure and online during sale spikes.</p><h2>What makes hosting e-commerce ready</h2><p><strong>Free SSL.</strong> Encrypted checkout builds trust and helps Google rankings - every plan should include it.<br/><strong>Local speed.</strong> BDIX-connected servers in Bangladesh load product images and carts instantly for local shoppers.<br/><strong>NVMe + LiteSpeed cache.</strong> WooCommerce databases and shops stay fast even with thousands of products.<br/><strong>Daily backups.</strong> Restore your store in one click after any update or human error.<br/><strong>Load handling.</strong> Festival sales and 10:10 shopping days can spike traffic 10x.</p><h2>Payment gateway support</h2><p>Your store needs bKash, Nagad, rocket and SSLCommerz integrations to actually get paid. Any hosting that supports WooCommerce works with these - but the speed of your server decides whether customers finish checkout.</p><h2>Start small, scale fast</h2><p>Begin with WordPress hosting on an <a href=\"/pricing\">affordable plan</a>, then move to a <a href=\"/vps\">BDIX VPS</a> as traffic grows, without changing your domain or emails.</p>',NULL,'The HostTiller Team','ecommerce hosting, woocommerce, online store, bangladesh',1,'2026-08-27 16:45:15','2026-09-07 16:45:15','2026-09-07 16:45:15');
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('2xCXwoHTS52j0g8cl3MDrtGcT95P5XWQhBfVoEr1',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoibTB0aVJSdkNTRzVRU0xVUklLbHFhbEtHcE53Z0JjZ0I4ZEMxTjlGYiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9yYy1saWNlbnNlIjtzOjU6InJvdXRlIjtzOjEwOiJyYy1saWNlbnNlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788798585),('3g1IKIsNWLiekmmpW6Q4Sj7jHJ08YahcdLSs3iqx',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSDZLaTRXRWNvOWlMSkZUN3RLZWhHcW45RUxtaE1Od2JQMGNpUEZVdyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Njc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9rbm93bGVkZ2ViYXNlL2Vjb21tZXJjZS1ob3N0aW5nLWluLWJhbmdsYWRlc2giO3M6NToicm91dGUiO3M6MTg6Imtub3dsZWRnZWJhc2Uuc2hvdyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1788799678),('7lbrJ4k2SqZBDXH9IumD14idLBP4paAZUmr3gzWu',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMm5kMG9uSEhLVUtpTTB5elVHYXZSOVV4dHh6YVd4VnRUS0xyRTFBViI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Njc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9rbm93bGVkZ2ViYXNlL2Vjb21tZXJjZS1ob3N0aW5nLWluLWJhbmdsYWRlc2giO3M6NToicm91dGUiO3M6MTg6Imtub3dsZWRnZWJhc2Uuc2hvdyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1788799673),('F1yLT1oNJ2Y7NyG3ERuekbqDvrp8BUFUThN5tbaS',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoieGpyUEhPUXhXWEdHemtlYU0yTmlaTTZaQzFFZ29hd0RiZ1d3VjRQQSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NjA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9ibG9nL2JkaXgtaG9zdGluZy1leHBsYWluZWQtYmFuZ2xhZGVzaCI7czo1OiJyb3V0ZSI7czo5OiJibG9nLnNob3ciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1788799678),('fHTgHpJsMW9MNYybFFU4HMA866vF9YLlU4lMP2rP',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDJ1MHZablFicEYyaGRDcnhCRWJqcmFmcnZEdVlaWnltcXdhcTN6eCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC93ZWItc2l0ZS1zZXJ2aWNlIjtzOjU6InJvdXRlIjtzOjE2OiJ3ZWItc2l0ZS1zZXJ2aWNlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788799672),('FNpIZG8CxMO4hV1annA1P5Wan3Dkd3NysURf4P5y',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOUdQeWR0QnFVblFmeG0yNXFKenVaWkNRWFQwazRMS1A0Z054cWJVZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zaXRlbWFwLnhtbCI7czo1OiJyb3V0ZSI7czo3OiJzaXRlbWFwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788799665),('G8ArLVAQgBpFo4YkwWCxdbqII60OvS3iS9GoVcMq',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDZQQUVJdEg2NnI4TUx3eDBjejFuVGhLZlM4RkdVQ0VobUlqRDhTRCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9yYy1saWNlbnNlIjtzOjU6InJvdXRlIjtzOjEwOiJyYy1saWNlbnNlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788798580),('H6IBw3InCBUrgFi49AWRIrOKDIUBfHy3XBYbzzAj',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQms5bG91Umo1YThoNEVndWIxOUNaUVp6YzJWTHo5dk9EanBhcEpJcyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9wcmljaW5nIjtzOjU6InJvdXRlIjtzOjc6InByaWNpbmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1788799683),('HplweqX3xfj87Eery8gjqaRxeb0R2j32CQqhOCiu',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZzZIUWRJbWlvaDRkYllBc1RWdXFBRjI0Q0o0S2V5OTJmb29yVzhqZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zZW8iO3M6NToicm91dGUiO3M6Mzoic2VvIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788799677),('iiUcLiDLi6IohZQ1UvsSExU91xjeQFdJHCEMuD9s',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSEIyaUhFdmVac0Vab2doR0xFTEk4SkpMV0FtbHh4ZFhXMmR3VmtiWCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zaXMtbGljZW5zZSI7czo1OiJyb3V0ZSI7czoxMToic2lzLWxpY2Vuc2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1788799671),('IRLuz1wPt3EJ1OyJ4r0TfbDMNlxP9oo2WTuIyDvQ',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoicFpCNW15V3hlS3lwb01hRUlRUXlsZkhUMVZhN1o2ZG1MamFFU2RsRyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zaXRlbWFwLnhtbCI7czo1OiJyb3V0ZSI7czo3OiJzaXRlbWFwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788799661),('l3Q7bHT3NeTjF2f1dsyYidF1Y8FvMeLbUcsycP91',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiN3R0Rk51WGhiTHRKN0dTUzRvUmIwZ21DYWVWc0hSVjZPS2Rhajl5MCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9yYy1saWNlbnNlIjtzOjU6InJvdXRlIjtzOjEwOiJyYy1saWNlbnNlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788799671),('mCjVNyaT0rLbe6spXcfcqaBkaELievkC6jjHaVpW',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVUhINlVhZWs3bk5MVDNsV0c5R3JwOGZtd3FUZGJ3R0lOOGw3V2Q0cyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9wcmljaW5nIjtzOjU6InJvdXRlIjtzOjc6InByaWNpbmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1788799678),('Mo2QNwG7HEEYw4AAnn6PGXjzQVh5nAJp0B2cNqyu',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV0xMWU1JUWtGT2haRzk3dTJSdjBnUXVBZGkzTmtPT3FCeHIwRlJTVCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zZW8iO3M6NToicm91dGUiO3M6Mzoic2VvIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788799670),('OCbT1CUZFRfVSBCXPukHLQoptneT69cShGcnCkkw',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoieUxsQU5vSjV0a3ZjYVJoREZwaUhuY3FSOUpNOHFoMWMzNTljeXBJTCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NjA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9ibG9nL2JkaXgtaG9zdGluZy1leHBsYWluZWQtYmFuZ2xhZGVzaCI7czo1OiJyb3V0ZSI7czo5OiJibG9nLnNob3ciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1788799673),('sdZYjAswQ9dEA6sU8YeeCbDVYoopqztO8tF3R4O3',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQTdQYkFrSG9WRkE4N3F2eFgxdnhxUnIyRnlQcHh1MWYzWllWb1ZGZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9zZXJ2ZXItbWFpbnRhaW4iO3M6NToicm91dGUiO3M6MTU6InNlcnZlci1tYWludGFpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1788799672),('YWPeNCKoHnfxxgsn0cpEZwvavL0w7aNWgcUVNGfd',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.19041.6456','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWEZ1OFQ1YUhhZEluYnlhNVhiSUVjbFlYWlR1eEFjTFczWnQ0V29PdiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9wcmljaW5nIjtzOjU6InJvdXRlIjtzOjc6InByaWNpbmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1788799670),('zrW9j9tOWadJktRg6YjoEQ7PaUhe7BUGBbTSePuM',1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQ3lRRmVPUEhOSHRBNDExNW1uU1hjdTBqUVVwZGdISlg4N29OalVncSI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czoyNjoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2Jsb2ciO3M6NToicm91dGUiO3M6NDoiYmxvZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1788798717);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `group` varchar(255) DEFAULT 'general',
  `label` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT 'text',
  `hint` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'brand_site_name','HostTiller','brand','Site Name','text','Site / brand name','2026-08-30 06:33:02','2026-08-30 06:33:02'),(2,'brand_tagline','Blazing-fast web hosting for ambitious projects','brand','Tagline','text','Short brand tagline','2026-08-30 06:33:02','2026-08-30 06:33:02'),(3,'brand_logo','media/brand-logo-ymti0kah.png','brand','Logo','text','Logo image (media path, e.g. media/logo.png)','2026-08-30 06:33:02','2026-09-04 14:37:49'),(4,'brand_favicon','media/brand-favicon-2nyw5wlk.png','brand','Favicon','text','Favicon path','2026-08-30 06:33:02','2026-09-04 14:37:55'),(5,'brand_show_logo_text','1','brand','Show Logo Text','boolean','Show logo text next to the image','2026-08-30 06:33:02','2026-08-30 06:33:02'),(6,'announcement_enabled','1','announcement','Enabled','boolean','Show the top announcement bar','2026-08-30 06:33:02','2026-08-30 06:33:02'),(7,'announcement_text','Welcome to Hosttiller.com—your trusted partner for blazing-fast NVMe web hosting, secure cloud infrastructure, and reliable here in Bangladesh.','announcement','Text','text','Announcement message','2026-08-30 06:33:02','2026-09-05 19:31:45'),(8,'announcement_link','/bdix-web-hosting','announcement','Link','text','Link target (optional)','2026-08-30 06:33:02','2026-09-04 15:03:29'),(9,'seo_meta_title','Best Web Hosting in Bangladesh | Cheap NVMe SSD, VPS & Reseller','seo','SEO meta title','text','Default browser tab title','2026-08-30 06:33:03','2026-09-07 14:56:43'),(10,'seo_meta_description','Best web hosting in Bangladesh at cheap Taka prices. LiteSpeed NVMe SSD shared hosting, BDIX VPS, reseller and dedicated servers with free SSL, daily backups and 24/7 local support.','seo','SEO meta description','text','Meta description','2026-08-30 06:33:03','2026-09-07 14:56:43'),(11,'seo_keywords','web hosting bangladesh, cheap web hosting bangladesh, vps bangladesh, bdix hosting, dedicated server bangladesh, reseller hosting bangladesh, domain bangladesh, hosting price in taka, wordpress hosting bangladesh','seo','SEO keywords','text','Meta keywords','2026-08-30 06:33:03','2026-09-07 14:56:43'),(12,'seo_og_image','','seo','Og Image','text','Social share image (path)','2026-08-30 06:33:03','2026-08-30 06:33:03'),(13,'hero_enabled','1','hero','Enabled','boolean','Show the hero section','2026-08-30 06:33:03','2026-08-30 06:33:03'),(14,'hero_badge','Trusted by 200,000+ customers worldwide','hero','Badge','text','Small badge above the title','2026-08-30 06:33:03','2026-08-30 06:33:03'),(15,'hero_title','Web Hosting That Keeps Your Business Growing','hero','Title','text','Main headline','2026-08-30 06:33:03','2026-08-30 06:33:03'),(16,'hero_title_highlight','Growing','hero','Title Highlight','text','Word that is highlighted with your secondary (gold) color','2026-08-30 06:33:03','2026-08-30 06:33:03'),(17,'hero_subtitle','Deploy your website on high-speed NVMe servers with 99.9% uptime, free SSL, daily backups and a support team that actually answers in minutes.','hero','Subtitle','text','Supporting paragraph','2026-08-30 06:33:03','2026-08-30 06:33:03'),(18,'hero_primary_button_text','Get Started','hero','Primary Button Text','text','Main button label','2026-08-30 06:33:03','2026-08-30 06:33:03'),(19,'hero_primary_button_url','/pricing','hero','Primary Button Url','text','Main button link','2026-08-30 06:33:03','2026-08-30 06:33:03'),(20,'hero_secondary_button_text','Explore Features','hero','Secondary Button Text','text','Secondary button label','2026-08-30 06:33:03','2026-08-30 06:33:03'),(21,'hero_secondary_button_url','#features','hero','Secondary Button Url','text','Secondary button link','2026-08-30 06:33:04','2026-08-30 09:02:31'),(22,'hero_image','media/hero.png','hero','Image','text','Hero illustration image (path)','2026-08-30 06:33:04','2026-08-30 06:33:04'),(23,'about_enabled','1','about','Enabled','boolean','Show the about / why-choose-us section','2026-08-30 06:33:04','2026-08-30 18:38:27'),(24,'about_eyebrow','Why HostTiller','about','Eyebrow','text','Small label','2026-08-30 06:33:04','2026-08-30 06:33:04'),(25,'about_title','A hosting platform engineered for performance and peace of mind','about','Title','text','Section title','2026-08-30 06:33:04','2026-08-30 06:33:04'),(26,'about_text','We built HostTiller so that developers, freelancers and growing companies never have to worry about where their website sleeps at night. From enterprise-grade infrastructure to people who treat your project like their own, we are the reliable partner modern websites deserve.','about','Text','text','Supporting text','2026-08-30 06:33:04','2026-08-30 06:33:04'),(27,'about_image','media/brand-about_image-exql7ctz.jpg','about','About Image','text','About section image (uploaded via Site Content > About)','2026-08-30 06:33:04','2026-09-04 15:03:46'),(28,'about_button_text','Learn More','about','Button Text','text','Button label','2026-08-30 06:33:04','2026-08-30 06:33:04'),(29,'about_button_url','/about-us','about','Button Url','text','Button link','2026-08-30 06:33:04','2026-09-04 15:13:41'),(30,'cta_enabled','1','cta','Enabled','boolean','Show the call-to-action band','2026-08-30 06:33:04','2026-08-30 06:33:04'),(31,'cta_eyebrow','Ready when you are','cta','Eyebrow','text','Small label','2026-08-30 06:33:04','2026-08-30 06:33:04'),(32,'cta_title','Launch your website in under 5 minutes','cta','Title','text','Bold headline','2026-08-30 06:33:04','2026-08-30 06:33:04'),(33,'cta_text','Join thousands of happy customers. Pick a plan, connect your domain and your site will be live before your coffee gets cold.','cta','Text','text','Supporting text','2026-08-30 06:33:05','2026-08-30 06:33:05'),(34,'cta_button_text','Start Today','cta','Button Text','text','Button label','2026-08-30 06:33:05','2026-08-30 06:33:05'),(35,'cta_button_url','/bdix-web-hosting','cta','Button Url','text','Button link','2026-08-30 06:33:05','2026-09-04 15:11:38'),(36,'cta_secondary_button_text','Talk to Sales','cta','Secondary Button Text','text','Secondary button label','2026-08-30 06:33:05','2026-08-30 06:33:05'),(37,'cta_secondary_button_url','/contact','cta','Secondary Button Url','text','Secondary button link','2026-08-30 06:33:05','2026-08-30 06:33:05'),(38,'contact_phone','+8801911336699','contact','Phone','text','Primary phone number','2026-08-30 06:33:05','2026-09-04 15:06:05'),(39,'contact_email','info@hosttiller.com','contact','Email','text','Contact / sales email','2026-08-30 06:33:05','2026-09-04 15:06:05'),(40,'contact_support_email','support@hosttiller.com','contact','Support Email','text','Support email','2026-08-30 06:33:05','2026-08-30 06:33:05'),(41,'contact_address','90/2 road sonadanga 1 no R/A','contact','Address','text','Street address','2026-08-30 06:33:05','2026-09-04 15:06:05'),(42,'contact_city','Khulna, Bangladesh','contact','City','text','City, state, country','2026-08-30 06:33:05','2026-09-04 15:06:05'),(43,'contact_hours','Mon – Sat: 8:00 AM – 10:00 PM','contact','Hours','text','Business hours','2026-08-30 06:33:05','2026-08-30 06:33:05'),(44,'contact_map_url','','contact','Map Url','text','Google Maps embed URL (optional)','2026-08-30 06:33:05','2026-08-30 06:33:05'),(45,'contact_whatsapp','+8801911336699','contact','Whatsapp','text','WhatsApp number','2026-08-30 06:33:05','2026-09-04 15:06:05'),(46,'social_facebook','https://facebook.com/hosttiller','social','Facebook','text','Facebook URL','2026-08-30 06:33:05','2026-09-04 15:07:16'),(47,'social_twitter','https://twitter.com/hosttiller','social','Twitter','text','Twitter / X URL','2026-08-30 06:33:06','2026-09-04 15:07:16'),(48,'social_instagram','https://instagram.com/hosttiller','social','Instagram','text','Instagram URL','2026-08-30 06:33:06','2026-09-04 15:07:16'),(49,'social_linkedin','https://linkedin.com/hosttiller','social','Linkedin','text','LinkedIn URL','2026-08-30 06:33:06','2026-09-04 15:07:16'),(50,'social_youtube','https://youtube.com@hosttiller','social','Youtube','text','YouTube URL','2026-08-30 06:33:06','2026-09-04 15:07:16'),(51,'footer_about_text','HostTiller delivers speed, security and reliability for websites of every size. Hosting the web, one happy customer at a time.','footer','About Text','text','Short company description','2026-08-30 06:33:06','2026-08-30 06:33:06'),(52,'footer_copyright_text','© 2026 HostTiller. All rights reserved.','footer','Copyright Text','text','Copyright line','2026-08-30 06:33:06','2026-08-30 06:33:06'),(53,'footer_newsletter_text','Subscribe for hosting tips, discounts and product news.','footer','Newsletter Text','text','Newsletter invite','2026-08-30 06:33:06','2026-08-30 06:33:06'),(54,'theme_primary','#0A3D61','theme','Primary','color','Primary brand color (dark navy blue)','2026-08-30 06:33:06','2026-08-30 06:33:06'),(55,'theme_primary_dark','#082E4A','theme','Primary Dark','color','Darker hero / footer backgrounds','2026-08-30 06:33:06','2026-08-30 06:33:06'),(56,'theme_secondary','#EAB543','theme','Secondary','color','Secondary brand color (gold / amber)','2026-08-30 06:33:06','2026-08-30 06:33:06'),(57,'theme_secondary_dark','#C99A26','theme','Secondary Dark','color','Darkened gold for text on gold','2026-08-30 06:33:06','2026-08-30 06:33:06'),(58,'theme_heading_font','Poppins','theme','Heading Font','text','Heading font family','2026-08-30 06:33:06','2026-08-30 06:33:06'),(59,'theme_body_font','Inter','theme','Body Font','text','Body font family','2026-08-30 06:33:07','2026-08-30 06:33:07'),(60,'theme_radius','14','theme','Radius','text','Rounded corner radius (px)','2026-08-30 06:33:07','2026-08-30 06:33:07'),(61,'theme_footer_dark','1','theme','Footer Dark','boolean','Use dark navy footer and header','2026-08-30 06:33:07','2026-08-30 06:33:07'),(62,'hero_stats','[{\"value\":\"99.9%\",\"label\":\"Uptime guarantee\"},{\"value\":\"24\\/7\",\"label\":\"Expert support\"},{\"value\":\"200K+\",\"label\":\"Websites hosted\"},{\"value\":\"4.9\\/5\",\"label\":\"Customer rating\"}]','hero','Hero statistics','json','Format: value + label','2026-08-30 06:33:07','2026-08-30 06:33:07'),(63,'hero_trusted','[{\"name\":\"NimbusPay\"},{\"name\":\"Pixelcraft\"},{\"name\":\"ShopGrid\"},{\"name\":\"CloudSeven\"},{\"name\":\"Brightlane\"}]','hero','Trusted-by logos','json','Company names displayed under the hero','2026-08-30 06:33:07','2026-08-30 06:33:07'),(64,'about_points','[{\"title\":\"99.9% Uptime SLA\",\"text\":\"Redundant power, networking and enterprise hardware keep your site online.\"},{\"title\":\"NVMe SSD Speed\",\"text\":\"LiteSpeed servers with NVMe drives load pages up to 10x faster.\"},{\"title\":\"Daily Automatic Backups\",\"text\":\"Restore any previous day in one click. Your data is never lost.\"},{\"title\":\"Free SSL + CDN\",\"text\":\"Security and a global edge network included in every single plan.\"}]','about','Feature points','json','title + text','2026-08-30 06:33:07','2026-08-30 06:33:07'),(65,'sections_plans','{\"enabled\":true,\"eyebrow\":\"Plans & Pricing\",\"title\":\"Pricing Plans\",\"title_highlight\":\"Plans\",\"subtitle\":\"Pick your perfect plan. All plans include LiteSpeed Web Server, Imunify360 security, free SSL, daily backups, and 24\\/7 support. Scale up anytime \\u2014 no migration needed.\",\"note\":\"\\u09a1\\u09cb\\u09ae\\u09c7\\u0987\\u09a8 \\u09b6\\u09c1\\u09a7\\u09c1 \\u09aa\\u09cd\\u09b0\\u09a5\\u09ae \\u09ac\\u099b\\u09b0 \\u098f\\u09b0 \\u099c\\u09a8\\u09cd\\u09af \\u09ab\\u09cd\\u09b0\\u09bf \\u2014 Free domain for 1st year only\"}','sections','Pricing section','json','Enabled + heading + note','2026-08-30 06:33:07','2026-08-30 12:13:33'),(67,'sections_testimonials','{\"eyebrow\":\"Wall of love\",\"title\":\"Loved by teams and solo builders\",\"subtitle\":\"Real reviews from real customers who moved their websites to HostTiller.\"}','sections','Testimonials section','json','Enabled + heading','2026-08-30 06:33:07','2026-08-30 12:22:04'),(68,'sections_faqs','{\"enabled\":true,\"eyebrow\":\"FAQ\",\"title\":\"Frequently asked questions\",\"subtitle\":\"Everything you need to know before picking a plan. Still curious? Just ask us.\"}','sections','FAQ section','json','Enabled + heading','2026-08-30 06:33:07','2026-08-30 06:33:07'),(69,'sections_blog','{\"enabled\":true,\"eyebrow\":\"From the blog\",\"title\":\"Guides, tips and product news\",\"subtitle\":\"Fresh, useful content to help you get the most out of the web.\"}','sections','Blog section','json','Enabled + heading','2026-08-30 06:33:07','2026-09-05 19:34:18'),(70,'hero_slides','[{\"badge\":\"Bangladesh\\u2019s local web host \\u00b7 BDIX + bKash \\/ Nagad\",\"title\":\"Best Web Hosting in Bangladesh at Taka Prices\",\"title_highlight\":\"Bangladesh\",\"subtitle\":\"Cheap, fast web hosting in Bangladesh on LiteSpeed NVMe SSD with real BDIX connectivity, free SSL, daily backups and 24\\/7 local support. Prices in BDT \\u2014 pay with bKash, Nagad or rocket.\",\"primary_button_text\":\"Get Started\",\"primary_button_url\":\"\\/pricing\",\"secondary_button_text\":\"Explore Features\",\"secondary_button_url\":\"#features\",\"image\":null,\"accent\":\"#EAB543\",\"live_badge\":\"Performance tuned\",\"points\":[{\"icon\":\"zap\",\"title\":\"BDIX + NVMe speed\",\"text\":\"Fast loading for Dhaka & BD visitors\"},{\"icon\":\"globe\",\"title\":\"Pay in Taka (BDT)\",\"text\":\"bKash, Nagad, rocket accepted\"},{\"icon\":\"shield\",\"title\":\"Free SSL + backups\",\"text\":\"Secure & daily auto-backups\"},{\"icon\":\"headphones\",\"title\":\"24\\/7 local support\",\"text\":\"Bangladesh-friendly team\"}]},{\"badge\":\"Bank-grade security included by default\",\"title\":\"Your Site, Locked Down & Always Online\",\"title_highlight\":\"Locked Down\",\"subtitle\":\"Free SSL on every plan, Imunify360 firewall, DDoS protection and off-site backups \\u2014 so you never have to worry about threats or downtime.\",\"primary_button_text\":\"Get Protected\",\"primary_button_url\":\"\\/pricing\",\"secondary_button_text\":\"Security Overview\",\"secondary_button_url\":\"#features\",\"image\":null,\"accent\":\"#34D399\",\"live_badge\":\"Shield active\",\"points\":[{\"icon\":\"lock\",\"title\":\"Free SSL\",\"text\":\"Auto-renewed, always\"},{\"icon\":\"shield\",\"title\":\"WAF + firewall\",\"text\":\"Imunify360 hardened\"},{\"icon\":\"cloud\",\"title\":\"DDoS shield\",\"text\":\"Always-on protection\"},{\"icon\":\"alert\",\"title\":\"24\\/7 monitoring\",\"text\":\"Instant breach alerts\"}]},{\"badge\":\"Real engineers, real answers\",\"title\":\"24\\/7 Support From Humans, Not Bots\",\"title_highlight\":\"Humans\",\"subtitle\":\"Live chat, ticketing and phone support around the clock with a median first reply of 4 minutes. We answer in plain English \\u2014 every time.\",\"primary_button_text\":\"Talk to Us\",\"primary_button_url\":\"\\/contact\",\"secondary_button_text\":\"See Plans\",\"secondary_button_url\":\"\\/pricing\",\"image\":null,\"accent\":\"#A78BFA\",\"live_badge\":\"Online now\",\"points\":[{\"icon\":\"headphones\",\"title\":\"Live chat 24\\/7\",\"text\":\"4-min median reply\"},{\"icon\":\"user\",\"title\":\"Named engineer\",\"text\":\"Dedicated help\"},{\"icon\":\"send\",\"title\":\"Pro migrations\",\"text\":\"Free & seamless\"},{\"icon\":\"clock\",\"title\":\"SLA-backed\",\"text\":\"1h critical response\"}]}]','hero','Hero slides','json','Each slide: badge, title, highlighted word, subtitle, buttons, accent color and up to 4 feature cards','2026-08-30 07:40:16','2026-09-07 14:56:44'),(71,'sections_features','{\"enabled\":true,\"eyebrow\":\"Why HostTiller\",\"title\":\"A hosting platform engineered for performance and peace of mind\",\"title_highlight\":\"performance and peace of mind\",\"subtitle\":\"We built HostTiller so that developers, freelancers and growing companies never have to worry about where their website sleeps at night. From enterprise-grade infrastructure to people who treat your project like their own, we are the reliable partner modern websites deserve.\",\"button_text\":\"Learn More\",\"button_url\":\"\\/bdix-web-hosting\"}','sections','Why HostTiller section','json','Enabled + heading + Learn More button','2026-08-30 09:02:29','2026-09-04 15:11:27'),(72,'sections_banner','{\"enabled\":true,\"eyebrow\":\"Now shipping \\u00b7 Managed Cloud VPS\",\"title\":\"Hosting that feels like it lives on your network\",\"title_highlight\":\"your network\",\"subtitle\":\"LiteSpeed NVMe servers, BDIX-peered networks and enterprise-grade security \\u2014 every site we host is launched, tuned and backed up for you, from Dhaka to the world.\",\"button_text\":\"Start now from $3.99\",\"button_url\":\"\\/bdix-web-hosting\"}','sections','Hosting banner section','json','Enabled + heading + button. The animated telemetry console is rendered from the component.','2026-08-30 12:13:33','2026-09-04 15:11:27'),(73,'sections_network','{\"enabled\":true,\"eyebrow\":\"Global Network \\u00b7 Multi-Region\",\"title\":\"Multi-Region Enterprise Core\",\"title_highlight\":\"Enterprise Core\",\"subtitle\":\"Strategically multihomed data centers providing ultra-low local BDIX ping, direct peering transits, and global backup redundancy.\",\"button_text\":\"Explore the network\",\"button_url\":\"\\/pricing\"}','sections','Global network section','json','Enabled + heading + button. The animated network map is rendered from the component.','2026-08-30 12:13:33','2026-08-30 12:13:33'),(74,'sections_performance','{\"enabled\":true,\"eyebrow\":\"Performance\",\"title\":\"Performance Breakdown\",\"title_highlight\":\"Breakdown\",\"subtitle\":\"Real numbers from production servers in the Dhaka core. Every HostTiller site ships with this performance profile by default \\u2014 no tuning needed.\"}','sections','Performance breakdown section','json','Enabled + heading. Live dashboard + metrics are rendered from the component.','2026-08-30 12:22:04','2026-08-30 12:22:04'),(75,'pricing_bdt_rate','125','pricing','USD to BDT Rate','number','Exchange rate used to convert USD prices to BDT (e.g. 1 USD = 115 BDT). Changes apply to every price on the site instantly.','2026-08-30 18:59:46','2026-09-04 16:17:52'),(76,'pricing_billing_cycles','[{\"key\":\"triennially\",\"label\":\"Triennially\",\"months\":36,\"savePercent\":12},{\"key\":\"biennially\",\"label\":\"Biennially\",\"months\":24,\"savePercent\":6},{\"key\":\"yearly\",\"label\":\"Annually\",\"months\":12,\"savePercent\":0},{\"key\":\"monthly\",\"label\":\"Monthly\",\"months\":1,\"savePercent\":0}]','pricing','Billing cycles','json','Billing cycles shown on every plan box (Monthly, Annually, Biennially, Triennially). Each row: label, months, save %.','2026-09-01 20:34:16','2026-09-04 16:17:41'),(77,'footer_logo','media/brand-footer_logo-gswwgp2t.png','footer','Footer Logo','text','Footer logo image (uploaded via Site Content > Footer)','2026-09-02 15:10:07','2026-09-04 14:38:10'),(78,'livechat_enabled','1','livechat','Enabled','boolean','Master toggle — show the floating live chat widget site-wide','2026-09-03 22:10:44','2026-09-04 13:53:44'),(79,'livechat_position','left','livechat','Position','text','Chat button position: right or left','2026-09-03 22:10:44','2026-09-04 14:39:20'),(80,'livechat_heading','Chat with us','livechat','Heading','text','Heading shown on the chat widget','2026-09-03 22:10:44','2026-09-03 22:10:44'),(81,'livechat_subheading','We usually reply within a few minutes','livechat','Subheading','text','Sub-heading shown on the chat widget','2026-09-03 22:10:45','2026-09-03 22:10:45'),(82,'livechat_facebook_enabled','1','livechat','Facebook Enabled','boolean','Show the Facebook Messenger chat option','2026-09-03 22:10:45','2026-09-03 22:10:45'),(83,'livechat_facebook_user','HostTiller','livechat','Facebook User','text','Facebook page name / handle (for Messenger deep link)','2026-09-03 22:10:45','2026-09-04 13:53:44'),(84,'livechat_whatsapp_enabled','1','livechat','Whatsapp Enabled','boolean','Show the WhatsApp chat option','2026-09-03 22:10:45','2026-09-03 22:10:45'),(85,'livechat_whatsapp_number','8801911336699','livechat','Whatsapp Number','text','WhatsApp number in international format, digits only (e.g. 8801...)','2026-09-03 22:10:45','2026-09-03 22:10:45'),(86,'livechat_telegram_enabled','1','livechat','Telegram Enabled','boolean','Show the Telegram chat option','2026-09-03 22:10:45','2026-09-03 22:10:45'),(87,'livechat_telegram_username','hosttiller','livechat','Telegram Username','text','Telegram username without the @ symbol','2026-09-03 22:10:45','2026-09-03 22:10:45'),(88,'livechat_header_bg','#C99A26','livechat','Header Bg','color','Background color of the chat box header (where the heading and sub-heading appear)','2026-09-03 22:25:00','2026-09-04 14:39:21'),(89,'sections_tabbed_plans','{\"enabled\":true,\"eyebrow\":\"Explore All Hosting\",\"title\":\"Choose Your Hosting Type\",\"title_highlight\":\"Hosting Type\",\"subtitle\":\"From shared hosting for your first site to dedicated servers for heavy workloads \\u2014 switch tabs to compare every hosting option we offer.\"}','sections','Tabbed hosting section','json','Enabled + heading. Plans are edited under Admin > Plans per product type.',NULL,NULL),(90,'sections_home_plans','{\"enabled\":false,\"note\":\"Featured plan cards on the homepage.\"}','sections','Homepage featured plans section','json','Show/hide the featured plan cards on the homepage only.',NULL,NULL);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `support_tickets`
--

DROP TABLE IF EXISTS `support_tickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `support_tickets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `number` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `department` varchar(255) DEFAULT NULL,
  `priority` varchar(255) DEFAULT 'Normal',
  `status` varchar(255) DEFAULT 'Open',
  `last_reply_at` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `support_tickets`
--

LOCK TABLES `support_tickets` WRITE;
/*!40000 ALTER TABLE `support_tickets` DISABLE KEYS */;
INSERT INTO `support_tickets` VALUES (2,3,'TKT-17471','How do I point my domain nameservers?','Technical Support','Normal','Answered','2026-08-31 16:22:06','2026-08-31 16:22:06','2026-08-31 16:22:06'),(3,3,'TKT-42739','Requesting SSL certificate renewal','Sales & Billing','Low','Open','2026-08-30 16:22:06','2026-08-31 16:22:06','2026-08-31 16:22:06');
/*!40000 ALTER TABLE `support_tickets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `testimonials`
--

DROP TABLE IF EXISTS `testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testimonials` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `rating` int(11) DEFAULT 5,
  `quote` text NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testimonials`
--

LOCK TABLES `testimonials` WRITE;
/*!40000 ALTER TABLE `testimonials` DISABLE KEYS */;
INSERT INTO `testimonials` VALUES (51,'Amelia Rodriguez','Founder & CEO','ShopGrid',NULL,5,'We moved 300,000+ monthly visitors onto HostTiller and the difference was immediate. Page loads dropped from 3.4s to under 800ms. Support answered every ticket in minutes.',1,1,'2026-09-04 13:54:03','2026-09-04 13:54:03'),(52,'David Chen','Freelance Developer',NULL,NULL,5,'I host 40+ client sites here. The dashboard is clean, migrations are free, and the uptime has been flawless. HostTiller basically runs my agency now.',2,1,'2026-09-04 13:54:04','2026-09-04 13:54:04'),(53,'Sofia Marino','Head of Marketing','NimbusPay',NULL,5,'Black Friday crushed us with traffic and the site did not even blink. The unlimited bandwidth and CDN really do what they say on the tin.',3,1,'2026-09-04 13:54:04','2026-09-04 13:54:04'),(54,'James Okafor','Full-stack Developer','Brightlane',NULL,4,'Fast servers, sane pricing and a genuinely helpful support team. The free SSL and one-click backups are the cherries on top.',4,1,'2026-09-04 13:54:04','2026-09-04 13:54:04'),(55,'Lena Fischer','Online Educator',NULL,NULL,5,'As a solo creator I needed simple. HostTiller made launching my course platform effortless ΓÇö and the 24/7 chat saved me twice at 2am.',5,1,'2026-09-04 13:54:04','2026-09-04 13:54:04');
/*!40000 ALTER TABLE `testimonials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket_replies`
--

DROP TABLE IF EXISTS `ticket_replies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_replies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `is_staff` int(11) DEFAULT 0,
  `body` text NOT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_replies`
--

LOCK TABLES `ticket_replies` WRITE;
/*!40000 ALTER TABLE `ticket_replies` DISABLE KEYS */;
INSERT INTO `ticket_replies` VALUES (1,2,3,0,'Hi, I just bought hosting and need to point my domain nameservers to HostTiller. What do I set them to?','2026-08-31 16:22:06','2026-08-31 16:22:06'),(2,2,NULL,1,'Hello! Point your nameservers to ns1.hosttiller.com and ns2.hosttiller.com. Allow 24-48 hours to propagate. Let us know if you need any help.','2026-08-31 16:22:06','2026-08-31 16:22:06');
/*!40000 ALTER TABLE `ticket_replies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `is_admin` int(11) DEFAULT 0,
  `remember_token` varchar(255) DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  `updated_at` varchar(255) DEFAULT NULL,
  `is_client` int(11) DEFAULT 0,
  `client_no` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT 'BD',
  `client_status` varchar(255) DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Aljin Admin','aljin.sr1@gmail.com',NULL,'$2y$12$voMstmr3/i1WLY4z.ldv5eu43DGmaylQgG/4X.P1Zh7enGNmPSMpO',1,'nIP5uOWBM2liEI0cIZwdLLXGPz9tKF32hrsp5usEzTRXXdCuqfQmpuR9P4hj','2026-08-30 06:33:02','2026-09-06 20:07:20',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'BD','Active'),(3,'Demo Client','demo@hosttiller.com',NULL,'$2y$12$vH8iAW5FuNYh7ujLDVVxy.II5mvn9/Vkn/l0L9WNPoaTOfGWDj5ZS',0,NULL,'2026-08-31 16:22:05','2026-08-31 16:22:05',1,'C-DEMO01','Demo Studio Ltd','+8801712345678','12 Gulshan Avenue','Dhaka','Dhaka','1212','BD','Active');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'hosttiller_hosttiller'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-09-07  9:50:49