WebSVN – cheapmusic – /www/seopanel/controllers/directory.ctrl.php

<?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 directory controller functions
class DirectoryController extends Controller{
        var $noTitles = 5;                        # no of titles and description for submission
        var $capchaFile = "captcha";  # captcha file name
        var $checkPR = 0;
        
        function showSubmissionPage( ) {
                
                $userId = isLoggedIn();
                $this->session->setSession('dirsub_pr', '');
                
                $websiteController = New WebsiteController();
                $this->set('websiteList', $websiteController->__getAllWebsites($userId, true));
                
                $langCtrler = New LanguageController();
                $langList = $langCtrler->__getAllLanguages();
                $this->set('langList', $langList);
                
                $this->render('directory/showsubmission');
        }
        
        function __getDirectoryInfo($dirId){
                $sql = "select * from directories where id=$dirId";
                $listInfo = $this->db->select($sql, true);
                return empty($listInfo['id']) ? false :  $listInfo;
        }
        
        function showWebsiteSubmissionPage($submitInfo, $error=false) {
                
                if(empty($submitInfo['website_id'])) {
                        showErrorMsg($this->spTextDir['Please select a website to proceed']."!");
                }
                
                # check whether the sitemap directory is writable
                if(!is_writable(SP_TMPPATH ."/".$this->sitemapDir)){
                        showErrorMsg("Directory '<b>".SP_TMPPATH."</b>' is not <b>writable</b>. Please change its <b>permission</b> !");
                }
                
                if(empty($error)){
                        $websiteController = New WebsiteController();
                        $websiteInfo = $websiteController->__getWebsiteInfo($submitInfo['website_id']);
                        $websiteInfo['website_id'] = $submitInfo['website_id'];
                }else{
                        $websiteInfo = $submitInfo;
                }
                
                $this->set('websiteInfo', $websiteInfo);                
                $this->session->setSession('no_captcha', empty($submitInfo['no_captcha']) ? 0 : 1);
                $this->session->setSession('dirsub_pr', $submitInfo['pagerank']);
                $this->session->setSession('dirsub_lang', $submitInfo['lang_code']);
                $this->set('noTitles', $this->noTitles);                
                $this->render('directory/showsitesubmission');
        }
        
        function saveSubmissiondata( $submitInfo ) {
                
                $submitInfo['website_id']= intval($submitInfo['website_id']);
                if(empty($submitInfo['website_id'])) {
                        showErrorMsg("Please select a website to proceed!");
                }
                
                $_SESSION['skipped'][$submitInfo['website_id']] = array();
                
                if(!SP_DEMO){
                        $errMsg['url'] = formatErrorMsg($this->validate->checkBlank($submitInfo['url']));
                        $errMsg['owner_name'] = formatErrorMsg($this->validate->checkBlank($submitInfo['owner_name']));
                        $errMsg['category'] = formatErrorMsg($this->validate->checkBlank($submitInfo['category']));
                        $errMsg['title'] = formatErrorMsg($this->validate->checkBlank($submitInfo['title']));
                        $errMsg['description'] = formatErrorMsg($this->validate->checkBlank($submitInfo['description']));
                        $errMsg['keywords'] = formatErrorMsg($this->validate->checkBlank($submitInfo['keywords']));
                        $errMsg['owner_email'] = formatErrorMsg($this->validate->checkEmail($submitInfo['owner_email']));
                        
                        # error occurs
                        if($this->validate->flagErr){
                                $this->set('errMsg', $errMsg);
                                $submitInfo['sec'] = '';
                                $this->showWebsiteSubmissionPage($submitInfo, true);
                                return;
                        }
                
                        $submitInfo['url'] = addHttpToUrl($submitInfo['url']);
                        $recUrl = formatUrl($submitInfo['reciprocal_url']);
                        $submitInfo['reciprocal_url'] = empty($recUrl) ? "" : addHttpToUrl($submitInfo['reciprocal_url']);
                
                        $sql = "update websites set " .
                                        "url='".addslashes($submitInfo['url'])."'," .
                                        "owner_name='".addslashes($submitInfo['owner_name'])."'," .
                                        "owner_email='".addslashes($submitInfo['owner_email'])."'," .
                                        "category='".addslashes($submitInfo['category'])."'," .
                                "reciprocal_url='".addslashes($submitInfo['reciprocal_url'])."'," .
                                        "title='".addslashes($submitInfo['title'])."'," .
                                        "description='".addslashes($submitInfo['description'])."',";                    
                        for($i=2;$i<=$this->noTitles;$i++){
                                $sql .= "title$i='".addslashes($submitInfo['title'.$i])."'," .
                                        "description$i='".addslashes($submitInfo['description'.$i])."',";
                        }                       
                        $sql .= "keywords='".addslashes($submitInfo['keywords'])."' " .
                                        "where id={$submitInfo['website_id']}";
                        $this->db->query($sql);
                }
                $this->startSubmission($submitInfo['website_id']);      
                                        
        }
        
        function isCategoryExists($page,$categoryCol) {
                $matches = array();
                $pattern1 = '/<select name="'.$categoryCol.'".*?<\/select>/is';
                $pattern2 = '/<select.*?'.$categoryCol.'.*?<\/select>/is';
                $pattern3 = '/<select.*?'.$categoryCol.'.*<\/select>/is';
                $matched = 0;
                if($matched = preg_match($pattern1, $page, $matches)){
                }elseif($matched = preg_match($pattern2, $page, $matches)){
                }elseif($matched = preg_match($pattern3, $page, $matches)){
                }
                
                return $matches;
        }

