Отменен

PHP Custom Affiliate Scripts - ASA

Blueprint - Affiliate Program

This Script will run in a website that is already running and has a database with members registered already

The developer of the script will add as many tables and rows as the script need it

I will install the script and include it into the designed graphics html pages

I will add the additional tables and rows to the database

I will send you a SQL database sample with the tables and rows already in the data base that will use this scripts

Payment will be done by escrow using [url removed, login to view]

I will escrow the 50% of the payment after I will be able to TEST half of the project in YOUR server (I don't have to get the scripts for this...)

After the first half test is done I will escrow the second 50% of the price

After the first job is complete. We can use Paypal for future payments for future changes in the script.

This is NOT a long list. This a detail explanation of what I need the scripts do. Please read and then submit your bit.

INFO: Dtabese MySQL

Operating System: Linux

PHP 4.4.7

1) PAGE#1 Member Login Page ([url removed, login to view]) directory /affiliate/[url removed, login to view]

* Member will write his login name and password and after submitting, the script will search in the table dt_members, if password and login name are TRUE

in the same row, the script will set in the table dt_affiliate_members his affiliate_id which it will be the same as "id" in table dt_members

* The setting of the dt_affiliate_members will be done ONLY the first time that the member login in the affiliate page.

* The login page also will have an extra required security step where the user has to write the letters and number that show in a little window, to prevent

computers to login an send spam.

* Please check table dt_affiliate_members (feel free to add or modify this table as you need it)

* Please check table dt_members (do NOT modify this table)

2) PAGE#2 Member Affiliate ([url removed, login to view])

* I will explain this later...

3) PAGE#3 Member Send Invitation Page ([url removed, login to view]) directory /affiliate/[url removed, login to view]

* Member will be able to send a invitation to his friend to join the affiliate program

* Member will only write the email address(es) that he would like to send the invitation and click send invitation

* Email address will have to be separate by commas

* Member will receive a confirmation showing the list of the email that he is going to invited to the affiliate program

* Email invited will be go in a list that the member will be able to see "Invited Friends"

* This list will show at the bottom of the Member Send Invitation Page

* To prevent Spam - IF an invitation was sent to an email(s) in less than 7 days in the confirmation page this email(s) will show in red with a note

at the end of the page saying "You have some Friend(s) that you invited already, to prevent spamming the system will not let you resend this invitation(s)

again after 7 days from the last invitation was sent"

* This page will be send an email that will be a standard form saved in a name [url removed, login to view] file

* This email will have a link to the website

* When link is click, the page will place a cookie in to the user computer

* When user register and login, it will be a script the read the cookie and assign the new member to the affiliate list to the member that invited him.

* If a user receive an invitation, and click the link, but did not register, then another friend send an invitation and click the link again, the FIRST COOKIE

will be delete and replace by the SECOND COOKIE

* The invitation email will have a link to unsubscribe, when user click this link will be added to a unsubscribe mailing list

/// THINGS TO BE CHECK BY THE SENDING INVITATION SCRIPT

- If the email to be send the invitation is already in the database in the table dt_members this email will not be send and will show in a green color

in the confirmation page saying next to the email "Member Already"

- If the email to be send the invitation is already in the unsubscribe mailing list this email will not be send and will show in a red color

in the confirmation page saying next to the email "This User is in our Unsubscribe Mailing List"

* Please check table dt_affiliate_invitation_data (feel free to add or modify this table as you need it)

4) and last... PAGE#2 Member Affiliate ([url removed, login to view]) directory /affiliate/[url removed, login to view]

* In this page members will be able to see the members that have joined the site under their sponsor or refer

* The system will work as a pyramid, where their a left side list name bottom_list in the dt_affiliate table and the right side list name top_list in

the same table.

* The system will place the new sponsor member under the list that has left sponsor members. If the 2 list have the same number of sponsor the default

list is the left list or bottom_list

Example: 1

/

2 3

/

4 5

