widgets/widget_like.php

   1 <?php
   2
   3 use Friendica\Core\L10n;
   4 use Friendica\Core\Renderer;
   5 use Friendica\Database\DBA;
   6 use Friendica\DI;
   7
   8 function like_widget_name() {
   9         return "Shows likes";
  10 }
  11 function like_widget_help() {
  12         return "Search first item which contains <em>KEY</em> and print like/dislike count";
  13 }
  14
  15 function like_widget_args(){
  16         return ["KEY"];
  17 }
  18
  19 function like_widget_size(){
  20         return ['60px','20px'];
  21 }
  22
  23
  24 function like_widget_content(&$a, $conf){
  25         $args = explode(",",$_GET['a']);
  26
  27
  28         $baseq="SELECT COUNT(`item`.`id`) as `c`, `p`.`id`
  29                                         FROM `item`,
  30                                                 (SELECT `i`.`id` FROM `item` as `i` WHERE
  31                                                         `i`.`visible` = 1 AND `i`.`deleted` = 0
  32                                                         AND (( `i`.`wall` = 1 AND `i`.`allow_cid` = ''
  33                                                                         AND `i`.`allow_gid` = ''
  34                                                                         AND `i`.`deny_cid`  = ''
  35                                                                         AND `i`.`deny_gid`  = '' )
  36                                                                   OR `i`.`uid` = %d )
  37                                                         AND `i`.`body` LIKE '%%%s%%' LIMIT 1) as `p`
  38                                         WHERE `item`.`parent` = `p`.`id` ";
  39
  40         // count likes
  41         $r = q( $baseq . "AND `item`.`verb` = 'http://activitystrea.ms/schema/1.0/like'",
  42                         intval($conf['uid']),
  43                         DBA::escape($args[0])
  44         );
  45         $likes = $r[0]['c'];
  46         $iid = $r[0]['id'];
  47
  48         // count dislikes
  49         $r = q( $baseq . "AND `item`.`verb` = 'http://purl.org/macgirvin/dfrn/1.0/dislike'",
  50                         intval($conf['uid']),
  51                         DBA::escape($args[0])
  52         );
  53         $dislikes = $r[0]['c'];
  54
  55
  56         $o = "";
  57
  58 #       $t = file_get_contents( dirname(__file__). "/widget_like.tpl" );
  59         $t = Renderer::getMarkupTemplate("widget_like.tpl", "addon/widgets/");
  60         $o .= Renderer::replaceMacros($t, [
  61                 '$like'         => $likes,
  62                 '$strlike'      => DI::l10n()->tt("%d person likes this", "%d people like this", $likes),
  63
  64                 '$dislike'      => $dislikes,
  65                 '$strdislike'=> DI::l10n()->tt("%d person doesn't like this", "%d people don't like this", $dislikes),
  66         ]);
  67
  68         return $o;
  69 }