        # func to create captcha image in system
        function __getCreatedCaptchaUrl($captchaUrl, $submitUrl, $phpsessid){
                $captchaUrlInfo = ['url' => $captchaUrl, 'code' => ''];
                
                $spider = new Spider();
                $spider->_CURLOPT_REFERER = $submitUrl;
                $spider->_CURLOPT_TIMEOUT = 30;
                
                if(!empty($phpsessid)){
                        $spider->_CURLOPT_COOKIE = 'PHPSESSID=' . $phpsessid . '; path=/';      
                }
                
                $ret = $spider->getContent($captchaUrl);
                
                if(!empty($ret['page'])){
                        $captchaFile = $this->capchaFile .isLoggedIn() . ".jpg";
                        $fp = fopen(SP_TMPPATH."/".$captchaFile, 'w');
                        fwrite($fp, $ret['page']);
                        fclose($fp);
                        $captchaUrl = SP_WEBPATH. "/tmp/" .$captchaFile ."?rand=".mktime();     
                        $captchaUrlInfo['url'] = $captchaUrl;
                        
                        // check for captcha bypass plugin enabled or not
                        if (isPluginActivated("CaptchaBypass")) {
                                $seopluginCtrler = new SeoPluginsController();
                                $pluginCtrler = $seopluginCtrler->createPluginObject("CaptchaBypass");
                                $captchaUrlInfo['code'] = $pluginCtrler->solveCaptchaImage(['img_path' => SP_TMPPATH."/".$captchaFile]);
                        }
                        
                }
                
                return $captchaUrlInfo; 
        }
        
