3 global $savant, $_config, $_base_href;
\r
5 //Get the list of entries associated with the current user
\r
8 $sql = 'SELECT * from '.TABLE_PREFIX.'config WHERE name="webcalendar"';
\r
9 $result = mysql_query($sql, $db);
\r
10 while($row = mysql_fetch_array($result)){
\r
11 $webcalendar_url_db = $row[1];
\r
14 $sql2 = "SELECT login from ".TABLE_PREFIX."members WHERE member_id ='$_SESSION[member_id]'";
\r
15 $result10 = mysql_query($sql2, $db);
\r
16 while($row2 = mysql_fetch_row($result10)){
\r
17 $this_login = $row2['0'];
\r
20 $sql9 = "SELECT * from webcal_entry_user WHERE cal_login='$this_login'";
\r
21 $result9 = mysql_query($sql9, $db);
\r
22 $today = date("d-M-Y");
\r
24 echo '<span>'._AT('today_is').': <strong><a href="'.$_base_href.'mods/calendar/">'.$today.'</a></strong></span>';
\r
25 echo '<small><small> ('._AT('new_window').')</small></small>';
\r
26 echo '<ul style="margin-left:-2em;">';
\r
27 while($row = mysql_fetch_array($result9)){
\r
29 // Get ten approved entries associated with a user, from today onward.
\r
30 $sql10 = "SELECT A.*, B.* FROM webcal_entry AS A, webcal_entry_user AS B WHERE A.cal_id='".$row[0]."' AND A.cal_date >= '$today' AND A.cal_id = B.cal_id AND (B.cal_status = 'A' || A.cal_access = 'P') AND B.cal_login = '".$this_login."' LIMIT 10";
\r
31 $result10 = mysql_query($sql10, $db);
\r
32 while($row2 = mysql_fetch_assoc($result10)){
\r
33 #$this_date = split("*./4", $row2['cal_date']);
\r
34 $this_date = split(".*/4", $row2['cal_date']);
\r
35 $this_date = chunk_split($row2['cal_date'], 4, '-');
\r
36 $this_date = trim(chunk_split($this_date, 7, '-'), '-');
\r
37 echo '<li><a href="'.$webcalendar_url_db.'view_entry.php?id='.$row2['cal_id'].SEP.'date='.$row2['cal_date'].'" onclick="window.open(\' '.$webcalendar_url_db.'view_entry.php?id='.$row2['cal_id'].SEP.'date='.$row2['cal_date'].'\',\'calendarwin\',\'width=600,height=520,scrollbars=yes, resizable=yes\'); return false">'.$row2['cal_name'].'</a><br /><small><small> ('.$this_date.')</small></small></li>';
\r
42 $savant->assign('dropdown_contents', ob_get_contents());
\r
45 $savant->assign('title', _AT('current_calendar'));
\r
46 $savant->display('include/box.tmpl.php');
\r