-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 21, 2026 at 05:13 PM
-- Server version: 8.0.42-cll-lve
-- PHP Version: 8.3.30

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: `shirfanb_powerv2ray`
--

-- --------------------------------------------------------

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `date` datetime NOT NULL,
  `action` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `ipaddress` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `device_os` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `device_client` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` (`id`, `user_id`, `date`, `action`, `ipaddress`, `device_os`, `device_client`) VALUES
(316, 2, '2026-04-13 07:56:33', 'Website Login', '103.31.155.229', 'Android - Chrome', 'Smartphone (Android)'),
(317, 2, '2026-04-13 10:59:29', 'Logout', '103.31.155.229', 'Google Chrome', 'Web Browser'),
(318, 1, '2026-04-13 07:59:33', 'Website Login', '103.31.155.229', 'Android - Chrome', 'Smartphone (Android)'),
(319, 1, '2026-04-13 10:59:54', 'Logout', '103.31.155.229', 'Google Chrome', 'Web Browser'),
(320, 2, '2026-04-13 08:00:09', 'Website Login', '103.31.155.229', 'Android - Chrome', 'Smartphone (Android)'),
(321, 2, '2026-04-13 11:01:52', 'Logout', '103.31.155.229', 'Google Chrome', 'Web Browser'),
(322, 1, '2026-04-13 08:01:56', 'Website Login', '103.31.155.229', 'Android - Chrome', 'Smartphone (Android)'),
(323, 1, '2026-04-13 08:04:37', 'Added new user <code>25408 - normal</code>', '103.31.155.229', 'Android - Chrome', 'Smartphone (Android)'),
(324, 1, '2026-04-13 08:09:07', 'Website Login', '107.152.42.186', 'Android - Chrome', 'Smartphone (Android)'),
(325, 1, '2026-04-13 08:28:24', 'Website Login', '91.107.188.225', 'Android - Chrome', 'Smartphone (Android)'),
(326, 2, '2026-04-13 08:30:27', 'Website Login', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(327, 1, '2026-04-13 08:30:31', 'Website Login', '178.73.77.41', 'Android - Chrome', 'Smartphone (Android)'),
(328, 2, '2026-04-13 11:31:30', 'Logout', '176.18.27.196', 'Google Chrome', 'Web Browser'),
(329, 1, '2026-04-13 08:31:33', 'Website Login', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(330, 1, '2026-04-13 08:32:16', 'Added new user <code>97916 - normal</code>', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(331, 1, '2026-04-13 08:33:46', 'Website Login', '37.111.211.166', 'Android - Chrome', 'Smartphone (Android)'),
(332, 1, '2026-04-13 08:35:27', 'User <code>97916</code> socksip access enabled.', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(333, 1, '2026-04-13 08:36:07', 'Added <code>xxxxxxxx</code> as new reseller with <code>1</code> credit balance.', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(334, 1, '2026-04-13 11:36:13', 'Logout', '178.73.77.41', 'Google Chrome', 'Web Browser'),
(335, 1, '2026-04-13 08:37:30', 'Website Login', '23.158.233.206', 'Android - Chrome', 'Smartphone (Android)'),
(336, 2, '2026-04-13 08:43:01', 'Website Login', '23.158.233.206', 'Android - Chrome', 'Smartphone (Android)'),
(337, 2, '2026-04-13 11:45:16', 'Logout', '23.158.233.206', 'Google Chrome', 'Web Browser'),
(338, 1, '2026-04-13 08:45:40', 'Website Login', '23.158.233.206', 'Android - Chrome', 'Smartphone (Android)'),
(339, 2, '2026-04-13 09:40:50', 'Website Login', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(340, 2, '2026-04-13 12:42:50', 'Logout', '176.18.27.196', 'Google Chrome', 'Web Browser'),
(341, 1, '2026-04-13 09:43:31', 'Website Login', '176.18.27.196', 'Windows 10 - Chrome', 'Desktop'),
(342, 1, '2026-04-13 10:02:02', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(343, 1, '2026-04-13 10:13:26', 'Website Login', '188.245.232.37', 'Android - Chrome', 'Smartphone (Android)'),
(344, 1, '2026-04-13 10:15:12', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(345, 1, '2026-04-13 10:16:59', 'Website Login', '103.158.206.36', 'Android - Chrome', 'Smartphone (Android)'),
(346, 1, '2026-04-13 10:20:25', 'Website Login', '94.99.17.247', 'Android - Chrome', 'Smartphone (Android)'),
(347, 1, '2026-04-13 13:23:03', 'Logout', '94.99.17.247', 'Google Chrome', 'Web Browser'),
(348, 1, '2026-04-13 10:30:54', 'Website Login', '94.99.17.247', 'Android - Chrome', 'Smartphone (Android)'),
(349, 1, '2026-04-13 13:35:36', 'Logout', '103.242.20.170', 'Google Chrome', 'Web Browser'),
(350, 2, '2026-04-13 10:35:43', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(351, 2, '2026-04-13 13:39:31', 'Logout', '103.242.20.170', 'Google Chrome', 'Web Browser'),
(352, 1, '2026-04-13 10:39:37', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(353, 1, '2026-04-13 14:01:08', 'Logout', '103.242.20.170', 'Google Chrome', 'Web Browser'),
(354, 1, '2026-04-13 14:01:40', 'Logout', '103.242.20.170', 'Google Chrome', 'Web Browser'),
(355, 2, '2026-04-13 11:02:04', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(356, 2, '2026-04-13 14:05:58', 'Logout', '103.242.20.170', 'Google Chrome', 'Web Browser'),
(357, 1, '2026-04-13 11:06:04', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(358, 1, '2026-04-13 11:12:16', 'Website Login', '103.242.20.170', 'Windows 10 - Chrome', 'Desktop'),
(359, 1, '2026-04-13 12:45:26', 'Website Login', '51.235.64.15', 'Android - Chrome', 'Smartphone (Android)'),
(360, 1, '2026-04-13 12:47:36', 'Added new user <code>57365 - normal</code>', '51.235.64.15', 'Android - Chrome', 'Smartphone (Android)'),
(361, 1, '2026-04-13 12:50:22', 'Website Login', '204.168.157.184', 'Android - Chrome', 'Smartphone (Android)'),
(362, 1, '2026-04-13 12:55:46', 'Added new <code>10</code> bulk users', '204.168.157.184', 'Android - Chrome', 'Smartphone (Android)'),
(363, 1, '2026-04-13 15:57:00', 'Logout', '94.99.17.247', 'Google Chrome', 'Web Browser'),
(364, 1, '2026-04-13 12:57:20', 'Website Login', '94.99.17.247', 'Android - Chrome', 'Smartphone (Android)'),
(365, 1, '2026-04-13 15:58:07', 'Logout', '94.99.17.247', 'Google Chrome', 'Web Browser'),
(366, 1, '2026-04-13 13:02:51', 'Website Login', '78.47.121.133', 'Android - Chrome', 'Smartphone (Android)'),
(367, 1, '2026-04-13 13:13:58', 'Website Login', '94.130.107.44', 'Android - Firefox', 'Smartphone (Android)'),
(368, 1, '2026-04-13 17:01:59', 'Logout', '103.31.155.241', 'Google Chrome', 'Web Browser'),
(369, 1, '2026-04-13 14:24:14', 'Website Login', '103.31.155.241', 'Windows 10 - Chrome', 'Desktop'),
(370, 1, '2026-04-13 15:38:29', 'Added new user <code>93433 - normal</code>', '103.31.155.241', 'Windows 10 - Chrome', 'Desktop'),
(371, 1, '2026-04-13 19:44:51', 'Logout', '103.31.155.241', 'Google Chrome', 'Web Browser'),
(372, 1, '2026-04-13 19:45:28', 'Logout', '103.31.155.241', 'Google Chrome', 'Web Browser'),
(373, 1, '2026-04-13 20:18:48', 'Logout', '103.31.155.241', 'Google Chrome', 'Web Browser'),
(374, 1, '2026-04-14 06:44:01', 'Website Login', '103.31.152.230', 'Android - Chrome', 'Smartphone (Android)'),
(375, 1, '2026-04-14 06:52:08', 'Website Login', '89.117.254.110', 'Windows 10 - Chrome', 'Desktop'),
(376, 1, '2026-04-14 10:17:39', 'Logout', '103.31.152.230', 'Google Chrome', 'Web Browser'),
(377, 1, '2026-04-14 07:17:54', 'Website Login', '103.31.152.230', 'Android - Chrome', 'Smartphone (Android)'),
(378, 1, '2026-04-14 11:47:45', 'Logout', '103.31.155.237', 'Google Chrome', 'Web Browser'),
(379, 1, '2026-04-14 08:48:10', 'Website Login', '149.126.14.183', 'Android - Chrome', 'Smartphone (Android)'),
(380, 1, '2026-04-14 08:48:30', 'Website Login', '103.31.155.237', 'Android - Chrome', 'Smartphone (Android)'),
(381, 1, '2026-04-14 09:20:01', 'Website Login', '103.31.155.237', 'Android - Chrome', 'Smartphone (Android)'),
(382, 1, '2026-04-14 12:22:47', 'Logout', '103.31.155.237', 'Google Chrome', 'Web Browser'),
(383, 1, '2026-04-14 12:43:08', 'Logout', '103.31.155.237', 'Google Chrome', 'Web Browser'),
(384, 1, '2026-04-14 10:02:04', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(385, 1, '2026-04-14 10:03:39', 'Website Login', '103.31.155.237', 'Windows 10 - Chrome', 'Desktop'),
(386, 1, '2026-04-14 10:10:02', 'Updated <code>93433</code> device.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(387, 1, '2026-04-14 10:10:29', 'Added new user <code>It13566 - normal</code>', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(388, 1, '2026-04-14 13:11:07', 'Logout', '103.51.2.180', 'Google Chrome', 'Web Browser'),
(389, 1, '2026-04-14 11:37:55', 'Website Login', '103.181.181.26', 'Android - Chrome', 'Smartphone (Android)'),
(390, 1, '2026-04-14 16:48:00', 'Website Login', '58.145.187.228', 'Android - Chrome', 'Smartphone (Android)'),
(391, 1, '2026-04-14 18:49:11', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(392, 1, '2026-04-14 21:15:55', 'Website Login', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(393, 1, '2026-04-14 21:19:11', 'User <code>xxxxxxxx</code> was deleted.', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(394, 1, '2026-04-14 21:19:30', 'User <code>It13566</code> was deleted.', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(395, 1, '2026-04-14 21:19:35', 'User <code>93433</code> was deleted.', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(396, 1, '2026-04-14 21:19:43', 'User <code>57365</code> was deleted.', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(397, 1, '2026-04-14 21:19:48', 'User <code>97916</code> was deleted.', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(398, 1, '2026-04-14 21:19:52', 'User <code>25408</code> was deleted.', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(399, 1, '2026-04-15 00:20:04', 'Logout', '157.230.29.224', 'Google Chrome', 'Web Browser'),
(400, 2, '2026-04-14 21:20:22', 'Website Login', '157.230.29.224', 'Android - Chrome', 'Smartphone (Android)'),
(401, 2, '2026-04-15 00:27:18', 'Logout', '157.230.29.224', 'Google Chrome', 'Web Browser'),
(402, 1, '2026-04-15 03:03:37', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(403, 1, '2026-04-15 07:27:08', 'Website Login', '114.130.120.18', 'Android - Chrome', 'Smartphone (Android)'),
(404, 1, '2026-04-15 07:58:31', 'Website Login', '103.158.206.36', 'Android - Chrome', 'Smartphone (Android)'),
(405, 1, '2026-04-15 08:04:25', 'Added new user <code>27889 - normal</code>', '114.130.120.18', 'Android - Chrome', 'Smartphone (Android)'),
(406, 1, '2026-04-15 11:27:21', 'Logout', '114.130.120.18', 'Google Chrome', 'Web Browser'),
(407, 1, '2026-04-15 11:35:41', 'Website Login', '103.242.22.251', 'Windows 10 - Chrome', 'Desktop'),
(408, 1, '2026-04-15 12:34:11', 'Website Login', '103.242.22.251', 'Windows 10 - Chrome', 'Desktop'),
(409, 1, '2026-04-15 13:26:26', 'Website Login', '103.242.22.251', 'Android - Chrome', 'Smartphone (Android)'),
(410, 1, '2026-04-15 16:32:19', 'Logout', '103.242.22.251', 'Google Chrome', 'Web Browser'),
(411, 1, '2026-04-15 13:38:23', 'Website Login', '103.242.22.251', 'Windows 10 - Chrome', 'Desktop'),
(412, 1, '2026-04-15 20:59:16', 'Logout', '46.224.11.130', 'Google Chrome', 'Web Browser'),
(413, 1, '2026-04-15 17:59:38', 'Website Login', '46.224.11.130', 'Android - Chrome', 'Smartphone (Android)'),
(414, 1, '2026-04-15 17:59:55', 'Website Login', '103.31.152.231', 'Android - Chrome', 'Smartphone (Android)'),
(415, 1, '2026-04-15 18:00:27', 'Added <code>Rjgcc</code> as new reseller with <code>2</code> credit balance.', '46.224.11.130', 'Android - Chrome', 'Smartphone (Android)'),
(416, 1, '2026-04-15 18:09:59', 'Website Login', '103.31.152.231', 'Android - Chrome', 'Smartphone (Android)'),
(417, 1, '2026-04-15 21:30:49', 'Logout', '46.224.11.130', 'Google Chrome', 'Web Browser'),
(418, 1, '2026-04-15 18:51:50', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(419, 1, '2026-04-15 18:53:44', 'Added new user <code>96859 - normal</code>', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(420, 1, '2026-04-15 21:54:05', 'Logout', '103.51.2.180', 'Google Chrome', 'Web Browser'),
(421, 1, '2026-04-15 22:51:16', 'Logout', '103.242.20.194', 'Google Chrome', 'Web Browser'),
(422, 1, '2026-04-15 19:51:35', 'Website Login', '103.242.20.194', 'Android - Chrome', 'Smartphone (Android)'),
(423, 1, '2026-04-15 22:58:03', 'Logout', '103.242.20.194', 'Google Chrome', 'Web Browser'),
(424, 1, '2026-04-15 20:03:56', 'Website Login', '37.111.213.173', 'Android - Chrome', 'Smartphone (Android)'),
(425, 1, '2026-04-15 21:43:21', 'Website Login', '103.242.20.194', 'Android - Chrome', 'Smartphone (Android)'),
(426, 1, '2026-04-15 21:52:05', 'Website Login', '223.25.254.29', 'Android - Chrome', 'Smartphone (Android)'),
(427, 1, '2026-04-15 21:53:12', 'Website Login', '51.36.222.191', 'Android - Chrome', 'Smartphone (Android)'),
(428, 1, '2026-04-15 21:53:18', 'Website Login', '204.168.204.73', 'Android - Chrome', 'Smartphone (Android)'),
(429, 1, '2026-04-15 21:55:32', 'Added <code>Kader</code> as new reseller with <code>010</code> credit balance.', '223.25.254.29', 'Android - Chrome', 'Smartphone (Android)'),
(430, 1, '2026-04-15 22:00:57', 'Website Login', '103.76.241.45', 'Android - Chrome', 'Smartphone (Android)'),
(431, 1, '2026-04-16 02:28:51', 'Logout', '103.158.206.39', 'Google Chrome', 'Web Browser'),
(432, 1, '2026-04-16 02:12:47', 'Website Login', '46.38.78.134', 'Android - Chrome', 'Smartphone (Android)'),
(433, 1, '2026-04-16 03:51:44', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(434, 1, '2026-04-16 04:47:53', 'Website Login', '103.134.58.202', 'Linux - Chrome', 'Desktop'),
(435, 1, '2026-04-16 10:28:45', 'Website Login', '103.112.206.80', 'Android - Chrome', 'Smartphone (Android)'),
(436, 1, '2026-04-17 10:37:17', 'Website Login', '103.31.155.243', 'Windows 10 - Chrome', 'Desktop'),
(437, 1, '2026-04-17 10:39:44', 'Website Login', '103.31.155.243', 'Windows 10 - Chrome', 'Desktop'),
(438, 1, '2026-04-17 12:40:23', 'Website Login', '37.111.194.156', 'Linux - Chrome', 'Desktop'),
(439, 1, '2026-04-17 14:08:28', 'Website Login', '103.31.155.243', 'Android - Chrome', 'Smartphone (Android)'),
(440, 2, '2026-04-17 14:22:54', 'Website Login', '103.158.206.36', 'Windows 10 - Chrome', 'Desktop'),
(441, 1, '2026-04-17 19:39:31', 'Logout', '103.31.155.243', 'Google Chrome', 'Web Browser'),
(442, 1, '2026-04-17 19:40:10', 'Logout', '103.31.155.243', 'Google Chrome', 'Web Browser'),
(443, 2, '2026-04-17 16:40:48', 'Website Login', '103.31.155.243', 'Windows 10 - Chrome', 'Desktop'),
(444, 2, '2026-04-17 19:46:32', 'Logout', '103.31.155.243', 'Google Chrome', 'Web Browser'),
(445, 1, '2026-04-17 16:46:38', 'Website Login', '103.31.155.243', 'Windows 10 - Chrome', 'Desktop'),
(446, 1, '2026-04-17 19:53:59', 'Logout', '103.31.155.243', 'Google Chrome', 'Web Browser'),
(447, 2, '2026-04-17 16:54:05', 'Website Login', '103.31.155.243', 'Windows 10 - Chrome', 'Desktop'),
(448, 1, '2026-04-17 17:16:43', 'Website Login', '37.111.221.73', 'Android - Chrome', 'Smartphone (Android)'),
(449, 1, '2026-04-17 18:40:59', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(450, 1, '2026-04-17 20:27:14', 'Website Login', '91.107.144.75', 'Android - Chrome', 'Smartphone (Android)'),
(451, 2, '2026-04-18 10:23:26', 'Website Login', '89.117.101.6', 'Windows 10 - Chrome', 'Desktop'),
(452, 2, '2026-04-18 17:03:14', 'Website Login', '103.31.155.240', 'Windows 10 - Chrome', 'Desktop'),
(453, 2, '2026-04-18 17:06:08', 'Website Login', '103.31.155.240', 'Android - Chrome', 'Smartphone (Android)'),
(454, 2, '2026-04-19 05:30:46', 'Logout', '103.242.20.210', 'Google Chrome', 'Web Browser'),
(455, 1, '2026-04-19 02:31:06', 'Website Login', '103.242.20.210', 'Windows 10 - Chrome', 'Desktop'),
(456, 2, '2026-04-19 05:33:57', 'Logout', '103.242.20.210', 'Google Chrome', 'Web Browser'),
(457, 1, '2026-04-19 02:34:01', 'Website Login', '103.242.20.210', 'Android - Chrome', 'Smartphone (Android)'),
(458, 1, '2026-04-19 02:59:07', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(459, 1, '2026-04-19 03:06:30', 'Added new user <code>74278 - normal</code>', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(460, 1, '2026-04-19 03:06:39', 'Added new user <code>dxplusdev - normal</code>', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(461, 1, '2026-04-19 03:07:24', 'Added <code>F7du</code> as new reseller with <code>02</code> credit balance.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(462, 1, '2026-04-19 03:08:50', 'Updated <code>dxplusdev</code> password.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(463, 1, '2026-04-19 03:08:59', 'User <code>dxplusdev</code> was blocked.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(464, 1, '2026-04-19 03:09:06', 'User <code>dxplusdev</code> was unblocked.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(465, 1, '2026-04-19 03:09:12', 'Updated <code>dxplusdev</code> session.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(466, 1, '2026-04-19 03:09:19', 'Updated <code>dxplusdev</code> device.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(467, 1, '2026-04-19 03:09:29', 'User <code>dxplusdev</code> was deleted.', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(468, 1, '2026-04-19 06:19:49', 'Logout', '103.51.2.180', 'Google Chrome', 'Web Browser'),
(469, 1, '2026-04-19 03:20:57', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(470, 1, '2026-04-20 19:08:36', 'Website Login', '42.0.5.219', 'Android - Chrome', 'Smartphone (Android)'),
(471, 1, '2026-04-20 19:10:51', 'Website Login', '42.0.5.219', 'Windows 10 - Chrome', 'Desktop'),
(472, 1, '2026-04-20 19:49:58', 'Website Login', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(473, 1, '2026-04-20 19:50:17', 'Added new user <code>92078 - normal</code>', '103.51.2.180', 'Android - Chrome', 'Smartphone (Android)'),
(474, 1, '2026-04-20 19:53:32', 'Website Login', '213.166.137.82', 'Android - Chrome', 'Smartphone (Android)'),
(475, 1, '2026-04-21 14:55:33', 'Logout', '46.224.11.130', 'Google Chrome', 'Web Browser'),
(476, 1, '2026-04-21 11:55:40', 'Website Login', '46.224.11.130', 'Android - Chrome', 'Smartphone (Android)'),
(477, 1, '2026-04-21 11:55:49', 'Website Login', '46.224.11.130', 'Android - Chrome', 'Smartphone (Android)'),
(478, 1, '2026-04-21 14:02:56', 'Added new user <code>71831 - normal</code>', '103.31.155.238', 'Android - Chrome', 'Smartphone (Android)');

-- --------------------------------------------------------

--
-- Table structure for table `ads_api_logs`
--

CREATE TABLE `ads_api_logs` (
  `id` int NOT NULL,
  `app_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `endpoint` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `request_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `response_code` int DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_api_logs`
