Esempio n. 1
0
function woocommerceCredit()
{
    if (isset($_GET["tab"]) && $_GET["tab"] != 1) {
        if ($_GET["tab"] == 2) {
            woocommerceCredit_users();
            return;
        } else {
            woocommerceCredit_products();
            return;
        }
    }
    if (isset($_POST['action']) && $_POST['action'] == 'addCredits') {
        global $wpdb;
        $user_id = $_POST["user"];
        $amount = $_POST["amount"];
        $result = $wpdb->get_row("SELECT credit FROM `" . $wpdb->prefix . "woocredit_users` WHERE user_id=" . $user_id);
        if ($result) {
            $amount = $result->credit + $amount;
            $sql = 'UPDATE `' . $wpdb->prefix . 'woocredit_users` SET `credit` = ' . $amount . ' WHERE `user_id`=' . $user_id . ';';
            $wpdb->query($sql);
        } else {
            $sql = 'INSERT INTO `' . $wpdb->prefix . 'woocredit_users` (user_id,credit) VALUES (' . $user_id . ',' . $amount . ');';
            $wpdb->query($sql);
        }
        $sql = 'INSERT INTO `' . $wpdb->prefix . 'woocredit_changes` (user_id,amount) VALUES (' . $user_id . ',' . $_POST["amount"] . ');';
        $wpdb->query($sql);
    }
    if (isset($_POST['action']) && $_POST['action'] == 'delete') {
        global $wpdb;
        $user_id = $_POST["user"];
        $sql = 'DELETE FROM `' . $wpdb->prefix . 'woocredit_users` WHERE `user_id`="' . $user_id . '";';
        $wpdb->query($sql);
    }
    include_once 'admin/management.php';
}
Esempio n. 2
0
function woocommerceCredit()
{
    if (isset($_GET["tab"])) {
        switch ($_GET["tab"]) {
            case 2:
                woocommerceCredit_users();
                break;
            default:
                default_menu();
                break;
        }
    } else {
        default_menu();
    }
}