        # func to show submission page
        function startSubmission( $websiteId, $dirId='' ) {
                $dirId = intval($dirId);
                $websiteId = intval($websiteId);

                $websiteController = New WebsiteController();
                $websiteInfo = $websiteController->__getWebsiteInfo($websiteId);
                $this->set('websiteId', $websiteId);
                
                // submission count validation
                $this->validateDirectorySubmissionCount($websiteInfo['user_id']);
                
                # get list of already submitted directories
                $sql = "select directory_id from dirsubmitinfo where website_id=$websiteId";
                $list = $this->db->select($sql);
                $dirList = array();
                foreach($list as $listInfo){
                        $dirList[] = $listInfo['directory_id'];
                }
                
                # to get skipped directories
                $skipDirList = $this->__getAllSkippedDir($websiteId);
                if( count($skipDirList) > 0){
                        $dirList = array_merge($dirList, $skipDirList);
                }
                
                $sql = "select * from directories where working=1";
                if(!empty($_SESSION['no_captcha'])) $sql .= " and is_captcha=0";
                
                // check for page rank
                if(!empty($_SESSION['dirsub_pr'])) {
                        $prMax = intval($_SESSION['dirsub_pr']) + 0.5;
                        $prMin = intval($_SESSION['dirsub_pr']) - 0.5;
                        $sql .= " and pagerank<$prMax and pagerank>=$prMin";
                }
                
                if(!empty($_SESSION['dirsub_lang'])) $sql .= " and lang_code='{$_SESSION['dirsub_lang']}'";
                
                // if reciprocal directory needs to be filtered
                if(!empty($_SESSION['no_reciprocal'])) {
                        $sql .= " and extra_val not like '%LINK_TYPE=reciprocal%' and is_reciprocal=0";
                }               
                
                if(!empty($dirId)) $sql .= " and id=$dirId";
                if(count($dirList) > 0) $sql .= " and id not in (".implode(',', $dirList).")";
                $sql .= " order by rank DESC, extra_val ASC, id ASC";
                $dirInfo = $this->db->select($sql, true);
                $this->set('dirInfo', $dirInfo);                
                
                # directory list is empty
                if(empty($dirInfo['id'])) {
                        showErrorMsg($this->spTextDir['nodirnote'].". Please <a href='".SP_CONTACT_LINK."' target='_blank'>Contact</a> <b>Seo Panel Team</b> to get more <b>directories</b>.");
                }
                
                $spider = new Spider();
                $spider->_CURLOPT_HEADER = 1; 
                $ret = $spider->getContent(addHttpToUrl($dirInfo['submit_url']));
                                
                if($ret['error']){
                        $this->set('error', 1);
                        $this->set('msg', $ret['errmsg']);
                }
                
                $page = $ret['page'];
                if(!empty($page)){
                        $matches = $this->isCategoryExists($page, $dirInfo['category_col']);            
                }

                # if category exists proceed submission
                if(!empty($matches[0])){
                        
                        $categorysel = $matches[0];
                        $this->set('catSelectStr', $websiteInfo['category']);
                        
                        // replaced with jquery script
                        /*$catList = explode(',', $websiteInfo['category']);
                        if(count($catList) > 0){
                                foreach($catList as $category){
                                        $category = trim($category);
                                        $categorysel = preg_replace("/<(option.*?$category.*?)>/si", '<$1 selected>', $categorysel, 1, $count);
                                        if($count > 0) break;   
                                }

                                if($count <= 0){
                                        $categorysel = $matches[0];
                                }
                        }*/

                        $categorysel = str_replace("ADD_CATEGORY_ID[]", $dirInfo['category_col'], $categorysel);
                        $this->set('categorySel', $categorysel);
                        
                        $captchaUrl = '';
                        if(stristr($page, $dirInfo['captcha_script'])){
                                $captchaUrl = $dirInfo['captcha_script'];
                        }
                        
                        $imageHash = $addParams = "";
                        if(preg_match('/name="'.$dirInfo['imagehash_col'].'".*?value="(.*?)"/is', $page, $hashMatch)){
                                $imageHash = $hashMatch[1];
                        }
                        $this->set('imageHash', $imageHash);
                        $phpsessid = $spider->getSessionId($page);
                        $this->set('phpsessid', $phpsessid);
                        
                        if(!empty($captchaUrl)){
                                $captchaUrl = preg_replace('/^\//', '', $captchaUrl);                           
                                $dirInfo['domain'] = addHttpToUrl($dirInfo['domain']);
                                if(preg_match('/\/$/', $dirInfo['domain'])){
                                        $captchaUrl = $dirInfo['domain']. $captchaUrl;
                                } else { 
                                        $captchaUrl =  $dirInfo['domain']."/". $captchaUrl;     
                                }                       
                                
                                if(!stristr($captchaUrl, '?')){
                                        if(!empty($imageHash)) {
                                                $captchaUrl .= "?".$dirInfo['imagehashurl_col']."=".$imageHash; 
                                        }else $captchaUrl .= "?rand=".rand(1,1000);     
                                }else{                                  
                                        if(!empty($imageHash)) {
                                                $captchaUrl .= "&".$dirInfo['imagehashurl_col']."=".$imageHash; 
                                        }else $captchaUrl .= "&rand=".rand(1,1000); 
                                }

                                # to get stored image path if hot linking is prevented
                                $captchaUrlInfo = $this->__getCreatedCaptchaUrl($captchaUrl, $dirInfo['submit_url'], $phpsessid);
                                $captchaUrl = $captchaUrlInfo['url'];
                                
                        } else {

                                // check for number question existing there
                                if (preg_match('/(\d+) \+ (\d+) =/is', $page, $numMatch)) {
                                        $sumMath = intval($numMatch[1]) + intval($numMatch[2]);
                                        $addParams = "&DO_MATH=$sumMath&Anti_Spam_Field=$sumMath";
                                }
                                
                                if (isPluginActivated("CaptchaBypass")) {
                                        $seopluginCtrler = new SeoPluginsController();
                                        $pluginCtrler = $seopluginCtrler->createPluginObject("CaptchaBypass");
                                }
                                
                        }                       
                        
                        $this->set('captchaCode', !empty($captchaUrlInfo['code']) ? $captchaUrlInfo['code'] : "");
                        $this->set('captchaUrl', $captchaUrl);
                        $this->set('addParams', $addParams);

                        // function check whether recriprocal directory
                        $scriptInfo = $this->getDirectoryScriptMetaInfo($dirInfo['script_type_id']);
                        $checkArg = $scriptInfo['link_type_col']."=".$scriptInfo['reciprocal'];
                        $reciprocalUrl = '';
                        $reciprocalDir = false;
                        if (!empty($dirInfo['is_reciprocal']) || stristr($dirInfo['extra_val'], $checkArg)) {
                                $reciprocalDir = true;
                $reciprocalUrl =  $websiteInfo['reciprocal_url'];
                if (empty($reciprocalUrl)) {
                    if (preg_match("/&{$scriptInfo['reciprocal_col']}=(.*)/", $dirInfo['extra_val'], $matches)) { 
                        if (!empty($matches[1])) $reciprocalUrl = $matches[1];     
                    }
                }
                        }
                        
                        $this->set('reciprocalDir', $reciprocalDir);
                        $this->set('reciprocalUrl', $reciprocalUrl);
                        
                }else{
                        $this->set('error', 1);
                        $this->set('msg', $this->spTextDir['nocatnote']);
                }
                
                $this->render('directory/showsubmissionform');                          
        }
        
        # to get random title and description for submisiion
        function __getSubmitTitleDes($websiteInfo){
                $titleList = array();
                
                $titleList[0]['title'] = $websiteInfo['title'];
                $titleList[0]['description'] = $websiteInfo['description'];
                for($i=2;$i<=$this->noTitles;$i++){
                        $titleInfo = array();
                        if(!empty($websiteInfo['title'.$i]) && !empty($websiteInfo['description'.$i])){
                                $titleInfo['title'] = $websiteInfo['title'.$i];
                                $titleInfo['description'] = $websiteInfo['description'.$i];
                                $titleList[] = $titleInfo;
                        }       
                }
                if($index = array_rand($titleList, 1)){
                        $websiteInfo['title'] = $titleList[$index]['title'];
                        $websiteInfo['description'] = $titleList[$index]['description'];        
                }
                
                return $websiteInfo;
        }       
        
