-- http://www.phpmyadmin.net
--




--
-- Database: `home_tpn`
--

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

--
-- Table structure for table `tpn_home_apikeys`
--

CREATE TABLE IF NOT EXISTS `tpn_home_apikeys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `username` varchar(128) CHARACTER SET latin1 NOT NULL,
  `privilege` int(11) NOT NULL,
  `accesskey` varchar(32) CHARACTER SET latin1 NOT NULL,
  `validtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tpn_home_confirm_accounts`
--

CREATE TABLE IF NOT EXISTS `tpn_home_confirm_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `numberList` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  `storage` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `createdtime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tpn_home_forgot_passwords`
--

CREATE TABLE IF NOT EXISTS `tpn_home_forgot_passwords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `timeday` datetime NOT NULL,
  `checksum` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=109 ;

--
-- Dumping data for table `tpn_home_forgot_passwords`
--

INSERT INTO `tpn_home_forgot_passwords` (`id`, `userid`, `timeday`, `checksum`) VALUES
(1, 56, '2022-06-03 04:12:17', '82f9b154b4018453be1e28bfba4833f6'),
(2, 56, '2022-06-03 04:13:20', '50c61ec34f8dd6498a97e96245dc85fa'),
(10, 63, '2022-07-15 03:06:33', '59342837e2aa672d25e2b6c260363c66'),
(18, 492, '2022-11-09 06:26:36', 'a147d4f5f25597e0c6aa0282ebdba22a'),
(17, 521, '2022-11-05 01:11:36', 'a9fbf20893140a09a294c18b4304b17c'),
(34, 534, '2023-02-04 07:26:06', '4c0b4b89bb2ba73beb98b2e8bb2913d7'),
(26, 63, '2022-12-16 00:56:35', '6f47ec0535bc5ac3723d2706db8ac281'),
(35, 534, '2023-02-04 07:28:30', 'e53bd0a933e14193c809ad9f8e4184fa'),
(36, 534, '2023-02-04 07:32:35', '523b2c7667fa7afa40f87b613610ff8a'),
(37, 534, '2023-02-04 07:34:01', '94a2dd0c29e0385fdfac981e110c8b26'),
(38, 534, '2023-02-04 08:44:38', '66159cc6eb501ff793ecf0da54bf13a8'),
(39, 534, '2023-02-04 08:45:52', '596d1692a4203f086bdd3bc2b504aec8'),
(40, 514, '2023-02-05 02:30:31', 'fdf10a5fe422b9eaf4f590b1bbbb08ef'),
(41, 514, '2023-02-05 02:30:42', 'd5605d538ca615636d3e4bda5a2c18f6'),
(42, 534, '2023-02-06 02:22:50', 'f7ca40c731961592687a5c23bdc479a8'),
(57, 557, '2023-03-14 08:02:49', '4170ce78b1f33561b2f39ee5ada63fe5'),
(56, 557, '2023-03-14 07:57:53', '81391ecf07a79bfd2d864f538557f812'),
(58, 557, '2023-03-14 08:03:04', '718ab5e70799b55b600ca4ed4744f0f9'),
(59, 557, '2023-03-14 08:11:50', 'b56f1a0b4a3fa7d7873a9ed3b3fc2c95'),
(63, 548, '2023-05-02 06:05:51', 'bed31ff3d80ea81d3fa80a49a8d24cd7'),
(64, 548, '2023-05-02 06:06:08', '43040f3ca452cc8e99a4ae4f57bc58d4'),
(65, 548, '2023-05-02 06:09:14', '7cb23790f8df6ba88e00242f907c6630'),
(66, 548, '2023-05-02 06:10:33', 'a375d6c2fa8bd1af51df904cf55e90cf'),
(67, 372, '2023-05-05 00:50:43', 'cdc0aeaa43eb67209dfcf09f48837ee3'),
(68, 372, '2023-05-05 00:52:50', '53781295406c33b5d915a9ffc6d03a90'),
(69, 372, '2023-05-05 02:47:37', '163976c607bde1f854d7d3de48841c16'),
(70, 66, '2023-05-05 02:49:48', 'dfe3918768088482c8b705457181ae64'),
(71, 549, '2023-05-05 06:17:35', '65900af92fc8564cae6f4da21afba016'),
(72, 549, '2023-05-05 06:17:38', '85925f5d9275455b9a6f9fe5d55169a8'),
(73, 549, '2023-05-05 06:17:40', 'a7f710e8a26720c4c340b1776556a7bc'),
(74, 571, '2023-06-13 05:41:13', 'd43f7d8eb2601500a8c064e4bc216990'),
(75, 571, '2023-06-13 05:42:35', 'af624163940966d20b1b835474a2f58f'),
(92, 527, '2023-07-30 07:12:09', '3f19a28b32c9691b7635f7ef70543a32'),
(82, 26, '2023-07-17 09:31:39', '10dec646173ac440fed2ca8a95fac170'),
(91, 527, '2023-07-30 07:11:37', '6b6ff15dbd07685643ddacf1a034c3a4'),
(93, 527, '2023-07-30 07:12:15', '015b48e13dac54f9454e0d905464796c'),
(94, 527, '2023-07-30 07:13:04', '108b7ebd949490e8071d23ed6caa5360'),
(95, 527, '2023-07-30 07:13:10', 'b95f3211f9c541bb8f758034a7749918'),
(96, 527, '2023-07-30 07:14:46', 'f545c1db12243fa1c588c2666ee4d1a5'),
(97, 527, '2023-07-30 07:15:02', '54511da45fac2d429ba0f7eda4091a6e'),
(98, 527, '2023-07-30 07:15:27', '752a3c5194709a3e0a958b67447e335b'),
(99, 527, '2023-07-30 07:15:37', '369e568d2fdc4f35c263d8697e764167'),
(100, 527, '2023-07-30 07:16:14', '3833ed4dc8bbe34a923bb00cfad78774'),
(101, 527, '2023-07-30 07:18:13', 'ffef2a3d032d679bc2fee05991e58ea3'),
(102, 527, '2023-07-30 07:18:20', '3af71864817c005c4985af666e99f553'),
(103, 502, '2023-08-01 08:50:37', '7d67e80fa2b4298e35a70d491db43258'),
(104, 502, '2023-08-01 08:50:41', '30b0610871917dd275364e8d1326b7f4'),
(105, 143, '2023-08-02 04:20:55', 'a695118b38a0e86efa608ff511cb976c'),
(106, 143, '2023-08-02 04:20:59', 'b8ac72364b0580ecf484b1ba796f2992'),
(107, 143, '2023-08-02 04:23:20', 'b9235ebbe378f8df581bc41886329ac4'),
(108, 187, '2023-08-03 02:03:06', 'cc3c5ce6664a99ed66e9d7b4bfd5818b');

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

--
-- Table structure for table `tpn_home_login_failed`
--

CREATE TABLE IF NOT EXISTS `tpn_home_login_failed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `user_agent` text NOT NULL,
  `ip` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=151 ;

