Jump to content

Forums

  1. Announcements

    1. 1059
      posts
  2. General

    1. Pre-sales questions

      Please direct all feature related pre-sales questions here. If you have a question about multiple order discounts contact the sales department via the ticket system or the "contact us" form.

      6027
      posts
    2. Joomla site showcase

      Show off your JReviews powered Joomla site here

      1187
      posts
    3. WordPress site showcase

      Show off your JReviews powered WordPress site here

      40
      posts
    4. ionCube encoding questions

      ionCube installation tips and other encoding related questions

      403
      posts
  3. JReviews 3

    1. 130
      posts
    2. 15
      posts
    3. 268
      posts
    4. Themes

      Share and discuss theme changes.

      41
      posts
    5. SEF and SEO

      Post anything SEO and SEF related here.

      2527
      posts
    6. FormBuilder Custom Field Repository

      Share your form Schemas and Themes with other users

      201
      posts
    7. Custom Field PHP Based Formatting

      Share your ideas and ask questions about this very cool cutom field feature.

      10
      posts
    8. Tips & Tricks

      PLEASE don't ask questions here, post the actual tip or trick. Many of the JReviews 2 Tips & Tricks posts are still valid so you can refer to those, but since there are also many that are no longer valid we have this JReviews 3 dedicated board.

      79
      posts
    9. 77
      posts
  4. JReviews Add-ons

    1. 110
      posts
    2. 115
      posts
    3. 351
      posts
    4. 115
      posts
    5. 568
      posts
    6. 4926
      posts
    7. 3082
      posts
    8. 116
      posts
    9. 1365
      posts
  5. JReviews en Español

    1. General Español

      Si prefieres ayuda en español, escribe aquí!

      1163
      posts
  6. JReviews 2.x

    1. 17492
      posts
    2. 891
      posts
    3. 40908
      posts
    4. Themes

      Share and discuss theme changes.

      6524
      posts
    5. Tips & Tricks

      PLEASE don't ask questions here, post the actual tip or trick.

      2750
      posts
    6. Modules

      Questions related to jReviews modules.

      5757
      posts
    7. Known conflicts & incompatibilities

      If you find a template or extension that conflicts with jReviews please post it here. If you have a workaround even better.

      724
      posts
    8. Language files

      Post your translations or updates here. Use one post and keep it up to date. Include the JReviews version number with your post!

      373
      posts
    9. 411
      posts
  7. Extensions & Templates

    1. 1677
      posts
  8. Feature requests

    1. Feature requests

      Post your JReviews features requests. Please keep in mind that we will *not* answer to every feature request post and we are not able to implement every feature request.

      4366
      posts
  9. Freelance board

    1. The freelancer corner

      Do you need to hire someone to get your jReviews site up and running? Do you want to sell your services to help others get their jReviews sites up and running? Post here!

      1971
      posts
    2. JReviews Professionals

      If you have experience building sites with JReviews, either with design or with development, feel free to advertise your services here. This should become a resource for all JReviews users to find trustworthy freelancers to work on their projects.

      133
      posts
  10. 3rd Party Solutions for JReviews

    1. 3rd Party Solutions for JReviews

      3rd party vendors can advertise their JReviews products here. It is a requirement that a pre-sales and support url or email are provided with your post. If your code makes use of any JReviews proprietary code you must get permission from us before you share or sell your product. We reserve the right to remove a post without prior notice. We also ask that you lock your posts to prevent this from becoming a support forum for 3rd party products.

      91
      posts
  • Recent possts

    • So this is what I've come up with based on the workaround idea I mentioned in the last post. It definitely works, just not sure if there's a better way? <?php $expired = $listing['Listing']['publish_down'] != NULL_DATE && strtotime($listing['Listing']['publish_down']) < time(); ?> <?php if($expired == "0"):?> <!–– listing template --!> <?php endif;?>  
    • Yeah that sounds like what's happening. Only issue is that we need to be able to stop the listing outputting part way through the day as it relates to offers which we're not supposed to show after they've expired. Setting to end a day early would't work either as for big events they're only live for part of one day so they wouldn't show at all. Plus interest peaks closer to when the offer ends so again wouldn't want it to end early. We'd previously been using a butchered version of the joomla banner system to contain these but wanted to use the related listing functions of jreviews. What if we checked the current time in the module theme file and compared to the joomla expiration time field. We'd have the module on a short cache so there would be a bit of overlap (but we'd have that anyway with the cache, whichever way we did it) but means the database query could still be cached, right?
    • Not necessarily. For performance reasons, JReviews doesn't include the current time in database queries. That's because if it did, then every time the page loaded the query would be different and MySQL is not able to cache it. So checking for expired listings is done based on the beginning of the day. So the queries look for listings that have an expiration date/time higher than the beginning of today. I guess this could turn into an issue if Joomla considers an article expiring at noon as expired, but JReviews allows it to show for the entire day since it was after all higher than the beginning of today. The only solution here, so as not to mess up with performance, would be to expire the listing one day before so that if the expiration is noon today, it will only show till the end of the previous day. Does any of this make sense and sounds like it could be the issue based on what you are seeing? There's also the issue with server time vs. real time, but hopefully, that's not something that's affecting this as well as there are built-in methods to take care of that.
    • We've not upgraded to 3.x but it is the latest version of 2.7 (v2.7.26.1). So after doing a bit more digging it seems that they are expiring but the time is ignored - ie: ones expired yesterday are removed but ones expired earlier today are still showing. Is that by design?
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Please refer to our Privacy Policy.