Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

after adding cvv2 contrib, admin panel access fail


Recommended Posts

Hi,

 

I added contribution http://www.oscommerce.com/community/contributions,3113 . Followed all the instructions. Trying to access teh admin area of osC and I get

 

Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/mysite/public_html/admin/includes/functions/database.php:11) in /home/mysite/public_html/admin/includes/functions/database.php on line 11

 

Has someone experianced this problem and knows how to correct it? Thanks in advance.

 

Jim

Link to comment
Share on other sites

im guessing you have included a file twice somewhere along the lines.

 

is that the full error you are getting?

 

otherwise post the first few lines of orders.php

Link to comment
Share on other sites

im guessing you have included a file twice somewhere along the lines.

 

is that the full error you are getting?

 

otherwise post the first few lines of orders.php

 

Hi

 

From includes/classes/order.php the sections I changed according to the contribution instrucitons:

 

$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_cvv2, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($order_id) . "'");

 

and

 

$this->info = array('currency' => $order['currency'],
? ? ? ? ? ? ? ? ? ? ? ? ?'currency_value' => $order['currency_value'],
? ? ? ? ? ? ? ? ? ? ? ? ?'payment_method' => $order['payment_method'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_type' => $order['cc_type'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_owner' => $order['cc_owner'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_number' => $order['cc_number'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_cvv2' => $order['cc_cvv2'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_expires' => $order['cc_expires'],
? ? ? ? ? ? ? ? ? ? ? ? ?'comments' => $order['comments'],
? ? ? ? ? ? ? ? ? ? ? ? ?'date_purchased' => $order['date_purchased'],
? ? ? ? ? ? ? ? ? ? ? ? ?'orders_status' => $order_status['orders_status_name'],
? ? ? ? ? ? ? ? ? ? ? ? ?'last_modified' => $order['last_modified'],
? ? ? ? ? ? ? ? ? ? ? ? ?'total' => strip_tags($order_total['text']),
? ? ? ? ? ? ? ? ? ? ? ? ?'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title'])));

 

 

While answering this post I see there are three things to change in the orders.php, this being the third:

 

AFTER:

'cc_number' => (isset($GLOBALS['cc_number']) ? $GLOBALS['cc_number'] : ''),

ADD:

'cc_cvv2' => (isset($GLOBALS['cc_cvv2']) ? $GLOBALS['cc_cvv2'] : ''),

 

I could not find 'cc_number' => (isset($GLOBALS['cc_number']) ? $GLOBALS['cc_number'] : ''), in my orders.php file. So I did this instead

 

