From d7b81b1afd150ebc0abfcd12f6ab23d65b61a0af Mon Sep 17 00:00:00 2001 From: zottel Date: Tue, 1 Oct 2013 09:36:28 +0200 Subject: Add possibility to use a block a channel menu (set channel_menublock to the lowercase title of the block without special chars) Fix comanche_block() SQL --- include/comanche.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'include/comanche.php') diff --git a/include/comanche.php b/include/comanche.php index 526819572..f1dd0e521 100644 --- a/include/comanche.php +++ b/include/comanche.php @@ -87,7 +87,7 @@ function comanche_replace_region($match) { function comanche_block($name) { $o = ''; - $r = q("select * from item left join item_id on iid = item_id and item_id.uid = item.uid and item.uid = %d and service = 'BUILDBLOCK' and sid = '%s' limit 1", + $r = q("select * from item inner join item_id on iid = item.id and item_id.uid = item.uid and item.uid = %d and service = 'BUILDBLOCK' and sid = '%s' limit 1", intval(get_app()->profile['profile_uid']), dbesc($name) ); -- cgit v1.2.3