sql syntax

[friendica.git] / include / network.php

diff --git a/include/network.php b/include/network.php
index 9871b9edcdd3df59b3f7eb9ed9d4b8fc3c4d9d29..10e3648a181642b49092a4c34a47618b9f68110f 100644 (file)
--- a/include/network.php
+++ b/include/network.php
@@ -536,8 +536,10 @@ function fetch_xrd_links($url) {
                        $aliases = array($alias);
                else
                        $aliases = $alias;
-               foreach($aliases as $alias) {
-                       $links[]['@attributes'] = array('rel' => 'alias' , 'href' => $alias);
+               if(count($aliases)) {
+                       foreach($aliases as $alias) {
+                               $links[]['@attributes'] = array('rel' => 'alias' , 'href' => $alias);
+                       }
                }
        }
 
@@ -691,3 +693,25 @@ function parse_xml_string($s,$strict = true) {
        }
        return $x;
 }}
+
+function add_fcontact($arr) {
+
+       $r = q("insert into fcontact ( `url`,`name`,`photo`,`request`,`nick`,`addr`,
+               `notify`,`poll`,`confirm`,`network`,`alias`,`pubkey`,`updated` )
+               values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
+               dbesc($arr['url']),
+               dbesc($arr['name']),
+               dbesc($arr['photo']),
+               dbesc($arr['request']),
+               dbesc($arr['nick']),
+               dbesc($arr['addr']),
+               dbesc($arr['notify']),
+               dbesc($arr['poll']),
+               dbesc($arr['confirm']),
+               dbesc($arr['network']),
+               dbesc($arr['alias']),
+               dbesc($arr['pubkey']),
+               dbesc(datetime_convert())
+       );
+       return $r;
+}