error in check out
<?php
//WA eCart Include
require_once("WA_eCart/OFP2015_PHP.php");
?>
<?php require_once('Connections/OFP_Final.php'); ?>
<?php
$OFP2015->GetContent();
?>
<?php
require_once("WA_eCart/Adv_CO_Scripts/AuthNet_PHP.php");
?>
<?php
//WA eCart Include
require_once("WA_eCart/WA_eCart_Database_PHP.php");
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_country"] = "".((isset($_POST["shipping_country"]))?$_POST["shipping_country"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_postcode"] = "".((isset($_POST["shipping_postcode"]))?$_POST["shipping_postcode"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_state_province"] = "".((isset($_POST["shipping_state_province"]))?$_POST["shipping_state_province"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_city"] = "".((isset($_POST["shipping_city"]))?$_POST["shipping_city"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_street2"] = "".((isset($_POST["shipping_street2"]))?$_POST["shipping_street2"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_street1"] = "".((isset($_POST["shipping_street1"]))?$_POST["shipping_street1"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_fax"] = "".((isset($_POST["shipping_fax"]))?$_POST["shipping_fax"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_phone"] = "".((isset($_POST["shipping_phone"]))?$_POST["shipping_phone"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_email"] = "".((isset($_POST["shipping_email"]))?$_POST["shipping_email"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_lastname"] = "".((isset($_POST["shipping_lastname"]))?$_POST["shipping_lastname"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_shipping_firstname"] = "".((isset($_POST["shipping_firstname"]))?$_POST["shipping_firstname"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_country"] = "".((isset($_POST["country"]))?$_POST["country"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_postcode"] = "".((isset($_POST["postcode"]))?$_POST["postcode"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_state_province"] = "".((isset($_POST["state_province"]))?$_POST["state_province"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_city"] = "".((isset($_POST["city"]))?$_POST["city"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_street2"] = "".((isset($_POST["street2"]))?$_POST["street2"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_street1"] = "".((isset($_POST["street1"]))?$_POST["street1"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_fax"] = "".((isset($_POST["fax"]))?$_POST["fax"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_phone"] = "".((isset($_POST["phone"]))?$_POST["phone"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_email"] = "".((isset($_POST["email"]))?$_POST["email"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_lastname"] = "".((isset($_POST["lastname"]))?$_POST["lastname"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_firstname"] = "".((isset($_POST["firstname"]))?$_POST["firstname"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_cvv"] = "".((isset($_POST["cvv"]))?$_POST["cvv"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_exp_year"] = "".((isset($_POST["exp_year"]))?$_POST["exp_year"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_exp_month"] = "".((isset($_POST["exp_month"]))?$_POST["exp_month"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_cc_number"] = "".((isset($_POST["cc_number"]))?$_POST["cc_number"]:"") ."";
}
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_cc_type"] = "".((isset($_POST["cc_type"]))?$_POST["cc_type"]:"") ."";
}
?>
<?php
if (($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST)) {
$AuthNet_required = array();
$AuthNet_required[0] = array();
$AuthNet_required[1] = array();
$AuthNet_itemized = array();
$AuthNet_itemized[0] = array();
$AuthNet_itemized[1] = array();
$AuthNet_optional = array();
$AuthNet_optional[0] = array();
$AuthNet_optional[1] = array();
$cartIndex = 0;
$nextIndex = 0;
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_login";
$AuthNet_required[1][$nextIndex] = "4CAy54e7ce5";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_tran_key";
$AuthNet_required[1][$nextIndex] = "296853rMgSAn6XjZ";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_version";
$AuthNet_required[1][$nextIndex] = "3.1";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_invoice_num";
$AuthNet_required[1][$nextIndex] = "".session_id() ."";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_test_request";
$AuthNet_required[1][$nextIndex] = "TRUE";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_method";
$AuthNet_required[1][$nextIndex] = "CC";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_type";
$AuthNet_required[1][$nextIndex] = "AUTH_CAPTURE";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_relay_response";
$AuthNet_required[1][$nextIndex] = "FALSE";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_delim_data";
$AuthNet_required[1][$nextIndex] = "TRUE";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_delim_char";
$AuthNet_required[1][$nextIndex] = "::";
$nextIndex = count($AuthNet_required[0]);
$AuthNet_required[0][$nextIndex] = "x_customer_ip";
$AuthNet_required[1][$nextIndex] = "".$_SERVER["REMOTE_ADDR"] ."";
$AuthNet_itemized[0][0] = "x_amount";
$AuthNet_itemized[1][0] = "".$OFP2015->GrandTotal() ."";
$AuthNet_itemized[0][1] = "x_description";
$AuthNet_itemized[1][1] = "".$OFP2015->TotalColumn("FullDetails") ."";
while ( !$OFP2015->EOF() ) {
$nextIndex = count($AuthNet_itemized[0]);
$AuthNet_itemized[0][$nextIndex] = "ID";
$AuthNet_itemized[1][$nextIndex] = "".$OFP2015->DisplayInfo("ID") ."";
$nextIndex = count($AuthNet_itemized[0]);
$AuthNet_itemized[0][$nextIndex] = "Name";
$AuthNet_itemized[1][$nextIndex] = "".$OFP2015->DisplayInfo("Name") ."";
$nextIndex = count($AuthNet_itemized[0]);
$AuthNet_itemized[0][$nextIndex] = "Description";
$AuthNet_itemized[1][$nextIndex] = "".$OFP2015->DisplayInfo("Description") ."";
$nextIndex = count($AuthNet_itemized[0]);
$AuthNet_itemized[0][$nextIndex] = "Quantity";
$AuthNet_itemized[1][$nextIndex] = "".$OFP2015->DisplayInfo("Quantity") ."";
$nextIndex = count($AuthNet_itemized[0]);
$AuthNet_itemized[0][$nextIndex] = "Price";
$AuthNet_itemized[1][$nextIndex] = "".$OFP2015->DisplayInfo("Price") ."";
$nextIndex = count($AuthNet_itemized[0]);
$AuthNet_itemized[0][$nextIndex] = "Taxable";
$AuthNet_itemized[1][$nextIndex] = "YES";
$OFP2015->MoveNext();
$cartIndex ++;
}
$OFP2015->MoveFirst();
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_card_num";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["cc_number"]))?$_POST["cc_number"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_exp_date";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["exp_month"]))?$_POST["exp_month"]:"") ."".((isset($_POST["exp_year"]))?$_POST["exp_year"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_card_code";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["cvv"]))?$_POST["cvv"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_email_customer";
$AuthNet_optional[1][$nextIndex] = "TRUE";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_tax_exempt";
$AuthNet_optional[1][$nextIndex] = "FALSE";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_first_name";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["firstname"]))?$_POST["firstname"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_last_name";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["lastname"]))?$_POST["lastname"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_address";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["street1"]))?$_POST["street1"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_city";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["city"]))?$_POST["city"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_state";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["state_province"]))?$_POST["state_province"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_zip";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["postcode"]))?$_POST["postcode"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_phone";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["phone"]))?$_POST["phone"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_fax";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["fax"]))?$_POST["fax"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_email";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["email"]))?$_POST["email"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_country";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["country"]))?$_POST["country"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_first_name";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_firstname"]))?$_POST["shipping_firstname"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_last_name";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_lastname"]))?$_POST["shipping_lastname"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_address";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_street1"]))?$_POST["shipping_street1"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_city";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_city"]))?$_POST["shipping_city"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_state";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_state_province"]))?$_POST["shipping_state_province"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_zip";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_postcode"]))?$_POST["shipping_postcode"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_country";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_country"]))?$_POST["shipping_country"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_phone";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_phone"]))?$_POST["shipping_phone"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_ship_to_fax";
$AuthNet_optional[1][$nextIndex] = "".((isset($_POST["shipping_fax"]))?$_POST["shipping_fax"]:"") ."";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_currency_code";
$AuthNet_optional[1][$nextIndex] = "USD";
$nextIndex = count($AuthNet_optional[0]);
$AuthNet_optional[0][$nextIndex] = "x_recurring_billing";
$AuthNet_optional[1][$nextIndex] = "NO";
$WAGatewayResponse = AuthNet_Post($AuthNet_required,$AuthNet_itemized,$AuthNet_optional);
if ($WAGatewayResponse) {
$OFP2015->redirStr = "checkout_success.php";
}
else if ("checkout_failure.php" != "") {
header("Location: ". "checkout_failure.php");
exit();
}
}
?>
<?php
// WA eCart Store Cart Summary in Db
if (($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST)) // Trigger
{
$WA_connection = $OFP_Final;
$WA_table = "orders";
$WA_redirectURL = "";
$WA_indexField = "OrderID";
$WA_fieldNamesStr = "OrderAmount|OrderShipName|OrderShipAddress|OrderShipAddress2|OrderCity|OrderState|OrderZip|OrderCountry|OrderPhone|OrderFax|OrderShipping|OrderTax|OrderEmail|OrderDate";
$WA_fieldValuesStr = WA_eCDB_ConvertNumber("".$OFP2015->GrandTotal() ."") . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_firstname'])?$_SESSION['eCartCheckoutForm_shipping_firstname']:$_SESSION['eCartCheckoutForm_firstname']) ." ".(isset($_SESSION['eCartCheckoutForm_shipping_lastname'])?$_SESSION['eCartCheckoutForm_shipping_lastname']:$_SESSION['eCartCheckoutForm_lastname']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_street1'])?$_SESSION['eCartCheckoutForm_shipping_street1']:$_SESSION['eCartCheckoutForm_street1']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_street2'])?$_SESSION['eCartCheckoutForm_shipping_street2']:$_SESSION['eCartCheckoutForm_street2']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_city'])?$_SESSION['eCartCheckoutForm_shipping_city']:$_SESSION['eCartCheckoutForm_city']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_state_province'])?$_SESSION['eCartCheckoutForm_shipping_state_province']:$_SESSION['eCartCheckoutForm_state_province']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_postcode'])?$_SESSION['eCartCheckoutForm_shipping_postcode']:$_SESSION['eCartCheckoutForm_postcode']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_country'])?$_SESSION['eCartCheckoutForm_shipping_country']:$_SESSION['eCartCheckoutForm_country']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_phone'])?$_SESSION['eCartCheckoutForm_shipping_phone']:$_SESSION['eCartCheckoutForm_phone']) ."" . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_fax'])?$_SESSION['eCartCheckoutForm_shipping_fax']:$_SESSION['eCartCheckoutForm_fax']) ."" . "|" . WA_eCDB_ConvertNumber("".$OFP2015->GetShipping() ."") . "|" . WA_eCDB_ConvertNumber("".$OFP2015->GetTax() ."") . "|" . "".(isset($_SESSION['eCartCheckoutForm_shipping_email'])?$_SESSION['eCartCheckoutForm_shipping_email']:$_SESSION['eCartCheckoutForm_email']) ."" . "|" . "".(date('Y-m-d h:i:s')) ."";
$WA_columnTypesStr = "none,none,NULL|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|none,none,NULL|',none,''|',none,''";
$WA_sessionName = "OFP2015_OrderID";
$WA_Sql = "";
$NeedInsert = false;
$indexFieldIndex = -1;
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
$WA_connectionDB = $database_OFP_Final;
$updateFieldValue = "";
mysql_select_db($WA_connectionDB, $WA_connection);
if (!session_id()) session_start();
if ($WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos('?', $WA_redirectURL) === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
for ($i = 0; $i < sizeof($WA_fieldNames); $i++)
{
if ($WA_indexField == $WA_fieldNames[$i])
{
$indexFieldIndex = $i;
break;
}
}
$deleteFieldValue = "";
$updateColType = "none,none,NULL";
if ($indexFieldIndex >= 0) $updateFieldValue = $WA_fieldValues[$indexFieldIndex];
if ($updateFieldValue == "" && isset($_SESSION[$WA_sessionName])) $updateFieldValue = $_SESSION[$WA_sessionName];
if ($indexFieldIndex >= 0) $updateColType = $WA_columns[$indexFieldIndex];
if ($updateFieldValue != "") {
$updateParamsObj = WA_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, $indexFieldIndex);
$valueForWhere = WA_generateInsertParams(array($WA_indexField), array($updateColType), array($updateFieldValue), -1);
$WA_Sql = "update " . $WA_table . " SET " . $updateParamsObj->WA_setValues . " where " . $WA_indexField . " = " . $valueForWhere->WA_dbValues;
$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$_SESSION[$WA_sessionName] = $updateFieldValue;
$result = mysql_query("SELECT * FROM " . $WA_table . " where " . $WA_indexField . " = " . $valueForWhere->WA_dbValues, $WA_connection);
$num_rows = mysql_num_rows($result);
$NeedInsert = (mysql_num_rows($result) === 0);
}
if ($updateFieldValue === "" || $NeedInsert) {
$updateFieldValue = "";
$insertParamsObj = WA_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_Sql = "insert into " . $WA_table . " (" . $insertParamsObj->WA_tableValues . ") values (" . $insertParamsObj->WA_dbValues . ")";
$WA_editCmd = mysql_query($WA_Sql, $WA_connection) or die(mysql_error());
$_SESSION[$WA_sessionName] = mysql_insert_id();
}
if ($WA_redirectURL != "") {
header("Location: ".$WA_redirectURL); exit;
}
}
?>
<?php
// WA eCart Store Cart Details in Db
if (($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST)) // Trigger
{
$WA_connection = $OFP_Final;
$WA_table = "orderdetails";
$WA_redirectURL = "";
$WA_indexField = "DetailOrderID";
$WA_fieldNamesStr = "DetailOrderID|DetailProductID|DetailName|DetailPrice|DetailQuantity";
$WA_fieldValuesStr = WA_eCDB_ConvertNumber("".((isset($_SESSION["OFP2015_OrderID"]))?$_SESSION["OFP2015_OrderID"]:"") ."") . "|" . WA_eCDB_ConvertNumber("".$OFP2015->DisplayInfo("ID") ."") . "|" . "".$OFP2015->DisplayInfo("Name") ."" . "|" . WA_eCDB_ConvertNumber("".$OFP2015->DisplayInfo("Price") ."") . "|" . WA_eCDB_ConvertNumber("".$OFP2015->DisplayInfo("Quantity") ."");
$WA_columnTypesStr = "none,none,NULL|none,none,NULL|',none,''|none,none,NULL|none,none,NULL";
$WA_sql = "";
mysql_select_db($database_OFP_Final, $WA_connection);
$indexFieldIndex = -1;
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
if (!session_id()) session_start();
if ($WA_redirectURL != "" && isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] !== "" && sizeof($_POST) > 0) {
$WA_redirectURL .= ((strpos('?', $WA_redirectURL) === false)?"?":"&").$_SERVER["QUERY_STRING"];
}
$WA_fieldNames = explode("|", $WA_fieldNamesStr);
$WA_columns = explode("|", $WA_columnTypesStr);
for ($i = 0; $i < sizeof($WA_fieldNames); $i++)
{
if ($WA_indexField == $WA_fieldNames[$i])
{
$indexFieldIndex = $i;
break;
}
}
$deleteFieldValue = $WA_fieldValues[$indexFieldIndex];
if (isset($deleteFieldValue) && $deleteFieldValue != "")
{
$deleteParamsObj = WA_generateInsertParams(array($WA_indexField), array($WA_columns[$indexFieldIndex]), array($deleteFieldValue), -1);
$WA_sql = "Delete from " . $WA_table . " where " . $WA_indexField . " = " . $deleteParamsObj->WA_dbValues;
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());
$WA_okToDelete = false;
}
$OFP2015->MoveFirst();
while (!$OFP2015->EOF())
{
$WA_fieldValuesStr = WA_eCDB_ConvertNumber("".((isset($_SESSION["OFP2015_OrderID"]))?$_SESSION["OFP2015_OrderID"]:"") ."") . "|" . WA_eCDB_ConvertNumber("".$OFP2015->DisplayInfo("ID") ."") . "|" . "".$OFP2015->DisplayInfo("Name") ."" . "|" . WA_eCDB_ConvertNumber("".$OFP2015->DisplayInfo("Price") ."") . "|" . WA_eCDB_ConvertNumber("".$OFP2015->DisplayInfo("Quantity") ."");
$WA_fieldValues = explode("|", $WA_fieldValuesStr);
$insertParamsObj = WA_generateInsertParams($WA_fieldNames, $WA_columns, $WA_fieldValues, -1);
$WA_sql = "insert into ".$WA_table." (".$insertParamsObj->WA_tableValues.") values (".$insertParamsObj->WA_dbValues.")";
$WA_editCmd = mysql_query($WA_sql, $WA_connection) or die(mysql_error());
$OFP2015->MoveNext();
}
if ($WA_redirectURL != "") {
header("Location: ".$WA_redirectURL); exit;
}
$OFP2015->MoveFirst();
}
?>
<?php
if ($OFP2015->IsEmpty()) {
$OFP2015->redirStr = "cart.php";
$OFP2015->cartAction = "RedirectIfEmpty";
}
?>
<?php
// WA eCart Redirect
if ($OFP2015->redirStr != "") {
header("Location: ".$OFP2015->redirStr);
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb"><!-- InstanceBegin template="/Templates/checkout.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Ohio Family Pack</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="imagetoolbar" content="false" />
<style type="text/css">
<!--
@import url("Temps/graphite/c/gm11.css");
#gordonmac-com #wrapper-a #wrapper-b #content #content-a #content-a-inner h2 {
font-size: x-large;
}
#apDiv1 {
position:absolute;
width:679px;
height:88px;
z-index:1;
left: 319px;
top: 476px;
}
#gordonmac-com #wrapper-a #wrapper-b #content #content-a #content-a-inner #quicknav {
font-size: xx-large;
color: #FF0000;
}
-->
</style>
<!--[if IE]>
<style type="text/css">
p.note-general, p.note-warning { color: #666666; }
</style>
<![endif]-->
<!--[if IE 6]>
<style type="text/css">
#footer { height: 1em; }
</style>
<![endif]-->
<!--[if IE 5.5]>
<style type="text/css">
pre { width: 453px; }
</style>
<![endif]-->
<!-- InstanceBeginEditable name="head" -->
<link href="WA_eCart/CSS/eC_Power_Pacifica_Arial.css" rel="stylesheet" type="text/css" />
<!--[if lte IE 6]>
<style type="text/css" media="all">
img, div, ul, li, span, a {
behavior: url("WA_eCart/CSS/Power/Images/iepngfix.htc");
}
</style>
<![endif]-->
<!-- InstanceEndEditable -->
</head>
<body id="gordonmac-com" class="homepage">
<div id="wrapper-a">
<div id="wrapper-b">
<div id="heading">
<h1><a href="index.php" title="Link to home page.">Gordonmac dot com</a></h1>
<h2><q>HTML templates and other silly things.</q></h2>
<p id="heading-intro">The Fun Start Here!</p>
<p id="heading-skipnav"><a href="#content">Skip site navigation and move to main content of page.</a></p>
<ul id="nav-a">
<li id="nav-a-about"><a href="index.php" title="Information about this site and it's author.">Home</a></li>
<li id="nav-a-downloads"><a href="index.php" title="Free downloadable files for your web projects.">Packs</a></li>
<li id="nav-a-contact"><a href="Policies.php" title="Information about getting in touch with me.">Contact</a></li>
</ul>
</div>
<div id="content">
<div id="content-a">
<div id="content-a-inner">
<h2 id="pageheader">Welcome</h2>
<h2>COLUMBUS FAMILY PACK IS HERE! <span>GET OUT OF</span></h2>
<h2><span> THE HOUSE AND GET INTO SOME FUN!!!</span> </h2>
<p> </p>
<div class="php" id="contactform"><!-- InstanceBeginEditable name="checkout" -->
<div class="eC_Power_Pacifica_Arial">
<?php
//WA eCart Show If Start
if (!$OFP2015->IsEmpty()) {
?>
<h2>Order Confirmation</h2>
<form action="<?php echo ($_SERVER["PHP_SELF"].(isset($_SERVER["QUERY_STRING"])?"?".htmlentities($_SERVER["QUERY_STRING"]):""));?>" method="post" >
<h2>Your Shopping Cart</h2>
<div class="eC_MediumArea">
<table class="eC_ShoppingCart" border="0" cellspacing="0" cellpadding="0">
<tr>
<th class="eC_GroupColumn" >Name</th>
<th class="eC_PriceItem">Price</th>
<th class="eC_PriceItem">Total</th>
</tr>
<?php
while (!$OFP2015->EOF()) {
?>
<tr>
<td class="eC_GroupColumn">
<p class="eC_ItemName"><?php echo $OFP2015->DisplayInfo("Name"); ?></p>
<p class="eC_ItemDescription">Description: <?php echo $OFP2015->DisplayInfo("Description"); ?></p>
</td>
<td class="eC_PriceItem">
<?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->DisplayInfo("Price")); ?>
</td>
<td class="eC_PriceItem">
<?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->DisplayInfo("TotalPrice")); ?>
</td>
</tr>
<?php
$OFP2015->MoveNext();
}
$OFP2015->MoveFirst();
?></table>
</div>
<div class="eC_OrderSummary">
<h2>Order Summary</h2>
<div class="eC_SmallArea">
<table border="0" cellpadding="0" cellspacing="0" class="eC_CartSummary">
<?php
//WA eCart Merchandizing Show Start
//ecart="OFP2015"
if ($OFP2015->GetDiscounts() > 0 || $OFP2015->GetCharges() > 0 || $OFP2015->GetShipping() > 0 || $OFP2015->GetTax() > 0) {
?>
<tr>
<td class="eC_Subtotal eC_SummaryLabel">Sub-total</td>
<td class="eC_Subtotal"><?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->TotalColumn("TotalPrice")); ?></td>
</tr>
<?php
//WA eCart Merchandizing Show End
//ecart="OFP2015"
}
?><?php
//WA eCart Merchandizing Show Start
//ecart="OFP2015"
if ($OFP2015->GetDiscounts() > 0) {
?>
<tr>
<td class="eC_SummaryLabel">Discounts</td>
<td>-<?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->GetDiscounts()); ?></td>
</tr>
<?php
//WA eCart Merchandizing Show End
//ecart="OFP2015"
}
?><?php
//WA eCart Merchandizing Show Start
//ecart="OFP2015"
if ($OFP2015->GetCharges() > 0) {
?>
<tr>
<td class="eC_SummaryLabel">Charges</td>
<td><?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->GetCharges()); ?></td>
</tr>
<?php
//WA eCart Merchandizing Show End
//ecart="OFP2015"
}
?><?php
//WA eCart Merchandizing Show Start
//ecart="OFP2015"
if ($OFP2015->GetShipping() > 0) {
?>
<tr>
<td class="eC_SummaryLabel">Shipping</td>
<td><?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->GetShipping()); ?></td>
</tr>
<?php
//WA eCart Merchandizing Show End
//ecart="OFP2015"
}
?><?php
//WA eCart Merchandizing Show Start
//ecart="OFP2015"
if ($OFP2015->GetTax() > 0) {
?>
<tr>
<td class="eC_SummaryLabel">Tax</td>
<td><?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->GetTax()); ?></td>
</tr>
<?php
//WA eCart Merchandizing Show End
//ecart="OFP2015"
}
?>
<tr class="eC_SummaryFooter">
<td class="eC_SummaryLabel">Grand Total:</td>
<td><?php echo WA_eCart_DisplayMoney($OFP2015, $OFP2015->GrandTotal()); ?></td>
</tr>
</table>
</div>
</div>
</form>
<?php
//WA eCart Show If Middle
}
else {
?><table><tr><td>The cart is empty</td></tr></table><?php
//WA eCart Show If End
}
?>
<div class="eC_PurchaserInfoWrapper">
<h3 class="eC_InfoHeader" >Payment Information</h3>
<div class="eC_MediumArea">
<div class="eC_InfoContainer" >
<p class="eC_OrderInfo"> <strong class="eC_OrderInfoLabel">Card number:</strong> xxxx xxxx xxxx <?php echo((strlen(((isset($_POST["cc_number"]))?$_POST["cc_number"]:""))<4)?((isset($_POST["cc_number"]))?$_POST["cc_number"]:""):substr(((isset($_POST["cc_number"]))?$_POST["cc_number"]:""),(strlen(((isset($_POST["cc_number"]))?$_POST["cc_number"]:""))-4),4)); ?><br />
<strong class="eC_OrderInfoLabel">Expiration date:</strong><?php echo((isset($_POST["exp_month"]))?$_POST["exp_month"]:"") ?>/<?php echo((isset($_POST["exp_year"]))?$_POST["exp_year"]:"") ?><br />
<strong class="eC_OrderInfoLabel">Security number:</strong> <?php echo((isset($_POST["cvv"]))?$_POST["cvv"]:"") ?></p>
</div>
</div>
<h3 class="eC_InfoHeader">Billing Information</h3>
<div class="eC_MediumArea">
<div class="eC_InfoContainer">
<p class="eC_OrderInfo"><?php echo((isset($_POST["firstname"]))?$_POST["firstname"]:"") ?> <?php echo((isset($_POST["lastname"]))?$_POST["lastname"]:"") ?><br />
<?php echo((isset($_POST["street1"]))?$_POST["street1"]:"") ?><br />
<?php echo((isset($_POST["city"]))?$_POST["city"]:"") ?>, <?php echo((isset($_POST["state_province"]))?$_POST["state_province"]:"") ?> <?php echo((isset($_POST["postcode"]))?$_POST["postcode"]:"") ?><br />
<?php echo((isset($_POST["country"]))?$_POST["country"]:"") ?></p>
</div>
</div>
<h3 class="eC_InfoHeader">Shipping Information</h3>
<div class="eC_MediumArea">
<div class="eC_InfoContainer">
<p class="eC_OrderInfo"><?php echo((isset($_POST["shipping_firstname"]))?$_POST["shipping_firstname"]:"") ?> <?php echo((isset($_POST["shipping_lastname"]))?$_POST["shipping_lastname"]:"") ?><br />
<?php echo((isset($_POST["shipping_street1"]))?$_POST["shipping_street1"]:"") ?><br />
<?php echo((isset($_POST["shipping_city"]))?$_POST["shipping_city"]:"") ?>, <?php echo((isset($_POST["shipping_state_province"]))?$_POST["shipping_state_province"]:"") ?> <?php echo((isset($_POST["shipping_postcode"]))?$_POST["shipping_postcode"]:"") ?><br />
<?php echo((isset($_POST["shipping_country"]))?$_POST["shipping_country"]:"") ?><br />
<?php echo((isset($_POST["shipping_phone"]))?$_POST["shipping_phone"]:"") ?>
</p>
</div>
</div>
</div>
<div class="eC_Power_Pacifica_Arial">
<div class="eC_CheckoutFormWrapper">
<form name="ecart_checkout_form" action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
<div class="eC_PurchaserInfoWrapper">
<div class="eC_CheckoutFormBody">
</div>
</div>
<table class="eC_ButtonWrapper" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><input type="hidden" name="cc_type" id="cc_type" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_cc_type"]))?$_SESSION["eCartCheckoutForm_cc_type"]:"") ?>" />
<input type="hidden" name="cc_number" id="cc_number" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_cc_number"]))?$_SESSION["eCartCheckoutForm_cc_number"]:"") ?>" />
<input type="hidden" name="exp_month" id="exp_month" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_exp_month"]))?$_SESSION["eCartCheckoutForm_exp_month"]:"") ?>" />
<input type="hidden" name="exp_year" id="exp_year" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_exp_year"]))?$_SESSION["eCartCheckoutForm_exp_year"]:"") ?>" />
<input type="hidden" name="cvv" id="cvv" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_cvv"]))?$_SESSION["eCartCheckoutForm_cvv"]:"") ?>" />
<input type="hidden" name="firstname" id="firstname" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_firstname"]))?$_SESSION["eCartCheckoutForm_firstname"]:"") ?>" />
<input type="hidden" name="lastname" id="lastname" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_lastname"]))?$_SESSION["eCartCheckoutForm_lastname"]:"") ?>" />
<input type="hidden" name="email" id="email" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_email"]))?$_SESSION["eCartCheckoutForm_email"]:"") ?>" />
<input type="hidden" name="phone" id="phone" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_phone"]))?$_SESSION["eCartCheckoutForm_phone"]:"") ?>" />
<input type="hidden" name="fax" id="fax" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_fax"]))?$_SESSION["eCartCheckoutForm_fax"]:"") ?>" />
<input type="hidden" name="street1" id="street1" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_street1"]))?$_SESSION["eCartCheckoutForm_street1"]:"") ?>" />
<input type="hidden" name="street2" id="street2" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_street2"]))?$_SESSION["eCartCheckoutForm_street2"]:"") ?>" />
<input type="hidden" name="city" id="city" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_city"]))?$_SESSION["eCartCheckoutForm_city"]:"") ?>" />
<input type="hidden" name="state_province" id="state_province" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_state_province"]))?$_SESSION["eCartCheckoutForm_state_province"]:"") ?>" />
<input type="hidden" name="postcode" id="postcode" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_postcode"]))?$_SESSION["eCartCheckoutForm_postcode"]:"") ?>" />
<input type="hidden" name="country" id="country" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_country"]))?$_SESSION["eCartCheckoutForm_country"]:"") ?>" />
<input type="hidden" name="shipping_firstname" id="shipping_firstname" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_firstname"]))?$_SESSION["eCartCheckoutForm_shipping_firstname"]:"") ?>" />
<input type="hidden" name="shipping_lastname" id="shipping_lastname" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_lastname"]))?$_SESSION["eCartCheckoutForm_shipping_lastname"]:"") ?>" />
<input type="hidden" name="shipping_email" id="shipping_email" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_email"]))?$_SESSION["eCartCheckoutForm_shipping_email"]:"") ?>" />
<input type="hidden" name="shipping_phone" id="shipping_phone" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_phone"]))?$_SESSION["eCartCheckoutForm_shipping_phone"]:"") ?>" />
<input type="hidden" name="shipping_fax" id="shipping_fax" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_fax"]))?$_SESSION["eCartCheckoutForm_shipping_fax"]:"") ?>" />
<input type="hidden" name="shipping_street1" id="shipping_street1" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_street1"]))?$_SESSION["eCartCheckoutForm_shipping_street1"]:"") ?>" />
<input type="hidden" name="shipping_street2" id="shipping_street2" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_street2"]))?$_SESSION["eCartCheckoutForm_shipping_street2"]:"") ?>" />
<input type="hidden" name="shipping_city" id="shipping_city" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_city"]))?$_SESSION["eCartCheckoutForm_shipping_city"]:"") ?>" />
<input type="hidden" name="shipping_state_province" id="shipping_state_province" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_state_province"]))?$_SESSION["eCartCheckoutForm_shipping_state_province"]:"") ?>" />
<input type="hidden" name="shipping_postcode" id="shipping_postcode" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_postcode"]))?$_SESSION["eCartCheckoutForm_shipping_postcode"]:"") ?>" />
<input type="hidden" name="shipping_country" id="shipping_country" value="<?php echo ((isset($_SESSION["eCartCheckoutForm_shipping_country"]))?$_SESSION["eCartCheckoutForm_shipping_country"]:"") ?>" />
<input type="image" alt="Modify information" value="Modify information" src="WA_eCart/Images/Pacifica/Btn2_EN_modifyinformation.gif" class="eC_ImageButton" onclick="history.back();return false;"/><input type="image" name="Submit_order" id="Submit_order" value="Checkout" alt="Submit order" src="WA_eCart/Images/Pacifica/Btn2_EN_submitorder.gif" class="eC_ImageButton" />
</td>
</tr>
</table>
</form>
</div>
</div>
<p class="eC_SmallPrint">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>
</div>
<!-- InstanceEndEditable --></div>
<p> </p>
<p> </p>
</div>
</div>
<div id="content-c">
<div id="content-c-inner">
<ul id="nav-b">
<li id="totop"><a href="#gordonmac-com" title="Jump back to the top of the document.">Top</a></li>
<li id="tonavigation"><a href="#nav-a" title="Jump back to the main site navigation.">Navigation</a></li>
<li id="accessibility"></li>
<li id="colophon"></li>
</ul>
</div>
</div>
<div id="footer">
<p id="copyright">© 2015 Ohio Family Pack. All rights reserved.</p>
<p> </p>
</div>
</div>
</div>
</div>
</body>
<!-- InstanceEnd --></html>