· 6 years ago · Aug 01, 2019, 03:22 PM
1CREATE TABLE IF NOT EXISTS `bases` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `category` varchar(256) NOT NULL,
4 `color` varchar(10) NOT NULL,
5 `precent` int(10) NOT NULL,
6 `type` int(11) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
9
10
11INSERT INTO `bases` (`id`, `category`, `color`, `precent`, `type`) VALUES
12(1, '4', '#2b9032', 100, 1),
13(2, '3', '#ffa200', 50, 1),
14(3, '1', '#ff1800', 30, 1),
15(4, '2', '#48be6d', 85, 1),
16(5, '1', '#f39826', 50, 2),
17(6, '2', '#f40023', 27, 2),
18(7, '3', '#329001', 90, 2),
19(8, '4', '#329001', 85, 2);
20
21CREATE TABLE IF NOT EXISTS `cards` (
22 `cardId` int(11) NOT NULL AUTO_INCREMENT,
23 `date` datetime NOT NULL,
24 `categoryId` int(11) NOT NULL DEFAULT '1',
25 `cardUsed` int(11) NOT NULL DEFAULT '0',
26 `cardContent` varchar(512) NOT NULL,
27 `cardNum` varchar(20) NOT NULL,
28 `cardMon` varchar(10) NOT NULL,
29 `cardYea` varchar(10) NOT NULL,
30 `cardCvv` varchar(10) DEFAULT NULL,
31 `cardCou` varchar(128) NOT NULL,
32 `CardState` varchar(255) NOT NULL,
33 `CardCity` varchar(255) NOT NULL,
34 `CardZip` varchar(255) NOT NULL,
35 `cardSpliter` varchar(11) NOT NULL,
36 `cardNumPost` int(11) NOT NULL,
37 `cardMonPost` int(11) NOT NULL,
38 `cardYeaPost` int(11) NOT NULL,
39 `cardCvvPost` int(11) NOT NULL,
40 `cardCouPost` int(11) NOT NULL,
41 `CardStatePost` int(11) NOT NULL,
42 `CardCityPost` int(11) NOT NULL,
43 `CardZipPost` int(11) NOT NULL,
44 `status` int(11) NOT NULL,
45 `price` varchar(11) NOT NULL DEFAULT '0',
46 `seller` int(11) NOT NULL DEFAULT '1',
47 `sellerprc` varchar(11) NOT NULL DEFAULT '0',
48 PRIMARY KEY (`cardId`),
49 UNIQUE KEY `cardContent` (`cardContent`),
50 UNIQUE KEY `cardNum` (`cardNum`)
51) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
52
53CREATE TABLE IF NOT EXISTS `category` (
54 `categoryId` int(11) NOT NULL AUTO_INCREMENT,
55 `categoryName` varchar(256) NOT NULL,
56 `categoryInfo` text NOT NULL,
57 `categoryPrice` double NOT NULL,
58 PRIMARY KEY (`categoryId`),
59 UNIQUE KEY `categoryName` (`categoryName`)
60) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
61
62INSERT INTO `category` (`categoryId`, `categoryName`, `categoryInfo`, `categoryPrice`) VALUES
63(1, 'USBASE01', 'seller1/seller2', 3.5),
64(2, 'USBASE02', 'EXAMPLE2', 2),
65(3, 'EUBASE4', 'EXAMPLE3', 0),
66(4, 'MIXDBCVV', 'for admin', 0),
67(5, 'TEST category', 'for admin', 0),
68(6, 'TEST categoryz', 'for admin', 0);
69
70CREATE TABLE IF NOT EXISTS `dumpcategory` (
71 `categoryId` int(11) NOT NULL AUTO_INCREMENT,
72 `categoryName` varchar(256) NOT NULL,
73 `categoryInfo` text NOT NULL,
74 `categoryPrice` double NOT NULL,
75 PRIMARY KEY (`categoryId`),
76 UNIQUE KEY `categoryName` (`categoryName`)
77) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
78
79INSERT INTO `dumpcategory` (`categoryId`, `categoryName`, `categoryInfo`, `categoryPrice`) VALUES
80(1, 'USA DUMPS', 'great valid', 30),
81(2, 'NO RUSSIAN DUMPS', 'skimmer', 150),
82(3, 'JACKPOS DB', 'example)', 0),
83(4, 'EUBASE[100%]', '101% valid', 0),
84(6, 'emty cay', 'emty cay', 0);
85
86CREATE TABLE IF NOT EXISTS `dumps` (
87 `dumpId` int(11) NOT NULL AUTO_INCREMENT,
88 `date` datetime NOT NULL,
89 `categoryId` int(11) NOT NULL DEFAULT '1',
90 `dumpUsed` int(11) NOT NULL DEFAULT '0',
91 `dumpContent` varchar(512) NOT NULL,
92 `dumpNum` varchar(20) NOT NULL,
93 `dumpMon` varchar(10) NOT NULL,
94 `dumpYea` varchar(10) NOT NULL,
95 `dumpCou` varchar(128) NOT NULL,
96 `dumpcode` int(11) NOT NULL,
97 `dumptype` varchar(255) NOT NULL DEFAULT '-',
98 `dumpclass` varchar(255) NOT NULL DEFAULT '-',
99 `dumplevel` varchar(255) NOT NULL DEFAULT '-',
100 `dumpbank` varchar(255) NOT NULL,
101 `status` int(11) NOT NULL,
102 `price` varchar(11) NOT NULL,
103 `seller` int(11) NOT NULL DEFAULT '1',
104 `sellerprc` varchar(11) NOT NULL DEFAULT '0',
105 `pack` int(11) DEFAULT '0',
106 `checkermsg` varchar(255) NOT NULL,
107 PRIMARY KEY (`dumpId`),
108 UNIQUE KEY `dumpContent` (`dumpContent`),
109 UNIQUE KEY `dumpNum` (`dumpNum`)
110) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
111
112CREATE TABLE IF NOT EXISTS `faq` (
113 `categoryId` int(11) NOT NULL AUTO_INCREMENT,
114 `categoryName` varchar(256) NOT NULL,
115 `categoryIcon` varchar(256) NOT NULL,
116 PRIMARY KEY (`categoryId`),
117 UNIQUE KEY `categoryName` (`categoryName`)
118) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
119
120INSERT INTO `faq` (`categoryId`, `categoryName`, `categoryIcon`) VALUES
121(8, 'Deposit', 'fa fa-money'),
122(7, 'Rules', 'fa fa-bullhorn'),
123(12, 'Checker', 'fa fa-credit-card');
124
125CREATE TABLE IF NOT EXISTS `news` (
126 `id` int(11) NOT NULL AUTO_INCREMENT,
127 `date` varchar(11) NOT NULL,
128 `color` varchar(10) NOT NULL,
129 `text` varchar(255) NOT NULL,
130 `category` int(1) NOT NULL,
131 PRIMARY KEY (`id`)
132) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
133
134INSERT INTO `news` (`id`, `date`, `color`, `text`, `category`) VALUES
135(1, '23.09.2014', '#555555', 'ADDED BASE [USA DUMPS]', 1),
136(2, '24.09.2014', '#555', 'ADDED BASE [NO RUSSIAN DUMPS]', 1),
137(3, '25.09.2014', '#555555', 'ADDED BASE [JACKPOS DB]', 1),
138(4, '29.09.2014', '#427dd9', 'ADDED BASE [EUBASE[100%]] - 100% VALID', 1),
139(5, '25.09.2014', '#555', 'ADDED BASE [USBASE01]', 2),
140(6, '26.09.2014', '#555', 'ADDED BASE [USBASE02]', 2),
141(7, '27.09.2014', '#509626', 'BEST EU CVV --> [EUBASE4]', 2),
142(8, '28.09.2014', '#bf3535', 'SUPER BIG UPDATE [MIXDBCVV]', 2);
143
144CREATE TABLE IF NOT EXISTS `orders` (
145 `orderId` int(11) NOT NULL AUTO_INCREMENT,
146 `userId` int(11) NOT NULL,
147 `approved` int(11) NOT NULL DEFAULT '0',
148 `orderTotal` double NOT NULL DEFAULT '0',
149 `orderDate` datetime NOT NULL,
150 `wallet` varchar(255) NOT NULL,
151 `walletbalance` int(11) NOT NULL,
152 `type` varchar(255) NOT NULL,
153 `btcvalue` varchar(100) NOT NULL DEFAULT 'no',
154 `btcreceived` varchar(100) NOT NULL,
155 `txhash` varchar(255) NOT NULL,
156 `confirmations` varchar(100) NOT NULL,
157 `uorderid` varchar(255) NOT NULL,
158 PRIMARY KEY (`orderId`)
159) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
160
161CREATE TABLE IF NOT EXISTS `packs` (
162 `Id` int(11) NOT NULL AUTO_INCREMENT,
163 `date` datetime NOT NULL,
164 `categoryId` int(11) NOT NULL DEFAULT '0',
165 `type` varchar(255) NOT NULL DEFAULT '0',
166 `level` varchar(255) NOT NULL DEFAULT '0',
167 `class` varchar(255) NOT NULL DEFAULT '0',
168 `code` int(11) NOT NULL DEFAULT '0',
169 `name` varchar(255) NOT NULL,
170 `comment1` varchar(255) NOT NULL,
171 `comment2` varchar(255) NOT NULL,
172 `Used` int(11) NOT NULL DEFAULT '0',
173 `country` varchar(512) NOT NULL,
174 `value` int(11) NOT NULL,
175 `price` varchar(11) NOT NULL DEFAULT '0',
176 `norefund` int(11) NOT NULL DEFAULT '0',
177 `seller` int(11) NOT NULL DEFAULT '1',
178 `sellerprc` varchar(11) NOT NULL DEFAULT '0',
179 PRIMARY KEY (`Id`)
180) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
181
182CREATE TABLE IF NOT EXISTS `questions` (
183 `Id` int(11) NOT NULL AUTO_INCREMENT,
184 `question` varchar(256) NOT NULL,
185 `answer` varchar(6256) NOT NULL,
186 `categoryId` double NOT NULL,
187 PRIMARY KEY (`Id`),
188 UNIQUE KEY `question` (`question`)
189) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
190
191INSERT INTO `questions` (`Id`, `question`, `answer`, `categoryId`) VALUES
192(10, 'How much time will be credited money in account?', 'Deposit process goes automatically. It usually takes ~10 minutes.\r\n<br>\r\n<font color="red">Wait for 4 block confirmations! Don''t ask support every 5 minutes.</font>', 8),
193(9, 'Main Rules', '<font color="green"><b>√</b></font> <font color="black"> Price for CVV starts from <b>3$</b></font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Price for dumps starts from <b>10$</b></font><br>\r\n<font color="green"><b><b>√</b></b></font> <font color="black"> Fast automatic payment methods</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Frequent UPDATES</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Instant stuff delivery</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Replace lost/stolen/hold/card error</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Fully secure. No logging. No IP tracking</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Ticket support contacting</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Jabber supporting</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Selection of dumps with bin, country, type</font><br>\r\n<font color="green"><b>√</b></font> <font color="black"> Individual approach to each customer</font><br>\r\n<font color="red"><b><b>x</b></b></font> <font color="gray"> NO money back</font><br>\r\n<font color="red"><b>x</b></font> <font color="gray"> NO dumps with pin</font><br>\r\n<font color="red"><b>x</b></font> <font color="gray"> NO any free test</font>', 7),
194(16, 'What payment methods are available?', 'Bitcoin and Perfect Money.\r\nDon''t ask about WU and Webmoney, use exchange services.', 8),
195(17, 'Checker said "UNKNOWN"', 'It''s not a refunded way, we replace only DEAD cards.\r\nBut if you know that card not valid - ask support please.', 12),
196(18, 'How much time to check?', '<b>60 minutes</b> for dumps and <b>10 minutes</b> for CC.', 12);
197
198CREATE TABLE IF NOT EXISTS `salepack` (
199 `id` int(11) NOT NULL AUTO_INCREMENT,
200 `date` datetime NOT NULL,
201 `used` int(11) NOT NULL,
202 `name` varchar(255) NOT NULL,
203 `categoryname` varchar(255) NOT NULL,
204 `type` varchar(255) NOT NULL,
205 `level` varchar(255) NOT NULL,
206 `class` varchar(255) DEFAULT NULL,
207 `code` varchar(255) NOT NULL,
208 `comment1` varchar(255) NOT NULL,
209 `comment2` varchar(255) NOT NULL,
210 `country` varchar(255) NOT NULL,
211 `value` int(11) NOT NULL,
212 `price` int(11) NOT NULL,
213 `seller` int(11) NOT NULL,
214 `sellerprc` varchar(11) NOT NULL DEFAULT '0',
215 `refund` varchar(11) NOT NULL DEFAULT '0',
216 PRIMARY KEY (`id`)
217) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
218
219CREATE TABLE IF NOT EXISTS `settings` (
220 `settingId` int(11) NOT NULL AUTO_INCREMENT,
221 `settingName` varchar(256) NOT NULL,
222 `settingInfo` varchar(256) NOT NULL,
223 `settingValue` varchar(256) NOT NULL,
224 PRIMARY KEY (`settingId`),
225 UNIQUE KEY `settingName` (`settingName`)
226) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;
227
228INSERT INTO `settings` (`settingId`, `settingName`, `settingInfo`, `settingValue`) VALUES
229(1, 'SiteName', 'SiteName', 'CvvDump.com'),
230(2, 'Buy&Check', 'Buy&Check', '0'),
231(3, 'adminEmail', 'Admin email', 'admin@localhost.com'),
232(4, 'homeUrl', 'Site home url', 'http://cvvdump.com/'),
233(5, 'currency_code', 'Currency code', 'USD'),
234(6, 'currency_symb', 'Currency symbol', '$'),
235(7, 'merchant', 'PM ACCOUNT', 'U0004759'),
236(8, 'storename', 'PM STORE NAME', 'BestShop'),
237(9, 'securityword', 'ALTERNATE PM PASS strtoupper(md5($password)', '80F632EBFE5295A9F8933E360EB382DF'),
238(10, 'themeadmin', 'Admin Template', 'theme_black_green.css'),
239(11, 'themeusr', 'User Template', 'theme_navy.css'),
240(12, 'CheckerPrice', 'Checker Price (0.1 - [dot!])', '0.3'),
241(13, 'checktime', 'Time for Check(min)', '10'),
242(14, 'blockchain_root', 'Blockchain Root', 'http://blockchain.info/'),
243(15, 'blockchain_secret', 'Blockchain random Secret Key', 'RANDOM'),
244(16, 'my_bitcoin_address', 'Bitcoin Address', '17ioSud7ha1B2Xjhu5oPPcGChWZY86nPLu'),
245(17, 'mindeposit', 'Minimal Deposit', '10'),
246(18, 'pmdeposit', 'Deposit PM', '1'),
247(19, 'btcdeposit', 'Deposit BTC', '1'),
248(20, 'Dump_Buy&Check', 'Dump Buy&Check', '0'),
249(21, 'dumpchecktime', 'Dump check Time', '60'),
250(22, 'saledump', 'Sale Dumps', '1'),
251(23, 'salecc', 'Sale CC', '1'),
252(24, 'dumpchecker', 'Dump Checker', 'dumpchecker.php'),
253(25, 'CCchecker', 'CC Checker', 'checker.php'),
254(26, 'packs', 'Sale Packs', '1'),
255(27, 'logo', 'Logo[html]', 'CVV <i class="fa fa-credit-card"></i> DUMP'),
256(28, 'salecheck', 'CC Checker', '1'),
257(29, 'btcspeed', 'Bitcoin Speed', '1'),
258(30, 'btconfirm', 'BTC Confirmations', '2'),
259(31, 'bcguid', 'Blockchain GUID', '400000000-0000-4000-0000-00000000000'),
260(32, 'bcmainpass', 'Blockchain Main Password', 'password'),
261(33, 'UPMUSD', 'Unitaco PM USD', '1'),
262(34, 'UWMZ', 'Unitaco WMZ', '1'),
263(35, 'UPAYMERZ', 'Unitaco PAYMER Z', '1'),
264(36, 'UMERCH', 'Unitaco MERCHANT', 'MERCH'),
265(37, 'UPASS', 'Unitaco Password', 'PASSWORD');
266
267CREATE TABLE IF NOT EXISTS `support` (
268 `id` int(11) NOT NULL AUTO_INCREMENT,
269 `user_id` int(11) NOT NULL,
270 `date_msg` datetime NOT NULL,
271 `read_msg` int(11) NOT NULL,
272 `msg` text NOT NULL,
273 `msgfrom` int(11) NOT NULL,
274 `read_msg_admin` int(11) NOT NULL DEFAULT '0',
275 PRIMARY KEY (`id`)
276) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
277
278--
279-- Структура таблицы `types`
280--
281
282CREATE TABLE IF NOT EXISTS `types` (
283 `typeId` int(11) NOT NULL AUTO_INCREMENT,
284 `typeName` varchar(128) NOT NULL,
285 `typeColor` varchar(10) NOT NULL,
286 PRIMARY KEY (`typeId`)
287) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
288
289INSERT INTO `types` (`typeId`, `typeName`, `typeColor`) VALUES
290(1, 'Admin', '#ff0000'),
291(2, 'Member', '#000000'),
292(3, 'Seller', '#42aaff');
293
294CREATE TABLE IF NOT EXISTS `users` (
295 `userId` int(11) NOT NULL AUTO_INCREMENT,
296 `username` varchar(128) NOT NULL,
297 `password` varchar(128) NOT NULL,
298 `jabber` varchar(256) NOT NULL,
299 `typeId` int(11) NOT NULL DEFAULT '2',
300 `credit` double NOT NULL DEFAULT '0',
301 `paids` varchar(50) NOT NULL DEFAULT '0',
302 `regDate` int(11) NOT NULL,
303 PRIMARY KEY (`userId`),
304 UNIQUE KEY `username` (`username`)
305) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
306
307INSERT INTO `users` (`userId`, `username`, `password`, `jabber`, `typeId`, `credit`, `paids`, `regDate`) VALUES
308(1, 'admin', '200ceb26807d6bf99fd6f4f0d1ca54d4', 'p9i9n2@0nl1ne.at', 1, 145.5, '0', 1277164490);