PHP WP_eStore_Db_Access::insert Examples

Example #1

File: eStore_post_payment_processing_helper.php Project: scttrgd/scottish-piping

function eStore_register_link_in_db($creation_time = '', $download_key = '', $download_item = '', $download_limit_count, $download_limit_time, $download_limit_ip = '', $access_count = 0, $txn_id = '')
{
    if (empty($creation_time)) {
        $creation_time = date("Y-m-d H:i:s");
        //current_time('mysql');
    }
    if (empty($download_key)) {
        //Download key cannot be empty
        return false;
    }
    if (empty($download_limit_count)) {
        $download_limit_count = get_option('eStore_download_url_limit_count');
        if (empty($download_limit_count)) {
            $download_limit_count = 999;
        }
    }
    if (empty($download_limit_time)) {
        $download_limit_time = get_option('eStore_download_url_life');
    }
    if (empty($download_limit_ip)) {
        $download_limit_ip = $_SERVER['REMOTE_ADDR'];
    }
    //Add to the download link to the database
    global $wpdb;
    $download_key = rawurldecode($download_key);
    //str_replace('%2B','+', $download_key );
    $fields = array();
    $fields['creation_time'] = $creation_time;
    $fields['download_key'] = $download_key;
    $fields['download_item'] = esc_sql($download_item);
    $fields['download_limit_count'] = $download_limit_count;
    $fields['download_limit_time'] = $download_limit_time;
    $fields['download_limit_ip'] = $download_limit_ip;
    $fields['access_count'] = $access_count;
    $fields['txn_id'] = $txn_id;
    $updated = WP_eStore_Db_Access::insert(WP_ESTORE_DOWNLOAD_LINKS_TABLE_NAME, $fields);
    return true;
}

Example #2

File: eStore_handle_subsc_ipn.php Project: scttrgd/scottish-piping

function eStore_save_membership_signup_rego_url($email, $rego_url, $ipn_data)
{
    debug_log_subsc("Saving membership signup rego URL data for: " . $email, true);
    $fields = array();
    $fields['date_time'] = date("Y-m-d H:i:s");
    //current_time('mysql');
    $fields['meta_key1'] = "member_email";
    //Email address key
    $fields['meta_value1'] = $email;
    //Email address value
    $fields['meta_key2'] = "txn_id";
    //Txn ID key
    $fields['meta_value2'] = $ipn_data['txn_id'];
    //Txn ID value
    $fields['meta_key3'] = "rego_url";
    //Rego url key
    $fields['meta_value3'] = $rego_url;
    //Rego url value
    //Save ip address too maybe
    $updated = WP_eStore_Db_Access::insert(WP_ESTORE_GLOBAL_META_TABLE_NAME, $fields);
    debug_log_subsc("Membership signup rego URL data saved.", true);
}