· 7 years ago · Sep 16, 2018, 02:18 AM
1-------------------------------------------------------------------------------------------------------------
2
3____ __. .__ .__ _________ .__ __
4| |/ _|____ | |___ _|__| ____ / _____/ ____ ____ __ _________|__|/ |_ ___.__.
5| <_/ __ | | / / |/ _____ _/ __ _/ ___| | _ __ __< | |
6| | ___/| |_ /| | | / ___/ ___| | /| | / || | ___ |
7|____|__ ___ >____/_/ |__|___| /_______ /___ >___ >____/ |__| |__||__| / ____|
8 / / / / / / /
9--- contact:https://www.facebook.com/pages/KelvinSecurity/1470285456587684
10
11
12----- больш ---------------------------------------------------------------------------------------------------------------
13Што Kelvinsecurity? -- -KelvinSecurity- //1995//1996//2019
14
15
16Kelvinsecurity з'ÑўлÑецца хакер твар шукае збору інфармацыі вÑлікіх людзей па ÑžÑім Ñвеце, падлучаных да Ñеткі, Ñ– ÑžÑ€Ð°Ð·Ð»Ñ–Ð²Ñ‹Ñ Ð´Ð° гÑÑ‚Ñ‹Ñ… платформах.
17
18----------------------------------------------------------------------------------------------------------------
19
20
21
22-- Structure de la table `admin_user`
23--
24
25CREATE TABLE IF NOT EXISTS `admin_user` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `user_name` varchar(60) NOT NULL,
28 `password` varchar(60) NOT NULL,
29 `privilege` varchar(20) NOT NULL,
30 `role` varchar(20) NOT NULL,
31 `label` varchar(60) NOT NULL,
32 `percentage` int(11) NOT NULL,
33 `creation_date` varchar(20) NOT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
36
37--
38-- Contenu de la table `admin_user`
39--
40
41INSERT INTO `admin_user` (`id`, `user_name`, `password`, `privilege`, `role`, `label`, `percentage`, `creation_date`) VALUES
42(2, 'Yusamin@yuscard.com', 'yusAdmin', '0', 'administrator', 'Super Admin', 0, ''),
43(5, 'tatianamah@yuscards.com', 'tatiana@2017', '', 'low_admin', 'Tatiana', 0, '2017-09-27 16:34:17'),
44(6, 'philipe@yuscards.com', 'philipe@2017', '', 'investor', 'philipe', 2, '2017-09-27 16:37:54'),
45(8, 'stephan@yuscards.com', 'stephan123', '', 'low_admin', 'Stephan', 20, '2017-10-10 07:35:20'),
46(9, 'toto', 'zzzzzzzzzzzzz', '', '', '', 0, ''),
47(10, 'toto', 'zzzzzzzzzzzzz', '', '', '', 0, '');
48
49
50-- Structure de la table `apply_card`
51--
52
53CREATE TABLE IF NOT EXISTS `apply_card` (
54 `id_card` int(11) NOT NULL AUTO_INCREMENT,
55 `type_card` varchar(60) NOT NULL,
56 `full_name` varchar(100) NOT NULL,
57 `email` varchar(60) NOT NULL,
58 `user_email` varchar(100) NOT NULL,
59 `phone_number` varchar(20) NOT NULL,
60 `country` varchar(60) NOT NULL,
61 `regions` varchar(60) NOT NULL,
62 `gender` varchar(20) NOT NULL,
63 `cni` varchar(20) NOT NULL,
64 `apply_date` varchar(20) NOT NULL,
65 `ref_number` varchar(20) NOT NULL,
66 `card_number` varchar(20) NOT NULL,
67 `date_creation` varchar(20) NOT NULL,
68 `exp_date` varchar(20) NOT NULL,
69 `cvv` int(3) NOT NULL,
70 `cvn` varchar(10) NOT NULL,
71 `agent_pin` varchar(10) NOT NULL,
72 `agent_id` int(11) NOT NULL,
73 `bitcoin_status` int(2) NOT NULL,
74 `amount` varchar(100) NOT NULL,
75 `btc_amount` varchar(60) NOT NULL,
76 `status` int(1) NOT NULL,
77 `pass` varchar(100) NOT NULL,
78 `sponsor_code` varchar(100) NOT NULL,
79 `godson1` varchar(100) NOT NULL,
80 `godson2` varchar(100) NOT NULL,
81 `godson3` varchar(100) NOT NULL,
82 `merchant_status` varchar(10) NOT NULL,
83 PRIMARY KEY (`id_card`)
84) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=90 ;
85
86--
87-- Contenu de la table `apply_card`
88--
89
90INSERT INTO `apply_card` (`id_card`, `type_card`, `full_name`, `email`, `user_email`, `phone_number`, `country`, `regions`, `gender`, `cni`, `apply_date`, `ref_number`, `card_number`, `date_creation`, `exp_date`, `cvv`, `cvn`, `agent_pin`, `agent_id`, `bitcoin_status`, `amount`, `btc_amount`, `status`, `pass`, `sponsor_code`, `godson1`, `godson2`, `godson3`, `merchant_status`) VALUES
91(14, 'Yuscard', 'Michael', 'Yuscard2@gmail.com', 'xxx@gmail.com', '-5', 'Cameroun', 'Douala', '', '', '2017-09-24 17:50:14', 'xxx', '487979889', '2017-09-24 18:00:55', '08/2020', 392, 'SC0007', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
92(15, '', 'Stephan', 'Yuscard3@gmail.com', '', '673309247', 'Cameroun', 'Douala', '', '', '2017-09-24 18:07:17', 'xxx', '2147483647', '2017-09-24 18:08:17', '08/20', 302, 'SC0010', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
93(16, '', 'Banankong', 'Yuscard4@gmail.com', '', '694170565', 'Cameroun', 'Douala', '', '', '2017-09-24 18:09:06', 'xxx', '2147483647', '2017-09-24 18:09:58', '08/20', 126, 'SC0011', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
94(17, '', 'Jannette', 'Yuscard3@gmail.com', '', '694562461', 'Cameroun', 'Douala', '', '', '2017-09-24 18:10:40', 'xxx', '2147483647', '2017-09-24 18:11:39', '09/20', 988, 'SC0004E', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
95(18, '', 'Papa Douala', 'Yuscard3@gmail.com', '', '699682168', 'Cameroun', 'Douala', '', '', '2017-09-24 18:12:30', 'xxx', '2147483647', '2017-09-24 18:13:11', '09/20', 119, 'SC0004G', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
96(19, '', 'Mr. Nana', 'Yuscard8@gmail.com', '', '690020905', 'Cameroun', 'Douala', '', '', '2017-09-24 18:13:58', 'xxx', '2147483647', '2017-09-24 18:15:21', '09/20', 750, 'SC0013', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
97(20, '', 'Rich Gang', 'Yuscard2@gmail.com', '', '694670515', 'Cameroun', 'Douala', '', '', '2017-09-24 18:16:23', 'xxx', '2147483647', '2017-09-24 18:17:14', '09/20', 580, 'SC0012E', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
98(21, '', 'Mme. Nana', 'Yuscard2@gmail.com', '', '699978824', 'Cameroun', 'Douala', '', '', '2017-09-24 18:18:08', 'xxx', '2147483647', '2017-09-24 18:19:06', '09/20', 285, 'SC0012G', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
99(22, '', 'Kenda Nyamba Anatole', 'kendanatole@yahoo.fr', '', '655888468', 'Cameroun', 'Littoral', 'Male', '', '2017-09-25 14:24:06', 'PP170925.1522.A53156', '2147483647', '2017-09-26 05:30:18', '08/20', 123, 'SC0011E', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
100(24, '', 'SIMB Emile Parfait', 'emileparfait2003@gmail.com', '', '655888468', 'Cameroun', 'Littoral', 'Male', '', '2017-09-25 18:08:02', 'PP170925.1906.A72386', '2147483647', '2017-09-26 04:44:39', '09/20', 874, 'SC0013E', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
101(26, '', 'Cedric Ngondi', 'info@guanxi-invest.com', '', '690775833', 'Cameroon', 'Douala', '', '', '2017-09-26 07:00:01', '123456789', '2147483647', '2017-09-26 07:10:28', '07/20', 323, 'SCC0001', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
102(27, '', 'loneur', 'XXX@gmail.com', '', '0', 'Cameroon', 'Bamenda', '', '', '2017-09-26 07:08:07', '123456789', '2147483647', '2017-09-26 07:14:27', '07/20', 928, 'SCC0001E', '', 0, 0, '', '', 1, '', '', '', '', '', ''),
103(30, 'Yuscard', 'Jean Paul TIAJIO', 'users8@yahoo.com', 'jeanpaultiajio@gmail.com', '693167071', 'Cameroon', 'Littoral', 'Male', '', '2017-09-26 14:54:03', 'PP170926.1551.B24067', '2147483647', '2017-09-26 16:02:31', '09/20', 287, 'SC0015', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
104(31, 'Yuscard', 'Mr. camerbitcoins', 'camerbitcoins@gmail.com', 'camerbitcoins@gmail.com', '651220919', 'Cameroon', 'Douala', 'Male', '', '2017-09-27 06:52:28', '153068268', '2147483647', '2017-09-27 13:09:07', '05/20', 532, 'SC0001', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
105(32, 'Yuscard', 'Paul Lambert Ndam', 'users10@yahoo.com', 'paullambertndam@gmail.com', '696361008', 'cameroon', 'littoral', 'Male', '', '2017-09-28 15:35:54', 'PP654680.7411.B14882', '2147483647', '2017-09-28 22:59:11', '09/20', 746, 'SC0017', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
106(33, 'Yuscard', 'Ruben Arnaud TCHAKOUNTE NYONSE', 'users9@yahoo.com', 'tchakarnaud@gmail.com', '2147483647', 'CAMEROON', 'YAOUNDE-CENTER', 'Male', '00000000000', '2017-09-28 18:27:38', 'PP170928.1926.A75562', '2147483647', '2017-09-28 23:17:19', '09/20', 885, 'SC0030', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
107(34, 'Yuscard', 'Steve TChoumba', 'users9@yahoo.com', 'tchoumba_steve@activspaces.com', '655694596', 'Cameroon', 'Douala', 'Male', '', '2017-09-28 18:45:02', '567297600', '2147483647', '2017-09-28 23:10:59', '09/20', 769, 'SC0016', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
108(35, 'Yuscard', 'Ali El Sariji', 'users11@yahoo.com', 'ali.el.sarji@hotmail.com', '655555513', 'Cameroon', 'Yaounde', 'Male', '', '2017-09-29 12:16:54', '213476589', '2147483647', '2017-09-29 12:27:50', '09/20', 231, 'SC0018', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
109(36, 'Yuscard', 'Mbende Jamira', 'camerbitcard1@gmail.com', 'stahe508@outlook.com', '664357084', 'cameroon', 'littoral', 'Male', '', '2017-10-01 12:07:56', 'PP171001.1306.A48778', '2147483647', '2017-10-01 23:35:22', '09/20', 485, 'SC0001G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
110(37, 'Yuscard', 'Mr Ayuk Mavis Enoh', 'users15@yahoo.com', 'ayukmavis3@gmail.com', '671004205', 'Cameroon', 'Littoral', 'Male', '', '2017-10-02 12:30:52', '156372176', '2147483647', '2017-10-03 14:10:56', '2020-09-30', 131, 'SC0022', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
111(38, 'Yuscard', 'Elodie N.', 'users15@yahoo.com', 'lesmarchesdelodie.contact@gmail.com', '2147483647', 'Cameroon', 'Littoral', 'Female', '', '2017-10-02 17:28:16', '954398466', '2147483647', '2017-10-03 14:14:55', '2020-09-30', 918, 'SC0022E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
112(40, 'Yuscard', 'Franck HAPPI', 'users9@yahoo.com', 'franckhappi3@gmail.com', '691668533', 'Cameroun', 'Littoral', 'Male', '', '2017-10-03 12:21:59', '356467474', '2147483647', '2017-10-03 12:33:49', '2020-09-30', 513, 'SC0016G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
113(42, 'Yuscard', 'NWAFO OTCHOUANG Larry', 'users15@yahoo.com', 'larry@gmail.com', '695059898', 'cameroon', 'Littoral', 'Male', '', '2017-10-03 15:59:23', 'PP171003.1443.A86834', '4665440386466870', '2017-10-04 10:21:07', '2020-09-30', 365, 'SC0022G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
114(43, 'Yuscard', 'Mbuh Jude', 'yuscard10@gmail.com', 'info@globexcamhost.com', '670858799', 'Cameroon', 'Yaounde', 'Male', '', '2017-10-03 21:55:04', '674329810', '4665440226047153', '2017-10-07 06:24:31', '09/20', 26, 'SC0014', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
115(44, 'Yuscard', 'Kamdem Nathan', 'yuscard10@gmail.com', 'info@globexcamhost.com', '696859422', 'Cameroon', 'Yaounde', 'Male', '', '2017-10-03 21:57:32', '532891064', '4665440111855140', '2017-10-07 06:25:38', '09/20', 0, 'SC0014', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
116(45, 'Yuscard', 'Angwah Asaa Gerald', 'yuscard7@gmail.com', 'geraldasaaangwah@gmail.com', '672108999', 'Cameroon', 'Litoral', 'Male', '', '2017-10-04 14:14:02', '157571736', '4665440105229765', '2017-10-06 12:00:20', '10/20', 624, 'WX0003E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
117(46, 'Yuscard', 'SIGNE CHEDJOU SIMPLICE', 'yuscard7@gmail.com', 'simplice.sns@gmail.com', '699139089', 'CAMEROON', 'DOUALA', 'Male', '', '2017-10-04 14:29:13', 'PP171004.1526.B57279', '4665440269935686', '2017-10-06 11:56:49', '10/20', 969, 'WX0003', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
118(47, 'Yuscard', 'TALLA ETIENNE', 'yuscard4@gmail.com', 'tallaetienne@yahoo.fr', '671807377', 'Cameroon', 'Littorale', 'Male', '', '2017-10-04 14:37:03', 'PP171004.1533.A59109', '4665440324179502', '2017-10-06 11:51:17', '10/20', 893, 'WX0002G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
119(48, 'Yuscard', 'MR ayuk mavis', 'yuscard4@gmail.com', 'ayukmavis3@gmail.com', '671004205', 'cameroon', 'littoral', '', '', '2017-10-06 11:33:13', '156372176', '4665440154758722', '2017-10-06 11:47:10', '10/20', 164, 'WX0002E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
120(49, 'Yuscard', 'cho promise cho', 'yuscard4@gmail.com', 'benita.franka@gmail.com', '690189433', 'cameroon', 'NORTH WEST', 'Male', '11654677895', '2017-10-06 11:37:28', '157571736', '4665440107697308', '2017-10-06 11:41:55', '10/20', 123, 'SC0011E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
121(50, 'Yuscard', 'DJIMAFO FOTIE GERIE ALAIN', 'yusacard7@gmail.com', 'geralain20012000@yahoo.fr', '690096388', 'Cameroon', 'Littoral', 'Male', '', '2017-10-06 12:36:34', '351794706', '4665440300253487', '2017-10-07 05:42:48', '10/20', 852, 'WX0003G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
122(51, 'Yuscard', 'Achingui Bidias', 'yuscard8@gmail.com', 'achinguimartial@hotmail.fr', '677484568', 'Cameroun', 'Littoral', 'Male', '', '2017-10-07 19:36:13', '159493441', '4665440300253487', '2017-10-09 11:54:56', '10/20', 852, 'WX0003G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
123(52, 'Yuscard', 'Kadjou martin sank', 'yuscard8@gmail.com', 'mkadjoumartin@gmail.com', '693704706', 'CAMEROON', 'Litoral', 'Male', '', '2017-10-08 09:47:38', '347163533', '4665440280527389', '2017-10-09 12:00:36', '10/20', 646, 'WX0004', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
124(53, 'Yuscard', 'ROGER NGASSAM', 'yuscard8@gmail.com', 'rogerngassam@gmail.com', '650503303', 'CAMEROON', 'DOUALA', 'Male', '', '2017-10-09 09:31:05', 'PP171009.1028.B45143', '4665440184843593', '2017-10-09 12:14:37', '10/20', 340, 'WX0004E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
125(54, 'Yuscard', 'Ngong Fais Ngong', 'yuscard8@gmail.com', 'faisngong@gmail.com', '653838061', 'Cameroon', 'Littoral', 'Male', '', '2017-10-09 09:36:26', '123456789', '4665440330517752', '2017-10-09 12:18:04', '10/20', 528, 'WX0004G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
126(55, 'Yuscard', 'BITTAM JEANNETTE', 'yuscard3@gmail.com', 'etbittamjeannette@yahoo.fr', '694562461', 'cameroon', 'littoral', '', '', '2017-10-09 12:04:03', '107298001', '4665440162804278', '2017-10-09 12:06:11', '10/20', 877, 'WX0001E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
127(56, 'Yuscard', 'CAMARA CHARLOTTE LISETTE', 'yuscard2@gmail.com', 'liseitte@yahoo.fr', '695649724', 'CAMEROUN', 'LITTORAL', 'Male', '11836476382', '2017-10-11 11:40:57', 'PP171011.1234.B90104', '4665440259328157', '2017-10-25 12:12:52', '08/20', 293, 'SC00077', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
128(57, 'Yuscard', 'feussi djouonzo bris noel', 'Yuscard3@gmail.com', 'noelke269@gmail.com', '661950583', 'cameroon', 'littoral', 'Male', '1467895490', '2017-10-12 09:43:53', '161939279', '4665440345177816', '2017-10-24 13:09:23', '09/20', 119, 'SC0004G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
129(58, 'Yuscard', 'gassam gael gautier', 'Yuscard7@gmail.com', 'gggassam@gmail.com', '2147483647', 'cameroun', 'littoral', 'Male', '114146007', '2017-10-16 14:33:36', 'PP171011.1215.B88590', '4665440290341573', '2017-10-25 12:16:11', '09/20', 489, 'SC00099', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
130(59, 'Yuscard', 'MELI SONGWA JUDICAEL', 'Yuscard3@gmail.com', 'judimes@gmail.com', '2147483647', 'Cameroon', 'Centre', 'Male', '108563696', '2017-10-17 12:10:40', 'BTC', '4665440255581817', '2017-10-25 12:19:05', '08/20', 203, 'SC00100', '', 0, 0, '', '0.00361958', 1, '', '', '', '', '', ''),
131(60, 'Yuscard', 'SAA LOTI ARISTIDE', 'Yuscard3@gmail.com', 'arsyiiecom@gmail.com', '694727204', 'CAMEROON', 'LITTORAL', 'Male', '108663044', '2017-10-18 13:26:50', 'PP171018.1422.A87225', '4665440107183986', '2017-10-25 12:21:43', '09/20', 889, 'SC00044', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
132(61, 'Yuscard', 'Peleg Fokem Akondeng', 'yuscard8@gmail.com', 'michaelpeleg78@gmail.com', '675588889', 'Cameroon', 'Littoral', 'Male', '0248630310776', '2017-10-20 15:00:16', '166884046', '4665440358601116', '2017-11-13 14:23:14', '2020-09-30', 959, 'SC0013G', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
133(62, 'Yuscard', 'fodjo djoko pierre merlin', 'yuscard7@gmail.com', 'merlinfodjo@gmail.com', '697974417', 'cmeroon', 'douala', 'Male', '114841195', '2017-10-28 06:59:52', '170369204', '4665440290347315', '2017-11-13 11:02:30', '2020-09-30', 984, 'SC009', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
134(63, 'Yuscard', 'LEUSSA TAGNE Adrien', 'leussaadrien@yahoo.fr', 'leussaadrien@yahoo.fr', '2147483647', 'Cameroun', 'Littoral', 'Male', '0000000000', '2017-10-30 12:54:08', 'Sale Agent', '4665440300136303', '2017-10-31 09:37:55', '10/20', 566, 'BTC008', 'SA0001', 7, 1, '', 'xxx', 1, '', '', '', '', '', ''),
135(64, 'Yuscard', 'KOM DAVID CHRISTIAN', 'dckom83@gmail.com', 'dckom83@gmail.com', '2147483647', 'Cameroun', 'Littoral', 'Male', '00000000000', '2017-10-30 12:56:07', 'Sale Agent', '4665440290435317', '2017-10-31 10:04:38', '10/20', 489, 'BTC004', 'SA0001', 7, 1, '', 'xxx', 1, '', '', '', '', '', ''),
136(65, 'Yuscard', 'SOPGUI DIOGNI Armel Baudoin', 'baudoin2004@yahoo.fr', 'baudoin2004@yahoo.fr', '2147483647', 'Cameroun', 'Littoral', 'Male', '00000000000', '2017-10-30 12:58:22', 'Sale Agent', '4665440120312118', '2017-10-31 10:21:44', '09/20', 623, 'BTC007', 'SA0001', 7, 1, '', 'xxx', 1, '', '', '', '', '', ''),
137(66, 'Yuscard', 'MBELLA BLANCHE NEIGE', 'blmbella@yahoo.fr', 'blmbella@yahoo.fr', '2147483647', 'Cameroun', 'Littoral', 'Male', '00000000000', '2017-10-30 14:27:12', 'Sale Agent', '4665440158595401', '2017-10-31 10:38:55', '09/20', 651, 'BTC006', 'SA0001', 7, 1, '', 'xxx', 1, '', '', '', '', '', ''),
138(67, 'Yuscard', 'NDOUNTENG NYAMSI MODESTE FLAURENT', '###@gmail.com', 'nyamsitechno@gmail.com', '695458531', 'cameroon', 'littoral', 'Male', '115939531', '2017-11-01 12:39:01', '178309172', '4665448692750226', '2017-11-04 12:34:55', '10/20', 507, 'BTC0033', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
139(68, 'Yuscard', 'Dieudonne Tata Kinga', 'xxxxxxxxx@yahoo.com', 'aladjibrown1@yahoo.com', '662144627', 'Cameroon', 'Center', 'Male', '00000000000', '2017-11-02 13:41:32', 'Sale Agent', '4665440158953485', '2017-11-06 09:41:55', '25/03/2020', 422, 'BTC0017', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
140(70, 'Yuscard', 'PIKO epse NDAMKOU', 'xxxxxxxxxxxx@gmail.com', '675328040nmd@gmail.com', '675328040', 'cameroon', 'centre', 'Male', '0000000000', '2017-11-03 12:56:03', 'Sale Agent', '4665440259325781', '2017-11-06 09:50:27', '10/20', 392, 'btc0025', 'BTC25', 11, 1, '', 'xxx', 1, '', '', '', '', '', ''),
141(72, 'Yuscard', 'uchenna frankline akpu', 'xxxxxxxx@gmail.com', 'uchekecee94@gmail.com', '693799124', 'cameroon', 'center', 'Male', '00000000000', '2017-11-06 11:48:55', 'Sale Agent', '4665440226867592', '2017-11-06 12:23:31', '09/20', 75, 'BTC0011', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
142(73, 'Yuscard', 'Yeah Eric', 'ericoboy1919@gmail.com', 'ericoboy1919@gmail.com', '677533003', 'Cameroon', 'Bamenda', 'Male', '0000000000', '2017-11-06 17:39:47', 'Sale Agent', '4665440300163363', '2017-11-07 10:22:23', '07/20', 829, 'BTC0016', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
143(74, 'Yuscard', 'Nyiwatumi Julian', 'julianagold1951@gmail.com', 'julianagold1951@gmail.com', '674298075', 'Cameroon', 'Bamenda', 'Male', '00000000000', '2017-11-06 17:44:03', 'Sale Agent', '4665440186005233', '2017-11-07 10:25:20', '09/20', 85, 'BTC0012', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
144(75, 'Yuscard', 'Williams Johnson', 'williamsjohnson790@gmail.com', 'williamsjohnson790@gmail.com', '2147483647', 'Cameroon', 'Centre', 'Male', '00000000000', '2017-11-07 12:09:11', 'Sale Agent', '4665440102312218', '2017-11-08 08:08:31', '09/20', 478, 'BTC0014', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
145(76, 'Yuscard', 'EFOMENKEU TAFOUEKONG NDONGSON IVAN', 'yuscard8@gmail.com', 'efotaf2@gmail.com', '2147483647', 'CAMEROON', 'DOUOALA', 'Male', '117789966', '2017-11-07 16:02:20', 'PP171107.1700.A17510', '4665440102311822', '2017-11-13 14:08:49', '2020-09-30', 874, 'SC0013E', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
146(77, 'Yuscard', 'njah miriam ngenche', 'tallamimmy@gmail.com', 'tallamimmy@gmail.com', '2147483647', 'cameroon', 'Centre', 'Male', '00000000000', '2017-11-07 17:47:04', 'Sale Agent', '4665440117020988', '2017-11-08 08:13:51', '09/20', 846, 'sc0019', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
147(78, 'Yuscard', 'soffor louis kongboh', 'louis.soffor@yahoo.com', 'Louis.soffor@yahoo.com', '2147483647', 'cameroon', 'Centre', 'Male', '00000000000', '2017-11-07 17:51:47', 'Sale Agent', '4665440107690873', '2017-11-08 08:16:43', '09/20', 321, 'BTC0018', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
148(80, 'Yuscard', 'Pierre Kengne', 'kengnepier@gmail.com', 'Kengnepier@gmail.com', '2147483647', 'cameroon', 'littoral', 'Male', '2016003347510883', '2017-11-09 14:15:59', 'Sale Agent', '4665440107188639', '2017-11-10 07:09:09', '10/20', 772, 'BTC0024', 'BTC25', 11, 1, '', 'xxx', 1, '', '', '', '', '', ''),
149(81, 'Yuscard', 'MBAKOB Gilles Brice', 'gillesbricembakob@gmail.com', 'gillesbricembakob@gmail.com', '2147483647', 'Cameroun', 'Douala', 'Male', '109139773', '2017-11-09 17:43:24', 'Sale Agent', '4665440259319350', '2017-11-10 07:18:32', '10/20', 891, 'BTC010', 'SA0001', 7, 1, '', 'xxx', 1, '', '', '', '', '', ''),
150(82, 'Yuscard', 'Willy Jiotsop', 'willystevejiotsop@gmail.com', 'Willystevejiotsop@gmail.com', '679358529', 'Cameroon', 'Center', 'Male', '107960340', '2017-11-10 09:30:52', 'Sale Agent', '4665440290143531', '2017-11-10 14:33:06', '11/20', 849, 'BTC0041', 'BTC35', 13, 1, '', 'xxx', 1, '', '', '', '', '', ''),
151(83, 'Yuscard', 'ZAKARIAOU', 'xxxxxxxx@gmail.com', 'ZAKARIAGAMBO3000@GMAIL.COM', '677010236', 'CAMEROUN', 'douala', 'Male', '112311079', '2017-11-11 10:32:47', '154096855', '4665440258193257', '2017-11-13 14:51:54', '08/20', 329, 'BTC0043', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
152(84, 'Yuscard', 'Aboubakar Hassana', 'aboubihassana@gmail.com', 'aboubihassana@gmail.com', '655924068', 'Cameroon', 'Centre', 'Male', '1128886460', '2017-11-12 14:40:12', 'Sale Agent', '4665440374477731', '2017-11-13 09:28:51', '09/20', 582, 'BTC0013', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
153(85, 'Yuscard', 'Nkeng Promise Mbuagwi', 'nkeng222@gmail.com', 'nkeng222@gmail.com', '674479544', 'Cameroon', 'Centre', 'Male', '1128886460', '2017-11-12 14:45:35', 'Sale Agent', '4665440358601611', '2017-11-13 09:37:50', '09/20', 959, 'BTC0015', 'BTC001', 10, 1, '', 'xxx', 1, '', '', '', '', '', ''),
154(86, 'Yuscard', 'Etundy Mathias Bertrand', 'etundy001@gmail.com', 'etundy001@gmail.com', '694235064', 'Cameroon', 'Center', 'Male', '110491979', '2017-11-13 12:47:30', 'Sale Agent', '4665440154758722', '2017-11-13 13:41:39', '11/20', 164, 'BTC0035', 'BTC35', 13, 1, '', 'xxx', 1, '', '', '', '', '', ''),
155(87, 'Yuscard', 'Paul Roland Foungtcho Essome', 'essome1@gmail.com', 'essome1@gmail.com', '695854653', 'Cameroon', 'LITTORAL', 'Male', '113246092', '2017-11-14 12:42:33', '125214528', '4665440131658601', '2017-11-16 15:33:23', '09/20', 959, 'BTC0054', '', 0, 0, '', 'xxx', 1, '', '', '', '', '', ''),
156(88, 'Yuscard', 'KENGNE PIERRE', '', 'camerbitcoins@gmail.com', '651220919', 'Cameroon', 'Douala', 'Male', '178904543', '2017-11-23 05:50:34', '124567888', '', '', '', 0, '', '', 0, 0, '', 'xxx', 0, '', '', '', '', '', ''),
157(89, '', 'Freezy', '', 'freezycarter2016@gmail.com', '678818233', 'ghana', '', '', '', '2017-12-05 13:25:32', '465463131', '', '', '', 0, '', '', 0, 0, '', '', 2, '$2y$10$dgcdoBTMgZeGatGcDTjFneWOMrnBzhDuNlrRAxF65CIsvn5KB0xVK', 'sfgsds', '', '', '', '');
158
159
160
161--
162-- Structure de la table `load_card`
163--
164
165CREATE TABLE IF NOT EXISTS `load_card` (
166 `load_id` int(11) NOT NULL AUTO_INCREMENT,
167 `user_id` int(11) NOT NULL,
168 `type_card` varchar(60) NOT NULL,
169 `cfa_amount` float NOT NULL,
170 `payment_amount` float NOT NULL,
171 `cvn` varchar(10) NOT NULL,
172 `card_number` varchar(20) NOT NULL,
173 `ref_number` varchar(20) NOT NULL,
174 `devise` varchar(10) NOT NULL,
175 `load_date` varchar(15) NOT NULL,
176 `approved_date` varchar(15) NOT NULL,
177 `status` int(1) NOT NULL,
178 PRIMARY KEY (`load_id`)
179) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
180
181--
182-- Contenu de la table `load_card`
183--
184
185INSERT INTO `load_card` (`load_id`, `user_id`, `type_card`, `cfa_amount`, `payment_amount`, `cvn`, `card_number`, `ref_number`, `devise`, `load_date`, `approved_date`, `status`) VALUES
186(29, 0, 'Yuscard', 30000, 44, 'SC0002', '2147483647', '659830291', 'xxx', '2017-09-26 19:1', '2017-09-28 23:2', 1),
187(30, 0, 'Yuscard', 15000, 22, 'SC0001', '2147483647', '153647065', 'xxx', '2017-09-27 15:0', '2017-09-27 17:4', 1),
188(31, 0, 'Yuscard', 75000, 110, '874', '2147483647', 'PP170928.1738.B66608', 'xxx', '2017-09-28 16:4', '2017-09-28 23:1', 1),
189(32, 0, 'Yuscard', 50000, 71, 'SCC0001', '2147483647', '123456789', '', '2017-09-28 23:2', '2017-09-28 23:2', 1),
190(33, 0, 'Yuscard', 10000, 15, 'SC0018', '2147483647', '132984357', 'xxx', '2017-09-30 21:2', '2017-09-30 21:2', 1),
191(34, 0, 'Yuscard', 20000, 30, '00007', '2147483647', '753534635', 'xxx', '2017-09-30 21:2', '2017-10-02 04:0', 1),
192(35, 0, 'Yuscard', 10000, 15, 'SC0016G', '35435353355', '554444455', 'xxx', '2017-10-03 15:4', '2017-10-06 07:2', 1),
193(36, 0, 'Yuscard', 15000, 23, 'WX - E', '4665440153970591', '153647064', 'xxx', '2017-10-06 08:2', '2017-10-07 04:4', 1),
194(37, 0, 'Yuscard', 10000, 15, 'WX0002', '4665440250447915', '560183114', 'xxx', '2017-10-06 15:0', '2017-10-06 15:1', 1),
195(38, 0, 'Yuscard', 50000, 76, 'SCC0001', '4665440292506850', '950235738', 'xxx', '2017-10-07 05:0', '2017-10-07 05:1', 1),
196(39, 0, 'Yuscard', 80000, 123, 'SCC0001', '4665440292506850', 'PP176392.2010.A28340', 'xxx', '2017-10-07 05:1', '2017-10-07 05:1', 1),
197(40, 0, 'Yuscard', 15000, 23, 'WX0001', '4665440244440158', '938034278', 'xxx', '2017-10-07 05:2', '2017-10-09 00:0', 1),
198(42, 0, 'Yuscard', 0, 384, 'WX0003', '4665440269935686', 'BTC', '0.09149', '2017-10-11 20:3', '2017-10-11 22:5', 1),
199(43, 0, 'Yuscard', 50000, 76, 'SC0011E', '4665440107697308', 'PP171013.1311.A27737', 'xxx', '2017-10-13 12:1', '2017-10-13 13:5', 1),
200(44, 0, 'Yuscard', 20000, 30, 'SC0011', '4665440262980140', '363351366', 'xxx', '2017-10-14 14:5', '2017-10-27 08:3', 1),
201(45, 0, 'Yuscard', 0, 1230, 'WX0004E', '4665440184843593', 'BTC', '0.2489551', '2017-10-16 10:2', '2017-10-16 23:3', 1),
202(46, 0, 'Yuscard', 0, 46, 'SC0001', '4665127489236521', 'BTC', '0.00916118', '2017-10-16 23:2', '2017-10-16 23:3', 1),
203(47, 0, 'Yuscard', 1000, 1, '392', '4665440259325781', '165433329', 'xxx', '2017-10-18 09:3', '2017-10-19 10:0', 1),
204(48, 0, 'Yuscard', 15000, 23, '852', '4665440300253487', '166433183', 'xxx', '2017-10-19 18:5', '2017-10-27 08:3', 1),
205(49, 0, 'Yuscard', 10400, 16, 'SCC0001', '4665440327049272', '178409745', 'xxx', '2017-11-01 09:5', '2017-11-03 15:5', 1),
206(50, 0, 'Yuscard', 0, 16, 'btc0025', '4665440259325781', 'BTC', '0.0029', '2017-11-03 14:1', '2017-11-03 15:5', 1),
207(51, 0, 'Yuscard', 23400, 36, 'BTC0033', '4665448692750226', '651220919', 'xxx', '2017-11-06 13:3', '2017-11-06 21:1', 1),
208(52, 0, 'Yuscard', 74750, 115, 'BTC0024', '4665440107188639', '453626771', 'xxx', '2017-11-10 08:1', '2017-11-10 08:1', 1),
209(53, 0, 'Yuscard', 182000, 280, 'BTC0024', '4665440104188639', '574453228', 'xxx', '2017-11-10 08:4', '2017-11-10 08:4', 1),
210(54, 0, 'Yuscard', 13000, 20, 'BTC0041', '4665440290143531', '179830624', 'xxx', '2017-11-10 14:1', '', 0),
211(55, 0, 'Yuscard', 0, 18, 'SC009', '4665440290347315', 'BTC', '0.00133293', '2017-11-16 11:1', '2017-11-20 10:5', 1),
212(56, 0, 'Yuscard', 200200, 308, 'BTC0015', '4665440358601611', '184421620', 'xxx', '2017-11-18 14:4', '', 0),
213(57, 0, 'Yuscard', 13000, 20, 'SC0020E', '4665440226869275', '185555897', 'xxx', '2017-11-20 17:0', '', 0),
214(58, 0, 'Yuscard', 0, 30, 'BTC0033', '4665448692750226', 'BTC', '0.00375484', '2017-11-21 18:3', '2017-11-21 19:2', 1),
215(59, 89, '', 100, 0, '', '', '552455214', 'MTN Mobile', '2017-12-05 14:3', '', 0);
216
217
218CREATE TABLE IF NOT EXISTS `sale_agent` (
219 `id` int(11) NOT NULL AUTO_INCREMENT,
220 `full_name` varchar(160) NOT NULL,
221 `phone_number` int(15) NOT NULL,
222 `email` varchar(60) NOT NULL,
223 `location` varchar(60) NOT NULL,
224 `pin` varchar(10) NOT NULL,
225 `login` varchar(60) NOT NULL,
226 `pass` varchar(60) NOT NULL,
227 `role` varchar(20) NOT NULL,
228 `added_card` int(11) NOT NULL,
229 `card_given` int(11) NOT NULL,
230 `date_registration` varchar(20) NOT NULL,
231 PRIMARY KEY (`id`)
232) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
233
234--
235-- Contenu de la table `sale_agent`
236--
237
238INSERT INTO `sale_agent` (`id`, `full_name`, `phone_number`, `email`, `location`, `pin`, `login`, `pass`, `role`, `added_card`, `card_given`, `date_registration`) VALUES
239(3, 'alain MCC', 677652563, 'alino@gmail.com', 'Douala, Cameroun', '556677', 'alino', 'alino@2017', 'Sale Agent', 0, 0, '2017/09/21'),
240(7, 'Emile Parfait SIMB', 655888468, 'emileparfait2003@gmail.com', 'Douala', 'SA0001', 'Emile', 'emile@2017', '', 5, 5, '2017-09-29 08:32:23'),
241(8, 'Valery awah', 696546183, 'Vawah1@gmail.com', 'Douala', 'SA0009', 'Valery', 'Yus09', '', 0, 10, '2017-10-07 14:22:03'),
242(9, 'SENA SOUL', 699139089, 'simplice.sns@gmail.com', 'Douala', 'WX3', 'simplice', 'Yus03', '', 0, 10, '2017-10-13 22:21:58'),
243(10, 'AWASOME NELSON NJI', 676309349, 'nelsonnjiawasom@gmail.com', 'Yaounde', 'BTC001', 'nelson', 'nelson2017', '', 10, 0, '2017-10-31 23:11:44'),
244(11, 'PIKO epse NDAMKOU Helene', 2147483647, '675328040nmd@gmail.com', 'cameroon yaounde', 'BTC25', 'Helene2', 'piko1980', '', 2, 8, '2017-11-03 12:35:03'),
245(12, 'KENGNE PIERRE', 699022736, 'pierrekengne73@gmail.com', 'cameroun douala', 'BTC33', 'PETER16', 'kengne16', '', 0, 10, '2017-11-03 13:14:24'),
246(13, 'KENFACK JIOTSOP WILLY STEVE', 679358529, 'willyjiotsop@yahoo.fr', 'Cameroon, Yaounde', 'BTC35', 'steve', 'steve123', '', 2, 8, '2017-11-06 12:43:27'),
247(14, 'NJISONG GODLOVE CHIA', 679112339, 'cnjigoddy@yahoo.co.uk', 'Douala', 'BTC45', 'Goddymax', 'GoodMan', '', 0, 10, '2017-11-11 12:25:38');