        # submitting site directory
        function submitSite( $submitInfo ) {

                $submitInfo['dir_id'] = intval($submitInfo['dir_id']);
                $submitInfo['website_id'] = intval($submitInfo['website_id']);
                $dirInfo = $this->__getDirectoryInfo($submitInfo['dir_id']);
                
                $websiteController = New WebsiteController();
                $websiteInfo = $websiteController->__getWebsiteInfo($submitInfo['website_id']);         
                $websiteInfo = $this->__getSubmitTitleDes($websiteInfo);
                
                $postData = $dirInfo['title_col']."=".$websiteInfo['title'];
                $postData .= "&".$dirInfo['url_col']."=".$websiteInfo['url'];
                $postData .= "&".$dirInfo['description_col']."=".$websiteInfo['description'];
                $postData .= "&".$dirInfo['name_col']."=".$websiteInfo['owner_name'];
                $postData .= "&".$dirInfo['email_col']."=".$websiteInfo['owner_email'];
                $postData .= "&".$dirInfo['category_col']."=".$submitInfo[$dirInfo['category_col']];
                $postData .= "&".$dirInfo['cptcha_col']."=".$submitInfo[$dirInfo['cptcha_col']];
                $postData .= $submitInfo['add_params'];
                
                // check image hash there
                if(!empty($submitInfo[$dirInfo['imagehash_col']])){
                        $postData .= "&".$dirInfo['imagehash_col']."=".$submitInfo[$dirInfo['imagehash_col']];
                }
                
                // check for reciprocal link
                $scriptInfo = $this->getDirectoryScriptMetaInfo($dirInfo['script_type_id']);
                if (!empty($submitInfo['reciprocal_url'])) {
                    
                    // if extra values contain the reciprocal col name
                        $reciprocalUrl = addHttpToUrl($submitInfo['reciprocal_url']);
                    if (stristr($dirInfo['extra_val'], $scriptInfo['reciprocal_col'])) {
                        $dirInfo['extra_val'] = preg_replace("/&{$scriptInfo['reciprocal_col']}=(.*)/", "&{$scriptInfo['reciprocal_col']}=$reciprocalUrl", $dirInfo['extra_val']);
                    } else {
                        $postData .= "&".$dirInfo['reciprocal_col']."=$reciprocalUrl";
                    }
                    
                }               
                
                $postData .= "&".$dirInfo['extra_val'];
                
                // check phpLD directory. Then add extra values
                if ($scriptInfo['name'] == 'phpLD') {
                        $postData .= "&OWNER_NEWSLETTER_ALLOW=on&META_KEYWORDS={$websiteInfo['keywords']}
                        &META_DESCRIPTION=" . substr($websiteInfo['description'], 0, 249) . "&META_DESCRIPTION_limit=250&formSubmitted=1";
                }
                
                $spider = new Spider(); 
                $spider->_CURLOPT_POSTFIELDS = $postData;
                $spider->_CURLOPT_REFERER = $dirInfo['submit_url'];
                if(!empty($submitInfo['phpsessid'])){
                        $spider->_CURLOPT_COOKIE = 'PHPSESSID=' . $submitInfo['phpsessid'] . '; path=/';        
                }
                $ret = $spider->getContent($dirInfo['submit_url']);
                
                if($ret['error']){
                        $this->set('error', 1);
                        $this->set('msg', $ret['errmsg']);
                }else{
                        
                        $page = $ret['page'];
                        
                        if(SP_DEBUG) $this->logSubmissionResult($page, $submitInfo['dir_id'], $submitInfo['website_id']);               
                        
                        // check success messages
                        if (preg_match('/<td.*?class="msg".*?>(.*?)<\/td>/is', $page, $matches)) {
                        } elseif (preg_match('/<p.*?class="box success".*?>(.*?)<\/p>/is', $page, $matches)) {
                        } else{
                                $status = 0;
                                $this->set('msg', $this->spTextDir['nosuccessnote']);
                        }                       
                        
                        // if $matches[1] is not empty
                        if (!empty($matches[1])) {
                                $this->set('msg', $matches[1]);
                                $status = 1;
                                
                                // to update the rank of directory
                                $sql = "update directories set rank=rank+1 where id=".$submitInfo['dir_id'];
                                $this->db->query($sql);                         
                        }
                        
                        
                        $sql = "select id from dirsubmitinfo where website_id={$submitInfo['website_id']} and directory_id={$submitInfo['dir_id']}";
                        $subInfo = $this->db->select($sql);
                        if(empty($subInfo[0][id])){
                                $sql = "insert into dirsubmitinfo(website_id,directory_id,status,submit_time) values({$submitInfo['website_id']}, {$submitInfo['dir_id']}, $status,".mktime().")";                              
                        }else{
                                $sql = "update dirsubmitinfo set status=$status,submit_time=".mktime()." where id={$subInfo[0][id]}";
                        }
                        $this->db->query($sql);                 
                }               
                $this->render('directory/showsubmissionstats');
                
                $this->set('error', 0);
                $this->set('msg', '');
                
                $this->startSubmission($submitInfo['website_id']);              
        }
        
        # to skip submission
        function skipSubmission( $info ) {
                
                $info['website_id'] = intval($info['website_id']);
                $info['dir_id'] = intval($info['dir_id']);
                $sql = "Insert into skipdirectories(website_id,directory_id) values({$info['website_id']}, {$info['dir_id']})";
                $this->db->query($sql);         
                $this->startSubmission($info['website_id']);
        }
        
