Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0  3.8.1  4.0.0  4.0.1  4.1.0   <- Available in other TYPO3 versions

class.tslib_pibase.php

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 1999-2005 Kasper Skaarhoj (kasperYYYY@typo3.com)
*  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.
*  A copy is found in the textfile GPL.txt and important notices to the license
*  from the author is found in LICENSE.txt distributed with these scripts.
*
*
*  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!
***************************************************************/
class tslib_pibase {

                // Reserved variables:
        var $cObj;              // The backReference to the mother cObj object set at call time
        var $prefixId;          // Should be same as classname of the plugin, used for CSS classes, variables
        var $scriptRelPath;     // Path to the plugin class script relative to extension directory, eg. 'pi1/class.tx_newfaq_pi1.php'
        var $extKey;            // Extension key.
        var $piVars = Array (   // This is the incoming array by name $this->prefixId merged between POST and GET, POST taking precedence. Eg. if the class name is 'tx_myext' then the content of this array will be whatever comes into &tx_myext[...]=...
                'pointer' => '',                // Used as a pointer for lists
                'mode' => '',                   // List mode
                'sword' => '',                  // Search word
                'sort' => '',                   // [Sorting column]:[ASC=0/DESC=1]
        );
        var $internal = Array(  // Used internally for general storage of values between methods
                'res_count' => 0,               // Total query count
                'results_at_a_time' => 20,      // pi_list_browseresults(): Show number of results at a time
                'maxPages' => 10,               // pi_list_browseresults(): Max number of 'Page 1 - Page 2 - ...' in the list browser
                'currentRow' => Array(),        // Current result row
                'currentTable' => '',           // Current table
        );

        var $LOCAL_LANG = Array();              // Local Language content
        var $LOCAL_LANG_charset = Array();      // Local Language content charset for individual labels (overriding)
        var $LOCAL_LANG_loaded = 0;             // Flag that tells if the locallang file has been fetch (or tried to be fetched) already.
        var $LLkey='default';                   // Pointer to the language to use.
        var $altLLkey='';                       // Pointer to alternative fall-back language to use.
        var $LLtestPrefix='';                   // You can set this during development to some value that makes it easy for you to spot all labels that ARe delivered by the getLL function.
        var $LLtestPrefixAlt='';                // Save as LLtestPrefix, but additional prefix for the alternative value in getLL() function calls

        var $pi_isOnlyFields = 'mode,pointer';
        var $pi_alwaysPrev = 0;
        var $pi_lowerThan = 5;
        var $pi_moreParams='';
        var $pi_listFields='*';

        var $pi_autoCacheFields=array();
        var $pi_autoCacheEn=0;

        var $pi_USER_INT_obj = FALSE;           // If set, then links are 1) not using cHash and 2) not allowing pages to be cached. (Set this for all USER_INT plugins!)
        var $pi_checkCHash = FALSE;             // If set, then caching is disabled if piVars are incoming while no cHash was set (Set this for all USER plugins!)

        var $conf = Array();

        // internal, don't mess with...
        var $pi_EPtemp_cObj;
        var $pi_tmpPageId=0;

















        /***************************
         *
         * Init functions
         *
         **************************/

        function tslib_pibase() {

                        // Setting piVars:
                if ($this->prefixId)    {
                        $this->piVars = t3lib_div::GParrayMerged($this->prefixId);

                                // cHash mode check
                                // IMPORTANT FOR CACHED PLUGINS (USER cObject): As soon as you generate cached plugin output which depends on parameters (eg. seeing the details of a news item) you MUST check if a cHash value is set.
                                // Background: The function call will check if a cHash parameter was sent with the URL because only if it was the page may be cached. If no cHash was found the function will simply disable caching to avoid unpredictable caching behaviour. In any case your plugin can generate the expected output and the only risk is that the content may not be cached. A missing cHash value is considered a mistake in the URL resulting from either URL manipulation, "realurl" "grayzones" etc. The problem is rare (more frequent with "realurl") but when it occurs it is very puzzling!
                        if ($this->pi_checkCHash && count($this->piVars))       {
                                $GLOBALS['TSFE']->reqCHash();
                        }
                }
                if ($GLOBALS['TSFE']->config['config']['language'])     {
                        $this->LLkey = $GLOBALS['TSFE']->config['config']['language'];
                        if ($GLOBALS['TSFE']->config['config']['language_alt']) {
                                $this->altLLkey = $GLOBALS['TSFE']->config['config']['language_alt'];
                        }
                }
        }

        function pi_setPiVarDefaults()  {
                if (is_array($this->conf['_DEFAULT_PI_VARS.'])) {
                        $this->piVars = t3lib_div::array_merge_recursive_overrule($this->conf['_DEFAULT_PI_VARS.'],is_array($this->piVars)?$this->piVars:array());
                }
        }













        /***************************
         *
         * Link functions
         *
         **************************/

