3 if($_POST['save_prefs']){
4 global $addslashes,$msg;
5 $private_xml = $addslashes($_POST['gcal_xml']);
6 $private_html = $addslashes($_POST['gcal_html']);
7 $timezone = $addslashes($_POST['timezone']);
9 $sql = "REPLACE into ".TABLE_PREFIX."google_prefs SET member_id = '$_SESSION[member_id]', private_xml = '$private_xml', private_html = '$private_html', timezone='$timezone'";
11 if($result = mysql_query($sql, $db)){
12 $msg->addFeedback('GOOGLE_CAL_UPDATED');
14 $msg->addError('GOOGLE_CAL_UPDATE_FAILED');
19 $sql = "SELECT email from ".TABLE_PREFIX."members WHERE member_id = '$_SESSION[member_id]'";
20 $result=mysql_query($sql, $db);
22 while($row = mysql_fetch_array($result)){
23 $my_email_address = $row[0];
27 $sql="SELECT * from ".TABLE_PREFIX."google_prefs WHERE member_id = '$_SESSION[member_id]'";
28 $result=mysql_query($sql, $db);
30 while($row = mysql_fetch_assoc($result)){
31 $private_xml = $row['private_xml'];
32 $private_html= $row['private_html'];
33 $timezone = $row['timezone'];
37 $calendar_xml = $private_xml;
39 $calendar_xml = "http://www.google.com/calendar/feeds/".$my_email_address."/public/basic";
40 $private_message = '<span style="color:red;">'._AT('google_calendar_permission').' </span>';
43 $calendar_xml = str_replace('%40','%2540',$calendar_xml);
46 $calendar_html = $private_html;
48 $calendar_html = "http://www.google.com/calendar/feeds/".$my_email_address."/public/basic";
53 $timezone = date_default_timezone_get();