--

INSERT INTO `ads_api_logs` (`id`, `app_name`, `endpoint`, `ip_address`, `user_agent`, `request_data`, `response_code`, `created_date`) VALUES
(4, 'SampleApp2', '/api/ads/SampleApp2/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/SampleApp2/config', 404, '2025-11-11 11:23:11'),
(10, 'ruzain', '/api/ads/ruzain/config', '::1', 'colly - https://github.com/gocolly/colly', '/api/ads/ruzain/config', 200, '2025-11-13 17:39:24'),
(11, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-11-13 17:39:52'),
(12, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-11-13 17:41:03'),
(13, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 404, '2025-12-07 21:42:10'),
(14, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 404, '2025-12-07 21:42:14'),
(15, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 404, '2025-12-07 21:42:22'),
(16, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-12-07 21:42:36'),
(17, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-12-07 21:42:46'),
(18, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-12-07 21:42:48'),
(19, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-12-07 21:42:51'),
(20, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-12-07 21:55:41'),
(21, 'ruzain', '/api/ads/ruzain/config', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/api/ads/ruzain/config', 200, '2025-12-07 22:02:04'),
(22, 'ruzain', '/api/ads/ruzain/config', '5.82.191.54', 'Dalvik/2.1.0 (Linux; U; Android 13; SM-A716B Build/TP1A.220624.014)', '/api/ads/ruzain/config', 404, '2025-12-08 20:51:22'),
(23, 'ruzain', '/api/ads/ruzain/config', '5.82.191.54', 'Dalvik/2.1.0 (Linux; U; Android 13; SM-A716B Build/TP1A.220624.014)', '/api/ads/ruzain/config', 404, '2025-12-08 20:51:22'),
(24, 'ruzain', '/api/ads/ruzain/config', '5.82.191.54', 'Dalvik/2.1.0 (Linux; U; Android 13; SM-A716B Build/TP1A.220624.014)', '/api/ads/ruzain/config', 404, '2025-12-08 20:51:33'),
(25, 'ruzain', '/api/ads/ruzain/config', '204.168.157.184', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/api/ads/ruzain/config', 200, '2026-04-13 11:16:44'),
(26, 'ruzain', '/api/ads/ruzain/config', '142.250.33.36', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', '/api/ads/ruzain/config', 200, '2026-04-13 11:16:46'),
(27, 'ruzain', '/api/ads/ruzain/config', '142.250.33.36', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', '/api/ads/ruzain/config', 200, '2026-04-13 11:16:46'),
(28, 'ruzain', '/api/ads/ruzain/config', '142.250.33.35', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)', '/api/ads/ruzain/config', 200, '2026-04-13 11:16:46');

-- --------------------------------------------------------

--
-- Table structure for table `ads_apps`
--

CREATE TABLE `ads_apps` (
  `id` int NOT NULL,
  `app_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `package_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `admob_app_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `banner_ad_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `interstitial_ad_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rewarded_ad_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `native_advanced_ad_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `app_open_ad_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('active','inactive','testing') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'active',
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ads_apps`
--

INSERT INTO `ads_apps` (`id`, `app_name`, `package_name`, `admob_app_id`, `banner_ad_id`, `interstitial_ad_id`, `rewarded_ad_id`, `native_advanced_ad_id`, `app_open_ad_id`, `status`, `created_date`, `updated_date`) VALUES
(6, 'ruzain', 'com.zeroos.app', 'ca-app-pub-3940256099942544~3347511713', 'ca-app-pub-3940256099942544/6300978111', 'ca-app-pub-3940256099942544/1033173712', 'ca-app-pub-3940256099942544/5224354917', 'ca-app-pub-3940256099942544/3986624511', 'ca-app-pub-3940256099942544/5662855259', 'active', '2025-11-13 17:36:21', '2026-04-13 11:16:31');

-- --------------------------------------------------------

--
-- Table structure for table `ads_revenue`
--

CREATE TABLE `ads_revenue` (
  `id` int NOT NULL,
  `app_id` int NOT NULL,
  `app_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` date NOT NULL,
  `ad_type` enum('banner','interstitial','rewarded','native_advanced','app_open','all') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'all',
  `revenue` decimal(10,2) DEFAULT '0.00',
  `impressions` int DEFAULT '0',
  `clicks` int DEFAULT '0',
  `ctr` decimal(5,2) DEFAULT '0.00',
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `anti_ddos`
--

CREATE TABLE `anti_ddos` (
  `id` int NOT NULL,
  `attempts` int NOT NULL DEFAULT '0',
  `ip` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `timestamp` int NOT NULL,
  `logs_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `api_keys`
--

CREATE TABLE `api_keys` (
  `key_id` int NOT NULL,
  `key_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `api_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `key_status` tinyint(1) NOT NULL DEFAULT '1',
  `key_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `application`
--

CREATE TABLE `application` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application`
--

INSERT INTO `application` (`id`, `name`, `link`, `date`, `description`, `status`) VALUES
(1, 'Android App', 'https://play.google.com/store/apps', '2025-11-14 18:12:06', 'Android VPN Application', 'active'),
(2, 'iOS App', 'https://apps.apple.com/', '2025-11-14 18:12:06', 'iOS VPN Application', 'active'),
(3, 'Windows App', 'https://example.com/windows', '2025-11-14 18:12:06', 'Windows VPN Client', 'active');

-- --------------------------------------------------------

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int NOT NULL,
  `app_title` varchar(155) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `app_version` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `app_website` varchar(155) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `logo` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `app_description` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `filename` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `date_uploaded` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `downloads` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `app_notices`
--

CREATE TABLE `app_notices` (
  `id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notice_type` enum('info','warning','success','error','update') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'info',
  `is_active` tinyint(1) DEFAULT '1',
  `show_button` tinyint(1) DEFAULT '0',
  `button_text` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_version` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `priority` int DEFAULT '0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `attention`
--

CREATE TABLE `attention` (
  `id` int NOT NULL,
  `attention_msg` text NOT NULL,
  `attention_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `bandwidth_logs`
--

CREATE TABLE `bandwidth_logs` (
  `id` int NOT NULL,
  `server` text NOT NULL,
  `server_ip` text NOT NULL,
  `server_port` text NOT NULL,
  `since_connected` text NOT NULL,
  `username` text NOT NULL,
  `ipaddress` text NOT NULL,
  `bytes_received` text NOT NULL,
  `bytes_sent` text NOT NULL,
  `bandwidth` bigint NOT NULL DEFAULT '0',
  `time` datetime NOT NULL,
  `time_in` datetime NOT NULL,
  `time_out` datetime NOT NULL,
  `status` enum('offline','online') NOT NULL,
  `timestamp` int NOT NULL,
  `category` enum('premium','vip','ph','private','free') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bandwidth_logs`
--

INSERT INTO `bandwidth_logs` (`id`, `server`, `server_ip`, `server_port`, `since_connected`, `username`, `ipaddress`, `bytes_received`, `bytes_sent`, `bandwidth`, `time`, `time_in`, `time_out`, `status`, `timestamp`, `category`) VALUES
(1, '', '127.0.0.1', '47586', '2025-12-09 04:51:38', 'dev22', '127.0.0.1:47586', '737669', '12169433', 0, '0000-00-00 00:00:00', '2025-12-09 04:51:40', '2025-12-09 04:55:46', 'offline', 2025, 'premium');

-- --------------------------------------------------------

--
-- Table structure for table `blocked_ips`
--

CREATE TABLE `blocked_ips` (
  `id` int NOT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `blocked_until` int NOT NULL,
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id` int NOT NULL,
  `chat_id1` int NOT NULL,
  `chat_id2` int NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `chat_status` enum('seen','unseen') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unseen',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sender_type` enum('user','admin') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cloudflare_domains`
--

CREATE TABLE `cloudflare_domains` (
  `id` int NOT NULL,
  `domain_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `zone_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `global_api` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `conversion_logs`
--

CREATE TABLE `conversion_logs` (
  `id` int NOT NULL,
  `client_id` int NOT NULL,
  `premium` varchar(755) NOT NULL,
  `vip` varchar(755) NOT NULL,
  `description` varchar(755) NOT NULL,
  `logs_date` datetime NOT NULL,
  `ipaddress` varchar(32) NOT NULL DEFAULT '0.0.0.0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `credits_logs`
--

CREATE TABLE `credits_logs` (
  `id` int NOT NULL,
  `credits_id` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `credits_id2` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `credits_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `credits_qty` int NOT NULL,
  `credits_date` datetime NOT NULL,
  `seller` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `credits_logs`
--

INSERT INTO `credits_logs` (`id`, `credits_id`, `credits_id2`, `credits_type`, `credits_qty`, `credits_date`, `seller`) VALUES
(79, '1', 'xxxxxxxx', 'add', 1, '2026-04-13 08:36:07', ''),
(80, '1', 'Rjgcc', 'add', 2, '2026-04-15 18:00:27', ''),
(81, '1', 'Kader', 'add', 10, '2026-04-15 21:55:32', ''),
(82, '1', 'F7du', 'add', 2, '2026-04-19 03:07:24', '');

-- --------------------------------------------------------

--
-- Table structure for table `cronjob_banned_ip`
--

CREATE TABLE `cronjob_banned_ip` (
  `id` int NOT NULL,
  `attempts` int NOT NULL DEFAULT '0',
  `content` varchar(128) NOT NULL DEFAULT 'Attempting',
  `ip` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `logs_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `cronjob_logs`
--

CREATE TABLE `cronjob_logs` (
  `id` int NOT NULL,
  `content` text NOT NULL,
  `ipaddress` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `deleted_app_logs`
--

CREATE TABLE `deleted_app_logs` (
  `id` int NOT NULL,
  `app_id` int NOT NULL,
  `app_title` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `date_uploaded` datetime NOT NULL,
  `date_deleted` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `deleted_logs`
--

CREATE TABLE `deleted_logs` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `user_upline` int NOT NULL,
  `user_level` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `deleted_logs`
--

INSERT INTO `deleted_logs` (`id`, `user_id`, `user_upline`, `user_level`, `date`) VALUES
(7607, 58299, 1, 'reseller', '2026-04-14 21:19:11'),
(7608, 58312, 1, 'normal', '2026-04-14 21:19:30'),
(7609, 58311, 1, 'normal', '2026-04-14 21:19:35'),
(7610, 58300, 1, 'normal', '2026-04-14 21:19:43'),
(7611, 58298, 1, 'normal', '2026-04-14 21:19:48'),
(7612, 58297, 1, 'normal', '2026-04-14 21:19:52'),
(7613, 58318, 1, 'normal', '2026-04-19 03:09:29');

-- --------------------------------------------------------

--
-- Table structure for table `dns`
--

CREATE TABLE `dns` (
  `dns_id` int NOT NULL,
  `record_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `host_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `domain_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `ip_address` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `record_type` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `status` int NOT NULL,
  `global_api` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `zone_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `email` varchar(155) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `download`
--

CREATE TABLE `download` (
  `id` int NOT NULL,
  `download_category` enum('public','seller') NOT NULL,
  `download_title` varchar(767) NOT NULL,
  `download_msg` text NOT NULL,
  `download_network` enum('NOTICE','UPDATE') NOT NULL,
  `download_device` enum('ANDROID','IOS','WINDOWS','CONFIG','OTHERS') NOT NULL,
  `download_file` varchar(999) NOT NULL,
  `download_date` datetime NOT NULL,
  `views` int NOT NULL DEFAULT '0',
  `downloaded` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `download`
--

INSERT INTO `download` (`id`, `download_category`, `download_title`, `download_msg`, `download_network`, `download_device`, `download_file`, `download_date`, `views`, `downloaded`) VALUES
(14, 'public', 'Welcome to Vollam', 'The entire team of Vollam is thrilled to welcome you on board. We hope you&rsquo;ll do some amazing works here!&nbsp;<br /><br />Congratulations on being part of the team! The whole team welcomes you and we look forward to a successful journey with you! Welcome aboard!', 'NOTICE', 'OTHERS', '', '2020-12-13 10:01:13', 0, 0),
(15, 'public', 'How to update Vollam applications', 'Vollam applications get staged automatic updates. It means that some users get their automatic&nbsp;updates earlier than others. The reason for that is to avoid massive issues in case&nbsp;of some failure related to the updates.<br /><br />If you haven&#39;t got an automatic update yet, you will get it within a few days. If you wish to get the latest app version now, you can download it from our&nbsp;News and Updates section. The download page always provides&nbsp;the latest available app versions for all operating systems.', 'NOTICE', 'OTHERS', '', '2020-12-11 17:35:19', 0, 0),
(16, 'public', 'VPN for Netflix: watch Netflix securely', '<p>To ensure&nbsp;secure access to Netflix, you can connect to&nbsp;<strong>any of our servers&nbsp;listed below</strong>. We recommend using the servers closest to your location for the best connection speed and stability.<br /><br /><strong>Netflix US:</strong><br />You should connect to any of our servers in countries&nbsp;<strong>other than</strong>&nbsp;Canada, Germany, the United Kingdom, France, Italy, Japan, Australia, the Netherlands, India, Brazil, Spain, Portugal, South Korea, and Finland.</p><p><strong>Netflix CA:</strong><br />You should connect to any of our servers in Canada.</p><p><strong>Netflix DE:</strong><br />You should connect to any of our servers in Germany.</p>', 'NOTICE', 'OTHERS', '', '2020-12-11 17:35:46', 0, 0),
(46, 'public', 'Test Update with APK', 'Test Notice and Update with apk file attachment.', 'UPDATE', 'ANDROID', '1605592512.apk', '2020-11-17 13:55:12', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `duration`
--

CREATE TABLE `duration` (
  `id` int NOT NULL,
  `duration_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `duration_time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `duration`
--

INSERT INTO `duration` (`id`, `duration_name`, `duration_time`) VALUES
(1, '1 Hour', 3600),
(2, '2 Hours', 7200),
(3, '3 Hours', 10800),
(4, '4 Hours', 14400),
(5, '5 Hours', 18000),
(6, '6 Hours', 21600),
(7, '7 Hours', 25200),
(8, '8 Hours', 28800),
(9, '9 Hours', 32400),
(10, '10 Hours', 36000),
(11, '11 Hours', 39600),
(12, '12 Hours', 43200),
(13, '13 Hours', 46800),
(14, '14 Hours', 50400),
(15, '15 Hours', 54000),
(16, '16 Hours', 57600),
(17, '17 Hours', 61200),
(18, '18 Hours', 64800),
(19, '19 Hours', 68400),
(20, '20 Hours', 72000),
(21, '21 Hours', 75600),
(22, '22 Hours', 79200),
(23, '23 Hours', 82800),
(24, '1 Day', 86400),
(25, '2 Days', 172800),
(26, '3 Days', 259200),
(27, '4 Days', 345600),
(28, '5 Days', 432000),
(29, '6 Days', 518400),
(30, '7 Days', 604800),
(31, '8 Days', 691200),
(32, '9 Days', 777600),
(33, '10 Days', 864000),
(34, '15 Days', 1296000),
(35, '20 Days', 1728000),
(36, '30 Days', 2592000),
(37, '31 Days', 2678400),
(38, '32 Days', 2764800),
(39, '-3 Days', -259200);

-- --------------------------------------------------------

--
-- Table structure for table `duration_logs`
--

CREATE TABLE `duration_logs` (
  `id` int NOT NULL,
  `duration_id` int NOT NULL,
  `duration_id2` int NOT NULL,
  `duration_username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `duration_qty` int NOT NULL,
  `duration_item` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `duration_date` datetime NOT NULL,
  `duration_type` enum('premium','vip','private') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'premium',
  `ipaddress` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0.0.0.0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_campaigns`
--

CREATE TABLE `email_campaigns` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `content_type` enum('html','text') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'html',
  `status` enum('draft','scheduled','sending','sent','paused') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'draft',
  `created_by` int NOT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime DEFAULT NULL,
  `scheduled_date` datetime DEFAULT NULL,
  `sent_date` datetime DEFAULT NULL,
  `total_recipients` int DEFAULT '0',
  `recipient_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'all',
  `emails_sent` int DEFAULT '0',
  `emails_failed` int DEFAULT '0',
  `opens` int DEFAULT '0',
  `clicks` int DEFAULT '0',
  `unsubscribes` int DEFAULT '0',
  `bounces` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_campaign_recipients`
--

CREATE TABLE `email_campaign_recipients` (
  `id` int NOT NULL,
  `campaign_id` int NOT NULL,
  `subscriber_id` int NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` enum('pending','sent','failed','opened','clicked','unsubscribed','bounced') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'pending',
  `sent_date` datetime DEFAULT NULL,
  `opened_date` datetime DEFAULT NULL,
  `clicked_date` datetime DEFAULT NULL,
  `error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `tracking_token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_subscribers`
--

CREATE TABLE `email_subscribers` (
  `id` int NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` enum('active','unsubscribed','bounced') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'active',
  `source` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'manual',
  `tags` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `subscribed_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `unsubscribed_date` datetime DEFAULT NULL,
  `last_email_sent` datetime DEFAULT NULL,
  `email_count` int DEFAULT '0',
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `email_subscribers`
--

INSERT INTO `email_subscribers` (`id`, `email`, `name`, `status`, `source`, `tags`, `subscribed_date`, `unsubscribed_date`, `last_email_sent`, `email_count`, `ip_address`, `user_agent`) VALUES
(2, 'coxsbd@gmail.com', 'Admin', 'active', 'manual', 'vpn', '2025-11-12 14:52:27', NULL, '2025-12-08 00:23:52', 21, '::1', NULL),
(4, 'datasoftcaresales@gmail.com', 'Anoarul', 'active', 'manual', 'vpn', '2025-11-12 21:14:26', NULL, '2025-12-08 00:23:55', 21, '::1', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `content_type` enum('html','text') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'html',
  `template_type` enum('newsletter','promotion','announcement','welcome','custom') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'custom',
  `created_by` int NOT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_active` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `subject`, `content`, `content_type`, `template_type`, `created_by`, `created_date`, `updated_date`, `is_active`) VALUES
(1, 'Welcome Newsletter', 'Welcome to Our VPN Service!', '<h2>Welcome to Our VPN Service!</h2>\n<p>Hello {name},</p>\n<p>Thank you for your interest in our VPN service. We are excited to have you join our community!</p>\n<p>Here is what you can expect:</p>\n<ul>\n<li>Fast and secure VPN connections</li>\n<li>Multiple server locations worldwide</li>\n<li>24/7 customer support</li>\n<li>Easy-to-use applications</li>\n</ul>\n<p><a href=\"{website_url}\">Visit Our Website</a></p>\n<p>You received this email because you subscribed to our newsletter.</p>\n<p><a href=\"{unsubscribe_url}\">Unsubscribe</a></p>', 'html', 'welcome', 1, '2025-11-12 14:37:43', '2025-11-12 14:37:43', 1),
(2, 'Admin', 'xxxxx', 'xxxxxxx', 'html', 'promotion', 1, '2025-11-12 15:27:52', '2025-11-12 15:27:52', 1),
(4, 'Welcome Newsletter (Copy 2)', 'Welcome to Our VPN Service!', '<h2>Welcome to Our VPN Service!</h2>\n<p>Hello {name},</p>\n<p>Thank you for your interest in our VPN service. We are excited to have you join our community!</p>\n<p>Here is what you can expect:</p>\n<ul>\n<li>Fast and secure VPN connections</li>\n<li>Multiple server locations worldwide</li>\n<li>24/7 customer support</li>\n<li>Easy-to-use applications</li>\n</ul>\n<p><a href=\"{website_url}\">Visit Our Website</a></p>\n<p>You received this email because you subscribed to our newsletter.</p>\n<p><a href=\"{unsubscribe_url}\">Unsubscribe</a></p>', 'html', 'welcome', 1, '2025-11-12 15:33:30', '2025-11-12 15:33:30', 1),
(14, 'Modern Welcome Email', 'Welcome to {website_name} - Your VPN Journey Starts Here!', '<meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <style>\n        body { margin: 0; padding: 0; font-family: Arial, sans-serif; background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); }\n        .container { max-width: 600px; margin: 0 auto; background: white; }\n        .header { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); padding: 40px 20px; text-align: center; }\n        .header h1 { color: white; margin: 0; font-size: 28px; }\n        .content { padding: 40px 30px; }\n        .welcome-box { background: #f8f9ff; border-left: 4px solid #667eea; padding: 20px; margin: 20px 0; }\n        .btn { display: inline-block; background: #667eea; color: white; padding: 15px 30px; text-decoration: none; border-radius: 25px; margin: 20px 0; }\n        .features { display: flex; flex-wrap: wrap; gap: 20px; margin: 30px 0; }\n        .feature { flex: 1; min-width: 150px; text-align: center; padding: 20px; background: #f8f9ff; border-radius: 10px; }\n        .footer { background: #333; color: white; padding: 30px; text-align: center; }\n    </style>\n\n\n    <div class=\"container\">\n        <div class=\"header\">\n            <h1>???? Welcome Aboard!</h1>\n        </div>\n        <div class=\"content\">\n            <div class=\"welcome-box\">\n                <h2>Hello {name}!</h2>\n                <p>Welcome to our premium VPN service! We are excited to have you join our community of privacy-conscious users.</p>\n            </div>\n            \n            <div class=\"features\">\n                <div class=\"feature\">\n                    <h3>???? Secure</h3>\n                    <p>Military-grade encryption</p>\n                </div>\n                <div class=\"feature\">\n                    <h3>⚡ Fast</h3>\n                    <p>Lightning-fast servers</p>\n                </div>\n                <div class=\"feature\">\n                    <h3>???? Global</h3>\n                    <p>Servers worldwide</p>\n                </div>\n            </div>\n            \n            <p>Your account is now active and ready to use. Click the button below to get started:</p>\n            <a href=\"{website_url}\" class=\"btn\">Get Started Now</a>\n            \n            <p>If you have any questions, our 24/7 support team is here to help!</p>\n        </div>\n        <div class=\"footer\">\n            <p>© 2024 VPN Service. All rights reserved.</p>\n            <p><a href=\"{unsubscribe_url}\" style=\"color: #ccc;\">Unsubscribe</a></p>\n        </div>\n    </div>', 'html', 'welcome', 1, '2025-11-12 16:52:53', '2025-11-12 17:20:31', 1),
(23, 'Newsletter - Tech Updates', '???? Weekly Tech Updates & VPN News', '<meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <style>\n        body { margin: 0; padding: 0; font-family: \"Segoe UI\", Arial, sans-serif; background: #f4f4f4; }\n        .container { max-width: 600px; margin: 0 auto; background: white; box-shadow: 0 0 20px rgba(0,0,0,0.1); }\n        .header { background: #2c3e50; color: white; padding: 30px; text-align: center; }\n        .content { padding: 30px; }\n        .article { border-bottom: 1px solid #eee; padding: 20px 0; }\n        .article:last-child { border-bottom: none; }\n        .article h3 { color: #2c3e50; margin-top: 0; }\n        .read-more { color: #3498db; text-decoration: none; font-weight: bold; }\n        .stats { background: #ecf0f1; padding: 20px; border-radius: 10px; margin: 20px 0; }\n        .footer { background: #34495e; color: white; padding: 20px; text-align: center; }\n    </style>\n\n\n    <div class=\"container\">\n        <div class=\"header\">\n            <h1>???? Weekly Newsletter</h1>\n            <p>Stay updated with the latest in VPN technology</p>\n        </div>\n        <div class=\"content\">\n            <p>Hi {name},</p>\n            \n            <div class=\"stats\">\n                <h3>???? This Week in Numbers</h3>\n                <p>• 50,000+ new users joined<br>\n                • 99.9% uptime maintained<br>\n                • 15 new server locations added</p>\n            </div>\n            \n            <div class=\"article\">\n                <h3>???? New Security Features Released</h3>\n                <p>We have enhanced our encryption protocols with the latest WireGuard technology, providing even faster and more secure connections.</p>\n                <a href=\"{website_url}\" class=\"read-more\">Read More →</a>\n            </div>\n            \n            <div class=\"article\">\n                <h3>???? Server Expansion Update</h3>\n                <p>New servers are now live in Tokyo, Sydney, and São Paulo, bringing our total to over 100 locations worldwide.</p>\n                <a href=\"{website_url}\" class=\"read-more\">View All Locations →</a>\n            </div>\n            \n            <div class=\"article\">\n                <h3>???? Privacy Tip of the Week</h3>\n                <p>Always use HTTPS websites when browsing. Look for the lock icon in your browser address bar to ensure your connection is encrypted.</p>\n            </div>\n        </div>\n        <div class=\"footer\">\n            <p>Thank you for being part of our community!</p>\n            <p><a href=\"{unsubscribe_url}\" style=\"color: #bdc3c7;\">Unsubscribe</a> | <a href=\"{website_url}\" style=\"color: #bdc3c7;\">Visit Website</a></p>\n        </div>\n    </div>', 'html', 'newsletter', 1, '2025-11-12 17:24:46', '2025-11-12 17:24:46', 1),
(24, 'c', '???? Limited Time: 50% OFF Premium VPN Plans!', '<meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <style>\n        body { margin: 0; padding: 0; font-family: Arial, sans-serif; background: linear-gradient(45deg, #ff6b6b, #feca57); }\n        .container { max-width: 600px; margin: 0 auto; background: white; }\n        .header { background: linear-gradient(45deg, #ff6b6b, #feca57); padding: 40px 20px; text-align: center; color: white; }\n        .offer-badge { background: #ff4757; color: white; padding: 10px 20px; border-radius: 50px; display: inline-block; font-weight: bold; margin: 10px 0; }\n        .content { padding: 40px 30px; text-align: center; }\n        .price-box { background: #f1f2f6; padding: 30px; border-radius: 15px; margin: 30px 0; }\n        .old-price { text-decoration: line-through; color: #999; font-size: 18px; }\n        .new-price { color: #ff4757; font-size: 36px; font-weight: bold; }\n        .cta-button { background: linear-gradient(45deg, #ff6b6b, #feca57); color: white; padding: 20px 40px; text-decoration: none; border-radius: 50px; font-size: 18px; font-weight: bold; display: inline-block; margin: 20px 0; }\n        .countdown { background: #2f3542; color: white; padding: 20px; border-radius: 10px; margin: 20px 0; }\n        .footer { background: #2f3542; color: white; padding: 20px; text-align: center; }\n    </style>\n\n\n    <div class=\"container\">\n        <div class=\"header\">\n            <div class=\"offer-badge\">LIMITED TIME OFFER</div>\n            <h1>???? MEGA SALE</h1>\n            <h2>50% OFF Everything!</h2>\n        </div>\n        <div class=\"content\">\n            <p>Hi {name},</p>\n            <p>This is your chance to get premium VPN protection at an unbeatable price!</p>\n            \n            <div class=\"price-box\">\n                <h3>Premium Annual Plan</h3>\n                <div class=\"old-price\">$99.99/year</div>\n                <div class=\"new-price\">$49.99/year</div>\n                <p><strong>Save $50 instantly!</strong></p>\n            </div>\n            \n            <div class=\"countdown\">\n                <h3>⏰ Hurry! Offer expires in:</h3>\n                <p style=\"font-size: 24px; margin: 0;\"><strong>48 HOURS</strong></p>\n            </div>\n            \n            <a href=\"{website_url}\" class=\"cta-button\">Claim Your 50% Discount</a>\n            \n            <p><strong>What you get:</strong></p>\n            <p>✅ Unlimited bandwidth<br>\n            ✅ 100+ server locations<br>\n            ✅ 24/7 customer support<br>\n            ✅ 30-day money-back guarantee</p>\n            \n            <p><em>No coupon code needed - discount applied automatically!</em></p>\n        </div>\n        <div class=\"footer\">\n            <p>This offer is exclusive to our subscribers</p>\n            <p><a href=\"{unsubscribe_url}\" style=\"color: #a4b0be;\">Unsubscribe</a></p>\n        </div>\n    </div>', 'html', 'promotion', 1, '2025-11-12 17:46:27', '2025-11-12 17:46:27', 1),
(25, 'Welcome Email', 'Welcome to {website_name}!', '<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><style>body{font-family:Arial,sans-serif;margin:0;padding:20px;background:#f4f4f4}.container{max-width:600px;margin:0 auto;background:white;padding:30px;border-radius:8px}</style></head><body><div class=\"container\"><h1>Welcome {name}!</h1><p>Thank you for joining us. We are excited to have you aboard!</p><p>Best regards,<br>The Team</p></div></body></html>', 'html', 'welcome', 0, '2025-11-12 21:21:50', '2025-11-12 21:21:50', 1),
(26, 'Newsletter Template', 'Monthly Newsletter - {website_name}', '<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><style>body{font-family:Arial,sans-serif;margin:0;padding:20px;background:#f4f4f4}.container{max-width:600px;margin:0 auto;background:white;padding:30px;border-radius:8px}.header{background:#007bff;color:white;padding:20px;text-align:center;border-radius:8px 8px 0 0}</style></head><body><div class=\"container\"><div class=\"header\"><h1>📰 Monthly Newsletter</h1></div><div style=\"padding:20px\"><p>Hello {name},</p><p>Here are the latest updates from our team...</p><p>Best regards,<br>The Newsletter Team</p></div></div></body></html>', 'html', 'newsletter', 0, '2025-11-12 21:21:50', '2025-11-12 21:21:50', 1),
(27, 'Promotion Email', 'Special Offer Just for You!', '<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><style>body{font-family:Arial,sans-serif;margin:0;padding:20px;background:#f4f4f4}.container{max-width:600px;margin:0 auto;background:white;padding:30px;border-radius:8px}.promo{background:#28a745;color:white;padding:20px;text-align:center;border-radius:8px;margin:20px 0}</style></head><body><div class=\"container\"><h1>🎉 Special Offer!</h1><div class=\"promo\"><h2>50% OFF</h2><p>Limited time offer for {name}</p></div><p>Don\'t miss out on this amazing deal!</p><p>Best regards,<br>The Sales Team</p></div></body></html>', 'html', 'promotion', 0, '2025-11-12 21:21:50', '2025-11-12 21:21:50', 1),
(28, 'Welcome Email', 'Welcome to {website_name}!', '<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><style>body{font-family:Arial,sans-serif;margin:0;padding:20px;background:#f4f4f4}.container{max-width:600px;margin:0 auto;background:white;padding:30px;border-radius:8px}</style></head><body><div class=\"container\"><h1>Welcome {name}!</h1><p>Thank you for joining us. We are excited to have you aboard!</p><p>Best regards,<br>The Team</p></div></body></html>', 'html', 'welcome', 0, '2025-11-12 22:01:16', '2025-11-12 22:01:16', 1),
(29, 'Newsletter Template', 'Monthly Newsletter - {website_name}', '<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><style>body{font-family:Arial,sans-serif;margin:0;padding:20px;background:#f4f4f4}.container{max-width:600px;margin:0 auto;background:white;padding:30px;border-radius:8px}.header{background:#007bff;color:white;padding:20px;text-align:center;border-radius:8px 8px 0 0}</style></head><body><div class=\"container\"><div class=\"header\"><h1>📰 Monthly Newsletter</h1></div><div style=\"padding:20px\"><p>Hello {name},</p><p>Here are the latest updates from our team...</p><p>Best regards,<br>The Newsletter Team</p></div></div></body></html>', 'html', 'newsletter', 0, '2025-11-12 22:01:16', '2025-11-12 22:01:16', 1),
(30, 'Promotion Email', 'Special Offer Just for You!', '<!DOCTYPE html><html><head><meta charset=\"UTF-8\"><style>body{font-family:Arial,sans-serif;margin:0;padding:20px;background:#f4f4f4}.container{max-width:600px;margin:0 auto;background:white;padding:30px;border-radius:8px}.promo{background:#28a745;color:white;padding:20px;text-align:center;border-radius:8px;margin:20px 0}</style></head><body><div class=\"container\"><h1>🎉 Special Offer!</h1><div class=\"promo\"><h2>50% OFF</h2><p>Limited time offer for {name}</p></div><p>Don\'t miss out on this amazing deal!</p><p>Best regards,<br>The Sales Team</p></div></body></html>', 'html', 'promotion', 0, '2025-11-12 22:01:16', '2025-11-12 22:01:16', 1);

-- --------------------------------------------------------

--
-- Table structure for table `freeze_request`
--

CREATE TABLE `freeze_request` (
  `id` int NOT NULL,
  `content` varchar(128) NOT NULL DEFAULT 'Freeze Request',
  `status` enum('pending','approved') NOT NULL DEFAULT 'pending',
  `client_id` int NOT NULL,
  `client_name` varchar(128) NOT NULL,
  `client_ipaddress` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `request_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `reseller_id` int NOT NULL,
  `reseller_name` varchar(128) NOT NULL,
  `reseller_ipaddress` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `process_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `json_update`
--

CREATE TABLE `json_update` (
  `id` int NOT NULL,
  `name` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `type` int NOT NULL,
  `encryption` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `json_update`
--

INSERT INTO `json_update` (`id`, `name`, `type`, `encryption`, `date`) VALUES
(3, 'z', 1, 'fada3241868382638688', '2026-04-13 08:34:48'),
(4, 'Hi7rru', 1, '86210f600c3fafef6fdf', '2026-04-19 03:09:58');

-- --------------------------------------------------------

--
-- Table structure for table `limit_logs`
--

CREATE TABLE `limit_logs` (
  `id` int NOT NULL,
  `id_user` int NOT NULL,
  `client_id` int NOT NULL,
  `username` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `subadmin_limit` int NOT NULL DEFAULT '0',
  `reseller_limit` int NOT NULL DEFAULT '0',
  `subreseller_limit` int NOT NULL DEFAULT '0',
  `client_limit` int NOT NULL,
  `user_level` enum('normal','reseller','subreseller','subadmin','admin','superadmin') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'normal',
  `logs_date` datetime NOT NULL,
  `ipaddress` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `limit_registration`
--

CREATE TABLE `limit_registration` (
  `id` int NOT NULL,
  `ipaddress` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `regtime` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `ip` varchar(20) DEFAULT NULL,
  `attempts` int DEFAULT '0',
  `lastlogin` datetime DEFAULT NULL,
  `timestamp` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `login_attempts_logs`
--

CREATE TABLE `login_attempts_logs` (
  `id` int NOT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `user_name` varchar(64) NOT NULL,
  `logs_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `login_banned_ip`
--

CREATE TABLE `login_banned_ip` (
  `id` int NOT NULL,
  `attempts` int NOT NULL DEFAULT '0',
  `ip` varchar(128) NOT NULL DEFAULT '0.0.0.0',
  `logs_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `nas`
--

CREATE TABLE `nas` (
  `id` int NOT NULL,
  `nasname` varchar(128) NOT NULL,
  `shortname` varchar(32) DEFAULT NULL,
  `type` varchar(30) DEFAULT 'other',
  `ports` int DEFAULT NULL,
  `secret` varchar(60) NOT NULL DEFAULT 'secret',
  `server` varchar(64) DEFAULT NULL,
  `community` varchar(50) DEFAULT NULL,
  `description` varchar(200) DEFAULT 'RADIUS Client'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int NOT NULL,
  `title` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `filename` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `type` int NOT NULL,
  `date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `page_content`
--

CREATE TABLE `page_content` (
  `id` int NOT NULL,
  `page_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `section_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `section_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `section_type` enum('text','textarea','html') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'text',
  `is_active` tinyint(1) DEFAULT '1',
  `section_order` int DEFAULT '1',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `page_content`
--

INSERT INTO `page_content` (`id`, `page_name`, `section_name`, `section_content`, `section_type`, `is_active`, `section_order`, `created_date`, `updated_date`) VALUES
(1, 'site-info', 'hero_title', 'Saudi Arabia SIM Companie', 'text', 1, 1, '2025-11-13 15:38:58', '2025-11-13 15:38:58'),
(2, 'site-info', 'main_description', '<font color=\"#ff0000\">Choose from premium telecom services offering high-speed internet, unlimited calls, and exclusive packages. Compare</font> <span style=\"color: #28a745; font-weight: bold;\">FREE plans</span> and <span style=\"color: #007bff; font-weight: bold;\">PREMIUM packages</span> <font color=\"#9c00ff\">from leading operators across the Kingdom.</font>', 'text', 1, 1, '2025-11-13 15:38:58', '2025-11-13 16:25:06'),
(3, 'site-info', 'stc_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:40'),
(4, 'site-info', 'stc_package_title', 'Stc Plan', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(5, 'site-info', 'stc_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(6, 'site-info', 'stc_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(7, 'site-info', 'mobily_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(8, 'site-info', 'mobily_package_title', 'Mobily Plan', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(9, 'site-info', 'mobily_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(10, 'site-info', 'mobily_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(11, 'site-info', 'zain_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(12, 'site-info', 'zain_package_title', 'Zain Plan', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(13, 'site-info', 'zain_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(14, 'site-info', 'zain_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(15, 'site-info', 'virgin_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(16, 'site-info', 'virgin_package_title', 'Virgin Plan', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(17, 'site-info', 'virgin_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(18, 'site-info', 'virgin_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(19, 'site-info', 'lebara_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(20, 'site-info', 'lebara_package_title', 'Lebara Plan', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(21, 'site-info', 'lebara_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:49', '2025-11-13 16:57:41'),
(22, 'site-info', 'lebara_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:41'),
(23, 'site-info', 'friendi_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:41'),
(24, 'site-info', 'friendi_package_title', 'Friendi Plan', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:41'),
(25, 'site-info', 'friendi_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:41'),
(26, 'site-info', 'friendi_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:41'),
(27, 'site-info', 'redbull_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:41'),
(28, 'site-info', 'redbull_package_title', 'Redbull Plan', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(29, 'site-info', 'redbull_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(30, 'site-info', 'redbull_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(31, 'site-info', 'salam_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(32, 'site-info', 'salam_package_title', 'Salam Plan', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(33, 'site-info', 'salam_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(34, 'site-info', 'salam_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(35, 'site-info', 'jawwy_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(36, 'site-info', 'jawwy_package_title', 'Jawwy Plan', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(37, 'site-info', 'jawwy_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(38, 'site-info', 'jawwy_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(39, 'site-info', 'yaqoot_package_type', 'FREE', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(40, 'site-info', 'yaqoot_package_title', 'Yaqoot Plan', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(41, 'site-info', 'yaqoot_package_description', 'Package description', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42'),
(42, 'site-info', 'yaqoot_package_features', 'Package features', 'text', 1, 1, '2025-11-13 16:30:50', '2025-11-13 16:57:42');

-- --------------------------------------------------------

--
-- Table structure for table `page_customizations`
--

CREATE TABLE `page_customizations` (
  `id` int NOT NULL,
  `page_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `customization_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `customization_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` int NOT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `page_customizations`
--

INSERT INTO `page_customizations` (`id`, `page_name`, `customization_type`, `customization_data`, `user_id`, `created_date`, `updated_date`) VALUES
(1, 'site-info', 'design', '{\"colorScheme\":\"blue\",\"fontFamily\":\"nunito, \\\"segoe ui\\\", arial\",\"fontSize\":\"14\",\"cardOpacity\":\"1\",\"animationSpeed\":\"3\"}', 1, '2025-11-13 15:39:22', '2025-11-13 17:52:43'),
(2, 'site-info', 'layout', '{\"layoutType\":\"grid\",\"cardSpacing\":\"20\",\"containerWidth\":\"100\"}', 1, '2025-11-13 15:40:43', '2025-11-13 17:52:43');

-- --------------------------------------------------------

--
-- Table structure for table `radacct`
--

CREATE TABLE `radacct` (
  `radacctid` bigint NOT NULL,
  `acctsessionid` varchar(64) NOT NULL DEFAULT '',
  `acctuniqueid` varchar(32) NOT NULL DEFAULT '',
  `username` varchar(64) NOT NULL DEFAULT '',
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `realm` varchar(64) DEFAULT '',
  `nasipaddress` varchar(15) NOT NULL DEFAULT '',
  `nasportid` varchar(15) DEFAULT NULL,
  `nasporttype` varchar(32) DEFAULT NULL,
  `acctstarttime` datetime DEFAULT NULL,
  `acctstoptime` datetime DEFAULT NULL,
  `acctsessiontime` int UNSIGNED DEFAULT NULL,
  `acctauthentic` varchar(32) DEFAULT NULL,
  `connectinfo_start` varchar(50) DEFAULT NULL,
  `connectinfo_stop` varchar(50) DEFAULT NULL,
  `acctinputoctets` bigint DEFAULT NULL,
  `acctoutputoctets` bigint DEFAULT NULL,
  `calledstationid` varchar(50) NOT NULL DEFAULT '',
  `callingstationid` varchar(50) NOT NULL DEFAULT '',
  `acctterminatecause` varchar(32) NOT NULL DEFAULT '',
  `servicetype` varchar(32) DEFAULT NULL,
  `framedprotocol` varchar(32) DEFAULT NULL,
  `framedipaddress` varchar(15) NOT NULL DEFAULT '',
  `acctstartdelay` int UNSIGNED DEFAULT NULL,
  `acctstopdelay` int UNSIGNED DEFAULT NULL,
  `xascendsessionsvrkey` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `radcheck`
--

CREATE TABLE `radcheck` (
  `id` int UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '==',
  `value` varchar(253) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `radcheck`
--

INSERT INTO `radcheck` (`id`, `username`, `attribute`, `op`, `value`) VALUES
(46, '27889', 'Cleartext-Password', ':=', '89176'),
(47, '96859', 'Cleartext-Password', ':=', '78734'),
(34, 'cjju1', 'Cleartext-Password', ':=', '281426'),
(35, 'cjju2', 'Cleartext-Password', ':=', '923883'),
(36, 'cjju3', 'Cleartext-Password', ':=', '567890'),
(37, 'cjju4', 'Cleartext-Password', ':=', '71852'),
(38, 'cjju5', 'Cleartext-Password', ':=', '218504'),
(39, 'cjju6', 'Cleartext-Password', ':=', '793442'),
(40, 'cjju7', 'Cleartext-Password', ':=', '613059'),
(41, 'cjju8', 'Cleartext-Password', ':=', '13957'),
(42, 'cjju9', 'Cleartext-Password', ':=', '704068'),
(43, 'cjju10', 'Cleartext-Password', ':=', '629226'),
(48, '74278', 'Cleartext-Password', ':=', '59367'),
(50, '92078', 'Cleartext-Password', ':=', '55260'),
(51, '71831', 'Cleartext-Password', ':=', '31089');

-- --------------------------------------------------------

--
-- Table structure for table `radgroupcheck`
--

CREATE TABLE `radgroupcheck` (
  `id` int UNSIGNED NOT NULL,
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '==',
  `value` varchar(253) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `radgroupreply`
--

CREATE TABLE `radgroupreply` (
  `id` int UNSIGNED NOT NULL,
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '=',
  `value` varchar(253) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `radpostauth`
--

CREATE TABLE `radpostauth` (
  `id` int NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `pass` varchar(64) NOT NULL DEFAULT '',
  `reply` varchar(32) NOT NULL DEFAULT '',
  `authdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `radreply`
--

CREATE TABLE `radreply` (
  `id` int UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '=',
  `value` varchar(253) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `radusergroup`
--

CREATE TABLE `radusergroup` (
  `username` varchar(64) NOT NULL DEFAULT '',
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `priority` int NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `recovery_logs`
--

CREATE TABLE `recovery_logs` (
  `id` int NOT NULL,
  `recovery_menu` varchar(255) NOT NULL,
  `recovery_ipaddress` varchar(15) NOT NULL DEFAULT '0.0.0.0',
  `recovery_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `reloadduration_logs`
--

CREATE TABLE `reloadduration_logs` (
  `id` int NOT NULL,
  `duration_id` int NOT NULL,
  `duration_id2` int NOT NULL,
  `duration_username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `duration_item` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `duration_date` datetime NOT NULL,
  `duration_type` enum('premium','vip','private') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'premium',
  `ipaddress` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reseller_applications`
--

CREATE TABLE `reseller_applications` (
  `id` int NOT NULL,
  `business_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `country` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `website` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `experience` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `expected_sales` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','under_review') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'pending',
  `admin_notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `applied_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `reviewed_date` datetime DEFAULT NULL,
  `reviewed_by` int DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_agent` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `reseller_applications`
--

INSERT INTO `reseller_applications` (`id`, `business_name`, `full_name`, `email`, `username`, `password`, `phone`, `country`, `website`, `experience`, `expected_sales`, `message`, `status`, `admin_notes`, `applied_date`, `reviewed_date`, `reviewed_by`, `ip_address`, `user_agent`) VALUES
(5, 'azimxxx', 'Anoarul Azimxxx', 'ghadeeralemaarcse@gmail.com', 'azimkawsar', '$2y$10$qcwnzlvOiCHDinO8tJO5Qua8Rm0fvFF0WDm6ehSrd21e6uZTz99mO', '0598126772', 'SA', 'https://mancaberone.com', 'intermediate', '51-100', 'cccccccccccc', 'approved', 'Approved and reseller account created (Username: azimkawsar)', '2025-11-14 17:37:37', '2025-11-14 17:38:59', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(6, 'azim', 'Anoarul Azim', 'ghadeeralemaarce@gmail.com', 'reseller4', '$2y$10$Dprkvn1KWEpZs40TzcPL.OwFXhFJfMPKP9gdbn7/nAvMLKx0EgpS.', '0598126771', 'SA', 'Voillom.com', 'intermediate', '51-100', 'xxxx', 'approved', 'Approved and reseller account created (Username: reseller4)', '2025-11-14 17:38:34', '2025-11-14 17:40:11', 1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36');

-- --------------------------------------------------------

--
-- Table structure for table `reseller_settings`
--

CREATE TABLE `reseller_settings` (
  `id` int NOT NULL,
  `setting_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `setting_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `updated_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `reseller_settings`
--

INSERT INTO `reseller_settings` (`id`, `setting_name`, `setting_value`, `updated_date`) VALUES
(1, 'email_notifications', '1', '2025-11-14 14:02:28'),
(2, 'auto_approval', '0', '2025-11-14 14:02:28'),
(3, 'admin_email', 'vollamltd@gmail.com', '2025-11-14 17:36:06'),
(4, 'welcome_email_subject', 'Welcome to Our Reseller Program', '2025-11-14 14:02:28'),
(5, 'welcome_email_body', '<p>Dear {name},</p><p>Welcome to our reseller program! Your application has been approved.</p><p><strong>Your reseller account details:</strong><br>Username: {username}<br>Password: {password}<br>Reseller Panel: {reseller_url}</p><p style=\"font-family: &quot;Hind Siliguri&quot;, Arial, sans-serif; line-height: 1.7;\" class=\"bangla-text\">আপনাকে স্বাগতম! আপনার রিসেলার আবেদন অনুমোদিত হয়েছে।</p><p>Best regards,<br>The Team</p>', '2025-11-14 14:02:29'),
(6, 'approval_email_subject', 'Reseller Application Approved', '2025-11-14 14:02:29'),
(7, 'approval_email_body', '<p>Dear {name},</p><p>Congratulations! Your reseller application for <strong>{business_name}</strong> has been approved.</p><p style=\"font-family: &quot;Hind Siliguri&quot;, Arial, sans-serif; line-height: 1.7;\" class=\"bangla-text\">অভিনন্দন! আপনার রিসেলার আবেদন অনুমোদিত হয়েছে।</p><p>We will contact you shortly with your account details.</p><p>Best regards,<br>The Team</p>', '2025-11-14 14:02:29'),
(8, 'rejection_email_subject', 'Reseller Application Update', '2025-11-14 14:02:29'),
(9, 'rejection_email_body', '<p>Dear {name},</p><p>Thank you for your interest in our reseller program.</p><p>After careful review, we are unable to approve your application at this time.</p><p><strong>Reason:</strong> {reason}</p><p style=\"font-family: &quot;Hind Siliguri&quot;, Arial, sans-serif; line-height: 1.7;\" class=\"bangla-text\">দুঃখিত, আপনার আবেদন এই মুহূর্তে অনুমোদন করা সম্ভব হয়নি।</p><p>You may reapply in the future.</p><p>Best regards,<br>The Team</p>', '2025-11-14 14:02:29'),
(10, 'smtp_enabled', '1', '2025-11-14 14:02:28'),
(11, 'smtp_host', 'smtp.gmail.com', '2025-11-14 14:02:28'),
(12, 'smtp_port', '587', '2025-11-14 14:02:28'),
(13, 'smtp_security', 'tls', '2025-11-14 14:02:28'),
(14, 'smtp_username', 'datasoftcaresales@gmail.com', '2025-11-14 14:02:28'),
(15, 'smtp_password', 'ffhgafnyzwyinujy', '2025-11-14 14:02:28'),
(16, 'smtp_from_email', 'datasoftcaresales@gmail.com', '2025-11-14 14:02:28'),
(17, 'smtp_from_name', 'VPN Panel', '2025-11-14 14:02:28'),
(27, 'gmail_username', 'datasoftcaresales@gmail.com', '2025-11-14 14:02:28'),
(26, 'gmail_enabled', '0', '2025-11-14 14:02:28'),
(18, 'bulk_email_enabled', '1', '2025-11-12 14:37:43'),
(19, 'bulk_email_per_batch', '50', '2025-11-12 14:37:43'),
(20, 'bulk_email_delay', '5', '2025-11-12 14:37:43'),
(21, 'bulk_email_from_name', 'VPN Panel', '2025-11-12 14:37:43'),
(22, 'bulk_email_reply_to', '', '2025-11-12 14:37:43'),
(23, 'email_tracking_enabled', '1', '2025-11-12 14:37:43'),
(24, 'email_unsubscribe_enabled', '1', '2025-11-12 14:37:43'),
(25, 'smtp_type', 'gmail', '2025-11-14 14:02:28'),
(28, 'gmail_from_name', 'VPN Panel System', '2025-11-14 14:02:28'),
(29, 'webmail_host', 'mail.coxsbd.com', '2025-11-14 14:02:28'),
(30, 'webmail_port', '587', '2025-11-14 14:02:28'),
(31, 'webmail_security', 'tls', '2025-11-14 14:02:28'),
(32, 'webmail_username', 'info@coxsbd.com', '2025-11-14 14:02:28'),
(33, 'webmail_password', '', '2025-11-14 14:02:28'),
(34, 'webmail_from_name', 'VPN Panel', '2025-11-14 14:02:28');

-- --------------------------------------------------------

--
-- Table structure for table `security_logs`
--

CREATE TABLE `security_logs` (
  `id` int NOT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `timestamp` int NOT NULL,
  `event_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `request_uri` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `security_logs`
--

INSERT INTO `security_logs` (`id`, `ip_address`, `timestamp`, `event_type`, `details`, `user_agent`, `request_uri`) VALUES
(32, '::1', 1765149073, 'FAILED_LOGIN', 'Username: coxsbd', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(33, '::1', 1765149075, 'FAILED_LOGIN', 'Username: coxsbd', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(34, '::1', 1765149078, 'FAILED_LOGIN', 'Username: coxsbd', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(35, '::1', 1765149079, 'FAILED_LOGIN', 'Username: coxsbd', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(36, '::1', 1765149081, 'FAILED_LOGIN', 'Username: coxsbd', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(37, '::1', 1765149082, 'LOGIN_LOCKOUT', 'Username: coxsbd, IP: ::1, Attempts: 5', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(38, '::1', 1765149102, 'LOGIN_LOCKOUT', 'Username: admin, IP: ::1, Attempts: 5', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(39, '::1', 1765271034, 'FAILED_LOGIN', 'Username: coxsbd', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(40, '103.31.155.229', 1776055145, 'FAILED_LOGIN', 'Username: developer', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(41, '37.111.211.166', 1776058990, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(42, '37.111.211.166', 1776058995, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(43, '37.111.211.166', 1776059001, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(44, '37.111.211.166', 1776059007, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(45, '37.111.211.166', 1776059009, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(46, '163.227.63.213', 1776059021, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(47, '163.227.63.213', 1776059025, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(48, '178.104.163.30', 1776059551, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(49, '159.195.43.39', 1776060348, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(50, '159.195.43.39', 1776060350, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(51, '159.195.43.39', 1776060362, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(52, '159.195.43.39', 1776060400, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(53, '49.13.172.60', 1776060662, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(54, '94.59.193.185', 1776061245, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(55, '94.59.193.185', 1776061262, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(56, '176.18.27.196', 1776062440, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(57, '176.18.27.196', 1776062445, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(58, '77.238.235.12', 1776062590, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(59, '37.111.211.166', 1776062998, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(60, '103.181.181.26', 1776063172, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(61, '103.242.20.170', 1776063666, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36 Edg/146.0.0.0', '/serverside/forms/login.php'),
(62, '94.99.17.247', 1776065450, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(63, '152.53.123.16', 1776067443, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php'),
(64, '103.31.155.241', 1776079399, 'FAILED_LOGIN', 'Username: admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36 Edg/146.0.0.0', '/serverside/forms/login.php'),
(65, '103.31.155.243', 1776433179, 'FAILED_LOGIN', 'Username: developer', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', '/serverside/forms/login.php'),
(66, '103.31.155.240', 1776521158, 'FAILED_LOGIN', 'Username: developer', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36', '/serverside/forms/login.php');

-- --------------------------------------------------------

--
-- Table structure for table `security_settings`
--

CREATE TABLE `security_settings` (
  `id` int NOT NULL,
  `setting_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `setting_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `security_settings`
--

INSERT INTO `security_settings` (`id`, `setting_name`, `setting_value`, `updated_at`) VALUES
(1, 'ddos_threshold', '100', '2025-12-07 22:33:21'),
(2, 'max_login_attempts', '5', '2025-12-07 22:33:21'),
(3, 'lockout_time', '900', '2025-12-07 22:33:21'),
(4, 'enable_csrf', '1', '2025-12-07 22:33:21'),
(5, 'enable_xss_protection', '1', '2025-12-07 22:33:21'),
(6, 'enable_sql_injection_protection', '1', '2025-12-07 22:33:21'),
(7, 'enable_file_upload_validation', '1', '2025-12-07 22:33:21'),
(8, 'blocked_user_agents', 'bot,crawler,spider,scraper', '2025-12-07 22:33:21'),
(9, 'whitelist_ips', '127.0.0.1,::1', '2025-12-07 22:33:21');

-- --------------------------------------------------------

--
-- Table structure for table `server_list`
--

CREATE TABLE `server_list` (
  `server_id` int NOT NULL,
  `server_name` varchar(255) NOT NULL,
  `server_ip` varchar(20) NOT NULL,
  `server_user` varchar(50) NOT NULL,
  `server_pass` varchar(255) NOT NULL,
  `flag` varchar(10) NOT NULL,
  `a_id` varchar(55) NOT NULL,
  `ns_id` varchar(55) NOT NULL,
  `auth_str` varchar(55) NOT NULL,
  `port_tcp` int NOT NULL,
  `port_udp` int NOT NULL,
  `port_ssh` int NOT NULL,
  `hysteria_port` int NOT NULL,
  `xray_port` int NOT NULL,
  `socksip_port` varchar(11) NOT NULL,
  `xray_tls` int NOT NULL,
  `xray_ntls` int NOT NULL,
  `slowdns_port` int NOT NULL,
  `ssh_port` int NOT NULL,
  `dropbear_port` int NOT NULL,
  `protocol` int NOT NULL,
  `online` int NOT NULL,
  `hysteria_online` int NOT NULL,
  `ssh_online` int NOT NULL,
  `cpu_model` varchar(55) NOT NULL,
  `distro` varchar(55) NOT NULL,
  `memory` varchar(50) NOT NULL,
  `uptime` varchar(30) NOT NULL,
  `disk` varchar(30) NOT NULL,
  `bandwidth` varchar(50) NOT NULL,
  `os` varchar(25) NOT NULL,
  `proto` varchar(30) NOT NULL,
  `tcpssl` varchar(25) NOT NULL,
  `udpssl` varchar(25) NOT NULL,
  `tcp_status` varchar(10) NOT NULL,
  `udp_status` varchar(10) NOT NULL,
  `ssl_status` varchar(10) NOT NULL,
  `squid_status` varchar(10) NOT NULL,
  `socket_status` varchar(10) NOT NULL,
  `hysteria_status` varchar(10) NOT NULL,
  `xray_status` varchar(10) NOT NULL,
  `slowdns_status` varchar(10) NOT NULL,
  `ssh_status` varchar(10) NOT NULL,
  `dropbear_status` varchar(10) NOT NULL,
  `socksip_status` varchar(11) NOT NULL,
  `xray_vmess` varchar(11) NOT NULL,
  `xray_vless` varchar(11) NOT NULL,
  `xray_trojan` varchar(11) NOT NULL,
  `xray_ss` varchar(11) NOT NULL,
  `tcp` varchar(25) NOT NULL,
  `udp` varchar(25) NOT NULL,
  `squid` varchar(25) NOT NULL,
  `socket` varchar(25) NOT NULL,
  `status` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `site_options`
--

CREATE TABLE `site_options` (
  `id` int NOT NULL,
  `email` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(155) NOT NULL,
  `logo` varchar(155) NOT NULL,
  `logo_status` int NOT NULL,
  `maintenance_status` int NOT NULL,
  `prefix_status` int NOT NULL,
  `prefix` varchar(50) NOT NULL,
  `trial_duration` int NOT NULL,
  `owner` varchar(50) NOT NULL,
  `theme` varchar(50) NOT NULL,
  `login_note` varchar(256) NOT NULL,
  `session_limit` int NOT NULL,
  `dns_prefix` varchar(155) NOT NULL,
  `dns_domain` varchar(155) NOT NULL,
  `dns_global` varchar(155) NOT NULL,
  `dns_zone` varchar(155) NOT NULL,
  `dns_email` varchar(155) NOT NULL,
  `site_status` int NOT NULL,
  `github_username` varchar(155) NOT NULL,
  `github_token` varchar(155) NOT NULL,
  `github_repo` varchar(255) DEFAULT NULL,
  `update_json` varchar(155) NOT NULL,
  `license` varchar(155) NOT NULL,
  `bak_to` varchar(155) NOT NULL,
  `bak_cc` varchar(155) NOT NULL,
  `otp_code` varchar(11) NOT NULL,
  `otp_id` varchar(11) NOT NULL,
  `otp_duration` int NOT NULL,
  `otp_rsnd` varchar(50) NOT NULL,
  `turnstile_key` varchar(55) NOT NULL,
  `turnstile_secret` varchar(55) NOT NULL,
  `hits` int NOT NULL,
  `whois_api` varchar(50) NOT NULL,
  `bandwidth_limit` bigint DEFAULT '0',
  `xray_limit` varchar(20) DEFAULT 'disabled',
  `bandwidth_value` decimal(10,2) DEFAULT '0.00',
  `bandwidth_unit` varchar(10) DEFAULT 'gb'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `site_options`
--

INSERT INTO `site_options` (`id`, `email`, `name`, `description`, `logo`, `logo_status`, `maintenance_status`, `prefix_status`, `prefix`, `trial_duration`, `owner`, `theme`, `login_note`, `session_limit`, `dns_prefix`, `dns_domain`, `dns_global`, `dns_zone`, `dns_email`, `site_status`, `github_username`, `github_token`, `github_repo`, `update_json`, `license`, `bak_to`, `bak_cc`, `otp_code`, `otp_id`, `otp_duration`, `otp_rsnd`, `turnstile_key`, `turnstile_secret`, `hits`, `whois_api`, `bandwidth_limit`, `xray_limit`, `bandwidth_value`, `bandwidth_unit`) VALUES
(1, 'coxsbd@gmail.com', 'DEMO PANEL', 'Fast and Secure', '1763767623.png', 1, 0, 0, 'vip', 1800, 'PANEL', 'purple', 'cW5vRi8vU1hsYVk0Um1vdXo3MTlmQT09', 99999, '', 'jaeAZs3OqOTM09ualc+kj6ultIa4wmvhf4aE54W1nJM=', 'j7urnNi7sbfbq9eRfqjJeKSp1pa8w5Whh6umpou4z46dyZ6tipR4jazTfuizupnJgt2Uk4a8vKq6oKSizcCAq9K/dp60ud3puomIrqy6u9yGvLq+zaeqkw==', 'kNG/Z9qqtdzL0r2Yfs6PoJeW2qe5wIy6fIeZ5ZWo5MS3louDhruDeK6Mha2sqbvBfN16w4Wswaq5sMKgv6iWssODisWekr+lu8Gcw66ToJ2Jo5jHw82qkw==', 'is27ftm5k9vJqcR2hJHFdp6DvIa+nZq2f5p07YbMuYurybCnlqamiZjGgqyoqLvDk8+gf5a5z4Gnroat', 1, 'azimaxas', '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', 'coxsbd.com', 'https://coxsbd.com', 'AZIM-ACE17199-1A7E8B17', 'coxsbd@gmail.com', 'coxsbd@gmail.com', '', '', 0, '', '0x4AAAAAAB12VfPkRndAiEbc', '0x4AAAAAAB12VR34JJpaXjqrHy5D8f0FA0A', 430, 'F8PVAPHDTFSHEhHHJmH06uyJX5lQYtxB', 1153434, 'enabled', 1.10, 'mb');

-- --------------------------------------------------------

--
-- Table structure for table `slider_images`
--

CREATE TABLE `slider_images` (
  `id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `link_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sort_order` int DEFAULT '1',
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider_images`
--

INSERT INTO `slider_images` (`id`, `title`, `description`, `image_url`, `link_url`, `sort_order`, `status`, `created_at`, `updated_at`) VALUES
(1, '50% offer', 'Reseller Get this offer', 'slider_1765056736_6934a0e08c715.jpg', 'https://coxsbd.com', 1, 'active', '2025-12-06 21:08:22', '2025-12-06 21:32:16'),
(3, 'Best Speed Server', '100+ Server', 'slider_1765056833_6934a141d9c6d.jpg', 'https://coxsbd.com', 3, 'active', '2025-12-06 21:24:31', '2025-12-06 21:33:53'),
(4, 'Premium VPN', 'High Speed VPN', 'slider_1765056790_6934a116cfdb5.jpg', 'https://coxsbd.com', 2, 'active', '2025-12-06 21:28:39', '2025-12-06 21:33:10');

-- --------------------------------------------------------

--
-- Table structure for table `subscriber_config`
--

CREATE TABLE `subscriber_config` (
  `id` int NOT NULL,
  `subscriber_id` int NOT NULL,
  `email_frequency` enum('daily','weekly','monthly','never') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'weekly',
  `email_format` enum('html','text') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'html',
  `marketing_emails` tinyint(1) NOT NULL DEFAULT '1',
  `newsletter` tinyint(1) NOT NULL DEFAULT '1',
  `product_updates` tinyint(1) NOT NULL DEFAULT '1',
  `created_date` datetime NOT NULL,
  `updated_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `support_message`
--

CREATE TABLE `support_message` (
  `id` int NOT NULL,
  `ticket_id` int NOT NULL,
  `support_message` text NOT NULL,
  `support_id_user` int NOT NULL,
  `support_name` varchar(767) NOT NULL,
  `support_groupname` varchar(767) NOT NULL,
  `support_date` datetime NOT NULL,
  `support_ipaddress` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `support_ticket`
--

CREATE TABLE `support_ticket` (
  `id` int NOT NULL,
  `ticket_name` varchar(767) NOT NULL,
  `ticket_subject` varchar(767) NOT NULL,
  `ticket_message` text NOT NULL,
  `ticket_status` enum('open','customer-reply','answered','closed') NOT NULL,
  `ticket_date` datetime NOT NULL,
  `ticket_update` datetime NOT NULL,
  `ip_address` varchar(767) NOT NULL,
  `ticket_id_user` int NOT NULL,
  `ticket_groupname` varchar(767) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `suspension_logs`
--

CREATE TABLE `suspension_logs` (
  `id` int NOT NULL,
  `is_suspended` int NOT NULL,
  `client_id` int NOT NULL,
  `client_username` varchar(32) NOT NULL,
  `user_id` int NOT NULL,
  `username` varchar(32) NOT NULL,
  `offense` varchar(225) NOT NULL,
  `logs_date` datetime NOT NULL,
  `ipaddress` varchar(32) NOT NULL DEFAULT '0.0.0.0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `suspension_recovery_logs`
--

CREATE TABLE `suspension_recovery_logs` (
  `id` int NOT NULL,
  `client_id` int NOT NULL,
  `client_username` varchar(32) NOT NULL,
  `user_id` int NOT NULL,
  `username` varchar(32) NOT NULL,
  `suspend_date` datetime NOT NULL,
  `offense` varchar(225) NOT NULL,
  `logs_date` datetime NOT NULL,
  `is_unsuspended` int NOT NULL,
  `ipaddress` varchar(32) NOT NULL DEFAULT '0.0.0.0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `username_logs`
--

CREATE TABLE `username_logs` (
  `id` int NOT NULL,
  `old_username` varchar(50) NOT NULL,
  `new_username` varchar(50) NOT NULL,
  `old_level` varchar(64) NOT NULL,
  `new_level` varchar(64) NOT NULL,
  `old_upline` int NOT NULL,
  `new_upline` int NOT NULL,
  `client_id` int NOT NULL,
  `user_id` int NOT NULL,
  `logs_date` datetime NOT NULL,
  `ipaddress` varchar(32) NOT NULL DEFAULT '0.0.0.0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `user_id` int NOT NULL,
  `password` varchar(50) NOT NULL DEFAULT 'jho',
  `code` varchar(10) NOT NULL,
  `ss_id` varchar(64) NOT NULL,
  `ssl_id` varchar(50) NOT NULL DEFAULT 'ssl',
  `username_prefix` varchar(11) NOT NULL,
  `user_name` varchar(30) NOT NULL DEFAULT '',
  `user_pass` varchar(256) NOT NULL,
  `user_2fa` int NOT NULL,
  `user_2fa_otp` varchar(11) NOT NULL,
  `user_2fa_id` varchar(11) NOT NULL,
  `user_2fa_duration` int NOT NULL,
  `attribute` varchar(64) NOT NULL DEFAULT 'MD5-Password',
  `op` char(2) NOT NULL DEFAULT ':=',
  `auth_vpn` varchar(256) NOT NULL,
  `user_email` varchar(50) NOT NULL DEFAULT '',
  `mobile` varchar(20) DEFAULT NULL,
  `user_email_verified` int NOT NULL,
  `full_name` varchar(50) DEFAULT NULL,
  `regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ipaddress` varchar(50) NOT NULL DEFAULT '0.0.0.0',
  `lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `timestamp` int NOT NULL,
  `reset_code` varchar(255) NOT NULL DEFAULT '0',
  `is_groupname` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_freeze` tinyint(1) NOT NULL DEFAULT '1',
  `is_passchange` int NOT NULL,
  `passchange_duration` int NOT NULL,
  `last_freeze_date` datetime NOT NULL,
  `is_validated` tinyint(1) NOT NULL DEFAULT '0',
  `is_connected` int NOT NULL DEFAULT '0',
  `is_offense` int NOT NULL DEFAULT '0',
  `is_ban` int NOT NULL DEFAULT '1',
  `is_socksip` int NOT NULL,
  `user_group` int NOT NULL,
  `suspended_date` datetime NOT NULL,
  `duration` bigint NOT NULL DEFAULT '18000',
  `vip_duration` bigint NOT NULL,
  `is_vip` int NOT NULL DEFAULT '0',
  `private_duration` bigint NOT NULL DEFAULT '0',
  `is_private` tinyint(1) NOT NULL DEFAULT '0',
  `private_slot` int NOT NULL DEFAULT '0',
  `private_control` tinyint(1) NOT NULL DEFAULT '0',
  `credits` int NOT NULL DEFAULT '0',
  `upline` int NOT NULL DEFAULT '1',
  `login_status` enum('offline','online') NOT NULL DEFAULT 'offline',
  `last_active_time` datetime NOT NULL,
  `user_level` enum('normal','subreseller','reseller','administrator','subadmin','superadmin','bulk','trial','developer') NOT NULL,
  `status` enum('live','freeze','suspended','banned','vacation') NOT NULL DEFAULT 'live',
  `bytes_received` int NOT NULL,
  `bytes_sent` int NOT NULL,
  `bandwidth` int NOT NULL DEFAULT '0',
  `bandwidth_premium` int NOT NULL,
  `bandwidth_vip` int NOT NULL,
  `bandwidth_ph` int NOT NULL,
  `bandwidth_private` int NOT NULL,
  `bandwidth_free` int NOT NULL,
  `device_connected` int NOT NULL DEFAULT '0',
  `device_id` varchar(100) NOT NULL,
  `device_model` varchar(100) NOT NULL,
  `session` int NOT NULL,
  `active_address` varchar(25) NOT NULL,
  `active_date` datetime NOT NULL,
  `bandwidth_used` bigint UNSIGNED DEFAULT '0',
  `api_key` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`user_id`, `password`, `code`, `ss_id`, `ssl_id`, `username_prefix`, `user_name`, `user_pass`, `user_2fa`, `user_2fa_otp`, `user_2fa_id`, `user_2fa_duration`, `attribute`, `op`, `auth_vpn`, `user_email`, `mobile`, `user_email_verified`, `full_name`, `regdate`, `ipaddress`, `lastlogin`, `timestamp`, `reset_code`, `is_groupname`, `is_active`, `is_freeze`, `is_passchange`, `passchange_duration`, `last_freeze_date`, `is_validated`, `is_connected`, `is_offense`, `is_ban`, `is_socksip`, `user_group`, `suspended_date`, `duration`, `vip_duration`, `is_vip`, `private_duration`, `is_private`, `private_slot`, `private_control`, `credits`, `upline`, `login_status`, `last_active_time`, `user_level`, `status`, `bytes_received`, `bytes_sent`, `bandwidth`, `bandwidth_premium`, `bandwidth_vip`, `bandwidth_ph`, `bandwidth_private`, `bandwidth_free`, `device_connected`, `device_id`, `device_model`, `session`, `active_address`, `active_date`, `bandwidth_used`, `api_key`) VALUES
(1, 'hjhj', '405154310', '54090', 'any', '', 'admin', 'akU0ZW4zeU41S0tSKzVQODkrVUxSdz09', 0, 'LKRCAP0YN', 'SCK24IB6C', 600, 'MD5-Password', ':=', '7d63e2d9cb6bb0a19bf9d094b5fefae2', 'admin@localhost.com', NULL, 0, 'VPN Philippines', '2018-07-09 10:59:14', '46.224.11.130', '2026-04-21 14:55:49', 0, '0', 'superadmin', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 33696000, 1305000, 1, 1728000, 1, 0, 0, 1000, 1, 'online', '2026-04-21 14:55:49', 'superadmin', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, '9294a5b04fa380233079e139f38d54fc09103d252853807b42a6bf6adea42f15'),
(2, 'hjhj', '405154310', '54090', 'any', '', 'developer', 'akU0ZW4zeU41S0tSKzVQODkrVUxSdz09', 0, '', '', 0, 'MD5-Password', ':=', '0192023a7bbd73250516f069df18b500', 'coxsbd@gmail.com', NULL, 0, 'Vollam Developer', '2018-07-09 10:59:14', '103.31.155.240', '2026-04-18 20:06:08', 0, '0', 'developer', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 999999, 1305000, 1, 1728000, 1, 0, 0, 1000, 1, 'offline', '2026-04-18 20:06:08', 'developer', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58313, 'jho', '367838471', '', 'ssl', '', '27889', 'SW1BU3Q3OVVkT0F2dzRNWTAwdFJadz09', 0, '', '', 0, 'MD5-Password', ':=', 'e52e9fb32dd0ae6d51d9f1dda10e8cbc', '27889@gmail.com', NULL, 0, 'Normal User', '2026-04-15 08:04:25', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'normal', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58314, 'jho', '630783447', '', 'ssl', '', 'Rjgcc', 'bzU4NXNUSXRHaDAxcUJXdGdESHU2Zz09', 0, '', '', 0, 'MD5-Password', ':=', '8aa9c174ec75776c11c70f62e1fe3ba6', 'Rjgcc@email.com', NULL, 0, 'Reseller User', '2026-04-15 06:00:27', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'reseller', 1, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 2, 1, 'offline', '0000-00-00 00:00:00', 'reseller', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58315, 'jho', '732803054', '', 'ssl', '', '96859', 'NGNUZ3Y1SWxuRXJrZWxTSmJFNUk3Zz09', 0, '', '', 0, 'MD5-Password', ':=', 'c58b3602bbcd6ed3b777d13c5a215d23', '96859@gmail.com', NULL, 0, 'Normal User', '2026-04-15 06:53:44', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'normal', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58316, 'jho', '480018904', '', 'ssl', '', 'Kader', 'VWg4d3VIMUIzWjF6K29Yc1dITFV6QT09', 0, '', '', 0, 'MD5-Password', ':=', '202cb962ac59075b964b07152d234b70', 'Kader@email.com', NULL, 0, 'Reseller User', '2026-04-15 09:55:32', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'reseller', 1, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 10, 1, 'offline', '0000-00-00 00:00:00', 'reseller', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58301, 'jho', '514252240', '', 'ssl', 'cjju', 'cjju1', 'eUhiVGpRZGtwSHlJVmRxenJ1dWgwZz09', 0, '', '', 0, 'MD5-Password', ':=', '8a945b3d0f310aa69c509ad03b744a85', 'cjju641339gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58302, 'jho', '337199921', '', 'ssl', 'cjju', 'cjju2', 'V2gwcEVhaUpGS2cwalozWmVvU1QyUT09', 0, '', '', 0, 'MD5-Password', ':=', '2c969d34bdc1630e2f6d5341fb4889b6', 'cjju578566gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58303, 'jho', '226505744', '', 'ssl', 'cjju', 'cjju3', 'UXgvL2N4akJwTE5CSG9hYTRMZmtJdz09', 0, '', '', 0, 'MD5-Password', ':=', 'ba00819f263287af1ff0100c5a323355', 'cjju995301gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58304, 'jho', '681936747', '', 'ssl', 'cjju', 'cjju4', 'TFFua0dJVUhwTThIajh2L2xBUTAwUT09', 0, '', '', 0, 'MD5-Password', ':=', 'f7c512eb7665bf289ccf9608050e4bc3', 'cjju321394gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58305, 'jho', '427777497', '', 'ssl', 'cjju', 'cjju5', 'M2hPR1Z6V282N0VPTy9oK1R1N2FQQT09', 0, '', '', 0, 'MD5-Password', ':=', 'ba17162ff8e55da1d5736544cac10c7d', 'cjju556805gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58306, 'jho', '685653392', '', 'ssl', 'cjju', 'cjju6', 'eVdsL1cveW41NDNjQ2JXTnVtb3Vldz09', 0, '', '', 0, 'MD5-Password', ':=', 'c72d6d2197243d1ee065749eae89676a', 'cjju132829gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58307, 'jho', '293371221', '', 'ssl', 'cjju', 'cjju7', 'TE9mekEzT3Q3N20vWVh4amNRc3hQUT09', 0, '', '', 0, 'MD5-Password', ':=', 'a3ffe2b379871487460ffc272d7aea1a', 'cjju169637gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58308, 'jho', '942922913', '', 'ssl', 'cjju', 'cjju8', 'WHMwU040dU5FZXpCYkF5aWhYMG1Idz09', 0, '', '', 0, 'MD5-Password', ':=', 'd203bbe1b9e242a034b376bafda15a99', 'cjju563988gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58309, 'jho', '221002554', '', 'ssl', 'cjju', 'cjju9', 'QTR5SkVyUGRNZ2l2bkRwU2FCUm41Zz09', 0, '', '', 0, 'MD5-Password', ':=', 'd70213a3f74d75ea1a8d7be09b5c4e89', 'cjju473285gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58310, 'jho', '988027390', '', 'ssl', 'cjju', 'cjju10', 'Z3VSOGViQ0VJZUdwVmY5NGlIL0s2QT09', 0, '', '', 0, 'MD5-Password', ':=', '0c5b962c88ba420285ca03f92cef0fb5', 'cjju882313gmail.com', NULL, 0, 'Bulk User', '2026-04-13 12:55:46', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'bulk', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 67359, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'bulk', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58319, 'jho', '324526605', '', 'ssl', '', 'F7du', 'dmFzTG8xTnBTWkV0ODh2UGI1cSs5dz09', 0, '', '', 0, 'MD5-Password', ':=', '2fb544a21e8cb8768b80cc231ca2f691', 'F7du@email.com', NULL, 0, 'Reseller User', '2026-04-19 03:07:24', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'reseller', 1, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 2, 1, 'offline', '0000-00-00 00:00:00', 'reseller', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58317, 'jho', '268948238', '', 'ssl', '', '74278', 'VVI4dVl0bE14R3hzZUlHYllBeWhiUT09', 0, '', '', 0, 'MD5-Password', ':=', '33c0802ccd55c286e13ce5ea9598d710', '74278@gmail.com', NULL, 0, 'Normal User', '2026-04-19 03:06:30', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'normal', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58320, 'jho', '459648596', '', 'ssl', '', '92078', 'K01Vd1lkYi8xSWw0TjF3Zk52MUlCQT09', 0, '', '', 0, 'MD5-Password', ':=', '3413990173aaf782ccb35c3216c72efb', '92078@gmail.com', NULL, 0, 'Normal User', '2026-04-20 07:50:17', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'normal', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL),
(58321, 'jho', '376815911', '', 'ssl', '', '71831', 'eENObWxIZDJ4OElwN1dPbUc2ek9LZz09', 0, '', '', 0, 'MD5-Password', ':=', 'c73edcecd97f8e999b5cd937d5e6827e', '71831@gmail.com', NULL, 0, 'Normal User', '2026-04-21 02:02:56', '0.0.0.0', '0000-00-00 00:00:00', 0, '0', 'normal', 0, 0, 0, 0, '0000-00-00 00:00:00', 1, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', '0000-00-00 00:00:00', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users_delete`
--

CREATE TABLE `users_delete` (
  `id` int NOT NULL,
  `delete_timestamp` int NOT NULL,
  `user_id` int NOT NULL,
  `user_name` varchar(30) NOT NULL DEFAULT '',
  `user_pass` varchar(256) NOT NULL,
  `auth_vpn` varchar(256) NOT NULL,
  `user_email` varchar(50) NOT NULL DEFAULT '',
  `full_name` varchar(50) DEFAULT NULL,
  `regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ipaddress` varchar(50) NOT NULL DEFAULT '0.0.0.0',
  `lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `timestamp` int NOT NULL,
  `code` varchar(10) NOT NULL,
  `reset_code` varchar(255) NOT NULL DEFAULT '0',
  `is_groupname` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_freeze` tinyint(1) NOT NULL DEFAULT '1',
  `last_freeze_date` date NOT NULL,
  `is_validated` tinyint(1) NOT NULL DEFAULT '0',
  `is_connected` int NOT NULL DEFAULT '0',
  `is_offense` int NOT NULL DEFAULT '0',
  `is_ban` int NOT NULL DEFAULT '1',
  `suspended_date` datetime NOT NULL,
  `duration` bigint NOT NULL DEFAULT '7200',
  `vip_duration` bigint NOT NULL,
  `is_vip` int NOT NULL DEFAULT '0',
  `private_duration` bigint NOT NULL DEFAULT '0',
  `is_private` tinyint(1) NOT NULL DEFAULT '0',
  `private_slot` int NOT NULL DEFAULT '0',
  `private_control` tinyint(1) NOT NULL DEFAULT '0',
  `credits` int NOT NULL DEFAULT '0',
  `upline` int NOT NULL DEFAULT '1',
  `login_status` enum('offline','online') NOT NULL DEFAULT 'offline',
  `last_active_time` datetime NOT NULL,
  `user_level` enum('normal','subreseller','reseller','moderator','subadmin','superadmin','bulk','trial') NOT NULL,
  `status` enum('live','freeze','suspended','banned','vacation') NOT NULL DEFAULT 'live',
  `bandwidth` int NOT NULL DEFAULT '0',
  `bandwidth_premium` int NOT NULL,
  `bandwidth_vip` int NOT NULL,
  `bandwidth_ph` int NOT NULL,
  `bandwidth_private` int NOT NULL,
  `bandwidth_free` int NOT NULL,
  `device_connected` int NOT NULL DEFAULT '0',
  `device_id` varchar(100) NOT NULL,
  `device_model` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_delete`
--

INSERT INTO `users_delete` (`id`, `delete_timestamp`, `user_id`, `user_name`, `user_pass`, `auth_vpn`, `user_email`, `full_name`, `regdate`, `ipaddress`, `lastlogin`, `timestamp`, `code`, `reset_code`, `is_groupname`, `is_active`, `is_freeze`, `last_freeze_date`, `is_validated`, `is_connected`, `is_offense`, `is_ban`, `suspended_date`, `duration`, `vip_duration`, `is_vip`, `private_duration`, `is_private`, `private_slot`, `private_control`, `credits`, `upline`, `login_status`, `last_active_time`, `user_level`, `status`, `bandwidth`, `bandwidth_premium`, `bandwidth_vip`, `bandwidth_ph`, `bandwidth_private`, `bandwidth_free`, `device_connected`, `device_id`, `device_model`) VALUES
(9100, 1778782751, 58299, 'xxxxxxxx', 'THg3V2dQY3BBWS9mY3RmQkN2RTUzdz09', 'dcb740b2c2836cb11f707d63e6ac664f', 'xxxxxxxx@email.com', 'Reseller User', '2026-04-13 08:36:07', '0.0.0.0', '0000-00-00 00:00:00', 0, '580412519', '0', 'reseller', 1, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, 0, 1, 1, 'offline', '0000-00-00 00:00:00', 'reseller', 'live', 0, 0, 0, 0, 0, 0, 0, '', ''),
(9101, 1778782770, 58312, 'It13566', 'bFVJaGhsT29Pd1VMUG1yUkFZYUJGQT09', '92a69ed33c2cf792dc965b0b6b12300d', 'It13566@gmail.com', 'Normal User', '2026-04-14 10:10:29', '0.0.0.0', '0000-00-00 00:00:00', 0, '854200577', '0', 'normal', 0, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, '', ''),
(9102, 1778782775, 58311, '93433', 'andRT3JRY3MzbGd3SDFnQ1pnZTcxUT09', '94c5476f9b164809c51dbc6e8ccdeee1', '93433@gmail.com', 'Normal User', '2026-04-13 03:38:29', '0.0.0.0', '0000-00-00 00:00:00', 0, '567734638', '0', 'normal', 0, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, '', ''),
(9103, 1778782783, 58300, '57365', 'Y3JrYTNiVWNCeHZGSG0rWGM0WTlBZz09', 'bfa2cc382822c1a2b110ac28ef1a6aca', '57365@gmail.com', 'Normal User', '2026-04-13 12:47:36', '0.0.0.0', '0000-00-00 00:00:00', 0, '464471077', '0', 'normal', 0, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, '', ''),
(9104, 1778782788, 58298, '97916', 'OERNb2xUZFhMQ0tOR3NyakFHc2YxQT09', '63d196328512c582293ce6c845521bb6', '97916@gmail.com', 'Normal User', '2026-04-13 08:32:16', '0.0.0.0', '0000-00-00 00:00:00', 0, '711734041', '0', 'normal', 0, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 1, '', ''),
(9105, 1778782792, 58297, '25408', 'YTFTWUgrRnljT25HWTZhMDRVYjlhQT09', '3710f8d0f60702216ee4495fd76e4dd8', '25408@gmail.com', 'Normal User', '2026-04-13 08:04:37', '0.0.0.0', '0000-00-00 00:00:00', 0, '979862615', '0', 'normal', 0, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, '', ''),
(9106, 1779149369, 58318, 'dxplusdev', 'WThKS0dMK20vaW1XVWxic1lRYWR3UT09', '63d27b078520ddef4537068ee0953600', 'dxplusdev@gmail.com', 'Normal User', '2026-04-19 03:06:39', '0.0.0.0', '0000-00-00 00:00:00', 0, '957365998', '0', 'normal', 0, 0, '0000-00-00', 1, 0, 0, 0, '0000-00-00 00:00:00', 2592000, 0, 0, 0, 0, 0, 0, 0, 1, 'offline', '0000-00-00 00:00:00', 'normal', 'live', 0, 0, 0, 0, 0, 0, 0, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `users_profile`
--

CREATE TABLE `users_profile` (
  `id` int NOT NULL,
  `profile_id` int NOT NULL,
  `profile_fb` varchar(250) NOT NULL,
  `profile_address` varchar(255) NOT NULL,
  `profile_number` varchar(13) NOT NULL DEFAULT '0',
  `profile_image` varchar(255) NOT NULL,
  `first_name` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `last_name` varchar(55) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `bio_link` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `bdo` int NOT NULL DEFAULT '0',
  `bitcoin` int NOT NULL DEFAULT '0',
  `bpi` int NOT NULL DEFAULT '0',
  `cebuana` int NOT NULL DEFAULT '0',
  `gcash` int NOT NULL DEFAULT '0',
  `lbc` int NOT NULL DEFAULT '0',
  `lbp` int NOT NULL DEFAULT '0',
  `meetup` int NOT NULL DEFAULT '0',
  `mlkwartapadala` int NOT NULL DEFAULT '0',
  `palawanexpress` int NOT NULL DEFAULT '0',
  `paypal` int NOT NULL DEFAULT '0',
  `prepaidload` int NOT NULL DEFAULT '0',
  `rcbc` int NOT NULL DEFAULT '0',
  `rdperapadala` int NOT NULL DEFAULT '0',
  `smartmoney` int NOT NULL DEFAULT '0',
  `unionbank` int NOT NULL DEFAULT '0',
  `westernunion` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `users_profile`
--

INSERT INTO `users_profile` (`id`, `profile_id`, `profile_fb`, `profile_address`, `profile_number`, `profile_image`, `first_name`, `last_name`, `bio_link`, `bdo`, `bitcoin`, `bpi`, `cebuana`, `gcash`, `lbc`, `lbp`, `meetup`, `mlkwartapadala`, `palawanexpress`, `paypal`, `prepaidload`, `rcbc`, `rdperapadala`, `smartmoney`, `unionbank`, `westernunion`) VALUES
(1, 1, '', 'Saudi Arabia', '8801817554444', '1762851060.png', 'Vollam', 'Azim', 'OHRXfXKZQ', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 2, '', 'Saudi Arabia', '+880181755444', 'avatar-1.png', 'Azim', 'Developer', 'HKWfLXfbG', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15349, 58299, '', '', '', '', 'Reseller', 'Account', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15350, 58314, '', '', '', '', 'Reseller', 'Account', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15351, 58316, '', '', '', '', 'Reseller', 'Account', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15352, 58319, '', '', '', '', 'Reseller', 'Account', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `vouchers`
--

CREATE TABLE `vouchers` (
  `id` int NOT NULL,
  `code_name` varchar(50) NOT NULL,
  `user_id` int NOT NULL,
  `client_name` varchar(755) NOT NULL,
  `reseller_id` int NOT NULL,
  `reseller_name` varchar(64) NOT NULL,
  `is_qty` int NOT NULL DEFAULT '1',
  `is_used` int NOT NULL,
  `duration` bigint NOT NULL DEFAULT '0',
  `gen_date` datetime NOT NULL,
  `date_used` datetime NOT NULL,
  `category` enum('premium','vip','private') NOT NULL DEFAULT 'premium',
  `permission` tinyint(1) NOT NULL DEFAULT '0',
  `ipaddress` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `voucher_logs`
--

CREATE TABLE `voucher_logs` (
  `id` int NOT NULL,
  `code_name` varchar(50) NOT NULL,
  `user_id` int NOT NULL,
  `client_name` varchar(755) NOT NULL,
  `reseller_id` int NOT NULL,
  `reseller_name` varchar(64) NOT NULL,
  `is_qty` int NOT NULL DEFAULT '1',
  `is_used` int NOT NULL,
  `date_used` datetime NOT NULL,
  `is_date` date NOT NULL,
  `category` enum('premium','vip','private') NOT NULL DEFAULT 'premium'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_date` (`date`);

--
-- Indexes for table `ads_api_logs`
--
ALTER TABLE `ads_api_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `app_name` (`app_name`),
  ADD KEY `created_date` (`created_date`);

--
-- Indexes for table `ads_apps`
--
ALTER TABLE `ads_apps`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `app_name` (`app_name`),
  ADD UNIQUE KEY `package_name` (`package_name`);

--
-- Indexes for table `ads_revenue`
--
ALTER TABLE `ads_revenue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `app_id` (`app_id`),
  ADD KEY `app_name` (`app_name`),
  ADD KEY `date` (`date`);

--
-- Indexes for table `anti_ddos`
--
ALTER TABLE `anti_ddos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `api_keys`
--
ALTER TABLE `api_keys`
  ADD PRIMARY KEY (`key_id`),
  ADD UNIQUE KEY `api_key` (`api_key`);

--
-- Indexes for table `application`
--
ALTER TABLE `application`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `app_notices`
--
ALTER TABLE `app_notices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `attention`
--
ALTER TABLE `attention`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bandwidth_logs`
--
ALTER TABLE `bandwidth_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blocked_ips`
--
ALTER TABLE `blocked_ips`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_ip` (`ip_address`),
  ADD KEY `idx_blocked_until` (`blocked_until`);

--
-- Indexes for table `chat`
--
ALTER TABLE `chat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_id1` (`chat_id1`),
  ADD KEY `chat_id2` (`chat_id2`),
  ADD KEY `chat_status` (`chat_status`);

--
-- Indexes for table `cloudflare_domains`
--
ALTER TABLE `cloudflare_domains`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `conversion_logs`
--
ALTER TABLE `conversion_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `credits_logs`
--
ALTER TABLE `credits_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cronjob_banned_ip`
--
ALTER TABLE `cronjob_banned_ip`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cronjob_logs`
--
ALTER TABLE `cronjob_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deleted_app_logs`
--
ALTER TABLE `deleted_app_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deleted_logs`
--
ALTER TABLE `deleted_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dns`
--
ALTER TABLE `dns`
  ADD PRIMARY KEY (`dns_id`) USING BTREE;

--
-- Indexes for table `download`
--
ALTER TABLE `download`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `duration`
--
ALTER TABLE `duration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `duration_logs`
--
ALTER TABLE `duration_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_campaigns`
--
ALTER TABLE `email_campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `created_date` (`created_date`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_by` (`created_by`),
  ADD KEY `idx_created_date` (`created_date`);

--
-- Indexes for table `email_campaign_recipients`
--
ALTER TABLE `email_campaign_recipients`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `campaign_subscriber` (`campaign_id`,`subscriber_id`),
  ADD KEY `campaign_id` (`campaign_id`),
  ADD KEY `subscriber_id` (`subscriber_id`),
  ADD KEY `status` (`status`),
  ADD KEY `tracking_token` (`tracking_token`);

--
-- Indexes for table `email_subscribers`
--
ALTER TABLE `email_subscribers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `status` (`status`),
  ADD KEY `source` (`source`),
  ADD KEY `subscribed_date` (`subscribed_date`);

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `template_type` (`template_type`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `is_active` (`is_active`);

--
-- Indexes for table `freeze_request`
--
ALTER TABLE `freeze_request`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `json_update`
--
ALTER TABLE `json_update`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `limit_logs`
--
ALTER TABLE `limit_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `limit_registration`
--
ALTER TABLE `limit_registration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD KEY `idx_ip` (`ip`);

--
-- Indexes for table `login_attempts_logs`
--
ALTER TABLE `login_attempts_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login_banned_ip`
--
ALTER TABLE `login_banned_ip`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nas`
--
ALTER TABLE `nas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nasname` (`nasname`);

--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_content`
--
ALTER TABLE `page_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_page_name` (`page_name`),
  ADD KEY `idx_section_order` (`section_order`);

--
-- Indexes for table `page_customizations`
--
ALTER TABLE `page_customizations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_page_customization` (`page_name`,`customization_type`),
  ADD KEY `idx_page_name` (`page_name`),
  ADD KEY `idx_customization_type` (`customization_type`);

--
-- Indexes for table `radacct`
--
ALTER TABLE `radacct`
  ADD PRIMARY KEY (`radacctid`),
  ADD UNIQUE KEY `acctuniqueid` (`acctuniqueid`),
  ADD KEY `username` (`username`),
  ADD KEY `framedipaddress` (`framedipaddress`),
  ADD KEY `acctsessionid` (`acctsessionid`),
  ADD KEY `acctsessiontime` (`acctsessiontime`),
  ADD KEY `acctstarttime` (`acctstarttime`),
  ADD KEY `acctstoptime` (`acctstoptime`),
  ADD KEY `nasipaddress` (`nasipaddress`);

--
-- Indexes for table `radcheck`
--
ALTER TABLE `radcheck`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`(32));

--
-- Indexes for table `radgroupcheck`
--
ALTER TABLE `radgroupcheck`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groupname` (`groupname`(32));

--
-- Indexes for table `radgroupreply`
--
ALTER TABLE `radgroupreply`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groupname` (`groupname`(32));

--
-- Indexes for table `radpostauth`
--
ALTER TABLE `radpostauth`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `radreply`
--
ALTER TABLE `radreply`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`(32));

--
-- Indexes for table `radusergroup`
--
ALTER TABLE `radusergroup`
  ADD KEY `username` (`username`(32));

--
-- Indexes for table `recovery_logs`
--
ALTER TABLE `recovery_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reloadduration_logs`
--
ALTER TABLE `reloadduration_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reseller_applications`
--
ALTER TABLE `reseller_applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `username` (`username`),
  ADD KEY `status` (`status`),
  ADD KEY `applied_date` (`applied_date`);

--
-- Indexes for table `reseller_settings`
--
ALTER TABLE `reseller_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_name` (`setting_name`);

--
-- Indexes for table `security_logs`
--
ALTER TABLE `security_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ip_timestamp` (`ip_address`,`timestamp`),
  ADD KEY `idx_event_type` (`event_type`),
  ADD KEY `idx_timestamp` (`timestamp`);

--
-- Indexes for table `security_settings`
--
ALTER TABLE `security_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_setting` (`setting_name`);

--
-- Indexes for table `server_list`
--
ALTER TABLE `server_list`
  ADD PRIMARY KEY (`server_id`),
  ADD KEY `idx_server_ip` (`server_ip`),
  ADD KEY `idx_proto` (`proto`);

--
-- Indexes for table `site_options`
--
ALTER TABLE `site_options`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `slider_images`
--
ALTER TABLE `slider_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscriber_config`
--
ALTER TABLE `subscriber_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscriber_id` (`subscriber_id`),
  ADD KEY `email_frequency` (`email_frequency`),
  ADD KEY `email_format` (`email_format`);

--
-- Indexes for table `support_message`
--
ALTER TABLE `support_message`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_ticket`
--
ALTER TABLE `support_ticket`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suspension_logs`
--
ALTER TABLE `suspension_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suspension_recovery_logs`
--
ALTER TABLE `suspension_recovery_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `username_logs`
--
ALTER TABLE `username_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `users_delete`
--
ALTER TABLE `users_delete`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_profile`
--
ALTER TABLE `users_profile`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vouchers`
--
ALTER TABLE `vouchers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code_name` (`code_name`);

--
-- Indexes for table `voucher_logs`
--
ALTER TABLE `voucher_logs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code_name` (`code_name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=479;

--
-- AUTO_INCREMENT for table `ads_api_logs`
--
ALTER TABLE `ads_api_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `ads_apps`
--
ALTER TABLE `ads_apps`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ads_revenue`
--
ALTER TABLE `ads_revenue`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `anti_ddos`
--
ALTER TABLE `anti_ddos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `api_keys`
--
ALTER TABLE `api_keys`
  MODIFY `key_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `application`
--
ALTER TABLE `application`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `applications`
--
ALTER TABLE `applications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `app_notices`
--
ALTER TABLE `app_notices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `attention`
--
ALTER TABLE `attention`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bandwidth_logs`
--
ALTER TABLE `bandwidth_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blocked_ips`
--
ALTER TABLE `blocked_ips`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `chat`
--
ALTER TABLE `chat`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cloudflare_domains`
--
ALTER TABLE `cloudflare_domains`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `conversion_logs`
--
ALTER TABLE `conversion_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `credits_logs`
--
ALTER TABLE `credits_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `cronjob_banned_ip`
--
ALTER TABLE `cronjob_banned_ip`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cronjob_logs`
--
ALTER TABLE `cronjob_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deleted_app_logs`
--
ALTER TABLE `deleted_app_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `deleted_logs`
--
ALTER TABLE `deleted_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7614;

--
-- AUTO_INCREMENT for table `dns`
--
ALTER TABLE `dns`
  MODIFY `dns_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65021;

--
-- AUTO_INCREMENT for table `download`
--
ALTER TABLE `download`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `duration`
--
ALTER TABLE `duration`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `duration_logs`
--
ALTER TABLE `duration_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_campaigns`
--
ALTER TABLE `email_campaigns`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `email_campaign_recipients`
--
ALTER TABLE `email_campaign_recipients`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_subscribers`
--
ALTER TABLE `email_subscribers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `freeze_request`
--
ALTER TABLE `freeze_request`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `json_update`
--
ALTER TABLE `json_update`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `limit_logs`
--
ALTER TABLE `limit_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `limit_registration`
--
ALTER TABLE `limit_registration`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_attempts_logs`
--
ALTER TABLE `login_attempts_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=321;

--
-- AUTO_INCREMENT for table `login_banned_ip`
--
ALTER TABLE `login_banned_ip`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;

--
-- AUTO_INCREMENT for table `nas`
--
ALTER TABLE `nas`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `page_content`
--
ALTER TABLE `page_content`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `page_customizations`
--
ALTER TABLE `page_customizations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `radacct`
--
ALTER TABLE `radacct`
  MODIFY `radacctid` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `radcheck`
--
ALTER TABLE `radcheck`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `radgroupcheck`
--
ALTER TABLE `radgroupcheck`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `radgroupreply`
--
ALTER TABLE `radgroupreply`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `radpostauth`
--
ALTER TABLE `radpostauth`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `radreply`
--
ALTER TABLE `radreply`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `recovery_logs`
--
ALTER TABLE `recovery_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reloadduration_logs`
--
ALTER TABLE `reloadduration_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reseller_applications`
--
ALTER TABLE `reseller_applications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `reseller_settings`
--
ALTER TABLE `reseller_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `security_logs`
--
ALTER TABLE `security_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `security_settings`
--
ALTER TABLE `security_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `server_list`
--
ALTER TABLE `server_list`
  MODIFY `server_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `site_options`
--
ALTER TABLE `site_options`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `slider_images`
--
ALTER TABLE `slider_images`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `subscriber_config`
--
ALTER TABLE `subscriber_config`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_message`
--
ALTER TABLE `support_message`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_ticket`
--
ALTER TABLE `support_ticket`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `suspension_logs`
--
ALTER TABLE `suspension_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `suspension_recovery_logs`
--
ALTER TABLE `suspension_recovery_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `username_logs`
--
ALTER TABLE `username_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1061;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58322;

--
-- AUTO_INCREMENT for table `users_delete`
--
ALTER TABLE `users_delete`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9107;

--
-- AUTO_INCREMENT for table `users_profile`
--
ALTER TABLE `users_profile`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15353;

--
-- AUTO_INCREMENT for table `vouchers`
--
ALTER TABLE `vouchers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6023;

--
-- AUTO_INCREMENT for table `voucher_logs`
--
ALTER TABLE `voucher_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=226;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ads_revenue`
--
ALTER TABLE `ads_revenue`
  ADD CONSTRAINT `ads_revenue_ibfk_1` FOREIGN KEY (`app_id`) REFERENCES `ads_apps` (`id`) ON DELETE CASCADE;
COMMIT;

/*!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 */;
