Jump to content
Latest News: (loading..)

Dan Cole

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Dan Cole

  1. Are you able to post a link so someone can have a look? Dan
  2. Information section of store

    And before you get to far are you using the correct version? ie EDGE. See this post. Dan
  3. Can you find the code that contains this class in your actual index.php file? Paste the section of your code that does that along with a few of the lines that follow and I'm sure someone can point you in the right direction. Dan
  4. Icloud email servers rejecting emails

    Now that I think about it....you're probably not the right person to ask....I hear your Iguanas fall out of the trees with the first hint of cold weather. Dan
  5. Icloud email servers rejecting emails

    John I noticed that you referenced ICloud in the threads title....aren't these the same folks giving us grief with attributes? If so, they might have security screwed down a little tight. Dan PS: Do you have any Iguanas you can send me?
  6. Icloud email servers rejecting emails

    Thanks Smoky...that's interesting....here is what SpamExperts say about outgoing filtering. Dan
  7. Icloud email servers rejecting emails

    @crimble crumble Smoky did you ask your host why they were marking them as spam....it seems odd that they would be the ones doing that. I can see the recipient server doing so but your host? Dan
  8. themes error

    That templates appears to be for an older version of oscommerce (2.2) and won't likely work with newer versions. If you're just new to osC be sure to install the EDGE version which you'll find referenced in this post. Dan
  9. I spent a little more time looking at the query I posted above, probably way more time than I should have but what can I say I'm both curious and stubborn. To make a long story short I shorten the query to isolate the problem. The short version goes like this. SELECT `customers_dob` FROM `customers` WHERE concat(year(now()), '', date_format(customers_dob,'%m%d')) < date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AND concat(year(now()), '', date_format(customers_dob,'%m%d')) > date_format(SUBDATE(now(), INTERVAL 17 DAY),'%Y%m%d') AND customers_dob != '0000-00-00 00:00:00' This runs just fine but still falls to pick up any records prior to year end. To see what data I was getting I copied the where conditions to the select portion of the query so I could see what output was generated each step of the way. Here is what that query looks like. SELECT `customers_dob`, concat(year(now()), '', date_format(customers_dob,'%m%d')) AS FIRST_AHEAD, date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AS SECOND_AHEAD, concat(year(now()), '', date_format(customers_dob,'%m%d')) AS FIRST_BEHIND, date_format(SUBDATE(now(), INTERVAL 17 DAY),'%Y%m%d') AS SECOND_BEHIND FROM `customers` WHERE concat(year(now()), '', date_format(customers_dob,'%m%d')) < date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AND concat(year(now()), '', date_format(customers_dob,'%m%d')) > date_format(SUBDATE(now(), INTERVAL 17 DAY),'%Y%m%d') AND customers_dob != '0000-00-00 00:00:00' This products the following output. + Options customers_dob FIRST_AHEAD SECOND_AHEAD FIRST_BEHIND SECOND_BEHIND 2009-01-06 00:00:00 20180106 20180118 20180106 20171225 2010-01-04 00:00:00 20180104 20180118 20180104 20171225 2006-01-12 00:00:00 20180112 20180118 20180112 20171225 2009-01-03 00:00:00 20180103 20180118 20180103 20171225 2008-01-05 00:00:00 20180105 20180118 20180105 20171225 2008-01-09 00:00:00 20180109 20180118 20180109 20171225 2008-01-11 00:00:00 20180111 20180118 20180111 20171225 2002-01-01 00:00:00 20180101 20180118 20180101 20171225 1999-01-15 00:00:00 20180115 20180118 20180115 20171225 2006-01-12 00:00:00 20180112 20180118 20180112 20171225 2005-01-01 00:00:00 20180101 20180118 20180101 20171225 2006-01-03 00:00:00 20180103 20180118 20180103 20171225 2013-01-07 00:00:00 20180107 20180118 20180107 20171225 2002-01-06 00:00:00 20180106 20180118 20180106 20171225 2008-01-16 00:00:00 20180116 20180118 20180116 20171225 It still doesn't catch any records in the previous year. Can anyone see what it is that I'm doing wrong or have any suggestion on how I can test this further to determine what the issue is? At this point this is not terribly important to me but I'm very curious as to why it doesn't work. Dan - The Stubborn one! PS: There are indeed records that the query should select.
  10. Seems to be an issue with the model number then ie perhaps it needs to already exist and that is starting to ring a bell with me but not loud enough to me to remember the answer. If you add the module number you want to your database with a minimum of detail I assume you can update it with Easy Populate? Humm....does the category need to exists already my memory is fuzzy. Maybe when my morning coffee kicks in so will my memory. If so I'll come back to this. Dan
  11. Maybe you want to back up....put the working version back in place and then make minor changes to the look and feel to suit what you want. If the submit button is not working it sounds to me that you have the form messed up. I do know that the original contribution works since I'm using it so it must be something you changed along the way. Backing up should get you back on the right track again. Dan
  12. Have you set up the form...ie using tep_draw_form? Dan
  13. If you leave the model number alone but change the product name or some other data point, what happens? Dan
  14. I think it should be tep_db_query. That must be a pretty old add-on you have there. Dan
  15. My guess...this file but I don't use it so I can't check it for you. Dan
  16. Ive got a suprise coming

    If he ever finishes wrapping it. To bad all the mall wrapping stations have moved on now. Oh wait, maybe he found the beer. Dan
  17. Has anyone developed any new IBar dashboards? If so, show us what you've done. Personally I haven't done much with them lately but the ones I did develop are still in use. I find the whole concept of having a dashboard to monitor things quite helpful and motivating. Here is what my dashboard currently looks like.
  18. I really like using Dashboards to gauge and monitor various goals and activities on my site. For me, what gets measured seems to get done so I've started to add a few dashboards and was just wondering if anyone else has done the same? If so, what types of dashboards have you added that you found useful? If you haven't added any yet, what types of dashboards would you like to see added? Dan
  19. Ive got a suprise coming

    Is it our belated Christmas present and you're wrapping it? Dan
  20. Remove client database addresses

    @reflex-ocasion Alfonso have a look at this add on...I think it'll do what you want. If you use order editor and take in store orders be careful since the order editor you use may or may not update the last login date when orders are entered. https://apps.oscommerce.com/eyKG8&inactive-user For some additional information have a look at this thread. Dan
  21. @tgely Gergely that thought went through my head when I was messing around with this but I was starting to get a headache by that time and wondered if I was over thinking things. When I get a bit more time I'll play around with the UNIX time format to see what I can come up with.....assuming that Carine doesn't pull some simple MySQL routine out of her bag of tricks. It really shouldn't be this complicated. Thanks for the input. This is exactly what I have in mind. I want to come up with a variety of emails that can be sent automatically day in and day out. Building or finding a useful fake cron job that can handle your HTML emails is on my list to do. Dan
  22. @bruyndoncx Thanks Carine...I'm in no hurry. I think, as it is currently written, I have a whole year before I see the issue again. I must say I'm curious about it though, since I tried a bunch of different options without success, so it's one of those things that bugs me. Dan
  23. @frankl It was just an available field that I didn't otherwise use...what is posted to it is the customers first order date. I don't collect birth dates...I probably should have renamed it but was just too lazy. Dan
  24. In an effort to improve customer engagement I developed an Anniversary Email a few years ago which has been working well. Customers have been pretty impressed by it and it generates additional sales. As they say an image it worth a thousand words so here is the email so you can see what I've been doing. Over the years I've noticed a bit of a glitch with the database query when we reach year end and since I was upgrading the mailing to use @tgely Gergely's HTML Emails I thought I would see if I could sort out the query. For some reason the query isn't spanning the calendar year so doesn't include records for the previous year when the date range spans the year end. I've tried reworking the query several times but I can seem to figure it out...it's kicking my butt. Does anyone @bruyndoncx perhaps, have any idea how I can rework the query to get it to work on a consistent basis. Here is the query I'm working with. SELECT c.customers_firstname, c.customers_lastname, c.customers_id, c.customers_email_address, c.customers_dob, date_format(c.customers_dob, '%M %D') as date_of_birth, CURDATE(), (YEAR(CURDATE())-YEAR(c.customers_dob)) - (RIGHT(CURDATE(),5) < RIGHT(c.customers_dob,5)) AS number_of_years FROM customers c WHERE concat(year(now()), '', date_format(c.customers_dob,'%m%d')) < date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AND concat(year(now()), '', date_format(c.customers_dob,'%m%d')) > date_format(SUBDATE(now(), INTERVAL 3 DAY),'%Y%m%d') AND c.customers_newsletter = '1' AND c.customers_dob != '0000-00-00 00:00:00' AND c.customers_email_address NOT LIKE 'MOPS%' ORDER BY date_of_birth Dan