        # to unskip submission
        function unSkipSubmission( $skipId ) {
                
                $skipId = intval($skipId);
                $sql = "delete from skipdirectories where id=$skipId";
                $this->db->query($sql);
        }
        
        # to get all skipped directories
        function __getAllSkippedDir($websiteId){
                
                $websiteId = intval($websiteId);
                $dirList = array();
                $sql = "select directory_id from skipdirectories where website_id=$websiteId";
                $list = $this->db->select($sql);
                if(count($list) > 0){
                        foreach($list as $listInfo){
                                $dirList[] = $listInfo['directory_id'];
                        }
                }
                
                return $dirList;
        }
        
        # func to show Skipped Directories
        function showSkippedDirectories($searchInfo=''){
                
                $userId = isLoggedIn();
                $websiteController = New WebsiteController();
                $websiteList = $websiteController->__getAllWebsites($userId, true);
                $this->set('websiteList', $websiteList);
                $websiteId = empty ($searchInfo['website_id']) ? $websiteList[0]['id'] : intval($searchInfo['website_id']);
                $this->set('websiteId', $websiteId);
                $this->set('onChange', "scriptDoLoadPost('directories.php', 'search_form', 'content', '&sec=skipped')");                
                
                $conditions = empty ($websiteId) ? "" : " and ds.website_id=$websiteId";
                $pageScriptPath = 'directories.php?sec=skipped&website_id='.$websiteId;
                $this->set('searchInfo', $searchInfo); 

                // search for name
                if (!empty($searchInfo['search_name'])) {
                        $conditions .= " and d.submit_url like '%".addslashes($searchInfo['search_name'])."%'";
                        $pageScriptPath .= "&search_name=" . $searchInfo['search_name'];
                }
                                
                $sql = "select ds.* ,d.domain,d.pagerank, d.submit_url
                from skipdirectories ds,directories d where ds.directory_id=d.id $conditions order by id desc,d.domain";
                                                                
                # 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');         
                $this->set('pagingDiv', $pagingDiv);
                $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;                                           
                                                                
                $reportList = $this->db->select($sql);
                
                $this->set('list', $reportList);
                $this->set('pageNo', $_GET['pageno']);
                $this->set('websiteId', $websiteId);
                $this->render('directory/skippeddirs'); 
        }
        
        # func to show submision reports
        function showSubmissionReports($searchInfo=''){
                
                $userId = isLoggedIn();         
                $websiteController = New WebsiteController();
                $websiteList = $websiteController->__getAllWebsites($userId, true);
                $this->set('websiteList', $websiteList);
                $websiteId = empty ($searchInfo['website_id']) ? $websiteList[0]['id'] : intval($searchInfo['website_id']);
                $this->set('websiteId', $websiteId);
                $this->set('onChange', "scriptDoLoadPost('directories.php', 'search_form', 'content', '&sec=reports')");                
                
                $conditions = empty ($websiteId) ? "" : " and ds.website_id=$websiteId";
                $conditions .= empty ($searchInfo['active']) ? "" : " and ds.active=".($searchInfo['active']=='pending' ? 0 : 1);               

                $pageScriptPath = 'directories.php?sec=reports&website_id='.$websiteId.'&active='.$searchInfo['active'];
                $this->set('searchInfo', $searchInfo);
                
                // search for name
                if (!empty($searchInfo['search_name'])) {
                        $conditions .= " and d.submit_url like '%".addslashes($searchInfo['search_name'])."%'";
                        $pageScriptPath .= "&search_name=" . $searchInfo['search_name'];
                }
                
                $sql = "select ds.* ,d.domain,d.pagerank, d.submit_url from dirsubmitinfo ds,directories d 
                where ds.directory_id=d.id $conditions order by submit_time desc,d.domain";
                                                                
                # 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');         
                $this->set('pagingDiv', $pagingDiv);
                $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;
                                                                
                $reportList = $this->db->select($sql);
                $this->set('pageScriptPath', $pageScriptPath);
                $this->set('pageNo', $_GET['pageno']);
                $this->set('activeVal', $searchInfo['active']);
                $this->set('list', $reportList);
                $this->render('directory/directoryreport');     
        }
        
        function changeConfirmStatus($dirInfo){
                
                $dirInfo['id'] = intval($dirInfo['id']);
                $status = ($dirInfo['confirm']=='Yes') ? 0 : 1;
                $sql = "Update dirsubmitinfo set status=$status where id=".$dirInfo['id'];
                $this->db->query($sql);
        }
        
        function showConfirmStatus($id){
                
                $id = intval($id);
                $sql = "select status from dirsubmitinfo where id=".$id;                
                $statusInfo = $this->db->select($sql, true);
                
                $confirm = empty($statusInfo['status']) ? "No" : "Yes";
        $confirmId = "confirm_".$id;
        $confirmLink = "<a href='javascript:void(0);' onclick=\"scriptDoLoad('directories.php', '$confirmId', 'sec=changeconfirm&id=$id&confirm=$confirm')\">$confirm</a>";
        
        print $confirmLink;
        }
        
