- Code: Select all
Couldn't get banners data
DEBUG MODE
SQL Error : 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 ':08 BETWEEN time_begin AND time_end) AND banner_timetype=2)
SELECT DISTINCT banner_id, banner_name, banner_spot, banner_description, banner_forum, banner_type, banner_width, banner_height, banner_filter FROM phpbb_banner WHERE banner_active AND IF(banner_level_type,IF(banner_level_type=1,2<=banner_level,IF(banner_level_type=2,2>=banner_level,2<>banner_level)),banner_level=2) AND (banner_timetype=0 OR (( Idag - 09:08 BETWEEN time_begin AND time_end) AND banner_timetype=2) OR (( Idag - 09:08 BETWEEN date_begin AND date_end) AND banner_timetype=4) OR (( Idag - 09:08 BETWEEN date_begin AND date_end) AND banner_timetype=6) ) ORDER BY banner_spot,banner_weigth*SUBSTRING(RAND(),6,2) DESC
Line : 534
File : /www/htdocs/forum/includes/page_header.php
how to fix this?
this is the "wrong" part:
- Code: Select all
(( Idag - 09:08 BETWEEN time_begin AND time_end) AND banner_timetype=2) OR (( Idag - 09:08 BETWEEN date_begin AND date_end) AND banner_timetype=4) OR (( Idag - 09:08
