Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ernstie

Archived
  • Posts

    4
  • Joined

  • Last visited

Posts posted by ernstie

  1. hello i am too stupid i think....

     

    i have load all files to the server. my destination is shop/googlesitemap/index.php

     

    If i start this i get the failure down....

     

    has someone a solution?

     

     

    Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1990 is not allowed to access / owned by uid 0 in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

     

    Warning: fopen(/sitemapproducts.xml) [function.fopen]: failed to open stream: No such file or directory in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

    ERROR: Google Product Sitemap Generation FAILED!

     

     

    Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1990 is not allowed to access / owned by uid 0 in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

     

    Warning: fopen(/sitemapcategories.xml) [function.fopen]: failed to open stream: No such file or directory in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

    ERROR: Google Category Sitemap Generation FAILED!

     

     

    Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1990 is not allowed to access / owned by uid 0 in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

     

    Warning: fopen(/sitemapmanufacturers.xml) [function.fopen]: failed to open stream: No such file or directory in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

    ERROR: Google Manufacturer Sitemap Generation FAILED!

     

     

    Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1990 is not allowed to access / owned by uid 0 in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

     

    Warning: fopen(/sitemapspecials.xml) [function.fopen]: failed to open stream: No such file or directory in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

    ERROR: Google Specials Sitemap Generation FAILED!

     

     

    Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 1990 is not allowed to access / owned by uid 0 in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

     

    Warning: fopen(/sitemapindex.xml) [function.fopen]: failed to open stream: No such file or directory in /var/www/web564/html/googlesitemap/sitemap.class.php on line 300

    ERROR: Google Sitemap Index Generation FAILED!

     

    Array

    (

    [QUERY] => Array

    (

    [PRODUCTS] => Array

    (

    [sTATUS] => success

    [NUM_ROWS] => 12625

    )

     

    [CATEOGRY] => Array

    (

    [sTATUS] => success

    [NUM_ROWS] => 320

    )

     

    [MANUFACTURERS] => Array

    (

    [sTATUS] => success

    [NUM_ROWS] => 283

    )

     

    [sPECIALS] => Array

    (

    [sTATUS] => success

    [NUM_ROWS] => 56

    )

     

    )

     

    [sAVE_FILE_XML] => Array

    (

    [0] => Array

    (

    [file] => /sitemapproducts.xml

    [status] => failure

    [file_exists] => false

    )

     

    [1] => Array

    (

    [file] => /sitemapcategories.xml

    [status] => failure

    [file_exists] => false

    )

     

    [2] => Array

    (

    [file] => /sitemapmanufacturers.xml

    [status] => failure

    [file_exists] => false

    )

     

    [3] => Array

    (

    [file] => /sitemapspecials.xml

    [status] => failure

    [file_exists] => false

    )

     

    [4] => Array

    (

    [file] => /sitemapindex.xml

    [status] => failure

    [file_exists] => false

    )

     

    )

     

    )

  2. Hallo, ich habe heuer order_editor_5_0_61 installiert, Laufen tuts, aber er wirft mir auf der Detailseite einen Fehler aus. der sieht so aus:

    get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . ''; ?>

    DAS KOMMT GANZ OBEN AUF DER SITE, und dann gehts normal weiter mit:

    Bestellungen

    xxxxxxxxxx

    xxxxxxxxxx

    xxxxxxxxxx

    Deutschland

    Telefonnummer: xxxxxxxxxxx

    eMail Adresse: xxxxxxxxxx

    Versandadresse: xxxxxxxxxxxxxxxxxxxx

    xxxxxxxxxx.46

    xxxxxxxxxx

    Deutschland

    Rechnungsadresse: xxxxxxxxxx

    xxxxxxxxxx

    xxxxxxxxxx

    Deutschland

    ICH WEISS; DASS DER CODE MEHRFACH IN DER ORDER.PHP VORKOMMT; ICH FINDE DEN FEHLER ALLERDINGS NICHT: HIER MEINE ORDERS.PhP

    <?php

    /*

    $Id: orders.php,v 1.112 2003/06/29 22:50:52 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();

    $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 = '" . (int)$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'];

    }

    $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

    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 . "'");

    $customer_notified = '0';

    if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) {

    $notify_comments = '';

    if (isset($HTTP_POST_VARS['notify_comments']) && ($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, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

    $customer_notified = '1';

    }

    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;

    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 (($action == 'edit') && isset($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 = '" . (int)$oID . "'");

    $order_exists = true;

    if (!tep_db_num_rows($orders_query)) {

    $order_exists = false;

    $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');

    }

    }

    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">

    <script language="javascript" src="includes/general.js"></script>

    </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 (($action == 'edit') && ($order_exists == true)) {

    $order = new order($oID);

    ?>

    <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 class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $_GET['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $_GET['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>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">

    <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 colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

    </tr>

    <tr>

    <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></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>

    </table></td>

    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <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>

    </table></td>

    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <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>

    </table></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"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>

    <td class="main"><?php echo $order->info['payment_method']; ?></td>

    </tr>

    <?php

    if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($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_EXPIRES; ?></td>

    <td class="main"><?php echo $order->info['cc_expires']; ?></td>

    </tr>

    <?php

    }

    ?>

    </table></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 class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>

    <td class="dataTableHeadingContent" align="right"><?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 (isset($order->products[$i]['attributes']) && (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($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

    ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></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="8"><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><?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_DATE_ADDED; ?></b></td>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>

    <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>

    </tr>

    <?php

    $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added");

    if (tep_db_num_rows($orders_history_query)) {

    while ($orders_history = tep_db_fetch_array($orders_history_query)) {

    echo ' <tr>' . "\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) . "</td>\n";

    } else {

    echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";

    }

    echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" .

    ' <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" .

    ' </tr>' . "\n";

    }

    } else {

    echo ' <tr>' . "\n" .

    ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .

    ' </tr>' . "\n";

    }

    ?>

    </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'); ?></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>

    </tr>

    </table></td>

    <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>

    </tr>

    </table></td>

    </form></tr>

    <tr>

    <!-- Neu -->

    <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $_GET['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $_GET['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $_GET['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', 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 (isset($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 = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";

    } elseif (isset($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 = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$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 = '" . (int)$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 ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {

    $oInfo = new objectInfo($orders);

    }

    if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {

    echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" 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="rowOverEffect(this)" onmouseout="rowOutEffect(this)" 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 (isset($oInfo) && 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 ($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 (isset($oInfo) && 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_details.gif', IMAGE_DETAILS) . '</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>');

    $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> <a href="' . tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $oInfo->orders_id) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</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'); ?>

  3. Hello i have insert SEO URL since 3 Months at my shop www.bekleidungskammer.de but nothing happened. It is more so that my site is at pages more back... before i found my articles at site 3-4 now at page 11-12 ... why this? Dont google find this headers?

     

    please help me. thanks

  4. Hello i downloaded the last version of seo. i have only installed the normal version without the additional_install. first i thought all runs good. but now i wanted to work in my shop and i got this problems.

     

    Nachricth

     

    Fatal error: Call to undefined function: tep_get_category_seo_url() in /var/www/web564/html/admin/categories.php on line 939

     

     

    TEXT_PRODUCTS_SEO_URL

    Fatal error: Call to undefined function: tep_get_products_seo_url() in /var/www/web564/html/admin/categories.php on line 529

     

    the shop does not start. i cannot open it. i have deleted the categories (the new one from you) and take my old one! then the shop runs. Is it neccessary to add the new categories? i think so ;-)

     

    my shop is www.bekleidungskammer.de

     

    Please help me... heres my old categories from Admin/categories:

     

    <?php

    /*

    $Id: categories.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']);

    }

     

    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' => $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'];

     

    $language_id = $languages[$i]['id'];

     

    $sql_data_array = array('categories_name' => tep_db_prepare_input($categories_name_array[$language_id]));

     

    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'] . "'");

    }

    }

     

    if ($categories_image = new upload('categories_image', DIR_FS_CATALOG_IMAGES)) {

    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' => 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']),

    'manufacturers_id' => 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'];

     

    $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]));

     

    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(), '" . 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();

     

    $description_query = tep_db_query("select language_id, products_name, products_description, 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_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_url']) . "', '0')");

    }

     

    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;

    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'] : '');

    }

    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 == 'new_product') {

    $parameters = array('products_name' => '',

    'products_description' => '',

    'products_url' => '',

    'products_id' => '',

    'products_quantity' => '',

    'products_model' => '',

    'products_image' => '',

    'products_price' => '',

    'products_weight' => '',

    'products_date_added' => '',

    'products_last_modified' => '',

    'products_date_available' => '',

    'products_status' => '',

    'products_tax_class_id' => '',

    'manufacturers_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_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, 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, p.manufacturers_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_description = $HTTP_POST_VARS['products_description'];

    $products_url = $HTTP_POST_VARS['products_url'];

    }

     

    $manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE));

    $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");

    while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {

    $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'],

    'text' => $manufacturers['manufacturers_name']);

    }

     

    $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_CATEGORIES, '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_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_MANUFACTURER; ?></td>

    <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_pull_down_menu('manufacturers_id', $manufacturers_array, $pInfo->manufacturers_id); ?></td>

    </tr>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <?php

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

    ?>

    <tr>

    <td class="main"><?php if ($i == 0) echo TEXT_PRODUCTS_NAME; ?></td>

    <td class="main"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . tep_draw_input_field('products_name[' . $languages[$i]['id'] . ']', (isset($products_name[$languages[$i]['id']]) ? $products_name[$languages[$i]['id']] : tep_get_products_name($pInfo->products_id, $languages[$i]['id']))); ?></td>

    </tr>

    <?php

    }

    ?>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <tr bgcolor="#ebebff">

    <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, 'onchange="updateGross()"'); ?></td>

    </tr>

    <tr bgcolor="#ebebff">

    <td class="main"><?php echo TEXT_PRODUCTS_PRICE_NET; ?></td>

    <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price', $pInfo->products_price, 'onKeyUp="updateGross()"'); ?></td>

    </tr>

    <tr bgcolor="#ebebff">

    <td class="main"><?php echo TEXT_PRODUCTS_PRICE_GROSS; ?></td>

    <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price_gross', $pInfo->products_price, 'OnKeyUp="updateNet()"'); ?></td>

    </tr>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <script language="javascript"><!--

    updateGross();

    //--></script>

    <?php

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

    ?>

    <tr>

    <td class="main" valign="top"><?php if ($i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>

    <td><table border="0" cellspacing="0" cellpadding="0">

    <tr>

    <td class="main" valign="top"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?> </td>

    <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? $products_description[$languages[$i]['id']] : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td>

    </tr>

    </table></td>

    </tr>

    <?php

    }

    ?>

    <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_MODEL; ?></td>

    <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_model', $pInfo->products_model); ?></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 colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

    </tr>

    <?php

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

    ?>

    <tr>

    <td class="main"><?php if ($i == 0) echo TEXT_PRODUCTS_URL . '<br><small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>'; ?></td>

    <td class="main"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . tep_draw_input_field('products_url[' . $languages[$i]['id'] . ']', (isset($products_url[$languages[$i]['id']]) ? $products_url[$languages[$i]['id']] : tep_get_products_url($pInfo->products_id, $languages[$i]['id']))); ?></td>

    </tr>

    <?php

    }

    ?>

    <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_CATEGORIES, '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_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_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, 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;

    }

     

    $form_action = (isset($HTTP_GET_VARS['pID'])) ? 'update_product' : 'insert_product';

     

    echo tep_draw_form($form_action, FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"');

     

    $languages = tep_get_languages();

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

    if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) {

    $pInfo->products_name = tep_get_products_name($pInfo->products_id, $languages[$i]['id']);

    $pInfo->products_description = tep_get_products_description($pInfo->products_id, $languages[$i]['id']);

    $pInfo->products_url = tep_get_products_url($pInfo->products_id, $languages[$i]['id']);

    } else {

    $pInfo->products_name = tep_db_prepare_input($products_name[$languages[$i]['id']]);

    $pInfo->products_description = tep_db_prepare_input($products_description[$languages[$i]['id']]);

    $pInfo->products_url = tep_db_prepare_input($products_url[$languages[$i]['id']]);

    }

    ?>

    <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 tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . $pInfo->products_name; ?></td>

    <td class="pageHeading" align="right"><?php echo $currencies->format($pInfo->products_price); ?></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 tep_image(DIR_WS_CATALOG_IMAGES . $products_image_name, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="right" hspace="5" vspace="5"') . $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>

    <?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_CATEGORIES;

    $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)));

    }

    }

    $languages = tep_get_languages();

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

    echo tep_draw_hidden_field('products_name[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_name[$languages[$i]['id']])));

    echo tep_draw_hidden_field('products_description[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_description[$languages[$i]['id']])));

    echo tep_draw_hidden_field('products_url[' . $languages[$i]['id'] . ']', htmlspecialchars(stripslashes($products_url[$languages[$i]['id']])));

    }

    echo tep_draw_hidden_field('products_image', stripslashes($products_image_name));

     

    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_CATEGORIES, '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>

    <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="smallText" align="right">

    <?php

    echo tep_draw_form('search', FILENAME_CATEGORIES, '', 'get');

    echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('search');

    echo '</form>';

    ?>

    </td>

    </tr>

    <tr>

    <td class="smallText" align="right">

    <?php

    echo tep_draw_form('goto', FILENAME_CATEGORIES, '', 'get');

    echo HEADING_TITLE_GOTO . ' ' . tep_draw_pull_down_menu('cPath', tep_get_category_tree(), $current_category_id, 'onChange="this.form.submit();"');

    echo '</form>';

    ?>

    </td>

    </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_CATEGORIES_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

    $categories_count = 0;

    $rows = 0;

    if (isset($HTTP_GET_VARS['search'])) {

    $search = tep_db_prepare_input($HTTP_GET_VARS['search']);

     

    $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name");

    } else {

    $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by c.sort_order, cd.categories_name");

    }

    while ($categories = tep_db_fetch_array($categories_query)) {

    $categories_count++;

    $rows++;

     

    // Get parent_id for subcategories if search

    if (isset($HTTP_GET_VARS['search'])) $cPath= $categories['parent_id'];

     

    if ((!isset($HTTP_GET_VARS['cID']) && !isset($HTTP_GET_VARS['pID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $categories['categories_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) {

    $category_childs = array('childs_count' => tep_childs_in_category_count($categories['categories_id']));

    $category_products = array('products_count' => tep_products_in_category_count($categories['categories_id']));

     

    $cInfo_array = array_merge($categories, $category_childs, $category_products);

    $cInfo = new objectInfo($cInfo_array);

    }

     

    if (isset($cInfo) && is_object($cInfo) && ($categories['categories_id'] == $cInfo->categories_id) ) {

    echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, tep_get_path($categories['categories_id'])) . '\'">' . "\n";

    } else {

    echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories['categories_id']) . '\'">' . "\n";

    }

    ?>

    <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, tep_get_path($categories['categories_id'])) . '">' . tep_image(DIR_WS_ICONS . 'folder.gif', ICON_FOLDER) . '</a> <b>' . $categories['categories_name'] . '</b>'; ?></td>

    <td class="dataTableContent" align="center"> </td>

    <td class="dataTableContent" align="right"><?php if (isset($cInfo) && is_object($cInfo) && ($categories['categories_id'] == $cInfo->categories_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories['categories_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

    </tr>

    <?php

    }

     

    $products_count = 0;

    if (isset($HTTP_GET_VARS['search'])) {

    $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id 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 pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name");

    } else {

    $products_query = tep_db_query("select p.products_id, pd.products_name, 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++;

     

    // Get categories_id for product if search

    if (isset($HTTP_GET_VARS['search'])) $cPath = $products['categories_id'];

     

    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_CATEGORIES, '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_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '\'">' . "\n";

    }

    ?>

    <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, '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_CATEGORIES, '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_CATEGORIES, '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_CATEGORIES, '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 . '&' : '';

    ?>

    <tr>

    <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td class="smallText"><?php echo TEXT_CATEGORIES . ' ' . $categories_count . '<br>' . TEXT_PRODUCTS . ' ' . $products_count; ?></td>

    <td align="right" class="smallText"><?php if (sizeof($cPath_array) > 0) echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, $cPath_back . 'cID=' . $current_category_id) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> '; if (!isset($HTTP_GET_VARS['search'])) echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_category') . '">' . tep_image_button('button_new_category.gif', IMAGE_NEW_CATEGORY) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&action=new_product') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>'; ?> </td>

    </tr>

    </table></td>

    </tr>

    </table></td>

    <?php

    $heading = array();

    $contents = array();

    switch ($action) {

    case 'new_category':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_CATEGORY . '</b>');

     

    $contents = array('form' => tep_draw_form('newcategory', FILENAME_CATEGORIES, 'action=insert_category&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"'));

    $contents[] = array('text' => TEXT_NEW_CATEGORY_INTRO);

     

    $category_inputs_string = '';

    $languages = tep_get_languages();

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

    $category_inputs_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . tep_draw_input_field('categories_name[' . $languages[$i]['id'] . ']');

    }

     

    $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_NAME . $category_inputs_string);

    $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image'));

    $contents[] = array('text' => '<br>' . TEXT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', '', 'size="2"'));

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    case 'edit_category':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_CATEGORY . '</b>');

     

    $contents = array('form' => tep_draw_form('categories', FILENAME_CATEGORIES, 'action=update_category&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"') . tep_draw_hidden_field('categories_id', $cInfo->categories_id));

    $contents[] = array('text' => TEXT_EDIT_INTRO);

     

    $category_inputs_string = '';

    $languages = tep_get_languages();

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

    $category_inputs_string .= '<br>' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . tep_draw_input_field('categories_name[' . $languages[$i]['id'] . ']', tep_get_category_name($cInfo->categories_id, $languages[$i]['id']));

    }

     

    $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_NAME . $category_inputs_string);

    $contents[] = array('text' => '<br>' . tep_image(DIR_WS_CATALOG_IMAGES . $cInfo->categories_image, $cInfo->categories_name) . '<br>' . DIR_WS_CATALOG_IMAGES . '<br><b>' . $cInfo->categories_image . '</b>');

    $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image'));

    $contents[] = array('text' => '<br>' . TEXT_EDIT_SORT_ORDER . '<br>' . tep_draw_input_field('sort_order', $cInfo->sort_order, 'size="2"'));

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    case 'delete_category':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_CATEGORY . '</b>');

     

    $contents = array('form' => tep_draw_form('categories', FILENAME_CATEGORIES, 'action=delete_category_confirm&cPath=' . $cPath) . tep_draw_hidden_field('categories_id', $cInfo->categories_id));

    $contents[] = array('text' => TEXT_DELETE_CATEGORY_INTRO);

    $contents[] = array('text' => '<br><b>' . $cInfo->categories_name . '</b>');

    if ($cInfo->childs_count > 0) $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_CHILDS, $cInfo->childs_count));

    if ($cInfo->products_count > 0) $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $cInfo->products_count));

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    case 'move_category':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_MOVE_CATEGORY . '</b>');

     

    $contents = array('form' => tep_draw_form('categories', FILENAME_CATEGORIES, 'action=move_category_confirm&cPath=' . $cPath) . tep_draw_hidden_field('categories_id', $cInfo->categories_id));

    $contents[] = array('text' => sprintf(TEXT_MOVE_CATEGORIES_INTRO, $cInfo->categories_name));

    $contents[] = array('text' => '<br>' . sprintf(TEXT_MOVE, $cInfo->categories_name) . '<br>' . tep_draw_pull_down_menu('move_to_category_id', tep_get_category_tree(), $current_category_id));

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_move.gif', IMAGE_MOVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    case 'delete_product':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_PRODUCT . '</b>');

     

    $contents = array('form' => tep_draw_form('products', FILENAME_CATEGORIES, '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_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    case 'move_product':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_MOVE_PRODUCT . '</b>');

     

    $contents = array('form' => tep_draw_form('products', FILENAME_CATEGORIES, 'action=move_product_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id));

    $contents[] = array('text' => sprintf(TEXT_MOVE_PRODUCTS_INTRO, $pInfo->products_name));

    $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENT_CATEGORIES . '<br><b>' . tep_output_generated_category_path($pInfo->products_id, 'product') . '</b>');

    $contents[] = array('text' => '<br>' . sprintf(TEXT_MOVE, $pInfo->products_name) . '<br>' . tep_draw_pull_down_menu('move_to_category_id', tep_get_category_tree(), $current_category_id));

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_move.gif', IMAGE_MOVE) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    case 'copy_to':

    $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_COPY_TO . '</b>');

     

    $contents = array('form' => tep_draw_form('copy_to', FILENAME_CATEGORIES, 'action=copy_to_confirm&cPath=' . $cPath) . tep_draw_hidden_field('products_id', $pInfo->products_id));

    $contents[] = array('text' => TEXT_INFO_COPY_TO_INTRO);

    $contents[] = array('text' => '<br>' . TEXT_INFO_CURRENT_CATEGORIES . '<br><b>' . tep_output_generated_category_path($pInfo->products_id, 'product') . '</b>');

    $contents[] = array('text' => '<br>' . TEXT_CATEGORIES . '<br>' . tep_draw_pull_down_menu('categories_id', tep_get_category_tree(), $current_category_id));

    $contents[] = array('text' => '<br>' . TEXT_HOW_TO_COPY . '<br>' . tep_draw_radio_field('copy_as', 'link', true) . ' ' . TEXT_COPY_AS_LINK . '<br>' . tep_draw_radio_field('copy_as', 'duplicate') . ' ' . TEXT_COPY_AS_DUPLICATE);

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_copy.gif', IMAGE_COPY) . ' <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    default:

    if ($rows > 0) {

    if (isset($cInfo) && is_object($cInfo)) { // category info box contents

    $heading[] = array('text' => '<b>' . $cInfo->categories_name . '</b>');

     

    $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=edit_category') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=delete_category') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=move_category') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a>');

    $contents[] = array('text' => '<br>' . TEXT_DATE_ADDED . ' ' . tep_date_short($cInfo->date_added));

    if (tep_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . tep_date_short($cInfo->last_modified));

    $contents[] = array('text' => '<br>' . tep_info_image($cInfo->categories_image, $cInfo->categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT) . '<br>' . $cInfo->categories_image);

    $contents[] = array('text' => '<br>' . TEXT_SUBCATEGORIES . ' ' . $cInfo->childs_count . '<br>' . TEXT_PRODUCTS . ' ' . $cInfo->products_count);

    } elseif (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_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=delete_product') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=move_product') . '">' . tep_image_button('button_move.gif', IMAGE_MOVE) . '</a> <a href="' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=copy_to') . '">' . tep_image_button('button_copy_to.gif', IMAGE_COPY_TO) . '</a>');

    $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_PRICE_INFO . ' ' . $currencies->format($pInfo->products_price) . '<br>' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity);

    $contents[] = array('text' => '<br>' . TEXT_PRODUCTS_AVERAGE_RATING . ' ' . number_format($pInfo->average_rating, 2) . '%');

    }

    } else { // create category/product info

    $heading[] = array('text' => '<b>' . EMPTY_CATEGORY . '</b>');

     

    $contents[] = array('text' => TEXT_NO_CHILD_CATEGORIES_OR_PRODUCTS);

    }

    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'); ?>

  5. Hello i am interested in writing invoices for my ebay auctions and import them automatically to my os commerce shop (bekleidungskammer.de) how can i do this? does there are a contribution? Does this fit the rules of a merchant invoice (number, duty number of me, date, shipping date and so on)

     

    hallo ich bin an einem Tool interessiert mit dem ich ebay auktionen bei mir im os commerce shop bearbeiten kann. gibt es da eine contribution? h?llt diese die finanzamtrechtlichen regeln ein? so wie fortlaufende nummer, datum, steuernummer, adresse, frachtadresse usw?

     

    dANKE F?R EURE HILFE UND SCHAUT EUCH BITTE MAL www.bekleidungskammer.de an.

     

    eure antworten k?nnte ihr auch an [email protected] schicken

     

    your answer can also be send to my email [email protected]

     

    ____________________________

    ps: WHO can help me to list my shop better in google? for example if i search for surefire and search in only germany i am on site 5. And i am one of 6-8 sellers in germany of this flashlights? i have installed contribution but this does not change the tilte of the site to the item name. HELP THANKs

×
×
  • Create New...