-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 19, 2010 at 07:34 AM -- Server version: 5.1.41 -- PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `sastambile` -- -- -------------------------------------------------------- -- -- Table structure for table `lovecandy_admins` -- CREATE TABLE IF NOT EXISTS `lovecandy_admins` ( `id` int(10) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL DEFAULT '', `password` varchar(50) NOT NULL DEFAULT '', `last_name` varchar(50) NOT NULL DEFAULT '', `first_name` varchar(50) NOT NULL DEFAULT '', `email` varchar(50) NOT NULL DEFAULT '', `status` enum('main admin','admin') NOT NULL DEFAULT 'main admin', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `lovecandy_admins` -- INSERT INTO `lovecandy_admins` (`id`, `username`, `password`, `last_name`, `first_name`, `email`, `status`) VALUES (1, 'admin', 'admin', 'Leaders', 'Info Tech', 'webmediaworld2@gmail.com', 'main admin'); -- -------------------------------------------------------- -- -- Table structure for table `lovecandy_menu` -- CREATE TABLE IF NOT EXISTS `lovecandy_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `page_name` varchar(150) NOT NULL DEFAULT '', `is_menu_group` tinyint(1) NOT NULL DEFAULT '0', `is_removable` tinyint(1) NOT NULL DEFAULT '0', `is_hidden` tinyint(1) NOT NULL DEFAULT '0', `parent_id` int(11) NOT NULL DEFAULT '0', `order_index` tinyint(3) NOT NULL DEFAULT '0', `icon` varchar(30) DEFAULT NULL, `is_dashboard_icon` tinyint(1) DEFAULT '1', `is_menu_item` tinyint(1) NOT NULL DEFAULT '1', `file_type_id` tinyint(3) NOT NULL DEFAULT '2', PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `is_menu_name` (`is_menu_group`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=147 ; -- -- Dumping data for table `lovecandy_menu` -- INSERT INTO `lovecandy_menu` (`id`, `name`, `page_name`, `is_menu_group`, `is_removable`, `is_hidden`, `parent_id`, `order_index`, `icon`, `is_dashboard_icon`, `is_menu_item`, `file_type_id`) VALUES (1, 'General', '', 1, 0, 0, 0, 0, NULL, 1, 1, 2), (2, 'Account Manager', '', 1, 0, 0, 0, 5, NULL, 1, 1, 2), (3, 'Pages', '', 1, 0, 0, 0, 10, NULL, 1, 1, 2), (33, 'Menu Manager', 'menu_manager.php', 0, 0, 0, 1, 10, 'menu.png', 1, 1, 2), (37, 'Change Password', 'pages/admins.php', 0, 0, 0, 2, 0, 'chgpwd.png', 1, 1, 2), (94, 'Benefits', 'pages/static_pages.php?page=benefits&side=middle', 0, 0, 0, 68, 0, 'aboutus.png', 1, 1, 2), (127, 'Main', 'home.php', 0, 0, 0, 1, 0, 'pages.png', 1, 1, 2), (128, 'Benefits', 'pages/static_pages.php?page=howwrk&side=middle', 0, 0, 0, 3, 0, 'aboutus.png', 1, 1, 2), (130, 'memarea', 'pages/static_pages.php?page=memarea&side=middle', 0, 0, 0, 3, 0, 'designers.png', 1, 1, 2), (139, 'Change Email', 'pages/change_email.php', 0, 0, 0, 2, 0, 'email.png', 1, 1, 2), (141, 'Faq', 'pages/static_pages.php?page=faq&side=middle', 0, 0, 0, 3, 0, 'faq.png', 1, 1, 2), (142, 'Contact', 'pages/static_pages.php?page=contact&side=middle', 0, 0, 0, 3, 0, 'contact.png', 1, 1, 2), (145, 'Applications', '', 1, 0, 0, 0, 6, NULL, 1, 1, 2), (146, 'Applications', 'pages/applications.php', 0, 0, 0, 145, 0, 'addedit.png', 1, 1, 2); -- -------------------------------------------------------- -- -- Table structure for table `lovecandy_pages` -- CREATE TABLE IF NOT EXISTS `lovecandy_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `page` varchar(50) NOT NULL, `side` varchar(50) NOT NULL, `description` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `lovecandy_pages` -- INSERT INTO `lovecandy_pages` (`id`, `page`, `side`, `description`) VALUES (1, 'home', 'middle', '
Welcome To Our Website and thanks for visiting.
'), (2, 'Howwrk', 'middle', '| \r\n | How It Works | \r\n||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | Benefits | \r\n||||||||||||||||
| \r\n | \r\n Insurance premiums keep rising despite the economic situation worldwide, it has become increasing challenging to keep up with these and many other increasing payments, which force many to take grave chances that eventually, cost us more in the long run. \r\nThis Saving Program has been put together to assist policy holders of motor vehicle insurance to be able to pay their premiums on time and avoid penalties by Law Enforcement for delinquencies. This financial benefit is offered to policy holders who would normally consider these high premium payments to be a monitory loss, especially when they have never had reasons to make a claim. \r\nParticipants in this program are entitled to the benefit herein; \r\n
All participants in the program also becomes a referral agent to the said program, no selling is required, but for each referred client, the agent will paid continuously a commission of four percent (4%) of the monthly payment on a multilevel basis to the 3rd levels. This means that for each person you refer who becomes a client, you will be paid each time he/she makes their monthly payment, and any one that person refers, they get paid and you also get paid the same rate and so on, to 3rd generations. \r\n | \r\n ||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | Illustration 1 | \r\n||||||||||||||||
| \r\n | \r\n
| \r\n ||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | \r\n Overview \r\n | \r\n ||||||||||||||||
| \r\n | \r\n
| \r\n ||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | Conditions | \r\n||||||||||||||||
| \r\n | \r\n This program is designed particularly to assist the owners of Motor Vehicle whom during these hard times must from year to year find an enormous sum of money to ensure the payment of insurance coverage on their vehicle or get rid of it. The Program allows for all owners of domestic or light weight commercial motor vehicles such as motorcars, van/buses, trucks and motorcycles despite where you are on the globe to be able to ensure your insurance payment as they become due each year by offering you a 40% saving from your last insurance payment, payable to your insurance company on renewal. \r\nMotor Insurance Saving Inc. (MIS) is not an insurance company nor are we affiliated to any such company. The contractual agreement is between the policy owner of a motor vehicle insurance policy and Motor Insurance Saving Inc. | \r\n ||||||||||||||||
| \r\n | \r\n Each contract is regarded by the assigned policy number issued by the insurance company and is considered on an individual basis, contracts are not transferable \r\n | \r\n ||||||||||||||||
| \r\n | \r\n Should for any reason the Insurance Policy Contract be terminated by the insurance company, the Contract with us will also be terminated as there would be no renewal date applicable to the said policy. Should an applicant have multiple units, each unit will need a different account. Funds are only applicable on the renewal of the policy with the check payable to the insurance company regarding the policy number on file. A copy of the policy contract may be requested by MIS inc. at any time before a disbursement of the funds to the insurance company. The company has the rights to change the conditions as it applies to the contract at anytime, but such changes will not affect contracts already issued but more so new contract entering into. Fees; All information shared with us in regards to this program is kept in the strictest form of confidence and will not be shared with any person or society not relevant to the program unless with the permission of the policyholder. Information as it applies to the Insurance policy and the Insurance Company involved will be verified before disbursement of any funds. \r\n | \r\n ||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | \r\n Opportunity \r\n | \r\n ||||||||||||||||
| \r\n | One must be a motor vehicle policy owner in order to qualify to be on this program and base off the fact that all persons will have policy renewal dates at different times throughout the year and one becomes qualified on the renewal date or up to 2 months after the renewal date, it stands to reason that all persons cannot qualify to be on the program at the same time. However we have arranged that one may get in on the program especially for the earning opportunity at anytime he/she so desire by applying for the program and paying the monthly premiums as it applies to participants for the nine months, that person would be able to receive the 40% discount on the renewal date that falls after the end of the payment. | \r\n||||||||||||||||
| \r\n | \r\n As mention prior to now all participants in the program has the opportunity to increase their income potential by referring other persons to the program, whereby for all referred clients you introduce to the program, you will earn 4% of the amount they pay monthly and 4% of the same amount that the people they refer monthly and so on to the 3rd generation. Note also that each year they renew their account you will be the sponsor on record for that policy number, therefore establishing continued recurring income. One can place their own vehicles on the program using their own sponsor code, providing it is not the same policy number as placed with your sponsor in your up line. You will be earning everyday whether or not you are working as long as you have people working in your down line. \r\n | \r\n ||||||||||||||||
| \r\n | \r\n THAT’S HUGE…. \r\n | \r\n ||||||||||||||||
| \r\n | \r\n Income Calculator \r\n | \r\n ||||||||||||||||
| \r\n | Let’s say you referred 20 clients and each client referred the same; at $1 commission per client per month | \r\n||||||||||||||||
| \r\n | \r\n
| \r\n ||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | Not only will you be saving money on your insurance premiums annually but now you are able to earn a continuous monthly income for just telling others about the program. \r\n \r\n You may want to get onboard as soon as possible to refer somebody before they refer you, thus becoming their sponsor rather than they being yours. | \r\n ||||||||||||||||
| \r\n | \r\n | ||||||||||||||||
| \r\n | \r\n \r\n | \r\n
'), (3, 'application form', 'middle', '
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n | \r\n ||||||||
| \r\n |
\r\n
| \r\n ||||||||||||||||||||||||||
\r\n
| \r\n ||||||||||||||
Contact with us for further Information
'); -- -------------------------------------------------------- -- -- Table structure for table `lovecandy_settings` -- CREATE TABLE IF NOT EXISTS `lovecandy_settings` ( `id` tinyint(3) NOT NULL AUTO_INCREMENT, `site_name` varchar(125) NOT NULL DEFAULT '', `site_address` varchar(125) NOT NULL DEFAULT '', `css_style` varchar(10) NOT NULL DEFAULT '', `header_text` varchar(125) NOT NULL DEFAULT '', `site_language` char(2) NOT NULL DEFAULT 'en', `datagrid_css_style` varchar(10) NOT NULL DEFAULT 'default', `menu_style` enum('left','top') NOT NULL DEFAULT 'left', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `lovecandy_settings` -- INSERT INTO `lovecandy_settings` (`id`, `site_name`, `site_address`, `css_style`, `header_text`, `site_language`, `datagrid_css_style`, `menu_style`) VALUES (1, 'Motor Insurance Saving', 'www.blackant.com', 'blue', 'Administrator Panel', 'en', 'blue', 'top'); -- -------------------------------------------------------- -- -- Table structure for table `lovecandy_user` -- CREATE TABLE IF NOT EXISTS `lovecandy_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sponsor_code` varchar(100) NOT NULL, `user_name` varchar(100) NOT NULL, `name` varchar(100) NOT NULL, `address` varchar(100) NOT NULL, `country` varchar(100) NOT NULL, `how_long` int(11) NOT NULL, `prev_address` varchar(100) NOT NULL, `age` int(11) NOT NULL, `dob` varchar(50) NOT NULL, `gender` varchar(5) NOT NULL, `status` varchar(5) NOT NULL, `telephone` varchar(100) NOT NULL, `cell` varchar(100) NOT NULL, `fax` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `occupation` varchar(100) NOT NULL, `employer` varchar(100) NOT NULL, `employer_address` varchar(100) NOT NULL, `insurer_name` varchar(100) NOT NULL, `insurer_address` varchar(100) NOT NULL, `insurer_contact` varchar(100) NOT NULL, `insurance_policy` varchar(100) NOT NULL, `policy_type` varchar(100) NOT NULL, `vehicle_year` varchar(10) NOT NULL, `vehicle_make` varchar(10) NOT NULL, `vehicle_model` varchar(10) NOT NULL, `vin` varchar(10) NOT NULL, `renewal_date` varchar(50) NOT NULL, `print_name` varchar(50) NOT NULL, `curr_date` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `lovecandy_user` -- INSERT INTO `lovecandy_user` (`id`, `sponsor_code`, `user_name`, `name`, `address`, `country`, `how_long`, `prev_address`, `age`, `dob`, `gender`, `status`, `telephone`, `cell`, `fax`, `email`, `occupation`, `employer`, `employer_address`, `insurer_name`, `insurer_address`, `insurer_contact`, `insurance_policy`, `policy_type`, `vehicle_year`, `vehicle_make`, `vehicle_model`, `vin`, `renewal_date`, `print_name`, `curr_date`) VALUES (5, 'sdaf', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 0, 'asdfa', 0, 'asdfa', 'asdfa', 'asdfa', '--', '--', '--', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'asdfa', 'Day-Month-Year', 'asdfa', 'asdfa'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;