Please Help! Store won't accept orders!

[jeffytime]

I think this happened when I synchronized my local files with remote in dreamweaver, this used to work fine, now customers are calling me saying they cant order!

 

I have tried to replace the shipping.php file with a backup and it still won't work. Please anyone have any ideas? :huh:

 

 

heres the error message when checking out

 

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fastlarr/public_html/mjn/oscommerce-2.2ms2/catalog/includes/classes/shipping.php on line 33

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fastlarr/public_html/mjn/oscommerce-2.2ms2/catalog/includes/classes/shipping.php on line 68

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fastlarr/public_html/mjn/oscommerce-2.2ms2/catalog/includes/classes/shipping.php on line 68

 

Warning: Cannot modify header information - headers already sent by (output started at /home/fastlarr/public_html/mjn/oscommerce-2.2ms2/catalog/includes/classes/shipping.php:1) in /home/fastlarr/public_html/mjn/oscommerce-2.2ms2/catalog/includes/functions/general.php on line 29

 

 

 

 

 

 

 

 

 

 

 

 

 

Here is the /includes/classes/shipping.php file

 

 

ï

»¿<?php

/*

$Id: shipping.php,v 1.23 2003/06/29 11:22:05 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

class shipping {

var $modules;

 

// class constructor

function shipping($module = '') {

global $language, $PHP_SELF;

 

// INDIV_SM BEGIN (this is messy i know)

global $cart;

// New to fix attributes bug

$cart_products = $cart->get_products();

if (tep_not_null($cart_products)) {

$real_ids = array();

foreach($cart_products as $prod){

$real_ids[] = tep_get_prid($prod['id']);

}

$sql = "SELECT shipping_methods FROM ".TABLE_PRODUCTS." WHERE products_id IN (".implode(',',$real_ids).") AND shipping_methods IS NOT NULL AND shipping_methods <> ''";

$query = mysql_query($sql);

// End new bug fix

$allow_mod_array = array();

while($rec = mysql_fetch_array($query)){

if(empty($allow_mod_array)) $startedempty = true;

$methods_array = array();

$methods_array = explode(';',$rec['shipping_methods']);

if(!empty($methods_array)){

foreach($methods_array as $method){

$allow_mod_array[] = $method;

}

}

if($startedempty){

$startedempty = false;

}else{

$temp_array = array();

foreach($allow_mod_array as $val){

$temp_array[$val]++;

}

$allow_mod_array = array();

foreach($temp_array as $key => $val){

if($val > 1){

$allow_mod_array[] = $key;

}

}

}

}

}

// INDIV_SM END

 

if (defined('MODULE_SHIPPING_INSTALLED') && tep_not_null(MODULE_SHIPPING_INSTALLED)) {

$this->modules = explode(';', MODULE_SHIPPING_INSTALLED);

 

// INDIV_SM START

if (tep_not_null($cart_products)) {

$temp_array = $this->modules;

$this->modules = array();

foreach($temp_array as $val){

if(mysql_num_rows($query)==0 || in_array(str_replace('.php','',$val),$allow_mod_array)) {

$this->modules[] = $val;

}

}

}

// INDIV_SM END

 

$include_modules = array();

 

if ( (tep_not_null($module)) && (in_array(substr($module['id'], 0, strpos($module['id'], '_')) . '.' . substr($PHP_SELF, (strrpos($PHP_SELF, '.')+1)), $this->modules)) ) {

$include_modules[] = array('class' => substr($module['id'], 0, strpos($module['id'], '_')), 'file' => substr($module['id'], 0, strpos($module['id'], '_')) . '.' . substr($PHP_SELF, (strrpos($PHP_SELF, '.')+1)));

} else {

reset($this->modules);

while (list(, $value) = each($this->modules)) {

$class = substr($value, 0, strrpos($value, '.'));

$include_modules[] = array('class' => $class, 'file' => $value);

}

}

 

for ($i=0, $n=sizeof($include_modules); $i<$n; $i++) {

include(DIR_WS_LANGUAGES . $language . '/modules/shipping/' . $include_modules[$i]['file']);

include(DIR_WS_MODULES . 'shipping/' . $include_modules[$i]['file']);

 

$GLOBALS[$include_modules[$i]['class']] = new $include_modules[$i]['class'];

}

}

}

 

function quote($method = '', $module = '') {

global $total_weight, $shipping_weight, $shipping_quoted, $shipping_num_boxes;

 

$quotes_array = array();

 

if (is_array($this->modules)) {

$shipping_quoted = '';

$shipping_num_boxes = 1;

$shipping_weight = $total_weight;

 

if (SHIPPING_BOX_WEIGHT >= $shipping_weight*SHIPPING_BOX_PADDING/100) {

$shipping_weight = $shipping_weight+SHIPPING_BOX_WEIGHT;

} else {

$shipping_weight = $shipping_weight + ($shipping_weight*SHIPPING_BOX_PADDING/100);

}

 

if ($shipping_weight > SHIPPING_MAX_WEIGHT) { // Split into many boxes

$shipping_num_boxes = ceil($shipping_weight/SHIPPING_MAX_WEIGHT);

$shipping_weight = $shipping_weight/$shipping_num_boxes;

}

 

$include_quotes = array();

 

reset($this->modules);

while (list(, $value) = each($this->modules)) {

$class = substr($value, 0, strrpos($value, '.'));

if (tep_not_null($module)) {

if ( ($module == $class) && ($GLOBALS[$class]->enabled) ) {

$include_quotes[] = $class;

}

} elseif ($GLOBALS[$class]->enabled) {

$include_quotes[] = $class;

}

}

 

$size = sizeof($include_quotes);

for ($i=0; $i<$size; $i++) {

$quotes = $GLOBALS[$include_quotes[$i]]->quote($method);

if (is_array($quotes)) $quotes_array[] = $quotes;

}

}

 

return $quotes_array;

}

 

function cheapest() {

if (is_array($this->modules)) {

$rates = array();

 

reset($this->modules);

while (list(, $value) = each($this->modules)) {

$class = substr($value, 0, strrpos($value, '.'));

if ($GLOBALS[$class]->enabled) {

$quotes = $GLOBALS[$class]->quotes;

for ($i=0, $n=sizeof($quotes['methods']); $i<$n; $i++) {

if (isset($quotes['methods'][$i]['cost']) && tep_not_null($quotes['methods'][$i]['cost'])) {

$rates[] = array('id' => $quotes['id'] . '_' . $quotes['methods'][$i]['id'],

'title' => $quotes['module'] . ' (' . $quotes['methods'][$i]['title'] . ')',

'cost' => $quotes['methods'][$i]['cost']);

}

}

}

}

 

$cheapest = false;

for ($i=0, $n=sizeof($rates); $i<$n; $i++) {

if (is_array($cheapest)) {

if ($rates[$i]['cost'] < $cheapest['cost']) {

$cheapest = $rates[$i];

}

} else {

$cheapest = $rates[$i];

}

}

 

return $cheapest;

}

}

}

?>