I have it a total of 6 levels
Me>someone
someone>someone2
someone2>someone3
and so on
well when i get up to level 6 i need it to not update me anymore but if someone else adds one to have it update. its not allowing any other members to add referrals but instead is changing mine via the last one on level 6.
I will show you my code hoever i am sure you will see alot of if statements. I plan to clean it up just trying to get it to work.
Here is my code
Code: Select all
if($myinfo['username'] != '$refinfo') {
$q1 = mysql_query("INSERT INTO referrals(id, username) VALUES(null, '$d_user')")or die( mysql_error() );
}
if($_POST['referral_info'] != NULL) {
if($myinfo['referral'] == NULL) {
$r=mysql_query("UPDATE referrals SET referral='$d_user' WHERE username = '$refinfo'")or die(mysql_error());
}
}
if($_POST['referral_info'] != NULL) {
if($myinfo['level_2'] == NULL) {
$r=mysql_query("UPDATE referrals SET level_2='$d_user' WHERE referral ='$refinfo' LIMIT 1")or die( mysql_error() );
}
}
if($_POST['referral_info'] != NULL) {
if($myinfo['level_3'] == NULL) {
$r=mysql_query("UPDATE referrals SET level_3='$d_user' WHERE level_2 ='$refinfo' LIMIT 1")or die( mysql_error() );
}
}
if($_POST['referral_info'] != NULL) {
if($myinfo['level_4'] == NULL) {
$r=mysql_query("UPDATE referrals SET level_4='$d_user' WHERE level_3 ='$refinfo' LIMIT 1")or die( mysql_error() );
}
}
if($_POST['referral_info'] != NULL) {
if($myinfo['level_5'] == NULL) {
$r=mysql_query("UPDATE referrals SET level_5='$d_user' WHERE level_4 ='$refinfo' LIMIT 1")or die( mysql_error() );
}
}
if($_POST['referral_info'] != NULL) {
if($myinfo['level_6'] == NULL) {
$r=mysql_query("UPDATE referrals SET level_6='$d_user' WHERE level_5 ='$refinfo' LIMIT 1")or die( mysql_error() );
}
}I hope someone can help me out
Thanks