X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=widgets%2Fwidget_like.php;h=8dd6b8a7a22dd63ede0f1119889d1f673d6b36ff;hb=14c09c1bbba1324bd03f58d6af123ba53b29070c;hp=6927d43241390a35e064b20e987839884ddeedcf;hpb=056921b1e8d64702535f03e238bc2e451ddca646;p=friendica-addons.git

diff --git a/widgets/widget_like.php b/widgets/widget_like.php
index 6927d432..8dd6b8a7 100644
--- a/widgets/widget_like.php
+++ b/widgets/widget_like.php
@@ -1,5 +1,10 @@
 <?php
 
+use Friendica\Core\L10n;
+use Friendica\Core\Renderer;
+use Friendica\Database\DBA;
+use Friendica\DI;
+
 function like_widget_name() {
 	return "Shows likes";
 }
@@ -8,15 +13,61 @@ function like_widget_help() {
 }
 
 function like_widget_args(){
-	return Array("KEY");
+	return ["KEY"];
+}
+
+function like_widget_size(){
+	return ['60px','20px'];
 }
 
+
 function like_widget_content(&$a, $conf){
 	$args = explode(",",$_GET['a']);
-	
-	if ($args[0]!=""){
-		return " #TODO like/dislike count for item with <em>" .$args[0]. "</em> # ";
-	} else {
-		return " #TODO# ";
+
+
+	$baseq="SELECT COUNT(`item`.`id`) as `c`, `p`.`id`
+					FROM `item`,
+						(SELECT `i`.`id` FROM `item` as `i` WHERE
+							`i`.`visible` = 1 AND `i`.`deleted` = 0
+							AND (( `i`.`wall` = 1 AND `i`.`allow_cid` = ''
+									AND `i`.`allow_gid` = ''
+									AND `i`.`deny_cid`  = ''
+									AND `i`.`deny_gid`  = '' )
+								  OR `i`.`uid` = %d )
+							AND `i`.`body` LIKE '%%%s%%' LIMIT 1) as `p`
+					WHERE `item`.`parent` = `p`.`id` ";
+
+	// count likes
+	$r = q( $baseq . "AND `item`.`verb` = 'http://activitystrea.ms/schema/1.0/like'",
+			intval($conf['uid']),
+			DBA::escape($args[0])
+	);
+	$likes = $r[0]['c'];
+
+	$dislikes = 0;
+	$strdislike = '';
+	if (!DI::pConfig()->get(local_user(), 'system', 'hide_dislike')) {
+		// 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'];
+		$strdislike = DI::l10n()->tt("%d person doesn't like this", "%d people don't like this", $dislikes);
 	}
+
+
+	$o = "";
+
+#	$t = file_get_contents( dirname(__file__). "/widget_like.tpl" );
+	$t = Renderer::getMarkupTemplate("widget_like.tpl", "addon/widgets/");
+	$o .= Renderer::replaceMacros($t, [
+		'$like'		=> $likes,
+		'$strlike'	=> DI::l10n()->tt("%d person likes this", "%d people like this", $likes),
+
+		'$dislike'	=> $dislikes,
+		'$strdislike'=> $strdislike,
+	]);
+
+	return $o;
 }