Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need help with T Case error on orders.php


JBCards

Recommended Posts

In the admin menu, I am getting the following error message when I go to the orders page.

 

Parse error: syntax error, unexpected T_CASE in /home2/site/public_html/admin/orders.php on line 61

 

I tried reinstalling a back up and ended up with the same message. I do have google checkout if that makes a difference since it looks like it is installing itself in the code anyway.

 

Here is the code around it.

 

		if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");
// ** GOOGLE CHECKOUT ** chdir("./.."); require_once(DIR_WS_LANGUAGES . $language . '/modules/payment/googlecheckout.php'); $payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE; $num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));
if($num_rows != 0) { $customer_notified = google_checkout_state_change($check_status, $status, $oID,  (@$_POST['notify']=='on'?1:0),  (@$_POST['notify_comments']=='on'?$comments:'')); } $customer_notified = isset($customer_notified)?$customer_notified:'0';// ** END GOOGLE CHECKOUT ** if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) { $notify_comments = ''; if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) { $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n"; }// ** GOOGLE CHECKOUT ** $force_email = false; if($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) { $force_email = true; $messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');  }
if($num_rows == 0 || $force_email) { //send emails, not a google order or configured to use both messaging systems $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, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; //send extra emails } } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; }

	if ($order_updated == true) {
	 $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;
--> this is line 61	 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;
}
 }

Link to comment
Share on other sites

In the admin menu, I am getting the following error message when I go to the orders page.

 

Parse error: syntax error, unexpected T_CASE in /home2/site/public_html/admin/orders.php on line 61

 

I tried reinstalling a back up and ended up with the same message. I do have google checkout if that makes a difference since it looks like it is installing itself in the code anyway.

 

Here is the code around it.

 

		if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");
// ** GOOGLE CHECKOUT ** chdir("./.."); require_once(DIR_WS_LANGUAGES . $language . '/modules/payment/googlecheckout.php'); $payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE; $num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));
if($num_rows != 0) { $customer_notified = google_checkout_state_change($check_status, $status, $oID,  (@$_POST['notify']=='on'?1:0),  (@$_POST['notify_comments']=='on'?$comments:'')); } $customer_notified = isset($customer_notified)?$customer_notified:'0';// ** END GOOGLE CHECKOUT ** if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) { $notify_comments = ''; if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) { $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n"; }// ** GOOGLE CHECKOUT ** $force_email = false; if($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) { $force_email = true; $messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');  }
if($num_rows == 0 || $force_email) { //send emails, not a google order or configured to use both messaging systems $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, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; //send extra emails } } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; }

	if ($order_updated == true) {
	 $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;
--> this is line 61	 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;
}
 }

 

Without the whole switch statement we can't debug a case.

Link to comment
Share on other sites

