X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fprofperm.php;h=0a4b3e9a470697555d1def50a565f3dbaf75c9b4;hb=db2d0e009503539b134fd43837d440028d5b8de7;hp=8d09c429cc3b006976543d7cb17236559815632f;hpb=1872cf2b2d14be5c4b8fbc9e2cf61f9fcd9e2f88;p=friendica.git

diff --git a/mod/profperm.php b/mod/profperm.php
index 8d09c429cc..0a4b3e9a47 100644
--- a/mod/profperm.php
+++ b/mod/profperm.php
@@ -2,11 +2,12 @@
 
 function profperm_init(&$a) {
 
-	if(! local_user())
+	if (! local_user()) {
 		return;
+	}
 
 	$which = $a->user['nickname'];
-	$profile = $a->argv[1];		
+	$profile = $a->argv[1];
 
 	profile_load($a,$which,$profile);
 
@@ -15,7 +16,7 @@ function profperm_init(&$a) {
 
 function profperm_content(&$a) {
 
-	if(! local_user()) {
+	if (! local_user()) {
 		notice( t('Permission denied') . EOL);
 		return;
 	}
@@ -36,12 +37,13 @@ function profperm_content(&$a) {
 
 
 	if(($a->argc > 2) && intval($a->argv[1]) && intval($a->argv[2])) {
-		$r = q("SELECT `id` FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `self` = 0 
-			AND `network` = 'dfrn' AND `id` = %d AND `uid` = %d LIMIT 1",
+		$r = q("SELECT `id` FROM `contact` WHERE `blocked` = 0 AND `pending` = 0 AND `self` = 0
+			AND `network` = '%s' AND `id` = %d AND `uid` = %d LIMIT 1",
+			dbesc(NETWORK_DFRN),
 			intval($a->argv[2]),
 			intval(local_user())
 		);
-		if(count($r))
+		if (dbm::is_result($r))
 			$change = intval($a->argv[2]);
 	}
 
@@ -51,7 +53,7 @@ function profperm_content(&$a) {
 			intval($a->argv[1]),
 			intval(local_user())
 		);
-		if(! count($r)) {
+		if (! dbm::is_result($r)) {
 			notice( t('Invalid profile identifier.') . EOL );
 			return;
 		}
@@ -63,7 +65,7 @@ function profperm_content(&$a) {
 		);
 
 		$ingroup = array();
-		if(count($r))
+		if (dbm::is_result($r))
 			foreach($r as $member)
 				$ingroup[] = $member['id'];
 
@@ -71,13 +73,13 @@ function profperm_content(&$a) {
 
 		if($change) {
 			if(in_array($change,$ingroup)) {
-				q("UPDATE `contact` SET `profile-id` = 0 WHERE `id` = %d AND `uid` = %d LIMIT 1",
+				q("UPDATE `contact` SET `profile-id` = 0 WHERE `id` = %d AND `uid` = %d",
 					intval($change),
 					intval(local_user())
 				);
 			}
 			else {
-				q("UPDATE `contact` SET `profile-id` = %d WHERE `id` = %d AND `uid` = %d LIMIT 1",
+				q("UPDATE `contact` SET `profile-id` = %d WHERE `id` = %d AND `uid` = %d",
 					intval($a->argv[1]),
 					intval($change),
 					intval(local_user())
@@ -93,7 +95,7 @@ function profperm_content(&$a) {
 			$members = $r;
 
 			$ingroup = array();
-			if(count($r))
+			if (dbm::is_result($r))
 				foreach($r as $member)
 					$ingroup[] = $member['id'];
 		}
@@ -130,13 +132,14 @@ function profperm_content(&$a) {
 	$o .= '<h3>' . t("All Contacts \x28with secure profile access\x29") . '</h3>';
 	$o .= '</div>';
 	$o .= '<div id="prof-all-contacts">';
-		
-		$r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `blocked` = 0 and `pending` = 0 and `self` = 0 
-			AND `network` = 'dfrn' ORDER BY `name` ASC",
-			intval(local_user())
+
+		$r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `blocked` = 0 and `pending` = 0 and `self` = 0
+			AND `network` = '%s' ORDER BY `name` ASC",
+			intval(local_user()),
+			dbesc(NETWORK_DFRN)
 		);
 
-		if(count($r)) {
+		if (dbm::is_result($r)) {
 			$textmode = (($switchtotext && (count($r) > $switchtotext)) ? true : false);
 			foreach($r as $member) {
 				if(! in_array($member['id'],$ingroup)) {