From e17ba14696d6ee7532bacce6b5519594e001f13f Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 4 Dec 2012 18:24:46 -0800 Subject: DB: do the mail table again. Mail almost working onsite, still needs to zot though --- include/message.php | 188 ++++++++-------------------------------------------- include/nav.php | 2 +- 2 files changed, 30 insertions(+), 160 deletions(-) (limited to 'include') diff --git a/include/message.php b/include/message.php index cf0fe96da..fd9698381 100644 --- a/include/message.php +++ b/include/message.php @@ -1,11 +1,10 @@ get_baseurl() . ':' . local_user() . ':' . $hash ; - - $convid = 0; - $reply = false; - // look for any existing conversation structure - - if(strlen($replyto)) { - $reply = true; - $r = q("select convid from mail where uid = %d and ( uri = '%s' or `parent_uri` = '%s' ) limit 1", - intval(local_user()), - dbesc($replyto), - dbesc($replyto) + if($uid) { + $r = q("select * from channel where channel_id = %d limit 1", + intval($uid) ); - if(count($r)) - $convid = $r[0]['convid']; - } - - if(! $convid) { - - // create a new conversation - - $conv_guid = get_guid(); - - $recip_host = substr($contact[0]['url'],strpos($contact[0]['url'],'://')+3); - $recip_host = substr($recip_host,0,strpos($recip_host,'/')); + if($r) + $channel = $r[0]; + } + else { + $channel = get_app()->get_channel(); + } - $recip_handle = (($contact[0]['addr']) ? $contact[0]['addr'] : $contact[0]['nick'] . '@' . $recip_host); - $sender_handle = $a->user['nickname'] . '@' . substr($a->get_baseurl(), strpos($a->get_baseurl(),'://') + 3); - $handles = $recip_handle . ';' . $sender_handle; + do { + $dups = false; + $hash = random_string(); - $r = q("insert into conv (uid,guid,creator,created,updated,subject,recips) values(%d, '%s', '%s', '%s', '%s', '%s', '%s') ", - intval(local_user()), - dbesc($conv_guid), - dbesc($sender_handle), - dbesc(datetime_convert()), - dbesc(datetime_convert()), - dbesc($subject), - dbesc($handles) - ); + $uri = $hash . '@' . get_app()->get_hostname(); - $r = q("select * from conv where guid = '%s' and uid = %d limit 1", - dbesc($conv_guid), - intval(local_user()) - ); + $r = q("SELECT `id` FROM mail WHERE `uri` = '%s' LIMIT 1", + dbesc($uri)); if(count($r)) - $convid = $r[0]['id']; - } + $dups = true; + } while($dups == true); - if(! $convid) { - logger('send message: conversation not found.'); - return -4; - } if(! strlen($replyto)) { $replyto = $uri; } + - $r = q("INSERT INTO `mail` ( `uid`, `guid`, `convid`, `from-name`, `from-photo`, `from-url`, - `contact-id`, `title`, `body`, `seen`, `reply`, `replied`, `uri`, `parent_uri`, `created`) - VALUES ( %d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', '%s', '%s' )", + $r = q("INSERT INTO `mail` ( account_id, channel_id, from_xchan, to_xchan, title, body, uri, parent_uri, created ) + VALUES ( %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s' )", + intval($channel['channel_account_id']), intval(local_user()), - dbesc(get_guid()), - intval($convid), - dbesc($me[0]['name']), - dbesc($me[0]['thumb']), - dbesc($me[0]['url']), - intval($recipient), + dbesc($channel['channel_hash']), + dbesc($recipient), dbesc($subject), dbesc($body), - 1, - intval($reply), - 0, dbesc($uri), dbesc($replyto), - datetime_convert() + dbesc(datetime_convert()) ); - $r = q("SELECT * FROM `mail` WHERE `uri` = '%s' and `uid` = %d LIMIT 1", + $r = q("SELECT * FROM `mail` WHERE uri = '%s' and channel_id = %d LIMIT 1", dbesc($uri), intval(local_user()) ); if(count($r)) $post_id = $r[0]['id']; + /** * * When a photo was uploaded into the message using the (profile wall) ajax @@ -158,85 +110,3 @@ function send_message($recipient=0, $body='', $subject='', $replyto=''){ } - - - -function send_wallmessage($recipient='', $body='', $subject='', $replyto=''){ - - $a = get_app(); - - if(! $recipient) return -1; - - if(! strlen($subject)) - $subject = t('[no subject]'); - - $hash = random_string(); - $uri = 'urn:X-dfrn:' . $a->get_baseurl() . ':' . local_user() . ':' . $hash ; - - $convid = 0; - $reply = false; - - require_once('include/Scrape.php'); - - $me = probe_url($replyto); - - if(! $me['name']) - return -2; - - $conv_guid = get_guid(); - - $recip_handle = $recipient['nickname'] . '@' . substr($a->get_baseurl(), strpos($a->get_baseurl(),'://') + 3); - - $sender_nick = basename($replyto); - $sender_host = substr($replyto,strpos($replyto,'://')+3); - $sender_host = substr($sender_host,0,strpos($sender_host,'/')); - $sender_handle = $sender_nick . '@' . $sender_host; - - $handles = $recip_handle . ';' . $sender_handle; - - $r = q("insert into conv (uid,guid,creator,created,updated,subject,recips) values(%d, '%s', '%s', '%s', '%s', '%s', '%s') ", - intval(local_user()), - dbesc($conv_guid), - dbesc($sender_handle), - dbesc(datetime_convert()), - dbesc(datetime_convert()), - dbesc($subject), - dbesc($handles) - ); - - $r = q("select * from conv where guid = '%s' and uid = %d limit 1", - dbesc($conv_guid), - intval($recipient['uid']) - ); - if(count($r)) - $convid = $r[0]['id']; - - if(! $convid) { - logger('send message: conversation not found.'); - return -4; - } - - $r = q("INSERT INTO `mail` ( `uid`, `guid`, `convid`, `from-name`, `from-photo`, `from-url`, - `contact-id`, `title`, `body`, `seen`, `reply`, `replied`, `uri`, `parent_uri`, `created`, `unknown`) - VALUES ( %d, '%s', %d, '%s', '%s', '%s', %d, '%s', '%s', %d, %d, %d, '%s', '%s', '%s', %d )", - intval($recipient['uid']), - dbesc(get_guid()), - intval($convid), - dbesc($me['name']), - dbesc($me['photo']), - dbesc($me['url']), - 0, - dbesc($subject), - dbesc($body), - 0, - 0, - 0, - dbesc($uri), - dbesc($replyto), - datetime_convert(), - 1 - ); - - return 0; - -} diff --git a/include/nav.php b/include/nav.php index 24449409b..eacb0f29a 100644 --- a/include/nav.php +++ b/include/nav.php @@ -23,7 +23,7 @@ function nav(&$a) { minChars: 2, width: 250, }); - a.setOptions({ params: { type: 'x' }}); + a.setOptions({ params: { autoSubmit: true, type: 'x' }}); }); -- cgit v1.2.3