oxseodecoder.php

Go to the documentation of this file.

<?php

class oxSeoDecoder extends oxSuperCfg
{
    public function parseStdUrl($sUrl)
    {
        $aRet = array();
        $sUrl = html_entity_decode($sUrl);
        if (($iPos = strpos($sUrl, '?')) !== false) {
            $aParams = explode('&', substr($sUrl, $iPos+1));
            foreach ($aParams as $sParam) {
                $aP = explode('=', $sParam);
                if (count($aP) == 2) {
                    if (($sName = trim($aP[0])) && ($sValue = trim($aP[1]))) {
                        $aRet[$sName] = rawurldecode($sValue);
                    }
                }
            }
        }
        return $aRet;
    }

    public function decodeUrl( $sSeoUrl )
    {
        $sBaseUrl = $this->getConfig()->getShopURL();
        if ( strpos( $sSeoUrl, $sBaseUrl ) === 0 ) {
            $sSeoUrl = substr( $sSeoUrl, strlen( $sBaseUrl ) );
        }
        $iShopId = $this->getConfig()->getShopId();
        $sSeoUrl = rawurldecode($sSeoUrl);

        $sKey = md5( strtolower( $sSeoUrl ) );

        $rs = oxDb::getDb(true)->Execute( "select oxstdurl, oxlang from oxseo where oxident='$sKey' and oxshopid='$iShopId' limit 1");
        if (!$rs->EOF) {
            $sStdUrl = $rs->fields['oxstdurl'];
            $iLang   = $rs->fields['oxlang'];
            $aRet = $this->parseStdUrl($sStdUrl);
            $aRet['lang'] = $iLang;
            return $aRet;
        }
        return false;
    }

    protected function _decodeOldUrl( $sSeoUrl )
    {
        $oDb = oxDb::getDb(true);
        $sBaseUrl = $this->getConfig()->getShopURL();
        if ( strpos( $sSeoUrl, $sBaseUrl ) === 0 ) {
            $sSeoUrl = substr( $sSeoUrl, strlen( $sBaseUrl ) );
        }
        $iShopId = $this->getConfig()->getShopId();
        $sSeoUrl = rawurldecode($sSeoUrl);
        $sKey = md5( strtolower( $sSeoUrl ) );

        $sUrl = false;
        $rs = $oDb->execute( "select oxobjectid, oxlang from oxseohistory where oxident = '{$sKey}' and oxshopid = '{$iShopId}' limit 1");
        if ( !$rs->EOF ) {
            // updating hit info (oxtimestamp field will be updated automatically)
            $oDb->execute( "update oxseohistory set oxhits = oxhits + 1 where oxident = '{$sKey}' and oxshopid = '{$iShopId}' limit 1" );

            // fetching new url
            $sUrl = $oDb->getOne( "select oxseourl from oxseo where oxobjectid = '{$rs->fields['oxobjectid']}' and oxlang = '{$rs->fields['oxlang']}' and oxshopid = '{$iShopId}' " );
        }
        return $sUrl;
    }

    public function processSeoCall( $sRequest = null, $sPath = null )
    {
        // first - collect needed parameters
        if ( !$sRequest ) {
            if ( isset( $_SERVER['REQUEST_URI'] ) && $_SERVER['REQUEST_URI'] ) {
                $sRequest = $_SERVER['REQUEST_URI'];
            } else {    // try something else
                $sRequest = $_SERVER['SCRIPT_URI'];
            }
        }

        $sPath = $sPath ? $sPath : str_replace( 'oxseo.php', '', $_SERVER['SCRIPT_NAME'] );
        if ( ( $sParams = $this->_getParams( $sRequest, $sPath ) ) ) {

            // in case SEO url is actual
            if ( is_array( $aGet = $this->decodeUrl( $sParams ) ) ) {
                $_GET = array_merge( $aGet, $_GET );
                oxLang::getInstance()->resetBaseLanguage();
            } elseif ( ( $sRedirectUrl = $this->_decodeOldUrl( $sParams ) ) ) {
                // in case SEO url was changed - redirecting to new location
                oxUtils::getInstance()->redirect( $this->getConfig()->getShopURL().$sRedirectUrl, false );
            } elseif ( ( $sRedirectUrl = $this->_decodeSimpleUrl( $sParams ) ) ) {
                // old type II seo urls
                oxUtils::getInstance()->redirect( $this->getConfig()->getShopURL().$sRedirectUrl, false );
            } else { // unrecognized url
                error_404_handler( $sParams );
            }
        }
    }

