X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fping.php;h=9f7191758e02b1816a8e92f3bb1da39c2cefcf53;hb=4eb1c1eb1a9d830151aa6437fefb4e7a590064e8;hp=bc160ade7f5abae284534e5892bb247d89f17cbb;hpb=ba8da761e669b22e16e1075e0e1e79d8b458af3e;p=friendica.git

diff --git a/mod/ping.php b/mod/ping.php
index bc160ade7f..9f7191758e 100644
--- a/mod/ping.php
+++ b/mod/ping.php
@@ -8,26 +8,32 @@ 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(get_uid())
 	);
 	$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 `type` != 'remote' ",
+		intval(get_uid())
 	);
 	$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(get_uid())
 	);
 	$intro = $r[0]['total'];
 
-	// TODO
-	$mail = 0;
+	$myurl = $a->get_baseurl() . '/profile/' . $user['nickname'] ;
+	$r = q("SELECT COUNT(*) AS `total` FROM `mail`
+		WHERE `uid` = %d AND `seen` = 0 AND `from-url` != '%s' ",
+		intval(get_uid()),
+		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";