

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

-- 
-- Table structure for table `ads`
-- 

CREATE TABLE `ads` (
  `ad_id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_id` smallint(5) unsigned NOT NULL default '0',
  `user_id` smallint(5) unsigned NOT NULL default '0',
  `subject` text NOT NULL,
  `descript` text NOT NULL,
  `url` text NOT NULL,
  `views` int(11) NOT NULL default '0',
  `add_date` int(11) NOT NULL default '0',
  `exp_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ad_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `ads`
-- 

INSERT INTO `ads` VALUES (1, 3, 1, 'Earn $891,289,8 every year!', 'You have just made an important decision that is to start your financial journey in the internet with CompanyName.com, since it is just $17.5 to join and you can earn $891,289,8 every year within 2 friends you invite to CompanyName.com.', 'http://Script4Profit.com', 0, 1170697656, 1171302456);

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

-- 
-- Table structure for table `badwords`
-- 

CREATE TABLE `badwords` (
  `word_id` smallint(5) unsigned NOT NULL auto_increment,
  `word` text NOT NULL,
  PRIMARY KEY  (`word_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `badwords`
-- 

INSERT INTO `badwords` VALUES (1, 'fuck');
INSERT INTO `badwords` VALUES (2, 'shit');
INSERT INTO `badwords` VALUES (3, 'wanker');
INSERT INTO `badwords` VALUES (4, 'bastard');
INSERT INTO `badwords` VALUES (5, 'cunt');
INSERT INTO `badwords` VALUES (6, 'bitch');

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

-- 
-- Table structure for table `banegold`
-- 

CREATE TABLE `banegold` (
  `id` int(30) NOT NULL auto_increment,
  `time` bigint(30) NOT NULL default '0',
  `egold` varchar(100) NOT NULL default '',
  `reason` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `banegold`
-- 


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

-- 
-- Table structure for table `banip`
-- 

CREATE TABLE `banip` (
  `id` int(30) NOT NULL auto_increment,
  `time` bigint(30) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  `reason` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `banip`
-- 


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

-- 
-- Table structure for table `category`
-- 

CREATE TABLE `category` (
  `root_id` smallint(5) unsigned NOT NULL auto_increment,
  `papa_id` smallint(5) unsigned NOT NULL default '0',
  `cat_name` text NOT NULL,
  `add_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`root_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=136 ;

-- 
-- Dumping data for table `category`
-- 

INSERT INTO `category` VALUES (1, 0, 'Animals and Pets', 1155189475);
INSERT INTO `category` VALUES (2, 0, 'Automobiles', 1155189480);
INSERT INTO `category` VALUES (3, 0, 'Business Opportunities', 1155189485);
INSERT INTO `category` VALUES (4, 0, 'Business Services', 1155189491);
INSERT INTO `category` VALUES (5, 0, 'Computers', 1155189498);
INSERT INTO `category` VALUES (6, 0, 'Electronics and Appliances', 1155189504);
INSERT INTO `category` VALUES (7, 0, 'Employment Opportunities', 1155189510);
INSERT INTO `category` VALUES (8, 0, 'Financial/Money', 1155189515);
INSERT INTO `category` VALUES (9, 0, 'General Merchandise', 1155189522);
INSERT INTO `category` VALUES (10, 0, 'Health and Fitness', 1155189528);
INSERT INTO `category` VALUES (11, 0, 'Internet/Web Services', 1155189537);
INSERT INTO `category` VALUES (12, 0, 'Miscellaneous', 1155189546);
INSERT INTO `category` VALUES (13, 0, 'Personals', 1155189553);
INSERT INTO `category` VALUES (14, 0, 'Real Estate', 1155189559);
INSERT INTO `category` VALUES (15, 1, 'Pets For Sale', 1155189576);
INSERT INTO `category` VALUES (16, 1, 'Fish', 1155189584);
INSERT INTO `category` VALUES (17, 1, 'Breeders', 1155189604);
INSERT INTO `category` VALUES (18, 1, 'Pet Accessories', 1155189615);
INSERT INTO `category` VALUES (19, 1, 'Pet & Animal Foods', 1155189626);
INSERT INTO `category` VALUES (20, 1, 'Other Pets Related', 1155189637);
INSERT INTO `category` VALUES (21, 2, 'Autos For Sale', 1155189650);
INSERT INTO `category` VALUES (22, 2, 'Autos Wanted', 1155189657);
INSERT INTO `category` VALUES (23, 2, 'Auto Repairing', 1155189662);
INSERT INTO `category` VALUES (24, 2, 'Auto Service', 1155189668);
INSERT INTO `category` VALUES (25, 2, 'Auto Parts', 1155189674);
INSERT INTO `category` VALUES (26, 2, 'Auto Accessories', 1155189685);
INSERT INTO `category` VALUES (27, 2, 'Antique', 1155189692);
INSERT INTO `category` VALUES (28, 2, 'Motorcycle', 1155189701);
INSERT INTO `category` VALUES (29, 2, 'Pickups and Vans', 1155189710);
INSERT INTO `category` VALUES (30, 2, 'Sports Cars', 1155189716);
INSERT INTO `category` VALUES (31, 2, 'Trucks', 1155189723);
INSERT INTO `category` VALUES (32, 2, 'Boats', 1155189732);
INSERT INTO `category` VALUES (33, 3, 'Business for Sale', 1155189746);
INSERT INTO `category` VALUES (34, 3, 'Work At Home', 1155189751);
INSERT INTO `category` VALUES (35, 3, 'MLM', 1155189757);
INSERT INTO `category` VALUES (36, 3, 'Money-Making Opportunities', 1155189763);
INSERT INTO `category` VALUES (37, 3, 'Marketing / Sales', 1155189769);
INSERT INTO `category` VALUES (38, 3, 'Distributors Wanted', 1155189776);
INSERT INTO `category` VALUES (39, 3, 'Agents Wanted', 1155189781);
INSERT INTO `category` VALUES (40, 3, 'Business Opportunities', 1155189792);
INSERT INTO `category` VALUES (41, 3, 'Home Business Opportunity', 1155189798);
INSERT INTO `category` VALUES (42, 3, 'Investors Wanted', 1155189807);
INSERT INTO `category` VALUES (43, 3, 'Partnerships & Investments', 1155189813);
INSERT INTO `category` VALUES (44, 4, 'Advertising', 1155189823);
INSERT INTO `category` VALUES (45, 4, 'Promotion', 1155189829);
INSERT INTO `category` VALUES (46, 4, 'Marketing', 1155189834);
INSERT INTO `category` VALUES (47, 4, 'Merchant Services', 1155189840);
INSERT INTO `category` VALUES (48, 4, 'Professional Services', 1155189852);
INSERT INTO `category` VALUES (49, 4, 'Office Equipment', 1155189861);
INSERT INTO `category` VALUES (50, 4, 'Business Equipment', 1155189877);
INSERT INTO `category` VALUES (51, 5, 'Computers For Sale', 1155189900);
INSERT INTO `category` VALUES (52, 5, 'Computers Wanted', 1155189905);
INSERT INTO `category` VALUES (53, 5, 'Computer Software', 1155189911);
INSERT INTO `category` VALUES (54, 5, 'Computer Hardware', 1155189917);
INSERT INTO `category` VALUES (55, 5, 'Computer Accessories', 1155189923);
INSERT INTO `category` VALUES (56, 5, 'Computer Consultants', 1155189929);
INSERT INTO `category` VALUES (57, 6, 'Phones and Accessories', 1155189939);
INSERT INTO `category` VALUES (58, 6, 'Home Appliances', 1155189945);
INSERT INTO `category` VALUES (59, 6, 'Cameras and Camcorders', 1155189951);
INSERT INTO `category` VALUES (60, 6, 'TV and Video', 1155189957);
INSERT INTO `category` VALUES (61, 6, 'PDAs and Handhels', 1155189963);
INSERT INTO `category` VALUES (62, 6, 'Audio', 1155189968);
INSERT INTO `category` VALUES (63, 6, 'Video Games', 1155189974);
INSERT INTO `category` VALUES (64, 6, 'Other Electronics', 1155189980);
INSERT INTO `category` VALUES (65, 7, 'Help Wanted', 1155190001);
INSERT INTO `category` VALUES (66, 7, 'Work from Home', 1155190006);
INSERT INTO `category` VALUES (67, 7, 'Employment Agencies', 1155190011);
INSERT INTO `category` VALUES (68, 7, 'Professionals', 1155190019);
INSERT INTO `category` VALUES (69, 7, 'Job Search', 1155190025);
INSERT INTO `category` VALUES (70, 7, 'Computer Jobs', 1155190036);
INSERT INTO `category` VALUES (71, 7, 'Misc. Employment', 1155190043);
INSERT INTO `category` VALUES (72, 8, 'Credit Cards', 1155190053);
INSERT INTO `category` VALUES (73, 8, 'Credit Services', 1155190059);
INSERT INTO `category` VALUES (74, 8, 'Mortgage Brokers', 1155190064);
INSERT INTO `category` VALUES (75, 8, 'Mortgage Services', 1155190071);
INSERT INTO `category` VALUES (76, 8, 'Money to Lend', 1155190076);
INSERT INTO `category` VALUES (77, 8, 'Venture Capital', 1155190081);
INSERT INTO `category` VALUES (78, 9, 'WholeSale', 1155190093);
INSERT INTO `category` VALUES (79, 9, 'Jewelry', 1155190098);
INSERT INTO `category` VALUES (80, 9, 'Flowers and Gifts', 1155190103);
INSERT INTO `category` VALUES (81, 9, 'Watches', 1155190109);
INSERT INTO `category` VALUES (82, 9, 'Paintings', 1155190114);
INSERT INTO `category` VALUES (83, 9, 'Furniture', 1155190123);
INSERT INTO `category` VALUES (84, 9, 'Craft Items', 1155190133);
INSERT INTO `category` VALUES (85, 9, 'Art and Antiques', 1155190138);
INSERT INTO `category` VALUES (86, 9, 'Books', 1155190144);
INSERT INTO `category` VALUES (87, 9, 'Clothing', 1155190153);
INSERT INTO `category` VALUES (88, 9, 'Toys and Games', 1155190161);
INSERT INTO `category` VALUES (89, 10, 'Beauty Products', 1155190172);
INSERT INTO `category` VALUES (90, 10, 'Weight Loss/Diet', 1155190178);
INSERT INTO `category` VALUES (91, 10, 'Health & Wellness', 1155190183);
INSERT INTO `category` VALUES (92, 10, 'Hair Loss', 1155190190);
INSERT INTO `category` VALUES (93, 10, 'Age Related', 1155190195);
INSERT INTO `category` VALUES (94, 10, 'Dental Care', 1155190202);
INSERT INTO `category` VALUES (95, 10, 'Exercise Equipment', 1155190208);
INSERT INTO `category` VALUES (96, 10, 'Fitness', 1155190213);
INSERT INTO `category` VALUES (97, 10, 'Health Services', 1155190218);
INSERT INTO `category` VALUES (98, 10, 'Sexual Health', 1155190223);
INSERT INTO `category` VALUES (99, 10, 'Skin Care', 1155190229);
INSERT INTO `category` VALUES (100, 11, 'Web Design', 1155190244);
INSERT INTO `category` VALUES (101, 11, 'Web Promotion', 1155190249);
INSERT INTO `category` VALUES (102, 11, 'Web Hosting', 1155190258);
INSERT INTO `category` VALUES (103, 11, 'Internet/Web Services', 1155190264);
INSERT INTO `category` VALUES (104, 11, 'Consulting', 1155190270);
INSERT INTO `category` VALUES (105, 11, 'ISP', 1155190277);
INSERT INTO `category` VALUES (106, 11, 'Training', 1155190283);
INSERT INTO `category` VALUES (107, 11, 'Affiliate Programs', 1155190289);
INSERT INTO `category` VALUES (108, 11, 'Free Traffic Programs', 1155190295);
INSERT INTO `category` VALUES (109, 11, 'Misc. Internet Resources', 1155190302);
INSERT INTO `category` VALUES (110, 12, 'Auctions', 1155190313);
INSERT INTO `category` VALUES (111, 12, 'Wanted To Buy', 1155190319);
INSERT INTO `category` VALUES (112, 12, 'Free Stuff', 1155190324);
INSERT INTO `category` VALUES (113, 12, 'Miscellaneous For Sale', 1155190330);
INSERT INTO `category` VALUES (114, 12, 'Travel', 1155190335);
INSERT INTO `category` VALUES (115, 12, 'Manufacturers', 1155190342);
INSERT INTO `category` VALUES (116, 12, 'Restaurants', 1155190353);
INSERT INTO `category` VALUES (117, 12, 'Gambling', 1155190366);
INSERT INTO `category` VALUES (118, 12, 'Sports', 1155190373);
INSERT INTO `category` VALUES (119, 12, 'Education', 1155190379);
INSERT INTO `category` VALUES (120, 13, 'Personal Ads', 1155190390);
INSERT INTO `category` VALUES (121, 13, 'Dating Services', 1155190395);
INSERT INTO `category` VALUES (122, 13, 'Personal Products', 1155190401);
INSERT INTO `category` VALUES (123, 13, 'Personal Services', 1155190407);
INSERT INTO `category` VALUES (124, 13, 'Chat', 1155190415);
INSERT INTO `category` VALUES (125, 13, 'Misc Personal Services', 1155190427);
INSERT INTO `category` VALUES (126, 14, 'Apartments', 1155190439);
INSERT INTO `category` VALUES (127, 14, 'Houses', 1155190444);
INSERT INTO `category` VALUES (128, 14, 'Rooms', 1155190449);
INSERT INTO `category` VALUES (129, 14, 'Agents', 1155190454);
INSERT INTO `category` VALUES (130, 14, 'Services', 1155190459);
INSERT INTO `category` VALUES (131, 14, 'Land For Sale', 1155190465);
INSERT INTO `category` VALUES (132, 14, 'Business&Commercial Sites', 1155190472);
INSERT INTO `category` VALUES (133, 14, 'Real Estate For Sale', 1155190479);
INSERT INTO `category` VALUES (134, 14, 'Farms', 1155190488);
INSERT INTO `category` VALUES (135, 14, 'For Rent', 1155190496);

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

-- 
-- Table structure for table `deposit`
-- 

CREATE TABLE `deposit` (
  `id` int(20) NOT NULL auto_increment,
  `userid` bigint(30) NOT NULL default '0',
  `dep_id` varchar(30) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `date` bigint(32) NOT NULL default '0',
  `year` varchar(4) NOT NULL default '',
  `month` char(3) NOT NULL default '',
  `day` char(2) NOT NULL default '',
  `egold` varchar(15) NOT NULL default '',
  `batch` varchar(20) NOT NULL default '',
  `type` varchar(10) NOT NULL default '',
  `units` int(4) NOT NULL default '0',
  `amount` double NOT NULL default '0',
  `merchant_id` varchar(50) NOT NULL default '',
  `memo` varchar(100) NOT NULL default '',
  `active` enum('0','1','2') NOT NULL default '0',
  `expired` enum('0','1') NOT NULL default '0',
  `paid_times` int(10) NOT NULL default '0',
  `pay_length` tinyint(10) NOT NULL default '1',
  `pay_times` mediumint(10) NOT NULL default '0',
  `pay_rate` varchar(10) NOT NULL default '3',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `deposit`
-- 

INSERT INTO `deposit` VALUES (1, 4, '1199632968.14', '127.0.0.1', 1199632968, '2008', 'Jan', '06', '3612548', '', 'EGOLD', 1, 100, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (2, 4, '1199633024.1', '127.0.0.1', 1199633024, '2008', 'Jan', '06', '3612548', '', 'EGOLD', 1, 100, '', '', '0', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (3, 4, '1199633036.6', '127.0.0.1', 1199633036, '2008', 'Jan', '06', '3612548', '', 'EGOLD', 1, 100, '', '', '0', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (4, 4, '1199633063.12', '127.0.0.1', 1199633063, '2008', 'Jan', '06', '3612548', '', 'EGOLD', 1, 100, '', '', '0', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (5, 4, '1207506926.57', '127.0.0.1', 1207506926, '2008', 'Apr', '07', 'n/a', '', 'EPOINT', 1, 100, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (6, 4, '1207506978.76', '127.0.0.1', 1207506978, '2008', 'Apr', '07', 'n/a', '', 'EPOINT', 1, 100, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (7, 4, '1207506987.51', '127.0.0.1', 1207506987, '2008', 'Apr', '07', 'n/a', '', 'EPOINT', 1, 100, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (8, 4, '1207507001.16', '127.0.0.1', 1207507001, '2008', 'Apr', '07', 'n/a', '', 'EPOINT', 1, 100, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (9, 4, '1207507068.17', '127.0.0.1', 1207507068, '2008', 'Apr', '07', 'n/a', '', 'EPOINT', 1, 100, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (10, 4, '1207654774.53', '127.0.0.1', 1207654774, '2008', 'Apr', '08', 'n/a', '', 'EPOINT', 2, 200, '', '', '1', '0', 0, 1, 10, '10');
INSERT INTO `deposit` VALUES (11, 4, '1207662301.6', '127.0.0.1', 1207662301, '2008', 'Apr', '08', '3612548', '', 'EGOLD', 1, 100, '', '', '0', '0', 0, 1, 10, '2');
INSERT INTO `deposit` VALUES (12, 5, '1207664536.96', '127.0.0.1', 1207664536, '2008', 'Apr', '08', '5384758', '', 'EGOLD', 1, 100, '', '', '0', '0', 0, 1, 10, '2');

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

-- 
-- Table structure for table `earning_history`
-- 

CREATE TABLE `earning_history` (
  `id` int(12) NOT NULL auto_increment,
  `userid` int(12) default NULL,
  `amount` double NOT NULL default '0',
  `pay_date` bigint(32) NOT NULL default '0',
  `payer_id` varchar(100) NOT NULL default '0',
  `admin` int(1) NOT NULL default '1',
  `comtype` varchar(6) NOT NULL default 'MLM',
  `memo` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- 
-- Dumping data for table `earning_history`
-- 

INSERT INTO `earning_history` VALUES (1, 4, 100, 1199633980, 'Admin', 1, 'ITR', 'Epoint');
INSERT INTO `earning_history` VALUES (2, 4, 5000, 1207506914, 'Admin', 1, 'ITR', 'Epoint');
INSERT INTO `earning_history` VALUES (4, 0, 0.5, 1207664339, '6', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (5, 4, 0.5, 1207664380, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (6, 4, 0.5, 1207664381, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (7, 4, 0.5, 1207664381, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (8, 4, 0.5, 1207664382, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (9, 4, 0.5, 1207664382, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (10, 4, 0.5, 1207664382, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (11, 4, 0.5, 1207664382, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (12, 4, 0.5, 1207664382, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (13, 4, 0.5, 1207664383, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (14, 4, 0.5, 1207664383, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (15, 4, 0.5, 1207664384, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (16, 4, 0.5, 1207664420, '5', 1, 'REF', 'Ref bonus');
INSERT INTO `earning_history` VALUES (17, 4, 0.5, 1212070177, '5', 1, 'REF', 'Ref bonus');

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

-- 
-- Table structure for table `errors`
-- 

CREATE TABLE `errors` (
  `id` int(10) NOT NULL auto_increment,
  `userid` bigint(32) default NULL,
  `error` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `errors`
-- 


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

-- 
-- Table structure for table `faq`
-- 

CREATE TABLE `faq` (
  `id` int(11) NOT NULL auto_increment,
  `parent` int(11) default NULL,
  `caption` tinytext,
  `message` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `faq`
-- 

INSERT INTO `faq` VALUES (1, NULL, 'Account information', NULL);
INSERT INTO `faq` VALUES (2, 1, 'Can I register 2 or more accounts?', 'Yes, you can have as many accounts as you like, you can even use the same egold and email address to all of your accounts.');
INSERT INTO `faq` VALUES (3, NULL, 'Bonuses and Commissions', NULL);
INSERT INTO `faq` VALUES (4, 3, 'How does payment for referrals work?', 'You receive referral commissions 18 levels deep, which means that by referring only a few people and then through your direct and indirect referrals again acquiring referrals, you can end up with a thousand or more in your downline.');
INSERT INTO `faq` VALUES (5, 3, 'How do I get paid?', 'All your bonuses and commissions will be sent to your e-gold account automatically and instantly by our automated system once you have a commissions or bonuses.');
INSERT INTO `faq` VALUES (6, NULL, 'About the Company', NULL);
INSERT INTO `faq` VALUES (7, 6, 'Is this legal?', 'Yes, CompanyName.com is 100% legal. In return for your investment, you are given access to the list of e-books indside our membership section. Any program that provides a product of any kind is legal.');

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

-- 
-- Table structure for table `files`
-- 

CREATE TABLE `files` (
  `id` int(32) NOT NULL auto_increment,
  `fname` varchar(100) NOT NULL default '',
  `fsize` varchar(100) NOT NULL default '0',
  `fdesc` varchar(200) NOT NULL default '',
  `ftitle` varchar(200) NOT NULL default '',
  `fmod` bigint(30) NOT NULL default '0',
  `dl_hit` int(32) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `fname` (`fname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `files`
-- 


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

-- 
-- Table structure for table `letters`
-- 

CREATE TABLE `letters` (
  `user_title` text NOT NULL,
  `dsponsor_title` text NOT NULL,
  `admin_title` text NOT NULL,
  `del_title` text NOT NULL,
  `active_title` text NOT NULL,
  `pass_msg` text NOT NULL,
  `pass_title` varchar(255) NOT NULL default '',
  `newuser_msg` text NOT NULL,
  `dsponsor_msg` text NOT NULL,
  `admin_msg` text NOT NULL,
  `del_msg` text NOT NULL,
  `active_msg` text NOT NULL,
  `lang` varchar(25) NOT NULL default 'en',
  `sponsor_active_msg` text NOT NULL,
  `sponsor_active_title` text NOT NULL,
  `exp_title` text NOT NULL,
  `exp_msg` text NOT NULL,
  `withdraw_title` text NOT NULL,
  `withdraw_msg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `letters`
-- 

INSERT INTO `letters` VALUES ('Selamat bergabung di\n            CompanyName.com!', 'Prospek baru di CompanyName.com!', '[{member_userid}] New\n            Member!', 'Membership anda dihapus!', 'Aktivasi membership anda!', 'Halo\n            {member_name}...\r\n\r\nInformasi login anda\n            adalah:\r\n-------------------------\r\nLoginId : {member_loginid}\r\nPassword:\n            {member_password}\r\nNama: {member_name}\r\nEmail:\n            {member_email}\r\n\r\n\r\nSukses selalu untuk\n            anda!\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'Data login anda!', 'Halo {member_name},\r\nTerima kasih telah melakukan registrasi.\r\n\r\nBerikut\n            ini data registrasi anda :\r\n--------------------------------\r\nLoginId :\n            {member_loginid}\r\nPassword : {member_password}\r\n\r\nNama:\n            {member_name}\r\nEmail: {member_email}\r\n\r\n            Telepon:\n            {member_phone}\r\nE-Gold: {member_egold}\r\nYahooId: {member_yahoo}\r\nKota:\n            {member_city}\r\nNegara: {member_country}\r\nAsal: {know_from}\r\nReferral Url :\n            http://CompanyName.com/?ref={member_userid}\r\n\r\n\r\nInformasi sponsor anda\n            :\r\n--------------------------------\r\n\r\n            Nama:\n            {sponsor_name}\r\nEmail: {sponsor_email}\r\nTelepon: {sponsor_phone}\r\nYahoo:\n            {sponsor_yahoo}\r\nKota: {sponsor_city}\r\nNegara:\n            {sponsor_country}\r\n\r\n\r\n\r\nSukses selalu untuk\n            anda!\r\n\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'Halo\n            {sponsor_name} ,\r\nSelamat! Anda mendapatkan prospek!\r\n\r\nBerikut ini\n            informasinya :\r\n------------------------\r\nNama: {member_name}\r\nEmail:\n            {member_email}\r\nTelepon: {member_phone}\r\nYahooId: {member_yahoo}\r\nKota:\n            {member_city}\r\nNegara: {member_country}\r\nAsal: {know_from}\r\n\r\n\r\nSukses\n            selalu untuk anda!\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'New\n            Member in your website!\r\n\r\nRegistrant information\n            :\r\n-----------------------------\r\nUserId: {member_userid}\r\nLoginId :\n            {member_loginid}\r\nPassword: {member_password}\r\nName: {member_name}\r\nEmail:\n            {member_email}\r\nPhone No: {member_phone}\r\nE-Gold: {member_egold}\r\nYahooId:\n            {member_yahoo}\r\nCity: {member_city}\r\nCountry: {member_country}\r\n\r\n\n            Referrer: {know_from}\r\n\r\n \r\nSponsor\n            Data:\r\n-----------------------------\r\nName: {sponsor_name}\r\nEmail:\n            {sponsor_email}\r\nPhone No: {sponsor_phone}\r\nYahoo: {sponsor_yahoo}\r\nCity:\n            {sponsor_city}\r\nCountry: {sponsor_country}', 'Halo\n            {member_name}...\r\n\r\nMembership anda di dihapus karena beberapa alasan\n            berikut ini :\r\n\r\n1. Kemungkinan anda melakukan SPAM.\r\n   SPAM adalah\n            kegiatan terlarang di Internet.\r\n   \r\n2. Kemungkinan karena anda tidak\n            mengisikan data-data\r\n   yang benar.\r\n   \r\n3. Kemungkinan anda melakukan\n            Hal-hal yang merugikan\r\n   Perusahaan atau sesama member.\r\n   \r\n4.\n            Melewati batas waktu Upgrade dari waktu yang ditentukan.\r\n\r\n\r\nSukses\n            selalu untuk anda!\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'Halo\n            {member_name}...\r\n\r\nSelamat! Membership anda di CompanyName.com \r\nsudah\n            diaktifkan.\r\n\r\nInformasi membership anda\n            :\r\n------------------------\r\nLoginId : {member_loginid}\r\nPassword :\n            {member_password}\r\nNama: {member_name}\r\nEmail: {member_email}\r\nStatus :\n            Active Member\r\n\r\nTanggal aktif: {member_activedate} (waktu\n            server)\r\nTanggal akhir: {member_expdate} (waktu server)\r\n\r\nReferral URL :\n            http://CompanyName.com/?ref={member_userid}\r\n\r\n\r\nSukses selalu untuk\n            anda!\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'id', 'Halo\n            {sponsor_name} ...\r\n\r\nSelamat! Downline anda sudah\n            diaktifkan!\r\n\r\nBerikut ini\n            informasinya:\r\n------------------------\r\nNama: {member_name}\r\nEmail:\n            {member_email}\r\nStatus : Active Member\r\n\r\nTanggal aktif:\n            {member_activedate} (waktu server)\r\nTanggal akhir: {member_expdate} (waktu\n            server)\r\n\r\n\r\nSukses selalu untuk\n            anda!\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'Downline anda:\n            {member_name} telah diaktifkan!', 'Masa aktif membership telah berakhir!', 'Halo\n            {member_name}...\r\n\r\nMasa aktif membership anda telah\n            berakhir.\r\n\r\nBerikut ini informasinya\n            :\r\n------------------------\r\nLoginId : {member_loginid}\r\nPassword :\n            {member_password}\r\nNama: {member_name}\r\nEmail: {member_email}\r\n\r\nTanggal\n            aktif: {member_activedate} (waktu server)\r\nTanggal akhir: {member_expdate}\n            (waktu server)\r\n\r\nUntuk memperbaharui account anda, silahkan login\n            ke\r\nmember area.\r\n\r\n\r\n\r\nTerima kasih, sukses\n            selalu!\r\n\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com', 'Withdrawal\n            sukses ()', 'Halo {member_name},\r\n\r\nPermintaan withdrawal anda sudah\n            diproses.\r\nTanggal : {withdraw_date\r\nEgold : {withdraw_egold}\r\nJumlah :\n            \r\nBatch : {withdraw_batch}\r\n\r\nSilahkan cek egold anda.\r\n\r\n\r\nTerima\n            kasih, sukses\n            selalu!\r\n\r\n\r\nCompanyName.com\r\nhttp://www.CompanyName.com');
INSERT INTO `letters` VALUES ('Welcome to            gandauang.com !', 'New prospect in gandauang.com !', '[{member_userid}] New            Member!', 'Deletion of your membership!', 'Your Membership has been activated            !', 'Hello {member_name}...\r\n\r\nHere are your membership data\r\n            :\r\n-------------------------\r\nLoginId : {member_loginid}\r\nPassword:\r\n            {member_password}\r\nName: {member_name}\r\nEmail:\r\n            {member_email}\r\n\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'Your login            information !', 'Dear {member_name},\r\n\r\nThank you for your\r\n            registration!\r\n\r\nHere are your registration data\r\n            :\r\n--------------------------------\r\nLoginId : {member_loginid}\r\nPassword\r\n            : {member_password}\r\n\r\nName: {member_name}\r\nEmail: {member_email}\r\nPhone\r\n            No: {member_phone}\r\nE-Gold: {member_egold}\r\nYahooId: {member_yahoo}\r\nCity:\r\n            {member_city}\r\nCountry: {member_country}\r\nReferrer: {know_from}\r\nReferral\r\n            Url : http://gandauang.com/?ref={member_userid}\r\n\r\n\r\nYour sponsor''s\r\n            data :\r\n--------------------------------\r\nName: {sponsor_name}\r\nEmail:\r\n            {sponsor_email}\r\nPhone No: {sponsor_phone}\r\nYahoo: {sponsor_yahoo}\r\nCity:\r\n            {sponsor_city}\r\nCountry: {sponsor_country}\r\n\r\n\r\n\r\nSuccessful Always\r\n            for You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'Hello\r\n            {sponsor_name} ,\r\nCongratulation! You got a new prospect!\r\n\r\nYour\r\n            prospect''s data :\r\n------------------------\r\nName: {member_name}\r\nEmail:\r\n            {member_email}\r\nPhone No: {member_phone}\r\nYahooId: {member_yahoo}\r\nCity:\r\n            {member_city}\r\nCountry: {member_country}\r\nReferrer:\r\n            {know_from}\r\n\r\n\r\n\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'New Member in\r\n            your website!\r\n\r\nRegistrant information\r\n            :\r\n-----------------------------\r\nUserId: {member_userid}\r\nLoginId :\r\n            {member_loginid}\r\n\r\n            Password: {member_password}\r\nName:\r\n            {member_name}\r\nEmail: {member_email}\r\nPhone No: {member_phone}\r\nE-Gold:\r\n            {member_egold}\r\nYahooId: {member_yahoo}\r\nCity: {member_city}\r\nCountry:\r\n            {member_country}\r\nReferrer: {know_from}\r\n\r\n \r\nSponsor\r\n            Data:\r\n-----------------------------\r\nName: {sponsor_name}\r\nEmail:\r\n            {sponsor_email}\r\nPhone No: {sponsor_phone}\r\nYahoo: {sponsor_yahoo}\r\nCity:\r\n            {sponsor_city}\r\nCountry: {sponsor_country}', 'Hello\r\n            {member_name}...\r\n\r\nYour Membership vanished by some reasons following\r\n            :\r\n\r\n1.  Possibility of you do SPAM. SPAM is forbidden activity\r\n2.\r\n            Possibility because you don''t fill in correct data\r\n3.  Pass deadline Upgrade\r\n            from the determined time.\r\n\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'Hello\r\n            {member_name}...\r\n\r\nCongratulation!\r\nYour Membership in gandauang.com\r\n            has been activated !\r\n\r\nYour membership data\r\n            :\r\n------------------------\r\nName: {member_name}\r\nEmail:\r\n            {member_email}\r\nStatus : Active Member\r\n\r\nDate Of Active:\r\n            {member_activedate} (server time)\r\nDate Of Expired: {member_expdate} (server\r\n            time)\r\n\r\nReferral URL : http://gandauang.com/?ref={member_userid}\r\nGood\r\n            luck {member_name}!!!\r\n\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'en', 'Hello\r\n            ...\r\n\r\nCongratulation!\r\nYour downline has been activated !\r\n\r\nThe data\r\n            is as follow:\r\n------------------------\r\nName: {member_name}\r\nEmail:\r\n            {member_email}\r\nStatus : Active Member\r\n\r\nDate Of Active:\r\n            {member_activedate} (server time)\r\nDate Of Expired: {member_expdate} (server\r\n            time)\r\n\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'Your downline            has been activated !', 'Your membership has expired!', 'Hello\r\n            {member_name}...\r\n\r\nYour Membership in gandauang.com has\r\n            expired!\r\n\r\nYour membership data :\r\n------------------------\r\nLoginId :\r\n            {member_loginid}\r\nPassword : {member_password}\r\nName:\r\n            {member_name}\r\nEmail: {member_email}\r\n\r\nDate Of Active:\r\n            {member_activedate} (server time)\r\nDate Of Expired: {member_expdate} (server\r\n            time)\r\n\r\nTo Renew your account, please login to members\r\n            area.\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com', 'Successful            withdrawal request ($ {withdraw_amount})', 'Hello {member_name},\r\n\r\nYour\r\n            withdraw request has been processed.\r\nDate : {withdraw_date}\r\nEgold :\r\n            {withdraw_egold}\r\nAmount : $ {withdraw_amount}\r\nBatch :\r\n            {withdraw_batch}\r\n\r\n\r\nPlease check your egold\r\n            account.\r\n\r\n\r\nSuccessful Always for\r\n            You!\r\n\r\n\r\ngandauang.com\r\nhttp://www.gandauang.com');

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

-- 
-- Table structure for table `levels_commisions`
-- 

CREATE TABLE `levels_commisions` (
  `id` int(11) NOT NULL auto_increment,
  `level_num` bigint(30) NOT NULL default '0',
  `commission` double NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

-- 
-- Dumping data for table `levels_commisions`
-- 

INSERT INTO `levels_commisions` VALUES (1, 1, 0.1);
INSERT INTO `levels_commisions` VALUES (2, 2, 0.2);
INSERT INTO `levels_commisions` VALUES (3, 3, 0.3);
INSERT INTO `levels_commisions` VALUES (4, 4, 0.4);
INSERT INTO `levels_commisions` VALUES (5, 5, 0.5);
INSERT INTO `levels_commisions` VALUES (6, 6, 0.6);
INSERT INTO `levels_commisions` VALUES (7, 7, 0.7);
INSERT INTO `levels_commisions` VALUES (8, 8, 0.8);
INSERT INTO `levels_commisions` VALUES (9, 9, 0.9);
INSERT INTO `levels_commisions` VALUES (10, 10, 1);
INSERT INTO `levels_commisions` VALUES (11, 11, 1.1);
INSERT INTO `levels_commisions` VALUES (12, 12, 1.2);
INSERT INTO `levels_commisions` VALUES (13, 13, 1.3);
INSERT INTO `levels_commisions` VALUES (14, 14, 1.4);
INSERT INTO `levels_commisions` VALUES (15, 15, 1.5);
INSERT INTO `levels_commisions` VALUES (16, 16, 1.6);
INSERT INTO `levels_commisions` VALUES (17, 17, 1.7);
INSERT INTO `levels_commisions` VALUES (18, 18, 1.8);

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

-- 
-- Table structure for table `login_session`
-- 

CREATE TABLE `login_session` (
  `userid` varchar(32) default NULL,
  `string` varchar(32) default NULL,
  `lastlogin` bigint(32) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `login_session`
-- 


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

-- 
-- Table structure for table `matrix`
-- 

CREATE TABLE `matrix` (
  `id` int(100) NOT NULL auto_increment,
  `userid` int(30) NOT NULL default '0',
  `parent` int(30) NOT NULL default '0',
  `userlevel` enum('0','1','2') NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `messages`
-- 

CREATE TABLE `messages` (
  `MsgID` bigint(32) NOT NULL auto_increment,
  `Subject` varchar(255) NOT NULL default '',
  `SecMinHoursDays` bigint(32) NOT NULL default '0',
  `Months` int(11) NOT NULL default '0',
  `BodyText` text NOT NULL,
  `BodyHTML` text NOT NULL,
  `lang` enum('id','my','en') NOT NULL default 'id',
  PRIMARY KEY  (`MsgID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `messages`
-- 


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

-- 
-- Table structure for table `news`
-- 

CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `subject` text NOT NULL,
  `body` text NOT NULL,
  `date` bigint(20) NOT NULL default '0',
  `enabled` enum('0','1') NOT NULL default '0',
  `showto` enum('0','1','2') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `news`
-- 

INSERT INTO `news` VALUES (1, 'Test News', 'Test News', 1213885432, '1', '2');

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

-- 
-- Table structure for table `payments`
-- 

CREATE TABLE `payments` (
  `id` int(12) NOT NULL auto_increment,
  `userid` int(12) default NULL,
  `amount` double NOT NULL default '0',
  `pay_date` bigint(32) NOT NULL default '0',
  `retry` int(1) NOT NULL default '0',
  `egold` varchar(12) NOT NULL default '0',
  `ip_request` varchar(100) NOT NULL default '',
  `withdrawto` varchar(10) NOT NULL default 'egold',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `payments`
-- 

INSERT INTO `payments` VALUES (2, 4, 5, 1199631789, 1, '3612548', '127.0.0.1', 'egold');
INSERT INTO `payments` VALUES (3, 5, 20, 1199631700, 1, '34184189', '', 'egold');

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

-- 
-- Table structure for table `payments_history`
-- 

CREATE TABLE `payments_history` (
  `id` int(12) NOT NULL auto_increment,
  `userid` int(12) default NULL,
  `egold` varchar(100) default NULL,
  `amount` double NOT NULL default '0',
  `batch` varchar(100) NOT NULL default '0',
  `pay_date` bigint(32) NOT NULL default '0',
  `payment_id` varchar(100) NOT NULL default '0',
  `ip_request` varchar(100) NOT NULL default '',
  `isfee` enum('0','1') NOT NULL default '0',
  `withdrawto` varchar(10) NOT NULL default 'egold',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `payments_history`
-- 

INSERT INTO `payments_history` VALUES (1, 4, '3625487', 20, '99954215', 1199631789, '0', '127.0.0.1', '0', 'egold');
INSERT INTO `payments_history` VALUES (2, 5, '4587655', 20, '0', 1199631789, '0', '', '0', 'egold');

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

-- 
-- Table structure for table `setting_investment`
-- 

CREATE TABLE `setting_investment` (
  `unit_curr` varchar(100) NOT NULL default '0',
  `unit_cost` varchar(100) NOT NULL default '',
  `pay_rate` varchar(100) NOT NULL default '',
  `pay_length` varchar(100) NOT NULL default '',
  `pay_times` varchar(100) NOT NULL default '',
  `referral_rate` varchar(100) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `setting_investment`
-- 

INSERT INTO `setting_investment` VALUES ('0', '100', '2', '1', '10', '5');

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

-- 
-- Table structure for table `stats`
-- 

CREATE TABLE `stats` (
  `userid` varchar(32) default NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(32) default NULL,
  `url` varchar(200) NOT NULL default '',
  `ref` varchar(200) default NULL,
  `lang` varchar(15) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `stats`
-- 

INSERT INTO `stats` VALUES ('4', '2008-07-03 03:13:25', '127.0.0.1', '/demo_nxnhyip_encrypted/', 'http://localhost/', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:10', '127.0.0.1', '/demo_nxnhyip_encrypted/join.php', 'http://localhost/demo_nxnhyip_encrypted/Flash/header.swf', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:12', '127.0.0.1', '/demo_nxnhyip_encrypted/index.php', 'http://localhost/demo_nxnhyip_encrypted/Flash/header.swf', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:14', '127.0.0.1', '/demo_nxnhyip_encrypted/about_us.php', 'http://localhost/demo_nxnhyip_encrypted/Flash/header.swf', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:15', '127.0.0.1', '/demo_nxnhyip_encrypted/system.php', 'http://localhost/demo_nxnhyip_encrypted/Flash/header.swf', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:17', '127.0.0.1', '/demo_nxnhyip_encrypted/contact.php', 'http://localhost/demo_nxnhyip_encrypted/Flash/header.swf', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:20', '127.0.0.1', '/demo_nxnhyip_encrypted/system.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/contact.php', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:22', '127.0.0.1', '/demo_nxnhyip_encrypted/testimonies.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/system.php?ref=4', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:24', '127.0.0.1', '/demo_nxnhyip_encrypted/join.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/testimonies.php?ref=4', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:27', '127.0.0.1', '/demo_nxnhyip_encrypted/join.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/join.php?ref=4', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:29', '127.0.0.1', '/demo_nxnhyip_encrypted/join.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/testimonies.php?ref=4', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:14:33', '127.0.0.1', '/demo_nxnhyip_encrypted/index.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/join.php?ref=4', 'en');
INSERT INTO `stats` VALUES ('4', '2008-07-03 03:15:15', '127.0.0.1', '/demo_nxnhyip_encrypted/index.php?ref=4', 'http://localhost/demo_nxnhyip_encrypted/join.php?ref=4', 'en');

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

-- 
-- Table structure for table `testimonials`
-- 

CREATE TABLE `testimonials` (
  `id` bigint(32) NOT NULL auto_increment,
  `userid` varchar(32) NOT NULL default '',
  `name` varchar(32) NOT NULL default '',
  `city` varchar(255) default NULL,
  `email` varchar(32) NOT NULL default '',
  `subject` text NOT NULL,
  `content` text NOT NULL,
  `active` enum('0','1') NOT NULL default '0',
  `date` bigint(32) NOT NULL default '0',
  `lang` varchar(12) NOT NULL default 'id',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `testimonials`
-- 

INSERT INTO `testimonials` VALUES (1, '1', 'Admin', 'Pekanbaru', 'admin@company.com', 'Join Us to earn $891,289,8 every year!', 'You have just made an important decision that is to start your financial journey in the internet with CompanyName.com, since it is just $17.5 to join and you can earn $891,289,8 every year within 2 friends you invite to CompanyName.com.\r\n\r\n\r\n\r\nAdmin\r\nEmail : admin@company.com\r\nPhone : 1234567', '1', 1170728879, 'id');

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

-- 
-- Table structure for table `top_of_month`
-- 

CREATE TABLE `top_of_month` (
  `id` bigint(32) NOT NULL auto_increment,
  `userid` bigint(32) NOT NULL default '0',
  `dline` bigint(32) NOT NULL default '0',
  `startdate` bigint(32) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `top_of_month`
-- 


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

-- 
-- Table structure for table `users_online`
-- 

CREATE TABLE `users_online` (
  `ip` varchar(15) NOT NULL default '',
  `time` int(11) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `users_online`
-- 

INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035005);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035050);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035052);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035054);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035055);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035057);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035060);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035062);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035064);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035066);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035068);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035073);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035115);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035125);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035141);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035141);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035147);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035150);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035240);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035240);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035279);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035280);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035293);
INSERT INTO `users_online` VALUES ('127.0.0.1', 1215035293);
