aboutsummaryrefslogtreecommitdiffstats
path: root/include/message.php
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-12-04 18:24:46 -0800
committerfriendica <info@friendica.com>2012-12-04 18:24:46 -0800
commite17ba14696d6ee7532bacce6b5519594e001f13f (patch)
tree490c90c8ec7cebc3fec94a7ad4c1eab4e9bacab3 /include/message.php
parent707397580c1c4547c0e308f90df61bc68e91b219 (diff)
downloadvolse-hubzilla-e17ba14696d6ee7532bacce6b5519594e001f13f.tar.gz
volse-hubzilla-e17ba14696d6ee7532bacce6b5519594e001f13f.tar.bz2
volse-hubzilla-e17ba14696d6ee7532bacce6b5519594e001f13f.zip
DB: do the mail table again. Mail almost working onsite, still needs to zot though
Diffstat (limited to 'include/message.php')
-rw-r--r--include/message.php188
1 files changed, 29 insertions, 159 deletions
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 @@
<?php
- // send a private message
-
-
+// send a private message
+
-function send_message($recipient=0, $body='', $subject='', $replyto=''){
+function send_message($uid = 0, $recipient='', $body='', $subject='', $replyto=''){
$a = get_app();
@@ -14,107 +13,60 @@ function send_message($recipient=0, $body='', $subject='', $replyto=''){
if(! strlen($subject))
$subject = t('[no subject]');
- $me = q("SELECT * FROM `contact` WHERE `uid` = %d AND `self` = 1 LIMIT 1",
- intval(local_user())
- );
- $contact = q("SELECT * FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
- intval($recipient),
- intval(local_user())
- );
-
- if(! (count($me) && (count($contact)))) {
- return -2;
- }
-
- $hash = random_string();
- $uri = 'urn:X-dfrn:' . $a->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;
-
-}