        function pi_getPageLink($id,$target='',$urlParameters=array())  {
                return $this->cObj->getTypoLink_URL($id,$urlParameters,$target);        // ?$target:$GLOBALS['TSFE']->sPre
        }

        function pi_linkToPage($str,$id,$target='',$urlParameters=array())      {
                return $this->cObj->getTypoLink($str,$id,$urlParameters,$target);       // ?$target:$GLOBALS['TSFE']->sPre
        }

        function pi_linkTP($str,$urlParameters=array(),$cache=0,$altPageId=0)   {
                $conf=array();
                $conf['useCacheHash'] = $this->pi_USER_INT_obj ? 0 : $cache;
                $conf['no_cache'] = $this->pi_USER_INT_obj ? 0 : !$cache;
                $conf['parameter'] = $altPageId ? $altPageId : ($this->pi_tmpPageId ? $this->pi_tmpPageId : $GLOBALS['TSFE']->id);
                $conf['additionalParams'] = $this->conf['parent.']['addParams'].t3lib_div::implodeArrayForUrl('',$urlParameters,'',1).$this->pi_moreParams;

                return $this->cObj->typoLink($str, $conf);
        }

        function pi_linkTP_keepPIvars($str,$overrulePIvars=array(),$cache=0,$clearAnyway=0,$altPageId=0)        {
                if (is_array($this->piVars) && is_array($overrulePIvars) && !$clearAnyway)      {
                        $piVars = $this->piVars;
                        unset($piVars['DATA']);
                        $overrulePIvars = t3lib_div::array_merge_recursive_overrule($piVars,$overrulePIvars);
                        if ($this->pi_autoCacheEn)      {
                                $cache = $this->pi_autoCache($overrulePIvars);
                        }
                }
                $res = $this->pi_linkTP($str,Array($this->prefixId=>$overrulePIvars),$cache,$altPageId);
                return $res;
        }

        function pi_linkTP_keepPIvars_url($overrulePIvars=array(),$cache=0,$clearAnyway=0,$altPageId=0) {
                $this->pi_linkTP_keepPIvars('|',$overrulePIvars,$cache,$clearAnyway,$altPageId);
                return $this->cObj->lastTypoLinkUrl;
        }

        function pi_list_linkSingle($str,$uid,$cache=FALSE,$mergeArr=array(),$urlOnly=FALSE,$altPageId=0)       {
                if ($this->prefixId)    {
                        if ($cache)     {
                                $overrulePIvars=$uid?array('showUid'=>$uid):Array();
                                $overrulePIvars=array_merge($overrulePIvars,(array)$mergeArr);
                                $str = $this->pi_linkTP($str,Array($this->prefixId=>$overrulePIvars),$cache,$altPageId);
                        } else {
                                $overrulePIvars=array('showUid'=>$uid?$uid:'');
                                $overrulePIvars=array_merge($overrulePIvars,(array)$mergeArr);
                                $str = $this->pi_linkTP_keepPIvars($str,$overrulePIvars,$cache,0,$altPageId);
                        }

                                // If urlOnly flag, return only URL as it has recently be generated.
                        if ($urlOnly)   {
                                $str = $this->cObj->lastTypoLinkUrl;
                        }
                }
                return $str;
        }

        function pi_openAtagHrefInJSwindow($str,$winName='',$winParams='width=670,height=500,status=0,menubar=0,scrollbars=1,resizable=1')      {
                if (eregi('(.*)(<a[^>]*>)(.*)',$str,$match))    {
                        $aTagContent = t3lib_div::get_tag_attributes($match[2]);
                        $match[2]='<a href="#" onclick="'.
                                htmlspecialchars('vHWin=window.open(\''.$GLOBALS['TSFE']->baseUrlWrap($aTagContent['href']).'\',\''.($winName?$winName:md5($aTagContent['href'])).'\',\''.$winParams.'\');vHWin.focus();return false;').
                                '">';
                        $str=$match[1].$match[2].$match[3];
                }
                return $str;
        }














        /***************************
         *
         * Functions for listing, browsing, searching etc.
         *
         **************************/

