اطلاعات کاربری
فول آلبوم
آمار سایت
کدهای اختصاصی
-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 24, 2008 at 05:54 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `tstore`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL auto_increment,
`admin_username` varchar(50) NOT NULL default '',
`admin_password` varchar(200) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`paypal_email` varchar(100) NOT NULL default '',
`stormpay_email` varchar(100) NOT NULL default '',
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`admin_id`, `admin_username`, `admin_password`, `email`, `paypal_email`, `stormpay_email`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@zeescripts.com', 'admin@zeescripts.com', '');
-- --------------------------------------------------------
--
-- Table structure for table `ads`
--
CREATE TABLE `ads` (
`adid` int(10) unsigned NOT NULL default '0',
`image` varchar(50) default NULL,
`url` varchar(255) default NULL,
`code` text,
`impressions` int(10) unsigned default '0',
`clicks` int(11) default '0',
`groupid` int(10) unsigned default NULL,
`type` char(1) default NULL,
`name` varchar(255) default NULL,
PRIMARY KEY (`adid`),
UNIQUE KEY `adid` (`adid`),
KEY `adid_2` (`adid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ads`
--
INSERT INTO `ads` (`adid`, `image`, `url`, `code`, `impressions`, `clicks`, `groupid`, `type`, `name`) VALUES
(24, 'gif', 'http://hostflv.com', NULL, 13, 1, 2, 'O', 'test'),
(20, 'gif', 'http://http://www.ZeeDigital.com', NULL, 727, 0, 4, 'O', 'bottom'),
(23, 'gif', 'http://www.zeescripts.com', NULL, 295, 0, 3, 'O', 'Zeescripts.com');
-- --------------------------------------------------------
--
-- Table structure for table `ad_groups`
--
CREATE TABLE `ad_groups` (
`groupid` int(10) unsigned NOT NULL default '0',
`groupname` varchar(255) NOT NULL default '',
PRIMARY KEY (`groupid`),
UNIQUE KEY `groupid` (`groupid`),
KEY `groupid_2` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ad_groups`
--
INSERT INTO `ad_groups` (`groupid`, `groupname`) VALUES
(2, 'Right Banner/Text Ad (120x600)'),
(3, 'Left Tower Banner/Text Ad (160x600)'),
(4, 'Bottom Banner/Text Ad (728x90)');
-- --------------------------------------------------------
--
-- Table structure for table `cat`
--
CREATE TABLE `cat` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `cat`
--
INSERT INTO `cat` (`id`, `name`) VALUES
(1, 'WEB TEMPLATES'),
(2, 'FLASH TEMPLATES'),
(3, 'IDENTITY KITS'),
(4, 'CORPORATE IDS'),
(5, 'LOGO TEMPLATES'),
(6, 'BROCHURE DESIGNS'),
(7, 'STOCK PHOTOS'),
(8, 'VECTOR ICONS'),
(9, 'OTHER DESIGNS');
-- --------------------------------------------------------
--
-- Table structure for table `currency`
--
CREATE TABLE `currency` (
`code` varchar(10) NOT NULL default '',
`name` varchar(200) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `currency`
--
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE `members` (
`members_id` int(11) NOT NULL auto_increment,
`members_sid` varchar(32) NOT NULL default '',
`members_username` varchar(50) NOT NULL default '',
`members_password` varchar(200) NOT NULL default '',
`members_email` varchar(50) NOT NULL default '',
`members_firstname` varchar(50) NOT NULL default '',
`members_lastname` varchar(50) NOT NULL default '',
`members_addy1` varchar(100) NOT NULL default '',
`members_addy2` varchar(100) NOT NULL default '',
`members_phone` varchar(20) NOT NULL default '',
`members_city` varchar(50) NOT NULL default '',
`members_state` varchar(50) NOT NULL default '',
`members_zip` varchar(5) NOT NULL default '',
`members_country` varchar(50) NOT NULL default '',
`members_paypalemail` varchar(50) NOT NULL default '',
`members_stormpayemail` varchar(50) NOT NULL default '',
`is_pro_member` tinyint(4) NOT NULL default '0',
`member_balance` double NOT NULL default '0',
`members_expiredate` varchar(20) NOT NULL default '',
`members_creationdate` varchar(20) NOT NULL default '',
`members_status` tinyint(4) NOT NULL default '0',
`member_activationcode` varchar(32) NOT NULL default '',
`members_paymentmethod` tinyint(4) NOT NULL default '0',
`affiliate_clicks` int(11) NOT NULL default '0',
`affiliate_referral` int(11) NOT NULL default '0',
`affiliate_commission` int(11) NOT NULL default '0',
`affiliate` varchar(255) NOT NULL default '',
PRIMARY KEY (`members_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` (`members_id`, `members_sid`, `members_username`, `members_password`, `members_email`, `members_firstname`, `members_lastname`, `members_addy1`, `members_addy2`, `members_phone`, `members_city`, `members_state`, `members_zip`, `members_country`, `members_paypalemail`, `members_stormpayemail`, `is_pro_member`, `member_balance`, `members_expiredate`, `members_creationdate`, `members_status`, `member_activationcode`, `members_paymentmethod`, `affiliate_clicks`, `affiliate_referral`, `affiliate_commission`, `affiliate`) VALUES
(13, 'c51ce410c124a10e0db5e4b97fc2af39', 'tester', 'f5d1278e8109edd94e1e4197e04873b9', 'tester@tester.com', 'tester', 'tester', 'tester', 'tester', '232323', 'tester', 'tester', '22323', 'India', 'tester@tester.com', '', 1, 179.86, '12/31/2007', '12/31/2007', 1, '35fecb53fdcd9b48432cd5040db3177c', 0, 0, 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `membertype`
--
CREATE TABLE `membertype` (
`membertype_id` int(11) NOT NULL auto_increment,
`membertype_name` varchar(255) NOT NULL default '',
`membertype_fee` double NOT NULL default '0',
`membertype_nop` int(11) NOT NULL default '0',
PRIMARY KEY (`membertype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `membertype`
--
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE `product` (
`product_id` int(11) NOT NULL auto_increment,
`product_title` varchar(255) NOT NULL default '',
`subcategory` int(11) NOT NULL default '0',
`product_picture_url` varchar(255) NOT NULL default '',
`product_upload_url` varchar(255) NOT NULL default '',
`product_description` text NOT NULL,
`product_brief` varchar(60) NOT NULL default '',
`product_delivery_info` text NOT NULL,
`product_price` double NOT NULL default '0',
`product_thankyou` text NOT NULL,
`product_member_id` varchar(32) NOT NULL default '0',
`product_creation_date` varchar(32) NOT NULL default '',
`product_feature` tinyint(4) NOT NULL default '0',
`product_sid` varchar(32) NOT NULL default '',
`payby_pp` tinyint(4) NOT NULL default '1',
`payby_sp` tinyint(4) NOT NULL default '1',
`was_feature_flag` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `product`
--
INSERT INTO `product` (`product_id`, `product_title`, `subcategory`, `product_picture_url`, `product_upload_url`, `product_description`, `product_brief`, `product_delivery_info`, `product_price`, `product_thankyou`, `product_member_id`, `product_creation_date`, `product_feature`, `product_sid`, `payby_pp`, `payby_sp`, `was_feature_flag`) VALUES
(1, 'Colored Art template', 21, 'upload/image/1230112343.png', 'http://www.italianlightandmagic.com/multistore.zip', 'sample template blue sample template blue\r\nsample template blue sample template blue\r\nsample template blue sample template blue\r\nsample template blue sample template blue\r\n\r\nsample template blue sample template blue\r\nsample template blue sample template blue\r\nsample template blue sample template blue\r\nsample template blue sample template blue', 'sample template colored', 'sample template blue sample template blue', 27, 'sample template blue sample template blue', 'c51ce410c124a10e0db5e4b97fc2af39', '12/24/2008', 1, 'c4ca4238a0b923820dcc509a6f75849b', 1, 0, 1),
(2, 'Flash template sample', 23, 'upload/image/1230112931.png', 'http://www.italianlightandmagic.com/multistore.zip', 'sample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\n\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\n', 'sample template description', 'sample template description sample template description', 49, 'sample template description sample template description', 'c51ce410c124a10e0db5e4b97fc2af39', '12/24/2008', 1, 'c81e728d9d4c2f636f067f89cc14862c', 1, 0, 1),
(3, 'Green Design', 29, 'upload/image/1230113088.png', 'http://www.italianlightandmagic.com/multistore.zip', 'sample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\n\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description', 'sample template green', 'sample template green', 37, 'sample template green', 'c51ce410c124a10e0db5e4b97fc2af39', '12/24/2008', 1, 'eccbc87e4b5ce2fe28308fd9f2a7baf3', 1, 0, 1),
(4, 'Black cinema', 12, 'upload/image/1230113187.png', 'http://www.italianlightandmagic.com/multistore.zip', 'sample template green sample template green \r\nsample template green sample template green \r\nsample template green sample template green \r\nsample template green sample template green \r\n\r\nsample template green sample template green \r\nsample template green sample template green \r\nsample template green sample template green \r\nsample template green sample template green ', 'sample template description', 'sample template green sample template green ', 47, 'sample template green sample template green ', 'c51ce410c124a10e0db5e4b97fc2af39', '12/24/2008', 1, 'a87ff679a2f3e71d9181a67b7542122c', 1, 0, 1),
(5, 'Dating Template', 18, 'upload/image/1230113533.png', 'http://www.italianlightandmagic.com/multistore.zip', 'sample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\n\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description\r\nsample template description sample template description', 'sample template description', 'sample template description sample template description', 49, 'sample template description sample template description', 'c51ce410c124a10e0db5e4b97fc2af39', '12/24/2008', 1, 'e4da3b7fbbce2345d7772b0674a318d5', 1, 0, 1),
(6, 'Stock Photo', 44, 'upload/image/1230113735.jpg', 'http://www.italianlightandmagic.com/multistore.zip', 'sample description sample description\r\nsample description sample description\r\nsample description sample description\r\nsample description sample description\r\n\r\nsample description sample description\r\nsample description sample description\r\nsample description sample description', 'sample description ', 'sample description sample description', 4, 'sample description sample description', 'c51ce410c124a10e0db5e4b97fc2af39', '12/24/2008', 1, '1679091c5a880faf6fb5e6087eb1b2dc', 1, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `sale`
--
CREATE TABLE `sale` (
`sid` bigint(20) NOT NULL auto_increment,
`product_sid` varchar(32) NOT NULL default '',
`sale_time` varchar(200) NOT NULL default '',
`quantity` int(11) NOT NULL default '0',
`price` double NOT NULL default '0',
PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Luu tru cac phien mua hang cua khach hang' AUTO_INCREMENT=7 ;
--
-- Dumping data for table `sale`
--
INSERT INTO `sale` (`sid`, `product_sid`, `sale_time`, `quantity`, `price`) VALUES
(6, 'a5771bce93e200c36f7cd9dfd0e5deaa', '1143038154', 1, 9.99);
-- --------------------------------------------------------
--
-- Table structure for table `subcat`
--
CREATE TABLE `subcat` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;
--
-- Dumping data for table `subcat`
--
INSERT INTO `subcat` (`id`, `catid`, `name`) VALUES
(4, 1, 'Wedding & Party'),
(5, 1, 'Webhosting Stuff'),
(6, 1, 'Travel & Vacation '),
(7, 1, 'Sports & Activities '),
(8, 1, 'Shopping & Stores'),
(9, 1, 'Real Estate '),
(10, 1, 'People & Ethnic '),
(11, 1, 'Legal & Government '),
(12, 1, 'IT & Software '),
(13, 1, 'Home & Furniture '),
(14, 1, 'Health & Medicine '),
(15, 1, 'Hobbies And Crafts '),
(16, 1, 'Food & Dining '),
(17, 1, 'Fashion & Beauty '),
(18, 1, 'Dating & Romance '),
(19, 1, 'Books & Education'),
(20, 1, 'Animals & Pets'),
(21, 1, 'Art & Music '),
(22, 2, 'Flash Intros'),
(23, 2, 'Full Flash Sites'),
(24, 2, 'Flash Animations'),
(25, 2, 'Flash Banners'),
(26, 3, 'Corporate'),
(27, 3, 'Education'),
(28, 3, 'Ecommerce'),
(29, 3, 'Web Design'),
(30, 5, 'Corporate'),
(31, 4, 'Web Design'),
(32, 4, 'Ecommerce'),
(33, 4, 'Education'),
(35, 4, 'Corporate'),
(36, 5, 'Web Design'),
(37, 5, 'Ecommerce'),
(38, 5, 'Education'),
(39, 6, 'Ecommerce'),
(40, 6, 'Web Design'),
(41, 6, 'Education'),
(42, 6, 'Corporate'),
(43, 7, 'Arts & Education'),
(44, 7, 'Nature & abstracts'),
(45, 8, 'Windows Icons'),
(46, 8, 'Internet Icons'),
(47, 9, 'General others');
-- --------------------------------------------------------
--
-- Table structure for table `transaction`
--
CREATE TABLE `transaction` (
`transaction_id` bigint(20) NOT NULL auto_increment,
`transaction_membersid` varchar(100) NOT NULL default '0',
`transaction_createdate` bigint(20) NOT NULL default '0',
`transaction_amount` double NOT NULL default '0',
`transaction_type` varchar(200) NOT NULL default '0',
PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Dumping data for table `transaction`
--
INSERT INTO `transaction` (`transaction_id`, `transaction_membersid`, `transaction_createdate`, `transaction_amount`, `transaction_type`) VALUES
(22, 'c51ce410c124a10e0db5e4b97fc2af39', 1199105734, 200, ''),
(23, 'c51ce410c124a10e0db5e4b97fc2af39', 1199189220, -0.02, 'Set product tester to feature listing'),
(24, 'c51ce410c124a10e0db5e4b97fc2af39', 1230094757, -0.02, 'Set product ZEE LYRICS CMS PHP WEBSITE SCRIPT 2.0 to feature listing'),
(25, 'c51ce410c124a10e0db5e4b97fc2af39', 1230104059, -0.02, 'Set product Blue Art to feature listing'),
(26, 'c51ce410c124a10e0db5e4b97fc2af39', 1230112345, -0.02, 'Set product Blue Art template to feature listing'),
(27, 'c51ce410c124a10e0db5e4b97fc2af39', 1230112933, -0.02, 'Set product Flash template sample to feature listing'),
(28, 'c51ce410c124a10e0db5e4b97fc2af39', 1230113090, -0.02, 'Set product Green Design to feature listing'),
(29, 'c51ce410c124a10e0db5e4b97fc2af39', 1230113188, -0.02, 'Set product Black cinema to feature listing'),
(30, 'c51ce410c124a10e0db5e4b97fc2af39', 1230113535, -10, 'Set product Dating Template to feature listing'),
(31, 'c51ce410c124a10e0db5e4b97fc2af39', 1230113764, -10, 'Set product Stock Photo to feature listing');
-- --------------------------------------------------------
--
-- Table structure for table `webconfig`
--
CREATE TABLE `webconfig` (
`contact` text NOT NULL,
`help` text NOT NULL,
`product_per_page` int(11) NOT NULL default '0',
`feature_product_random` int(11) NOT NULL default '0',
`free_posting` int(11) NOT NULL default '0',
`comission_paid` double NOT NULL default '0',
`free_fee_feature_posting` double NOT NULL default '0',
`featureposting_fee` double NOT NULL default '0',
`normalposting_fee` double NOT NULL default '0',
`negative_member_money_bounds` double NOT NULL default '0',
`minimum_deposit_money` double NOT NULL default '0',
`promember_fee` double NOT NULL default '0',
`web_title` varchar(255) NOT NULL default '',
`meta_content` varchar(255) NOT NULL default '',
`template_url` varchar(255) NOT NULL default '',
`default_product_img` varchar(255) NOT NULL default '',
`admin_email` varchar(200) NOT NULL default '',
`admin_pemail` varchar(200) NOT NULL default '',
`admin_semail` varchar(200) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `webconfig`
--
INSERT INTO `webconfig` (`contact`, `help`, `product_per_page`, `feature_product_random`, `free_posting`, `comission_paid`, `free_fee_feature_posting`, `featureposting_fee`, `normalposting_fee`, `negative_member_money_bounds`, `minimum_deposit_money`, `promember_fee`, `web_title`, `meta_content`, `template_url`, `default_product_img`, `admin_email`, `admin_pemail`, `admin_semail`) VALUES
('
\r\n
\r\n
\r\n\r\n
Can Change your text or html form in admin panel..
', 'Your Help Text - Edit from Admin Panel...
\r\nYour Help Text - Edit from Admin Panel...
\r\nYour Help Text - Edit from Admin Panel...
\r\nYour Help Text - Edit from Admin Panel...
\r\nYour Help Text - Edit from Admin Panel...
\r\n', 5, 5, 5, 10, 25, 10, 0, 50, 50, 24.99, 'Multiseller Digital Store PHP Script', 'Multiseller Digital Store PHP Script - Buy & Sell Templates', 'template/default', 'upload/image/0.gif', 'admin@zeescripts.com', 'admin@zeescripts.com', 'admin@zeescripts.com');