widgets/widget_like.php

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