$property_value_id = $value_data["value_id"];
$property_value = $value_data["value"];
if ($property_full_desc) {
$property_full_desc .= "; ";
}
$property_full_desc .= $property_value;
$op->set_value("property_id", $property_id);
$op->set_value("property_order", $property_order);
$op->set_value("property_type", 4);
$op->set_value("property_name", $property_name);
$op->set_value("property_value_id", $property_value_id);
$op->set_value("property_value", $property_value);
$op->set_value("property_price", 0);
$op->set_value("property_weight", 0);
$op->set_value("tax_free", 0);
$op->insert_record();
}
$t->set_var("field_name_" . $property_id, $property_name);
$t->set_var("field_value_" . $property_id, $property_full_desc);
$t->set_var("field_" . $property_id, $property_full_desc);
}
$admin_notification = get_setting_value($cc_info, "admin_notification", 0);
$admin_sms = get_setting_value($cc_info, "admin_sms_notification", 0);
if ($admin_notification || $admin_sms) {
$admin_mail_type = get_setting_value($cc_info, "admin_message_type");
$admin_message = get_setting_value($cc_info, "admin_message", "");
$admin_sms_message = get_setting_value($cc_info, "admin_sms_message", "");
$items_text = "";
// parse basket template
if ($admin_notification && $admin_mail_type && strpos($admin_message, "{basket}") !== false) {
$t->set_file("basket", "email_basket.html");
$r->set_value("last_visit_ip", $user_ip);
$r->set_value("last_visit_page", get_custom_friendly_url("user_profile.php"));
if ($is_subscription) {
$expiry_date = va_time();
// set expiry_date and suspend_date as yesterday
$expiry_date_ts = mktime(0, 0, 0, $expiry_date[MONTH], $expiry_date[DAY] - 1, $expiry_date[YEAR]);
$r->set_value("expiry_date", $expiry_date_ts);
$r->set_value("suspend_date", $expiry_date_ts);
}
$password_encrypt = get_setting_value($settings, "password_encrypt", 0);
$plain_password = $r->get_value("password");
set_session("session_plain_password", $plain_password);
if ($password_encrypt == 1) {
$r->set_value("password", md5($plain_password));
}
if ($r->insert_record()) {
if ($db_type == "mysql") {
$user_id = get_db_value(" SELECT LAST_INSERT_ID() ");
$r->set_value("user_id", $user_id);
} elseif ($db_type == "access") {
$user_id = get_db_value(" SELECT @@IDENTITY ");
$r->set_value("user_id", $user_id);
} elseif ($db_type == "db2") {
$user_id = get_db_value(" SELECT PREVVAL FOR seq_" . $table_prefix . "users FROM " . $table_prefix . "users");
$r->set_value("user_id", $user_id);
}
update_user_properties();
$new_user_id = $user_id;
set_session("session_new_user_id", $user_id);
set_session("session_new_user_type_id", $type_id);
}
$fld->add_textbox("field_order", INTEGER);
$fld->add_textbox("field_title", TEXT);
$fld->add_textbox("field_source", TEXT);
$field_order = 0;
$total_columns = get_param("total_columns");
for ($col = 1; $col <= $total_columns; $col++) {
$field_title = get_param("column_title_" . $col);
$field_source = get_param("field_source_" . $col);
$column_checked = get_param("db_column_" . $col);
if ($column_checked) {
// if there is column title we can save this field even if it source empty
$field_order++;
$fld->set_value("field_order", $field_order);
$fld->set_value("field_title", $field_title);
$fld->set_value("field_source", $field_source);
$fld->insert_record();
}
}
}
$template_success = EXPORT_TEMPLATE_SAVED_MSG;
}
} else {
if ($operation == "export") {
if (!strlen($errors)) {
// prepare categories for items table
$categories = array();
if ($table == "items") {
$sql = "SELECT category_id,category_name FROM " . $table_prefix . "categories ";
$db->query($sql);
while ($db->next_record()) {
$category_id = $db->f("category_id");
}
if ($generate_serial) {
for ($sn = $quantity; $sn > 0; $sn--) {
$serial_number = generate_serial($order_item_id, $sn, $cart_item, $generate_serial);
if ($serial_number) {
$ois->set_value("order_item_id", $order_item_id);
$ois->set_value("item_id", $item_id);
$ois->set_value("serial_number", $serial_number);
$ois->set_value("activated", 0);
$ois->set_value("activations_number", $activations_number);
$ois->set_value("serial_added", va_time());
if (strlen($serial_period)) {
$serial_expiry = va_timestamp() + intval($serial_period) * 86400;
$ois->set_value("serial_expiry", va_time($serial_expiry));
}
$ois->insert_record();
}
}
}
if ($is_gift_voucher) {
for ($gf = $quantity; $gf > 0; $gf--) {
$gift_voucher = generate_gift_voucher($order_id, $order_item_id, $item_name, $price_incl_tax);
}
}
// add properties
if (is_array($properties_info) && sizeof($properties_info) > 0) {
$oip->set_value("order_item_id", $order_item_id);
for ($pi = 0; $pi < sizeof($properties_info); $pi++) {
list($property_id, $control_type, $property_name, $property_value, $pr_add_price, $pr_add_weight, $pr_values, $property_order) = $properties_info[$pi];
if ($control_type == "TEXTBOXLIST") {
// for text boxes list save all data in property value
