aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorFriendika <info@friendika.com>2011-01-13 02:01:00 -0800
committerFriendika <info@friendika.com>2011-01-13 02:01:00 -0800
commit55598932936196d4a5012f801336c5d850b168ae (patch)
treed22c9d98072891bb0d4b4bdeb5dc0abcf16fa0b4
parentb11963f9ac3551ff850ddfd4c8c58fe0c87dee1a (diff)
downloadvolse-hubzilla-55598932936196d4a5012f801336c5d850b168ae.tar.gz
volse-hubzilla-55598932936196d4a5012f801336c5d850b168ae.tar.bz2
volse-hubzilla-55598932936196d4a5012f801336c5d850b168ae.zip
event and birthday data structures
-rw-r--r--boot.php2
-rw-r--r--database.sql18
-rw-r--r--mod/notifications.php11
-rw-r--r--update.php24
4 files changed, 54 insertions, 1 deletions
diff --git a/boot.php b/boot.php
index 600ce2cc0..46c514481 100644
--- a/boot.php
+++ b/boot.php
@@ -2,7 +2,7 @@
set_time_limit(0);
-define ( 'BUILD_ID', 1030 );
+define ( 'BUILD_ID', 1031 );
define ( 'DFRN_PROTOCOL_VERSION', '2.0' );
define ( 'EOL', "<br />\r\n" );
diff --git a/database.sql b/database.sql
index 61cd95e72..0e21be512 100644
--- a/database.sql
+++ b/database.sql
@@ -89,6 +89,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
`reason` text NOT NULL,
`info` mediumtext NOT NULL,
`profile-id` int(11) NOT NULL DEFAULT '0',
+ `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `self` (`self`),
@@ -451,5 +452,22 @@ CREATE TABLE IF NOT EXISTS `addon` (
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
+CREATE TABLE IF NOT EXISTS `event` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`uid` INT NOT NULL ,
+`cid` INT NOT NULL ,
+`created` DATETIME NOT NULL ,
+`edited` DATETIME NOT NULL ,
+`start` DATETIME NOT NULL ,
+`finish` DATETIME NOT NULL ,
+`desc` TEXT NOT NULL ,
+`location` TEXT NOT NULL ,
+`type` CHAR( 255 ) NOT NULL ,
+`adjust` TINYINT( 1 ) NOT NULL DEFAULT '1',
+`allow_cid` MEDIUMTEXT NOT NULL ,
+`allow_gid` MEDIUMTEXT NOT NULL ,
+`deny_cid` MEDIUMTEXT NOT NULL ,
+`deny_gid` MEDIUMTEXT NOT NULL
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;
diff --git a/mod/notifications.php b/mod/notifications.php
index ef7202363..49157c444 100644
--- a/mod/notifications.php
+++ b/mod/notifications.php
@@ -72,6 +72,16 @@ function notifications_content(&$a) {
'$hide_text' => ((strlen($sql_extra)) ? t('Show Ignored Requests') : t('Hide Ignored Requests'))
));
+
+ $r = q("SELECT COUNT(*) AS `total` FROM `intro`
+ WHERE `intro`.`uid` = %d $sql_extra AND `intro`.`blocked` = 0 ",
+ intval($_SESSION['uid'])
+ );
+ if($r && count($r)) {
+ $a->set_pager_total($r[0]['total']);
+ $a->set_pager_itemspage(20);
+ }
+
$r = q("SELECT `intro`.`id` AS `intro_id`, `intro`.*, `contact`.*
FROM `intro` LEFT JOIN `contact` ON `intro`.`contact-id` = `contact`.`id`
WHERE `intro`.`uid` = %d $sql_extra AND `intro`.`blocked` = 0 ",
@@ -152,5 +162,6 @@ function notifications_content(&$a) {
}
+ $o .= paginate($a);
return $o;
}
diff --git a/update.php b/update.php
index afa3b58a4..1b75d0434 100644
--- a/update.php
+++ b/update.php
@@ -277,3 +277,27 @@ function update_1028() {
function update_1029() {
q("ALTER TABLE `contact` ADD `info` MEDIUMTEXT NOT NULL AFTER `reason` ");
}
+
+function update_1030() {
+ q("ALTER TABLE `contact` ADD `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag' AFTER `profile-id` ");
+
+ q("CREATE TABLE IF NOT EXISTS `event` (
+ `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `uid` INT NOT NULL ,
+ `cid` INT NOT NULL ,
+ `created` DATETIME NOT NULL ,
+ `edited` DATETIME NOT NULL ,
+ `start` DATETIME NOT NULL ,
+ `finish` DATETIME NOT NULL ,
+ `desc` TEXT NOT NULL ,
+ `location` TEXT NOT NULL ,
+ `type` CHAR( 255 ) NOT NULL ,
+ `adjust` TINYINT( 1 ) NOT NULL DEFAULT '1',
+ `allow_cid` MEDIUMTEXT NOT NULL ,
+ `allow_gid` MEDIUMTEXT NOT NULL ,
+ `deny_cid` MEDIUMTEXT NOT NULL ,
+ `deny_gid` MEDIUMTEXT NOT NULL
+ ) ENGINE = MYISAM DEFAULT CHARSET=utf8 ");
+
+
+} \ No newline at end of file