Subversion Repositories cheapmusic

<?php

/***************************************************************************
 *   Copyright (C) 2009-2011 by Geo Varghese(www.seopanel.in)      *
 *   sendtogeo@gmail.com                                                                                                   *
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 *   This program is distributed in the hope that it will be useful,       *
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
 *   GNU General Public License for more details.                          *
 *                                                                         *
 *   You should have received a copy of the GNU General Public License     *
 *   along with this program; if not, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/

# class defines all blog controller functions
class BlogController extends Controller{

        # func to show all blogs
        function listBlogs($info=''){
                $whereCond = "status=1 and link_page=''";
                $whereCond .= !empty($info['tag']) ? " and tags like '%".addslashes(trim(urldecode($info['tag'])))."%'" : "";
                $whereCond .= !empty($info['search']) ? " and blog_content like '%".addslashes($info['search'])."%'" : "";
                $countInfo = $this->dbHelper->getRow("cust_blogs", $whereCond, "count(*) count");
                $totalPageCount = ceil(($countInfo['count'] / SP_PAGINGNO));
                $currPage = intval($info['page']);
                $currPage = $currPage ? $currPage : 1;
                
                $whereCond .= " order by created_time desc";
                $start = ($currPage - 1) * SP_PAGINGNO;
                $whereCond .= " limit $start," . SP_PAGINGNO;
                $blogList = $this->dbHelper->getAllRows("cust_blogs", $whereCond);
                $blogBaseLink = SP_WEBPATH . "/blog.php?search=".$info['search']."&tag=".$info['tag'];
                $this->set("blogBaseLink", $blogBaseLink);
                $this->set("post", $info);
                
                $olderPage = ($currPage < $totalPageCount) ? $currPage + 1 : 0;
                $newerPage = ($currPage > 1) ? $currPage - 1 : 0;
                $this->set('olderPage', $olderPage);
                $this->set('newerPage', $newerPage);            
                $this->set('blogList', $blogList);
                $this->render('blog/blog_list');
        }

        # func to show a blog
        function showBlog($blogId){
                $whereCond = "status=1 and id=" . intval($blogId);
                $blogInfo = $this->dbHelper->getRow("cust_blogs", $whereCond);
                $this->set('spTitle', $blogInfo['meta_title']);
                $this->set('spDescription', $blogInfo['meta_description']);
                $this->set('spKeywords', $blogInfo['meta_keywords']);
                $this->set('blogInfo', $blogInfo);
                $this->render('blog/blog_show');
        }       
                
}
?>