group_public_members sql query typo

[friendica.git] / include / diaspora.php

diff --git a/include/diaspora.php b/include/diaspora.php
index 5e751f4ba6442e57785026657d2b8cbcfb5ee588..6d070ecba4f2f0a9b6ae3cb717a10e9886b200e1 100644 (file)
--- a/include/diaspora.php
+++ b/include/diaspora.php
@@ -398,6 +398,7 @@ function diaspora_request($importer,$xml) {
 
 function diaspora_post($importer,$xml) {
 
+       $a = get_app();
        $guid = notags(unxmlify($xml->guid));
        $diaspora_handle = notags(unxmlify($xml->diaspora_handle));
 
@@ -417,8 +418,10 @@ function diaspora_post($importer,$xml) {
                dbesc($message_id),
                dbesc($guid)
        );
-       if(count($r))
+       if(count($r)) {
+               logger('diaspora_post: message exists: ' . $guid);
                return;
+       }
 
     // allocate a guid on our system - we aren't fixing any collisions.
        // we're ignoring them
@@ -455,7 +458,14 @@ function diaspora_post($importer,$xml) {
        $datarray['body'] = $body;
        $datarray['app']  = 'Diaspora';
 
-       item_store($datarray);
+       $message_id = item_store($datarray);
+
+       if($message_id) {
+               q("update item set plink = '%s' where id = %d limit 1",
+                       dbesc($a->get_baseurl() . '/display/' . $importer['nickname'] . '/' . $message_id),
+                       intval($message_id)
+               );
+       }
 
        return;
 
@@ -463,6 +473,7 @@ function diaspora_post($importer,$xml) {
 
 function diaspora_comment($importer,$xml,$msg) {
 
+       $a = get_app();
        $guid = notags(unxmlify($xml->guid));
        $parent_guid = notags(unxmlify($xml->parent_guid));
        $diaspora_handle = notags(unxmlify($xml->diaspora_handle));
@@ -475,8 +486,10 @@ function diaspora_comment($importer,$xml,$msg) {
        $text = $xml->text;
 
        $contact = diaspora_get_contact_by_handle($importer['uid'],$msg['author']);
-       if(! $contact)
+       if(! $contact) {
+               logger('diaspora_comment: cannot find contact: ' . $msg['author']);
                return;
+       }
 
        if(($contact['rel'] == CONTACT_IS_FOLLOWER) || ($contact['blocked']) || ($contact['readonly'])) { 
                logger('diaspora_comment: Ignoring this author.');
@@ -489,7 +502,7 @@ function diaspora_comment($importer,$xml,$msg) {
                dbesc($guid)
        );
        if(count($r)) {
-               logger('daspora_comment: our comment just got relayed back to us (or there was a guid collision) : ' . $guid);
+               logger('diaspora_comment: our comment just got relayed back to us (or there was a guid collision) : ' . $guid);
                return;
        }
 
@@ -572,6 +585,13 @@ function diaspora_comment($importer,$xml,$msg) {
 
        $message_id = item_store($datarray);
 
+       if($message_id) {
+               q("update item set plink = '%s' where id = %d limit 1",
+                       dbesc($a->get_baseurl() . '/display/' . $importer['nickname'] . '/' . $message_id),
+                       intval($message_id)
+               );
+       }
+
        if(! $parent_author_signature) {
                q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
                        intval($message_id),
@@ -591,6 +611,7 @@ function diaspora_comment($importer,$xml,$msg) {
 
 function diaspora_photo($importer,$xml,$msg) {
 
+       $a = get_app();
        $remote_photo_path = notags(unxmlify($xml->remote_photo_path));
 
        $remote_photo_name = notags(unxmlify($xml->remote_photo_name));
@@ -658,8 +679,10 @@ function diaspora_like($importer,$xml,$msg) {
                return;
 
        $contact = diaspora_get_contact_by_handle($importer['uid'],$msg['author']);
-       if(! $contact)
+       if(! $contact) {
+               logger('diaspora_like: cannot find contact: ' . $msg['author']);
                return;
+       }
 
        if(($contact['rel'] == CONTACT_IS_FOLLOWER) || ($contact['blocked']) || ($contact['readonly'])) { 
                logger('diaspora_like: Ignoring this author.');
@@ -726,8 +749,8 @@ function diaspora_like($importer,$xml,$msg) {
        }
 
        if($parent_author_signature) {
-//             $owner_signed_data = $guid . ';' . $parent_guid . ';' . $target_type . ';' . $positive . ';' . $msg['author'];
-               $owner_signed_data = $guid . ';' . $parent_guid . ';' . $target_type . ';' . $positive . ';' . $diaspora_handle;
+
+               $owner_signed_data = $guid . ';' . $target_type . ';' . $parent_guid . ';' . $positive . ';' . $diaspora_handle;
 
                $parent_author_signature = base64_decode($parent_author_signature);
 
@@ -799,6 +822,14 @@ EOT;
 
        $message_id = item_store($arr);
 
+
+       if($message_id) {
+               q("update item set plink = '%s' where id = %d limit 1",
+                       dbesc($a->get_baseurl() . '/display/' . $importer['nickname'] . '/' . $message_id),
+                       intval($message_id)
+               );
+       }
+
        if(! $parent_author_signature) {
                q("insert into sign (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
                        intval($message_id),
@@ -915,7 +946,7 @@ function diaspora_send_status($item,$owner,$contact) {
        $public = (($item['private']) ? 'false' : 'true');
 
        require_once('include/datetime.php');
-       $created = datetime_convert('UTC','UTC',$item['created'],'Y-m-d h:i:s \U\T\C');
+       $created = datetime_convert('UTC','UTC',$item['created'],'Y-m-d H:i:s \U\T\C');
 
        $tpl = get_markup_template('diaspora_post.tpl');
        $msg = replace_macros($tpl, array(
@@ -967,7 +998,7 @@ function diaspora_send_images($item,$owner,$contact,$images) {
                        '$guid' => xmlify($r[0]['guid']),
                        '$handle' => xmlify($image['handle']),
                        '$public' => xmlify($public),
-                       '$created_at' => xmlify(datetime_convert('UTC','UTC',$r[0]['created'],'Y-m-d h:i:s \U\T\C'))
+                       '$created_at' => xmlify(datetime_convert('UTC','UTC',$r[0]['created'],'Y-m-d H:i:s \U\T\C'))
                ));