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 search engine controller functions
class SearchEngineController extends Controller{
        
        # func to get all search engines
        function __getAllSearchEngines(){
                $sql = "select * from searchengines where status=1";
                $seList = $this->db->select($sql);
                return $seList;
        }
        
        function __searchSerachEngines($searchInfo=[]) {
            $cond = "1=1";
            $cond .= isset($searchInfo['status']) ? " and status=".intval($searchInfo['status']) : "";
            $cond .= isset($searchInfo['search']) ? " and url like '%".addslashes($searchInfo['search'])."%'" : "";
            return $this->dbHelper->getAllRows('searchengines', $cond);
        }
        
        # func to get search engine info
        function __getsearchEngineInfo($seId){
                $sql = "select * from searchengines where id=$seId";
                $seList = $this->db->select($sql, true);
                return $seList;
        }
        
        # func to get all search engines
        function __getAllCrawlFormatedSearchEngines(){
                $sql = "select * from searchengines where status=1";
                $list = $this->db->select($sql);
                $seList = array();
                foreach($list as $seInfo){
                        $seId = $seInfo['id'];
                        $seInfo['regex'] = "/".$seInfo['regex']."/is";
                        $search = array('[--num--]');
                        $replace = array($seInfo['no_of_results_page']);
                        $seInfo['url'] = str_replace($search, $replace, $seInfo['url']);
                        $seList[$seId] = $seInfo;
                }       
                return $seList;
        }
        
        # func to show search engines
        function listSE($info=''){
                $info = sanitizeData($info);
                $info['stscheck'] = isset($info['stscheck']) ? intval($info['stscheck']) : 1;
                $pageScriptPath = 'searchengine.php?stscheck=' . $info['stscheck'];
                $sql = "select * from searchengines where status='{$info['stscheck']}'";
                
                // search for search engine name
                if (!empty($info['se_name'])) {
                        $sql .= " and domain like '%".addslashes($info['se_name'])."%'";
                        $pageScriptPath .= "&se_name=" . $info['se_name'];
                }
                
                $sql .= " order by id"; 
                
                # pagination setup              
                $this->db->query($sql, true);
                $this->paging->setDivClass('pagingdiv');
                $this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
                $pagingDiv = $this->paging->printPages($pageScriptPath, '', 'scriptDoLoad', 'content', 'layout=ajax');          
                $this->set('pagingDiv', $pagingDiv);
                $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;
                $seList = $this->db->select($sql);
                $this->set('seList', $seList);

                $statusList = array(
                        $_SESSION['text']['common']['Active'] => 1,
                        $_SESSION['text']['common']['Inactive'] => 0,
                );
                
                $this->set('statusList', $statusList);
                $this->set('info', $info);
                $this->set('pageScriptPath', $pageScriptPath);
                $this->set('pageNo', $info['pageno']);          
                $this->render('searchengine/list', 'ajax');
        }
        
        # func to change status of search engine
        function __changeStatus($seId, $status){                
                $seId = intval($seId);
                $sql = "update searchengines set status=$status where id=$seId";
                $this->db->query($sql);
        }
        
        # func to delete search engine
        function __deleteSearchEngine($seId){
                $seId = intval($seId);
                $sql = "delete from searchengines where id=$seId";
                $this->db->query($sql);
                
                
                $sql = "select id from searchresults where searchengine_id=$seId";
                $recordList = $this->db->select($sql);
                
                if(count($recordList) > 0){
                        foreach($recordList as $recordInfo){
                                $sql = "delete from searchresultdetails where searchresult_id=".$recordInfo['id'];
                                $this->db->query($sql);
                        }
                        
                        $sql = "delete from searchresults where searchengine_id=$seId";
                        $this->db->query($sql);
                }               
                
        }
        
        # function to check whether captcha found in search engine results
        public static function isCaptchInSearchResults($searchContent) {

                $captchFound = false;
                
                // if captcha input field is found
                if (stristr($searchContent, 'name="captcha"') || stristr($searchContent, 'id="captcha"') || stristr($searchContent, 'recaptcha/api')) {
                        $captchFound = true;
                }
                
                return $captchFound;
        }
        
