epinUpdate.php

<?php
require_once('../../../wp-config.php');
global $wpdb;
$table_prefix = mlm_core_get_table_prefix();

extract($_REQUEST);
$user_key=getuserkeybyid($user_id);
if(!empty($epin))
{
    $sql = "SELECT * FROM {$table_prefix}mlm_epins WHERE epin_no='".$epin."' AND status=1";
	$results = $wpdb->get_results($sql);
	if($wpdb->num_rows!=1)
	{
    $sql = "update {$table_prefix}mlm_epins set user_key='{$user_key}', date_used=now(), status=1 where epin_no ='{$epin}' ";
    $epinUpdate=$wpdb->query($sql);
    if(!empty($epinUpdate)){
    $userUpdate=mlmUserUpdateePin($user_id,$epin);
	
	$status = $wpdb->get_var("SELECT payment_status 
							FROM {$table_prefix}mlm_users 
							WHERE `user_id` = '".$user_id."'");
	if($status=='1')
	{
			insert_refferal_commision11($user_id);
	}
	}
    }
	
	
	if($epinUpdate && $userUpdate)
    {
        _e("<span class='error' style='color:green'>Congratulations! Your account is now set to Active.</span>");
    }
    else
    {
        _e("<span class='error' style='color:red'>Sorry. You have entered an invalid ePin.</span>");
    } 
}

function insert_refferal_commision11($user_id)
{ 
	global $wpdb;
	$date = date("Y-m-d H:i:s");
	$child_ids='';
	$mlm_payout = get_option('wp_mlm_payout_settings');
	$refferal_amount=$mlm_payout['referral_commission_amount'];
	$table_prefix = mlm_core_get_table_prefix();
	
	$user_id=$user_id;
	$row=$wpdb->get_row("SELECT * FROM {$table_prefix}mlm_users WHERE user_id=$user_id");
	$sponsor_key=$row->sponsor_key;
	$child_id = $row->id;
	if($sponsor_key !=0) {
	$sponsor= $wpdb->get_row("SELECT id FROM {$table_prefix}mlm_users WHERE user_key='".$sponsor_key."'"); 
	$sponsor_id=$sponsor->id;
	$sql = "INSERT INTO {$table_prefix}mlm_referral_commission SET date_notified ='$date',sponsor_id='$sponsor_id',child_id='$child_id',amount='$refferal_amount',payout_id='0' ON DUPLICATE KEY UPDATE child_id='$child_id'";
	
	$rs = $wpdb->query($sql);
			//if($rs){_e("<span class='error' style='color:red'>Inserting  Fail</span>");}
			 
																						
	}
}

?>