$r->set_value("is_confirmed", 1);
$r->change_property("is_confirmed", USE_IN_UPDATE, true);
}
$r->set_value("authorization_code", $variables["authorization_code"]);
// set AVS data
$r->set_value("avs_response_code", $variables["avs_response_code"]);
$r->set_value("avs_message", $variables["avs_message"]);
$r->set_value("avs_address_match", $variables["avs_address_match"]);
$r->set_value("avs_zip_match", $variables["avs_zip_match"]);
$r->set_value("cvv2_match", $variables["cvv2_match"]);
// set 3D data
$r->set_value("secure_3d_check", $variables["secure_3d_check"]);
$r->set_value("secure_3d_status", $variables["secure_3d_status"]);
$r->set_value("secure_3d_md", $variables["secure_3d_md"]);
$r->set_value("secure_3d_xid", $variables["secure_3d_xid"]);
$r->update_record();
if ($update_order_status) {
if (strlen($error_message)) {
$order_status = $failure_status_id;
} elseif (strlen($pending_message)) {
$order_status = $pending_status_id;
} else {
$order_status = $success_status_id;
}
// update order status for payment
update_order_status($order_id, $order_status, true, "", $status_error);
}
$secure_3d_acsurl = get_setting_value($variables, "secure_3d_acsurl", "");
if ($secure_3d_acsurl) {
$secure_3d_pareq = get_setting_value($variables, "secure_3d_pareq", "");
$secure_3d_md = get_setting_value($variables, "secure_3d_md", "");
} else {
$cc_number_last = $cc_number;
}
set_session("session_cc_number_first", $cc_number_first);
set_session("session_cc_number_last", $cc_number_last);
if ($cc_number_security == 0) {
$r->set_value("cc_number", "");
} elseif ($cc_number_security > 0) {
$r->set_value("cc_number", va_encrypt($r->get_value("cc_number")));
}
if ($cc_code_security == 0) {
$r->set_value("cc_security_code", "");
} elseif ($cc_code_security > 0) {
$r->set_value("cc_security_code", va_encrypt($cc_security_code));
}
if ($r->update_record()) {
// update order status
$cc_order_status = 2;
update_order_status($order_id, $cc_order_status, true, "", $status_error);
$op = new VA_Record($table_prefix . "orders_properties");
$op->add_textbox("order_id", INTEGER);
$op->set_value("order_id", $order_id);
$op->add_textbox("property_id", INTEGER);
$op->add_textbox("property_order", INTEGER);
$op->add_textbox("property_type", INTEGER);
$op->add_textbox("property_name", TEXT);
$op->add_textbox("property_value_id", INTEGER);
$op->add_textbox("property_value", TEXT);
$op->add_textbox("property_price", FLOAT);
$op->add_textbox("property_weight", FLOAT);
$op->add_textbox("tax_free", INTEGER);
$is_placed = $db->f("is_placed");
$paid_status = $db->f("paid_status");
$transaction_id = $db->f("transaction_id");
if ($is_placed || $paid_status || strlen($transaction_id)) {
$user_order_id = "";
}
} else {
$user_order_id = "";
}
}
if ($user_order_id) {
$order_id = $user_order_id;
$variables["order_id"] = $user_order_id;
$r->set_value("order_id", $user_order_id);
remove_orders($user_order_id, false);
$order_added = $r->update_record();
} else {
if ($db_type == "postgre") {
$order_id = get_db_value(" SELECT NEXTVAL('seq_" . $table_prefix . "orders') ");
$variables["order_id"] = $order_id;
$r->change_property("order_id", USE_IN_INSERT, true);
$r->set_value("order_id", $order_id);
}
$order_added = $r->insert_record();
}
if ($order_added) {
if (!$user_order_id) {
if ($db_type == "mysql") {
$order_id = get_db_value(" SELECT LAST_INSERT_ID() ");
$r->set_value("order_id", $order_id);
$variables["order_id"] = $order_id;
