- new_nonhtml_page('carnet/calendar.tpl', AUTH_PUBLIC);
-
- if ($alias && $hash) {
- $res = XDB::query(
- 'SELECT a.id
- FROM aliases AS a
- INNER JOIN auth_user_quick AS q ON ( a.id = q.user_id AND q.core_rss_hash = {?} )
- WHERE a.alias = {?} AND a.type != "homonyme"', $hash, $alias);
- $uid = $res->fetchOneCell();
+ require_once 'ical.inc.php';
+ $page->changeTpl('carnet/calendar.tpl', NO_SKIN);
+ $page->register_function('display_ical', 'display_ical');
+
+ $res = XDB::iterRow(
+ 'SELECT u.prenom,
+ IF(u.nom_usage = \'\',u.nom,u.nom_usage) AS nom,
+ u.promo,
+ u.naissance,
+ DATE_ADD(u.naissance, INTERVAL 1 DAY) AS end,
+ u.date_ins,
+ a.alias AS forlife
+ FROM contacts AS c
+ INNER JOIN auth_user_md5 AS u ON (u.user_id = c.contact)
+ INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type = \'a_vie\')
+ WHERE c.uid = {?}', S::v('uid'));
+
+ $annivs = Array();
+ while (list($prenom, $nom, $promo, $naissance, $end, $ts, $forlife) = $res->next()) {
+ $naissance = str_replace('-', '', $naissance);
+ $end = str_replace('-', '', $end);
+ $annivs[] = array(
+ 'timestamp' => strtotime($ts),
+ 'date' => $naissance,
+ 'tomorrow' => $end,
+ 'forlife' => $forlife,
+ 'summary' => 'Anniversaire de '.$prenom
+ .' '.$nom.' - x '.$promo,
+ );