        function checkSubmissionStatus($dirInfo){

                $dirInfo['id'] = intval($dirInfo['id']);
                $sql = "select ds.* ,d.domain,d.search_script,w.url
                                        from dirsubmitinfo ds,directories d,websites w 
                                        where ds.directory_id=d.id and ds.website_id=w.id 
                                        and ds.id=". $dirInfo['id'];
                $statusInfo = $this->db->select($sql, true);
                
                $searchUrl = (preg_match('/\/$/', $statusInfo['domain'])) ? $statusInfo['domain'].$statusInfo['search_script'] : $statusInfo['domain']."/".$statusInfo['search_script'];
                $keyword = formatUrl($statusInfo['url']);
                $searchUrl = str_replace('[--keyword--]', urlencode($keyword), $searchUrl);
                
                $ret = $this->spider->getContent($searchUrl);
                if(empty($ret['error'])){
                        if(stristr($ret['page'], 'href="'.$statusInfo['url'].'"')){
                                return 1;
                        }elseif(stristr($ret['page'], "href='".$statusInfo['url']."'")){
                                return 1;
                        }elseif(stristr($ret['page'], 'href='.$statusInfo['url'])){
                                return 1;
                        }
                }
                return 0;
        }
        
        function updateSubmissionStatus($dirId, $status){
                $status = intval($status);
                $dirId = intval($dirId);
                $sql = "Update dirsubmitinfo set active=$status where id=".$dirId;
                $this->db->query($sql);
        }
        
        function showSubmissionStatus($id){
                
                $id = intval($id);
                $sql = "select active from dirsubmitinfo where id=".$id;                
                $statusInfo = $this->db->select($sql, true);
        
        print empty($statusInfo['active']) ? $this->spTextDir["Pending"] : $this->spTextDir["Approved"];
        }
        
        function checkSubmissionReports( $searchInfo ) {
                
                $userId = isLoggedIn();         
                $websiteController = New WebsiteController();
                $this->set('websiteList', $websiteController->__getAllWebsites($userId, true));
                $this->set('websiteNull', true);
                $this->set('onClick', "scriptDoLoadPost('directories.php', 'search_form', 'subcontent', '&sec=checksub')");
                
                $this->render('directory/checksubmission');
        }
        
        function generateSubmissionReports( $searchInfo ){
                
                $searchInfo['website_id'] = intval($searchInfo['website_id']);
                if(empty($searchInfo['website_id'])) {
                        echo "<script>scriptDoLoad('directories.php', 'content', 'sec=checksub');</script>";
                        return;
                }               
                                
                $sql = "select ds.* ,d.domain
                                                                from dirsubmitinfo ds,directories d 
                                                                where ds.directory_id=d.id  
                                                                and ds.website_id={$searchInfo['website_id']} and ds.active=0   
                                                                order by submit_time";
                $reportList = $this->db->select($sql);          
                $this->set('list', $reportList);
                $this->render('directory/generatesubmission');
        }
        
        function deleteSubmissionReports($dirSubId){
                
                $dirSubId = intval($dirSubId);
                $sql = "delete from dirsubmitinfo where id=$dirSubId";
                $this->db->query($sql);
                
                echo "<script>scriptDoLoadPost('directories.php', 'search_form', 'content', '&sec=reports');</script>";
        }
        
        # function to show featured directories
        function showFeaturedSubmission($info="") {
            $dirList = $this->getAllFeaturedDirectories();
            $this->set('list', $dirList);
                $this->render('directory/featuredsubmission');
        }       
        
        # function to get all features directories
    function getAllFeaturedDirectories() {
                $sql = "SELECT * FROM featured_directories where status=1 order by  google_pagerank DESC";              
                $list = $this->db->select($sql);
                $dirList = array();
                foreach ($list as $listInfo) {
                    $dirList[$listInfo['id']] = $listInfo;
                }
                return $dirList;
        }
        
        # func to get all directories
        function getAllDirectories($searchInfo=array()) {
                $sql = "SELECT * FROM directories ";
                $i = 0;
                foreach($searchInfo as $col => $value){
                        $and = ($i++) ? "and" : "where";
                        $sql .= " $and $col='$value'";
                }
                $sql .= "order by id";          
                $dirList = $this->db->select($sql);
                
                return $dirList;
        }
        
        # func to get dir info
        function getDirectoryInfo($dirId) {
                
                $dirId = intval($dirId);
                $sql = "SELECT * FROM directories where id=$dirId";             
                $dirInfo = $this->db->select($sql, true);               
                return $dirInfo;
        }
        
