Free PTC MLM Web Template

Posted On // Leave a Comment
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 :

Copy Source | Copy HTML
  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` )
  74. VALUES ('Test terms of service text, this text supports html tags. <b>This is a bold text</b>');

0 comments:

Post a Comment