X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fdelegate.php;h=4212ec9b132a4b8ff1a4d4e72d746a9074906ecb;hb=221cfa8c22b724228ed24618569cabcae582d331;hp=f8a0dcb5997b6df3311e4dcf87e8affc7ec0edb4;hpb=09851331a9dc8601919cd0c9200686b92843d235;p=friendica.git

diff --git a/mod/delegate.php b/mod/delegate.php
index f8a0dcb599..4212ec9b13 100644
--- a/mod/delegate.php
+++ b/mod/delegate.php
@@ -23,16 +23,16 @@ function delegate_content(App $a) {
 
 		$id = $a->argv[2];
 
-		$r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
+		$r = q("select `nickname` from user where uid = %d limit 1",
 			intval($id)
 		);
 		if (dbm::is_result($r)) {
-			$r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `nurl` = '%s' LIMIT 1",
+			$r = q("select id from contact where uid = %d and nurl = '%s' limit 1",
 				intval(local_user()),
 				dbesc(normalise_link(App::get_baseurl() . '/profile/' . $r[0]['nickname']))
 			);
 			if (dbm::is_result($r)) {
-				q("INSERT INTO `manage` ( `uid`, `mid` ) VALUES ( %d , %d ) ",
+				q("insert into manage ( uid, mid ) values ( %d , %d ) ",
 					intval($a->argv[2]),
 					intval(local_user())
 				);
@@ -64,40 +64,34 @@ function delegate_content(App $a) {
 		dbesc($a->user['email']),
 		dbesc($a->user['password'])
 	);
-	if (dbm::is_result($r)) {
+	if (dbm::is_result($r))
 		$full_managers = $r;
-	}
 
 	$delegates = array();
 
 	// find everybody that currently has delegated management to this account/page
 
-	$r = q("SELECT * FROM `user` WHERE `uid` IN ( SELECT `uid` FROM `manage` WHERE `mid` = %d ) ",
+	$r = q("select * from user where uid in ( select uid from manage where mid = %d ) ",
 		intval(local_user())
 	);
 
-	if (dbm::is_result($r)) {
+	if (dbm::is_result($r))
 		$delegates = $r;
-	}
 
 	$uids = array();
 
-	if (count($full_managers)) {
-		foreach ($full_managers as $rr) {
+	if(count($full_managers))
+		foreach($full_managers as $rr)
 			$uids[] = $rr['uid'];
-		}
-	}
 
-	if (count($delegates)) {
-		foreach ($delegates as $rr) {
+	if(count($delegates))
+		foreach($delegates as $rr)
 			$uids[] = $rr['uid'];
-		}
-	}
 
 	// find every contact who might be a candidate for delegation
 
-	$r = q("SELECT `nurl` FROM `contact` WHERE SUBSTRING_INDEX(`contact`.`nurl`,'/',3) = '%s'
-		AND `contact`.`uid` = %d AND `contact`.`self` = 0 AND `network` = '%s' ",
+	$r = q("select nurl from contact where substring_index(contact.nurl,'/',3) = '%s'
+		and contact.uid = %d and contact.self = 0 and network = '%s' ",
 		dbesc(normalise_link(App::get_baseurl())),
 		intval(local_user()),
 		dbesc(NETWORK_DFRN)
@@ -122,15 +116,12 @@ function delegate_content(App $a) {
 
 	// get user records for all potential page delegates who are not already delegates or managers
 
-	$r = q("SELECT `uid`, `username`, `nickname` FROM `user` WHERE `nickname` IN ( $nicks )");
+	$r = q("select `uid`, `username`, `nickname` from user where nickname in ( $nicks )");
 
-	if (dbm::is_result($r)) {
-		foreach ($r as $rr) {
-			if (! in_array($rr['uid'],$uids)) {
+	if (dbm::is_result($r))
+		foreach($r as $rr)
+			if(! in_array($rr['uid'],$uids))
 				$potentials[] = $rr;
-			}
-		}
-	}
 
 	require_once("mod/settings.php");
 	settings_init($a);