Jump to content

FOD

Members
  • Content count

    42
  • Joined

  • Last visited

Profile Information

  • Real Name
    No
  • Gender
    Male
  1. FOD

    [contribution] Tracking Module

    mmm.. Seems tracking link from Admin seems to have gone down again (2nd december '14) checked source of Royal Mail site and same as was. Funny thing is clicking the tracking link from the email that goes out worls...weirdness. Anyone got the same result??
  2. FOD

    [contribution] Tracking Module

    You're a star psxgunman got it working following your instruction. The only other thing I did was to remove the </div> on roughy line 99 $content[1] = str_replace("</div>", "", $content[1]); to $content[1] = str_replace("", "", $content[1]);
  3. FOD

    [contribution] Tracking Module

    Royal Mail have changed their urls again, anyone know what the new one is to enable theTracking Module with Royal Mail tracking option to work again. I've go this part : https://www.royalmai...track-your-item used to be: http://www.royalmail...ce?trackNumber= anyone know how it works now This is what Royal Mail suggest you change URL's to but doesn't work for me :-( http://www.royalmail.com/portal/rm/track?trackNumber= Help greatly appreciated!!
  4. FOD

    Royal Mail URL's

    Royal Mail have changed their urls again, anyone know what the new one is to enable theTracking Module with Royal Mail tracking option to work again. I've go this part : https://www.royalmail.com/track-your-item used to be: http://www.royalmailgroup.co.uk/track-trace?trackNumber= anyone know how it works now Help greatly appreciated!!
  5. Tried the hack as suggested. Works great with only one attribute; however if as I do you have two attributes: One for size (trackable) and one for 'Add Giftwrap' (yes or no and not trackable - i.e. track stock option off on this attribute) it doesn't seem to work properly really. The Please Select option appears on the top of the dropdowns as expected but if a customer selects a size but not the gift wrap option (either yes or no) and clicks add to cart the product does not get added to the shopping cart. Anyone know of a way to have the alert or pop up window appear if both sets of options are not selected?
  6. FOD

    Royal Mail URL's

    Strange! All seems to working again today.
  7. Hi Chris I was wondering if you or anyone else has got problems with the Royal Mail tracking module as when I click the tracking number nothing appears in the box other than the ' [x] Close' message. Do you know if the Royal Mail have changed their urls again? They were working last Friday!
  8. FOD

    Margin Report v2.10

    Actually scrub that it returns errors (PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource) Try this instead: On line 42 of margin_report2.php Find... $d = mysql_fetch_array($date, MYSQL_ASSOC); Add after... $mydate = mysql_query("SELECT NOW() as time"); $d2 = mysql_fetch_array($mydate, MYSQL_ASSOC); Now the daily reports seem to return a result. Give it a try and see if it gets a result for you!
  9. FOD

    Margin Report v2.10

    I tried that but it didn't work for me and the daily reports were still not showing any results. After much head scratching I came up with this: On line 42 of margin_report2.php Find... $d = mysql_fetch_array($date, MYSQL_ASSOC); Add after... $d2 = mysql_fetch_array('now()', MYSQL_ASSOC); Now the daily reports seem to return a result. Give it a try and see if it gets a result for you!
  10. FOD

    Margin Report v2.10

    This is a typical error that comes out when you try to divide a number by zero. I got rid of it by adding @ in front of the formula which makes php not report the warning: Find $margin = tep_round((((($prods['products_price'])-($prods['products_cost']))/($prods['products_price']))*100), 0); replace with $margin = @tep_round(($price-$cost)/$price*100,2); That integrates the fix from the forum just above by sjnelle
  11. has set their status

  12. Try this, probably a long winded way of doing it but it works for me. FIND $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1'"; if($categories_id > 0) $specials_query_raw .= " and p2c.categories_id=".(int)$categories_id; $specials_query_raw .= " order by s.specials_date_added DESC"; REPLACE WITH if($categories_id > 0) { $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and p.products_id = p2c.products_id and p2c.categories_id=".(int)$categories_id." order by s.specials_date_added DESC"; } else { $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC";; }
  13. FOD

    NEW! Complete Order Editing Tool!

    Hi all Some time ago I had a problem with order editor 3 or so; I have just updated our system with the latest version(order_editor_5_0_6_6) but still experience a strange problem where apostophes written in the comments box " break " the contribution. Here is the error massage I received when testing by adding the word don't into the comments box when editing an order. Does any one know how I can resolve this issue by escaping the apostrophe? 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't')' at line 7 INSERT into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('8401', '2', now(), 0, 'don't') [TEP STOP]
  14. FOD

    Google XML Sitemap SEO

    Further to my previous post , I was mistaken and yes all the manufacturers appear regardless of whether they have a product with stock available or not. Is there a mod I could make to stop the sitemap listing those Manufacturers that no longer have a product with stock? Any help truly appreciated...
  15. FOD

    Google XML Sitemap SEO

    Here's something thats been baffling me regarding this ace contribution I have 100 or so manufacturers, all of which had products assigned to them at some point. We are no longer stocking some of the products by certain manufacturers but the manufacturers are still being listing in the sitemapmanufacturers.xml. The weirdest thing is some of the manufacturers that have no stock aren't showing up which is how we want it, where is the logic in that? Does the script base its search on a date modified stamp or should it get all the manufacturers regardless of whether there is stock assigned to them or not. Confused? i am...
×