Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by ianric

  1. ianric

    Activate inactivate categories

    Hi Sorry to hijack another post but my prob is similar with the same contrib. Did anyone have an answer to this?? I've got it all working except for the specials and new_products pages (boxes seem to be OK). If I have a hidden category, when I pick on the arrow in the box heading I get a 1064 error 26 & 53 are my hidden category id's. I'm also using the default specials.php from RC2.2a, PHP 5.3 and mysql 5.1.37 I can't find that SQL anywhere in my files. This is what the contrib install says for the specials page If I var_dump() the contents of the new SQL, I get Pasting that into phpmyadmin works, no errors. I've tried the various fixes on the contrib page but non have worked. It's probably something easy. Any help would be appreciated. Many thanks Ian
  2. ianric

    Official PayPal IPN Support Thread

    Edit: By "which version" I mean verson 2.3.4, 3.1, 3.6, version 3, 3.01 etc
  3. ianric

    Official PayPal IPN Support Thread

    Hi A very easy question which has probably been asked and answered over and over but I can't find the answer. I am using Paypal 1.3 with MS2.2 and all is well with the live shop. I am also upgrading to RC2.2a and PHP 5.3 which I'm using xampp, if that makes a difference. I'm hosted on a Windows server but will be moving to Linux. There's so many versions, which one do I install? :'( I'm happy with 1.3, if it works, don't fix it, but will it work with RC2.2a? Hope someone could answer Thanks Ian
  4. Panic over. It's fixed. It was me :blush: Took the files into the office today and it worked?? :'( Found I had turned all the cache off in admin. Need to do a bit more work for my original problem of custom field in URL Cheers Ian
  5. Hi Jack Thanks for the reply. Unfortunatly, adding a new manufacturer didn't work. I've had a look at the contrib download page and tried the fixes suggested but none worked. I then decided to overwrite your Ultimate SEO 2-2.2d-5 seo_class with the version from Shadowrider, 10 Feb 2009. I got a few depreciated errors because I'm using PHP 5.3 but that version worked. I couldn't get the suggested SQL fix in the install instructions to work tho. I tried replacing code from the Shadowrider seo_class into yours but it still failed. Any ideas where I should look? Thanks Ian
  6. Hi Steve Many thanks for getting back to me. That code was slightly different from mine but I found the right place and my custom title field now shows in the URL. Yessss!! Two more tweaks for someone to help me with. The first is very minor. How do I make the URL so that the product_id is at the beginning of the URL instead of the category name? As in mysite.com/artists-a-z-p-101-product_name.html. I think this is in the .htaccess file?? And the other is my manufacturer name doesn't appear in the URL, its just mysite.com/-m-12.html. I'm a music site and my categories set up as Artists A-F, Artists G-L etc and my manufacturers are genres, pop, rock, hip hop etc. Categories show up fine and are displayed first Any ideas anyone? Thanks again Ian
  7. Still no answer?? It must be possible. Anyway, solved the ampersand problem by replacing them with and in the database. Just noticed a fix in the contrib download area. Please someone, anyone, is there a way of adding a custom field to the URL. I can't solve it TIA Ian
  8. Hi I've installed Ultimate SEO 2-2.2d-4 and just 2 slight problems. The first is the ampersand. How do I get it to show in the URL? I've tried the char=> and set to different combinations of &amp but can't get it to show. I've also set the filter short words to 0, 1, 2, 3, -1 but that didn't work either. The second is the product_name in the URL. My site is a music site and at the moment, my product_name is the artist. Thats all thats showing. I need to have the title in there aswell. I've added new fields in products and products_description to the database and in most of the SQL in OSC, I can add to and get my new fields out. I can't work out the code in this contrib so just need a pointer as to where to look I'm guessing its here function get_product_name($pID){ $result = array(); if ($this->attributes['SEO_ADD_CPATH_TO_PRODUCT_URLS']) { $cName = $this->get_all_category_parents($pID, $cName); } switch(true){ case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && defined('PRODUCT_NAME_' . $pID)): $this->performance['CACHE_QUERY_SAVINGS']++; $return = (tep_not_null($cName) ? $cName . '-'. constant('PRODUCT_NAME_' . $pID) : constant('PRODUCT_NAME_' . $pID)); $this->cache['PRODUCTS'][$pID] = $return; break; case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && isset($this->cache['PRODUCTS'][$pID])): $this->performance['CACHE_QUERY_SAVINGS']++; $return = (tep_not_null($cName) ? $cName . '-'. $this->cache['PRODUCTS'][$pID] : $this->cache['PRODUCTS'][$pID]); break; default: $this->performance['NUMBER_QUERIES']++; $sqlCmd = $this->attributes['USE_SEO_HEADER_TAGS'] == 'true' ? 'products_name as pName' : 'products_name as pName'; $sql = "SELECT " . $sqlCmd . " . ** Do I add "select field1, field2 here?? ** FROM ".TABLE_PRODUCTS_DESCRIPTION." WHERE products_id='".(int)$pID."' AND language_id='".(int)$this->languages_id."' LIMIT 1"; $result = $this->DB->FetchArray( $this->DB->Query( $sql ) ); $pName = $this->strip( $result['pName'] ); [b]** Do I add to $result here? **[/b] $this->cache['PRODUCTS'][$pID] = $pName; $this->performance['QUERIES']['PRODUCTS'][] = $sql; $return = (tep_not_null($cName) ? $cName . '-'. $pName : $pName); break; } # end switch return $return; } # end function Thanks in advance Sorry, the colours and bold don't work for me Ian
  9. ianric

    Sitemap SEO

    Hi I installed the contrib and all is OK. I managed to solve the &$links code but I am now getting the "Unable to determine page link error". I'm running local with wampserver2.0 and all is well until I add the information box in Admin. I refresh the catalog sitemap page and the error happens. It's NOT the Search Engine Friendly option being set. Any ideas?? Also, to have the page look like the screenshot, do I need to install the 3 contribs mentioned?? Sorry if someone has answered. Many thanks Ian
  10. Hi Me again, Just searched for my post and found a few others asking the same about the specials listing. Thought I'd let everyone know that it can be done. All I did was open products_new.php and save it as specials.php (backup original first of course). then I merged the specials and new_products SQL. This is MY SQL with MY EXTRA FIELDS. The important bit is the $sort_sql $products_new_query_raw = "select p.products_date_added, p.products_id, pd.products_name, pd.products_title, p.products_media, p.products_model, p.products_category, p.products_label, p.products_catno, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, m.manufacturers_name, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_quantity = '1' and p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and s.status = '1' and pd.language_id = '" . (int)$languages_id . "'" . $sort_sql; Change the breadcrumb and language file at the top and leave everything as is. I THINK thats all I did and it works for me. I can't guarentee it working for anyone else but it's a start for anyone who wants to try Thanks for a great contrib Ian
  11. Hi I have installed the contrib and have a question about the results per page option that maybe someone else has come across and fixed. Its defaulted to 20 per page, you change to another value, say 40, and the dropdown list value goes back to 20. I can't find a way to go back to 20 results per page. Maybe the value should stay at 40 per page and then you can select 20 from the dropdown and go back to 20 per page Many thanks Ian
  12. ianric

    Country-State Selector

    Me again. Solved this too. I googled ajax images and found some that rotate anti clockwise, I've only seen clockwise versions. Anyway, solved, I downloaded a horiz bar and all is OK Cheers Ian
  13. ianric

    RMA Returns error for 2.2 MS2

    Still no answers?? I still can't get this bit to work properly. The admin side still works tho. I am redesigning starting from scratch with 2.2rc2a and installing same contribs. I found 1.3 wishlist contrib gave a parse error but couldn't see what was wrong, I am using it on my live store and it all works. Anyway, when I looked closer the contrib coder used a mix of PHP short open tags ie some were <? and others were <?php I even enabled short open tags in my php.ini file but it still didn't work so I replaced all the <? in each file and it worked. This contrib has been written the same. Stacks of short tags mixed with normal tags. I thought I'd cracked it but unfortunatly it still didn't work when I corrected all the <? although I haven't used the fix suggested earlier in the forum. Not really expecting it to work :blink: Maybe that's a clue to solving this prob. Hope some one can solve. @ newbieonekenobie - I found the same. I replaced the code anyway and it seemed to work. Not sure if it's 100% because of this login error but try it, can't hurt Cheers Ian
  14. ianric

    Graphical Borders

    Hi Just wondering if the size of the borders and the top heading tab can be changed. Reading through the thread, the colours etc can be changed, in Photoshop or Paintshop Pro, I assume. That is OK, I think I can work that out but is there any code to the mws.?? styles I need to change? Cheers Ian
  15. Still no answer. Surely someone out there can answer this Ian
  16. ianric

    Country-State Selector

    Hi Thanks to everyone who "helped" but I managed to get it working on my self. I forgot to add the css info. :blush: The image still spins anti-clockwise but I can live with that. Is it possible to collapse the div? At the moment it is leaving a gap the height of the image on the page Cheers ian
  17. ianric

    Country-State Selector

    Hi Just thought I'd say thanks for the above fix. It worked for me Cheers ian
  18. ianric

    Country-State Selector

    Hi I've installed the 1.5.5 ajax version but when I go to create an account or any address page I get the spinning image in the left corner just under the breadcrumb and it spins forever. I then change my country, that works and the state is populated then the image disappears. Isn't that back to front?? Edit: I'm on version rc2a and copied the included files over as it's an empty development store Hope someone can point me in the right direction Cheers Ian
  19. Hi I've modded my specials page to display in a list like the main product listing. Is it possible to add the sort order and results per page to the specials page? If you have a look at My Website you'll see sthe styling. Specials.php looks the same Hope that makes sense Cheers Ian
  20. ianric

    Official PayPal IPN Support Thread

    Hi This has happend to me today. No changes made since Nov '07. Just installed HTML emails so testing. Everything works, it all goes thru to Paypal, even the discount module works, I get the email in nice HTML but no order number either in the email title or the email subject. I also have a letter in front of my order numbers and this comes thru in both email subject and content but no order number. The order number complete with the order letter prefix DOES gets printed on the checkout_confirmation page. I have tried the fix above but it didn't work. I am using Paypal IPN 1.3, PHP ver 4.4.7, MySQL 5.0.45, oscommerce-2.2ms2-060817 Any ideas anyone Cheers Ian
  21. Solved this one too. I am just too good. Ian
  22. ianric

    Wishlist 3.0 Support Thread

    Solved. Thanks to whoever read my post
  23. Hi, Me again It's been almost 2 months, I think I've been patient. Is this the wishlist support thread??? I am in the right thread?? Can someone kindly sort this out for me. All I want is for a message to show when an excluded item is added to the cart. My debug info is attached. Why did that product fail?? Cheers Ian
  24. ianric

    Automatic Stock Notification

    Hi I, too, installed but don't see anything. My question is as above, how does the customer get notified Cheers Ian
  25. ianric


    hi, me again Was it really in Jan I posted? Wow, doesn't time fly. Anyway, solved it thanks to the Graphic borders contrib. Why? Because that contrib mentioned adding borders to cross sell, product listings etc. So I looked at the Xsell products contrib (installed but didn't like it) and there was an update to the files as below, hope I don't get into trouble :) On my installation, with SEO URLS, the Buy It Now button was showing the parent product's ID and not its own. In catalog/includes/modules/xsell_products.php //Cache $text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $xsell['products_image'], $xsell['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . $xsell['products_name'] .'</a><br>' . $xsell_price. '<br><a href="' . tep_href_link(FILENAME_DEFAULT, 'action=buy_now&products_id=' . $xsell['products_id'], 'NONSSL') . '">' . tep_image_button('button_buy_now.gif', TEXT_BUY . $xsell['products_name'] . TEXT_NOW) .'</a>'; I stripped out the tep_get_all_get_params(array('action')) . and it seems to work. As I am not a great expert at this, do please test the heck out of it before you go anywhere near a production system! This zip contains only the updated includes/modules/xsell_products.php file. If you replace the $xsell with $matching it works and has passed a few tests locally. Hopefully a working module will be up on my site over the weekend. I'm still testing & formatting a wishlist contrib. This is my line of code that displays to products $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top" style="border-style: solid; border-width: 2" bordercolor="#EBEDF1"', 'text' => strtoupper($matching_products['products_name']) . '<br><br>' . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $matching_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $matching_products['products_image'], $matching_products['products_name'] . ' - ' . $matching_products['products_title'] . ' Label Side A', SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><br><a STYLE="text-decoration:underline" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $matching_products['products_id']) . '">' . $matching_products['products_title'] . '</a> (' . $matching_products['products_media'] . ')<br><br>' . $products_price . '<br><br><a href="' . tep_href_link(FILENAME_DEFAULT, 'action=buy_now&products_id=' . $matching_products['products_id'], 'NONSSL') . '">' . tep_image_submit('button_buy_now.gif', IMAGE_BUTTON_IN_CART) .'</a>' . ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'action=add_wishlist&products_id=' . $matching_products['products_id']) . '">' . tep_image_button('button_wishlist_small.gif', IMAGE_BUTTON_ADD_WISHLIST_SMALL) . '</a>'); Many thanks for a great contrib Ian