Okay, this appears to be the entire switch statement. Thanks.

 

 if (tep_not_null($action)) {
switch ($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 from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
	$check_status = tep_db_fetch_array($check_status_query);

	if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");
// ** GOOGLE CHECKOUT ** chdir("./.."); require_once(DIR_WS_LANGUAGES . $language . '/modules/payment/googlecheckout.php'); $payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE; $num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));
if($num_rows != 0) { $customer_notified = google_checkout_state_change($check_status, $status, $oID,  (@$_POST['notify']=='on'?1:0),  (@$_POST['notify_comments']=='on'?$comments:'')); } $customer_notified = isset($customer_notified)?$customer_notified:'0';// ** END GOOGLE CHECKOUT ** if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) { $notify_comments = ''; if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) { $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n"; }// ** GOOGLE CHECKOUT ** $force_email = false; if($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) { $force_email = true; $messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');  }
if($num_rows == 0 || $force_email) { //send emails, not a google order or configured to use both messaging systems $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, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; //send extra emails } } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; }

	if ($order_updated == true) {
	 $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;
--> line 61	  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;
}
 }

Link to comment
Share on other sites

Okay, this appears to be the entire switch statement. Thanks.

 

 if (tep_not_null($action)) {
switch ($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 from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
	$check_status = tep_db_fetch_array($check_status_query);

	if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) { tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");
// ** GOOGLE CHECKOUT ** chdir("./.."); require_once(DIR_WS_LANGUAGES . $language . '/modules/payment/googlecheckout.php'); $payment_value= MODULE_PAYMENT_GOOGLECHECKOUT_TEXT_TITLE; $num_rows = tep_db_num_rows(tep_db_query("select google_order_number from google_orders where orders_id= ". (int)$oID));
if($num_rows != 0) { $customer_notified = google_checkout_state_change($check_status, $status, $oID,  (@$_POST['notify']=='on'?1:0),  (@$_POST['notify_comments']=='on'?$comments:'')); } $customer_notified = isset($customer_notified)?$customer_notified:'0';// ** END GOOGLE CHECKOUT ** if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) { $notify_comments = ''; if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') && tep_not_null($comments)) { $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n"; }// ** GOOGLE CHECKOUT ** $force_email = false; if($num_rows != 0 && (strlen(htmlentities(strip_tags($notify_comments))) > GOOGLE_MESSAGE_LENGTH && MODULE_PAYMENT_GOOGLECHECKOUT_USE_CART_MESSAGING == 'True')) { $force_email = true; $messageStack->add_session(GOOGLECHECKOUT_WARNING_SYSTEM_EMAIL_SENT, 'warning');  }
if($num_rows == 0 || $force_email) { //send emails, not a google order or configured to use both messaging systems $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, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; //send extra emails } } tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; }

	if ($order_updated == true) {
	 $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;
--> line 61	  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;
}
 }

 

The following line seems to be causing the problem as it is "overlapping the controlling case .. break statement

 

if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {

Link to comment
Share on other sites

  • 3 weeks later...

Hi!

 

Yea, I just installed the Header Tags addon and I got this error when I clicked on "Catalog" in my admin page:

 

Parse error: syntax error, unexpected T_CASE in /home/xxxxxx/public_html/catalog/admin/categories.php on line 341

 

Heres the whole code:

 

 require('includes/application_top.php');  require(DIR_WS_CLASSES . 'currencies.php');  $currencies = new currencies();  $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');  if (tep_not_null($action)) {	switch ($action) {	  case 'setflag':		if ( ($HTTP_GET_VARS['flag'] == '0') || ($HTTP_GET_VARS['flag'] == '1') ) {		  if (isset($HTTP_GET_VARS['pID'])) {			tep_set_product_status($HTTP_GET_VARS['pID'], $HTTP_GET_VARS['flag']);		  }		  if (USE_CACHE == 'true') {			tep_reset_cache_block('categories');			tep_reset_cache_block('also_purchased');		  }		}		tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $HTTP_GET_VARS['cPath'] . '&pID=' . $HTTP_GET_VARS['pID']));		break;	  case 'insert_category':	  case 'update_category':		if (isset($HTTP_POST_VARS['categories_id'])) $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);		$sort_order = tep_db_prepare_input($HTTP_POST_VARS['sort_order']);		$sql_data_array = array('sort_order' => (int)$sort_order);		if ($action == 'insert_category') {		  $insert_sql_data = array('parent_id' => $current_category_id,								   'date_added' => 'now()');		  $sql_data_array = array_merge($sql_data_array, $insert_sql_data);		  tep_db_perform(TABLE_CATEGORIES, $sql_data_array);		  $categories_id = tep_db_insert_id();		} elseif ($action == 'update_category') {		  $update_sql_data = array('last_modified' => 'now()');		  $sql_data_array = array_merge($sql_data_array, $update_sql_data);		  tep_db_perform(TABLE_CATEGORIES, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "'");		}		$languages = tep_get_languages();		for ($i=0, $n=sizeof($languages); $i<$n; $i++) {		  $categories_name_array = $HTTP_POST_VARS['categories_name']; /*** Begin Header Tags SEO ***/ $categories_htc_title_array = $HTTP_POST_VARS['categories_htc_title_tag']; $categories_htc_desc_array = $HTTP_POST_VARS['categories_htc_desc_tag']; $categories_htc_keywords_array = $HTTP_POST_VARS['categories_htc_keywords_tag']; $categories_htc_description_array = $HTTP_POST_VARS['categories_htc_description']; /*** End Header Tags SEO ***/		  $language_id = $languages[$i]['id'];   /*** Begin Header Tags SEO ***/ $sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id]), 'categories_htc_title_tag' => (tep_not_null($categories_htc_title_array[$language_id]) ? tep_db_prepare_input($categories_htc_title_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])), 'categories_htc_desc_tag' => (tep_not_null($categories_htc_desc_array[$language_id]) ? tep_db_prepare_input($categories_htc_desc_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])), 'categories_htc_keywords_tag' => (tep_not_null($categories_htc_keywords_array[$language_id]) ? tep_db_prepare_input($categories_htc_keywords_array[$language_id]) : tep_db_prepare_input($categories_name_array[$language_id])), 'categories_htc_description' => tep_db_prepare_input($categories_htc_description_array[$language_id])); /*** End Header Tags SEO ***/		  if ($action == 'insert_category') {			$insert_sql_data = array('categories_id' => $categories_id,									 'language_id' => $languages[$i]['id']);			$sql_data_array = array_merge($sql_data_array, $insert_sql_data);			tep_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array);		  } elseif ($action == 'update_category') {			tep_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");		  }		}		$categories_image = new upload('categories_image');		$categories_image->set_destination(DIR_FS_CATALOG_IMAGES);		if ($categories_image->parse() && $categories_image->save()) {		  tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($categories_image->filename) . "' where categories_id = '" . (int)$categories_id . "'");		}		if (USE_CACHE == 'true') {		  tep_reset_cache_block('categories');		  tep_reset_cache_block('also_purchased');		}		tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));		break;	  case 'delete_category_confirm':		if (isset($HTTP_POST_VARS['categories_id'])) {		  $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);		  $categories = tep_get_category_tree($categories_id, '', '0', '', true);		  $products = array();		  $products_delete = array();		  for ($i=0, $n=sizeof($categories); $i<$n; $i++) {			$product_ids_query = tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$categories[$i]['id'] . "'");			while ($product_ids = tep_db_fetch_array($product_ids_query)) {			  $products[$product_ids['products_id']]['categories'][] = $categories[$i]['id'];			}		  }		  reset($products);		  while (list($key, $value) = each($products)) {			$category_ids = '';			for ($i=0, $n=sizeof($value['categories']); $i<$n; $i++) {			  $category_ids .= "'" . (int)$value['categories'][$i] . "', ";			}			$category_ids = substr($category_ids, 0, -2);			$check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$key . "' and categories_id not in (" . $category_ids . ")");			$check = tep_db_fetch_array($check_query);			if ($check['total'] < '1') {			  $products_delete[$key] = $key;			}		  }// removing categories can be a lengthy process		  tep_set_time_limit(0);		  for ($i=0, $n=sizeof($categories); $i<$n; $i++) {			tep_remove_category($categories[$i]['id']);		  }		  reset($products_delete);		  while (list($key) = each($products_delete)) {			tep_remove_product($key);		  }		}		if (USE_CACHE == 'true') {		  tep_reset_cache_block('categories');		  tep_reset_cache_block('also_purchased');		}		tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));		break;	  case 'delete_product_confirm':		if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['product_categories']) && is_array($HTTP_POST_VARS['product_categories'])) {		  $product_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);		  $product_categories = $HTTP_POST_VARS['product_categories'];		  for ($i=0, $n=sizeof($product_categories); $i<$n; $i++) {			tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "' and categories_id = '" . (int)$product_categories[$i] . "'");		  }		  $product_categories_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'");		  $product_categories = tep_db_fetch_array($product_categories_query);		  if ($product_categories['total'] == '0') {			tep_remove_product($product_id);		  }		}		if (USE_CACHE == 'true') {		  tep_reset_cache_block('categories');		  tep_reset_cache_block('also_purchased');		}		tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));		break;	  case 'move_category_confirm':		if (isset($HTTP_POST_VARS['categories_id']) && ($HTTP_POST_VARS['categories_id'] != $HTTP_POST_VARS['move_to_category_id'])) {		  $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);		  $new_parent_id = tep_db_prepare_input($HTTP_POST_VARS['move_to_category_id']);		  $path = explode('_', tep_get_generated_category_path_ids($new_parent_id));		  if (in_array($categories_id, $path)) {			$messageStack->add_session(ERROR_CANNOT_MOVE_CATEGORY_TO_PARENT, 'error');			tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));		  } else {			tep_db_query("update " . TABLE_CATEGORIES . " set parent_id = '" . (int)$new_parent_id . "', last_modified = now() where categories_id = '" . (int)$categories_id . "'");			if (USE_CACHE == 'true') {			  tep_reset_cache_block('categories');			  tep_reset_cache_block('also_purchased');			}			tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&cID=' . $categories_id));		  }		}		break;	  case 'move_product_confirm':		$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);		$new_parent_id = tep_db_prepare_input($HTTP_POST_VARS['move_to_category_id']);		$duplicate_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$new_parent_id . "'");		$duplicate_check = tep_db_fetch_array($duplicate_check_query);		if ($duplicate_check['total'] < 1) tep_db_query("update " . TABLE_PRODUCTS_TO_CATEGORIES . " set categories_id = '" . (int)$new_parent_id . "' where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$current_category_id . "'");		if (USE_CACHE == 'true') {		  tep_reset_cache_block('categories');		  tep_reset_cache_block('also_purchased');		}		tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id . '&pID=' . $products_id));		break;	  case 'insert_product':	  case 'update_product':		if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) {		  $action = 'new_product';		} else {		  if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']);		  $products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']);		  $products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null';		  $sql_data_array = array('products_quantity' => (int)tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),								  'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),								  'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']),								  'products_date_available' => $products_date_available,								  'products_weight' => (float)tep_db_prepare_input($HTTP_POST_VARS['products_weight']),								  'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']),								  'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),								  'manufacturers_id' => (int)tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']));		  if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) {			$sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']);		  }		  if ($action == 'insert_product') {			$insert_sql_data = array('products_date_added' => 'now()');			$sql_data_array = array_merge($sql_data_array, $insert_sql_data);			tep_db_perform(TABLE_PRODUCTS, $sql_data_array);			$products_id = tep_db_insert_id();			tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')");		  } elseif ($action == 'update_product') {			$update_sql_data = array('products_last_modified' => 'now()');			$sql_data_array = array_merge($sql_data_array, $update_sql_data);			tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");		  }		  $languages = tep_get_languages();		  for ($i=0, $n=sizeof($languages); $i<$n; $i++) {			$language_id = $languages[$i]['id'];			 /*** Begin Header Tags SEO ***/ $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), 'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), 'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]), 'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])));  /*** End Header Tags SEO ***/			if ($action == 'insert_product') {			  $insert_sql_data = array('products_id' => $products_id,									   'language_id' => $language_id);			  $sql_data_array = array_merge($sql_data_array, $insert_sql_data);			  tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array);			} elseif ($action == 'update_product') {			  tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'");			}		  }		  if (USE_CACHE == 'true') {			tep_reset_cache_block('categories');			tep_reset_cache_block('also_purchased');		  }		  tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id));		}		break;	  case 'copy_to_confirm':		if (isset($HTTP_POST_VARS['products_id']) && isset($HTTP_POST_VARS['categories_id'])) {		  $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);		  $categories_id = tep_db_prepare_input($HTTP_POST_VARS['categories_id']);		  if ($HTTP_POST_VARS['copy_as'] == 'link') {			if ($categories_id != $current_category_id) {			  $check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "'");			  $check = tep_db_fetch_array($check_query);			  if ($check['total'] < '1') {				tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$categories_id . "')");			  }			} else {			  $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error');			}		  } elseif ($HTTP_POST_VARS['copy_as'] == 'duplicate') {			$product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");			$product = tep_db_fetch_array($product_query);			tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "',  now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')");			$dup_products_id = tep_db_insert_id();			 /*** Begin Header Tags SEO ***/ $description_query = tep_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_head_title_tag']) . "', '" . tep_db_input($description['products_head_desc_tag']) . "', '" . tep_db_input($description['products_head_keywords_tag']) . "', '" . tep_db_input($description['products_url']) . "', '0')"); }  
/*** End Header Tags SEO ***/ 

		}			
tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')");  
$products_id = $dup_products_id;		  
}		  
if (USE_CACHE == 'true') {			
tep_reset_cache_block('categories');			
tep_reset_cache_block('also_purchased');
}	   
}		

tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $categories_id . '&pID=' . $products_id));		
break;


-----> [b] case 'new_product_preview':[/b]



// copy image only if modified		$products_image = new upload('products_image');		$products_image->set_destination(DIR_FS_CATALOG_IMAGES);		if ($products_image->parse() && $products_image->save()) {		  $products_image_name = $products_image->filename;		} else {		  $products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : '');		}		break;	}  }

 

 

 

I seperated a few lines, I dont know how to copy/paste exactly how it shows, sorry...

 

But thats line 341

 

Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...