        function pi_list_browseresults($showResultCount=1, $tableParams='', $wrapArr=array(), $pointerName='pointer', $hscText=TRUE)    {

                // example $wrapArr-array how it could be traversed from an extension
                /* $wrapArr = array(
                        'browseBoxWrap' => '<div class="browseBoxWrap">|</div>',
                        'showResultsWrap' => '<div class="showResultsWrap">|</div>',
                        'browseLinksWrap' => '<div class="browseLinksWrap">|</div>',
                        'showResultsNumbersWrap' => '<span class="showResultsNumbersWrap">|</span>',
                        'disabledLinkWrap' => '<span class="disabledLinkWrap">|</span>',
                        'inactiveLinkWrap' => '<span class="inactiveLinkWrap">|</span>',
                        'activeLinkWrap' => '<span class="activeLinkWrap">|</span>'
                ); */

                        // Initializing variables:
                $pointer = intval($this->piVars[$pointerName]);
                $count = intval($this->internal['res_count']);
                $results_at_a_time = t3lib_div::intInRange($this->internal['results_at_a_time'],1,1000);
                $totalPages = ceil($count/$results_at_a_time);
                $maxPages = t3lib_div::intInRange($this->internal['maxPages'],1,100);
                $pi_isOnlyFields = $this->pi_isOnlyFields($this->pi_isOnlyFields);

                        // $showResultCount determines how the results of the pagerowser will be shown.
                        // If set to 0: only the result-browser will be shown
                        //                       1: (default) the text "Displaying results..." and the result-browser will be shown.
                        //                       2: only the text "Displaying results..." will be shown
                $showResultCount = intval($showResultCount);

                        // if this is set, two links named "<< First" and "LAST >>" will be shown and point to the very first or last page.
                $showFirstLast = $this->internal['showFirstLast'];

                        // if this has a value the "previous" button is always visible (will be forced if "showFirstLast" is set)
                $alwaysPrev = $showFirstLast?1:$this->pi_alwaysPrev;

                if (isset($this->internal['pagefloat'])) {
                        if (strtoupper($this->internal['pagefloat']) == 'CENTER') {
                                $pagefloat = ceil(($maxPages - 1)/2);
                        } else {
                                // pagefloat set as integer. 0 = left, value >= $this->internal['maxPages'] = right
                                $pagefloat = t3lib_div::intInRange($this->internal['pagefloat'],-1,$maxPages-1);
                        }
                } else {
                        $pagefloat = -1; // pagefloat disabled
                }

                        // default values for "traditional" wrapping with a table. Can be overwritten by vars from $wrapArr
                $wrapper['disabledLinkWrap'] = '<td nowrap="nowrap"><p>|</p></td>';
                $wrapper['inactiveLinkWrap'] = '<td nowrap="nowrap"><p>|</p></td>';
                $wrapper['activeLinkWrap'] = '<td'.$this->pi_classParam('browsebox-SCell').' nowrap="nowrap"><p>|</p></td>';
                $wrapper['browseLinksWrap'] = trim('<table '.$tableParams).'><tr>|</tr></table>';
                $wrapper['showResultsWrap'] = '<p>|</p>';
                $wrapper['browseBoxWrap'] = '
                <!--
                        List browsing box:
                -->
                <div '.$this->pi_classParam('browsebox').'>
                        |
                </div>';

                        // now overwrite all entries in $wrapper which are also in $wrapArr
                $wrapper = array_merge($wrapper,$wrapArr);

                if ($showResultCount != 2) { //show pagebrowser
                        if ($pagefloat > -1) {
                                $lastPage = min($totalPages,max($pointer+1 + $pagefloat,$maxPages));
                                $firstPage = max(0,$lastPage-$maxPages);
                        } else {
                                $firstPage = 0;
                                $lastPage = t3lib_div::intInRange($totalPages,1,$maxPages);
                        }
                        $links=array();

                                // Make browse-table/links:
                        if ($showFirstLast) { // Link to first page
                                if ($pointer>0) {
                                        $links[]=$this->cObj->wrap($this->pi_linkTP_keepPIvars($this->pi_getLL('pi_list_browseresults_first','<< First',$hscText),array($pointerName => null),$pi_isOnlyFields),$wrapper['inactiveLinkWrap']);
                                } else {
                                        $links[]=$this->cObj->wrap($this->pi_getLL('pi_list_browseresults_first','<< First',$hscText),$wrapper['disabledLinkWrap']);
                                }
                        }
                        if ($alwaysPrev>=0)     { // Link to previous page
                                if ($pointer>0) {
                                        $links[]=$this->cObj->wrap($this->pi_linkTP_keepPIvars($this->pi_getLL('pi_list_browseresults_prev','< Previous',$hscText),array($pointerName => ($pointer-1?$pointer-1:'')),$pi_isOnlyFields),$wrapper['inactiveLinkWrap']);
                                } elseif ($alwaysPrev)  {
                                        $links[]=$this->cObj->wrap($this->pi_getLL('pi_list_browseresults_prev','< Previous',$hscText),$wrapper['disabledLinkWrap']);
                                }
                        }
                        for($a=$firstPage;$a<$lastPage;$a++)    { // Links to pages
                                if ($this->internal['showRange']) {
                                        $pageText = (($a*$results_at_a_time)+1).'-'.min($count,(($a+1)*$results_at_a_time));
                                } else {
                                        $pageText = trim($this->pi_getLL('pi_list_browseresults_page','Page',$hscText).' '.($a+1));
                                }
                                if ($pointer == $a) { // current page
                                        if ($this->internal['dontLinkActivePage']) {
                                                $links[] = $this->cObj->wrap($pageText,$wrapper['activeLinkWrap']);
                                        } else {
                                                $links[] = $this->cObj->wrap($this->pi_linkTP_keepPIvars($pageText,array($pointerName  => ($a?$a:'')),$pi_isOnlyFields),$wrapper['activeLinkWrap']);
                                        }
                                } else {
                                        $links[] = $this->cObj->wrap($this->pi_linkTP_keepPIvars($pageText,array($pointerName => ($a?$a:'')),$pi_isOnlyFields),$wrapper['inactiveLinkWrap']);
                                }
                        }
                        if ($pointer<$totalPages-1 || $showFirstLast)   {
                                if ($pointer==$totalPages-1) { // Link to next page
                                        $links[]=$this->cObj->wrap($this->pi_getLL('pi_list_browseresults_next','Next >',$hscText),$wrapper['disabledLinkWrap']);
                                } else {
                                        $links[]=$this->cObj->wrap($this->pi_linkTP_keepPIvars($this->pi_getLL('pi_list_browseresults_next','Next >',$hscText),array($pointerName => $pointer+1),$pi_isOnlyFields),$wrapper['inactiveLinkWrap']);
                                }
                        }
                        if ($showFirstLast) { // Link to last page
                                if ($pointer<$totalPages-1) {
                                        $links[]=$this->cObj->wrap($this->pi_linkTP_keepPIvars($this->pi_getLL('pi_list_browseresults_last','Last >>',$hscText),array($pointerName => $totalPages-1),$pi_isOnlyFields),$wrapper['inactiveLinkWrap']);
                                } else {
                                        $links[]=$this->cObj->wrap($this->pi_getLL('pi_list_browseresults_last','Last >>',$hscText),$wrapper['disabledLinkWrap']);
                                }
                        }
                        $theLinks = $this->cObj->wrap(implode(chr(10),$links),$wrapper['browseLinksWrap']);
                } else {
                        $theLinks = '';
                }

                $pR1 = $pointer*$results_at_a_time+1;
                $pR2 = $pointer*$results_at_a_time+$results_at_a_time;

                if ($showResultCount) {
                        if ($wrapper['showResultsNumbersWrap']) {
                                // this will render the resultcount in a more flexible way using markers (new in TYPO3 3.8.0).
                                // the formatting string is expected to hold template markers (see function header). Example: 'Displaying results ###FROM### to ###TO### out of ###OUT_OF###'

                                $markerArray['###FROM###'] = $this->cObj->wrap($this->internal['res_count'] > 0 ? $pR1 : 0,$wrapper['showResultsNumbersWrap']);
                                $markerArray['###TO###'] = $this->cObj->wrap(min($this->internal['res_count'],$pR2),$wrapper['showResultsNumbersWrap']);
                                $markerArray['###OUT_OF###'] = $this->cObj->wrap($this->internal['res_count'],$wrapper['showResultsNumbersWrap']);
                                $markerArray['###FROM_TO###'] = $this->cObj->wrap(($this->internal['res_count'] > 0 ? $pR1 : 0).' '.$this->pi_getLL('pi_list_browseresults_to','to').' '.min($this->internal['res_count'],$pR2),$wrapper['showResultsNumbersWrap']);
                                $markerArray['###CURRENT_PAGE###'] = $this->cObj->wrap($pointer+1,$wrapper['showResultsNumbersWrap']);
                                $markerArray['###TOTAL_PAGES###'] = $this->cObj->wrap($totalPages,$wrapper['showResultsNumbersWrap']);
                                // substitute markers
                                $resultCountMsg = $this->cObj->substituteMarkerArray($this->pi_getLL('pi_list_browseresults_displays','Displaying results ###FROM### to ###TO### out of ###OUT_OF###'),$markerArray);
                        } else {
                                // render the resultcount in the "traditional" way using sprintf
                                $resultCountMsg = sprintf(
                                        str_replace('###SPAN_BEGIN###','<span'.$this->pi_classParam('browsebox-strong').'>',$this->pi_getLL('pi_list_browseresults_displays','Displaying results ###SPAN_BEGIN###%s to %s</span> out of ###SPAN_BEGIN###%s</span>')),
                                        $count > 0 ? $pR1 : 0,
                                        min($count,$pR2),
                                        $count);
                        }
                        $resultCountMsg = $this->cObj->wrap($resultCountMsg,$wrapper['showResultsWrap']);
                } else {
                        $resultCountMsg = '';
                }

                $sTables = $this->cObj->wrap($resultCountMsg.$theLinks,$wrapper['browseBoxWrap']);

                return $sTables;
        }

