mlm/buy.php at master · staddy/mlm · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<?php

include_once("z_db.php");

// only for testing
// я думаю, дальше будет здорово сделать запрос из html с параметром A/B баллов

$scoretype = 'a';

function pay_and_go_up($con_, $userid, $sourceid, $side, $h, $amount, $scoretype) {
    if(($amount > 0) && ($side!="none")) {
        // to see if it's okay
        echo("userid: ".$userid." source: ".$sourceid." side: ".$side." h: ".$h." amount: ".$amount);

        $query2 = "SELECT active,".$h."_active,referedby,ref_h,ref_side FROM affiliateuser where Id = '$userid'";
        $result2 = mysqli_query($con_,$query2);
        $row2 = mysqli_fetch_row($result2);

        $active="$row2[0]";
        $h_active="$row2[1]";
        $referedby="$row2[2]";
        $ref_h="$row2[3]";
        $ref_side="$row2[4]";

        if($active && $h_active) {
            $cur=date("Y-m-d");
            $insertbalancestmnt = "insert into payments_balance(userid,sourceid,h_number,side,scoretype,payment_amount,createdtime) values(".$userid.",".$sourceid.",'".$h."','".$side."','".$scoretype."',".$amount.",'".$cur."')";
            echo("<br/>".$insertbalancestmnt);
            $query=mysqli_query($con_, $insertbalancestmnt);
        }

        if($referedby != "none") {
            $query3 = "SELECT COUNT(*),Id FROM affiliateuser where username = '$referedby'";
            $result3 = mysqli_query($con_, $query3);
            $row3 = mysqli_fetch_row($result3);
            $isref = $row3[0];
            $refid = $row3[1];
            if($isref == 1) {
                pay_and_go_up($con_, $refid, $sourceid, $ref_side, $ref_h, $amount,$scoretype);
            }
        }
    }
}

if(isset($_GET['id']) && isset($_GET['amount']) && is_numeric($_GET['amount']) && isset($_GET['type'])) {
    $id=mysqli_real_escape_string($con,$_GET['id']);
    $amount=$_GET['amount'];
    // now this thing is retrieved from the http request
    $scoretype=$_GET['type'];
    $result = mysqli_query($con,"SELECT referedby,ref_h,ref_side FROM affiliateuser where Id = '$id'");
    $row = mysqli_fetch_row($result);
    $referedby = $row[0];
    $ref_h = $row[1];
    $ref_side = $row[2];
    if($referedby != "none") {
        $query3 = "SELECT COUNT(*),Id FROM affiliateuser where username = '$referedby'";
        $result3 = mysqli_query($con, $query3);
        $row3 = mysqli_fetch_row($result3);
        $isref = $row3[0];
        $refid = $row3[1];
        if($isref == 1) {
            pay_and_go_up($con, $refid, $id, $ref_side, $ref_h, $amount, $scoretype);
        }
    }
} else {
    die();
}

?>