mod/events.php

   1 <?php
   2
   3 require_once('include/datetime.php');
   4 require_once('include/event.php');
   5
   6 function events_post(&$a) {
   7
   8         if(! local_user())
   9                 return;
  10
  11         $event_id = ((x($_POST,'event_id')) ? intval($_POST['event_id']) : 0);
  12         $uid      = local_user();
  13         $start    = strip_tags($_POST['start']);
  14         $finish   = strip_tags($_POST['finish']);
  15         $desc     = escape_tags($_POST['desc']);
  16         $location = escape_tags($_POST['location']);
  17         $type     = 'event';
  18         $adjust   = intval($_POST['adjust']);
  19
  20         $str_group_allow   = perms2str($_POST['group_allow']);
  21         $str_contact_allow = perms2str($_POST['contact_allow']);
  22         $str_group_deny    = perms2str($_POST['group_deny']);
  23         $str_contact_deny  = perms2str($_POST['contact_deny']);
  24
  25
  26         if($event_id) {
  27                 $r = q("UPDATE `event` SET
  28                         `edited` = '%s',
  29                         `start` = '%s',
  30                         `finish` = '%s',
  31                         `desc` = '%s',
  32                         `location` = '%s',
  33                         `type` = '%s',
  34                         `adjust` = %d,
  35                         `allow_cid` = '%s',
  36                         `allow_gid` = '%s',
  37                         `deny_cid` = '%s',
  38                         `deny_gid` = '%s'
  39                         WHERE `id` = %d AND `uid` = %d LIMIT 1",
  40
  41                         dbesc(datetime_convert()),
  42                         dbesc($start),
  43                         dbesc($finish),
  44                         dbesc($desc),
  45                         dbesc($location),
  46                         dbesc($type),
  47                         intval($adjust),
  48                         dbesc($str_contact_allow),
  49                         dbesc($str_group_allow),
  50                         dbesc($str_contact_deny),
  51                         dbesc($str_group_deny),
  52                         intval($event_id),
  53                         intval($local_user())
  54                 );
  55
  56         }
  57         else {
  58
  59                 $uri = item_new_uri($a->get_hostname(),local_user());
  60
  61                 $r = q("INSERT INTO `event` ( `uid`,`uri`,`created`,`edited`,`start`,`finish`,`desc`,`location`,`type`,
  62                         `adjust`,`allow_cid`,`allow_gid`,`deny_cid`,`deny_gid`)
  63                         VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, '%s', '%s', '%s', '%s' ) ",
  64                         intval(local_user()),
  65
  66                         dbesc(datetime_convert()),
  67                         dbesc(datetime_convert()),
  68                         dbesc($start),
  69                         dbesc($finish),
  70                         dbesc($desc),
  71                         dbesc($location),
  72                         dbesc($type),
  73                         intval($adjust),
  74                         dbesc($str_contact_allow),
  75                         dbesc($str_group_allow),
  76                         dbesc($str_contact_deny),
  77                         dbesc($str_group_deny)
  78
  79                 );
  80         }
  81
  82 }
  83
  84
  85
  86 function events_content(&$a) {
  87
  88         if(! local_user()) {
  89                 notice( t('Permission denied.') . EOL);
  90                 return;
  91         }
  92
  93         $o .= '<h2>' . t('Events') . '</h2>';
  94
  95         $mode = 'view';
  96         $y = 0;
  97         $m = 0;
  98
  99         if($a->argc > 1) {
 100                 if($a->argc > 2 && $a->argv[1] == 'event') {
 101                         $mode = 'edit';
 102                         $event_id = intval($a->argv[2]);
 103                 }
 104                 if($a->argv[1] === 'new') {
 105                         $mode = 'new';
 106                         $event_id = 0;
 107                 }
 108                 if($a->argc > 2 && intval($a->argv[1]) && intval($a->argv[2])) {
 109                         $mode = 'view';
 110                         $y = intval($a->argv[1]);
 111                         $m = intval($a->argv[2]);
 112                 }
 113         }
 114
 115         if($mode == 'view') {
 116             $thisyear = datetime_convert('UTC',date_default_timezone_get(),'now','Y');
 117         $thismonth = datetime_convert('UTC',date_default_timezone_get(),'now','m');
 118                 if(! $y)
 119                         $y = intval($thisyear);
 120                 if(! $m)
 121                         $m = intval($thismonth);
 122
 123
 124                 $o .= cal($y,$m,false, ' eventcal');
 125
 126                 $dim = get_dim($y,$m);
 127                 $start = sprintf('%d-%d-%d %d:%d:%d',$y,$m,1,0,0,0);
 128                 $finish = sprintf('%d-%d-%d %d:%d:%d',$y,$m,$dim,23,59,59);
 129
 130
 131                 $r = q("SELECT * FROM `event` WHERE `start` >= '%s' AND `finish` <= '%s' AND `uid` = %d ",
 132                         dbesc($start),
 133                         dbesc($finish),
 134                         intval(local_user())
 135                 );
 136
 137                 if(count($r))
 138                         foreach($r as $rr)
 139                                 $o .= format_event_html($rr);
 140
 141                 return $o;
 142         }
 143
 144         if($mode === 'edit' || $mode === 'new') {
 145                 $tpl = get_markup_template('event_form.tpl');
 146
 147                 $year = datetime_convert('UTC', date_default_timezone_get(), 'now', 'Y');
 148
 149
 150                 $o .= replace_macros($tpl,array(
 151                         '$post' => $a->get_baseurl() . '/events',
 152                         '$e_text' => t('Event details'),
 153                         '$s_text' => t('Starting date/time:'),
 154                         '$s_dsel' => datesel('start',$year+5,$year,false,$year,0,0),
 155                         '$s_tsel' => timesel('start',0,0),
 156                         '$f_text' => t('Finish date/time:'),
 157                         '$f_dsel' => datesel('start',$year+5,$year,false,$year,0,0),
 158                         '$f_tsel' => timesel('start',0,0),
 159                         '$d_text' => t('Description:'),
 160                         '$d_orig' => '',
 161                         '$l_text' => t('Location:'),
 162                         '$l_orig' => '',
 163                         '$submit' => t('Submit')
 164
 165                 ));
 166
 167                 return $o;
 168         }
 169 }