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

diff --git a/communityhome/communityhome.php b/communityhome/communityhome.php
index a4c956c2..dc0a6baf 100644
--- a/communityhome/communityhome.php
+++ b/communityhome/communityhome.php
@@ -5,6 +5,7 @@
  * Description: Show last community activity in homepage
  * Version: 2.0
  * Author: Fabio Comuni <http://kirgroup.com/profile/fabrixxm>
+ * Status: Unsupported
  */
 
 use Friendica\App;
@@ -32,7 +33,6 @@ 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')
@@ -118,40 +118,7 @@ function communityhome_home(App $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');