/** * returns Sql for export * * @param string $sWhere where part of sql * @param int $iLanguage language id * @param int $iShopID shop id * * @see objects/oxERPType#getSQL() * * @return string */ public function getSQL($sWhere, $iLanguage = 0, $iShopID = 1) { if (strstr($sWhere, 'where')) { $sWhere .= ' and '; } else { $sWhere .= ' where '; } $sWhere .= 'oxordershopid = \'' . $iShopID . '\''; return parent::getSQL($sWhere, $iLanguage, $iShopID); }
/** * returns SQL string for this type * * @param string $sWhere where part of sql * @param int $iLanguage language id * @param int $iShopId shop id * * @return string */ public function getSQL($sWhere, $iLanguage = 0, $iShopId = 1) { $myConfig = oxConfig::getInstance(); // add type 'user' for security reasons if (strstr($sWhere, 'where')) { $sWhere .= ' and '; } else { $sWhere .= ' where '; } $sWhere .= ' oxrights = \'user\''; //MAFI also check for shopid to restrict access return parent::getSQL($sWhere, $iLanguage, $iShopId); }