        function pi_list_searchBox($tableParams='')     {
                        // Search box design:
                $sTables = '

                <!--
                        List search box:
                -->
                <div'.$this->pi_classParam('searchbox').'>
                        <form action="'.htmlspecialchars(t3lib_div::getIndpEnv('REQUEST_URI')).'" method="post" style="margin: 0 0 0 0;">
                        <'.trim('table '.$tableParams).'>
                                <tr>
                                        <td><input type="text" name="'.$this->prefixId.'[sword]" value="'.htmlspecialchars($this->piVars['sword']).'"'.$this->pi_classParam('searchbox-sword').' /></td>
                                        <td><input type="submit" value="'.$this->pi_getLL('pi_list_searchBox_search','Search',TRUE).'"'.$this->pi_classParam('searchbox-button').' />'.
                                                '<input type="hidden" name="no_cache" value="1" />'.
                                                '<input type="hidden" name="'.$this->prefixId.'[pointer]" value="" />'.
                                                '</td>
                                </tr>
                        </table>
                        </form>
                </div>';

                return $sTables;
        }

        function pi_list_modeSelector($items=array(),$tableParams='')   {
                $cells=array();
                reset($items);
                while(list($k,$v)=each($items)) {
                        $cells[]='
                                        <td'.($this->piVars['mode']==$k?$this->pi_classParam('modeSelector-SCell'):'').'><p>'.
                                $this->pi_linkTP_keepPIvars(htmlspecialchars($v),array('mode'=>$k),$this->pi_isOnlyFields($this->pi_isOnlyFields)).
                                '</p></td>';
                }

                $sTables = '

                <!--
                        Mode selector (menu for list):
                -->
                <div'.$this->pi_classParam('modeSelector').'>
                        <'.trim('table '.$tableParams).'>
                                <tr>
                                        '.implode('',$cells).'
                                </tr>
                        </table>
                </div>';

                return $sTables;
        }

