Basic ability to create "things"

4 files changed, 57 insertions, 8 deletions

diff --git a/boot.php b/boot.php
index 9ff4bad7a..7106fd18f 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',       1046  );
+define ( 'DB_UPDATE_VERSION',       1047  );
 
 define ( 'EOL',                    '<br />' . "\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
@@ -322,10 +322,7 @@ define ( 'TERM_CATEGORY',     3 );
 define ( 'TERM_PCATEGORY',    4 );
 define ( 'TERM_FILE',         5 );
 define ( 'TERM_SAVEDSEARCH',  6 );
-define ( 'TERM_HAVETHING',    7 );
-define ( 'TERM_WANTTHING',    8 );
-define ( 'TERM_LIKETHING',    9 );
-define ( 'TERM_NOLIKETHING', 10 );
+define ( 'TERM_THING',        7 );
 
 define ( 'TERM_OBJ_POST',    1 );
 define ( 'TERM_OBJ_PHOTO',   2 );
diff --git a/install/database.sql b/install/database.sql
index 056124649..30b8edfd7 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -829,6 +829,7 @@ CREATE TABLE IF NOT EXISTS `term` (
   `term` char(255) NOT NULL,
   `url` char(255) NOT NULL,
   `imgurl` char(255) NOT NULL,
+  `term_hash` char(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`tid`),
   KEY `oid` (`oid`),
   KEY `otype` (`otype`),
@@ -836,7 +837,8 @@ CREATE TABLE IF NOT EXISTS `term` (
   KEY `term` (`term`),
   KEY `uid` (`uid`),
   KEY `aid` (`aid`),
-  KEY `imgurl` (`imgurl`)
+  KEY `imgurl` (`imgurl`),
+  KEY `term_hash` (`term_hash`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `tokens` (
@@ -933,7 +935,7 @@ CREATE TABLE IF NOT EXISTS `xlink` (
   KEY `xlink_link` (`xlink_link`),
   KEY `xlink_updated` (`xlink_updated`),
   KEY `xlink_rating` (`xlink_rating`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `xprof` (
   `xprof_hash` char(255) NOT NULL,
diff --git a/install/update.php b/install/update.php
index c57b8562e..ee95b7e01 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1046 );
+define( 'UPDATE_VERSION' , 1047 );
 
 /**
  *
@@ -565,3 +565,10 @@ ADD INDEX ( `site_register` ) ");
 	return UPDATE_FAILED;
 }
 	
+function update_r1046() {
+	$r = q("ALTER TABLE `term` ADD `term_hash` CHAR( 255 ) NOT NULL DEFAULT '',
+ADD INDEX ( `term_hash` ) ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
diff --git a/mod/thing.php b/mod/thing.php
new file mode 100644
index 000000000..723b069bc
--- /dev/null
+++ b/mod/thing.php
@@ -0,0 +1,43 @@
+<?php /** @file */
+
+
+
+function thing_init(&$a) {
+
+	if(! local_user())
+		return;
+
+	$account_id = $a->get_account();
+
+	$name = escape_tags($_REQUEST['term']);
+	$url = $_REQUEST['link'];
+	$photo = $_REQUEST['photo'];
+
+	$hash = random_string();
+
+
+	if(! $name)
+		return;
+
+	$r = q("insert into term ( aid, uid, oid, otype, type, term, url, imgurl, term_hash )
+		values( %d, %d, %d, %d, %d, '%s', '%s', '%s', '%s' ) ",
+		intval($account_id),
+		intval(local_user()),
+		0,
+		TERM_OBJ_THING,
+		TERM_THING,
+		dbesc($name),
+		dbesc(($url) ? $url : z_root() . '/thing/' . $hash),
+		dbesc(($photo) ? $photo : ''),
+		dbesc($hash)
+	);
+	
+}
+
+
+function thing_content(&$a) {
+
+
+
+
+}