remove public disclosure risk

[friendica.git] / mod / ping.php

diff --git a/mod/ping.php b/mod/ping.php
index bc160ade7f5abae284534e5892bb247d89f17cbb..924f9ff76bff228c0db16ff41e91c34d2c59d25c 100644 (file)
--- a/mod/ping.php
+++ b/mod/ping.php
@@ -8,28 +8,41 @@ 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 AND `wall` = 0 ",
+               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;
+       $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'];
+
+       if ($a->config['register_policy'] == REGISTER_APPROVE && is_site_admin()){
+               $r = q("SELECT COUNT(*) AS `total` FROM `register`");
+               $register = $r[0]['total'];
+       } else {
+               $register = "0";
+       }
 
+       
        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><intro>$intro</intro><mail>$mail</mail><net>$network</net><home>$home</home><register>$register</register></result>\r\n";
 
        killme();
 }