Latest News: (loading..)

garywwww

Members
  • Content count

    15
  • Joined

  • Last visited

About garywwww

Profile Information

  • Real Name
    sdf
  1. hi all, i have installed the FCK HTML Editor 2.7 Install for OSC2.2.txt However, on the admin > tools > send email I was typed with normal rich text format in english and paste a picture just like what i have done on microsoft winword but now in FCK editor But once i press 'send mail' and it was as follows and the email that i received was just like a mess html code. How to adjust it and how to make it normal send a letter with a picture instead of mass html code out to email receiver. please help Is there any thread of the URL that can answer the above said mentioned question thanks <p> </p> <p>dsf</p> <p>v</p> <p><img height="50" alt="在別人眼中,你的英語是怎樣?" src="http://l.yimg.com/mq/a/hk/wsi/mntl_090401.jpg" width="65" border="0" /></p>
  2. Dearest, I was successfully installed the Easy Populate 2.76h-MS2 (with attributes) However, i can use the excel sheet such as sample_output_file.csv I press insert into the db of Upload and Import EP File on the admin> catalog>Easy Populate the description and needed image was upload into the db was success. But it doesn't show Shop By Products as you can see the following URL with classified catalog. The catalog of the new products that upload into db will not updated the catalog of new product of Shop By Products section It just show up the NEW PRODUCTS LISTING of those upload excel information http://58.177.136.197/site1/catalog/ and the admin panel also go to catalog section that haven't updated and classfied the Categories / Products even i upload and insert into the db. Please help! My email was : garywong@skywalk-ent.com thanks gar
  3. I just wondering on the one of my installed Automated Auction Process there is a file called auction_listing_admin.php You can see on the admin>auction listing A text box for Description: It was very ugly. I would like to have a FCK EDITOR FOR WYSIWG EDITING which is FCK HTML Editor 2.7 Install, in fact, i installed on the osc already But I would like to have FCK_HTML Editor on the Description that makes elegant and user friendly to use Please help <?php /* $Id: auction_listings_admin.php,v 1.146 2003/07/11 14:40:27 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ 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']); } } tep_redirect(tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $HTTP_GET_VARS['cPath'] . '&pID=' . $HTTP_GET_VARS['pID'])); 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); } } tep_redirect(tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath)); 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' => 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' => 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'])); 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 (isset($HTTP_POST_VARS['remove_image_2']) && tep_not_null($HTTP_POST_VARS['remove_image_2']) && ($HTTP_POST_VARS['remove_image_2'] == 'true')) { $HTTP_POST_VARS['products_image_2'] = Null; $sql_data_array['products_image_2'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_2']); } elseif (isset($HTTP_POST_VARS['products_image_2']) && tep_not_null($HTTP_POST_VARS['products_image_2']) && ($HTTP_POST_VARS['products_image_2'] != 'none')) { $sql_data_array['products_image_2'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_2']); } if (isset($HTTP_POST_VARS['remove_image_3']) && tep_not_null($HTTP_POST_VARS['remove_image_3']) && ($HTTP_POST_VARS['remove_image_3'] == 'true')) { $HTTP_POST_VARS['products_image_3'] = Null; $sql_data_array['products_image_3'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_3']); } elseif (isset($HTTP_POST_VARS['products_image_3']) && tep_not_null($HTTP_POST_VARS['products_image_3']) && ($HTTP_POST_VARS['products_image_3'] != 'none')) { $sql_data_array['products_image_3'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_3']); } if (isset($HTTP_POST_VARS['remove_image_4']) && tep_not_null($HTTP_POST_VARS['remove_image_4']) && ($HTTP_POST_VARS['remove_image_4'] == 'true')) { $HTTP_POST_VARS['products_image_4'] = Null; $sql_data_array['products_image_4'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_4']); } elseif (isset($HTTP_POST_VARS['products_image_4']) && tep_not_null($HTTP_POST_VARS['products_image_4']) && ($HTTP_POST_VARS['products_image_4'] != 'none')) { $sql_data_array['products_image_4'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_4']); } if (isset($HTTP_POST_VARS['remove_image_5']) && tep_not_null($HTTP_POST_VARS['remove_image_5']) && ($HTTP_POST_VARS['remove_image_5'] == 'true')) { $HTTP_POST_VARS['products_image_5'] = Null; $sql_data_array['products_image_5'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_5']); } elseif (isset($HTTP_POST_VARS['auction_products_image_5']) && tep_not_null($HTTP_POST_VARS['products_image_5']) && ($HTTP_POST_VARS['products_image_5'] != 'none')) { $sql_data_array['products_image_5'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_5']); } if (isset($HTTP_POST_VARS['remove_image_6']) && tep_not_null($HTTP_POST_VARS['remove_image_6']) && ($HTTP_POST_VARS['remove_image_6'] == 'true')) { $HTTP_POST_VARS['products_image_6'] = Null; $sql_data_array['products_image_6'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_6']); } elseif (isset($HTTP_POST_VARS['products_image_6']) && tep_not_null($HTTP_POST_VARS['products_image_6']) && ($HTTP_POST_VARS['products_image_6'] != 'none')) { $sql_data_array['products_image_6'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_6']); } 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 . "'"); } $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name']), 'products_title' => tep_db_prepare_input($HTTP_POST_VARS['products_title']), 'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description']), 'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'])); if ($action == 'insert_product') { $insert_sql_data = array('products_id' => $products_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 . "'"); } tep_redirect(tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products_id)); } break; case 'new_product_preview': // 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'] : ''); } $products_image_2 = new upload('products_image_2'); $products_image_2->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image_2->parse() && $products_image_2->save()) { $products_image_name_2 = $products_image_2->filename; } else { $products_image_name_2 = (isset($HTTP_POST_VARS['products_previous_image_2']) ? $HTTP_POST_VARS['products_previous_image_2'] : ''); } $products_image_3 = new upload('products_image_3'); $products_image_3->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image_3->parse() && $products_image_3->save()) { $products_image_name_3 = $products_image_3->filename; } else { $products_image_name_3 = (isset($HTTP_POST_VARS['products_previous_image_3']) ? $HTTP_POST_VARS['products_previous_image_3'] : ''); } $products_image_4 = new upload('products_image_4'); $products_image_4->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image_4->parse() && $products_image_4->save()) { $products_image_name_4 = $products_image_4->filename; } else { $products_image_name_4 = (isset($HTTP_POST_VARS['products_previous_image_4']) ? $HTTP_POST_VARS['products_previous_image_4'] : ''); } $products_image_5 = new upload('products_image_5'); $products_image_5->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image_5->parse() && $products_image_5->save()) { $products_image_name_5 = $products_image_5->filename; } else { $products_image_name_5 = (isset($HTTP_POST_VARS['products_previous_image_5']) ? $HTTP_POST_VARS['products_previous_image_5'] : ''); } $products_image_6 = new upload('products_image_6'); $products_image_6->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image_6->parse() && $products_image_6->save()) { $products_image_name_6 = $products_image_6->filename; } else { $products_image_name_6 = (isset($HTTP_POST_VARS['products_previous_image_6']) ? $HTTP_POST_VARS['products_previous_image_6'] : ''); } break; } } // check if the catalog image directory exists if (is_dir(DIR_FS_CATALOG_IMAGES)) { if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error'); } else { $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error'); } ?> <!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"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();"> <div id="spiffycalendar" class="text"></div> <!-- 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"> <?php if ($action == 'generate_code') { $generate_code_query = tep_db_query("select products_id, products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $generate_code_product = tep_db_fetch_array($generate_code_query); $form_action = (isset($HTTP_GET_VARS['pID'])); echo tep_draw_form($form_action, FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action="#"' . $form_action, 'post', 'enctype="multipart/form-data"'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo $generate_code_product['products_name']; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_GENERATE_CODE_DESC; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td> <textarea rows="22" name="S1" cols="100"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td> <script language="JavaScript" type="text/JavaScript"> if(navigator.appName == "Microsoft Internet Explorer") { document.write("<object type='text/x-scriptlet' data='<?php echo tep_catalog_href_link('auction_product_info.php') . '?cPath=9999&products_id=' . $HTTP_GET_VARS['pID']; ?>' width='100%' height='1300'></object>") } else { document.write("<object type='text/html' data='<?php echo tep_catalog_href_link('auction_product_info.php') . '?cPath=9999&products_id=' . $HTTP_GET_VARS['pID']; ?>' width='100%' height='1300'></object>") } </script> </td> </tr> </table></textarea> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><?php echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> </table></form> <?php } elseif ($action == 'new_product') { $parameters = array('products_name' => '', 'products_title' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_model' => '', 'products_image' => '', 'products_image_2' => '', 'products_image_3' => '', 'products_image_4' => '', 'products_image_5' => '', 'products_image_6' => '', 'products_price' => '', 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => ''); $pInfo = new objectInfo($parameters); if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { // $product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_query = tep_db_query("select pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $pInfo->objectInfo($product); } elseif (tep_not_null($HTTP_POST_VARS)) { $pInfo->objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_title = $HTTP_POST_VARS['products_title']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE)); $tax_class_query = tep_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title"); while ($tax_class = tep_db_fetch_array($tax_class_query)) { $tax_class_array[] = array('id' => $tax_class['tax_class_id'], 'text' => $tax_class['tax_class_title']); } $languages = tep_get_languages(); if (!isset($pInfo->products_status)) $pInfo->products_status = '1'; switch ($pInfo->products_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } ?> <link rel="stylesheet" type="text/css" href="includes/javascript/spiffyCal/spiffyCal_v2_1.css"> <script language="JavaScript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script> <script language="javascript"><!-- var dateAvailable = new ctlSpiffyCalendarBox("dateAvailable", "new_product", "products_date_available","btnDate1","<?php echo $pInfo->products_date_available; ?>",scBTNMODE_CUSTOMBLUE); //--></script> <script language="javascript"><!-- var tax_rates = new Array(); <?php for ($i=0, $n=sizeof($tax_class_array); $i<$n; $i++) { if ($tax_class_array[$i]['id'] > 0) { echo 'tax_rates["' . $tax_class_array[$i]['id'] . '"] = ' . tep_get_tax_rate_value($tax_class_array[$i]['id']) . ';' . "\n"; } } ?> function doRound(x, places) { return Math.round(x * Math.pow(10, places)) / Math.pow(10, places); } function getTaxRate() { var selected_value = document.forms["new_product"].products_tax_class_id.selectedIndex; var parameterVal = document.forms["new_product"].products_tax_class_id[selected_value].value; if ( (parameterVal > 0) && (tax_rates[parameterVal] > 0) ) { return tax_rates[parameterVal]; } else { return 0; } } function updateGross() { var taxRate = getTaxRate(); var grossValue = document.forms["new_product"].products_price.value; if (taxRate > 0) { grossValue = grossValue * ((taxRate / 100) + 1); } document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4); } function updateNet() { var taxRate = getTaxRate(); var netValue = document.forms["new_product"].products_price_gross.value; if (taxRate > 0) { netValue = netValue / ((taxRate / 100) + 1); } document.forms["new_product"].products_price.value = doRound(netValue, 4); } //--></script> <?php echo tep_draw_form('new_product', FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=new_product_preview', 'post', 'enctype="multipart/form-data"'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo sprintf(TEXT_NEW_AUCTION_PRODUCT, tep_output_generated_category_path($current_category_id)); ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></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 class="main"><?php echo TEXT_PRODUCTS_STATUS; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_radio_field('products_status', '1', $in_status) . ' ' . TEXT_PRODUCT_AVAILABLE . ' ' . tep_draw_radio_field('products_status', '0', $out_status) . ' ' . TEXT_PRODUCT_NOT_AVAILABLE; ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_DATE_AVAILABLE; ?><br><small>(YYYY-MM-DD)</small></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' '; ?><script language="javascript">dateAvailable.writeControl(); dateAvailable.dateFormat="yyyy-MM-dd";</script></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_NAME; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_name', $pInfo->products_name, 'size="50"'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_TITLE; ?><br><small>(Very Important!)</small></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_title', $pInfo->products_title, 'size="50"'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_TAX_CLASS; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_pull_down_menu('products_tax_class_id', $tax_class_array, $pInfo->products_tax_class_id); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main" valign="top"><?php echo TEXT_PRODUCTS_DESCRIPTION; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_textarea_field('products_description', 'soft', '70', '15', $pInfo->products_description); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_quantity', $pInfo->products_quantity); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image . tep_draw_hidden_field('products_previous_image', $pInfo->products_image); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE_2; ?><br><?php echo tep_draw_checkbox_field('remove_image_2', "true") . ' ' . 'Remove'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_2') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_2 . tep_draw_hidden_field('products_previous_image_2', $pInfo->products_image_2); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE_3; ?><br><?php echo tep_draw_checkbox_field('remove_image_3', "true") . ' ' . 'Remove'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_3') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_3 . tep_draw_hidden_field('products_previous_image_3', $pInfo->products_image_3); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE_4; ?><br><?php echo tep_draw_checkbox_field('remove_image_4', "true") . ' ' . 'Remove'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_4') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_4 . tep_draw_hidden_field('products_previous_image_4', $pInfo->products_image_4); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE_5; ?><br><?php echo tep_draw_checkbox_field('remove_image_5', "true") . ' ' . 'Remove'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_5') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_5 . tep_draw_hidden_field('products_previous_image_5', $pInfo->products_image_5); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE_6; ?><br><?php echo tep_draw_checkbox_field('remove_image_6', "true") . ' ' . 'Remove'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image_6') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image_6 . tep_draw_hidden_field('products_previous_image_6', $pInfo->products_image_6); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_URL . '<br><small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_url', $pInfo->products_url); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_WEIGHT; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', $pInfo->products_weight); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_date_added', (tep_not_null($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . tep_image_submit('button_preview.gif', IMAGE_PREVIEW) . ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td> </tr> </table></form> <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_title = $HTTP_POST_VARS['products_title']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_title, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_image_2, p.products_image_3, p.products_image_4, p.products_image_5, p.products_image_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; $products_image_name_2 = $pInfo->products_image_2; $products_image_name_3 = $pInfo->products_image_3; $products_image_name_4 = $pInfo->products_image_4; $products_image_name_5 = $pInfo->products_image_5; $products_image_name_6 = $pInfo->products_image_6; } if ($HTTP_POST_VARS['remove_image_2'] == 'true') { $products_image_name_2 = Null; } if ($HTTP_POST_VARS['remove_image_3'] == 'true') { $products_image_name_3 = Null; } if ($HTTP_POST_VARS['remove_image_4'] == 'true') { $products_image_name_4 = Null; } if ($HTTP_POST_VARS['remove_image_5'] == 'true') { $products_image_name_5 = Null; } if ($HTTP_POST_VARS['remove_image_6'] == 'true') { $products_image_name_6 = Null; } $form_action = (isset($HTTP_GET_VARS['pID'])) ? 'update_product' : 'insert_product'; echo tep_draw_form($form_action, FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo $pInfo->products_name; ?></td> </tr> <tr> <td class="pageHeading"><?php echo $pInfo->products_title; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo $pInfo->products_description; ?></td> </tr> <?php if ($pInfo->products_url) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo sprintf(TEXT_PRODUCT_MORE_INFORMATION, $pInfo->products_url); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main" align="center"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"') ?></td> </tr> <tr> <td class="main" align="center"> <?php if (tep_not_null($products_image_name_2)) { echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_2, $pInfo->products_name_2, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"'); } ?> </td> </tr> <tr> <td class="main" align="center"> <?php if (tep_not_null($products_image_name_3)) { echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_3, $pInfo->products_name_3, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"'); } ?> </td> </tr> <tr> <td class="main" align="center"> <?php if (tep_not_null($products_image_name_4)) { echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_4, $pInfo->products_name_4, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"'); } ?> </td> </tr> <tr> <td class="main" align="center"> <?php if (tep_not_null($products_image_name_5)) { echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_5, $pInfo->products_name_5, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"'); } ?> </td> </tr> <tr> <td class="main" align="center"> <?php if (tep_not_null($products_image_name_6)) { echo tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name_6, $pInfo->products_name_6, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"'); } ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php if ($pInfo->products_date_available > date('Y-m-d')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, tep_date_long($pInfo->products_date_available)); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, tep_date_long($pInfo->products_date_added)); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) { if (isset($HTTP_GET_VARS['origin'])) { $pos_params = strpos($HTTP_GET_VARS['origin'], '?', 0); if ($pos_params != false) { $back_url = substr($HTTP_GET_VARS['origin'], 0, $pos_params); $back_url_params = substr($HTTP_GET_VARS['origin'], $pos_params + 1); } else { $back_url = $HTTP_GET_VARS['origin']; $back_url_params = ''; } } else { $back_url = FILENAME_AUCTION_LISTINGS_ADMIN; $back_url_params = 'cPath=' . $cPath . '&pID=' . $pInfo->products_id; } ?> <tr> <td align="right"><?php echo '<a href="' . tep_href_link($back_url, $back_url_params, 'NONSSL') . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <?php } else { ?> <tr> <td align="right" class="smallText"> <?php /* Re-Post all POST'ed variables */ reset($HTTP_POST_VARS); while (list($key, $value) = each($HTTP_POST_VARS)) { if (!is_array($HTTP_POST_VARS[$key])) { echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } } echo tep_draw_hidden_field('products_name', htmlspecialchars(stripslashes($products_name))); echo tep_draw_hidden_field('products_title', htmlspecialchars(stripslashes($products_title))); echo tep_draw_hidden_field('products_description', htmlspecialchars(stripslashes($products_description))); echo tep_draw_hidden_field('products_url', htmlspecialchars(stripslashes($products_url))); echo tep_draw_hidden_field('products_image', stripslashes($products_image_name)); echo tep_draw_hidden_field('products_image_2', stripslashes($products_image_name_2)); echo tep_draw_hidden_field('products_image_3', stripslashes($products_image_name_3)); echo tep_draw_hidden_field('products_image_4', stripslashes($products_image_name_4)); echo tep_draw_hidden_field('products_image_5', stripslashes($products_image_name_5)); echo tep_draw_hidden_field('products_image_6', stripslashes($products_image_name_6)); echo tep_image_submit('button_back.gif', IMAGE_BACK, 'name="edit"') . ' '; if (isset($HTTP_GET_VARS['pID'])) { echo tep_image_submit('button_update.gif', IMAGE_UPDATE); } else { echo tep_image_submit('button_insert.gif', IMAGE_INSERT); } echo ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td> </tr> </table></form> <?php } } else { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><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> </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_PRODUCTS; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $products_count = 0; $current_category_id = '9999'; $cPath = '9999'; $products_query = tep_db_query("select p.products_id, pd.products_name, pd.products_title, pd.products_viewed, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name"); while ($products = tep_db_fetch_array($products_query)) { $products_count++; $rows++; if ( (!isset($HTTP_GET_VARS['pID']) && !isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['pID']) && ($HTTP_GET_VARS['pID'] == $products['products_id']))) && !isset($pInfo) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) { // find out the rating average from customer reviews $reviews_query = tep_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . (int)$products['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); $pInfo_array = array_merge($products, $reviews); $pInfo = new objectInfo($pInfo_array); } if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id) ) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $products['products_name']; ?></td> <td class="dataTableContent" align="center"> <?php if ($products['products_status'] == '1') { echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'action=setflag&flag=0&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>'; } else { echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'action=setflag&flag=1&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10); } ?></td> <td class="dataTableContent" align="right"><?php if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php } $cPath_back = ''; if (sizeof($cPath_array) > 0) { for ($i=0, $n=sizeof($cPath_array)-1; $i<$n; $i++) { if (empty($cPath_back)) { $cPath_back .= $cPath_array[$i]; } else { $cPath_back .= '_' . $cPath_array[$i]; } } } $cPath_back = (tep_not_null($cPath_back)) ? 'cPath=' . $cPath_back . '&' : ''; ?> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'delete_product': $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_PRODUCT . '</b>'); $contents = array('form' => tep_draw_form('products', FILENAME_AUCTION_LISTINGS_ADMIN, 'action=delete_product_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id)); $contents[] = array('text' => TEXT_DELETE_PRODUCT_INTRO); $contents[] = array('text' => '<br><b>' . $pInfo->products_name . '</b>'); $product_categories_string = ''; $product_categories = tep_generate_category_path($pInfo->products_id, 'product'); for ($i = 0, $n = sizeof($product_categories); $i < $n; $i++) { $category_path = ''; for ($j = 0, $k = sizeof($product_categories[$i]); $j < $k; $j++) { $category_path .= $product_categories[$i][$j]['text'] . ' > '; } $category_path = substr($category_path, 0, -16); $product_categories_string .= tep_draw_checkbox_field('product_categories[]', $product_categories[$i][sizeof($product_categories[$i])-1]['id'], true) . ' ' . $category_path . '<br>'; } $product_categories_string = substr($product_categories_string, 0, -4); $contents[] = array('text' => '<br>' . $product_categories_string); $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if ($rows > 0) { if (isset($pInfo) && is_object($pInfo)) { // product info box contents $heading[] = array('text' => '<b>' . tep_get_products_name($pInfo->products_id, $languages_id) . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&action=new_product') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>'); $contents[] = array('text' => '<br><a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=generate_code') . '">' . TEXT_GENERATE_CODE . '</a>'); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_TITLE . ' ' . $pInfo->products_title); $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($pInfo->products_date_added)); if (tep_not_null($pInfo->products_last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($pInfo->products_last_modified)); if (date('Y-m-d') < $pInfo->products_date_available) $contents[] = array('text' => TEXT_DATE_AVAILABLE . ' ' . tep_date_short($pInfo->products_date_available)); $contents[] = array('text' => '<br>' . tep_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>' . $pInfo->products_image); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_WEIGHT_INFO . ' ' . $pInfo->products_weight . ' lbs'); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_VIEWED_INFO . ' ' . $pInfo->products_viewed . ' times'); $contents[] = array('text' => '<br>' . TEXT_PRODUCTS . ' ' . $products_count); } } else { // create category/product info $heading[] = array('text' => '<b>' . TEXT_NO_PRODUCTS . '</b>'); $contents[] = array('align' => 'center', 'text' => '</a> <a href="' . tep_href_link(FILENAME_AUCTION_LISTINGS_ADMIN, 'cPath=' . $cPath . '&action=new_product') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>'); } 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> </table> <?php } ?> </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'); ?>
  4. I tried the automated auction process of ebay-contrib-1.3 I installed all and followed exact of the manual instruction but on the admin panel Auctions> current auctions Then I press 'update' on this url http://58.177.136.197/site5/catalog/admin/...e3e0e05f15a9e26 it occurs this error Fatal error: Call to undefined function curl_init() in C:\Program Files\xampp\htdocs\Public\myweb\site5\catalog\admin\includes\functions\get_a uction_info.php on line 60 How come? Please help gar
  5. Dear all, which contributions is the most reliable and stable for the administration of osc to import such as a very simple excel xls worksheet with product description and the product name to the database and must be safe and easy to do. Not csv_import-v2 or easy populate those two contributions is mess and not workable. Or it can be a left column of admin page to have a page to insert all the product name and description similar to excel to input it. So, the user no need to go to catalog/products to input each product. I want to insert bulk product with description and name is ok. And i do not need those product quick edit because i only need a page to bulk input all the product description and product name in an most instant way fast and clean to the osc is ok. Please instruct which is the most easy and reliable contribution to handle this. thanks gar
  6. i have then downloaded your csv_import_v2. However, it success on the admin page under tools> Excel/Calc Import I go to C:\Program Files\xampp\htdocs\Public\myweb\site1\catalog\admin\csv_import and find out the example.csv Since then i tried to upload this example.csv It was not success. I press 'Upload' with broswe the file of example.csv It then automatically jump back to the login page of admin page. It doesn't seems to success each time. You know what is the problem for that. My osCommerce is osc 2.2-MS2 Php version - php/5.2.8 windows server site is : 58.177.168.197/site1/catalog The authorizing pages contributions is : Administration Access Level Accounts 2.0 http://addons.oscommerce.com/info/1359 Could you please help which other contributions for authorizing pages. The csv_import_v2 plus the other contributions please recommended should works out just fine. Also, it is an import tools of csv_import_v2. The configuration and the empty catalog doesn't work too. Is there any export function for csv_import_v2. I have /admin/csv_import/csv with permission on windows server already. I have my /admin/includes/boxes/tools.php with the following > > > <?php > > > /* > > > $Id: tools.php,v 1.21 2003/07/09 01:18:53 hpdl Exp $ > > > > > > adex > > > */ > > > ?> > > > <!-- tools //--> > > > <tr> > > > <td> > > > <?php > > > $heading = array(); > > > $contents = array(); > > > > > > $heading[] = array('text' => BOX_HEADING_TOOLS, > > > 'link' => tep_href_link(FILENAME_BACKUP, > > > 'selected_box=tools')); > > > > > > if ($selected_box == 'tools') { > > > // BOE Access with Level Account (v. 2.2a) for the Admin Area of > osCommerce > > > (MS2) 1 of 1 > > > $contents[] = array('text' => > tep_admin_files_boxes(FILENAME_BACKUP, > > > BOX_TOOLS_BACKUP) . > > > > > > tep_admin_files_boxes(FILENAME_BANNER_MANAGER, BOX_TOOLS_BANNER_MANAGER) > . > > > tep_admin_files_boxes(FILENAME_OPTIMIZE_DB, > > > BOX_TOOLS_OPTIMIZE_DB) . > > > > > > tep_admin_files_boxes(FILENAME_DEFINE_LANGUAGE, > BOX_TOOLS_DEFINE_LANGUAGE) . > > > > > > tep_admin_files_boxes(FILENAME_FILE_MANAGER, BOX_TOOLS_FILE_MANAGER) . > > > tep_admin_files_boxes(FILENAME_MAIL, > > > BOX_TOOLS_MAIL) . > > > > > > tep_admin_files_boxes(FILENAME_NEWSLETTERS, > BOX_TOOLS_NEWSLETTER_MANAGER) . > > > > > > tep_admin_files_boxes(FILENAME_SERVER_INFO, BOX_TOOLS_SERVER_INFO) . > > > '<a href="' . tep_href_link('csv_import.php') . '" > > > class="menuBoxContentLink">Excel/Calc Import</a><br>' . > > > > > > tep_admin_files_boxes(FILENAME_WHOS_ONLINE, BOX_TOOLS_WHOS_ONLINE)); > > > } > > > > > > $box = new box; > > > echo $box->menuBox($heading, $contents); > > > ?> > > > </td> > > > </tr> > > > <!-- tools_eof //--> > > > > > > > > > > > > > > >