        # func to show directory manager
        function showDirectoryManager($info=''){                
                $info = sanitizeData($info);
                $info['stscheck'] = isset($info['stscheck']) ? intval($info['stscheck']) : 1;
                $capcheck = isset($info['capcheck']) ? (($info['capcheck'] == 'yes') ? 1 : 0 ) : "";  
                $sql = "SELECT *,l.lang_name FROM directories d,languages l where d.lang_code=l.lang_code and working='{$info['stscheck']}'";           
                if(!empty($info['dir_name'])) $sql .= " and domain like '%".addslashes($info['dir_name'])."%'";
                if($info['capcheck'] != '') $sql .= " and is_captcha='$capcheck'";
                
                // check for page rank
                if(isset($info['pagerank']) && ($info['pagerank'] != '')) {
                        $prMax = intval($info['pagerank']) + 0.5;
                        $prMin = intval($info['pagerank']) - 0.5;
                        $sql .= " and pagerank<$prMax and pagerank>=$prMin";
                }
                
                if (!empty($info['langcode'])) { $info['lang_code'] = $info['langcode']; }
                if(!empty($info['lang_code'])) $sql .= " and d.lang_code='".addslashes($info['lang_code'])."'";
                $sql .= " order by id";         
                
                # pagination setup              
                $this->db->query($sql, true);
                $this->paging->setDivClass('pagingdiv');
                $this->paging->loadPaging($this->db->noRows, SP_PAGINGNO);
                $pageScriptPath = 'directories.php?sec=directorymgr&dir_name='.urlencode($info['dir_name'])."&stscheck={$info['stscheck']}&capcheck=".$info['capcheck'];
                $pageScriptPath .= "&pagerank=".$info['pagerank']."&langcode=".$info['lang_code'];
                $pagingDiv = $this->paging->printPages($pageScriptPath);                
                $this->set('pagingDiv', $pagingDiv);
                $sql .= " limit ".$this->paging->start .",". $this->paging->per_page;
                
                $statusList = array(
                        $_SESSION['text']['common']['Active'] => 1,
                        $_SESSION['text']['common']['Inactive'] => 0,
                );
                $captchaList = array(
                        $_SESSION['text']['common']['Yes'] => 'yes',
                        $_SESSION['text']['common']['No'] => 'no',
                );
                
                $langCtrler = New LanguageController();
                $langList = $langCtrler->__getAllLanguages();
                $this->set('langList', $langList);
                
                $this->set('statusList', $statusList);
                $this->set('captchaList', $captchaList);                                
                $dirList = $this->db->select($sql);             
                $this->set('list', $dirList);
                $this->set('info', $info);
                $this->set('ctrler', $this);
                $this->render('directory/list');
        }
        
        # func to change status of directory
        function changeStatusDirectory($dirId, $status, $printLink=false){
                
            $status = intval($status);
                $dirId = intval($dirId);
                $sql = "update directories set working=$status where id=$dirId";
                $this->db->query($sql);
                
                if($printLink){
                        echo $this->getStatusLink($dirId, $status);
                }
        }
        
        # func to show directory check interface
        function showCheckDirectory() {         
                
                $this->render('directory/showcheckdir');
        }
        
        # function to start directory check
        function startDirectoryCheckStatus($info=''){
                
                $searchInfo = array();
                if(isset($info['stscheck']) && ($info['stscheck'] != '')){
                        $searchInfo = array(
                                'working' => intval($info['stscheck']),
                        );
                }
                
                $dirList = $this->getAllDirectories($searchInfo);
                                
                $this->set('dirList', $dirList);
                $this->render('directory/dirstatusgenerator');
        }
        
        # func to check directories active or not 
        function checkDirectoryStatus($dirId, $nodebug=0) {

                $dirId = intval($dirId);
                $dirInfo = $this->getDirectoryInfo($dirId);
                $active = 0;
                $captcha = 0;
                $spider = new Spider(); 
                $ret = $spider->getContent(addHttpToUrl($dirInfo['submit_url']));
                $prUpdate = '';
                $searchUpdate = '';
                $extraValUpdate = '';
                
                if(empty($ret['error']) && !empty($ret['page'])) {                                                              
                        $page = $ret['page'];
                                                
                        $matches = $this->isCategoryExists($page, $dirInfo['category_col']);                    
                        $active = empty($matches[0]) ? 0 : 1;
                        
                        $captcha = stristr($page, $dirInfo['captcha_script']) ? 1 : 0;
                        
                        // to check search script
                        if (stristr($page, 'name="search"')) {
                                $searchUpdate = ",search_script='index.php?search=[--keyword--]'";                          
                        }
                        
                        // to check  the value of the LINK_TYPE if phpld directory
                        if (($dirInfo['script_type_id'] == 1) && preg_match('/name="LINK_TYPE" value="(\d)"/s', $page)) {
                            $subject = array('LINK_TYPE=reciprocal', 'LINK_TYPE=normal', 'LINK_TYPE=free');
                            $replace = array('reciprocal=1&LINK_TYPE=1', 'LINK_TYPE=2', 'LINK_TYPE=3');
                            $dirInfo['extra_val'] = str_replace($subject, $replace, $dirInfo['extra_val']);
                                $extraValUpdate = ",extra_val='{$dirInfo['extra_val']}'";           
                        }
                        
                        if ($this->checkPR) {
                                include_once(SP_CTRLPATH."/moz.ctrl.php");
                                $mozCtrler = new MozController();
                                $mozRankList = $mozCtrler->__getMozRankInfo(array($dirInfo['domain']));
                                $pagerank = !empty($mozRankList[0]['moz_rank']) ? $mozRankList[0]['moz_rank'] : 0;
                                $domainAuthority = !empty($mozRankList[0]['domain_authority']) ? $mozRankList[0]['domain_authority'] : 0;
                                $pageAuthority = !empty($mozRankList[0]['page_authority']) ? $mozRankList[0]['page_authority'] : 0;
                                $prUpdate = ",pagerank=$pagerank,domain_authority=$domainAuthority,page_authority=$pageAuthority";
                        }
                        
                }
                
                $sql = "update directories set working=$active,is_captcha=$captcha,checked=1 $prUpdate $searchUpdate $extraValUpdate where id=$dirId";
                $this->db->query($sql);
                
                if($nodebug){                   
                        $captchaLabel = $captcha ? $_SESSION['text']['common']['Yes'] : $_SESSION['text']['common']['No'];
                        ?>
                        <script type="text/javascript">
                                document.getElementById('captcha_<?php echo $dirId?>').innerHTML = '<?php echo $captchaLabel?>';
                        </script>
                        <?php
                        if ($this->checkPR) {
                                ?>
                                <script type="text/javascript">
                                        document.getElementById('pr_<?php echo $dirId?>').innerHTML = '<?php echo $pagerank?>';
                                        document.getElementById('da_<?php echo $dirId?>').innerHTML = '<?php echo $domainAuthority?>';
                                        document.getElementById('pa_<?php echo $dirId?>').innerHTML = '<?php echo $pageAuthority?>';
                                </script>
                                <?php
                        }
                        echo $this->getStatusLink($dirId, $active);
                }else{
                        echo "<p class='note notesuccess'>Saved status of directory <b>{$dirInfo['domain']}</b>.....</p>";
                }
        }
        
