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.

2 files changed, 8 insertions, 1 deletions

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;
+}