    protected function _decodeSimpleUrl( $sParams )
    {
        $sLastParam = rtrim( $sParams, '/' );
        $sLastParam = substr( $sLastParam, ( ( int ) strrpos( $sLastParam, '/' ) ) - ( strlen( $sLastParam ) ) );
        $sLastParam = trim( $sParams, '/' );

        // active object id
        $sUrl = null;

        if ( $sLastParam ) {

            $sLastParam = oxDb::getDb()->quote( $sLastParam );
            $iLanguage  = oxLang::getInstance()->getBaseLanguage();

            // article ?
            if ( strpos( $sLastParam, '.htm' ) !== false ) {
                $sUrl = $this->_getObjectUrl( $sLastParam, 'oxarticles', $iLanguage, 'oxarticle' );
            } else {

                // category ?
                if ( !( $sUrl = $this->_getObjectUrl( $sLastParam, 'oxcategories', $iLanguage, 'oxcategory' ) ) ) {
                    // then maybe vendor ?
                    $sUrl = $this->_getObjectUrl( $sLastParam, 'oxvendor', $iLanguage, 'oxvendor' );
                }
            }
        }

        return $sUrl;
    }

    protected function _getObjectUrl( $sSeoId, $sTable, $iLanguage, $sType )
    {
        $oDb     = oxDb::getDb();
        $sTable  = getViewName( $sTable );
        $sField  = "oxseoid".oxLang::getInstance()->getLanguageTag( $iLanguage );
        $sSeoUrl = null;

        try {
            if ( $sObjectId = $oDb->getOne( "select oxid from $sTable where $sField = $sSeoId" ) ) {
                $sSeoUrl = $oDb->getOne( "select oxseourl from oxseo where oxtype = '$sType' and oxobjectid = '$sObjectId' and oxlang = '$iLanguage' " );
            }
        } catch ( Exception $oEx ) {
            // in case field does not exist must catch db exception
        }

        return $sSeoUrl;
    }

    protected function _getParams( $sRequest, $sPath )
    {
        $sParams = preg_replace( '/\?.*/', '', $sRequest );
        $sPath   = preg_quote($sPath, '/');
        $sParams = preg_replace( "/^$sPath/", '', $sParams );

        // this should not happen on most cases, because this redirect is handled by .htaccess
        if ( $sParams && !ereg( '\.html$', $sParams ) && !ereg( '\/$', $sParams ) ) {
            oxUtils::getInstance()->redirect( $this->getConfig()->getShopURL() . $sParams . '/', false );
        }

        return $sParams;
    }

    public function fetchSeoUrl( $sStdUrl, $iLanguage = null )
    {
        $oDb = oxDb::getDb( true );
        $sStdUrl = $oDb->quote( $sStdUrl );
        $iLanguage = isset( $iLanguage ) ? $iLanguage : oxLang::getInstance()->getBaseLanguage();

        $sSeoUrl = false;

        $sQ = "select oxseourl, oxlang from oxseo where oxstdurl = $sStdUrl and oxlang = '$iLanguage' limit 1";
        $oRs = $oDb->execute( $sQ );
        if ( !$oRs->EOF ) {
            $sSeoUrl = oxSeoEncoder::getInstance()->getLanguageParam( $oRs->fields['oxlang'] ).$oRs->fields['oxseourl'];
        }

        return $sSeoUrl;
    }
}

---