X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=widgets%2Fwidget_like.php;h=9b347d94adfdcd22478fdabc1d174ee8207d66ca;hb=da159e9d2c95e341a39bdc845291ea97be0ca61f;hp=56ad1e5b35abbda726541899d9de8e593e52955d;hpb=94ed7bf163e0b814afcc159ddaf00bf652e7387d;p=friendica-addons.git

diff --git a/widgets/widget_like.php b/widgets/widget_like.php
index 56ad1e5b..9b347d94 100644
--- a/widgets/widget_like.php
+++ b/widgets/widget_like.php
@@ -3,6 +3,7 @@
 use Friendica\Core\L10n;
 use Friendica\Core\Renderer;
 use Friendica\Database\DBA;
+use Friendica\DI;
 
 function like_widget_name() {
 	return "Shows likes";
@@ -24,9 +25,9 @@ function like_widget_content(&$a, $conf){
 	$args = explode(",",$_GET['a']);
 
 
-	$baseq="SELECT COUNT(`item`.`id`) as `c`, `p`.`id`
-					FROM `item`,
-						(SELECT `i`.`id` FROM `item` as `i` WHERE
+	$baseq="SELECT COUNT(`post-view`.`id`) as `c`, `p`.`id`
+					FROM `post-view`,
+						(SELECT `i`.`id` FROM `post-view` as `i` WHERE
 							`i`.`visible` = 1 AND `i`.`deleted` = 0
 							AND (( `i`.`wall` = 1 AND `i`.`allow_cid` = ''
 									AND `i`.`allow_gid` = ''
@@ -34,22 +35,26 @@ function like_widget_content(&$a, $conf){
 									AND `i`.`deny_gid`  = '' )
 								  OR `i`.`uid` = %d )
 							AND `i`.`body` LIKE '%%%s%%' LIMIT 1) as `p`
-					WHERE `item`.`parent` = `p`.`id` ";
+					WHERE `post-view`.`parent` = `p`.`id` ";
 
 	// count likes
-	$r = q( $baseq . "AND `item`.`verb` = 'http://activitystrea.ms/schema/1.0/like'",
+	$r = q( $baseq . "AND `post-view`.`verb` = 'http://activitystrea.ms/schema/1.0/like'",
 			intval($conf['uid']),
 			DBA::escape($args[0])
 	);
 	$likes = $r[0]['c'];
-	$iid = $r[0]['id'];
 
-	// count dislikes
-	$r = q( $baseq . "AND `item`.`verb` = 'http://purl.org/macgirvin/dfrn/1.0/dislike'",
-			intval($conf['uid']),
-			DBA::escape($args[0])
-	);
-	$dislikes = $r[0]['c'];
+	$dislikes = 0;
+	$strdislike = '';
+	if (!DI::pConfig()->get(local_user(), 'system', 'hide_dislike')) {
+		// count dislikes
+		$r = q( $baseq . "AND `post-view`.`verb` = 'http://purl.org/macgirvin/dfrn/1.0/dislike'",
+				intval($conf['uid']),
+				DBA::escape($args[0])
+		);
+		$dislikes = $r[0]['c'];
+		$strdislike = DI::l10n()->tt("%d person doesn't like this", "%d people don't like this", $dislikes);
+	}
 
 
 	$o = "";
@@ -58,12 +63,10 @@ function like_widget_content(&$a, $conf){
 	$t = Renderer::getMarkupTemplate("widget_like.tpl", "addon/widgets/");
 	$o .= Renderer::replaceMacros($t, [
 		'$like'		=> $likes,
-		'$strlike'	=> L10n::tt("%d person likes this", "%d people like this", $likes),
+		'$strlike'	=> DI::l10n()->tt("%d person likes this", "%d people like this", $likes),
 
 		'$dislike'	=> $dislikes,
-		'$strdislike'=> L10n::tt("%d person doesn't like this", "%d people don't like this", $dislikes),
-
-		'$baseurl' => $a->getBaseURL(),
+		'$strdislike'=> $strdislike,
 	]);
 
 	return $o;