$this->info = array('order_status' => DEFAULT_ORDERS_STATUS_ID,
? ? ? ? ? ? ? ? ? ? ? ? ?'currency' => $currency,
? ? ? ? ? ? ? ? ? ? ? ? ?'currency_value' => $currencies->currencies[$currency]['value'],
? ? ? ? ? ? ? ? ? ? ? ? ?'payment_method' => $payment,
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_type' => $GLOBALS['cc_type'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_owner' => $GLOBALS['cc_owner'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_number' => $GLOBALS['cc_number'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_cvv2' => $GLOBALS['cc_cvv2'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_expires' => $GLOBALS['cc_expires'],
? ? ? ? ? ? ? ? ? ? ? ? ?'shipping_method' => $shipping['title'],
? ? ? ? ? ? ? ? ? ? ? ? ?'shipping_cost' => $shipping['cost'],
? ? ? ? ? ? ? ? ? ? ? ? ?'comments' => $GLOBALS['comments']);

 

 

This could veery well be where I've gone wrong. Appreciate if someone could point out the correction. Below I'll post the complete orders.php file I currently have on the server:

 

<?php
/*
?Copyright (c) 2002 osCommerce
?
?Modified for use by YourShopCart.com sections Copyright (c) 2002 - 2003
?YourShopCart Version 1.0

?Released under the GNU General Public License
*/

?class order {
? ?var $info, $totals, $products, $customer, $delivery, $content_type;

? ?function order($order_id = '') {
? ? ?$this->info = array();
? ? ?$this->totals = array();
? ? ?$this->products = array();
? ? ?$this->customer = array();
? ? ?$this->delivery = array();

? ? ?if (tep_not_null($order_id)) {
? ? ? ?$this->query($order_id);
? ? ?} else {
? ? ? ?$this->cart();
? ? ?}
? ?}

? ?function query($order_id) {
? ? ?global $languages_id;

? ? ?$order_id = tep_db_prepare_input($order_id);

? ? ?$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_cvv2, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($order_id) . "'");
? ? ?$order = tep_db_fetch_array($order_query);

? ? ?$totals_query = tep_db_query("select title, text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . tep_db_input($order_id) . "' order by sort_order");
? ? ?while ($totals = tep_db_fetch_array($totals_query)) {
? ? ? ?$this->totals[] = array('title' => $totals['title'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'text' => $totals['text']);
? ? ?}

? ? ?$order_total_query = tep_db_query("select text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . $order_id . "' and class = 'ot_total'");
? ? ?$order_total = tep_db_fetch_array($order_total_query);

? ? ?$shipping_method_query = tep_db_query("select title from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . $order_id . "' and class = 'ot_shipping'");
? ? ?$shipping_method = tep_db_fetch_array($shipping_method_query);

? ? ?$order_status_query = tep_db_query("select orders_status_name from " . TABLE_ORDERS_STATUS . " where orders_status_id = '" . $order['orders_status'] . "' and language_id = '" . $languages_id . "'");
? ? ?$order_status = tep_db_fetch_array($order_status_query);

? ? ?$this->info = array('currency' => $order['currency'],
? ? ? ? ? ? ? ? ? ? ? ? ?'currency_value' => $order['currency_value'],
? ? ? ? ? ? ? ? ? ? ? ? ?'payment_method' => $order['payment_method'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_type' => $order['cc_type'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_owner' => $order['cc_owner'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_number' => $order['cc_number'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_cvv2' => $order['cc_cvv2'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_expires' => $order['cc_expires'],
? ? ? ? ? ? ? ? ? ? ? ? ?'comments' => $order['comments'],
? ? ? ? ? ? ? ? ? ? ? ? ?'date_purchased' => $order['date_purchased'],
? ? ? ? ? ? ? ? ? ? ? ? ?'orders_status' => $order_status['orders_status_name'],
? ? ? ? ? ? ? ? ? ? ? ? ?'last_modified' => $order['last_modified'],
? ? ? ? ? ? ? ? ? ? ? ? ?'total' => strip_tags($order_total['text']),
? ? ? ? ? ? ? ? ? ? ? ? ?'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title'])));

? ? ?$this->customer = array('name' => $order['customers_name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'company' => $order['customers_company'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'street_address' => $order['customers_street_address'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'suburb' => $order['customers_suburb'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'city' => $order['customers_city'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'postcode' => $order['customers_postcode'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'state' => $order['customers_state'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'country' => $order['customers_country'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'format_id' => $order['customers_address_format_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'telephone' => $order['customers_telephone'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'email_address' => $order['customers_email_address']);

? ? ?$this->delivery = array('name' => $order['delivery_name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'company' => $order['delivery_company'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'street_address' => $order['delivery_street_address'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'suburb' => $order['delivery_suburb'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'city' => $order['delivery_city'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'postcode' => $order['delivery_postcode'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'state' => $order['delivery_state'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'country' => $order['delivery_country'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'format_id' => $order['delivery_address_format_id']);

? ? ?if (empty($this->delivery['name']) && empty($this->delivery['street_address'])) {
? ? ? ?$this->delivery = false;
? ? ?}

? ? ?$this->billing = array('name' => $order['billing_name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'company' => $order['billing_company'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'street_address' => $order['billing_street_address'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'suburb' => $order['billing_suburb'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'city' => $order['billing_city'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'postcode' => $order['billing_postcode'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'state' => $order['billing_state'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'country' => $order['billing_country'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'format_id' => $order['billing_address_format_id']);

? ? ?$index = 0;
? ? ?$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . tep_db_input($order_id) . "'");
? ? ?while ($orders_products = tep_db_fetch_array($orders_products_query)) {
? ? ? ?$this->products[$index] = array('qty' => $orders_products['products_quantity'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'name' => $orders_products['products_name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'model' => $orders_products['products_model'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'tax' => $orders_products['products_tax'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'price' => $orders_products['products_price'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'final_price' => $orders_products['final_price']);

? ? ? ?$subindex = 0;
? ? ? ?$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . tep_db_input($order_id) . "' and orders_products_id = '" . $orders_products['orders_products_id'] . "'");
? ? ? ?if (tep_db_num_rows($attributes_query)) {
? ? ? ? ?while ($attributes = tep_db_fetch_array($attributes_query)) {
? ? ? ? ? ?$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'value' => $attributes['products_options_values'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'prefix' => $attributes['price_prefix'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'price' => $attributes['options_values_price']);

? ? ? ? ? ?$subindex++;
? ? ? ? ?}
? ? ? ?}

? ? ? ?$this->info['tax_groups']["{$this->products[$index]['tax']}"] = '1';

? ? ? ?$index++;
? ? ?}
? ?}

? ?function cart() {
? ? ?global $customer_id, $sendto, $billto, $cart, $languages_id, $currency, $currencies, $shipping, $payment;

? ? ?$this->content_type = $cart->get_content_type();

? ? ?$customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " co on (ab.entry_country_id = co.countries_id) where c.customers_id = '" . $customer_id . "' and ab.customers_id = '" . $customer_id . "' and c.customers_default_address_id = ab.address_book_id");
? ? ?$customer_address = tep_db_fetch_array($customer_address_query);

? ? ?$shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '" . $customer_id . "' and ab.address_book_id = '" . $sendto . "'");
? ? ?$shipping_address = tep_db_fetch_array($shipping_address_query);
? ? ?
? ? ?$billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '" . $customer_id . "' and ab.address_book_id = '" . $billto . "'");
? ? ?$billing_address = tep_db_fetch_array($billing_address_query);

? ? ?$this->info = array('order_status' => DEFAULT_ORDERS_STATUS_ID,
? ? ? ? ? ? ? ? ? ? ? ? ?'currency' => $currency,
? ? ? ? ? ? ? ? ? ? ? ? ?'currency_value' => $currencies->currencies[$currency]['value'],
? ? ? ? ? ? ? ? ? ? ? ? ?'payment_method' => $payment,
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_type' => $GLOBALS['cc_type'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_owner' => $GLOBALS['cc_owner'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_number' => $GLOBALS['cc_number'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_cvv2' => $GLOBALS['cc_cvv2'],
? ? ? ? ? ? ? ? ? ? ? ? ?'cc_expires' => $GLOBALS['cc_expires'],
? ? ? ? ? ? ? ? ? ? ? ? ?'shipping_method' => $shipping['title'],
? ? ? ? ? ? ? ? ? ? ? ? ?'shipping_cost' => $shipping['cost'],
? ? ? ? ? ? ? ? ? ? ? ? ?'comments' => $GLOBALS['comments']);

? ? ?if (is_object($GLOBALS[$payment])) {
? ? ? ?$this->info['payment_method'] = $GLOBALS[$payment]->title;

? ? ? ?if ( isset($GLOBALS[$payment]->order_status) && is_numeric($GLOBALS[$payment]->order_status) && ($GLOBALS[$payment]->order_status > 0) ) {
? ? ? ? ?$this->info['order_status'] = $GLOBALS[$payment]->order_status;
? ? ? ?}
? ? ?}

? ? ?$this->customer = array('firstname' => $customer_address['customers_firstname'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'lastname' => $customer_address['customers_lastname'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'company' => $customer_address['entry_company'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'street_address' => $customer_address['entry_street_address'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'suburb' => $customer_address['entry_suburb'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'city' => $customer_address['entry_city'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'postcode' => $customer_address['entry_postcode'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'state' => ((tep_not_null($customer_address['entry_state'])) ? $customer_address['entry_state'] : $customer_address['zone_name']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'zone_id' => $customer_address['entry_zone_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'country' => array('id' => $customer_address['countries_id'], 'title' => $customer_address['countries_name'], 'iso_code_2' => $customer_address['countries_iso_code_2'], 'iso_code_3' => $customer_address['countries_iso_code_3']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'format_id' => $customer_address['address_format_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'telephone' => $customer_address['customers_telephone'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'email_address' => $customer_address['customers_email_address']);

? ? ?$this->delivery = array('firstname' => $shipping_address['entry_firstname'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'lastname' => $shipping_address['entry_lastname'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'company' => $shipping_address['entry_company'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'street_address' => $shipping_address['entry_street_address'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'suburb' => $shipping_address['entry_suburb'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'city' => $shipping_address['entry_city'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'postcode' => $shipping_address['entry_postcode'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'state' => ((tep_not_null($shipping_address['entry_state'])) ? $shipping_address['entry_state'] : $shipping_address['zone_name']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'zone_id' => $shipping_address['entry_zone_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'country' => array('id' => $shipping_address['countries_id'], 'title' => $shipping_address['countries_name'], 'iso_code_2' => $shipping_address['countries_iso_code_2'], 'iso_code_3' => $shipping_address['countries_iso_code_3']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'country_id' => $shipping_address['entry_country_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'format_id' => $shipping_address['address_format_id']);

? ? ?$this->billing = array('firstname' => $billing_address['entry_firstname'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'lastname' => $billing_address['entry_lastname'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'company' => $billing_address['entry_company'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'street_address' => $billing_address['entry_street_address'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'suburb' => $billing_address['entry_suburb'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'city' => $billing_address['entry_city'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'postcode' => $billing_address['entry_postcode'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'state' => ((tep_not_null($billing_address['entry_state'])) ? $billing_address['entry_state'] : $billing_address['zone_name']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'zone_id' => $billing_address['entry_zone_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'country' => array('id' => $billing_address['countries_id'], 'title' => $billing_address['countries_name'], 'iso_code_2' => $billing_address['countries_iso_code_2'], 'iso_code_3' => $billing_address['countries_iso_code_3']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'country_id' => $billing_address['entry_country_id'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? 'format_id' => $billing_address['address_format_id']);

? ? ?$index = 0;
? ? ?$products = $cart->get_products();
? ? ?$psize = sizeof($products);
? ? ?for ($i=0; $i<$psize; $i++) {
? ? ? ?$this->products[$index] = array('qty' => $products[$i]['quantity'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'name' => $products[$i]['name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'model' => $products[$i]['model'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'tax' => tep_get_tax_rate($products[$i]['tax_class_id'], $shipping_address['entry_country_id'], $shipping_address['entry_zone_id']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'price' => $products[$i]['price'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'final_price' => $products[$i]['price'] + $cart->attributes_price($products[$i]['id']),
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'weight' => $products[$i]['weight'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'id' => $products[$i]['id']);

? ? ? ?if ($products[$i]['attributes']) {
? ? ? ? ?$subindex = 0;
? ? ? ? ?reset($products[$i]['attributes']);
? ? ? ? ?while (list($option, $value) = each($products[$i]['attributes'])) {
? ? ? ? ? ?$attributes_query = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $products[$i]['id'] . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'");
? ? ? ? ? ?$attributes = tep_db_fetch_array($attributes_query);

? ? ? ? ? ?$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options_name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'value' => $attributes['products_options_values_name'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'option_id' => $option,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'value_id' => $value,
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'prefix' => $attributes['price_prefix'],
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'price' => $attributes['options_values_price']);

? ? ? ? ? ?$subindex++;
? ? ? ? ?}
? ? ? ?}

? ? ? ?$shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'];
? ? ? ?$this->info['subtotal'] += $shown_price;

? ? ? ?$products_tax = $this->products[$index]['tax'];
? ? ? ?if (DISPLAY_PRICE_WITH_TAX == true) {
? ? ? ? ?$this->info['tax'] += $shown_price - ($shown_price / (($products_tax < 10) ? "1.0" . str_replace('.', '', $products_tax) : "1." . str_replace('.', '', $products_tax)));
? ? ? ? ?$this->info['tax_groups']["$products_tax"] += $shown_price - ($shown_price / (($products_tax < 10) ? "1.0" . str_replace('.', '', $products_tax) : "1." . str_replace('.', '', $products_tax)));
? ? ? ?} else {
? ? ? ? ?$this->info['tax'] += ($products_tax / 100) * $shown_price;
? ? ? ? ?$this->info['tax_groups']["$products_tax"] += ($products_tax / 100) * $shown_price;
? ? ? ?}

? ? ? ?$index++;
? ? ?}

? ? ?if (DISPLAY_PRICE_WITH_TAX == true) {
? ? ? ?$this->info['total'] = $this->info['subtotal'] + $this->info['shipping_cost'];
? ? ?} else {
? ? ? ?$this->info['total'] = $this->info['subtotal'] + $this->info['tax'] + $this->info['shipping_cost'];
? ? ?}
? ?}
?}
?>

Edited by JimBarry
Link to comment
Share on other sites

i was referring to admin/orders.php really

 

you have put the code up for includes/classes/order.php

 

matt

 

 

Sorry about that. Here is the admin/orders.php

 

<?php
/*
 Copyright (c) 2002 osCommerce
 
 Modified for use by YourShopCart.com sections Copyright (c) 2002 - 2003
 YourShopCart Version 1.0

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_CLASSES . 'currencies.php');
 $currencies = new currencies();

 $orders_statuses = array();
 $orders_status_array = array();
 $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                              'text' => $orders_status['orders_status_name']);
   $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
 }

 switch ($HTTP_GET_VARS['action']) {
   case 'update_order':
     $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
     $status = tep_db_prepare_input($HTTP_POST_VARS['status']);
     $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);

     $order_updated = false;
     $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased, comments from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");
     $check_status = tep_db_fetch_array($check_status_query);
     if ($check_status['orders_status'] != $status) {
       tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . tep_db_input($oID) . "'");

       $customer_notified = '0';
       if ($HTTP_POST_VARS['notify'] == 'on') {
         $notify_comments = '';
         if ($HTTP_POST_VARS['notify_comments'] == 'on') {
           $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";
         }
         $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
         tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
         $customer_notified = '1';
       }

       tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, new_value, old_value, date_added, customer_notified) values ('" . tep_db_input($oID) . "', '" . tep_db_input($status) . "', '" . $check_status['orders_status'] . "', now(), '" . $customer_notified . "')");
     if($HTTP_POST_VARS['clear_CC'] == 'on') {
    tep_db_query("update " . TABLE_ORDERS . " set cc_number = '' where orders_id = '" . tep_db_input($oID) . "'");
     }
       $order_updated = true;
     }

     if ($check_status['comments'] != $comments) {
       tep_db_query("update " . TABLE_ORDERS . " set comments = '" . tep_db_input($comments) . "' where orders_id = '" . tep_db_input($oID) . "'");
       $order_updated = true;
     }

     if ($order_updated) {
      $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
     } else {
       $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
     }

     tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));
     break;
   case 'deleteconfirm':
     $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

     tep_remove_order($oID, $HTTP_POST_VARS['restock']);

     tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));
     break;
 }

 if ( ($HTTP_GET_VARS['action'] == 'edit') && ($HTTP_GET_VARS['oID']) ) {
   $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

   $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");
   $order_exists = true;
   if (!tep_db_num_rows($orders_query)) {
     $order_exists = false;
     $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
   }
 }

// BOF: WebMakers.com Added: Additional info for Orders
// Look up things in orders

$the_extra_query= tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");
$the_extra= tep_db_fetch_array($the_extra_query);
$the_customers_id= $the_extra['customers_id'];

// Look up things in customers

$the_extra_query= tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $the_customers_id . "'");
$the_extra= tep_db_fetch_array($the_extra_query);
$the_customers_fax= $the_extra['customers_fax'];

// EOF: WebMakers.com Added: Additional info for Orders

 include(DIR_WS_CLASSES . 'order.php');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php
 require(DIR_WS_INCLUDES . 'header.php');
?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
       <?php
 if ( ($HTTP_GET_VARS['action'] == 'edit') && ($order_exists) ) {
   $order = new order($oID);
?>
       <tr> 
         <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr> 
               <td class="pageHeading"><?php echo HEADING_ORDER_NUMBER; ?><?php echo tep_db_input($oID); ?></td>
               <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
               <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
             </tr>
           </table></td>
       </tr>
       <tr> 
         <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
             <tr> 
               <td colspan="3"><?php echo tep_draw_separator(); ?></td>
             </tr>
             <tr> 
               <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
   <?php 
// BOF: WebMakers.com Added: show additional order info
?>
<tr>
<!-- Customers ID# // -->
<td class="main"><b>Customer #: </b></td>
<td class="main"><?php echo $the_customers_id; ?></td>
</tr>
<tr> 
<!-- add date/time // -->
<td class="main"><b>Date/Time Ordered: </b></td>
<td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?><br><br></td>
</tr>
<?php
// EOF: WebMakers.com Added: show additional order info
?>
   
                   <tr> 
                     <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>
                     <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, ' ', '<br>'); ?></td>
                   </tr>
                   <tr> 
                     <td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>
                     <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td>
                   </tr>
                   <tr> 
                     <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>
                     <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br>'); ?></td>
                   </tr>
                   <tr> 
                     <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                   </tr>
                   <tr> 
                     <td class="main"><b><?php echo ENTRY_TELEPHONE; ?></b></td>
                     <td class="main"><?php echo $order->customer['telephone']; ?></td>
                   </tr>
                   <tr> 
                     <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>
                     <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>
                   </tr>
                   <tr> 
                     <td class="main"> </td>
                     <td class="main"> </td>
                   </tr>
  	 <tr> 
                     <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
                     <td class="main"><?php echo $order->info['payment_method']; ?></td>
                   </tr>
                   <?php
   if ( (($order->info['cc_type']) || ($order->info['cc_owner']) || ($order->info['cc_number'])) ) {
?>
                   <tr> 
                     <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                   </tr>
                   <tr> 
                     <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>
                     <td class="main"><?php echo $order->info['cc_type']; ?></td>
                   </tr>
                   <tr> 
                     <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>
                     <td class="main"><?php echo $order->info['cc_owner']; ?></td>
                   </tr>
                   <tr> 
                     <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>
                     <td class="main"><?php echo $order->info['cc_number']; ?></td>
                   </tr>
                   <tr><td class="main"><?php echo ENTRY_CREDIT_CARD_CVV2; ?></td>
                                              <td class="main"><?php echo $order->info['cc_cvv2']; ?></td>
                                       </tr>
                   <tr> 
                     <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>
                     <td class="main"><?php echo $order->info['cc_expires']; ?></td>
                   </tr>
                   <?php
   }
?>                  </table></td>
               <td valign="top"> </td>
               <td valign="top"> </td>
             </tr>
           </table></td>
       </tr>
       <tr> 
         <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
       </tr>
       <tr> 
         <td> </td>
       </tr>
       <tr> 
         <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
       </tr>
       <tr> 
         <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr class="dataTableHeadingRow"> 
               <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>
               <td align="right" class="dataTableHeadingContent"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>
             </tr>
             <?php
   for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
     echo '          <tr class="dataTableRow">' . "\n" .
          '            <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
          '            <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

     if (sizeof($order->products[$i]['attributes']) > 0) {
       for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
         echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
         if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
         echo '</i></small></nobr>';
       }
     }

     echo '            </td>' . "\n" .
          '            <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .
          '            <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .
          '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n";
     echo '          </tr>' . "\n";
   }
?>
             <tr> 
               <td align="right" colspan="5"><table border="0" cellspacing="0" cellpadding="2">
                   <?php
   for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
     echo '              <tr>' . "\n" .
          '                <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .
          '                <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .
          '              </tr>' . "\n";
   }
?>
                 </table></td>
             </tr>
           </table></td>
       </tr>
       <tr>
         <td class="main"><table width="100%" border="0" cellpadding="0">
             <tr>
               <td><table border="0" cellspacing="0" cellpadding="2">
                   
                 </table></td>
             </tr>
           </table></td>
       </tr>
       <tr> 
         <td class="main"><br>
           <b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>
       </tr>
       <tr> 
         <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
       </tr>
       <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order'); ?> 
         <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5', $order->info['comments']); ?></td>
       </tr>
       <tr> 
         <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
       </tr>
       <tr> 
         <td><table border="0" cellspacing="0" cellpadding="2">
             <tr> 
               <td><table border="0" cellspacing="0" cellpadding="2">
                   <tr> 
                     <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>
                   </tr>
                   <tr> 
                     <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> 
                       <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>
                     <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> 
                       <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>
      <td class="main"><b><?php echo ENTRY_NOTIFY_CLEAR_CC; ?></b>
        <?php echo tep_draw_checkbox_field('clear_CC', '', true); ?></td>
                   </tr>
                 </table></td>
               <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>
             </tr>
           </table></td></form>
       </tr>
       <tr> 
         <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
       </tr>
       <tr> 
         <td class="main"><table border="1" cellspacing="0" cellpadding="5">
             <tr> 
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_NEW_VALUE; ?></b></td>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_OLD_VALUE; ?></b></td>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>
             </tr>
             <?php
   $orders_history_query = tep_db_query("select new_value, old_value, date_added, customer_notified from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by orders_status_history_id desc");
   if (tep_db_num_rows($orders_history_query)) {
     while ($orders_history = tep_db_fetch_array($orders_history_query)) {
       echo '          <tr>' . "\n" .
            '            <td class="smallText">' . $orders_status_array[$orders_history['new_value']] . '</td>' . "\n" .
            '            <td class="smallText">' . (tep_not_null($orders_history['old_value']) ? $orders_status_array[$orders_history['old_value']] : ' ') . '</td>' . "\n" .
            '            <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" .
            '            <td class="smallText" align="center">';
       if ($orders_history['customer_notified'] == '1') {
         echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK);
       } else {
         echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS);
       }
       echo '          </tr>' . "\n";
     }
   } else {
       echo '          <tr>' . "\n" .
            '            <td class="smallText" colspan="4">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .
            '          </tr>' . "\n";
   }
?>
           </table></td>
       </tr>
       <tr> 
         <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
       </tr>
       <?php
 } else {
?>
       <tr> 
         <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr> 
               <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
               <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
               <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">
                   <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?> 
                     <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td></form>
                   </tr>
                   <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?> 
                     <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', tep_array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td></form>
                   </tr>
                 </table></td>
             </tr>
           </table></td>
       </tr>
       <tr> 
         <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr> 
               <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                   <tr class="dataTableHeadingRow"> 
                     <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
                     <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
                     <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
                     <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
                     <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
                   </tr>
                   <?php
   if ($HTTP_GET_VARS['cID']) {
     $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
     $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . tep_db_input($cID) . "' and o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";
   } elseif ($HTTP_GET_VARS['status']) {
     $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
     $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and s.orders_status_id = '" . tep_db_input($status) . "' and ot.class = 'ot_total' order by o.orders_id DESC";
   } else {
     $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC";
   }
   $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);
   $orders_query = tep_db_query($orders_query_raw);
   while ($orders = tep_db_fetch_array($orders_query)) {
     if (((!$HTTP_GET_VARS['oID']) || ($HTTP_GET_VARS['oID'] == $orders['orders_id'])) && (!$oInfo)) {
       $oInfo = new objectInfo($orders);
     }

     if ( (is_object($oInfo)) && ($orders['orders_id'] == $oInfo->orders_id) ) {
       echo '              <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '\'">' . "\n";
     } else {
       echo '              <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '\'">' . "\n";
     }
?>
                   <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>
                   <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
                   <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>
                   <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
                   <td class="dataTableContent" align="right">
                     <?php if ( (is_object($oInfo)) && ($orders['orders_id'] == $oInfo->orders_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>
                      </td>
                   </tr>
                   <?php
   }
?>
                   <tr> 
                     <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                         <tr> 
                           <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>
                           <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>
                         </tr>
                       </table></td>
                   </tr>
                 </table></td>
               <?php
 $heading = array();
 $contents = array();
 switch ($HTTP_GET_VARS['action']) {
   case 'delete':
     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>');

     $contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm'));
     $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br><br><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
     $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);
     $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
     break;
   default:
     if (is_object($oInfo)) {
       $heading[] = array('text' => '<b>[' . $oInfo->orders_id . ']  ' . tep_datetime_short($oInfo->date_purchased) . '</b>');

       $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . tep_image_button('button_update_order.gif', IMAGE_UPDATE_ORDER) . '</a></a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');

// upgrade order direct link mod start

       $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(update_order. '.'.php, 'OrderID=' . $oInfo->orders_id) . '">' . tep_image_button('button_edit.gif', Edit) . '</a>'); 

// upgrade order direct link mod end

       $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');
       $contents[] = array('text' => '<br>' . TEXT_DATE_ORDER_CREATED . ' ' . tep_date_short($oInfo->date_purchased));
       if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . tep_date_short($oInfo->last_modified));
       $contents[] = array('text' => '<br>' . TEXT_INFO_PAYMENT_METHOD . ' '  . $oInfo->payment_method);
     }
     break;
 }

 if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
   echo '            <td width="25%" valign="top">' . "\n";

   $box = new box;
   echo $box->infoBox($heading, $contents);

   echo '            </td>' . "\n";
 }
?>
             </tr>
           </table></td>
       </tr>
       <?php
 }
?>
     </table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php
   require(DIR_WS_INCLUDES . 'footer.php');
?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

Thanks

Link to comment
Share on other sites

i couldnt see anything in those files that was wrong?

 

are you using PHP5?

 

anyhoo - a shameful hack to get things running would be to put

 

if (file_exists(tep_db_connect)) {

return;

}

 

at the top of admin/includes/database.php

 

Matt

Link to comment
Share on other sites

i couldnt see anything in those files that was wrong?

 

are you using PHP5?

 

anyhoo - a shameful hack to get things running would be to put

 

if (file_exists(tep_db_connect)) {

return;

}

 

at the top of admin/includes/database.php

 

Matt

 

According to the server admin, PHP is 4.3.10

Will that be an issue/problems??

I'll add the hack and report back what happens. Thnaks so much.

Edited by JimBarry
Link to comment
Share on other sites

admin/includes/functions/database.php

 

 

I did this, but it still doesn't allow me to access admin/orders.php

 

<?php
/*
 Copyright (c) 2002 osCommerce
 
 Modified for use by YourShopCart.com sections Copyright (c) 2002 - 2003
 YourShopCart Version 1.0

 Released under the GNU General Public License
*/
if (file_exists(tep_db_connect)) {
return;
}

 function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {
   global $$link;

   if (USE_PCONNECT == 'true') {
     $$link = mysql_pconnect($server, $username, $password);
   } else {
     $$link = mysql_connect($server, $username, $password);
   }

   if ($$link) mysql_select_db($database);

   return $$link;
 }

 function tep_db_close($link = 'db_link') {
   global $$link;

Link to comment
Share on other sites

terribly sorry - should be function_exists - not file_exists

 

Hi,

 

I made the change as stated above. While it seems to have fixed that error message, I now get the following message:

 

Fatal error: Cannot redeclare class logger in /home/woodwork/public_html/admin/includes/classes/logger.php on line 11

 

Ideas? Thanks. This is my logger file

 

<?php
/*
 Copyright (c) 2002 osCommerce
 
 Modified for use by YourShopCart.com sections Copyright (c) 2002 - 2003
 YourShopCart Version 1.0

 Released under the GNU General Public License
*/

 class logger {
   var $timer_start, $timer_stop, $timer_total;

// class constructor
   function logger() {
     $this->timer_start();
   }

   function timer_start() {
     if (defined("PAGE_PARSE_START_TIME")) {
       $this->timer_start = PAGE_PARSE_START_TIME;
     } else {
       $this->timer_start = microtime();
     }
   }

   function timer_stop($display = 'false') {
     $this->timer_stop = microtime();

     $time_start = explode(' ', $this->timer_start);
     $time_end = explode(' ', $this->timer_stop);

     $this->timer_total = number_format(($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0])), 3);

     $this->write(getenv('REQUEST_URI'), $this->timer_total . 's');

     if ($display == 'true') {
       return $this->timer_display();
     }
   }

   function timer_display() {
     return '<span class="smallText">Parse Time: ' . $this->timer_total . 's</span>';
   }

   function write($message, $type) {
     error_log(strftime(STORE_PARSE_DATE_TIME_FORMAT) . ' [' . $type . '] ' . $message . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
   }
 }
?>

Edited by JimBarry
Link to comment
Share on other sites

Hi Meltus,

 

Would you have any more suggestions on trying to make a fix for this error? Thanks in advance.

 

Jim

 

Hello,

 

You seem to be using a different version of OSC that I am not familiar with.

 

You said that you reverted everything back to it's original state and it is still giving errors? That is very strange.

 

You reverted your database as well, correct?

 

Since you are using a YourShopCart.com version of OSC there may be some issues with my directions that are conflicting with this version and I may need to dig into that version to figure out the conflict.

 

I am very busy atm so I have not had much time to look at this issue, just peruse the thread.

 

If you would like me to dedicate some time to resolving this issue for you I can do so at a very reasonable fee.

 

Otherwise, I will still look into the problem but I can not give you any time frame or guarantees.

Link to comment
Share on other sites

Update on this issue...

 

I downloaded the newest osC and working from those files, made the changes according to the contribution. I also replaced the database.php file. As a result, I am able to access the admin order processing page

 

however...

 

in testing a purchase through the online store I get the following error message after completing the checkout process:

 

1054 - Unknown column 'orders_status_id' in 'field list'

 

insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('49', '1', now(), '1', '')

 

[TEP STOP]

 

The customer order does appear in the admin/orders.php page and it does collect the CVV2 information but it no longer records the credit card number for dispaly in this page. So I cannot process orders. as well, on the customer orders page it shows the following error message:

 

1054 - Unknown column 'orders_status_id' in 'field list'

 

select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '49' order by date_added

 

[TEP STOP]

 

Could someone help with this ongoing issue? Thank you very much in advance.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...