Jump to content

jeep

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

jeep's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi, I wonder if anyone could help me with this: I am setting up an intranet site with mambo open source. I also use an calendar component (ExtCalendar) wich has a module that shows the 'latest events' (LatestEventsModule). But,.. i would like to make some changes to how the program works. By default you can set how many upcoming events you want to show on the frontpage. What I would like is that is shows only stuff for today. I think it should be in this part: $calendarquery = "SELECT e.*,cat,cat_name from #__extcal_events AS e LEFT JOIN #__extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( ( UNIX_TIMESTAMP(e.end_date) >= UNIX_TIMESTAMP('".$EXTCAL_CONFIG['now']."') ) OR ( UNIX_TIMESTAMP(e.start_date) >= UNIX_TIMESTAMP('".$EXTCAL_CONFIG['now']."') ) ) OR ( e.end_date = '0000-00-00 00:00:01' ) ) AND c.published = '1' AND approved = '1' AND recur_type = '' ORDER BY e.start_date,e.title ASC LIMIT " . $EXTCAL_CONFIG['number_of_events_to_list_upcoming'];\0\0 but i can't figure it out, anyone that could give me a tip? thnx!
×
×
  • Create New...

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.