X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=communityhome%2Fcommunityhome.php;h=dc0a6bafaca64b0d7dec64cefc5e2c395dd71e63;hb=4c4a8da6126cb6ff04f9e52bcab62129b6c5cd63;hp=11309635af5905987386a900dfa0c20870a1cb1e;hpb=cc6108d9caa35384e16a050012cd7def687c2262;p=friendica-addons.git

diff --git a/communityhome/communityhome.php b/communityhome/communityhome.php
index 11309635..dc0a6baf 100644
--- a/communityhome/communityhome.php
+++ b/communityhome/communityhome.php
@@ -5,7 +5,10 @@
  * Description: Show last community activity in homepage
  * Version: 2.0
  * Author: Fabio Comuni <http://kirgroup.com/profile/fabrixxm>
+ * Status: Unsupported
  */
+
+use Friendica\App;
 use Friendica\Core\Addon;
 use Friendica\Core\Config;
 use Friendica\Core\L10n;
@@ -30,14 +33,13 @@ function communityhome_getopts()
 	return [
 		'hidelogin' => L10n::t('Hide login form'),
 		'showlastusers' => L10n::t('Show last new users'),
-		'showactiveusers' => L10n::t('Show last active users'),
 		'showlastphotos' => L10n::t('Show last photos'),
 		'showlastlike' => L10n::t('Show last liked items'),
 		'showcommunitystream' => L10n::t('Show community stream')
 	];
 }
 
-function communityhome_addon_admin(&$a, &$o)
+function communityhome_addon_admin(App $a, &$o)
 {
 	$tpl = get_markup_template('settings.tpl', 'addon/communityhome/');
 
@@ -53,7 +55,7 @@ function communityhome_addon_admin(&$a, &$o)
 	$o = replace_macros($tpl, $ctx);
 }
 
-function communityhome_addon_admin_post(&$a, &$b)
+function communityhome_addon_admin_post(App $a)
 {
 	if (x($_POST, 'communityhome-submit')) {
 		$opts = communityhome_getopts();
@@ -63,7 +65,7 @@ function communityhome_addon_admin_post(&$a, &$b)
 	}
 }
 
-function communityhome_home(&$a, &$o)
+function communityhome_home(App $a, &$o)
 {
 	// custom css
 	$a->page['htmlhead'] .= '<link rel="stylesheet" type="text/css" href="' . $a->get_baseurl() . '/addon/communityhome/communityhome.css" media="all" />';
@@ -116,40 +118,7 @@ function communityhome_home(&$a, &$o)
 			}
 		}
 	}
-	// 12 most active users (by posts and contacts)
-	// this query don't work on some mysql versions
-	if (Config::get('communityhome', 'showactiveusers')) {
-		$r = q("SELECT `uni`.`contacts`,`uni`.`items`, `profile`.*, `profile`.`uid` AS `profile_uid`, `user`.`nickname`  FROM
-				(SELECT COUNT(*) as `contacts`, `uid` FROM `contact` WHERE `self`=0 GROUP BY `uid`) AS `con`,
-				(SELECT COUNT(*) as `items`, `uid` FROM `item` WHERE `item`.`changed` > DATE(NOW() - INTERVAL 1 MONTH) AND `item`.`wall` = 1 GROUP BY `uid`) AS `ite`,
-				(
-				SELECT `contacts`,`items`,`ite`.`uid` FROM `con` RIGHT OUTER JOIN `ite` ON `con`.`uid`=`ite`.`uid`
-				UNION ALL
-				SELECT `contacts`,`items`,`con`.`uid` FROM `con` LEFT OUTER JOIN `ite` ON `con`.`uid`=`ite`.`uid`
-				) AS `uni`, `user`, `profile`
-				WHERE `uni`.`uid`=`user`.`uid`
-				AND `uni`.`uid`=`profile`.`uid` AND `profile`.`publish`=1
-				GROUP BY `uid`
-				ORDER BY `items` DESC,`contacts` DESC
-				LIMIT 0,10");
-		if ($r && count($r)) {
-			$aside['$activeusers_title'] = L10n::t('Most active users');
-			$aside['$activeusers_items'] = [];
 
-			$photo = 'thumb';
-			foreach ($r as $rr) {
-				$profile_link = $a->get_baseurl() . '/profile/' . ((strlen($rr['nickname'])) ? $rr['nickname'] : $rr['profile_uid']);
-				$entry = replace_macros($tpl, [
-					'$id' => $rr['id'],
-					'$profile_link' => $profile_link,
-					'$photo' => $rr[$photo],
-					'$photo_user' => sprintf("%s (%s posts, %s contacts)", $rr['name'], ($rr['items'] ? $rr['items'] : '0'),
-						($rr['contacts'] ? $rr['contacts'] : '0'))
-				]);
-				$aside['$activeusers_items'][] = $entry;
-			}
-		}
-	}
 	// last 12 photos
 	if (Config::get('communityhome', 'showlastphotos')) {
 		$aside['$photos_title'] = L10n::t('Latest photos');