Riedborn

Hi Mike, you should find ORDER BY p.products_id and change it to ORDER BY products_date_added or products_last_modified Thats it. Wolfgang

Hi Hajo, I haven't installed SPPC and got the same error. The prices are lost if I call rss.php or rss.php?ecommerce=1 --> It ist always the same result. Wolfgang

Hi, I have had installed the contrib Persistent_cart 0.1 with uses a cookie to save the cart content when not logged in. This works fine! When you fill your cart unlogged and will then log in the cart is empty. Maybe only a little bug but I dont find it. Can anyone please help me because it it seems to be a great contrib when bugfree. Wolfgang Weiler Here comes the installation code Persistent Cart v0.1 Files modified for use with Order Editor: = includes/application_top.php = includes/classes/shopping_cart.php Good luck! ------------- REMEMBER- Always BACKUP everything before making any changes! If you have previously modified any of the files that are listed here for modification, you may have to do the changes manually rather than simply overwriting the code as per the instructions. ------------- ------------- STEP 1 ------------- Open includes/application_top.php ### Find near line 251: } else { tep_session_register('cart'); $cart = new shoppingCart; } *** Adter Add this: // Persistent Cart v0.1 if(isset($_COOKIE['cart'])) { //restore content $cart->contents=unserialize($_COOKIE['cart']); } ------------- STEP 2 ------------- Open includes/classes/shopping_cart.php ### Find: // reset per-session cart contents, but not the database contents $this->reset(false); $products_query = tep_db_query("select products_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "'"); while ($products = tep_db_fetch_array($products_query)) { $this->contents[$products['products_id']] = array('qty' => $products['customers_basket_quantity']); // attributes $attributes_query = tep_db_query("select products_options_id, products_options_value_id from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products['products_id']) . "'"); while ($attributes = tep_db_fetch_array($attributes_query)) { $this->contents[$products['products_id']]['attributes'][$attributes['products_options_id']] = $attributes['products_options_value_id']; } } *** Add below this: // Persistent Cart v0.1 setcookie("cart",serialize($this->contents),time()+30*24*60*60); ### Find line 104: if (is_array($attributes)) { reset($attributes); while (list($option, $value) = each($attributes)) { $this->contents[$products_id_string]['attributes'][$option] = $value; // insert into database if (tep_session_is_registered('customer_id')) tep_db_query("insert into " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " (customers_id, products_id, products_options_id, products_options_value_id) values ('" . (int)$customer_id . "', '" . tep_db_input($products_id_string) . "', '" . (int)$option . "', '" . (int)$value . "')"); } } *** Add below this: // Persistent Cart v0.1 setcookie("cart",serialize($this->contents),time()+30*24*60*60); ### Find line 136: if (is_array($attributes)) { reset($attributes); while (list($option, $value) = each($attributes)) { $this->contents[$products_id_string]['attributes'][$option] = $value; // update database if (tep_session_is_registered('customer_id')) tep_db_query("update " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " set products_options_value_id = '" . (int)$value . "' where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products_id_string) . "' and products_options_id = '" . (int)$option . "'"); } } *** Add below this: // Persistent Cart v0.1 setcookie("cart",serialize($this->contents),time()+30*24*60*60); ### Find line 153: reset($this->contents); while (list($key,) = each($this->contents)) { if ($this->contents[$key]['qty'] < 1) { unset($this->contents[$key]); // remove from database if (tep_session_is_registered('customer_id')) { tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($key) . "'"); tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($key) . "'"); } } } *** Add below this: // Persistent Cart v0.1 setcookie("cart",serialize($this->contents),time()+30*24*60*60); ###Find line 207: // assign a temporary unique ID to the order contents to prevent hack attempts during the checkout procedure $this->cartID = $this->generate_cart_id(); *** Add below this: // Persistent Cart v0.1 setcookie("cart",serialize($this->contents),time()+30*24*60*60); =============== That's it! ===============

Hi, I have just now installed this contrib into my MS1-Shop but I have got an error when trying to make a comment: Fatal error: Call to a member function on a non-object in /home/riedbornshop/www/catalog/account_history_info.php on line 63 the lines 62-64 looks like this: if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'updated')) { $messageStack->add('header', SUCCESS_ORDER_UPDATED, 'success'); } Can you help? Wolfgang

Great! Wolfgang

Hi Salvo, seems no - its not from me, I only adapted it into osC (for my purpose). Wolfgang

