Jump to content

Riedborn

Members
  • Content count

    26
  • Joined

  • Last visited

1 Follower

Profile Information

  1. Riedborn

    RSS Feed contribution support thread

    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
  2. Riedborn

    RSS Feed contribution support thread

    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
  3. 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! ===============
  4. Riedborn

    Customer Updates - Order Comments

    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
  5. Riedborn

    [contribution] "osC_GiftWrap_v1.0"

    Great! Wolfgang
  6. Riedborn

    Send as Postcard expert needed

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

    Send as Postcard expert needed

    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
  8. Riedborn

    Send as Postcard expert needed

    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
  9. Riedborn

    [contribution] "osC_GiftWrap_v1.0"

    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
  10. Riedborn

    [contribution] "osC_GiftWrap_v1.0"

    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
  11. Riedborn

    [contribution] "osC_GiftWrap_v1.0"

    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
  12. 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
  13. 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
  14. 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
  15. 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
×