        # func to get status link
        function getStatusLink($dirId, $status){
                if($status){
                        $statLabel = "Active";
                        $statVal = 0;
                }else{
                        $statLabel = "Inactive";
                        $statVal = 1;
                }
                if (SP_DEMO) {
                        $statusLink = scriptAJAXLinkHref('demo', "", "", $_SESSION['text']['common'][$statLabel]);
                } else {                        
                        $statusLink = scriptAJAXLinkHref('directories.php', 'status_'.$dirId, "sec=dirstatus&dir_id=$dirId&status=$statVal", $_SESSION['text']['common'][$statLabel]);
                }
                
                return $statusLink;
        }

        # to get total directory submission info
        function __getTotalSubmitInfo($websiteId, $activeCheck=false){
                $sql = "select count(*) count from dirsubmitinfo where website_id=$websiteId";
                if($activeCheck) $sql .= " and active=1";
                
                $countInfo = $this->db->select($sql, true);
                return empty($countInfo['count']) ? 0 : $countInfo['count']; 
        }
        
        # function to log submission data
        function logSubmissionResult($content, $dirId, $websiteId) {
                
                $filename = SP_TMPPATH."/subres_web".$websiteId."_dir".$dirId.".html";
                $fp = fopen($filename, 'w');
                fwrite($fp, $content);
                fclose($fp);
                
        }
        
        # function to get directory script type meta info
        function getDirectoryScriptMetaInfo($id) {
            $id = empty($id) ? 1 : $id;     
            $sql = "SELECT * FROM di_directory_meta where id=$id";
            $scriptInfo = $this->db->select($sql, true); 
            return $scriptInfo;
        }

        // Function to check / validate the user type directory submission count
        function validateDirectorySubmissionCount($userId, $exit = true) {
                $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['directory_submit_limit']) || isset($userTypeDetails['directory_submit_daily_limit'])) {

                        $spTextSubs = $userTypeCtrlr->getLanguageTexts('subscription', $_SESSION['lang_code']);
                        $websiteCtrler = new WebsiteController();
                        $websiteList = $websiteCtrler->__getAllWebsites($userId);
                        $websiteIdList = array();
                        foreach ($websiteList as $info) {
                                $websiteIdList[] = $info['id'];
                        }
                        
                        $whereCond = " website_id in (".implode(',', $websiteIdList).")";
                        
                        // if whole submit limit set
                        if ($userTypeDetails['directory_submit_limit'] >= 0) {
                                $submitInfo = $this->dbHelper->getRow("dirsubmitinfo", $whereCond, "count(*) count");

                                // check whether count greater than limit
                                if ($submitInfo['count'] >= $userTypeDetails['directory_submit_limit']) {
                                        $validation['error'] = true;
                                        $validation['msg'] = formatErrorMsg(str_replace("[limit]", $userTypeDetails['directory_submit_limit'], $spTextSubs['total_count_greater_account_limit_dir_sub']), "error", "");
                                }
                                
                        }
                        
                        // if daily submit limit is set
                        if (!$validation['error'] && $userTypeDetails['directory_submit_daily_limit'] >= 0) {
                                $dateStr = date("Y-m-d");
                                $fromTime = strtotime($dateStr . " 00:00:00");
                                $toTime = strtotime($dateStr . " 23:59:59");
                                $whereCond .= " and submit_time>=$fromTime and submit_time<=$toTime";
                                $submitInfo = $this->dbHelper->getRow("dirsubmitinfo", $whereCond, "count(*) count");
                                
                                // check whether count greater than limit
                                if ($submitInfo['count'] >= $userTypeDetails['directory_submit_daily_limit']) {
                                        $validation['error'] = true;
                                        $validation['msg'] = formatErrorMsg(str_replace("[limit]", $userTypeDetails['directory_submit_daily_limit'], $spTextSubs['total_count_greater_account_limit_dir_sub_daily']), "error", "");
                                }
                                
                        }
                                
                }
                
                // if exit after error
                if ($exit && $validation['error']) {
                        showErrorMsg($validation['msg']);
                }
        
                return $validation;
        }
}
?>
Subversion Repositories cheapmusic

(root)/www/seopanel/controllers/directory.ctrl.php – Rev 103
