get_var("SHOW TABLES LIKE '".$wpdb->prefix."usermeta'")) { if(is_numeric($user_ID) && ($user_ID > 0)) { $saved_data_sql = "SELECT * FROM `".$wpdb->prefix."usermeta` WHERE `user_id` = '".$user_ID."' AND `meta_key` = 'wpshpcrt_usr_profile';"; $saved_data = $wpdb->get_row($saved_data_sql,ARRAY_A); $meta_data = unserialize($saved_data['meta_value']); } } if(!isset($_SESSION['collected_data']) || ($_SESSION['collected_data'] == null)) { $_SESSION['collected_data'] = $meta_data; } else { foreach($_SESSION['collected_data'] as $form_key => $session_form_data) { if($session_form_data == null) { $_SESSION['collected_data'][$form_key] = $meta_data[$form_key]; } } } $checkout = $_SESSION['checkoutdata']; if(get_option('permalink_structure') != '') { $seperator ="?"; } else { $seperator ="&"; } $currenturl = get_option('checkout_url') . $seperator .'total='.$_GET['total']; if(get_option('permalink_structure') == '') { $currenturl = str_replace(trailingslashit(get_option('siteurl')).'?',trailingslashit(get_option('siteurl')) . 'index.php?', $currenturl); } if(!isset($_GET['result'])){ // if(!(get_option('payment_gateway')=='google')) { ?>

".TXT_WPSC_LOG_IN.""; echo "
"; ?>

".TXT_WPSC_REGISTER.""; echo "
"; } echo "

"; echo TXT_WPSC_ASTERISK; if($_SESSION['nzshpcrt_checkouterr'] != null) { echo "
".$_SESSION['nzshpcrt_checkouterr'].""; $_SESSION['nzshpcrt_checkouterr'] = ''; } ?>
prefix."collect_data_forms` WHERE `active` = '1' ORDER BY `order`;"; $form_data = $wpdb->get_results($form_sql,ARRAY_A); //exit("
".print_r($form_data,true)."
"); foreach($form_data as $form_field) { if($form_field['type'] == 'heading') { echo "\n\r"; echo " \n\r"; echo "\n\r"; } else { echo "\n\r"; echo " \n\r"; echo " \n\r"; echo "\n\r"; } } $cart = $_SESSION['nzshpcrt_cart']; foreach($cart as $key => $product) { $product_data = $wpdb->get_row("SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id` = '{$product->product_id}' LIMIT 1",ARRAY_A); $can_have_uploaded_image = get_product_meta($product->product_id,'can_have_uploaded_image',true); if ($can_have_uploaded_image[0]=='on'){ echo "\n\r"; echo " \n\r"; echo "\n\r"; } } $gateway_options = get_option('custom_gateway_options'); $google_decrement = 0; if(array_search("google",(array)$gateway_options) !== false) { $google_decrement = 1; } if ((count($gateway_options) - $google_decrement) > 1) { echo "\n\r"; echo " \n\r"; echo "\n\r"; echo "\n\r"; echo " \n\r"; echo ""; } else { foreach ((array)get_option('custom_gateway_options') as $option) { foreach ($GLOBALS['nzshpcrt_gateways'] as $gateway){ if ($gateway['internalname'] == $option) { echo ""; } } } } //echo "
Test Code
".print_r($gateway_checkout_form_field, true)."
"; if(isset($gateway_checkout_form_field)) { echo $gateway_checkout_form_field; } $product=$_SESSION['nzshpcrt_cart'][0]; $engrave = get_product_meta($product->product_id,'engraved',true); if ($engrave[0] == true) { echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; echo " \n\r"; } if (get_option('display_find_us') == '1') { echo ""; } $termsandconds = get_option('terms_and_conditions'); if($termsandconds != '') { ?> "; echo ""; } ?>
\n\r"; echo " ".$form_field['name']."\n\r"; echo "
\n\r"; echo $form_field['name']; if($form_field['mandatory'] == 1) { if(!(($form_field['type'] == 'country') || ($form_field['type'] == 'delivery_country'))) { echo "*"; } } echo " \n\r"; switch($form_field['type']) { case "city": if (function_exists('getdistance')) { echo ""; } else { echo ""; } break; case "text": case "city": case "delivery_city": case "coupon": echo ""; break; case "address": if (function_exists('getdistance')) { echo ""; } else { echo ""; } break; case "address": case "delivery_address": case "textarea": echo ""; break; /* case "region": case "delivery_region": echo ""; break; */ case "country": echo wpsc_country_region_list($form_field['id'] , false, $_SESSION['selected_country'], $_SESSION['selected_region']); break; case "delivery_country": $country_name = $wpdb->get_var("SELECT `country` FROM `".$wpdb->prefix."currency_list` WHERE `isocode`='".$_SESSION['delivery_country']."' LIMIT 1"); echo "".$country_name." "; break; case "email": echo ""; break; default: echo ""; break; } echo "
\n\r"; echo "

".TXT_WPSC_UPLOAD_IMAGE_FOR." ".$product_data['name']."

\n\r"; echo " \n\r";// echo "
\n\r"; echo " ".TXT_WPSC_SELECTGATEWAY."\n\r"; echo "
\n\r"; foreach ($gateway_options as $option) { if($option == 'google') { //skip google continue; } if($count == 0) { $checked = "checked='true'"; $gateway_form_css = ""; } else { $checked = " "; $gateway_form_css = "style='display: none;'"; } foreach ($GLOBALS['nzshpcrt_gateways'] as $gateway){ if ($gateway['internalname'] == $option) { echo "
\n\r"; echo " \n\r"; if(isset($gateway_checkout_form_fields[$gateway['internalname']])) { echo " \n\r"; echo $gateway_checkout_form_fields[$gateway['internalname']]; echo "
\n\r"; } echo "
\n\r"; } } $count++; } echo "
\n\r"; echo " Engrave text:\n\r"; echo " \n\r"; echo " \n\r"; echo "
\n\r"; echo " \n\r"; echo " \n\r"; echo "
 
How did you find us:
' class='termsandconds'>