add chandesc field to profiles to provide some arbitrary text in the directory - such as to inform people what this channel is about before they connect. This will work best with a "channel detail" popup in the directory to provide more info than is available in the micro-profiles (when hovered, or clicked or something). And of course, the first thing is to enable this data to be stored in the directory.

3 files changed, 9 insertions, 2 deletions

diff --git a/boot.php b/boot.php
index 8f2f7af6e..e6de1b5cb 100755
--- a/boot.php
+++ b/boot.php
@@ -43,7 +43,7 @@ require_once('include/taxonomy.php');
 define ( 'RED_PLATFORM',            'Red Matrix' );
 define ( 'RED_VERSION',             trim(file_get_contents('version.inc')) . 'R');
 define ( 'ZOT_REVISION',            1     ); 
-define ( 'DB_UPDATE_VERSION',       1053  );
+define ( 'DB_UPDATE_VERSION',       1054  );
 
 define ( 'EOL',                    '<br />' . "\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
diff --git a/install/database.sql b/install/database.sql
index 1226f1cd1..e8b01d066 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -693,6 +693,7 @@ CREATE TABLE IF NOT EXISTS `profile` (
   `hide_friends` tinyint(1) NOT NULL DEFAULT '0',
   `name` char(255) NOT NULL,
   `pdesc` char(255) NOT NULL,
+  `chandesc` text NOT NULL DEFAULT '',
   `dob` char(32) NOT NULL DEFAULT '0000-00-00',
   `dob_tz` char(255) NOT NULL DEFAULT 'UTC',
   `address` char(255) NOT NULL,
diff --git a/install/update.php b/install/update.php
index 8bc629f71..ba9e9e430 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1053 );
+define( 'UPDATE_VERSION' , 1054 );
 
 /**
  *
@@ -635,3 +635,9 @@ function update_r1052() {
 	return UPDATE_FAILED;
 }
 
+function update_r1053() {
+	$r = q("ALTER TABLE `profile` ADD `chandesc` TEXT NOT NULL DEFAULT '' AFTER `pdesc` ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}