Advertisement

Responsive Advertisement

Free PTC MLM Web Template

Manish Deo November 25, 2011
Hey there! One of my reader told me that i am tired of goggling Free PTC MLM Web Template for my business and going to buy one. Then we searched same to help him out and look what we got there are many Free PTC Script on the internet like GeN2 but they are contain some malware tagging with that, thus we have written a basic script in PHP which works well with PTC and MLM Services with little modification.

This Contact Management Template has more that 15 standalone pages like Top Affiliate admin, Affiliate Settings, Report Options, view Affiliate Detail and equipped with security pages like Admin Session Control. This template is highly customizable, so go ahead and make this this useful. Ah.. forgotten to tell you that there is sql query that you have to create listed below :

  1. CREATE DATABASE `affiliate_test` ;
  2. use `affiliate_test`;
  3. CREATE TABLE `affiliate` (
  4. `id` INT UNSIGNED NOT NULL ,
  5. `name` VARCHAR( 100 ) NOT NULL ,
  6. `surname` VARCHAR( 100 ) NOT NULL ,
  7. `current_amount` DOUBLE NOT NULL ,
  8. `total_amount` DOUBLE NOT NULL ,
  9. PRIMARY KEY ( `id` )
  10. );
  11. CREATE TABLE `sold_item` (
  12. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  13. `aff_id` INT NOT NULL ,
  14. `sold_amount` DOUBLE NOT NULL ,
  15. `aff_amount` DOUBLE NOT NULL ,
  16. `sold_date` VARCHAR( 50 ) NOT NULL ,
  17. `smonth` INT NOT NULL ,
  18. `syear` INT NOT NULL ,
  19. PRIMARY KEY ( `id` )
  20. );
  21. CREATE TABLE `inc_amount` (
  22. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  23. `start_amount` INT NOT NULL ,
  24. `end_amount` INT NOT NULL ,
  25. `percentage` INT NOT NULL ,
  26. PRIMARY KEY ( `id` )
  27. );
  28. CREATE TABLE `aff_payment` (
  29. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  30. `aff_id` INT NOT NULL ,
  31. `payment_date` VARCHAR( 50 ) NOT NULL ,
  32. `payment_amount` DOUBLE NOT NULL ,
  33. `smonth` INT NOT NULL ,
  34. `syear` INT NOT NULL ,
  35. PRIMARY KEY ( `id` )
  36. );
  37. CREATE TABLE `app_seq` (
  38. `last_num` INT NOT NULL
  39. );
  40. INSERT INTO `app_seq` ( `last_num` )
  41. VALUES (
  42. '1000'
  43. );
  44. INSERT INTO `inc_amount` ( `id` , `start_amount` , `end_amount` , `percentage` )
  45. VALUES ('', '1', '1000', '3');
  46. INSERT INTO `inc_amount` ( `id` , `start_amount` , `end_amount` , `percentage` )
  47. VALUES ('', '1001', '2000', '4');
  48. INSERT INTO `inc_amount` ( `id` , `start_amount` , `end_amount` , `percentage` )
  49. VALUES ('', '2001', '3000', '5');
  50. INSERT INTO `inc_amount` ( `id` , `start_amount` , `end_amount` , `percentage` )
  51. VALUES ('', '3001', '4000', '6');
  52. INSERT INTO `inc_amount` ( `id` , `start_amount` , `end_amount` , `percentage` )
  53. VALUES ('', '4001', '5000', '7');
  54. ALTER TABLE `affiliate` ADD `address` VARCHAR( 250 ) NOT NULL ,
  55. ADD `city` VARCHAR( 100 ) NOT NULL ,
  56. ADD `postal_code` VARCHAR( 20 ) NOT NULL ,
  57. ADD `country` VARCHAR( 100 ) NOT NULL ,
  58. ADD `company_name` VARCHAR( 150 ) ,
  59. ADD `email` VARCHAR( 150 ) NOT NULL ,
  60. ADD `phone_number` VARCHAR( 30 ) NOT NULL ,
  61. ADD `web_site` VARCHAR( 100 ) ,
  62. ADD `recieve_special_offer` VARCHAR( 5 ) ,
  63. ADD `how_did_you_hear` VARCHAR( 100 ) ,
  64. ADD `accept_terms` VARCHAR( 5 ) NOT NULL ;
  65. CREATE TABLE `terms_of_service` (
  66. `terms` TEXT NOT NULL
  67. );
  68. CREATE TABLE `options_list` (
  69. `options` VARCHAR( 150 ) NOT NULL
  70. );
  71. INSERT INTO `options_list` ( `options` )
  72. VALUES ('Test'), ('Test 2');
  73. INSERT INTO `terms_of_service` ( `terms` )

Download Contact Management Template [PTC MLM]
Tags
Manish Deo

Posted by Manish Deo

A highly motivated and ambitious freelancer able to give Low Cost Web Design services and solutions for SME’s, Corporate, Individuals, and business customers. Possessing excellent website development skills and having the ability to work with minimum resource to produce cheap business website. Having a proven ability to offer best web design services within small business budget, consistently hit costing targets, improves best cheap business website practices and organizes time efficiently.

Post a Comment

1 Comments