        function pi_list_makelist($res,$tableParams='') {
                        // Make list table header:
                $tRows=array();
                $this->internal['currentRow']='';
                $tRows[] = $this->pi_list_header();

                        // Make list table rows
                $c=0;
                while($this->internal['currentRow'] = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))      {
                        $tRows[] = $this->pi_list_row($c);
                        $c++;
                }

                $out = '

                <!--
                        Record list:
                -->
                <div'.$this->pi_classParam('listrow').'>
                        <'.trim('table '.$tableParams).'>
                                '.implode('',$tRows).'
                        </table>
                </div>';

                return $out;
        }

        function pi_list_row($c)        {
                // Dummy
                return '<tr'.($c%2 ? $this->pi_classParam('listrow-odd') : '').'><td><p>[dummy row]</p></td></tr>';
        }

        function pi_list_header()       {
                return '<tr'.$this->pi_classParam('listrow-header').'><td><p>[dummy header row]</p></td></tr>';
        }















        /***************************
         *
         * Stylesheet, CSS
         *
         **************************/


        function pi_getClassName($class)        {
                return str_replace('_','-',$this->prefixId).($this->prefixId?'-':'').$class;
        }

        function pi_classParam($class, $addClasses='')  {
                $output = '';
                foreach (t3lib_div::trimExplode(',',$class) as $v)      {
                        $output.= ' '.$this->pi_getClassName($v);
                }
                foreach (t3lib_div::trimExplode(',',$addClasses) as $v) {
                        $output.= ' '.$v;
                }
                return ' class="'.trim($output).'"';
        }

        function pi_setClassStyle($class,$data,$selector='')    {
                $GLOBALS['TSFE']->setCSS($this->pi_getClassName($class).($selector?' '.$selector:''),'.'.$this->pi_getClassName($class).($selector?' '.$selector:'').' {'.$data.'}');
        }

        function pi_wrapInBaseClass($str)       {
                $content = '<div class="'.str_replace('_','-',$this->prefixId).'">
                '.$str.'
        </div>
        ';

                if(!$GLOBALS['TSFE']->config['config']['disablePrefixComment']) {
                        $content = '


        <!--

                BEGIN: Content of extension "'.$this->extKey.'", plugin "'.$this->prefixId.'"

        -->
        '.$content.'
        <!-- END: Content of extension "'.$this->extKey.'", plugin "'.$this->prefixId.'" -->

        ';
                }

                return $content;
        }

















        /***************************
         *
         * Frontend editing: Edit panel, edit icons
         *
         **************************/

        function pi_getEditPanel($row='',$tablename='',$label='',$conf=Array()) {
                $panel='';
                if (!$row || !$tablename)       {
                        $row = $this->internal['currentRow'];
                        $tablename = $this->internal['currentTable'];
                }

                if ($GLOBALS['TSFE']->beUserLogin)      {
                                // Create local cObj if not set:
                        if (!is_object($this->pi_EPtemp_cObj))  {
                                $this->pi_EPtemp_cObj = t3lib_div::makeInstance('tslib_cObj');
                                $this->pi_EPtemp_cObj->setParent($this->cObj->data,$this->cObj->currentRecord);
                        }

                                // Initialize the cObj object with current row
                        $this->pi_EPtemp_cObj->start($row,$tablename);

                                // Setting TypoScript values in the $conf array. See documentation in TSref for the EDITPANEL cObject.
                        $conf['allow'] = 'edit,new,delete,move,hide';
                        $panel = $this->pi_EPtemp_cObj->cObjGetSingle('EDITPANEL',$conf,'editpanel');
                }

                if ($panel)     {
                        if ($label)     {
                                return '<!-- BEGIN: EDIT PANEL --><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td valign="top">'.$label.'</td><td valign="top" align="right">'.$panel.'</td></tr></table><!-- END: EDIT PANEL -->';
                        } else return '<!-- BEGIN: EDIT PANEL -->'.$panel.'<!-- END: EDIT PANEL -->';
                } else return $label;
        }

        function pi_getEditIcon($content,$fields,$title='',$row='',$tablename='',$oConf=array())        {
                if ($GLOBALS['TSFE']->beUserLogin){
                        if (!$row || !$tablename)       {
                                $row = $this->internal['currentRow'];
                                $tablename = $this->internal['currentTable'];
                        }
                        $conf=array_merge(array(
                                'beforeLastTag'=>1,
                                'iconTitle' => $title
                        ),$oConf);
                        $content=$this->cObj->editIcons($content,$tablename.':'.$fields,$conf,$tablename.':'.$row['uid'],$row,'&viewUrl='.rawurlencode(t3lib_div::getIndpEnv('REQUEST_URI')));
                }
                return $content;
        }

















        /***************************
         *
         * Localization, locallang functions
         *
         **************************/


        function pi_getLL($key,$alt='',$hsc=FALSE)      {
                if (isset($this->LOCAL_LANG[$this->LLkey][$key]))       {
                        $word = $GLOBALS['TSFE']->csConv($this->LOCAL_LANG[$this->LLkey][$key], $this->LOCAL_LANG_charset[$this->LLkey][$key]); // The "from" charset is normally empty and thus it will convert from the charset of the system language, but if it is set (see ->pi_loadLL()) it will be used.
                } elseif ($this->altLLkey && isset($this->LOCAL_LANG[$this->altLLkey][$key]))   {
                        $word = $GLOBALS['TSFE']->csConv($this->LOCAL_LANG[$this->altLLkey][$key], $this->LOCAL_LANG_charset[$this->altLLkey][$key]);   // The "from" charset is normally empty and thus it will convert from the charset of the system language, but if it is set (see ->pi_loadLL()) it will be used.
                } elseif (isset($this->LOCAL_LANG['default'][$key]))    {
                        $word = $this->LOCAL_LANG['default'][$key];     // No charset conversion because default is english and thereby ASCII
                } else {
                        $word = $this->LLtestPrefixAlt.$alt;
                }

                $output = $this->LLtestPrefix.$word;
                if ($hsc)       $output = htmlspecialchars($output);

                return $output;
        }

        function pi_loadLL()    {
                if (!$this->LOCAL_LANG_loaded && $this->scriptRelPath)  {
                        $basePath = t3lib_extMgm::extPath($this->extKey).dirname($this->scriptRelPath).'/locallang.php';

                                // php or xml as source: In any case the charset will be that of the system language.
                                // However, this function guarantees only return output for default language plus the specified language (which is different from how 3.7.0 dealt with it)
                        $this->LOCAL_LANG = t3lib_div::readLLfile($basePath,$this->LLkey);
                        if ($this->altLLkey)    {
                                $tempLOCAL_LANG = t3lib_div::readLLfile($basePath,$this->altLLkey);
                                $this->LOCAL_LANG = array_merge(is_array($this->LOCAL_LANG) ? $this->LOCAL_LANG : array(),$tempLOCAL_LANG);
                        }

                                // Overlaying labels from TypoScript (including fictitious language keys for non-system languages!):
                        if (is_array($this->conf['_LOCAL_LANG.']))      {
                                reset($this->conf['_LOCAL_LANG.']);
                                while(list($k,$lA)=each($this->conf['_LOCAL_LANG.']))   {
                                        if (is_array($lA))      {
                                                $k = substr($k,0,-1);
                                                foreach($lA as $llK => $llV)    {
                                                        if (!is_array($llV))    {
                                                                $this->LOCAL_LANG[$k][$llK] = $llV;
                                                                if ($k != 'default')    {
                                                                        $this->LOCAL_LANG_charset[$k][$llK] = $GLOBALS['TYPO3_CONF_VARS']['BE']['forceCharset'];        // For labels coming from the TypoScript (database) the charset is assumed to be "forceCharset" and if that is not set, assumed to be that of the individual system languages (thus no conversion)
                                                                }
                                                        }
                                                }
                                        }
                                }
                        }
                }
                $this->LOCAL_LANG_loaded = 1;
        }























        /***************************
         *
         * Database, queries
         *
         **************************/

        function pi_list_query($table,$count=0,$addWhere='',$mm_cat='',$groupBy='',$orderBy='',$query='',$returnQueryArray=FALSE)       {

                        // Begin Query:
                if (!$query)    {
                                // Fetches the list of PIDs to select from.
                                // TypoScript property .pidList is a comma list of pids. If blank, current page id is used.
                                // TypoScript property .recursive is a int+ which determines how many levels down from the pids in the pid-list subpages should be included in the select.
                        $pidList = $this->pi_getPidList($this->conf['pidList'],$this->conf['recursive']);
                        if (is_array($mm_cat))  {
                                $query='FROM '.$table.','.$mm_cat['table'].','.$mm_cat['mmtable'].chr(10).
                                                ' WHERE '.$table.'.uid='.$mm_cat['mmtable'].'.uid_local AND '.$mm_cat['table'].'.uid='.$mm_cat['mmtable'].'.uid_foreign '.chr(10).
                                                (strcmp($mm_cat['catUidList'],'')?' AND '.$mm_cat['table'].'.uid IN ('.$mm_cat['catUidList'].')':'').chr(10).
                                                ' AND '.$table.'.pid IN ('.$pidList.')'.chr(10).
                                                $this->cObj->enableFields($table).chr(10);      // This adds WHERE-clauses that ensures deleted, hidden, starttime/endtime/access records are NOT selected, if they should not! Almost ALWAYS add this to your queries!
                        } else {
                                $query='FROM '.$table.' WHERE pid IN ('.$pidList.')'.chr(10).
                                                $this->cObj->enableFields($table).chr(10);      // This adds WHERE-clauses that ensures deleted, hidden, starttime/endtime/access records are NOT selected, if they should not! Almost ALWAYS add this to your queries!
                        }
                }

                        // Split the "FROM ... WHERE" string so we get the WHERE part and TABLE names separated...:
                list($TABLENAMES,$WHERE) = spliti('WHERE', trim($query), 2);
                $TABLENAMES = trim(substr(trim($TABLENAMES),5));
                $WHERE = trim($WHERE);

                        // Add '$addWhere'
                if ($addWhere)  {$WHERE.=' '.$addWhere.chr(10);}

                        // Search word:
                if ($this->piVars['sword'] && $this->internal['searchFieldList'])       {
                        $WHERE.=$this->cObj->searchWhere($this->piVars['sword'],$this->internal['searchFieldList'],$table).chr(10);
                }

                if ($count) {
                        $queryParts = array(
                                'SELECT' => 'count(*)',
                                'FROM' => $TABLENAMES,
                                'WHERE' => $WHERE,
                                'GROUPBY' => '',
                                'ORDERBY' => '',
                                'LIMIT' => ''
                        );
                } else {
                                // Order by data:
                        if (!$orderBy && $this->internal['orderBy'])    {
                                if (t3lib_div::inList($this->internal['orderByList'],$this->internal['orderBy']))       {
                                        $orderBy = 'ORDER BY '.$table.'.'.$this->internal['orderBy'].($this->internal['descFlag']?' DESC':'');
                                }
                        }

                                // Limit data:
                        $pointer = $this->piVars['pointer'];
                        $pointer = intval($pointer);
                        $results_at_a_time = t3lib_div::intInRange($this->internal['results_at_a_time'],1,1000);
                        $LIMIT = ($pointer*$results_at_a_time).','.$results_at_a_time;

                                // Add 'SELECT'
                        $queryParts = array(
                                'SELECT' => $this->pi_prependFieldsWithTable($table,$this->pi_listFields),
                                'FROM' => $TABLENAMES,
                                'WHERE' => $WHERE,
                                'GROUPBY' => $GLOBALS['TYPO3_DB']->stripGroupBy($groupBy),
                                'ORDERBY' => $GLOBALS['TYPO3_DB']->stripOrderBy($orderBy),
                                'LIMIT' => $LIMIT
                        );
                }

                $query = $GLOBALS['TYPO3_DB']->SELECTquery (
                                        $queryParts['SELECT'],
                                        $queryParts['FROM'],
                                        $queryParts['WHERE'],
                                        $queryParts['GROUPBY'],
                                        $queryParts['ORDERBY'],
                                        $queryParts['LIMIT']
                                );
                return $returnQueryArray ? $queryParts : $query;
        }

        function pi_exec_query($table,$count=0,$addWhere='',$mm_cat='',$groupBy='',$orderBy='',$query='')       {
                $queryParts = $this->pi_list_query($table,$count,$addWhere,$mm_cat,$groupBy,$orderBy,$query, TRUE);

                return $GLOBALS['TYPO3_DB']->exec_SELECT_queryArray($queryParts);
        }

        function pi_getRecord($table,$uid,$checkPage=0) {
                return $GLOBALS['TSFE']->sys_page->checkRecord($table,$uid,$checkPage);
        }

        function pi_getPidList($pid_list,$recursive=0)  {
                if (!strcmp($pid_list,''))      $pid_list = $GLOBALS['TSFE']->id;
                $recursive = t3lib_div::intInRange($recursive,0);

                $pid_list_arr = array_unique(t3lib_div::trimExplode(',',$pid_list,1));
                $pid_list = array();

                foreach($pid_list_arr as $val)  {
                        $val = t3lib_div::intInRange($val,0);
                        if ($val)       {
                                $_list = $this->cObj->getTreeList(-1*$val, $recursive);
                                if ($_list)             $pid_list[] = $_list;
                        }
                }

                return implode(',', $pid_list);
        }

        function pi_prependFieldsWithTable($table,$fieldList)   {
                $list=t3lib_div::trimExplode(',',$fieldList,1);
                $return=array();
                while(list(,$listItem)=each($list))     {
                        $return[]=$table.'.'.$listItem;
                }
                return implode(',',$return);
        }

        function pi_getCategoryTableContents($table,$pid,$whereClause='',$groupBy='',$orderBy='',$limit='')     {
                $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                                        '*',
                                        $table,
                                        'pid='.intval($pid).
                                                $this->cObj->enableFields($table).' '.
                                                $whereClause,   // whereClauseMightContainGroupOrderBy
                                        $groupBy,
                                        $orderBy,
                                        $limit
                                );
                $outArr = array();
                while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))       {
                        $outArr[$row['uid']] = $row;
                }
                $GLOBALS['TYPO3_DB']->sql_free_result($res);
                return $outArr;
        }












        /***************************
         *
         * Various
         *
         **************************/

        function pi_isOnlyFields($fList,$lowerThan=-1)  {
                $lowerThan = $lowerThan==-1 ? $this->pi_lowerThan : $lowerThan;

                $fList = t3lib_div::trimExplode(',',$fList,1);
                $tempPiVars = $this->piVars;
                while(list(,$k)=each($fList))   {
                        if (!t3lib_div::testInt($tempPiVars[$k]) || $tempPiVars[$k]<$lowerThan)         unset($tempPiVars[$k]);
                }
                if (!count($tempPiVars))        return 1;
        }

        function pi_autoCache($inArray) {
                if (is_array($inArray)) {
                        reset($inArray);
                        while(list($fN,$fV)=each($inArray))     {
                                if (!strcmp($inArray[$fN],''))  {
                                        unset($inArray[$fN]);
                                } elseif (is_array($this->pi_autoCacheFields[$fN]))     {
                                        if (is_array($this->pi_autoCacheFields[$fN]['range'])
                                                         && intval($inArray[$fN])>=intval($this->pi_autoCacheFields[$fN]['range'][0])
                                                         && intval($inArray[$fN])<=intval($this->pi_autoCacheFields[$fN]['range'][1]))  {
                                                                unset($inArray[$fN]);
                                        }
                                        if (is_array($this->pi_autoCacheFields[$fN]['list'])
                                                         && in_array($inArray[$fN],$this->pi_autoCacheFields[$fN]['list']))     {
                                                                unset($inArray[$fN]);
                                        }
                                }
                        }
                }
                if (!count($inArray))   return 1;
        }

        function pi_RTEcssText($str)    {
                $parseFunc = $GLOBALS['TSFE']->tmpl->setup['lib.']['parseFunc_RTE.'];
                if (is_array($parseFunc))       $str = $this->cObj->parseFunc($str, $parseFunc);
                return $str;
        }





        /*******************************
         *
         * FlexForms related functions
         *
         *******************************/

        function pi_initPIflexForm($field='pi_flexform')        {
                        // Converting flexform data into array:
                if (!is_array($this->cObj->data[$field]) && $this->cObj->data[$field])  {
                        $this->cObj->data[$field] = t3lib_div::xml2array($this->cObj->data[$field]);
                        if (!is_array($this->cObj->data[$field]))       $this->cObj->data[$field]=array();
                }
        }

        function pi_getFFvalue($T3FlexForm_array,$fieldName,$sheet='sDEF',$lang='lDEF',$value='vDEF')   {
                $sheetArray = is_array($T3FlexForm_array) ? $T3FlexForm_array['data'][$sheet][$lang] : '';
                if (is_array($sheetArray))      {
                        return $this->pi_getFFvalueFromSheetArray($sheetArray,explode('/',$fieldName),$value);
                }
        }

        function pi_getFFvalueFromSheetArray($sheetArray,$fieldNameArr,$value)  {

                $tempArr=$sheetArray;
                foreach($fieldNameArr as $k => $v)      {
                        if (t3lib_div::testInt($v))     {
                                if (is_array($tempArr)) {
                                        $c=0;
                                        foreach($tempArr as $values)    {
                                                if ($c==$v)     {
                                                        #debug($values);
                                                        $tempArr=$values;
                                                        break;
                                                }
                                                $c++;
                                        }
                                }
                        } else {
                                $tempArr = $tempArr[$v];
                        }
                }
                return $tempArr[$value];
        }
}

// NO extension of class - does not make sense here.
?>

---