--
-- Dumping data for table `tpn_home_login_failed`
--

INSERT INTO `tpn_home_login_failed` (`id`, `userid`, `user_agent`, `ip`) VALUES
(1, 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', '116.97.52.86'),
(2, 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', '14.174.183.193'),
(3, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36', '14.174.183.193'),
(4, 56, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36 Edg/102.0.1245.30', '14.161.32.119'),
(5, 62, 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/456 ZaloTheme/light ZaloLanguage/vn', '103.199.60.20'),
(6, 9, 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/456 ZaloTheme/light ZaloLanguage/vn', '118.71.69.255'),
(7, 62, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.0', '118.71.69.255'),
(8, 9, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36 Edg/102.0.1245.33', '115.73.143.121'),
(9, 8, 'Mozilla/5.0 (Linux; Android 12; SM-G985F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.78 Mobile Safari/537.36', '171.234.13.97'),
(10, 497, 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', '171.231.205.114'),
(11, 498, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', '27.71.108.171'),
(12, 39, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', '115.79.50.245'),
(13, 64, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/458 ZaloTheme/light ZaloLanguage/vn', '14.243.79.96'),
(14, 63, 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36', '42.119.82.105'),
(15, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36', '14.226.122.9'),
(16, 50, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36', '1.53.196.87'),
(17, 507, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/464 ZaloTheme/light ZaloLanguage/vn', '171.235.97.23'),
(18, 47, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', '14.161.32.119'),
(19, 493, 'Mozilla/5.0 (Linux; Android 11; SAMSUNG SM-G996B) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/18.0 Chrome/99.0.4844.88 Mobile Safari/537.36', '113.22.162.194'),
(20, 493, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', '123.20.247.228'),
(21, 516, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', '27.78.71.56'),
(22, 521, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/478 ZaloTheme/light ZaloLanguage/vn', '171.236.49.49'),
(23, 520, 'Mozilla/5.0 (Linux; Android 12; SM-A025F Build/SP1A.210812.016;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/105.0.5195.136 Mobile Safari/537.36 Zalo android/12100646 ZaloTheme/light ZaloLanguage/vi', '27.66.52.143'),
(24, 520, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.3 Safari/605.1.15', '118.68.96.12'),
(25, 519, 'Mozilla/5.0 (Linux; Android 12; 21081111RG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Mobile Safari/537.36', '113.185.105.192'),
(26, 519, 'Mozilla/5.0 (Linux; Android 12; 21081111RG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.48 Mobile Safari/537.36', '113.185.111.137'),
(27, 26, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148', '116.103.28.4'),
(28, 24, 'Mozilla/5.0 (Linux; Android 10; SM-A750GN Build/QP1A.190711.020; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/105.0.5195.136 Mobile Safari/537.36', '14.165.42.69'),
(29, 514, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/478 ZaloTheme/light ZaloLanguage/vn', '171.253.132.200'),
(30, 514, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/482 ZaloTheme/light ZaloLanguage/vn', '171.233.201.101'),
(31, 497, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', '171.234.15.86'),
(32, 497, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', '42.119.238.240'),
(33, 535, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6,2 Safari/605.1.15', '14.245.156.94'),
(34, 535, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', '171.234.15.86'),
(35, 535, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', '14.161.32.119'),
(36, 535, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', '116.99.229.20'),
(37, 534, 'Mozilla/5.0 (Linux; U; Android 10; vi-vn; RMX2185 Build/QP1A.190711.020) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36 HeyTapBrowser/45.8.9.1', '27.3.56.112'),
(38, 510, 'Mozilla/5.0 (Linux; Android 11; M2012K10C Build/RP1A.200720.011; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/107.0.5304.105 Mobile Safari/537.36', '42.1.89.119'),
(39, 534, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36', '113.174.245.20'),
(40, 538, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1', '58.187.170.234'),
(41, 510, 'Mozilla/5.0 (Linux; Android 11; M2012K10C Build/RP1A.200720.011; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/107.0.5304.141 Mobile Safari/537.36', '117.3.230.180'),
(42, 534, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.2 Safari/605.1.15', '171.231.146.216'),
(43, 493, 'Mozilla/5.0 (Linux; Android 10; SM-A750GN Build/QP1A.190711.020;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/108.0.5359.79 Mobile Safari/537.36 Zalo android/12100646 ZaloTheme/light ZaloLanguage/vi', '103.199.39.180'),
(44, 493, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.3 Mobile/15E148 Safari/604.1', '113.185.85.99'),
(45, 530, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '113.185.83.27'),
(46, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', '14.175.172.131'),
(47, 26, 'Mozilla/5.0 (iPad; CPU OS 16_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 LightSpeed [FBAN/MessengerLiteForiOS;FBAV/377.0.0.32.105;FBBV/396109127;FBDV/iPad12,1;FBMD/iPad;FBSN/iPadOS;FBSV/16.1.1;FBSS/2;FBCR/;FBID/tablet;FBLC/vi;FBOP/0]', '171.226.74.250'),
(48, 42, 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', '117.5.189.222'),
(49, 521, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', '171.236.48.187'),
(50, 493, 'Mozilla/5.0 (Linux; Android 12; SM-A325F Build/SP1A.210812.016;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/108.0.5359.128 Mobile Safari/537.36 Zalo android/12100674 ZaloTheme/light ZaloLanguage/vi', '103.199.39.84'),
(51, 98, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0', '14.161.32.119'),
(52, 470, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:108.0) Gecko/20100101 Firefox/108.0', '14.161.32.119'),
(53, 87, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0', '113.161.160.11'),
(54, 106, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(55, 97, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0', '14.161.32.119'),
(56, 85, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0', '113.161.160.11'),
(57, 50, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '116.99.239.175'),
(58, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '14.226.122.147'),
(59, 534, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/502 ZaloTheme/light ZaloLanguage/vn', '27.3.56.72'),
(60, 534, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36', '117.2.159.175'),
(61, 534, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/502 ZaloTheme/light ZaloLanguage/vn', '27.67.94.109'),
(62, 514, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '171.247.77.63'),
(63, 501, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/107.0.5304.101 Mobile/15E148 Safari/604.1', '103.199.61.207'),
(64, 514, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/502 ZaloTheme/light ZaloLanguage/vn', '27.67.27.141'),
(65, 534, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/502 ZaloTheme/light ZaloLanguage/vn', '27.67.134.220'),
(66, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '45.117.171.211'),
(67, 493, 'Mozilla/5.0 (Linux; Android 12; SM-A325F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Mobile Safari/537.36', '103.199.60.156'),
(68, 376, 'Mozilla/5.0 (Linux; Android 12; SM-A325F Build/SP1A.210812.016;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/109.0.5414.117 Mobile Safari/537.36 Zalo android/12100676 ZaloTheme/light ZaloLanguage/vi', '103.199.60.156'),
(69, 376, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.3 Mobile/15E148 Safari/604.1', '113.185.84.97'),
(70, 376, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.3 Mobile/15E148 Safari/604.1', '113.185.84.5'),
(71, 7, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '115.72.76.221'),
(72, 512, 'Mozilla/5.0 (Linux; Android 12; SAMSUNG SM-A045F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/16.2 Chrome/92.0.4515.166 Mobile Safari/537.36', '103.199.62.142'),
(73, 540, 'Mozilla/5.0 (Linux; Android 11; M2010J19SG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Mobile Safari/537.36', '171.234.12.208'),
(74, 28, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '14.161.32.119'),
(75, 448, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', '116.111.224.108'),
(76, 501, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.5 Mobile/15E148 Safari/604.1', '113.182.69.88'),
(77, 138, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.162.19'),
(78, 325, 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.162.19'),
(79, 154, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(80, 180, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '113.161.160.11'),
(81, 193, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', '113.161.239.7'),
(82, 193, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '113.161.162.19'),
(83, 275, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '113.161.162.19'),
(84, 275, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '113.161.239.7'),
(85, 207, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '113.161.239.7'),
(86, 155, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', '113.161.160.11'),
(87, 173, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36', '113.161.160.11'),
(88, 194, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(89, 444, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', '113.161.160.11'),
(90, 208, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.162.19'),
(91, 62, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/510 ZaloTheme/light ZaloLanguage/vn', '103.199.62.145'),
(92, 549, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Mobile/15E148 Safari/604.1', '171.253.186.123'),
(93, 548, 'Mozilla/5.0 (Linux; Android 12; SM-G988B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Mobile Safari/537.36', '171.247.166.114'),
(94, 524, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', '113.178.96.93'),
(95, 547, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36', '117.3.192.22'),
(96, 557, 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/514 ZaloTheme/light ZaloLanguage/vn', '103.199.60.26'),
(97, 146, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0', '125.212.208.185'),
(98, 146, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', '113.161.239.7'),
(99, 146, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0', '113.161.160.11'),
(100, 384, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', '113.161.239.7'),
(101, 63, 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1', '1.53.54.18'),
(102, 452, 'Mozilla/5.0 (Linux; Android 13; SM-A536E Build/TP1A.220624.014; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.58 Mobile Safari/537.36 lsbrowser', '123.28.31.233'),
(103, 139, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0', '113.161.239.7'),
(104, 308, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(105, 495, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(106, 362, 'Mozilla/5.0 (Linux; Android 11; 2201117TG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '59.153.227.48'),
(107, 452, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(108, 494, 'Mozilla/5.0 (Linux; Android 13; SM-A536E Build/TP1A.220624.014; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.58 Mobile Safari/537.36 lsbrowser', '113.161.160.11'),
(109, 480, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0', '113.161.160.11'),
(110, 480, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', '125.235.233.76'),
(111, 81, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0', '113.161.160.11'),
(112, 305, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.160.11'),
(113, 89, 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0', '113.161.160.11'),
(114, 39, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', '42.118.76.237'),
(115, 73, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/110.0', '113.161.239.7'),
(116, 521, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '171.236.49.158'),
(117, 546, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', '115.79.220.91'),
(118, 554, 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/524 ZaloTheme/light ZaloLanguage/vn', '171.225.184.211'),
(119, 548, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.64', '171.225.173.218'),
(120, 319, 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.80 Safari/537.36', '113.161.239.7'),
(121, 319, 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.80 Safari/537.36', '113.161.162.19'),
(122, 571, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', '171.245.251.168'),
(123, 372, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.68', '42.114.203.230'),
(124, 516, 'Mozilla/5.0 (Linux; Android 11; 21061119AG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Mobile Safari/537.36', '125.235.187.202'),
(125, 576, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.4 Mobile/15E148 Safari/604.1', '14.191.188.192'),
(126, 565, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.2 Mobile/15E148 Safari/604.1', '59.153.246.157'),
(127, 548, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', '115.79.141.85'),
(128, 206, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', '113.161.239.7'),
(129, 173, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.239.7'),
(130, 571, 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.2 Mobile/15E148 Safari/604.1', '103.199.60.215'),
(131, 560, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', '42.114.23.46'),
(132, 554, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Mobile/15E148 Safari/604.1', '171.225.185.109'),
(133, 506, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/534 ZaloTheme/light ZaloLanguage/vn', '125.235.237.175'),
(134, 571, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', '171.227.255.29'),
(135, 73, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', '113.163.216.130'),
(136, 208, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '113.161.239.7'),
(137, 142, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '103.199.46.152'),
(138, 565, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.2 Mobile/15E148 Safari/604.1', '14.191.254.198'),
(139, 30, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/540 ZaloTheme/light ZaloLanguage/vn', '118.68.87.96'),
(140, 559, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.2 Mobile/15E148 Safari/604.1', '1.54.243.242'),
(141, 491, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.86', '171.249.108.113'),
(142, 42, 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 LightSpeed [FBAN/MessengerLiteForiOS;FBAV/404.0.0.30.110;FBBV/464513134;FBDV/iPhone8,2;FBMD/iPhone;FBSN/iOS;FBSV/13.6.1;FBSS/3;FBCR/;FBID/phone;FBLC/vi;FBOP/0]', '113.185.85.197'),
(143, 372, 'Mozilla/5.0 (Linux; Android 13; SM-S908E Build/TP1A.220624.014;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/114.0.5735.196 Mobile Safari/537.36 Zalo android/12100699 ZaloTheme/light ZaloLanguage/vi', '42.116.13.151'),
(144, 491, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Zalo iOS/542 ZaloTheme/light ZaloLanguage/vn', '103.199.60.148'),
(145, 362, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', '42.1.89.118'),
(146, 143, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', '113.161.162.19'),
(147, 187, 'Mozilla/5.0 (Windows NT 6.1; rv:109.0) Gecko/20100101 Firefox/115.0', '113.161.160.11'),
(148, 199, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0', '113.161.160.11'),
(149, 539, 'Mozilla/5.0 (Linux; Android 12; SM-A217F Build/SP1A.210812.016;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/115.0.5790.138 Mobile Safari/537.36 Zalo android/12100700 ZaloTheme/light ZaloLanguage/vi', '59.153.227.18'),
(150, 539, 'Mozilla/5.0 (Linux; Android 12; SM-A217F Build/SP1A.210812.016;) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/115.0.5790.138 Mobile Safari/537.36 Zalo android/12100700 ZaloTheme/light ZaloLanguage/vi', '42.1.89.44');

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

--
-- Table structure for table `tpn_home_new_accounts`
--

CREATE TABLE IF NOT EXISTS `tpn_home_new_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `timeday` datetime NOT NULL,
  `checksum` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tpn_home_uitext`
--

CREATE TABLE IF NOT EXISTS `tpn_home_uitext` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(4096) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(4096) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=113 ;



