Calendrier : menu de flux

Calendrier : menu de flux [Réglé]

affichage ASC pour des prochains événements Support des Modules

olivierb Membre non connecté

Equipe Assistance Modérateur

Le 22/03/2015 à 18h59

#143929

Reprise du message précédent

Bonjour,

Alors, je viens de modifier le fichier /calendar/phpboost/CalendarFeedProvider.class.php

Code PHP :

            $now = new Date();
            $today = strtotime(date("Y-m-d", $now->get_timestamp()));
            $result = $querier->select('SELECT *
            FROM ' . CalendarSetup::$calendar_events_table . ' event
            LEFT JOIN ' . CalendarSetup::$calendar_events_content_table . ' event_content ON event_content.id = event.content_id
            LEFT JOIN ' . DB_TABLE_MEMBER . ' member ON member.user_id = event_content.author_id
            LEFT JOIN '. CalendarSetup::$calendar_cats_table .' cat ON cat.id = event_content.id_category
            WHERE approved = 1
            AND start_date >= :timestamp_now
            AND id_category IN :cats_ids
            ORDER BY start_date', array(
                'cats_ids' => $ids_categories,
                'timestamp_now' => $today
            ));
 
/*            Code d'origine modifié par Babsolune et Dramaturge
            $result = $querier->select('SELECT *
            FROM ' . CalendarSetup::$calendar_events_table . ' event
            LEFT JOIN ' . CalendarSetup::$calendar_events_content_table . ' event_content ON event_content.id = event.content_id
            LEFT JOIN ' . DB_TABLE_MEMBER . ' member ON member.user_id = event_content.author_id
            LEFT JOIN '. CalendarSetup::$calendar_cats_table .' cat ON cat.id = event_content.id_category
            WHERE approved = 1
            AND start_date > ' . time() . '
            AND id_category IN :cats_ids
            ORDER BY start_date ASC', array(
                'cats_ids' => $ids_categories
            )); */