-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 17, 2026 at 07:05 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `u680871603_emepro`
--
-- --------------------------------------------------------
--
-- Table structure for table `active_number`
--
CREATE TABLE `active_number` (
`id` int(11) NOT NULL,
`user_id` varchar(255) NOT NULL,
`number_id` varchar(255) NOT NULL,
`number` varchar(255) NOT NULL,
`server_id` varchar(255) NOT NULL,
`service_id` varchar(255) NOT NULL,
`order_id` varchar(255) NOT NULL,
`buy_time` datetime NOT NULL DEFAULT current_timestamp(),
`service_price` varchar(255) NOT NULL,
`service_name` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
`sms_text` varchar(255) NOT NULL,
`active_status` varchar(255) NOT NULL,
`provider` varchar(20) NOT NULL DEFAULT 'smscodes' COMMENT 'smscodes | smspva',
`operator` varchar(100) NOT NULL DEFAULT '' COMMENT 'smspva operator name or empty for smscodes',
`provider_type` varchar(20) NOT NULL DEFAULT 'smscodes' COMMENT 'smscodes or smspva',
`api_provider` varchar(50) NOT NULL DEFAULT 'smscodes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `active_number`
--
INSERT INTO `active_number` (`id`, `user_id`, `number_id`, `number`, `server_id`, `service_id`, `order_id`, `buy_time`, `service_price`, `service_name`, `status`, `sms_text`, `active_status`, `provider`, `operator`, `provider_type`, `api_provider`) VALUES
(1, '340', '177081281', '+31613643243', '251', 'opt131', 'W9Qbc2rNzPL6saziJUre', '2026-05-24 06:29:05', '1125', 'Apple', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(2, '340', '177081493', '+15037528219', '274', 'opt46', 'cqANnPtSx9N6c4DIfp4r', '2026-05-24 06:48:17', '3937.5', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(3, '340', '177081640', '+4368181669454', '187', 'opt46', 'Y4vjGE1HjBwqzOGrrwsJ', '2026-05-24 07:13:18', '3375', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(4, '340', '177081681', '+358417401633', '214', 'opt46', 's05tbwwVRdLAAQTd3cKS', '2026-05-24 07:19:28', '2250', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(5, '340', '177081693', '+34669074886', '213', 'opt46', 'DAY4A0WSXWZNp5BzFZoG', '2026-05-24 07:22:57', '3825', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(6, '340', '177081817', '+353899458058', '227', 'opt46', 'aHYrpJl2sHNXImoSNspW', '2026-05-24 07:49:23', '1800', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(7, '340', '177091354', '+447342345339', '273', 'opt242', '4OuNXwCVmOBak0e5QepA', '2026-05-24 19:34:24', '2565', 'Abbott', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(8, '340', '177115636', '+447348616682', '273', 'opt231', 'sVhrD4TzXdWBli6PnIpN', '2026-05-26 01:11:25', '1710', 'Whatnot', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(9, '340', '177316053', '+48739406471', '256', 'opt46', 'wXAsx6Lox3gg9MVCaRXn', '2026-06-05 12:05:02', '1980', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(10, '340', '177316623', '+447393821405', '273', 'opt132', 'AIsTw1vMS3WEd6bRvnB2', '2026-06-05 12:40:54', '600', '1 OpenAI API (chatGPT, DALL-e 2)', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(11, '340', '177316688', '+48739406471', '256', 'opt46', 'cAgLdV2nfjrq7UIOQjBC', '2026-06-05 12:45:22', '1980', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(12, '340', '177316704', '+358414990898', '214', 'opt46', 'oBg3eEa0xSQDTb3iBLNw', '2026-06-05 12:46:46', '3000', 'Airbnb', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(13, '340', '177319448', '+358414996012', '214', 'opt131', 'sr7RIC9R4bHiXuiMzQ56', '2026-06-05 13:14:52', '3000', 'Apple', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(14, '340', '177319510', '+447348591849', '273', 'opt20', 'K5iyORxbpXCrgZNYSlnG', '2026-06-05 13:18:27', '9000', 'WhatsAPP', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(15, '340', '177382836', '+447347071599', '273', 'opt20', 'lMXweIBLcj8DXUkC5uH9', '2026-06-08 18:54:33', '4200', 'WhatsAPP', '1', '952115 <#> Your WhatsApp code: 952-115_Don\'t share this code with others_4sgLq1p5sV6', '1', 'smspva', '', 'smscodes', 'smscodes'),
(16, '340', '177472988', '+19714286116', '274', 'opt131', 'xmtDhHTalAvo7tjRQxKw', '2026-06-12 11:06:14', '5250', 'Apple', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(17, '340', '177762122', '+19714439227', '274', 'opt140', 'rVKABdWfTLt0nH86TCJX', '2026-06-25 22:33:16', '8250', 'Google Voice', '3', '', '1', 'smspva', '', 'smscodes', 'smscodes'),
(18, '340', '177766123', '+19715161433', '274', 'opt66', 'PrGKElEuxSOLsAuFt9b7', '2026-06-26 02:39:30', '5250', 'Twilio', '1', '717001 Your Twilio verification code is: 717001', '1', 'smspva', '', 'smscodes', 'smscodes');
-- --------------------------------------------------------
--
-- Table structure for table `api_detail`
--
CREATE TABLE `api_detail` (
`id` int(11) NOT NULL,
`api_name` varchar(255) NOT NULL,
`api_url` varchar(255) NOT NULL,
`api_key` varchar(255) NOT NULL,
`api_code` varchar(255) NOT NULL,
`api_type` varchar(30) NOT NULL DEFAULT 'smscodes' COMMENT 'smscodes | smspva'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `api_detail`
--
INSERT INTO `api_detail` (`id`, `api_name`, `api_url`, `api_key`, `api_code`, `api_type`) VALUES
(7, 'SMSCodes', 'https://code.smscodes.io/api/sms', 'xxxxxxxxxxxxxxxxx', '1', 'smscodes'),
(9, 'SMSPVA', 'https://api.smspva.com', 'bMB0Ju3wFOp1TapvBDPoxSlhcldfwI', '1', 'smspva'),
(10, '5SIM', 'https://5sim.net/v1', 'bc54e5324edc4454a1efee9a7a6a2a6c', '1', '5sim'),
(11, 'SMS-Bus', 'https://sms-bus.com/api/control', '1697b0b6ee7847d881d2bd65d9311bbd', '1', 'smsbus');
-- --------------------------------------------------------
--
-- Table structure for table `api_logs`
--
CREATE TABLE `api_logs` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`endpoint` varchar(100) NOT NULL,
`method` varchar(10) NOT NULL DEFAULT 'GET',
`ip_address` varchar(45) NOT NULL,
`request_data` text DEFAULT NULL,
`response_status` varchar(10) DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `blog_posts`
--
CREATE TABLE `blog_posts` (
`id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`category` varchar(100) NOT NULL DEFAULT 'General',
`author` varchar(100) NOT NULL DEFAULT 'Admin',
`excerpt` text NOT NULL,
`content` longtext NOT NULL,
`thumbnail` varchar(500) NOT NULL DEFAULT '' COMMENT 'Uploaded image path relative to web root',
`read_time` varchar(50) NOT NULL DEFAULT '5 min read',
`status` enum('published','draft') NOT NULL DEFAULT 'draft' COMMENT 'published or draft',
`views` int(11) NOT NULL DEFAULT 0,
`created_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Blog posts with thumbnail upload support';
--
-- Dumping data for table `blog_posts`
--
INSERT INTO `blog_posts` (`id`, `title`, `slug`, `category`, `author`, `excerpt`, `content`, `thumbnail`, `read_time`, `status`, `views`, `created_at`, `updated_at`) VALUES
(1, '10 Proven Strategies to Boost Your Instagram Engagement in 2026', '10-proven-strategies-instagram-engagement-2026', 'SMM Tips', 'Danny Breed', 'Discover the most effective techniques to increase your Instagram engagement rate, grow your follower base organically, and build a loyal community around your brand.', 'In the ever-evolving world of social media, Instagram remains one of the most powerful platforms for building your brand and connecting with your audience. With over 2 billion active users, standing out requires more than just posting pretty pictures. Here are 10 proven strategies that will help you boost your Instagram engagement in 2026.
\r\n1. Post at Optimal Times
\r\nTiming is everything on Instagram. Analyze your Instagram Insights to determine when your followers are most active.
\r\n2. Use Instagram Reels Strategically
\r\nReels continue to dominate Instagram\'s algorithm. Create short, engaging videos that provide value, entertainment, or education.
\r\n3. Engage With Your Audience
\r\nRespond to comments within the first hour of posting and ask questions in your captions to encourage conversations.
\r\nConclusion
\r\nGrowing your Instagram engagement takes time and consistency. Implement these strategies and watch your engagement soar.
', '/assets/images/social2.webp', '5 min read', 'published', 262, '2026-01-15 10:30:00', '2026-07-16 14:30:40'),
(2, 'Why Virtual Phone Numbers Are Essential for Online Privacy in 2026', 'virtual-phone-numbers-online-privacy-2026', 'Privacy', 'Danny Breed', 'Learn how virtual phone numbers can protect your personal information while allowing you to verify accounts on hundreds of platforms without compromising security.', 'In today\'s digital age, protecting your personal information has never been more critical. Virtual phone numbers have emerged as an essential tool for maintaining privacy while navigating the online world.
\r\nWhat Are Virtual Phone Numbers?
\r\nVirtual phone numbers are telephone numbers that aren\'t directly associated with a physical phone line. They forward calls and SMS messages to your actual phone number while keeping your personal number private.
\r\nWhy You Need Them
\r\n- Data breaches and leaks
- Spam calls and messages
- Identity theft
\r\nConclusion
\r\nVirtual phone numbers are no longer optional — they\'re essential for anyone who values their online privacy.
', '/assets/images/hero-img.webp', '7 min read', 'published', 839, '2026-01-28 14:15:00', '2026-07-16 14:30:41'),
(3, 'The Complete Guide to Choosing the Right SMM Panel for Your Business', 'complete-guide-choosing-smm-panel-business', 'Marketing', 'Danny Breed', 'Not all SMM panels are created equal. Here\'s everything you need to know about selecting a reliable, high-quality service provider for your social media growth.', 'Choosing the right SMM panel can make or break your social media marketing strategy. With countless providers claiming to offer the best services, how do you separate the genuine from the fraudulent?
\r\nWhat to Look For
\r\n1. Service Quality
\r\nThe best SMM panels provide high-quality, genuine engagement from real accounts.
\r\n2. Customer Support
\r\nReliable customer support is crucial. Choose providers that offer multiple support channels.
\r\nRed Flags to Avoid
\r\n- Panels requiring your account password
- Unrealistically cheap prices
- No refund or refill policy
\r\nConclusion
\r\nSelecting the right SMM panel is an investment in your brand\'s future.