Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cooldo

Members
  • Posts

    13
  • Joined

  • Last visited

Everything posted by cooldo

  1. Hi Le Quoc Hung, in // list products determined group change $products_price_query to $products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products_description.language_id = '".idJazyk($_SESSION["language"])."' and products.products_id = products_description.products_id and products.products_quantity <> 100000".$query." and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group." order by products_description.products_name"); after // get all groups add function idJazyk($dir) { $najdi = tep_db_query("select languages_id from languages where directory='".$dir."' or name='".$dir."' or code='".$dir."'"); $nalezeno = tep_db_fetch_array($najdi); return $nalezeno["languages_id"]; and change $groups_price_query to $groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent." and categories_description.language_id = '".idJazyk($_SESSION["language"])."' order by categories_description.categories_name");
  2. Hi everybody php experts, I need a contribution for my osc shop (okshop.eu) - counter on column_left, displayed sum - 10,- from every delivered order. This money I want to regulary send to Uganda kids, through the Caritas organisation (www.charita-adopce.cz). The contribution can be simple - just total sum of money or with sum sedning before. Thanks for your help. Milos wegra @email.cz P.S.: Sorry for my poor English
  3. Hi everybody php experts, I need a contribution for my osc shop (okshop.eu) - counter on column_left, displayed sum - 10,- from every delivered order. This money I want to regulary send to Uganda kids, through the Caritas organisation (www.charita-adopce.cz). The contribution can be simple - just total sum of money or with sum sedning before. Thanks for your help. Milos P.S.: Sorry for my poor English
  4. Change in print_batch_process.php part of code to: if($autoupdatestatus=='Yes') { $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 (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_short($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($autostatus) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); tep_db_query("update orders SET orders_status='" . tep_db_input($autostatus) . "' WHERE orders_id='" .$oID . "'"); } } -------------------- and copy to your languages print_batch_process.php define('EMAIL_SEPARATOR', '------------------------------------------------------'); define('EMAIL_TEXT_SUBJECT', 'Your Text'); define('EMAIL_TEXT_ORDER_NUMBER', 'Your Text: '); define('EMAIL_TEXT_INVOICE_URL', 'Your Text: '); define('EMAIL_TEXT_DATE_ORDERED', Your Text: '); define('EMAIL_TEXT_STATUS_UPDATE', 'Your Text.' . "\n\n" . 'Your Text: OK' . "\n\n" . 'Your Text.' . "\n"); define('EMAIL_TEXT_COMMENTS_UPDATE', Your Text' . "\n\n%s\n\n"); --------------------- I am not php guru, but have anybody better solution?
  5. Hi, you must set $allow_no_stock = "1"; Ahoj
  6. You must set $allow_no_stock = "1"; Bye
  7. I think -p- is for unique URL address, but Products Name + Products Model is unique too and better for SEO.
  8. I prefer model in URL instead id. For example: http://www.domain.com/mp3-player-xmodel.html (no: http://www.domain.com/mp3-player-p-42.html) Can somebody help me? Thanx. Regards from Slovakia.
  9. First of all. Mery Christmas to all (and sorry for my poor English) Can somebody help me: I prefer model in URL instead id. For example: http://www.domain.com/mp3-player-xyz.html (no: http://www.domain.com/mp3-player-p-42.html) Thanx.
  10. First of all. Mery Christmas to all (and sorry for my poor English) Can somebody help me: I prefer model in URL instead id. For example: http://www.domain.com/mp3-player-xyz.html (no: http://www.domain.com/mp3-player-p-42.html) Thanx.
×
×
  • Create New...