"TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/indexed_search/modfunc2/class.tx_indexedsearch_modfunc2.php Source File", "datetime" => "Sat Dec 2 19:22:33 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

class.tx_indexedsearch_modfunc2.php

<?php
/***************************************************************
 *  Copyright notice
 *
 *  (c) 2004 Dimitri Ebert (dimitri.ebert@dkd.de)
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project 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.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script 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.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/
require_once(PATH_t3lib.'class.t3lib_extobjbase.php');
require_once(PATH_t3lib.'class.t3lib_tsfebeuserauth.php');




class tx_indexedsearch_modfunc2 extends t3lib_extobjbase {

        function main() {
                        // Initializes the module. Done in this function because we may need to re-initialize if data is submitted!
                global $SOBE,$BE_USER,$LANG,$BACK_PATH,$TCA_DESCR,$TCA,$CLIENT,$TYPO3_CONF_VARS;

                $theOutput.=$this->pObj->doc->spacer(5);
                $theOutput.=$this->pObj->doc->section($LANG->getLL('title'),$this->showStats(),0,1);

                $menu=array();
                $menu[]=t3lib_BEfunc::getFuncCheck($this->pObj->id,'SET[tx_indexedsearch_modfunc2_check]',$this->pObj->MOD_SETTINGS['tx_indexedsearch_modfunc2_check']).$LANG->getLL('checklabel');
                $theOutput.=$this->pObj->doc->spacer(5);

                return $theOutput;
        }


        function showStats()    {
                global $LANG,$HTTP_GET_VARS,$TYPO3_CONF_VARS;

                $conf['words']=50;      // max words in result list
                $conf['bid']=$HTTP_GET_VARS['id'];      // pageid for several statistics

                $addwhere1='';  // all records
                $addwhere2=' AND tstamp > '.(time()-30*24*60*60);       // last 30 days
                $addwhere3=' AND tstamp > '.(time()-24*60*60);          // last 24 hours

                $content.= $LANG->getLL('title2').'
                        <table cellpading="5" cellspacing="5" valign="top"><tr><td valign="top">'
                        .$this->listSeveralStats($LANG->getLL('all'),$addwhere1,$conf).'</td><td valign="top">'
                        .$this->listSeveralStats($LANG->getLL('last30days'),$addwhere2,$conf).'</td><td valign="top">'
                        .$this->listSeveralStats($LANG->getLL('last24hours'),$addwhere3,$conf).'</td></tr></table>'
                        .$this->note;

                        // Ask hook to include more on the page:
                if ($hookObj = &$this->hookRequest('additionalSearchStat'))     {
                        $content.= $hookObj->additionalSearchStat();
                }

                return $content;
        }

        function listSeveralStats($title,$addwhere,$conf)       {
                global $LANG;

                $queryParts['SELECT']= '*, COUNT(*) AS c';
                $queryParts['FROM']='index_stat_word';
                $queryParts['WHERE']=sprintf('pageid= %s '.$addwhere, $conf['bid']);
                $queryParts['GROUPBY']='word';
                $queryParts['ORDERBY']='c DESC,word';
                $queryParts['LIMIT']=$conf['words'];

                $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                                $queryParts['SELECT'],
                                $queryParts['FROM'],
                                $queryParts['WHERE'],
                                $queryParts['GROUPBY'],
                                $queryParts['ORDERBY'],
                                $queryParts['LIMIT']
                        );

                if ($res)       {
                        $count = $GLOBALS['TYPO3_DB']->sql_num_rows($res);
                } else {
                        $count = 0;
                }

                        // exist several statistics for this page?
                if ($count > 0) {
                        $this->note =   $LANG->getLL('justthispage');
                } else {
                                // Limit access to pages of the current site
                        $secureaddwhere = ' AND pageid IN ('.($this->extGetTreeList($conf['bid'],100,0,'1')).$conf['bid'].') ';
                        $this->note = $LANG->getLL('allpages');

                        $queryParts['WHERE']= '1 '.$addwhere.$secureaddwhere;
                }

                        // make real query
                $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                                $queryParts['SELECT'],
                                $queryParts['FROM'],
                                $queryParts['WHERE'],
                                $queryParts['GROUPBY'],
                                $queryParts['ORDERBY'],
                                $queryParts['LIMIT']
                );

                $table1='';
                $i=0;
                if ($res)       {
                        while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))      {
                                $i++;
                                $table1.='<tr class="bgColor4"><td>'.$i.'.</td><td>'.$row['word'].'</td><td>&nbsp;&nbsp;'.$row['c'].'</td></tr>';
                        }
                }

                if ($i==0)      {
                        $table1='<tr class="bgColor4"><td callspan="3">'.$LANG->getLL("noresults").'</td></tr>';
                }

                $table1='<table class="bgColor5" cellpadding="2" cellspacing="1"><tr class="tableheader"><td colspan="3">'.$title.'</td></tr>'.$table1.'</table>';

                return $note.$table1;
        }

        function extGetTreeList($id,$depth,$begin = 0,$perms_clause)    {
                return t3lib_tsfeBeUserAuth::extGetTreeList($id,$depth,$begin,$perms_clause);
        }

        function &hookRequest($functionName)    {
                global $TYPO3_CONF_VARS;

                        // Hook: menuConfig_preProcessModMenu
                if ($TYPO3_CONF_VARS['EXTCONF']['indexed_search']['be_hooks'][$functionName])   {
                        $hookObj = &t3lib_div::getUserObj($TYPO3_CONF_VARS['EXTCONF']['indexed_search']['be_hooks'][$functionName]);
                        if (method_exists ($hookObj, $functionName))    {
                                $hookObj->pObj = &$this;
                                return $hookObj;
                        }
                }
        }
}



if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/indexed_search/modfunc2/class.tx_indexedsearch_modfunc2.php']) {
        include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/indexed_search/modfunc2/class.tx_indexedsearch_modfunc2.php']);
}

?>