* How you can see in the sample the system will keep putting sponsors for member 1 under 4 and 5 an so on. But, this is a pyramid, so this mean that 2, 3,

4 and 5 will also sponsor members. So, if 2 is adding four sponsors more, let say 6,7,8,9 the system will place him in the top_list an so on, so look like

this Example: 2

/

4 6

/

7 8

/

9

* Now, let say 5 is adding three sponsors too 10,11,12 so the system do this...

Example: 5

/

10 11

/

12

* At the end the system will look like this...

Example: 1

/

/

2 3

/

4 6 5

/ /

7 8 10 11

/ /

9 12

* At this point if member 1 refer a new sponsor the system will place under 11 in his top_list (the same as member 5 top_list)

* At this point the system will count this

- Member 1 has 11 sponsors (6 Sponsors in his bottom_list and 5 Sponsors in his top_list)

- Member 2 has 5 sponsors (3 Sponsors in his bottom_list and 2 Sponsors in his top_list)

- Member 3 has 4 sponsors (0 Sponsors in his bottom_list and 4 Sponsors in his top_list)

- Member 4 has 2 sponsors (2 Sponsors in his bottom_list and 0 Sponsors in his top_list)

- Member 5 has 3 sponsors (2 Sponsors in his bottom_list and 1 Sponsors in his top_list)

- Member 6 has 1 sponsors (0 Sponsors in his bottom_list and 1 Sponsors in his top_list)

- Member 7 has 1 sponsors (1 Sponsors in his bottom_list and 0 Sponsors in his top_list)

- Member 8 has 0 sponsors

- Member 9 has 0 sponsors

- Member 10 has 1 sponsors (1 Sponsors in his bottom_list and 0 Sponsors in his top_list)

- Member 11 has 0 sponsors

- Member 12 has 0 sponsors

* As you can see, the system relate the sponsors added with the members in the top

- Note that sponsors added for 4 and 6 will be added to 2 and 1 but never to 3

* Sponsored Member will be divide by the list # of Sponsored Members in bottom_list and # the Sponsored Members in the top_list

* The website has 3 kinds of members

- Unlimited Members with a pay membership

- Unlimited Members with a a coupon or promotion code

- Limited Members with Free accounts

* In the dt-members table the row unlimited defines this

Unlimited Members = 1

Limited Members = 0

* In the dt_promotion_member table the Unlimited Members that using a promotional code are define adding their member id to the memberrid row

* An extra script will be needed to run in a cron job every day, I will called [url removed, login to view] script directory /affiliate/admin/[url removed, login to view]

- This script will check Limited Member and Unlimited Members

- IF the Member is Limited (unlimited = 0) the script will do NOTHING

- IF the Member is Unlimited (unlimited = 1) the script will look for this Member ID and will look for it in the dt_promotion_member table in

the memberid row, IF the member id is there, the script will do NOTHING

- ELSE the script will add 1 point to the member that is located in top of his and all others member in top related to him

Example #1: In the table used before if 9 become a paid member a point will be added to 7, 4, 2 and 1

Example #2: In the table used before if 12 become a paid member a point will be added to 10, 5, 3 and 1

Example #3: In the table used before if 6 become a paid member a point will be added to 2 and 1

- This script will also add a timestamp of 32 day so this script will not check this member again on 32 days

- This timestamp will prevent from the script adding another point before 32 days

- This script will also separate the point for list, taken again the same examples...

In Example #1: In the table used before if 9 become a paid member a point will be added to 7, 4, 2 and 1

7 will receive a point to his left list (bottom_list)

4 will receive a point to his left list (bottom_list)

2 will receive a point to his left list (bottom_list)

1 will receive a point to his left list (bottom_list)

In Example #2: In the table used before if 12 become a paid member a point will be added to 10, 5, 3 and 1

10 will receive a point to his left list (bottom_list)

5 will receive a point to his left list (bottom_list)

3 will receive a point to his right list (top_list)

1 will receive a point to his right list (top_list)

In Example #3: In the table used before if 6 become a paid member a point will be added to 2 and 1

2 will receive a point to his right list (top_list)

1 will receive a point to his left list (bottom_list)

* The total of each list will be show in each side of the list, total of point on left list (bottom_list) and total of points in

the right list (top_list)

* The /affiliate/[url removed, login to view] page will print the name of the member in the top of the list

then will print in a pyramid style the sponsored members if they exist

please go to [url removed, login to view]

* Also in the top of this pay will print the amount to be pay this month in $

* The amount to be pay is the list that have less points

Example#1: bottom_list = 90, top_list = 58 the total amount to be pay is $58

* NOTE: The members will be able to see only up to their level and down. Their will no be able to see from the level up from their own.

* Since this is a pyramid, and it will be impossible to show everyone in one page, the system will only show down, up to 4 levels where

Level 1 is the Member

Level 2 ... the next 2 members down (if they are TRUE)

Level 3 ... the next 4 members down (if they are TRUE)

Level 4 ... the next 8 members down (if they are TRUE)

Level 5 ... the next 16 places (if they are TRUE) but each it will content the total of members down in that place, each of this total will be a

link to go in another page and see who is under.

* Please check table dt_affiliate_data (feel free to add or modify this table as you need it)

5) PAGE#5 The Administration page ([url removed, login to view]) directory /affiliate/admin/[url removed, login to view]

* This page will be the login page for the administration of the affiliate program

* Please check table dt_affiliate_admin (feel free to add or modify this table as you need it)

* The login name and password will be read it from the dt_affiliate_admin table where it look for adminid, password

* Also this page only will be able to be seen ONLY from the IP address include in the table ip_admin in the row good_ip (THIS WILL BE WITH ALL ADMIN PAGES)

* This page will show the list of all member and their stats, please divide the list by pages max 50 member per page in order descendent from higher

payment to less, if the payment is "0", then the default will be the affiliateid in order descendent too

* So the list will print...

affiliateid, login, total members referred by this member, total in members in his left list, total members in his right list,

total points in his left list, total points in his right list, total amount to be pay.

* Also this pay will check for this...

- IF the Member is Limited (unlimited = 0) this members is not getting pay, the amount to be pay for this member will show in RED.

- IF the Member is Unlimited (unlimited = 1) the script will look for this Member ID and will look for it in the dt_promotion_member table in

the memberid row, IF the member id is there, this members is not getting pay, the amount to be pay for this member will show in RED.

- ELSE the script will show the members that are getting pay if is higher than $10, , the amount to be pay for this member will show in GREEN.

- ELSE the script will show the members that are getting pay if is lower than $10, , the amount to be pay for this member will show in BLUE.

6) PAGE#6 The Administration Payments ([url removed, login to view]) directory /affiliate/admin/[url removed, login to view]

* This page is the one the will process the payment and will reset the stats for each member in the affiliate

* Payment will process manually for now, so this page will write and save the list that the payments that have to be done to the time

that the script was run

* This page will check this before processing the payments

- IF the Member is Limited (unlimited = 0) this members is not getting pay, this member is not showing in this page.

- IF the Member is Unlimited (unlimited = 1) the script will look for this Member ID and will look for it in the dt_promotion_member table in

the memberid row, IF the member id is there, this members is not getting pay, this member is not showing in this page.

- ELSE the script will show the members that are getting pay if is higher than $10

* This page will show a preview of the page that will process and be save for future record

* This page will have a submit button to process payment, after the submit button is click, the page will ask for a confirmation password,

the confirmation password will be the same password use for the administration to login.

* When the script run...

The script will reset the stat to "0" in bottom_list and top_list

- IF the Member is Limited (unlimited = 0) (this members is not getting pay)

- IF the Member is Unlimited (unlimited = 1) the script will look for this Member ID and will look for it in the dt_promotion_member table in

the memberid row, IF the member id is there. (this members is not getting pay)

ELSE The script will deduct the points from the higher point list from the lowest and the difference in points will ROLLOVER in the same list for the

next period of payment (EXAMPLE: bottom_list = 90, top_list = 58 the total amount to be pay is $58, the total points to be rollover to the bottom_list

is 32 = (90-58)) bottom_list = 32 points after the scrip is done

* This information will be save in the database

FOR EACH MEMBER IN THE AFFILIATE...

Paymentip (autoincrease) will be the same payment id for everyone, if the payment is #1 then this will be the payment #1 for all members

Date of the process

Affiliateid

Login

total points in his left list (bottom_list)

total points in his right list (top_list)

total rollover points

list that receive the rollover points

total reset points

total amount to paid

* Please check table dt_affiliate_payments (feel free to add or modify this table as you need it)

7) PAGE#7 The Administration Payments Info page ([url removed, login to view]) directory /affiliate/admin/[url removed, login to view]

* In this page will have a list of links of the payments reports

- Payment# and Date, when click it, it will show all the members that receive a payment in that period, it will show the login name and amount paid,

when the login name is click, will show a detail list of the payment

* Paymentip

* Date of the process

* Affiliateid

* Login

* total points in his left list (bottom_list)

* total points in his right list (top_list)

* total rollover points

* list that receive the rollover points

* total reset points

* total amount to paid

* Check No. (NOTE: since payment will be done manually this field will have to be add manually too, this field must have a little form in order to

include this information in this page, and a save button, if this field have the check info already then the save button should be a edit button

in order to change this info in case was submitted wrong.

8) PAGE#8 The Member Payments Info page ([url removed, login to view]) directory /affiliate/[url removed, login to view]

* In this page will have a list of links of the payments reports

- Payment# and Date, when click it, it will show a detail list of the process

* Paymentip

* Date of the process

* Affiliateid

* Login

* total points in his left list (bottom_list)

* total points in his right list (top_list)

* total rollover points

* list that receive the rollover points

* total reset points

* total amount to paid

* Check No.

9) PAGE#9 The Member Account Info ([url removed, login to view]) directory /affiliate/[url removed, login to view]

* This will be a form page where member will be able to add their info in order to send the checks, this field can be added to the dt_members table

- FIRST NAME:

- LAST NAME:

- SS#:

- ADDRESS:

- CITY:

- STATE:

- COUNTRY:

- PHONE:

- EMAIL: (this field will be read it from the dt_members table, row email) member will not be able to change this info

* Please check table dt_affiliate_members (feel free to add or modify this table as you need it)

This is the basic form for this affiliate program. More changes and report will be added in the future. I will keep working with the selected developer in

the future to make this script better. I will do the graphic design of this pages myself. I have knowledge about php so I will be able to integrate these script

into the html page. If I may forgot something will be added later on. I am looking to find long time working relationship.

Квалификация: PHP, Установка скриптов, Дизайн сайтов

Показать больше write what i say, write email to friend, write an email to a friend look, write an email to a friend, work places of graphic design, working at the limited, window graphics design, where to look for a php developer, where to find php developer, where to find developer info for a website, where to find a linux developer, where to find a job in graphic design, where to find a graphic design job, where do you find a developer, where do i find a website developer, where can you find a job for graphic design, where can i go to get a free graphic design done, where can i get some graphic job, where can i get some graphic design done, where can i get a graphic design job done

О работодателе:
( 23 отзыв(-а, -ов) ) Miami, United States

ID проекта: #223114

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $240

ranganathp

Can help... check my reviews... costs more...

$250 USD за 30 дней(-я)
(26 отзывов(-а))
6.3
zub

Hello Sir, Please see the PM. Thank you With regards Zub

$250 USD за 45 дней(-я)
(47 отзывов(-а))
5.9
fastwebsolutions

See pmb for more information Thank you.

$250 USD за 7 дней(-я)
(15 отзывов(-а))
5.7
gyanart

Dear Sir, Please see PMB

$250 USD за 4 дней(-я)
(43 отзывов(-а))
5.1
PhinWorks

I have templates for these type of site admin pages.

$200 USD за 5 дней(-я)
(0 отзывов(-а))
2.8