From 30550795186dbaf926fb81f1647428ebe0dd9809 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Mon, 2 Oct 2006 19:21:26 +0000
Subject: [PATCH] fixed sql text quoting, other fixes in blog ahead

---
 blocks/blog_tags/block_blog_tags.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/blocks/blog_tags/block_blog_tags.php b/blocks/blog_tags/block_blog_tags.php
index f1ee063a31..4ef68bf634 100644
--- a/blocks/blog_tags/block_blog_tags.php
+++ b/blocks/blog_tags/block_blog_tags.php
@@ -75,7 +75,7 @@ class block_blog_tags extends block_base {
         $sql .= "FROM {$CFG->prefix}tags as t, {$CFG->prefix}blog_tag_instance as bt, {$CFG->prefix}post as p ";
         $sql .= 'WHERE t.id = bt.tagid ';
         $sql .= 'AND p.id = bt.entryid ';
-        $sql .= 'AND (p.publishstate = "site" or p.publishstate="public") ';
+        $sql .= 'AND (p.publishstate = \'site\' or p.publishstate=\'public\') ';
         $sql .= "AND bt.timemodified > {$timewithin} ";
         $sql .= 'GROUP BY bt.tagid ';
         $sql .= 'ORDER BY ct DESC, t.text ASC ';
-- 
2.39.5