· 10 years ago · Jan 14, 2016, 11:24 PM
1
2text/x-generic zadmin_shop.sql ( ASCII English text, with very long lines )
3
4-- phpMyAdmin SQL Dump
5-- version 3.5.8.1
6-- http://www.phpmyadmin.net
7--
8-- Host: localhost
9-- Generation Time: Dec 19, 2015 at 04:37 PM
10-- Server version: 5.1.73
11-- PHP Version: 5.3.3
12
13SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
14SET time_zone = "+00:00";
15
16
17/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
18/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
19/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
20/*!40101 SET NAMES utf8 */;
21
22--
23-- Database: `zadmin_shop`
24--
25
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `accounts`
30--
31
32CREATE TABLE IF NOT EXISTS `accounts` (
33 `account_id` int(6) NOT NULL AUTO_INCREMENT,
34 `acctype` varchar(30) NOT NULL,
35 `country` varchar(30) NOT NULL,
36 `info` varchar(150) NOT NULL,
37 `addinfo` varchar(150) NOT NULL,
38 `login` varchar(150) NOT NULL,
39 `pass` varchar(150) NOT NULL,
40 `cat` int(1) NOT NULL,
41 `sold` int(1) NOT NULL,
42 `price` decimal(10,2) NOT NULL,
43 `username` varchar(30) NOT NULL,
44 `date_added` varchar(30) NOT NULL,
45 `valid_system` varchar(10) NOT NULL,
46 `valid_user` varchar(10) NOT NULL,
47 `total_price` decimal(10,2) NOT NULL,
48 `date_purchased` varchar(30) NOT NULL,
49 `addbyid` int(6) NOT NULL DEFAULT '1',
50 `addby` varchar(30) NOT NULL,
51 PRIMARY KEY (`account_id`),
52 UNIQUE KEY `account_id` (`account_id`)
53) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;
54
55--
56-- Dumping data for table `accounts`
57--
58
59INSERT INTO `accounts` (`account_id`, `acctype`, `country`, `info`, `addinfo`, `login`, `pass`, `cat`, `sold`, `price`, `username`, `date_added`, `valid_system`, `valid_user`, `total_price`, `date_purchased`, `addbyid`, `addby`) VALUES
60(51, 'Mailer', 'Inbox', '100%', 'mailer.com', '/', '/\r', 2, 1, '3.00', 'tools28shopDEL', '2015-06-22 15:51:19', 'NONE', 'NONE', '0.00', '2015-12-18 18:15:05', 1, 'Borex Team'),
61(52, 'Mailer', 'Inbox', '100%', 'mailer.com', '/', '/\r', 2, 0, '3.00', 'NONE', '2015-06-22 15:51:19', 'NONE', 'NONE', '0.00', 'NONE', 1, 'Borex Team'),
62(53, 'Mailer', 'Inbox', '100%', 'mailer.com', '/', '/\r', 2, 1, '3.00', 'tools28shop', '2015-06-22 15:51:19', 'NONE', 'NONE', '0.00', '2015-12-18 18:26:43', 1, 'Borex Team'),
63(54, 'Mailer', 'Inbox', '100%', 'mailer.com', '/', '/\r', 2, 0, '3.00', 'NONE', '2015-06-22 15:51:19', 'NONE', 'NONE', '0.00', 'NONE', 1, 'Borex Team'),
64(55, 'Mailer', 'Inbox', '100%', 'mailer.com', '/', '/', 2, 0, '3.00', 'NONE', '2015-06-22 15:51:19', 'NONE', 'NONE', '0.00', 'NONE', 1, 'Borex Team'),
65(58, 'test', 'test', 'test', 'teest', 'teest', 'test', 1, 1, '3.00', 'tools28shop', '2015-12-17 19:01:08', 'NONE', 'NONE', '0.00', '2015-12-18 17:00:33', 1, 'tools28shop'),
66(59, 'match', 'Usa', 'login succes - work 100%', '/', 'justmaricar@yahoo.com', 'jahluv1', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
67(60, 'match', 'Usa', 'login succes - work 100%', '/', 'ammalgam@yahoo.com', 'papsi1', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
68(61, 'match', 'Usa', 'login succes - work 100%', '/', 'mthomas456@yahoo.com', 'greentea', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
69(62, 'match', 'Usa', 'login succes - work 100%', '/', 'swovy5@yahoo.com', 'soheil', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
70(63, 'match', 'Usa', 'login succes - work 100%', '/', 'fleabag17@yahoo.com', 'bass17', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
71(64, 'match', 'Usa', 'login succes - work 100%', '/', 'jerrylee4tx@yahoo.com', 'i84girls', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
72(65, 'match', 'Usa', 'login succes - work 100%', '/', 'dustyp10@yahoo.com', 'o10081974', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
73(66, 'match', 'Usa', 'login succes - work 100%', '/', 'bigrob1027@yahoo.com', 'starling', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
74(67, 'match', 'Usa', 'login succes - work 100%', '/', 'guy5004@yahoo.com', 'str123', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
75(68, 'match', 'Usa', 'login succes - work 100%', '/', 'bna1026@yahoo.com', '12201989', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
76(69, 'match', 'Usa', 'login succes - work 100%', '/', 'dodpilot@yahoo.com', 'galaxy', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
77(70, 'match', 'Usa', 'login succes - work 100%', '/', 'joseph5029@yahoo.com', 'maricopa', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
78(71, 'match', 'Usa', 'login succes - work 100%', '/', 'rjbuck66@yahoo.com', 'farmer66', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
79(72, 'match', 'Usa', 'login succes - work 100%', '/', 'aikman@yahoo.com', 'aikman', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
80(73, 'match', 'Usa', 'login succes - work 100%', '/', 'delta123@yahoo.com', 'delta123', 1, 0, '2.00', 'NONE', '2015-12-18 14:03:30', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
81(74, 'shell', 'test', 'test', 'http://oliveandtheivy.com/active.php ', 'test2', 'test', 2, 0, '3.00', 'NONE', '2015-12-18 17:53:33', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
82(75, 'Mailer', 'test', 'test', 'http://ibtnetwork.com/match.php', 'test', 'test', 2, 0, '3.00', 'NONE', '2015-12-18 17:54:26', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop'),
83(76, 'cPanel', 'testc', 'test', 'https://maritimeservicesgroup.net:2083', 'mama3875', '5x0vf^c$', 2, 0, '13.00', 'NONE', '2015-12-18 17:55:15', 'NONE', 'NONE', '0.00', 'NONE', 1, 'tools28shop');
84
85-- --------------------------------------------------------
86
87--
88-- Table structure for table `cards`
89--
90
91CREATE TABLE IF NOT EXISTS `cards` (
92 `cardid` int(6) NOT NULL AUTO_INCREMENT,
93 `number` varchar(30) NOT NULL,
94 `expire` varchar(10) NOT NULL,
95 `cvv` varchar(10) NOT NULL,
96 `firstname` varchar(20) NOT NULL,
97 `lastname` varchar(20) NOT NULL,
98 `address` varchar(50) NOT NULL,
99 `city` varchar(30) NOT NULL,
100 `zip` varchar(20) NOT NULL,
101 `state` varchar(50) NOT NULL,
102 `country` varchar(50) NOT NULL,
103 `email` varchar(50) NOT NULL,
104 `phone` varchar(30) NOT NULL,
105 `card_type` varchar(20) NOT NULL,
106 `dob` varchar(30) NOT NULL,
107 `sold` int(1) NOT NULL,
108 `price` decimal(10,2) NOT NULL,
109 `username` varchar(30) NOT NULL,
110 `date_added` varchar(30) NOT NULL,
111 `valid_system` varchar(10) NOT NULL,
112 `valid_user` varchar(10) NOT NULL,
113 `total_price` decimal(10,2) NOT NULL,
114 `date_purchased` varchar(30) NOT NULL,
115 `ssn` varchar(40) NOT NULL,
116 PRIMARY KEY (`cardid`),
117 UNIQUE KEY `card_id` (`cardid`)
118) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
119
120--
121-- Dumping data for table `cards`
122--
123
124INSERT INTO `cards` (`cardid`, `number`, `expire`, `cvv`, `firstname`, `lastname`, `address`, `city`, `zip`, `state`, `country`, `email`, `phone`, `card_type`, `dob`, `sold`, `price`, `username`, `date_added`, `valid_system`, `valid_user`, `total_price`, `date_purchased`, `ssn`) VALUES
125(9, 'NONE', '', '', '', '', '', '', '', '', '', '', '', 'Unknown', '', 1, '3.00', 'admin', '2015-03-24 21:58:35', 'NONE', 'Approved', '0.00', '2015-03-25 20:59:13', ''),
126(8, '4721732173', '36123671', '12673712', 'ergjan ', 'jaha', 'epo', 'ktu', '2138129831@ahsudas.c', 'atje', 'hasudhuas', '12737213', '8312731283', 'Visa', 'kosova', 1, '3.00', 'admin', '2015-03-24 21:58:35', 'NONE', 'Approved', '0.00', '2015-03-25 20:59:13', '732173712'),
127(10, '4744880045610332', '07/15', '333', '', 'Altin', 'pogragja', 'gilan', '69999', 'kari', 'albania', 'NONE', '', 'Visa', 'NONE', 1, '2.50', 'admin', '2015-03-24 18:37:11', 'NONE', 'Approved', '0.00', '2015-03-25 20:59:13', 'NONE'),
128(11, 'NUMBER', 'EXPDATE', 'CVV2', '', 'NAME', 'ADDRESS', 'CITY', 'ZIP', 'STATE', 'COUNTRY', 'PHONE', 'EMAIL', 'Unknown', 'DOB', 1, '3.00', 'admin', '2015-03-25 15:51:30', 'NONE', 'CHECK', '0.00', '2015-03-25 20:59:13', 'SSN'),
129(12, '4744880045610332', '03/17', '222', '', 'altin', 'tini', 'rini', '35353', 'bini', 'alban', 'NONE', '', 'Visa', 'NONE', 1, '5.00', 'admin', '2015-03-25 21:26:50', 'NONE', 'CHECK', '0.00', '2015-03-25 21:27:15', 'NONE'),
130(13, '242424242', '03/18', '222', '', 'altin', 'pgoragja', 'cities', '259295', 'gilan', 'albania', '29529592', 'redonpsycho@yahoo.com', 'Unknown', '2929', 1, '3.00', 'redonpsycho', '2015-03-25 21:48:43', 'NONE', 'Approved', '0.00', '2015-03-25 21:49:11', '295925'),
131(14, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' glowe2709@live.co.uk ', ' BENSOFIA2 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
132(15, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' tracey@solosite.net ', ' class1f1ed \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
133(16, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' bruneisue@ntlworld.com ', ' tammie \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 1, '3.00', 'order1', '2015-03-26 16:29:48', 'NONE', 'CHECK', '0.00', '2015-03-26 21:59:57', 'NONE'),
134(17, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' john_dilks2003@yahoo.com ', ' karathedog2 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
135(18, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' info@weddingwalkway.co.uk ', ' sharm2009 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
136(19, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' laurieweeks@aol.com ', ' Timothy8 ', '', ' \r\n', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
137(20, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' ambreenakhtar_6@hotmail.com ', ' abc123456 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
138(21, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' shaun.mitchell90@googlemail.com ', ' shauns10 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
139(22, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' andyrogers11@hotmail.com ', ' calvin04 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
140(23, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' thetreasurechest@fsmail.net ', ' ttc123 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 1, '3.00', 'order1', '2015-03-26 16:29:48', 'NONE', 'CHECK', '0.00', '2015-03-26 16:31:00', 'NONE'),
141(24, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' orieljohnson@btinternet.com ', ' littlewelsh1 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
142(25, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' sales@theallinoneweddingshop.co.uk ', 'charlie26 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 1, '3.00', 'redonpsycho', '2015-03-26 16:29:48', 'NONE', 'CHECK', '0.00', '2015-03-27 16:00:36', 'NONE'),
143(26, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' Sylvieroma@yahoo.fr ', ' andrew \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
144(27, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' savingscentredirect@live.co.uk ', ' jasmine2201 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
145(28, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' pumamedia@ntlworld.com ', ' rudi309 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
146(29, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' elliann@live.co.uk ', ' 22london \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
147(30, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' moulanasu@hotmail.com ', ' chilaw56 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
148(31, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' mckayjewellers@btconnect.com ', ' rocks123 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
149(32, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' rachael@cherlaan.com ', ' 31Woodhall \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
150(33, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' katebekontakt@googlemail.com ', ' galkowek1984 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
151(34, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' coobarbara@aol.com ', ' gambia \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
152(35, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' info@theweddingshop.co.za ', ' wed2580 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
153(36, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' info@jbfjewelry.nl ', ' john2460 ', '', ' \r\n', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
154(37, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' lilgemz@btinternet.com ', ' gromitdog1 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
155(38, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' partyproducts@hotmail.co.uk ', ' oldmanor \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
156(39, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' jacquelines4u@yahoo.co.uk ', ' gershwin \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
157(40, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' info@tiptopweddingshop.co.uk ', ' wedding1 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
158(41, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' keithlilley@aformalaffair.co.uk ', ' gunner3759 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 1, '3.00', 'order1', '2015-03-26 16:29:48', 'NONE', 'CHECK', '0.00', '2015-03-27 05:01:29', 'NONE'),
159(42, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' debiryinnovations@yahoo.co.uk ', ' hebrew123 \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
160(43, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' tm@prodevas.com ', ' hillman \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
161(44, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' bargainsforyouall@blueyonder.co.uk ', ' gefcouk \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
162(45, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' cs-handel@web.de ', ' liamfranz \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
163(46, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' carabou@hotmail.co.uk ', ' bedhead \r\n', '', '', '', 'NONE', '', 'Unknown', 'NONE', 0, '3.00', 'NONE', '2015-03-26 16:29:48', 'NONE', 'NONE', '0.00', 'NONE', 'NONE'),
164(47, 'Aliexpress ', ' UK ', ' Feedback:', ' Aliexpress ', '', ' sales@partyworlduk.net ', ' 51704680 ', '', '', '', 'NONE', '', 'Unknown', 'NONE', 1, '3.00', 'order1', '2015-03-26 16:29:48', 'NONE', 'CHECK', '0.00', '2015-03-26 16:31:00', 'NONE');
165
166-- --------------------------------------------------------
167
168--
169-- Table structure for table `cart`
170--
171
172CREATE TABLE IF NOT EXISTS `cart` (
173 `card_id` int(6) NOT NULL AUTO_INCREMENT,
174 `username` varchar(30) NOT NULL,
175 `charge_bin` tinyint(4) NOT NULL,
176 `charge_zip` tinyint(4) NOT NULL,
177 `charge_city` tinyint(4) NOT NULL,
178 PRIMARY KEY (`card_id`)
179) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
180
181-- --------------------------------------------------------
182
183--
184-- Table structure for table `news`
185--
186
187CREATE TABLE IF NOT EXISTS `news` (
188 `nid` int(11) NOT NULL AUTO_INCREMENT,
189 `subject` varchar(400) NOT NULL,
190 `message` mediumtext NOT NULL,
191 `type` varchar(40) NOT NULL,
192 `time` varchar(90) NOT NULL,
193 PRIMARY KEY (`nid`)
194) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
195
196--
197-- Dumping data for table `news`
198--
199
200INSERT INTO `news` (`nid`, `subject`, `message`, `type`, `time`) VALUES
201(44, '<font color="#C88039">Welcome to Shop-cc.com</font>', '<p align="justify">Dear User,<br>\r\n <br>\r\nWelcome to our new Store , <br>\r\nOur store is designed especially for your requests ,<br>\r\n <br>\r\nAt the moment we are Selling only Accounts , Stuff , and some Special tools .<br>\r\nCards & Dumps will be updated very soon .<br>\r\n <br>\r\nWe''re accepting payments from Bitcoin and Perfectmoney .<br>\r\nBoth payments are automatic and don''t take more time than 1 minute to complete .<br>\r\n <br>\r\nWe suggest you to read the rules before Adding Funds !<br>\r\n <br>\r\nFor any problem you have the Ticket System where you can contact Us !<br>\r\n <br>\r\nBest Regards,<br>\r\nShop-cc Team .<br>\r\n</p>', 'news', '2015-12-19 06:18:26'),
202(47, '<font color="#2FA8DD">Other Services</font>', '<br>\r\n[+] We do Spamming Services , the price is 10$ for Spamming 10k e-mails , all providers inbox .<br>\r\n[+] We do Ddos Services , the price is 5$ for Taking down a site for 1 hour , 100$ for taking down a site for 24 hours .\r\n<br>\r\nHope You Like our new Updates , \r\n<br>\r\nIf you have trouble , please contact us . \r\n<br>\r\n \r\n<br>\r\n<b>Shop-cc.com Crew </b>', 'news', '2015-12-19 06:23:45'),
203(48, '<font color="red">SCRIPT UPDATE</font>', '<p align="justify">Dear Customers,<br>\r\nWe have put a lot of hard work in our new script.<br>\r\nWhat makes the new script better ?<br>\r\nThe browsing speed has increased for 2-3 times more than the last one.<br>\r\nMany bugs have been fixed, now you can even see which of your items were or were not refunded.<br>\r\nBuying items is much faster than before, and some of the checkers have been fixed so every Bad items will be deleted from our database and you will only see valid tools on the list.<br>\r\n<br>\r\nOn the reseller page:<br>\r\nYou can now see the top 4 resellers, and the stats have been improved.<br>\r\n<br>\r\n<br>\r\nEnjoy.</p>', 'news', '2015-12-19 06:24:35'),
204(49, '<font color="#691C1C">A FASTER SUPPORT SYSTEM </font>', '<p align="justify">Dear users,<br>\r\nOur Support System has become <b>5x faster</b> ,<br>\r\nFrom now Your tickets / reports will be replied/solved within (maximum) 3 hours .<br>\r\nAlso , please take a look at our <b>Rules</b>, they have been changed a little .<br>\r\n <br>\r\nThanks for understanding ,<br>\r\nShop-CC Team .</p>', 'news', '2015-12-19 06:26:29'),
205(50, '<font color="#C88039">Payments Updated! </font>', '<p align="justify">We have fixed the payments<br>\r\nYou may now add funds, and funds will be added automatically!<br>\r\n<br>\r\nWe thank everyone for their patience.<br>\r\n<br>\r\nBest Regards,<br>\r\nShop-CC Team</p>', 'news', '2015-12-19 06:27:54'),
206(51, '<font color="red">Reseller Mode </font>', '<font color="red">What is a Reseller in our store?</font><br>\n<font color="blue" size="2">If you are a reseller in Shop-CC, you have access to add tools for sale.<br>\nWhen a tool of yours gets sold you will earn 75% of the price that the tool has costed.<br>\nIn order to activate this feature, you need to pay 20$ from your balance.<br>\n</font><br>\nNot to forget to mention, every tool reported in your name will result be checked and if the report says its a bad tool and if the tool was really bad then you will not earn the money of that sold tool.<br>\n<br>\nSincerly,<br>\nShop-CC Team.<br>\n</p>', 'news', '2015-12-19 06:56:15');
207
208-- --------------------------------------------------------
209
210--
211-- Table structure for table `orders`
212--
213
214CREATE TABLE IF NOT EXISTS `orders` (
215 `orderid` int(11) NOT NULL AUTO_INCREMENT,
216 `amount` decimal(10,2) NOT NULL,
217 `btc_amount` varchar(9) NOT NULL,
218 `username` varchar(30) NOT NULL,
219 `address` varchar(50) NOT NULL,
220 `ip` varchar(40) NOT NULL,
221 `method` varchar(15) NOT NULL,
222 `date` varchar(50) NOT NULL,
223 PRIMARY KEY (`orderid`)
224) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
225
226--
227-- Dumping data for table `orders`
228--
229
230INSERT INTO `orders` (`orderid`, `amount`, `btc_amount`, `username`, `address`, `ip`, `method`, `date`) VALUES
231(1, '3.00', '1', 'redonpsycho', '1P3exgsctQ3f3b2LMi2ziZiysL63XdpRPE', 'none', 'Cashout', '2015-06-22 12:14:02'),
232(9, '35.00', '0.0754847', 'tools28shop', '19QtyE569CRNNmqbRS8d847sJPfQbatfuR', 'none', 'Cashout', '2015-12-18 21:09:13'),
233(10, '1.00', '0.0026596', 'tools28shop', '1P5tkM8YSXPyWyhKVG6ZHDKGDwGUBZ63Ry', '78.250.122.7', 'Bitcoin', '2015-12-19 09:02:47');
234
235-- --------------------------------------------------------
236
237--
238-- Table structure for table `purchases`
239--
240
241CREATE TABLE IF NOT EXISTS `purchases` (
242 `purchase_id` int(6) NOT NULL AUTO_INCREMENT,
243 `amount` decimal(10,2) NOT NULL,
244 `username` varchar(30) NOT NULL,
245 `date` varchar(30) NOT NULL,
246 `before_balance` decimal(10,2) NOT NULL,
247 `after_balance` decimal(10,2) NOT NULL,
248 PRIMARY KEY (`purchase_id`),
249 UNIQUE KEY `purchase_id` (`purchase_id`),
250 KEY `purchase_id_2` (`purchase_id`)
251) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3347 ;
252
253--
254-- Dumping data for table `purchases`
255--
256
257INSERT INTO `purchases` (`purchase_id`, `amount`, `username`, `date`, `before_balance`, `after_balance`) VALUES
258(3332, '3.00', 'admin', '2015-03-24 19:10:03', '100.00', '97.00'),
259(3333, '3.00', 'admin', '2015-03-24 19:14:32', '97.00', '94.00'),
260(3334, '3.00', 'admin', '2015-03-24 20:04:11', '92.00', '89.00'),
261(3335, '6.00', 'admin', '2015-03-24 20:43:24', '6.00', '0.00'),
262(3336, '6.00', 'admin', '2015-03-24 20:50:58', '20.00', '14.00'),
263(3337, '3.30', 'admin', '2015-03-24 21:29:44', '13.00', '9.70'),
264(3338, '6.00', 'admin', '2015-03-24 17:25:54', '9.20', '3.20'),
265(3339, '2.50', 'admin', '2015-03-24 18:37:29', '2.70', '0.20'),
266(3340, '3.00', 'admin', '2015-03-25 15:51:49', '4.20', '1.20'),
267(3341, '5.00', 'admin', '2015-03-25 21:27:15', '5.20', '0.20'),
268(3342, '3.50', 'redonpsycho', '2015-03-25 21:49:11', '4.00', '0.50'),
269(3343, '6.00', 'order1', '2015-03-26 16:31:00', '200.00', '194.00'),
270(3344, '3.00', 'order1', '2015-03-26 21:59:57', '194.00', '191.00'),
271(3345, '3.00', 'order1', '2015-03-27 05:01:29', '191.00', '188.00'),
272(3346, '3.00', 'redonpsycho', '2015-03-27 16:00:36', '4.00', '1.00');
273
274-- --------------------------------------------------------
275
276--
277-- Table structure for table `reseller`
278--
279
280CREATE TABLE IF NOT EXISTS `reseller` (
281 `ids` int(6) NOT NULL AUTO_INCREMENT,
282 `username` varchar(30) NOT NULL,
283 `unsold` decimal(10,2) NOT NULL,
284 `sold` decimal(10,2) NOT NULL,
285 `earnings` decimal(10,2) NOT NULL,
286 `solditems` int(6) NOT NULL,
287 `unsolditems` int(6) NOT NULL,
288 `btcaddress` varchar(150) NOT NULL,
289 PRIMARY KEY (`ids`),
290 UNIQUE KEY `ids` (`ids`)
291) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=688 ;
292
293--
294-- Dumping data for table `reseller`
295--
296
297INSERT INTO `reseller` (`ids`, `username`, `unsold`, `sold`, `earnings`, `solditems`, `unsolditems`, `btcaddress`) VALUES
298(686, 'redonpsycho', '0.00', '6.00', '6.00', 2, 19, 'aasfafsdfdkk'),
299(687, 'tools28shop', '55.00', '6.00', '6.00', 2, 20, '19QtyE569CRNNmqbRS8d847sJPfQbatfuR');
300
301-- --------------------------------------------------------
302
303--
304-- Table structure for table `settings`
305--
306
307CREATE TABLE IF NOT EXISTS `settings` (
308 `registration` tinyint(1) NOT NULL,
309 `sitename` varchar(100) NOT NULL,
310 `siteurl` varchar(100) NOT NULL,
311 `site_online` tinyint(1) NOT NULL,
312 `siteemail` varchar(40) NOT NULL,
313 `sitelogo` varchar(300) NOT NULL,
314 `notes` mediumtext NOT NULL,
315 `autorefunds` int(11) NOT NULL,
316 `checker_invalids` int(2) NOT NULL
317) ENGINE=MyISAM DEFAULT CHARSET=latin1;
318
319--
320-- Dumping data for table `settings`
321--
322
323INSERT INTO `settings` (`registration`, `sitename`, `siteurl`, `site_online`, `siteemail`, `sitelogo`, `notes`, `autorefunds`, `checker_invalids`) VALUES
324(1, 'Shop Store', 'https://Shop-cc.com', 1, 'ardit.avdiuinpra@gmail.com', 'Shop Store ', '<?=$sitenotes ?>', 1, 0);
325
326-- --------------------------------------------------------
327
328--
329-- Table structure for table `supportticket`
330--
331
332CREATE TABLE IF NOT EXISTS `supportticket` (
333 `id` int(100) NOT NULL AUTO_INCREMENT,
334 `date` varchar(60) NOT NULL,
335 `reseller` varchar(150) NOT NULL,
336 `username` varchar(30) NOT NULL,
337 `email` varchar(30) NOT NULL,
338 `status` int(1) NOT NULL,
339 `subject` text NOT NULL,
340 `message` text NOT NULL,
341 `hash` varchar(200) NOT NULL,
342 `adminreply` text NOT NULL,
343 `admindate` varchar(60) NOT NULL,
344 `read` int(1) NOT NULL,
345 `badtool` varchar(450) NOT NULL,
346 PRIMARY KEY (`id`)
347) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=214 ;
348
349--
350-- Dumping data for table `supportticket`
351--
352
353INSERT INTO `supportticket` (`id`, `date`, `reseller`, `username`, `email`, `status`, `subject`, `message`, `hash`, `adminreply`, `admindate`, `read`, `badtool`) VALUES
354(190, '2015-06-20 23:01:59', '', '', 'redonpsajko@yahoo.com', 1, '', 't', '', 'NULL', 'NULL', 0, ''),
355(191, '2015-06-22 12:16:52', '', 'redonpsycho', '', 1, 'y', 'y', '', 'NULL', 'NULL', 0, ''),
356(192, '2015-06-22 12:17:00', '', 'redonpsycho', '', 1, '', '', '', 'NULL', 'NULL', 0, ''),
357(193, '2015-06-22 12:17:05', '', 'redonpsycho', '', 1, '', 'fsfsfd', '', 'NULL', 'NULL', 0, ''),
358(194, '2015-06-22 12:19:46', 'BOREX', 'redonpsycho', '', 1, '', '', '', 'NULL', 'NULL', 0, 'NONE'),
359(195, '2015-06-22 12:40:17', 'redonpsycho', 'redonpsycho', '', 1, 'REPORT', 'Reason of Report ? REPOTRER', '', 'NULL', 'NULL', 0, '||||||3.00'),
360(196, '2015-06-22 12:43:21', 'redonpsycho', 'redonpsycho', '', 1, '', 'Reason of Report ?', '', 'NULL', 'NULL', 0, '||||||3.00'),
361(197, '2015-06-22 12:44:19', 'redonpsycho', 'redonpsycho', '', 1, '', 'Reason of Report ?', '', 'NULL', 'NULL', 0, ''),
362(198, '2015-06-22 12:45:19', 'redonpsycho', 'redonpsycho', '', 1, '', 'Reason of Report ?', '', 'adadad', '2015-06-22 14:39:29', 0, '||'),
363(199, '2015-06-22 12:47:51', 'redonpsycho', 'redonpsycho', '', 1, '', 'Reason of Report ?', '', 'NULL', 'NULL', 0, '||||'),
364(200, '2015-06-22 12:48:54', 'redonpsycho', 'redonpsycho', '', 1, '', 'Reason of Report ?', '', 'NULL', 'NULL', 0, ''),
365(201, '2015-06-22 12:49:51', 'redonpsycho', 'redonpsycho', '', 2, '', 'Reason of Report ?', '', 'fdf', '2015-06-22 14:35:49', 0, ''),
366(202, '2015-06-22 12:50:48', 'redonpsycho', 'redonpsycho', '', 4, '', 'Reason of Report ?', '', 'gasdad', '2015-06-22 14:34:01', 0, '33'),
367(203, '2015-06-22 14:39:39', 'redonpsycho', 'redonpsycho', '', 1, '', 'Reason of Report ?', '', 'NULL', 'NULL', 0, '35'),
368(204, '2015-06-22 14:44:34', 'redonpsycho', 'redonpsycho', '', 1, 'asdasd', 'Reason of Report ?asdasd', '', '', '2015-06-22 14:49:30', 0, '34'),
369(205, '2015-06-22 14:51:10', 'BOREX', 'adadada', '', 1, '', '', '', 'NULL', 'NULL', 0, 'NONE'),
370(206, '2015-06-22 14:51:34', 'BOREX', 'adadada', '', 1, 'bad tools', 'bad', '', 'NULL', 'NULL', 0, 'NONE'),
371(207, '2015-06-22 15:01:02', 'BOREX', 'redonpsycho', '', 4, '', '77676', '', '', '2015-06-22 15:05:26', 0, 'NONE'),
372(208, '2015-12-18 19:09:27', 'BOREX', 'tools28shop', '', 1, 'test', 'test', '', 'Refunded', 'NULL', 0, 'NONE'),
373(209, '2015-12-18 19:24:35', 'BOREX', 'tools28shop', '', 1, '', '', '', 'Refunded', 'NULL', 0, 'NONE'),
374(210, '2015-12-18 19:29:22', 'redonpsycho', 'tools28shop', '', 4, 'test', 'Reason of Report ? test', '', 'Refunded', '2015-12-18 20:03:25', 0, '57'),
375(211, '2015-12-18 20:11:22', 'BOREX', 'tools28shop', '', 1, 'test', '1515151 nuk po fuksionon', '', 'Refunded', '2015-12-19 05:46:51', 0, 'NONE'),
376(212, '2015-12-19 07:23:15', 'tools28shop', 'tools28shop', '', 1, 'Match', 'sbon kjo', '', 'Refunded', 'NULL', 0, '79'),
377(213, '2015-12-19 09:41:27', 'BOREX', 'Edontest', '', 1, 'zz', 'zzz', '', 'NULL', 'NULL', 0, 'NONE');
378
379-- --------------------------------------------------------
380
381--
382-- Table structure for table `tbl_users`
383--
384
385CREATE TABLE IF NOT EXISTS `tbl_users` (
386 `id` int(11) NOT NULL AUTO_INCREMENT,
387 `first_name` varchar(25) NOT NULL,
388 `last_name` varchar(25) NOT NULL,
389 `email_id` varchar(50) NOT NULL,
390 `contact_no` bigint(10) NOT NULL,
391 PRIMARY KEY (`id`)
392) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
393
394--
395-- Dumping data for table `tbl_users`
396--
397
398INSERT INTO `tbl_users` (`id`, `first_name`, `last_name`, `email_id`, `contact_no`) VALUES
399(23, 'pradeep', 'khodke', 'pradeep@gmail.com', 9876543210),
400(24, 'sohan', 'mahamune', 'sohan@gmail.com', 9874563210),
401(25, 'john', 'doe', 'john@someone.com', 9778456123),
402(26, 'test', 'test', 'test@test.com', 8745691230);
403
404-- --------------------------------------------------------
405
406--
407-- Table structure for table `users`
408--
409
410CREATE TABLE IF NOT EXISTS `users` (
411 `userid` int(100) NOT NULL AUTO_INCREMENT,
412 `username` varchar(25) NOT NULL,
413 `password` varchar(60) NOT NULL,
414 `plainpassword` varchar(30) NOT NULL,
415 `email` varchar(50) NOT NULL,
416 `icq` int(9) NOT NULL,
417 `balance` decimal(10,2) NOT NULL,
418 `moneyspent` varchar(30) NOT NULL,
419 `regip` varchar(50) NOT NULL,
420 `regdate` varchar(80) NOT NULL,
421 `lastlogin` varchar(80) NOT NULL,
422 `lastip` varchar(50) NOT NULL,
423 `level` int(11) NOT NULL,
424 `banned` int(11) NOT NULL,
425 `amount_purchased` decimal(10,2) NOT NULL,
426 `amount_refunds` int(6) NOT NULL,
427 `items_purchased` mediumint(9) NOT NULL,
428 `reseller` int(1) NOT NULL DEFAULT '0',
429 PRIMARY KEY (`userid`)
430) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=853 ;
431
432--
433-- Dumping data for table `users`
434--
435
436INSERT INTO `users` (`userid`, `username`, `password`, `plainpassword`, `email`, `icq`, `balance`, `moneyspent`, `regip`, `regdate`, `lastlogin`, `lastip`, `level`, `banned`, `amount_purchased`, `amount_refunds`, `items_purchased`, `reseller`) VALUES
437(841, 'admin', '1915e0089738d0ab28a36918b273dd9e', 'Password2', 'admin@blackhat.al', 13812312, '0.20', '0.00', '::1', '2015-03-24 17:35:08', '2015-03-27 15:14:47', '83.183.28.157', 0, 1, '13.00', 0, 5, 1),
438(844, 'redonpsycho', '3ef32e20f1eed67d70baaacfd06126b6', 'Buyer1', 'redonpsajko@yahoo.com', 542452452, '0.00', '0.00', '91.187.125.51', '2015-03-25 21:46:15', '2015-12-17 18:57:32', '78.250.115.14', 2, 1, '2.00', 0, 2, 1),
439(849, 'tools28shop', 'ea6c2c84ba6c1ab841bcca37bd9b3218', 'tools28shop.123', 'toolsshop28@gmail.com', 158764556, '489.00', '9.00', '78.250.115.14', '2015-12-17 18:51:45', '2015-12-19 09:41:07', '78.250.122.7', 2, 0, '-5.00', 6, 0, 1),
440(851, 'hacker', '64b06a690da7547bfb628a7c9c6178ce', 'albaniakosova', 'vik.paloka122@yahoo.com', 0, '0.00', '0.00', '82.114.79.163', '2015-12-18 12:47:44', '2015-12-19 06:50:13', '78.250.122.7', 0, 0, '0.00', 0, 0, 0),
441(852, 'Edontest', 'fdb9625e4ee5e8b593eb5c862ed82e7e', 'Edontest123', 'tedua@live.com', 0, '0.00', '0.00', '31.11.87.125', '2015-12-19 09:39:40', '2015-12-19 09:39:47', '31.11.87.125', 0, 0, '0.00', 0, 0, 0);
442
443/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
444/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
445/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;