Код:
--
-- Database: `tft_hyip`
--
-- Uncomment out the four following lines if you were given enough privileges to create new user and database on the MySQL server.
-- This will prevent importing errors related to insufficient permissions.
--
-- DROP DATABASE IF EXISTS `tft_hyip`;
-- CREATE DATABASE `tft_hyip`;
-- GRANT USAGE ON *.* TO 'tft_hyip'@'localhost' IDENTIFIED BY 'tft_hyip' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;
-- GRANT SELECT, INSERT, DELETE, UPDATE ON `tft_hyip`.* TO 'tft_hyip'@localhost;
--
USE tft_hyip;
SET PASSWORD FOR 'tft_hyip'@'localhost' = OLD_PASSWORD('tft_hyip');
--
--
-- Table structure for table `hm2_deposits`
--
CREATE TABLE `hm2_deposits` (
`id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`type_id` bigint(20) NOT NULL default '0',
`deposit_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_pay_date` datetime NOT NULL default '0000-00-00 00:00:00',
`status` enum('on','off') default 'on',
`q_pays` bigint(20) NOT NULL default '0',
`amount` double(10,5) NOT NULL default '0.00000',
`actual_amount` double(10,5) NOT NULL default '0.00000',
`ec` int(11) NOT NULL default '0',
`compound` float(10,5) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_emails`
--
CREATE TABLE `hm2_emails` (
`id` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`subject` varchar(255) NOT NULL default '',
`text` text,
`status` tinyint(1) unsigned NOT NULL default '1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
INSERT INTO `hm2_emails` (`id`, `name`, `subject`, `text`, `status`) VALUES
('registration', 'Registration Completetion', 'Your registration Info', 'Hello #name#,\r\n\r\nThank you for registering with us.\r\n\r\nYour login information are as follow:\r\n\r\nLogin: #username#\r\nPassword: #password#\r\n\r\nYour referral link is:\r\n\r\n#site_url#/?ref=#username#\r\n\r\n\You can login and invest right now from here: #site_url#\r\n\r\nContact us immediately if you did not authorize this registration.\r\n\r\nThank you for being a part of us.\r\n#site_name#\r\n', 1),
('confirm_registration', 'Registration Confirmation', 'Confirm your registration', 'Hello #name#,\r\n\r\nThank you for registering in our program\r\nPlease confirm your registration or ignore this message.\r\n\r\nCopy and paste this link to your browser:\r\n#site_url#/?a=confirm_registration&c=#confirm_string#\r\n\r\nThank you.\r\n#site_name#\r\n', 1),
('forgot_password', 'Password Reminder', 'Requested password', 'Hello #name#,\r\n\r\nSomeone (most likely you) requested your username and password from the IP #ip#.\r\nYour password has been changed!!!\r\n\r\nYou can log into your account with:\r\n\r\nUsername: #username#\r\nPassword: #password#\r\n\r\nHope that helps.\r\n', 1),
('bonus', 'Bonus Notification', 'Bonus Notification', 'Hello #name#,\r\n\r\nYou have just received a bonus with the amount of: $#amount#\r\nYou can check your statistics here:\r\n#site_url#\r\n\r\nGood luck and happy investing.\r\n', 1),
('penalty', 'Penalty Notification', 'Penalty Notification', 'Hello #name#,\r\n\r\nYour account has been charged for $#amount#\r\nYou can check your statistics here:\r\n#site_url#\r\n\r\nGood luck.\r\n', 1),
('change_account', 'Account Change Notification', 'Account Change Notification', 'Hello #name#,\r\n\r\nYour account data has been changed from ip #ip#\r\n\r\nNew information:\r\n\r\nPassword: #password#\r\nE-gold account: #egold#\r\nE-mail address: #email#\r\n\r\nContact us immediately if you did not authorize this change.\r\n\r\nThank you.\r\n', 1),
('withdraw_request_user_notification', 'User Withdrawal Request Notification', 'Withdrawal Request has been sent', 'Hello #name#,\r\n\r\nYou have requested a withdrawal for the amount of: $#amount#.\r\nRequested IP address is: #ip#.\r\n\r\nThank you.\r\n#site_name#\r\n#site_url#\r\n', 1),
('withdraw_request_admin_notification', 'Administrator Withdrawal Request Notification', 'Withdrawal Request has been sent', 'User #username# requested to withdraw $#amount# from IP #ip#.\r\n', 1),
('withdraw_user_notification', 'User Withdrawal Notification', 'Withdrawal has been sent', 'Hello #name#.\r\n\r\nThe amount of: $#amount# has been successfully sent to your #currency# account #account#.\r\n\r\nTransaction batch is: #batch#.\r\n\r\n#site_name#\r\n#site_url#\r\n', 1),
('withdraw_admin_notification', 'Administrator Withdrawal Notification', 'Withdrawal has been sent', 'User #username# received $#amount# to #currency# account #account#. \r\n\r\nBatch is #batch#.\r\n', 1),
('deposit_admin_notification', 'Administrator Deposit Notification', 'A deposit has been processed', 'User #username# deposit $#amount# #currency# to #plan#.\r\n\r\nAccount: #account#\r\nBatch: #batch#\r\nCompound: #compound#%.\r\nReferrers fee: $#ref_sum#\r\n', 1),
('deposit_user_notification', 'Deposit User Notification', 'Payment received', 'Dear #name# (#username#)\r\n\r\nWe have successfully received your deposit for the total amount of: $#amount# #currency# to #plan#.\r\n\r\nYour Account: #account#\r\nBatch: #batch#\r\nCompound: #compound#%.\r\n\r\nThank you.\r\n#site_name#\r\n#site_url#\r\n', 1),
('exchange_admin_notification', 'Exchange Admin Notification', 'Currency Exchange Processed', 'User #username# has exchanged $#amount_from# #currency_from# to $#amount_to# #currency_to#.\r\n', 1),
('exchange_user_notification', 'Exchange User Notification', 'Currency Exchange Completed', 'Dear #name# (#username#).\r\n\r\nYou have successfully exchanged $#amount_from# #currency_from# to $#amount_to# #currency_to#.\r\n\r\nThank you.\r\n#site_name#\r\n#site_url#\r\n', 1),
('brute_force_activation', 'Account Activation after Brute Force', '#site_name# - Your account activation code.', 'Someone from IP #ip# has entered wrong password for your account "#username#" incorrectly #max_tries# times. \r\n\r\nSystem locked your account until you activate it.\r\n\r\nClick here to activate your account:\r\n\r\n#site_url#?a=activate&code=#activation_code#\r\n\r\nThank you.\r\n#site_name#\r\n', 1),
('direct_signup_notification', 'Direct Referral Signup', 'You have a new direct signup on #site_name#', 'Dear #name# (#username#)\r\n\r\nYou have a new direct signup on #site_name#\r\n\r\nUser: #ref_username#\r\nName: #ref_name#\r\nE-mail: #ref_email#\r\n\r\nThank you.\r\n', 1),
('referral_commision_notification', 'Referral Comission Notification', '#site_name# Referral Comission', 'Dear #name# (#username#)\r\n\r\nYou have recived a referral comission of $#amount# #currency# from the #ref_name# (#ref_username#) deposit.\r\n\r\nThank you.\r\n', 1),
('pending_deposit_admin_notification', 'Deposit Request Admin Notification', 'Deposit Request Notification', 'User #username# save deposit $#amount# of #currency# to #plan#.\r\n\r\n#fields#\r\n', 1),
('deposit_approved_admin_notification', 'Deposit Approved Admin Notification', 'Deposit has been approved', 'Deposit has been approved:\r\n\r\nUser: #username# (#name#)\r\nAmount: $#amount# of #currency#\r\nPlan: #plan#\r\nDate: #deposit_date#\r\n#fields#\r\n', 1),
('deposit_approved_user_notification', 'Deposit Approved User Notification', 'Deposit has been approved', 'Dear #name#\r\n\r\nYour deposit has been approved:\r\n\r\nAmount: $#amount# of #currency#\r\nPlan: #plan#\r\n#fields#\r\n', 1),
('account_update_confirmation', 'Account Update Confirmation', 'Account Update Confirmation', 'Dear #name# (#username#),\r\n\r\nSomeone from IP address #ip# (most likely you) is trying to change your account data.\r\n\r\nTo confirm these changes please use this Confirmation Code:\r\n\r\n#confirmation_code#\r\n\r\nThank you.\r\n#site_name#\r\n#site_url#\r\n', 1);
-- --------------------------------------------------------
--
-- Table structure for table `hm2_exchange_rates`
--
CREATE TABLE `hm2_exchange_rates` (
`sfrom` int(10) unsigned default NULL,
`sto` int(10) unsigned default NULL,
`percent` float(5,2) default '0.00'
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_history`
--
CREATE TABLE `hm2_history` (
`id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`amount` float(10,5) default NULL,
`type` enum('deposit','bonus','penality','earning','withdrawal','commissions','early_deposit_release','early_deposit_charge','release_deposit','add_funds','withdraw_pending','exchange_in','exchange_out','internal_transaction_spend','internal_transaction_receive') default NULL,
`description` text NOT NULL,
`actual_amount` float(10,5) default NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`str` varchar(40) NOT NULL default '',
`ec` int(11) NOT NULL default '0',
`deposit_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_news`
--
CREATE TABLE `hm2_news` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime default NULL,
`title` varchar(255) default NULL,
`small_text` text,
`full_text` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_online`
--
CREATE TABLE `hm2_online` (
`ip` varchar(15) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_pay_errors`
--
CREATE TABLE `hm2_pay_errors` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_pay_settings`
--
CREATE TABLE `hm2_pay_settings` (
`n` varchar(200) NOT NULL default '',
`v` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_pending_deposits`
--
CREATE TABLE `hm2_pending_deposits` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`ec` bigint(20) unsigned default NULL,
`fields` text,
`user_id` bigint(20) unsigned NOT NULL default '0',
`amount` float(10,5) NOT NULL default '0.00000',
`type_id` bigint(20) unsigned NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`status` enum('new','problem','processed') NOT NULL default 'new',
`compound` double(10,5) NOT NULL default '0.00000',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_plans`
--
CREATE TABLE `hm2_plans` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(250) default NULL,
`description` text,
`min_deposit` float(10,2) default NULL,
`max_deposit` float(10,2) default NULL,
`percent` float(10,2) default NULL,
`status` enum('on','off') default NULL,
`parent` bigint(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_processings`
--
CREATE TABLE `hm2_processings` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) default NULL,
`infofields` text,
`status` tinyint(1) unsigned NOT NULL default '1',
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1006 ;
INSERT INTO `hm2_processings` (`id`, `name`, `infofields`, `status`, `description`) VALUES
(999, 'Bank Wire', 'a:3:{i:1;s:9:"Bank Name";i:2;s:12:"Account Name";i:3;s:15:"Payment Details";}', 0, 'Send your bank wires here:<br>\r\nBeneficiary''s Bank Name: <b>Your Bank Name</b><br>\r\nBeneficiary''s Bank SWIFT code: <b>Your Bank SWIFT code</b><br>\r\nBeneficiary''s Bank Address: <b>Your Bank address</b><br>\r\nBeneficiary Account: <b>Your Account</b><br>\r\nBeneficiary Name: <b>Your Name</b><br>\r\n\r\nCorrespondent Bank Name: <b>Your Bank Name</b><br>\r\nCorrespondent Bank Address: <b>Your Bank Address</b><br>\r\nCorrespondent Bank codes: <b>Your Bank codes</b><br>\r\nABA: <b>Your ABA</b><br>'),
(1000, 'e-Bullion', 'a:2:{i:1;s:13:"Payer Account";i:2;s:14:"Transaction ID";}', 0, 'Please send your payments to this account: <b>Your e-Bullion account</b>'),
(1001, 'NetPay', 'a:2:{i:1;s:13:"Payer Account";i:2;s:14:"Transaction ID";}', 0, 'Send your funds to account: <b>Your NetPay account</b>'),
(1002, 'GoldMoney', 'a:2:{i:1;s:13:"Payer Account";i:2;s:14:"Transaction ID";}', 0, 'Send your fund to account: <b>your GoldMoney account</b>'),
(1003, 'MoneyBookers', 'a:2:{i:1;s:13:"Payer Account";i:2;s:14:"Transaction ID";}', 0, 'Send your funds to account: <b>your MoneyBookers account</b>'),
(1004, 'Pecunix', 'a:2:{i:1;s:19:"Your e-mail address";i:2;s:16:"Reference Number";}', 0, 'Send your funds to account: <b>your Pecunix account</b>'),
(1005, 'PicPay', 'a:2:{i:1;s:13:"Payer Account";i:2;s:14:"Transaction ID";}', 0, 'Send your funds to account: <b>Your PicPay account</b>');
-- --------------------------------------------------------
--
-- Table structure for table `hm2_referal`
--
CREATE TABLE `hm2_referal` (
`id` bigint(20) NOT NULL auto_increment,
`level` bigint(20) NOT NULL default '0',
`name` varchar(200) default NULL,
`from_value` bigint(20) NOT NULL default '0',
`to_value` bigint(20) NOT NULL default '0',
`percent` double(10,2) default NULL,
`percent_daily` double(10,2) default NULL,
`percent_weekly` double(10,2) default NULL,
`percent_monthly` double(10,2) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_referal_stats`
--
CREATE TABLE `hm2_referal_stats` (
`date` date NOT NULL default '0000-00-00',
`user_id` bigint(20) NOT NULL default '0',
`income` bigint(20) NOT NULL default '0',
`reg` bigint(20) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_settings`
--
CREATE TABLE `hm2_settings` (
`name` varchar(200) NOT NULL default '',
`value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_types`
--
CREATE TABLE `hm2_types` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(250) default NULL,
`description` text,
`q_days` bigint(20) default NULL,
`min_deposit` float(10,2) default NULL,
`max_deposit` float(10,2) default NULL,
`period` enum('d','w','b-w','m','2m','3m','6m','y','end') default NULL,
`status` enum('on','off','suspended') default NULL,
`return_profit` enum('0','1') default NULL,
`return_profit_percent` float(10,2) default NULL,
`percent` float(10,2) default NULL,
`pay_to_egold_directly` int(11) NOT NULL default '0',
`use_compound` int(11) NOT NULL default '0',
`work_week` int(11) NOT NULL default '0',
`parent` int(11) NOT NULL default '0',
`withdraw_principal` tinyint(1) unsigned NOT NULL default '0',
`withdraw_principal_percent` double(10,2) NOT NULL default '0.00',
`withdraw_principal_duration` int(10) unsigned NOT NULL default '0',
`compound_min_deposit` double(10,2) default '0.00',
`compound_max_deposit` double(10,2) default '0.00',
`compound_percents_type` tinyint(1) unsigned default '0',
`compound_min_percent` double(10,2) default '0.00',
`compound_max_percent` double(10,2) default '100.00',
`compound_percents` text,
`closed` tinyint(1) unsigned NOT NULL default '0',
`withdraw_principal_duration_max` int(10) unsigned NOT NULL default '0',
`dsc` text,
`hold` int(11) NOT NULL default '0',
`delay` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_user_access_log`
--
CREATE TABLE `hm2_user_access_log` (
`id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`date` datetime default NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hm2_users`
--
CREATE TABLE `hm2_users` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(200) default NULL,
`username` varchar(20) default NULL,
`password` varchar(50) default NULL,
`date_register` datetime default NULL,
`egold_account` bigint(20) NOT NULL default '0',
`email` varchar(200) default NULL,
`status` enum('on','off','suspended') default NULL,
`came_from` text NOT NULL,
`ref` bigint(20) NOT NULL default '0',
`deposit_total` float(10,2) NOT NULL default '0.00',
`confirm_string` varchar(200) NOT NULL default '',
`ip_reg` varchar(15) NOT NULL default '',
`last_access_time` datetime NOT NULL default '0000-00-00 00:00:00',
`last_access_ip` varchar(15) NOT NULL default '',
`stat_password` varchar(200) NOT NULL default '',
`auto_withdraw` int(11) NOT NULL default '1',
`user_auto_pay_earning` int(11) NOT NULL default '0',
`admin_auto_pay_earning` int(11) NOT NULL default '0',
`pswd` varchar(50) NOT NULL default '',
`evocash_account` bigint(20) NOT NULL default '0',
`intgold_account` bigint(20) NOT NULL default '0',
`hid` varchar(50) NOT NULL default '',
`l_e_t` datetime NOT NULL default '2004-01-01 00:00:00',
`activation_code` varchar(50) NOT NULL default '',
`bf_counter` tinyint(3) unsigned NOT NULL default '0',
`address` varchar(255) default NULL,
`city` varchar(255) default NULL,
`state` varchar(255) default NULL,
`zip` varchar(255) default NULL,
`country` varchar(255) default NULL,
`transaction_code` varchar(255) default NULL,
`stormpay_account` varchar(200) NOT NULL default '',
`ebullion_account` varchar(200) NOT NULL default '',
`paypal_account` varchar(200) NOT NULL default '',
`goldmoney_account` varchar(200) NOT NULL default '',
`eeecurrency_account` bigint(20) NOT NULL default '0',
`pecunix_account` bigint(20) NOT NULL default '0',
`ac` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=41 ;
INSERT INTO `hm2_users` (`id`, `name`, `username`, `password`, `date_register`, `egold_account`, `email`, `status`, `came_from`, `ref`, `deposit_total`, `confirm_string`, `ip_reg`, `last_access_time`, `last_access_ip`, `stat_password`, `auto_withdraw`, `user_auto_pay_earning`, `admin_auto_pay_earning`, `pswd`, `evocash_account`, `intgold_account`, `hid`, `l_e_t`, `activation_code`, `bf_counter`, `address`, `city`, `state`, `zip`, `country`, `transaction_code`, `stormpay_account`, `ebullion_account`, `paypal_account`, `goldmoney_account`, `eeecurrency_account`, `pecunix_account`, `ac`) VALUES (1, 'admin name', 'admin', '827ccb0eea8a706c4c34a16891f84e7b', NULL, 0, 'sr_tft@yahoo.com', 'on', ' ', 0, 0.00, '', '', '', '', '', 1, 0, 0, '', 0, 0, '2F49DC598A69FEAB30143C37305A98', '2006-04-24 22:23:04', '', 0, '', '', '', '', '', '', '', '', '', '', 0, 0, '2278720242440a0e7864215c405c51401d2f321a7a32797a7b1a5d5e4356202a205d1602410e7372781a25243727224c665542583535204b1602410e7a7c605c283222202d5d5d150b4478737f1b5154535d2e64794b7b707578634b4b68445136063c585c565d1a21292f1a7a3c');
-- --------------------------------------------------------
--
-- Table structure for table `hm2_wires`
--
CREATE TABLE `hm2_wires` (
`id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`pname` varchar(250) NOT NULL default '',
`paddress` varchar(250) NOT NULL default '',
`pzip` varchar(250) NOT NULL default '',
`pcity` varchar(250) NOT NULL default '',
`pstate` varchar(250) NOT NULL default '',
`pcountry` varchar(250) NOT NULL default '',
`bname` varchar(250) NOT NULL default '',
`baddress` varchar(250) NOT NULL default '',
`bzip` varchar(250) NOT NULL default '',
`bcity` varchar(250) NOT NULL default '',
`bstate` varchar(250) NOT NULL default '',
`bcountry` varchar(250) NOT NULL default '',
`baccount` varchar(250) NOT NULL default '',
`biban` varchar(250) NOT NULL default '',
`bswift` varchar(250) NOT NULL default '',
`amount` float(10,5) default NULL,
`type_id` bigint(20) default NULL,
`wire_date` datetime NOT NULL default '0000-00-00 00:00:00',
`compound` float(10,5) default NULL,
`status` enum('new','problem','processed') default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;Дава ми това: