How do you make a referral system on US?

[lilpanda]

How would you allow users to make their referral link and when a unique ip accesses that and signs up the user of the referral link receives +1 in their payout column in the database.

[mudmin]

Well...Hmm. Let's work on this. This is kind of a basic overview of how I would walk through that logic to get you started

There is a tool in userspice called Input::get which will probably be your friend here.

What if you made a page called refer.php

Have that page look for the referrer's username in the link. So let's say my link looked like...

https://userspice.com/refer.php?id=mudmin

Then maybe you would add 2 columns to the users table.

Code:

payouts

and

Code:

payouts_paid

refer.php would look something like this...

Code:

$refer = Input::get('id'); //id is the get variable in the link

Then you want to check the database to see if that variable is legit.

Code:

$legitQ = $db->query("SELECT * FROM users WHERE username = ?",array($refer);

//check all usersnames for that link

Code:

$legitC = $legitQ->count();

//how many results did you get

Code:

if($legitC < 1){

Code:

echo "Invalid referral link.";

Code:

}else{

//get the user's account
$

Code:

legit = $legitQ->first();

//since usernames are unique, you only need first()
$oldPayout = $legit->payouts; //how many payouts DID they have

Code:

$newPayout = $oldPayout + 1;

Code:

$db->update("users",$legit->id,'payouts'=>$newPayout);

//give the user credit
//do whatever else you want to do

Code:

}

[lilpanda]

ok thank you very much!