Merge pull request #1157 from MrPetovan/task/advancecontentfilter-attachments

[friendica-addons.git] / widgets / widget_like.php

diff --git a/widgets/widget_like.php b/widgets/widget_like.php
index 2e3879544dfe90554c75ac2b05e4143debb7c3e7..9b347d94adfdcd22478fdabc1d174ee8207d66ca 100644 (file)
--- a/widgets/widget_like.php
+++ b/widgets/widget_like.php
@@ -1,6 +1,9 @@
 <?php
 
 use Friendica\Core\L10n;
+use Friendica\Core\Renderer;
+use Friendica\Database\DBA;
+use Friendica\DI;
 
 function like_widget_name() {
        return "Shows likes";
@@ -22,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` = ''
@@ -32,38 +35,38 @@ 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);
+       }
 
 
-       require_once("include/conversation.php");
-
        $o = "";
 
 #      $t = file_get_contents( dirname(__file__). "/widget_like.tpl" );
-       $t = get_markup_template("widget_like.tpl", "addon/widgets/");
-       $o .= replace_macros($t, [
+       $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->get_baseurl(),
+               '$strdislike'=> $strdislike,
        ]);
 
        return $o;