source/Application/Model/ArticleList.php
public function loadActionArticles($sActionID, $iLimit = null)
    {
        // Performance
        if (!trim($sActionID)) {
            return;
        }

        $sShopID = \OxidEsales\Eshop\Core\Registry::getConfig()->getShopId();
        $sActionID = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote(strtolower($sActionID));

        //echo $sSelect;
        $oBaseObject = $this->getBaseObject();
        $sArticleTable = $oBaseObject->getViewName();
        $sArticleFields = $oBaseObject->getSelectFields();

        $oBase = oxNew(\OxidEsales\Eshop\Application\Model\Actions::class);
        $sActiveSql = $oBase->getSqlActiveSnippet();
        $sViewName = $oBase->getViewName();

        $sLimit = ($iLimit > 0) ? "limit " . $iLimit : '';

        $sSelect = "select $sArticleFields from oxactions2article
                              left join $sArticleTable on $sArticleTable.oxid = oxactions2article.oxartid
                              left join $sViewName on $sViewName.oxid = oxactions2article.oxactionid
                              where oxactions2article.oxshopid = '$sShopID' and oxactions2article.oxactionid = $sActionID and $sActiveSql
                              and $sArticleTable.oxid is not null and " . $oBaseObject->getSqlActiveSnippet() . "
                              order by oxactions2article.oxsort $sLimit";

        $this->selectString($sSelect);
    }
public function loadActionArticles($sActionID, $iLimit = null)
    {
        // Performance
        if (!trim($sActionID)) {
            return;
        }

        $sShopID = \OxidEsales\Eshop\Core\Registry::getConfig()->getShopId();
        $sActionID = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote(strtolower($sActionID));

        //echo $sSelect;
        $oBaseObject = $this->getBaseObject();
        $sArticleTable = $oBaseObject->getViewName();
        $sArticleFields = $oBaseObject->getSelectFields();

        $oBase = oxNew(\OxidEsales\Eshop\Application\Model\Actions::class);
        $sActiveSql = $oBase->getSqlActiveSnippet();
        $sViewName = $oBase->getViewName();

        $sLimit = ($iLimit > 0) ? "limit " . $iLimit : '';

        $sSelect = "select $sArticleFields from oxactions2article
                              left join $sArticleTable on $sArticleTable.oxid = oxactions2article.oxartid
                              left join $sViewName on $sViewName.oxid = oxactions2article.oxactionid
                              where oxactions2article.oxshopid = '$sShopID' and oxactions2article.oxactionid = $sActionID and $sActiveSql
                              and $sArticleTable.oxid is not null and " . $oBaseObject->getSqlActiveSnippet() . "
                              order by oxactions2article.oxsort $sLimit";

        $this->selectString($sSelect);
    }
public function loadActionArticles ( $ sActionID , $ iLimit = null ) { // Performance if ( ! trim ( $ sActionID ) ) { return ; } $ sShopID = \ OxidEsales \ Eshop \ Core \ Registry :: getConfig ( ) -> getShopId ( ) ; $ sActionID = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> quote ( strtolower ( $ sActionID ) ) ; //echo $sSelect; $ oBaseObject = $ this -> getBaseObject ( ) ; $ sArticleTable = $ oBaseObject -> getViewName ( ) ; $ sArticleFields = $ oBaseObject -> getSelectFields ( ) ; $ oBase = oxNew ( \ OxidEsales \ Eshop \ Application \ Model \ Actions :: class ) ; $ sActiveSql = $ oBase -> getSqlActiveSnippet ( ) ; $ sViewName = $ oBase -> getViewName ( ) ; $ sLimit = ( $ iLimit > 0 ) ? "limit " . $ iLimit : '' ; $ sSelect = "select $sArticleFields from oxactions2article
                              left join $sArticleTable on $sArticleTable.oxid = oxactions2article.oxartid
                              left join $sViewName on $sViewName.oxid = oxactions2article.oxactionid
                              where oxactions2article.oxshopid = '$sShopID' and oxactions2article.oxactionid = $sActionID and $sActiveSql
                              and $sArticleTable.oxid is not null and " . $ oBaseObject -> getSqlActiveSnippet ( ) . "
                              order by oxactions2article.oxsort $sLimit" ; $ this -> selectString ( $ sSelect ) ; }
Loads shop AktionArticles.

@param string $sActionID Action id
@param int    $iLimit    Select limit

@return null
Loads shop AktionArticles .