diff options
| -rw-r--r-- | boot.php | 2 | ||||
| -rw-r--r-- | database.sql | 1 | ||||
| -rw-r--r-- | include/event.php | 5 | ||||
| -rw-r--r-- | mod/events.php | 84 | ||||
| -rw-r--r-- | update.php | 6 |
5 files changed, 95 insertions, 3 deletions
@@ -6,7 +6,7 @@ ini_set('pcre.backtrack_limit', 250000); define ( 'FRIENDIKA_VERSION', '2.2.1002' ); define ( 'DFRN_PROTOCOL_VERSION', '2.21' ); -define ( 'DB_UPDATE_VERSION', 1060 ); +define ( 'DB_UPDATE_VERSION', 1061 ); define ( 'EOL', "<br />\r\n" ); define ( 'ATOM_TIME', 'Y-m-d\TH:i:s\Z' ); diff --git a/database.sql b/database.sql index 7c26af341..ab047968e 100644 --- a/database.sql +++ b/database.sql @@ -476,6 +476,7 @@ CREATE TABLE IF NOT EXISTS `event` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `uid` INT NOT NULL , `cid` INT NOT NULL , +`uri` CHAR( 255 ) NOT NULL, `created` DATETIME NOT NULL , `edited` DATETIME NOT NULL , `start` DATETIME NOT NULL , diff --git a/include/event.php b/include/event.php index 06239b2ab..21817086f 100644 --- a/include/event.php +++ b/include/event.php @@ -31,4 +31,7 @@ function format_event_html($ev) { $o .= '</div>'; return $o; -}
\ No newline at end of file +} + + + diff --git a/mod/events.php b/mod/events.php new file mode 100644 index 000000000..73328b959 --- /dev/null +++ b/mod/events.php @@ -0,0 +1,84 @@ +<?php + +require_once('include/datetime.php'); +require_once('include/event.php'); + +function events_post(&$a) { + + if(! local_user()) + return; + + $event_id = ((x($_POST,'event_id')) ? intval($_POST['event_id']) : 0); + $uid = local_user(); + $start = strip_tags($_POST['start']); + $finish = strip_tags($_POST['finish']); + $desc = escape_tags($_POST['desc']); + $location = escape_tags($_POST['location']); + $type = 'event'; + $adjust = intval($_POST['adjust']); + + $str_group_allow = perms2str($_POST['group_allow']); + $str_contact_allow = perms2str($_POST['contact_allow']); + $str_group_deny = perms2str($_POST['group_deny']); + $str_contact_deny = perms2str($_POST['contact_deny']); + + + if($event_id) { + $r = q("UPDATE `event` SET + `edited` = '%s', + `start` = '%s', + `finish` = '%s', + `desc` = '%s', + `location` = '%s', + `type` = '%s', + `adjust` = %d, + `allow_cid` = '%s', + `allow_gid` = '%s', + `deny_cid` = '%s', + `deny_gid` = '%s' + WHERE `id` = %d AND `uid` = %d LIMIT 1", + + dbesc(datetime_convert()), + dbesc($start), + dbesc($finish), + dbesc($desc), + dbesc($location), + dbesc($type), + intval($adjust), + dbesc($str_contact_allow), + dbesc($str_group_allow), + dbesc($str_contact_deny), + dbesc($str_group_deny), + intval($event_id), + intval($local_user()) + ); + + } + else { + + $uri = item_new_uri($a->get_hostname(),local_user()); + + $r = q("INSERT INTO `event` ( `uid`,`uri`,`created`,`edited`,`start`,`finish`,`desc`,`location`,`type`, + `adjust`,`allow_cid`,`allow_gid`,`deny_cid`,`deny_gid`) + VALUES ( %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, '%s', '%s', '%s', '%s' ) ", + intval(local_user()), + + dbesc(datetime_convert()), + dbesc(datetime_convert()), + dbesc($start), + dbesc($finish), + dbesc($desc), + dbesc($location), + dbesc($type), + intval($adjust), + dbesc($str_contact_allow), + dbesc($str_group_allow), + dbesc($str_contact_deny), + dbesc($str_group_deny) + + ); + } + +} + + diff --git a/update.php b/update.php index be1b184ae..be78f068f 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1060 ); +define( 'UPDATE_VERSION' , 1061 ); /** * @@ -506,3 +506,7 @@ function update_1059() { q("ALTER TABLE `queue` ADD `network` CHAR( 32 ) NOT NULL AFTER `cid` "); } +function update_1060() { + q("ALTER TABLE `event` ADD `uri` CHAR( 255 ) NOT NULL AFTER `cid` "); +} + |