From f7c6a6ff9071c120f5bd6efe51cdb934e0c30cc7 Mon Sep 17 00:00:00 2001 From: friendica Date: Wed, 15 Aug 2012 22:33:37 -0700 Subject: item table rename parent-uri, target-type, object-type (more to come later) --- view/theme/diabook/theme.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'view/theme/diabook') diff --git a/view/theme/diabook/theme.php b/view/theme/diabook/theme.php index 53048df6c..2c8290344 100644 --- a/view/theme/diabook/theme.php +++ b/view/theme/diabook/theme.php @@ -540,9 +540,9 @@ if ($color=="dark") $color_path = "/diabook-dark/"; $aside['$like_title'] = t('Last likes'); $aside['$like_items'] = array(); $r = q("SELECT `T1`.`created`, `T1`.`liker`, `T1`.`liker-link`, `item`.* FROM - (SELECT `parent-uri`, `created`, `author-name` AS `liker`,`author-link` AS `liker-link` - FROM `item` WHERE `verb`='http://activitystrea.ms/schema/1.0/like' GROUP BY `parent-uri` ORDER BY `created` DESC) AS T1 - INNER JOIN `item` ON `item`.`uri`=`T1`.`parent-uri` + (SELECT `parent_uri`, `created`, `author-name` AS `liker`,`author-link` AS `liker-link` + FROM `item` WHERE `verb`='http://activitystrea.ms/schema/1.0/like' GROUP BY `parent_uri` ORDER BY `created` DESC) AS T1 + INNER JOIN `item` ON `item`.`uri`=`T1`.`parent_uri` WHERE `T1`.`liker-link` LIKE '%s%%' OR `item`.`author-link` LIKE '%s%%' GROUP BY `uri` ORDER BY `T1`.`created` DESC @@ -554,10 +554,10 @@ if ($color=="dark") $color_path = "/diabook-dark/"; $author = '' . $rr['liker'] . ''; $objauthor = '' . $rr['author-name'] . ''; - //var_dump($rr['verb'],$rr['object-type']); killme(); + //var_dump($rr['verb'],$rr['obj_type']); killme(); switch($rr['verb']){ case 'http://activitystrea.ms/schema/1.0/post': - switch ($rr['object-type']){ + switch ($rr['obj_type']){ case 'http://activitystrea.ms/schema/1.0/event': $post_type = t('event'); break; -- cgit v1.2.3