PHP Database::update_by_key Examples

Example #1

File: json-alterbanner.php Project: JulioNavarro/Affiliates-For-All

<?php

/*
Copyright (c) 2008 Metathinking Ltd.
This file is part of Affiliates For All.
Affiliates For All is free software: you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
Affiliates For All is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
General Public License for more details.
You should have received a copy of the GNU General Public License
along with Affiliates For All.  If not, see
<http://www.gnu.org/licenses/>.
*/
$admin_required = TRUE;
require_once '../lib/bootstrap.php';
Template::check_ajax_key();
$db = new Database();
$row = $db->get_row_by_key('banners', 'id', $_GET['id']);
if ($row['name'] != $_GET['name']) {
    $row = $db->get_row_by_key('banners', 'name', $_GET['name']);
    if ($row != null) {
        echo json_encode('duplicate');
        exit;
    }
}
$db->update_by_key('banners', 'id', $_GET['id'], array('name' => $_GET['name'], 'link_target' => $_GET['linktarget'], 'enabled' => $_GET['enabled']));
echo json_encode(true);

Example #2

File: xmlrpc-cart.php Project: JulioNavarro/Affiliates-For-All

function order_cancelled($secret, $order_no)
{
    if ($error = check_secret($secret)) {
        return $error;
    }
    $db = new Database();
    $order = $db->get_row_by_key('orders', 'id', $order_no);
    if ($order['status'] == 'new') {
        $db->update_by_key('orders', 'id', $order_no, array('status' => 'cancelled'));
    } else {
        if ($order['status'] == 'shipped') {
            $db->update_by_key('orders', 'id', $order_no, array('status' => 'refunded'));
            $new_order = array('id' => $order['id'] . '-r', 'affiliate' => $order['affiliate'], 'affiliate_data' => $order['affiliate_data'], 'status' => 'refund', 'customer_email' => $order['customer_email'], 'customer_name' => $order['customer_name'], 'total' => -$order['total'], 'commission' => -$order['commission']);
            $db->insert('orders', $new_order);
        }
    }
}

Example #3

File: json-setpassword.php Project: JulioNavarro/Affiliates-For-All

<?php

/*
Copyright (c) 2008 Metathinking Ltd.
This file is part of Affiliates For All.
Affiliates For All is free software: you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
Affiliates For All is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
General Public License for more details.
You should have received a copy of the GNU General Public License
along with Affiliates For All.  If not, see
<http://www.gnu.org/licenses/>.
*/
require_once '../lib/bootstrap.php';
Template::check_ajax_key();
$db = new Database();
$result = $row = $db->update_by_key('affiliates', 'id', $_SESSION['affiliate_id'], array('local_password' => $_GET['password']));
echo json_encode($result ? true : false);

Example #4

File: json-setpaypal.php Project: JulioNavarro/Affiliates-For-All

<?php

/*
Copyright (c) 2008 Metathinking Ltd.
This file is part of Affiliates For All.
Affiliates For All is free software: you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
Affiliates For All is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
General Public License for more details.
You should have received a copy of the GNU General Public License
along with Affiliates For All.  If not, see
<http://www.gnu.org/licenses/>.
*/
$wizard_not_required = TRUE;
require_once '../lib/bootstrap.php';
Template::check_ajax_key();
$db = new Database();
$result = $row = $db->update_by_key('affiliates', 'id', $_SESSION['affiliate_id'], array('paypal' => $_GET['paypal'], 'wizard_complete' => TRUE));
unset($_SESSION['wizard_incomplete']);
echo json_encode($result ? true : false);

Example #5

File: json-setgeneral.php Project: JulioNavarro/Affiliates-For-All

<?php

/*
Copyright (c) 2008 Metathinking Ltd.
This file is part of Affiliates For All.
Affiliates For All is free software: you can redistribute it and/or
modify it under the terms of the GNU General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
Affiliates For All is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
General Public License for more details.
You should have received a copy of the GNU General Public License
along with Affiliates For All.  If not, see
<http://www.gnu.org/licenses/>.
*/
$wizard_not_required = TRUE;
require_once '../lib/bootstrap.php';
Template::check_ajax_key();
parse_str($_GET['details'], $details);
// Check the user isn't trying to change anything he isn't supposed to:
$junk = array_diff_key($details, array_fill_keys(array('title', 'first_name', 'last_name', 'email', 'email_update', 'address1', 'address2', 'address3', 'address4', 'postcode', 'country', 'phone'), true));
if (count($junk) == 0) {
    $db = new Database();
    $details['email_update'] = isset($details['email_update']);
    $result = $db->update_by_key('affiliates', 'id', $_SESSION['affiliate_id'], $details);
    echo json_encode($result ? true : false);
}