Free PTC MLM Web Template

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]

Share this :

थका हूँ... बुझा नहीं

Previous
Next Post »
0 Komentar

Write markup in comments
  • Please leave a comment by topic. Comments that include active links, ads, or promotion will be deleted.
  • To insert the code use <i rel="code"> kode yang akan disisipkan </i>
  • To insert long code use <i rel="pre"> kode yang akan disisipkan </i>
  • To insert a quote use <i rel="quote"> catatan anda </i>
  • To insert a picture use <i rel="image"> URL gambar </i>
  • To insert video use [iframe] URL embed video [/iframe]
  • Then parse the code in the box below
  • © 2015 Simple SEO ✔