x-MU.net форум

// Referral
if($mmw[switch_ref]==yes) {
$referral_result = mssql_query("SELECT memb___id,ref_check FROM MEMB_INFO WHERE ref_acc='$login'");
$referral_num = mssql_num_rows($referral_result);
if($referral_num>0) {
for($i=0; $i < $referral_num; ++$i) {
$rank = $i + 1;
$referral_row = mssql_fetch_row($referral_result);
if($referral_row[1]<=0) {
$char_ref_sql = mssql_query("Select name,Reset From Character WHERE AccountID='$referral_row[0]'");
for($c=0; $c < mssql_num_rows($char_ref_sql); ++$c) {
$char_ref_row = mssql_fetch_row($char_ref_sql);
if($char_ref_row[1]>0 && $referral_row[1]<=0) {
mssql_query("UPDATE MEMB_INFO SET [ref_check]='1' WHERE memb___id='$referral_row[0]'");
$referral_row[1] = 1;
$wh_resoult = mssql_query("Select memb___id,cspoints From MEMB_INFO WHERE memb___id = '$login'");
$wh_row = mssql_fetch_row($wh_resoult); $wh_updated = $wh_row[1] + $mmw[zen_for_ref];
mssql_query("UPDATE MEMB_INFO SET [cspoints]='$wh_updated' WHERE memb___id = '$login'");
writelog("referral","Account <b>$login</b> Has Been <font color=#FF0000>GET</font> Zen: $mmw[zen_for_ref]|For Acc: $referral_row[0]|For Char: $char_ref_row[0]");
}
}
}
if($referral_row[1]==1) {$ref_status = mmw_lang_have_a_reset;} else {$ref_status = mmw_lang_have_not_a_reset;}
$referral_list = $referral_list . "$rank. $referral_row[0] ($ref_status)<br>";
}
}
else {
$referral_list = mmw_lang_no_referral;
}
$referral_result_check = mssql_query("SELECT memb___id FROM MEMB_INFO WHERE ref_acc='$login' AND ref_check='1'");
$referral_num_check = mssql_num_rows($referral_result_check);
}