When you click on an image there opens a popup-window with this image. Instead of this you import this image into a postcard-program and send the image to a friend, customer... 1. Have a look at www.riedborn-apotheke.de/catalog to see if it is useful 2. Install a postcard-program like postcard-direct (pd) (http://www.ginini.com/software/postcard-direct) 3. Add your domain into the file cgi-bin/pd/admin/remotesites.txt 4. Make some changes inside catalog/product_info.php: --> change function popupWindow(url): <link rel="stylesheet" type="text/css" href="stylesheet.css"> <!-- BOF Einbau von Postcard direct - changed: scrollbars, width, height //--> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resiza ble=yes,copyhistory=no,width=800,height=600,screenX=150,screenY=150,top=150,left= 150') } //--></script> <!-- EOF Einbau von Postcard direct //--> </head> --> change the call of this function about line 100: <!-- BOF use of Postcard direct - don't forget to change the function popupWindow: scrollbars, width, height //--> <script language="javascript"><!-- document.write('<?php echo '<a href="java script:popupWindow('/cgi-bin/pd/pd.cgi?image=' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '&title=' . $product_info['products_name'] . '')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="/cgi-bin/pd/pd.cgi?image=' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> <!-- EOF use of Postcard direct //--> ---------- Wolfgang

Hi, I solved the problem. Look at www.riedborn-apotheke.de/catalog and use some image to send as a postcard. When it is useful, I can post the code here! Wolfgang

Hi Randy, ...better but not ok: The customer orders giftwrap for 1,- but in the total listing there is 1,16 ! Wolfgang And the tax included ist without the tax of giftwrap

Hi Randy, once again in english - I hope the translation ist readable... I installed it, but there es a tax problem unsolved (MS1, tax included, giftwrap = 1,-): 1 x SPRING Deltarad 191,74? (giftwrap): 1,16? German Post (Dispatch to DE: (1 x 3 kg)): 5,92? cod (cost on delivery): 4,15? subtotal: 191,74? tax included 16%: 27,84? 16: 0,16? <-- tax from giftwrap! total: 202,97? -------------------- Module sort Status Action cod 3 Giftwrap 1 shipping 2 subtotal 4 tax 5 total 6 ------------------- Wolfgang

Hi Randy, I installed it, but there es a tax problem unsolved (MS1, tax included, giftwrap = 1,-): 1 x SPRING Deltarad 191,74? (Geschenkverpackung): 1,16? Deutsche Post (Versand nach DE: (1 x 3 kg)): 5,92? Nachnahmegeb?hr: 4,15? Zwischensumme: 191,74? enthaltene MwSt. 16%: 27,84? 16: 0,16? Summe: 202,97? -------------------- Module Reihenfolge Status Aktion Nachnahmegeb?hr 3 Giftwrap 1 Mindermengenzuschlag Versandkosten 2 Zwischensumme 4 MwSt. 5 Summe 6 ------------------- Wolfgang

Hi, I installed the contrib update_order_utilityv133ger and I get a fatal error, when I click on the drop-down menu to choose an order: Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 12 bytes) in /home/riedborn-apotheke/www/admin/oscommerce/update_order.php on line 762 Can anyone help? Wolfgang

Hi, I installed it, but I got the following error when I use the browser (chmod = 777): Updated on Wed Jul 30 22:55:19 2003 CHF, xe, error USD, xe, error GBP, xe, error EUR, xe, error Anyone any idea? Wolfgang

Hi, I've installed it, but I'll get an error when I try to print out: 1054 - Unknown column 'shipping_cost' in 'field list' select date_purchased, orders_status, last_modified, shipping_cost, shipping_method,comments from orders where orders_id = '3' [TEP STOP] Can anyone help? Wolfgang

The problem is you see the link with a wrong filename (EPEP): /catalog/temp/EPEP2003Jul27-1503.txt ^^^^ the realy filename is EP2003... (only one EP) Wolfgang

Hi, the contrib. quick_priceupdates has incluced the wrong file: quick_stockupdate.php instead of quick_priceupdates.php. It gives an error! Where can I get the file quick_priceupdates.php? Wolfgang

Hi, when I produce a file in the temp-dir I'll get the following link with twice EPEP instead of once EP: You can get your file in the Tools/Files under /catalog/temp/EPEP2003Jul27-1503.txt Wolfgang

VJ -> Thats it! Thanks a lot!!! Wolfgang

Hi, I got the following error - can anyone help me? Wolfgang ------------------------------- Fatal error: Failed opening required 'DIR_WS_FUNCTIONSheader_tags.php' (include_path='.:..') in /home/riedborn-apotheke/www/catalog/includes/application_top.php on line 19 ------------------------------- My code in applicaton_top.php: <?php /* $Id: application_top.php,v 1.264 2003/02/17 16:37:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // CATALOG_PRODUCTS_WITH_IMAGES_mod # START Printable Catalog V 2.3 define('FILENAME_CATALOG_PRODUCTS_WITH_IMAGES', 'catalog_products_with_images.php'); # END Printable Catalog V 2.3 // BOF: WebMakers.com Added: Header Tags Controller v1.0 require(DIR_WS_FUNCTIONS . 'header_tags.php'); // Clean out HTML comments from ALT tags etc. require(DIR_WS_FUNCTIONS . 'clean_html_comments.php'); // Also used by: WebMakers.com Added: FREE-CALL FOR PRICE // EOF: WebMakers.com Added: Header Tags Controller v1.0 // start the timer for the page parse time log define('PAGE_PARSE_START_TIME', microtime());