bug #85

[friendica.git] / mod / ping.php

diff --git a/mod/ping.php b/mod/ping.php
index bc160ade7f5abae284534e5892bb247d89f17cbb..b736ea995c18c9b35ea976c1b60368e31a06925f 100644 (file)
--- a/mod/ping.php
+++ b/mod/ping.php
@@ -8,28 +8,43 @@ function ping_init(&$a) {
                xml_status(0);
 
        $r = q("SELECT COUNT(*) AS `total` FROM `item` 
-               WHERE `unseen` = 1 AND `uid` = %d",
-               intval($_SESSION['uid'])
+               WHERE `unseen` = 1 AND `visible` = 1 AND `deleted` = 0 AND `uid` = %d",
+               intval(local_user())
        );
        $network = $r[0]['total'];
 
        $r = q("SELECT COUNT(*) AS `total` FROM `item` 
-               WHERE `unseen` = 1 AND `uid` = %d AND `type` != 'remote' ",
-               intval($_SESSION['uid'])
+               WHERE `unseen` = 1 AND `visible` = 1 AND `deleted` = 0 AND `uid` = %d AND `wall` = 1 ",
+               intval(local_user())
        );
        $home = $r[0]['total'];
 
        $r = q("SELECT COUNT(*) AS `total` FROM `intro` 
                WHERE `uid` = %d  AND `blocked` = 0 AND `ignore` = 0 ",
-               intval($_SESSION['uid'])
+               intval(local_user())
        );
        $intro = $r[0]['total'];
 
-       // TODO
-       $mail = 0;
+       if ($a->config['register_policy'] == REGISTER_APPROVE &&        
+               $a->config['admin_email'] === $a->user['email']){
+                       $r = q("SELECT COUNT(*) AS `total` FROM `register`");
+                       $register = $r[0]['total'];
+       } else {
+               $register = "0";
+       }
 
+
+       $myurl = $a->get_baseurl() . '/profile/' . $a->user['nickname'] ;
+       $r = q("SELECT COUNT(*) AS `total` FROM `mail`
+               WHERE `uid` = %d AND `seen` = 0 AND `from-url` != '%s' ",
+               intval(local_user()),
+               dbesc($myurl)
+       );
+
+       $mail = $r[0]['total'];
+       
        header("Content-type: text/xml");
-       echo "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<result><intro>$intro</intro><mail>$mail</mail><net>$network</net><home>$home</home></result>\r\n";
+       echo "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<result><register>$register</register><intro>$intro</intro><mail>$mail</mail><net>$network</net><home>$home</home></result>\r\n";
 
        killme();
 }