1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

question about php sql ExtCalendar

Discussion in 'Content Management' started by jeep, Jun 7, 2006.

  1. #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? :confused:


    thnx!
     
    jeep, Jun 7, 2006 IP