-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 09, 2025 at 10:04 PM
-- Server version: 10.6.20-MariaDB-cll-lve
-- PHP Version: 8.3.8
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: `egpayio_pay`
--
-- --------------------------------------------------------
--
-- Table structure for table `activity_logs`
--
CREATE TABLE `activity_logs` (
`id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`ip` varchar(50) NOT NULL,
`activity` text DEFAULT NULL,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `activity_logs`
--
INSERT INTO `activity_logs` (`id`, `uid`, `ip`, `activity`, `created_at`) VALUES
(58, 357, '103.115.24.239', 'Signin', '2025-03-11 04:49:30'),
(59, 358, '103.148.52.244', 'Signin', '2025-03-11 20:16:53'),
(60, 358, '180.148.213.124', 'Signin', '2025-03-12 14:35:12'),
(61, 358, '180.148.213.124', 'Signin', '2025-03-13 13:40:53'),
(62, 358, '180.148.213.124', 'Signin', '2025-03-13 13:50:55'),
(63, 359, '103.25.251.236', 'Signin', '2025-03-13 20:38:25'),
(64, 358, '103.148.52.244', 'Signin', '2025-03-13 23:01:55'),
(65, 358, '103.148.52.244', 'Signin', '2025-03-14 16:46:14'),
(66, 358, '103.148.52.242', 'Signin', '2025-03-17 04:05:57'),
(67, 360, '103.121.217.60', 'Signin', '2025-03-18 01:16:11'),
(68, 358, '103.148.52.242', 'Signin', '2025-03-18 05:39:32'),
(70, 362, '103.112.56.237', 'Signin', '2025-05-09 21:41:18'),
(71, 363, '103.67.65.97', 'Signin', '2025-05-09 21:45:17');
-- --------------------------------------------------------
--
-- Table structure for table `addons`
--
CREATE TABLE `addons` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(50) DEFAULT NULL,
`unique_identifier` varchar(50) DEFAULT NULL,
`version` varchar(50) DEFAULT NULL,
`price` decimal(10,3) NOT NULL DEFAULT 0.000,
`status` int(2) NOT NULL DEFAULT 1,
`image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `admin_activity_logs`
--
CREATE TABLE `admin_activity_logs` (
`id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`ip` varchar(50) NOT NULL,
`activity` text DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `admin_activity_logs`
--
INSERT INTO `admin_activity_logs` (`id`, `uid`, `ip`, `activity`, `created_at`, `deleted_at`) VALUES
(67, 1, '103.148.52.244', 'Login', '2025-03-11 04:08:52', NULL),
(68, 1, '103.148.52.244', 'Login', '2025-03-11 04:59:40', NULL),
(69, 1, '180.148.213.124', 'Login', '2025-03-11 08:24:54', NULL),
(70, 1, '180.148.213.124', 'The was created-admin@gmail.com', '2025-03-11 08:25:39', NULL),
(71, 1, '103.148.52.244', 'Login', '2025-03-11 20:06:39', NULL),
(72, 1, '103.148.52.244', 'Login', '2025-03-11 20:14:16', NULL),
(73, 1, '103.148.52.244', 'The was created-asfv@gmail.com', '2025-03-11 20:15:17', NULL),
(74, 1, '103.148.52.244', 'Bulk user delete', '2025-03-11 20:15:28', NULL),
(75, 1, '103.148.52.242', 'Login', '2025-03-16 20:27:41', NULL),
(76, 1, '103.16.226.153', 'Login', '2025-03-17 06:19:14', NULL),
(77, 1, '180.148.213.124', 'Login', '2025-03-17 15:20:19', NULL),
(78, 1, '37.111.206.195', 'Login', '2025-03-17 17:18:05', NULL),
(79, 1, '103.134.124.20', 'Login', '2025-03-17 17:49:06', NULL),
(80, 1, '37.111.206.195', 'Login', '2025-03-18 03:58:00', NULL),
(81, 1, '103.148.52.242', 'Login', '2025-03-18 05:37:50', NULL),
(82, 1, '103.112.56.237', 'Login', '2025-05-09 21:51:53', NULL),
(83, 1, '103.112.56.237', 'The was created-admin@gmail.com', '2025-05-09 21:52:37', NULL),
(84, 1, '42.0.6.228', 'Login', '2025-05-09 21:54:35', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `affiliates`
--
CREATE TABLE `affiliates` (
`id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`ref_id` int(10) UNSIGNED NOT NULL,
`amount` decimal(10,3) NOT NULL DEFAULT 0.000,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `bank_transaction_logs`
--
CREATE TABLE `bank_transaction_logs` (
`id` int(11) UNSIGNED NOT NULL,
`ids` text NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`brand_id` int(10) DEFAULT NULL,
`files` text DEFAULT NULL,
`type` varchar(10) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=pending,1=initiated,2=success,3=cancel',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `blogs`
--
CREATE TABLE `blogs` (
`id` int(10) UNSIGNED NOT NULL,
`ids` text DEFAULT NULL,
`thumbnail` text DEFAULT NULL,
`uri` text DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT 1,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `brands`
--
CREATE TABLE `brands` (
`id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`domain` text DEFAULT NULL,
`ip` text DEFAULT NULL,
`brand_name` varchar(30) DEFAULT NULL,
`brand_key` text DEFAULT NULL,
`brand_logo` text DEFAULT NULL,
`meta` text DEFAULT NULL,
`fees` decimal(10,3) NOT NULL DEFAULT 0.000,
`fees_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=flat,1=percent',
`currency` varchar(20) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=inactive,1=active',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `brands`
--
INSERT INTO `brands` (`id`, `uid`, `domain`, `ip`, `brand_name`, `brand_key`, `brand_logo`, `meta`, `fees`, `fees_type`, `currency`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(8, 1, 'bdbetterpay.com', '103.159.37.122', 'BD Better Pay', '8QFIJJNzDGGw1qmhdCJcK5xcvuh8PwRXviUfDlLatVhgkjXlZv', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1734967288_00c5211fea2e14b14555.jpg', '{\"mobile_number\":\"01711991935\",\"whatsapp_number\":\"01711991935\",\"support_mail\":\"tuktakpay@gmail.com\"}', 0.000, 0, NULL, 1, '2024-12-07 11:20:51', '2025-03-11 00:04:26', NULL),
(19, 358, 'hostreset.com', '103.148.52.244', 'Hostreset', 'fXB5o17G3eregnsoB266sxelC5qBZGysKo4emeNP9bAEknZf04', 'public/uploads/user/abf749051d8b000946c71a2e216e55eeb49cf414/1741702704_8bb04122ef73501a7879.png', '{\"mobile_number\":\"01710604946\",\"whatsapp_number\":\"01710604946\",\"support_mail\":\"info@hostreset.com\"}', 1.000, 0, NULL, 1, '2025-03-11 20:18:37', '2025-03-13 14:00:24', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `coupons`
--
CREATE TABLE `coupons` (
`id` int(11) UNSIGNED NOT NULL,
`code` varchar(191) NOT NULL,
`type` tinyint(4) NOT NULL,
`price` double NOT NULL,
`times` varchar(191) DEFAULT NULL,
`used` int(191) UNSIGNED NOT NULL DEFAULT 0,
`param` text NOT NULL,
`description` text DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT 1,
`start_date` date NOT NULL,
`end_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `devices`
--
CREATE TABLE `devices` (
`id` int(11) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`user_email` text NOT NULL,
`device_name` text NOT NULL,
`device_key` text NOT NULL,
`device_ip` text DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `devices`
--
INSERT INTO `devices` (`id`, `uid`, `user_email`, `device_name`, `device_key`, `device_ip`, `created_at`, `updated_at`, `deleted_at`) VALUES
(14, 1, 'admin@gmail.com', 'Relme8', 'fVSARTobNKvglddV9QhKlPFTsFcLUD884mmh1wjg', NULL, '2025-03-11 20:15:22', NULL, NULL),
(15, 358, 'bdbosstv@gmail.com', 'teste', 'hFKo7yB5Fg27PKLxT5hmi9xi1Wx3Zp6ZqPEm5zEh', '264c0fcca9e4a792', '2025-03-11 20:18:50', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `faqs`
--
CREATE TABLE `faqs` (
`id` int(11) UNSIGNED NOT NULL,
`question` text DEFAULT NULL,
`answer` longtext DEFAULT NULL,
`sort` int(11) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT 1,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Dumping data for table `faqs`
--
INSERT INTO `faqs` (`id`, `question`, `answer`, `sort`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'What is TukTak Pay', 'Tuktak Pay: Transforming Transactions through Technology\r\nTuktak Pay is a powerful yet easy to utilize digital solution created to streamline business exchanges. Leveraging individual accounts as gateways, it guarantees adaptability, protection, and simplicity of use. Here are the ways Tuktak Pay can change your operations:\r\nEffortless Customer Settlements:\r\nWith Tuktak Pay, enterprises can effortlessly approve installments specifically through their sites, improving client benefit. Its configurable settings support diverse payment options including recurring payments and subscriptions.\r\nProgrammatic Integration for Productivity:\r\nIncorporate Tuktak Pay\\\'s strong API into your framework for smooth exchange administration. Its flexible design interfaces seamlessly with a wide range of platforms to automate workflows and reconcile funds with minimal human intervention.\r\nSecurity You Can Depend On:\r\nEach exchange is encrypted and checked to give a sheltered condition, guaranteeing client trust and information honesty. Multi-factor authentication and automatic fraud detection further fortify the protection of sensitive consumer data.\r\nFor Organizations of All Sizes:\r\nWhether you\\\'re a small new company or a large association, Tuktak Pay changes as indicated by your needs, empowering development and making monetary cycles intuitive.\r\nBegin your excursion with Tuktak Pay and redesign how your business deals with installments.', 1, 1, '2024-12-18 22:29:47', '2024-12-18 22:29:47', NULL),
(2, 'Is TukTak Pay a Safe Option for Businesses ?', 'TukTak Pay: The Safe and Reliable Payment Option!\r\nTukTak Pay ensures every transaction is secured and reliable — making it a great choice for businesses needing the best financial protection. Here\\\'s why you can trust it :\r\nAdvanced Encryption Protocols\r\nTukTak Pay employs military-grade encryption to protect sensitive transactional data, maintaining the privacy of your customers.\r\nFraud Detection Systems\r\nScalable with integrated fraud detection, TukTak Pay identifies and blocks suspicious activities for the peace of mind of the business.\r\nInternational standard compliance\r\nTukTak Pay complies with international security frameworks, including PCI DSS, to ensure its compliance with industry standards for secure payment processing.\r\nIntegration without compromise with strong security\r\nTukTak Pay is user-friendly and easy to integrate, yet it still never sacrifices safety, helping businesses of all sizes.\r\nTukTak Pay caters the necessities of startups and enterprise businesses with an emphasis on security, efficiency, and reliability.', 2, 1, '2024-12-18 22:46:17', '2024-12-18 22:46:17', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `file_managers`
--
CREATE TABLE `file_managers` (
`id` int(9) NOT NULL,
`uid` int(11) DEFAULT NULL,
`file_name` varchar(255) NOT NULL,
`file_url` varchar(255) NOT NULL,
`file_type` varchar(100) NOT NULL,
`file_size` int(11) NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Dumping data for table `file_managers`
--
INSERT INTO `file_managers` (`id`, `uid`, `file_name`, `file_url`, `file_type`, `file_size`, `created_at`) VALUES
(2, 88, '1728398628_942e8c07e19cebba1673.jpg', 'public/uploads/user/b37f6ddcefad7e8657837d3177f9ef2462f98acf/1728398628_942e8c07e19cebba1673.jpg', 'image/jpeg', 103221, '2024-10-08 20:43:48'),
(3, 88, '1728398658_5e037cadedaa9ddc5395.jpg', 'public/uploads/user/b37f6ddcefad7e8657837d3177f9ef2462f98acf/1728398658_5e037cadedaa9ddc5395.jpg', 'image/jpeg', 10263, '2024-10-08 20:44:18'),
(4, 0, '1728399479_b7d73f35726d9e4310b5.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1728399479_b7d73f35726d9e4310b5.png', 'image/png', 80596, '2024-10-08 20:57:59'),
(5, 0, '1728399488_b64c3407b15836b97fd5.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1728399488_b64c3407b15836b97fd5.png', 'image/png', 102502, '2024-10-08 20:58:08'),
(6, 0, '1728399559_9cd8914214b745521876.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1728399559_9cd8914214b745521876.png', 'image/png', 80596, '2024-10-08 20:59:19'),
(7, 0, '1728399564_a0c7c02fd5a00d7ad426.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1728399564_a0c7c02fd5a00d7ad426.png', 'image/png', 80596, '2024-10-08 20:59:24'),
(8, 6, '1728400816_efcb28e5a8242c8caa78.png', 'public/uploads/user/c1dfd96eea8cc2b62785275bca38ac261256e278/1728400816_efcb28e5a8242c8caa78.png', 'image/png', 80596, '2024-10-08 21:20:16'),
(9, 1, '1728403939_dfba68933fe40076ad85.jpg', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1728403939_dfba68933fe40076ad85.jpg', 'image/jpeg', 14158, '2024-10-08 22:12:19'),
(10, 0, '1728409631_b500be3dd669fbf6579e.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1728409631_b500be3dd669fbf6579e.png', 'image/png', 80596, '2024-10-08 23:47:11'),
(11, 0, '1728410037_9239d6c1bae86f22c973.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1728410037_9239d6c1bae86f22c973.png', 'image/png', 80596, '2024-10-08 23:53:57'),
(12, 6, '1728459782_00c5b6202549db3b7ba4.jpg', 'public/uploads/user/c1dfd96eea8cc2b62785275bca38ac261256e278/1728459782_00c5b6202549db3b7ba4.jpg', 'image/jpeg', 39655, '2024-10-09 13:43:02'),
(13, 179, '1728478783_ac6316caf55f369ce3ca.jpeg', 'public/uploads/user/9e44d2771c052d44058245eda6cb334689ca78cc/1728478783_ac6316caf55f369ce3ca.jpeg', 'image/jpeg', 7603, '2024-10-09 18:59:43'),
(14, 185, '1728496161_d0d07ad08a7d6af8a376.jpg', 'public/uploads/user/cfa2ed2aac6d61f44ca9cba73e1e8946b7cd7d22/1728496161_d0d07ad08a7d6af8a376.jpg', 'image/jpeg', 46179, '2024-10-09 23:49:21'),
(15, 185, '1728496198_3630522c5e47f2c5d0ae.png', 'public/uploads/user/cfa2ed2aac6d61f44ca9cba73e1e8946b7cd7d22/1728496198_3630522c5e47f2c5d0ae.png', 'image/png', 12578, '2024-10-09 23:49:58'),
(16, 185, '1728496406_66492203136fe6c36375.jpg', 'public/uploads/user/cfa2ed2aac6d61f44ca9cba73e1e8946b7cd7d22/1728496406_66492203136fe6c36375.jpg', 'image/jpeg', 17945, '2024-10-09 23:53:26'),
(17, 88, '1728625532_c736bb50a36ff775b6b3.jpg', 'public/uploads/user/b37f6ddcefad7e8657837d3177f9ef2462f98acf/1728625532_c736bb50a36ff775b6b3.jpg', 'image/jpeg', 9848, '2024-10-11 11:45:32'),
(18, 294, '1728912198_9b860d2f3c72bd2ba023.png', 'public/uploads/user/3a085d1bc5fa41313c4e0910e7341af761b0f7db/1728912198_9b860d2f3c72bd2ba023.png', 'image/png', 14217, '2024-10-14 19:23:18'),
(19, 294, '1728912321_ca1ae7710241735b3281.png', 'public/uploads/user/3a085d1bc5fa41313c4e0910e7341af761b0f7db/1728912321_ca1ae7710241735b3281.png', 'image/png', 14217, '2024-10-14 19:25:21'),
(20, 88, '1729093736_5fc766c9b99212298c52.png', 'public/uploads/user/b37f6ddcefad7e8657837d3177f9ef2462f98acf/1729093736_5fc766c9b99212298c52.png', 'image/png', 14217, '2024-10-16 21:48:56'),
(21, 88, '1729093831_fa933efbff64b7e36225.png', 'public/uploads/user/b37f6ddcefad7e8657837d3177f9ef2462f98acf/1729093831_fa933efbff64b7e36225.png', 'image/png', 14217, '2024-10-16 21:50:31'),
(22, 295, '1729094239_8e2d65a6eb177299cf19.png', 'public/uploads/user/a02b857f2eff73e8e188f35529dd91f8144b23b9/1729094239_8e2d65a6eb177299cf19.png', 'image/png', 353311, '2024-10-16 21:57:19'),
(23, 295, '1729094469_32a8993e4621be4b1de4.png', 'public/uploads/user/a02b857f2eff73e8e188f35529dd91f8144b23b9/1729094469_32a8993e4621be4b1de4.png', 'image/png', 14217, '2024-10-16 22:01:09'),
(24, 298, '1729386388_9d7da5a470559431441d.jpg', 'public/uploads/user/eb65e208b715d3b42fc535aebcd8d3e7fb5f2c94/1729386388_9d7da5a470559431441d.jpg', 'image/jpeg', 125565, '2024-10-20 07:06:28'),
(25, 300, '1729618566_ebbbf94a1463ae0457c8.png', 'public/uploads/user/e26973e6ee8ab9cd8cb3f207d1b90f00d2669eff/1729618566_ebbbf94a1463ae0457c8.png', 'image/png', 405464, '2024-10-22 23:36:06'),
(26, 0, '1730479999_b87e7dfe94351beeb59e.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1730479999_b87e7dfe94351beeb59e.jpg', 'image/jpeg', 14158, '2024-11-01 22:53:19'),
(27, 0, '1730480029_aa524a469f5d2c7b0c86.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1730480029_aa524a469f5d2c7b0c86.jpg', 'image/jpeg', 14158, '2024-11-01 22:53:49'),
(28, 1, '1730595824_0af2130ffb3c7e904904.png', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1730595824_0af2130ffb3c7e904904.png', 'image/png', 80596, '2024-11-03 07:03:44'),
(29, 0, '1732982962_ab1f3d84fa63112c3ca6.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1732982962_ab1f3d84fa63112c3ca6.png', 'image/png', 5774, '2024-11-30 22:09:22'),
(30, 0, '1732982998_9ce2a923f99cd8fc2195.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1732982998_9ce2a923f99cd8fc2195.png', 'image/png', 5774, '2024-11-30 22:09:58'),
(31, 0, '1733031584_41825073b1b771dca6c4.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1733031584_41825073b1b771dca6c4.png', 'image/png', 9299, '2024-12-01 11:39:44'),
(32, 0, '1733031830_6e41fa51d1d9b0bcd847.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1733031830_6e41fa51d1d9b0bcd847.png', 'image/png', 76912, '2024-12-01 11:43:50'),
(33, 0, '1733031856_50b153c4d9ae66b5a156.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1733031856_50b153c4d9ae66b5a156.png', 'image/png', 76912, '2024-12-01 11:44:16'),
(34, 0, '1733031863_d0f67e662a5079f004eb.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1733031863_d0f67e662a5079f004eb.png', 'image/png', 9299, '2024-12-01 11:44:23'),
(35, 0, '1733114332_81e7abc3de6e2f6ae2b0.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1733114332_81e7abc3de6e2f6ae2b0.png', 'image/png', 34218, '2024-12-02 10:38:52'),
(36, 1, '1733208458_d74f2aea85f7ca40742d.png', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1733208458_d74f2aea85f7ca40742d.png', 'image/png', 34218, '2024-12-03 12:47:38'),
(37, 305, '1733548847_ac6a1016655add94c3fa.png', 'public/uploads/user/9a3d6127374af09c22015bf3ede3ac00a36e3ec6/1733548847_ac6a1016655add94c3fa.png', 'image/png', 76912, '2024-12-07 11:20:47'),
(38, 1, '1734176170_0f063d499294a3f1e5ac.png', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1734176170_0f063d499294a3f1e5ac.png', 'image/png', 4190, '2024-12-14 17:36:10'),
(39, 1, '1734176397_89fe00dfab5b71abc250.png', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1734176397_89fe00dfab5b71abc250.png', 'image/png', 6974, '2024-12-14 17:39:57'),
(40, 0, '1734517490_3e85a09031251cde25cc.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734517490_3e85a09031251cde25cc.jpg', 'image/jpeg', 11813, '2024-12-18 16:24:50'),
(41, 0, '1734517520_ce360fd376246a408ee2.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734517520_ce360fd376246a408ee2.jpg', 'image/jpeg', 11813, '2024-12-18 16:25:20'),
(42, 0, '1734518091_54e0507c3f49114cec5c.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734518091_54e0507c3f49114cec5c.jpg', 'image/jpeg', 22993, '2024-12-18 16:34:51'),
(43, 0, '1734518168_ace641b4ec9c9209f648.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734518168_ace641b4ec9c9209f648.png', 'image/png', 47608, '2024-12-18 16:36:08'),
(44, 0, '1734518179_cd2492593a529e11a746.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734518179_cd2492593a529e11a746.jpg', 'image/jpeg', 17921, '2024-12-18 16:36:19'),
(45, 0, '1734519128_69d5a090b9b3df244e02.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734519128_69d5a090b9b3df244e02.jpg', 'image/jpeg', 17921, '2024-12-18 16:52:08'),
(46, 0, '1734519891_d9639631de1634bf18bc.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734519891_d9639631de1634bf18bc.png', 'image/png', 47608, '2024-12-18 17:04:51'),
(47, 340, '1734542607_1ab17fcc7244e31abc31.jpg', 'public/uploads/user/3e6bf6c89ba8a8b8b189f85975b0fab42bdc6d4a/1734542607_1ab17fcc7244e31abc31.jpg', 'image/jpeg', 69631, '2024-12-18 23:23:27'),
(48, 340, '1734542972_2d014fde6f86d13e69b0.png', 'public/uploads/user/3e6bf6c89ba8a8b8b189f85975b0fab42bdc6d4a/1734542972_2d014fde6f86d13e69b0.png', 'image/png', 315707, '2024-12-18 23:29:33'),
(49, 0, '1734614289_262d9fd2c01e2ebc4719.jpg', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734614289_262d9fd2c01e2ebc4719.jpg', 'image/jpeg', 17433, '2024-12-19 19:18:09'),
(50, 0, '1734614395_c0c3762ef72a251de9e6.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734614395_c0c3762ef72a251de9e6.png', 'image/png', 53445, '2024-12-19 19:19:55'),
(51, 340, '1734937992_329284fb1bf938ea2987.png', 'public/uploads/user/3e6bf6c89ba8a8b8b189f85975b0fab42bdc6d4a/1734937992_329284fb1bf938ea2987.png', 'image/png', 18841, '2024-12-23 13:13:12'),
(52, 340, '1734938769_a6de23117d04d5c4f0ec.png', 'public/uploads/user/3e6bf6c89ba8a8b8b189f85975b0fab42bdc6d4a/1734938769_a6de23117d04d5c4f0ec.png', 'image/png', 18841, '2024-12-23 13:26:09'),
(53, 0, '1734947867_4e920b1c6db0a27cf27a.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734947867_4e920b1c6db0a27cf27a.png', 'image/png', 121805, '2024-12-23 15:57:47'),
(54, 1, '1734967288_00c5211fea2e14b14555.jpg', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1734967288_00c5211fea2e14b14555.jpg', 'image/jpeg', 11375, '2024-12-23 21:21:28'),
(55, 1, '1734967698_8eb8fbaa63941124dc8e.jpg', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1734967698_8eb8fbaa63941124dc8e.jpg', 'image/jpeg', 55107, '2024-12-23 21:28:18'),
(56, 341, '1735011486_4801ce974c04db55cb75.jpg', 'public/uploads/user/8da4dabfaeb4a44681c9777c85db39140e3e12e6/1735011486_4801ce974c04db55cb75.jpg', 'image/jpeg', 15878, '2024-12-24 09:38:06'),
(57, 343, '1735013786_0cc23734a29f647625ba.jpg', 'public/uploads/user/25a5e3012854728e0c6ab97fdcbb65c3a00c0965/1735013786_0cc23734a29f647625ba.jpg', 'image/jpeg', 68916, '2024-12-24 10:16:26'),
(58, 343, '1735034795_4e4dddbf25a737e06538.jpg', 'public/uploads/user/25a5e3012854728e0c6ab97fdcbb65c3a00c0965/1735034795_4e4dddbf25a737e06538.jpg', 'image/jpeg', 55107, '2024-12-24 16:06:35'),
(59, 344, '1735091568_9970f2d6c58fe5ba9c4e.jpg', 'public/uploads/user/640bacfb48aefac1f91028c01603e5c78d4f63ca/1735091568_9970f2d6c58fe5ba9c4e.jpg', 'image/jpeg', 64520, '2024-12-25 07:52:48'),
(60, 345, '1735100654_556d77316b63cdccf145.jpg', 'public/uploads/user/35139ef894b28b73bea022755166a23933c7d9cb/1735100654_556d77316b63cdccf145.jpg', 'image/jpeg', 55107, '2024-12-25 10:24:14'),
(61, 344, '1735120914_d1a3a6585c0af53167e9.jpg', 'public/uploads/user/640bacfb48aefac1f91028c01603e5c78d4f63ca/1735120914_d1a3a6585c0af53167e9.jpg', 'image/jpeg', 64520, '2024-12-25 16:01:54'),
(62, 344, '1735121112_56db2aed8e2e08edfe31.jpg', 'public/uploads/user/640bacfb48aefac1f91028c01603e5c78d4f63ca/1735121112_56db2aed8e2e08edfe31.jpg', 'image/jpeg', 64520, '2024-12-25 16:05:12'),
(63, 309, '1735189800_9eb8731cad43175badc8.jpg', 'public/uploads/user/ed2efc1c05342a60c2198a5e96773a237008956b/1735189800_9eb8731cad43175badc8.jpg', 'image/jpeg', 149719, '2024-12-26 11:10:00'),
(64, 351, '1735458685_c0889c215fe1b81901a9.png', 'public/uploads/user/0026476a20bfbd08714155bb66f0b4feb2d25c1c/1735458685_c0889c215fe1b81901a9.png', 'image/png', 53269, '2024-12-29 13:51:25'),
(65, 352, '1735568726_c731b945f81cc65167a0.png', 'public/uploads/user/efbc0848b836a9de4b0c18c93ec052d87647fb06/1735568726_c731b945f81cc65167a0.png', 'image/png', 19341, '2024-12-30 20:25:26'),
(66, 309, '1735835221_52dd0ee3e1252e277692.jpg', 'public/uploads/user/ed2efc1c05342a60c2198a5e96773a237008956b/1735835221_52dd0ee3e1252e277692.jpg', 'image/jpeg', 68306, '2025-01-02 22:27:01'),
(67, 358, '1741702704_8bb04122ef73501a7879.png', 'public/uploads/user/abf749051d8b000946c71a2e216e55eeb49cf414/1741702704_8bb04122ef73501a7879.png', 'image/png', 390361, '2025-03-11 20:18:25'),
(68, 1, '1746806013_f5bd82cfd5cec3190852.png', 'public/uploads/user/356a192b7913b04c54574d18c28d46e6395428ab/1746806013_f5bd82cfd5cec3190852.png', 'image/png', 8337, '2025-05-09 21:53:33'),
(69, 0, '1746806453_631eb05aa9d55be8506e.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1746806453_631eb05aa9d55be8506e.png', 'image/png', 8337, '2025-05-09 22:00:53'),
(70, 0, '1746806477_ff79c3408aab1c2f22f0.png', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1746806477_ff79c3408aab1c2f22f0.png', 'image/png', 8337, '2025-05-09 22:01:17');
-- --------------------------------------------------------
--
-- Table structure for table `invoice`
--
CREATE TABLE `invoice` (
`id` int(11) UNSIGNED NOT NULL,
`ids` text NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`customer_name` text NOT NULL,
`customer_number` text DEFAULT NULL,
`customer_amount` text NOT NULL,
`customer_email` text NOT NULL,
`customer_address` text NOT NULL,
`customer_description` text DEFAULT NULL,
`status` int(11) NOT NULL,
`pay_status` int(4) NOT NULL,
`brand_id` text DEFAULT NULL,
`transaction_id` text DEFAULT NULL,
`extras` text DEFAULT NULL,
`created_at` text DEFAULT NULL,
`deleted_at` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `invoice`
--
INSERT INTO `invoice` (`id`, `ids`, `uid`, `customer_name`, `customer_number`, `customer_amount`, `customer_email`, `customer_address`, `customer_description`, `status`, `pay_status`, `brand_id`, `transaction_id`, `extras`, `created_at`, `deleted_at`) VALUES
(17, '9547f957938e1166cc015eb3d91e9db8', 358, 'AAA', '01710604946', '777', 'a@app.com', 'asdasd', 'dsfdsfs', 1, 0, '19', NULL, NULL, '2025-03-18 05:41:43', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `kyc`
--
CREATE TABLE `kyc` (
`id` int(11) UNSIGNED NOT NULL,
`ids` text NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`params` text DEFAULT NULL,
`status` int(2) NOT NULL DEFAULT 0,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` bigint(20) UNSIGNED NOT NULL,
`version` varchar(255) NOT NULL,
`class` varchar(255) NOT NULL,
`group` varchar(255) NOT NULL,
`namespace` varchar(255) NOT NULL,
`time` int(11) NOT NULL,
`batch` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2023-12-23-055313', 'Modules\\Blocks\\Database\\Migrations\\Queue', 'default', 'Blocks', 1733164861, 1),
(2, '2023-12-23-055313', 'Modules\\Home\\Database\\Migrations\\Settings', 'default', 'Home', 1733164862, 2),
(3, '2023-12-26-040632', 'Modules\\Home\\Database\\Migrations\\FileManager', 'default', 'Home', 1733164862, 2),
(4, '2023-12-27-012628', 'Modules\\Home\\Database\\Migrations\\Payments', 'default', 'Home', 1733164862, 2),
(5, '2024-04-30-042916', 'Modules\\Home\\Database\\Migrations\\Blogs', 'default', 'Home', 1733164862, 2),
(6, '2024-05-15-153103', 'Modules\\Home\\Database\\Migrations\\Addons', 'default', 'Home', 1733164862, 2);
-- --------------------------------------------------------
--
-- Table structure for table `module_data`
--
CREATE TABLE `module_data` (
`id` int(10) UNSIGNED NOT NULL,
`tmp_id` text DEFAULT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`message` text DEFAULT NULL,
`address` text DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=pending,1=success',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `module_data`
--
INSERT INTO `module_data` (`id`, `tmp_id`, `uid`, `message`, `address`, `status`, `created_at`, `updated_at`) VALUES
(15, NULL, 358, 'You have received payment Tk 1,500.00 from 01329503432. Fee Tk 0.00. Balance Tk 1,506.40. TrxID CCE6L9KZ74 at 14/03/2025 20:27', 'bKash', 0, '2025-03-14 20:27:21', NULL),
(16, NULL, 358, 'You have received payment Tk 20.00 from 01783632964. Fee Tk 0.00. Balance Tk 1,526.40. TrxID CCE8LAW19U at 14/03/2025 21:13', 'bKash', 0, '2025-03-14 21:13:41', NULL),
(17, NULL, 358, 'TK 1,500.00 credited to A/C#10531**0001 on 14-03-25 @09:15 PM from OTHER BANK. Balance TK 4,047.24. BRAC Bank.', 'BRAC-BANK', 0, '2025-03-14 21:16:05', NULL),
(18, NULL, 358, 'আজকের অফার ৮০মিনিট ৫৫টাকা ৩০দিন ডায়াল *১২১*৩২০৪# https://mygp.li/oS3', 'GP80MIN55TK', 0, '2025-03-15 09:46:39', NULL),
(19, NULL, 358, 'আজ ৪জিবি ৯০টাকা ৭দিন। ডায়াল *১২১*৫৪৫০# বা https://mygp.li/Rt', 'GP4GB90TK7D', 0, '2025-03-15 10:08:09', NULL),
(20, NULL, 358, 'আজকের অফার! ৮জিবি ১০০টাকা ৩০দিন (১বার)! *১২১*৫০৭১# https://mygp.li/o9', 'GP8GB100TK', 0, '2025-03-15 12:50:30', NULL),
(21, NULL, 358, 'আজ ২জিবি ৪০টাকা ৭দিন। ডায়াল *১২১*৫১৮২# বা https://mygp.li/Xb', 'GP 2GB40TK', 0, '2025-03-16 08:17:39', NULL),
(22, NULL, 358, '৩৫৮টাকা ১৫জিবি+৩০০মিনিট ৩০দিন,ডায়াল *১২১*৫৩৫৮# বা https://mygp.li/3N8', 'GP Bundle', 0, '2025-03-16 11:45:41', NULL),
(23, NULL, 358, 'আজকের অফার! ৮জিবি ১০০টাকা ৩০দিন (১বার)! *১২১*৫০৭১# https://mygp.li/o9', 'GP8GB100TK', 0, '2025-03-16 12:36:25', NULL),
(24, NULL, 358, 'You have received payment Tk 2,000.00 from 01674962416. Fee Tk 0.00. Balance Tk 2,005.55. TrxID CCG1MIY18N at 16/03/2025 14:00', 'bKash', 0, '2025-03-16 14:00:44', NULL),
(25, NULL, 358, '৪জিবি + ১২৫মিনিট ১২৫ টাকা-৭দিন,ডায়াল *১২১*৫৫০৮# বা https://mygp.li/8M', 'GP Bundle', 0, '2025-03-17 09:50:08', NULL),
(26, NULL, 358, 'আজ ৪জিবি ৯০টাকা ৭দিন। ডায়াল *১২১*৫৪৫০# বা https://mygp.li/Rt', 'GP4GB90TK7D', 0, '2025-03-17 09:50:10', NULL),
(27, NULL, 358, 'আজকের অফার! ৮জিবি ১০০টাকা ৩০দিন (১বার)! *১২১*৫০৭১# https://mygp.li/o9', 'GP8GB100TK', 0, '2025-03-17 11:37:38', NULL),
(28, NULL, 358, 'TK 690.00 has been credited to your A/C# 10531**0001 on 17-03-25. Your A/C balance is TK 4,737.24. For Enquiry call: 16221', 'BRAC-BANK', 0, '2025-03-17 13:48:46', NULL),
(29, NULL, 358, 'TK 5,000.00 has been deposited to A/C#10531**0001 on 17-03-25 @01:53 PM at NARAYANGANJ CRM NARAYANGONJ BD. Balance TK 9,737.24. BRAC Bank.', 'BRAC-BANK', 0, '2025-03-17 13:53:15', NULL),
(30, NULL, 358, 'আপনি উপভোগ করছেন ১পয়সা/সেকেন্ড কলরেট, মেয়াদ ২৩ মার্চ ‘২৫ পর্যন্ত', 'GP1Poisha', 0, '2025-03-17 17:23:05', NULL),
(31, NULL, 358, 'TK 3,000.00 credited to A/C#10531**0001 on 17-03-25 @08:36 PM from OTHER BANK. Balance TK 12,737.24. BRAC Bank.', 'BRAC-BANK', 0, '2025-03-17 20:36:56', NULL),
(32, NULL, 358, 'You have received Tk 1,500.00 from M A supershopbd_01645007201 01645007201. Ref . Fee Tk 0.00. Balance Tk 3,505.55. TrxID CCH8NT2TIC at 17/03/2025 22:35', 'bKash', 0, '2025-03-17 22:35:59', NULL),
(33, NULL, 358, 'You have received payment Tk 1,400.00 from 01674962416. Ref bdpaymentgateway and sohelrasel. Fee Tk 0.00. Balance Tk 4,905.55. TrxID CCH9NTW41P at 17/03/2025 23:10', 'bKash', 0, '2025-03-17 23:10:10', NULL),
(34, NULL, 358, 'Send Money Tk 1,000.00 to 01969176234 successful. Ref . Fee Tk 5.00. Balance Tk 3,900.55. TrxID CCI6NWT2K0 at 18/03/2025 04:37', 'bKash', 0, '2025-03-18 04:38:02', NULL),
(35, NULL, 358, 'Cash Out Tk 1,256.30 to Habibur Telecom And Store_01323775746 01323775746 successful. Fee Tk 18.72. Balance Tk 2,625.53. TrxID CCI9O02Y6D at 18/03/2025 09:46', 'bKash', 0, '2025-03-18 09:46:56', NULL),
(36, NULL, 358, 'Merchant Payment Tk 1,938.00 to Ofaex It Solutions_01869430242 01869430242 successful. Ref . Fee Tk 3.88. Balance Tk 683.65. TrxID CCI0O173QE at 18/03/2025 10:23', 'bKash', 0, '2025-03-18 10:23:30', NULL),
(37, NULL, 358, 'আজকের অফার! ৮জিবি ১০০টাকা ৩০দিন (১বার)! *১২১*৫০৭১# https://mygp.li/o9', 'GP8GB100TK', 0, '2025-03-18 11:01:22', NULL),
(38, NULL, 358, '৩৫৮টাকা ১৫জিবি+৩০০মিনিট ৩০দিন,ডায়াল *১২১*৫৩৫৮# বা https://mygp.li/3N8', 'GP Bundle', 0, '2025-03-18 11:50:41', NULL),
(39, NULL, 358, 'আজকের অফার ৮০মিনিট ৫৫টাকা ৩০দিন ডায়াল *১২১*৩২০৪# https://mygp.li/oS3', 'GP80MIN55TK', 0, '2025-03-18 11:56:46', NULL),
(40, NULL, 358, 'আজ ২জিবি ৪০টাকা ৭দিন। ডায়াল *১২১*৫১৮২# বা https://mygp.li/Xb', 'GP 2GB40TK', 0, '2025-03-18 11:56:47', NULL),
(41, NULL, 358, 'You have received payment Tk 900.00 from 01674962416. Fee Tk 0.00. Balance Tk 1,583.65. TrxID CCI2O8HX6Y at 18/03/2025 13:47', 'bKash', 0, '2025-03-18 13:47:41', NULL),
(42, NULL, 358, 'Dear MD Leon Islam, Your invoice #(invoiceid) was due on 17.03.2025 and is now overdue. Please make the payment at your earliest convenience to avoid service disruption. – HPLink DC Let me know if you need any modifications! ????HPL DC', '+8809601003407', 0, '2025-03-18 15:00:35', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE `notifications` (
`id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`message` text NOT NULL,
`is_read` tinyint(1) NOT NULL DEFAULT 0,
`admin_status` tinyint(1) NOT NULL DEFAULT 1,
`is_admin_read` tinyint(1) NOT NULL DEFAULT 0,
`created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `notifications`
--
INSERT INTO `notifications` (`id`, `uid`, `message`, `is_read`, `admin_status`, `is_admin_read`, `created_at`) VALUES
(2, 357, 'Hi,Asdfgh, your account is Updated by an Admin', 0, 0, 0, '2025-03-11 20:15:17'),
(3, 358, 'Hi,MD Leon, your account is created Successfully', 0, 0, 0, '2025-03-11 20:16:53'),
(4, 359, 'Hi,Nannu Islam, your account is created Successfully', 0, 0, 0, '2025-03-13 20:38:25'),
(5, 360, 'Hi,Swadhin, your account is created Successfully', 0, 0, 0, '2025-03-18 01:16:11'),
(7, 362, 'Hi,Md Rakibul, your account is created Successfully', 0, 0, 0, '2025-05-09 21:41:18'),
(8, 363, 'Hi,RP DEVELOPER, your account is created Successfully', 0, 0, 0, '2025-05-09 21:45:17'),
(9, 1, 'Hi,R Lab BD, your account is Updated by an Admin', 0, 0, 0, '2025-05-09 21:52:37');
-- --------------------------------------------------------
--
-- Table structure for table `options`
--
CREATE TABLE `options` (
`id` int(9) NOT NULL,
`name` text DEFAULT NULL,
`value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Dumping data for table `options`
--
INSERT INTO `options` (`id`, `name`, `value`) VALUES
(1, 'is_maintenance_mode', '0'),
(2, 'site_title', 'bdbetterpay.com'),
(3, 'site_description', 'bdbetterpay.com is your one-stop platform for seamless and secure payment automation. We specialise in streamlining payment processes for businesses and individuals, offering features like recurring billing, real-time transaction tracking, and integration with multiple payment gateways. With a focus on efficiency and user-friendliness, Auto Pay Solution ensures your payments are handled effortlessly, giving you more time to focus on growth. Experience the convenience of automated payments with our cutting-edge technology and reliable customer support.'),
(4, 'site_keywords', 'bdbetterpay.com'),
(5, 'site_icon', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734947867_4e920b1c6db0a27cf27a.png'),
(6, 'site_name', 'bdbetterpay.com'),
(7, 'default_limit_per_page', '40'),
(8, 'currency_decimal', '2'),
(9, 'currency_decimal_separator', 'dot'),
(10, 'currency_thousand_separator', 'comma'),
(11, 'currency_symbol', '৳'),
(12, 'maintenance_mode_time', '2024-06-02T20:31'),
(13, 'enable_https', '1'),
(14, 'optimize', '1'),
(15, 'address', 'Jigatola, Dhanmondi, Dhaka'),
(16, 'social_github_link', '#'),
(17, 'social_facebook_link', 'https://www.facebook.com/'),
(18, 'social_instagram_link', '#'),
(19, 'social_pinterest_link', '#'),
(20, 'social_twitter_link', '#'),
(21, 'social_tumblr_link', ''),
(22, 'social_youtube_link', '#'),
(23, 'contact_tel', '+8801783632964(WhatsApp)'),
(24, 'contact_email', 'tuktakpay@gmail.com'),
(25, 'contact_work_hour', 'Sat-Thu 09 am - 10 pm'),
(26, 'copy_right_content', 'BDBetterPay'),
(27, 'update_file', '1'),
(28, 'honeypot', ''),
(29, 'site_logo', 'public/uploads/admin/356a192b7913b04c54574d18c28d46e6395428ab/1734614395_c0c3762ef72a251de9e6.png'),
(30, 'is_clear_ticket', '0'),
(31, 'default_clear_ticket_days', '30'),
(32, 'default_pending_ticket_per_user', '0'),
(33, 'enable_notification_popup', '0'),
(34, 'notification_popup_content', 'টুকটাক পে তে আপনাকে স্বাগত জানাই।
টুকটাক পে সম্পর্কিত সমস্যা ও সম্ভাবনা জানান আমাদের-
fb.com/tuktakpay
Telegram: t.me/paytuktak
\r\nধন্যবাদ
টুকটাক পে টিম
'),
(35, 'enable_panel_notification_popup', '0'),
(36, 'notification_popup_panel_content', 'টুকটাক পে তে আপনাকে স্বাগত জানাই।
টুকটাক পে সম্পর্কিত সমস্যা ও সম্ভাবনা জানান আমাদের-
fb.com/tuktakpay
Telegram: t.me/paytuktak
\r\nধন্যবাদ
টুকটাক পে টিম
'),
(37, 'is_verification_new_account', '0'),
(38, 'is_welcome_email', '0'),
(39, 'is_new_user_email', '0'),
(40, 'email_welcome_email_subject', 'Welcome To Our site'),
(41, 'enable_notification', '1'),
(42, 'email_from', 'support@tuktakpay.com'),
(43, 'email_name', 'TukTak Pay'),
(44, 'email_protocol_type', 'php_mail'),
(45, 'is_addfund_bonus', '0'),
(46, 'is_plan_bonus', '0'),
(47, 'is_signup_bonus', '0'),
(48, 'signup_bonus_amount', '0'),
(49, 'affiliate_bonus_type', ''),
(50, 'affiliate_bonus', '0'),
(51, 'min_affiliate_amount', '0'),
(52, 'max_affiliate_time', '0'),
(53, 'currency_code', 'BDT'),
(54, 'auto_rounding_x_decimal_places', '2'),
(55, 'is_auto_currency_convert', '0'),
(56, 'new_currecry_rate', '1'),
(57, 'policy_content', ''),
(58, 'embed_head_javascript', '<!-- Google tag (gtag.js) -->\r\n<script async src="https://www.googletagmanager.com/gtag/js?id=G-Y94EHHD0L5"></script>\r\n<script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-Y94EHHD0L5');\r\n</script>\r\n<div id="myAliceWebChatWA"></div>\r\n<!-- Telegram Button -->\r\n<div id="myAliceWebChatTG"></div>\r\n<script>\r\n!function(){ var e, t, n, a; if (!window.MyAliceWebChat) { (t = document.createElement("div")).id = "myAliceWebChatLoader", (n = document.createElement("script")).type = "text/javascript", n.async = !0, n.src = "https://widget.myalice.ai/index.js", (a = (e = document.body.getElementsByTagName("script"))[e.length - 1]).parentNode.insertBefore(n, a), a.parentNode.insertBefore(t, a), n.addEventListener("load", (function(){ // WhatsApp Button MyAliceWebChat.init({ selector: "myAliceWebChatWA", number: "+88001625970780", message: "আসসালাইমুয়ালাইকুম", color: "#25D366", channel: "wa", boxShadow: "none", text: "Whatsapp", theme: "light", position: "left", mb: "15px", mx: "20px", radius: "20px" }); // Telegram Button MyAliceWebChat.init({ selector: "myAliceWebChatTG", number: "nagorikpay", message: "", color: "#2AABEE", channel: "tg", boxShadow: "none", text: "Telegram", theme: "light", position: "left", mt: "40px", // Top margin mb: "70px", // Bottom margin mx: "20px", radius: "20px" }); })); }\r\n}();\r\n</script>'),
(59, 'embed_javascript', ''),
(60, 'is_payment_notice_email', '0'),
(61, 'is_ticket_notice_email', '0'),
(62, 'is_ticket_notice_email_admin', '0'),
(63, 'is_order_notice_email', '0'),
(64, 'smtp_server', ''),
(65, 'smtp_port', '587'),
(66, 'smtp_encryption', 'tls'),
(67, 'smtp_username', ''),
(68, 'smtp_password', ''),
(69, 'limit_per_page', '10'),
(70, 'terms_content', ''),
(71, 'enable_all_user', '1'),
(72, 'enable_database_cache', '1'),
(73, 'enable_tickets', '1'),
(74, 'affiliate_level', '4'),
(75, 'verification_email_subject', '{{website_name}} - Please validate your account'),
(76, 'verification_email_content', 'Welcome to {{website_name}}!
\r\nHello {{first_name}}!
\r\n Thank you for joining! We\'re glad to have you as community member, and we\'re stocked for you to start exploring our service. If you don\'t verify your address, you won\'t be able to create a User Account.
\r\n All you need to do is activate your account by click this link:
{{activation_link}}
\r\nThanks and Best Regards!
'),
(77, 'email_welcome_email_content', 'Welcome to {{website_name}}!
\r\nHello {{first_name}}!
\r\nCongratulations!
You have successfully signed up for our service - {{website_name}} with follow data
\r\n\r\n- Firstname: {{first_name}}
\r\n- Lastname: {{last_name}}
\r\n- Email: {{email}}
\r\n- Timezone: {{user_timezone}}
\r\n
\r\nWe want to exceed your expectations, so please do not hesitate to reach out at any time if you have any questions or concerns. We look to working with you.
\r\nBest Regards,
'),
(78, 'email_new_registration_subject', '{{website_name}} - New Registration'),
(79, 'email_new_registration_content', 'Hi Admin!
\r\nSomeone signed up in {{website_name}} with follow data
\r\n\r\n- Firstname {{first_name}}
\r\n- Lastname: {{last_name}}
\r\n- Email: {{email}}
\r\n- Timezone: {{user_timezone}}
\r\n
'),
(80, 'email_password_recovery_subject', '{{website_name}} - Password Recovery'),
(81, 'email_password_recovery_content', 'Hi {{first_name}}!
\r\nSomebody (hopefully you) requested a new password for your account.
\r\nNo changes have been made to your account yet.
You can reset your password by click this link:
{{recovery_password_link}}
\r\nIf you did not request a password reset, no further action is required.
\r\nThanks and Best Regards!
'),
(82, 'admin_email_password_recovery_subject', '{{website_name}} - Password Recovery'),
(83, 'admin_email_password_recovery_content', 'Hi {{first_name}}!
\r\nSomebody (hopefully you) requested a new password for your account.
\r\nNo changes have been made to your account yet.
You can reset your password by click this link:
{{admin_recovery_password_link}}
\r\nIf you did not request a password reset, no further action is required.
\r\nThanks and Best Regards!
'),
(84, 'email_payment_notice_subject', '{{website_name}} - Thank You! Deposit Payment Received'),
(85, 'email_payment_notice_content', 'Hi {{first_name}}!
\r\nWe\'ve just received your final remittance and would like to thank you. We appreciate your diligence in adding funds to your balance in our service.
\r\nIt has been a pleasure doing business with you. We wish you the best of luck.
\r\nThanks and Best Regards!
'),
(86, 'business_name', ''),
(87, 'is_cookie_policy_page', '0'),
(88, 'cookies_policy_page', ''),
(89, 'embed_footee_javascript', ''),
(90, 'home_page', '1'),
(91, 'homepage_code', '\n\n\n \n
\n
\n
Automate Your Payments Seamlessly
\n
Join us to experience efficient and secure payment solutions for your business
\n
\n
\n
\n \n
![](\"<?=)
/123123-1.png\" class=\"img-fluid animated\" alt=\"\">\n
\n \n
\n
\n \n\n
\n
\n
\n
/tt.png\" class=\"img-fluid\" alt=\"\">\n
Save Time
\n
Simplify your payment processes and save valuable time with our integrated MFS API, ensuring fast and efficient transactions.
\n
\n
\n\n
\n
\n
/nh.png\" class=\"img-fluid\" alt=\"\">\n
Seamless Integration
\n
Easily connect and integrate with our system. Automate workflows, link applications, and manage data sources effortlessly.
\n
\n
\n\n
\n
\n
/mm.png\" class=\"img-fluid\" alt=\"\">\n
Automate Personal Accounts
\n
Streamline your payment reception with NagorikPay\'s automation. Direct payments to your personal account without manual intervention.
\n
\n
\n\n
\n
\n
/5644447.png\" class=\"img-fluid\" alt=\"\">\n
Invoice Generator
\n
Create and send personalized payment links via email for quick and easy payments, eliminating the need for a website or online store.
\n
\n
\n\n
\n
\n
/6221918.png\" class=\"img-fluid\" alt=\"\">\n
Billing Management
\n
Simplify billing with NagorikPay\'s automated system. Monitor transactions, generate invoices, and streamline your billing process efficiently.
\n
\n
\n\n
\n
\n
/2903544.png\" class=\"img-fluid\" alt=\"\">\n
Multiple Payment Options
\n
Offer your customers various payment methods, including Mobile Banking and Bank Transfers, through NagorikPay\'s versatile platform.
\n
\n
\n\n \n
\n
\n\n
\n\n
\n\n
\n\n
\n
\n \n
\n
\n
\n
Total Amount Transactions
\n
\n
\n
\n\n
\n
\n \n
\n
\n
\n
Supported Payment Methods
\n
\n
\n
\n\n
\n\n
\n\n \n\n
\n\n
\n \n
/13429923.jpg\" class=\"img-fluid\" alt=\"\">\n
\n \n\n
\n
\n\n
\n
\n \n
Real-Time Processing
\n \n
\n\n
\n
\n \n
High Security
\n \n
\n\n
\n
\n \n
Scalability
\n \n
\n\n \n\n
\n
\n \n
Seamless Integration
\n \n
\n\n
\n
\n \n
Comprehensive Reporting
\n \n
\n\n
\n
\n \n
Automatic Payment Verification
\n \n
\n\n
\n
\n \n
No Transaction Fees
\n \n
\n\n
\n
\n\n
\n\n
\n\n \n\n
\n\n
\n
\n
\n
Instant Payment
\n
After the customer makes the payment through NAGORIKPAY, it will be instantly added to account with automatic verification.
\n
\n
\n\n
\n
\n
\n
Lifetime Updates
\n
Enjoy free lifetime updates with the desired service.
\n
\n
\n\n
\n
\n
\n
Unlimited Transactions
\n
Receive unlimited payments with Nagorikpay without any fees.
\n
\n
\n\n
\n
\n
\n
24/7 Support
\n
Our support team is available 24/7 to solve any issues, including NagorikPay setup and usage.
\n
\n
\n\n
\n
\n
\n
Payment Processing
\n
Efficient and secure processing for all your payment needs, ensuring seamless transactions every time.
\n
\n
\n\n
\n
\n
\n
Fraud Prevention
\n
Advanced fraud prevention measures to protect your business and customers from unauthorized activities.
\n
\n
\n\n
\n\n
\n\n \n\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n \n
\n
\n\n \n \n
\n
\n \n
\n $item) : ?>\n
\n \n
\" class=\"accordion-collapse collapse \" aria-labelledby=\"m\" data-bs-parent=\"#faqlist1\">\n
\n \n
\n
\n
\n \n
\n
\n\n
\n \n
\n $item) : ?>\n
\n \n
\" class=\"accordion-collapse collapse\" aria-labelledby=\"m\" data-bs-parent=\"#faqlist2\">\n
\n \n
\n
\n
\n \n
\n
\n
\n \n\n\n
\n\n \n\n
\n
\n \n
\" class=\"img-fluid\" alt=\"\">
\n \n
\n \n
\n
![\"\"](\"public/assets/plat/smm.png\")
![\"\"](\"public/assets/plat/php.png\")
![\"\"](\"public/assets/plat/javascript.png\")
![\"\"](\"public/assets/plat/jquery.png\")
![\"\"](\"public/assets/plat/nodejs.png\")
![\"\"](\"public/assets/plat/whmcs-logo.png\"){kind=logo}
![\"\"](\"public/assets/plat/woocommerce-logo-transparent.png\"){kind=spacer}
![\"\"](\"public/assets/plat/wordpress-logo-stacked-rgb.png\"){kind=logo}