MODS.DB9.DK

[bjpembo]

I have version 1.3.7 installed on phpbb 2.018, previously 17 and when i set a time interval on any banner, the banner will not display on my forum. If i remove the time interval's the banner displays fine. I recieve no error messages or have any other problems besides this. The current date on my forum is correct and i have no mods that affect the way the date or time is displayed. I tried to search and found a couple of topics on this problem but none of them had answers, i hope someone can help me out here. Thanks in advance

[Beeveer]

Does it work without time settings?

[bjpembo]

yes, it works fine without time intervals. but if i set a banner to start and end at any time, the banner will not display until i remove the time interval.

[Delta221]

yes, it works fine without time intervals. but if i set a banner to start and end at any time, the banner will not display until i remove the time interval.

same problem here, no solution ?

[mgutt]

look here:
http://mods.db9.dk/viewtopic.php?p=26176#26176

[bjpembo]

just to bring the solution that worked for me over from the other thread.... thanks for the link to the correct thread as well.


includes/page_header.php

Replace this....

Code: Select all

$sql = "SELECT DISTINCT banner_id, banner_name, banner_spot, banner_description, banner_forum, banner_type, banner_width, banner_height, banner_filter FROM ".BANNERS_TABLE ."
      WHERE banner_active
      AND IF(banner_level_type,IF(banner_level_type=1,".intval($sql_level)."<=banner_level,IF(banner_level_type=2,".intval($sql_level).">=banner_level,".intval($sql_level)."<>banner_level)),banner_level=".intval($sql_level).")
      AND (banner_timetype=0
      OR (( $hour_now BETWEEN time_begin AND time_end) AND ((banner_timetype=2
      OR (( $week_now BETWEEN date_begin AND date_end) AND banner_timetype=4)
      OR (( $date_now BETWEEN date_begin AND date_end) AND banner_timetype=6)
      )))) ORDER BY banner_spot,banner_weigth*SUBSTRING(RAND(),6,2) DESC";

With this....

Code: Select all

$sql = "SELECT DISTINCT banner_id, banner_name, banner_spot, banner_url, banner_description, banner_forum, banner_type, banner_width, banner_height, banner_filter FROM ".BANNERS_TABLE ."
      WHERE banner_active
      AND IF(banner_level_type,IF(banner_level_type=1,".intval($sql_level)."<=banner_level,IF(banner_level_type=2,".intval($sql_level).">=banner_level,".intval($sql_level)."<>banner_level)),banner_level=".intval($sql_level).")
      AND (banner_timetype=0
      OR (( $hour_now BETWEEN time_begin AND time_end) AND banner_timetype=2)
      OR (( $week_now BETWEEN date_begin AND date_end) AND banner_timetype=4)
      OR (( $date_now BETWEEN date_begin AND date_end) AND banner_timetype=6)
      ) ORDER BY banner_spot,banner_weigth*SUBSTRING(RAND(),6,2) DESC";

[/code]

[Delta221]

Works just great !! thanx alot buddy