        // Function to check / validate the user type searh engine count
        public static function validateSearchEngineCount($userId, $count) {
                $userCtrler = new UserController();
                $validation = array('error' => false);

                // if admin user id return true
                if ($userCtrler->isAdminUserId($userId)) {
                        return $validation;
                }
                
                $userTypeCtrlr = new UserTypeController();
                $userTypeDetails = $userTypeCtrlr->getUserTypeSpecByUser($userId);
                
                // if limit is set and not -1
                if (isset($userTypeDetails['searchengine_count']) && $userTypeDetails['searchengine_count'] >= 0) {
                
                        // check whether count greater than limit
                        if ($count > $userTypeDetails['searchengine_count']) {
                                $validation['error'] = true;
                                $spTextSubs = $userTypeCtrlr->getLanguageTexts('subscription', $_SESSION['lang_code']);
                                $validation['msg'] = formatErrorMsg(str_replace("[limit]", $userTypeDetails['searchengine_count'], $spTextSubs['total_count_greater_account_limit']));
                        }
                        
                }
                
                return $validation;
        }
        
        // func to show sync search engines
        function showSyncSearchEngines($info=[]) {
            
            $pageScriptPath = 'searchengine.php?sec=sync-se';
            $sql = "select * from sync_searchengines order by sync_time DESC";
            
            # pagination setup
            $this->db->query($sql, true);
            $this->paging->setDivClass('pagingdiv');
            $this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
            $pagingDiv = $this->paging->printPages($pageScriptPath, '', 'scriptDoLoad', 'content', 'layout=ajax');
            $this->set('pagingDiv', $pagingDiv);
            $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;
            $syncList = $this->db->select($sql);
            $this->set('syncList', $syncList);
            
            $this->set('pageScriptPath', $pageScriptPath);
            $this->set('pageNo', $info['pageno']);
            $this->render('searchengine/list_sync_searchengines');
        }
        
        // do sync search engines from sp main website
        function doSyncSearchEngines($checkAlreadyExecuted = false, $cronJob = false) {
            
            // check whether already executed sync
            if ($checkAlreadyExecuted) {
                $row = $this->dbHelper->getRow("sync_searchengines", "sync_time>TIMESTAMP(DATE_SUB(NOW(), INTERVAL ". SP_SYNC_SE_INTERVAL ." day))");
                if (!empty($row['id'])) {
                    return ['status' => false, 'result' => "Search engines already synced."];
                }
            }
            
            $dataList = ['status' => 0];
            $syncUrl = SP_MAIN_SITE . "/get_searchengine_updates.php";
            $ret = $this->spider->getContent($syncUrl);
            if (!empty($ret['page'])) {
                
                // check whethere required content exists in the page crawled
                if (stristr($ret['page'], 'UPDATE ')) {
                    
                    $queryList = explode(';', $ret['page']);
                    foreach ($queryList as $query) {
                        if (!empty($query)) {
                           $this->db->query(trim($query));
                        }
                    }
                    
                    $dataList['result'] = "Search engines successfully synced.";
                    $dataList['status'] = 1;
                    
                    // update admin alerts section
                    if ($cronJob) {
                        $alertCtrl = new AlertController();
                        $alertInfo = array(
                            'alert_subject' => "Search Engine Sync",
                            'alert_message' => $dataList['result'],
                            'alert_category' => "reports",
                            'alert_url' => SP_WEBPATH,
                        );
                        $alertCtrl->createAlert($alertInfo, false, true);
                    }
                    
                } else {
                    $dataList['result'] = "Internal error occured during search engine sync.";
                }
                
            } else {
                $dataList['result'] = $ret['errmsg'];
            }
            
            $this->dbHelper->insertRow("sync_searchengines", $dataList);
            return $dataList;
        }
        
}
?>