if (!Configuration::get('EBAY_SECURITY_TOKEN') || Tools::getValue('token') != Configuration::get('EBAY_SECURITY_TOKEN')) { echo Tools::safeOutput(Tools::getValue('not_logged_str')); return; } $ebay_request = new EbayRequest(); /* Loading categories */ $category_config_list = array(); $category_config_list_tmp = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'ebay_category_configuration`'); foreach ($category_config_list_tmp as $category) { $category_config_list[$category['id_category']] = $category; } /* Get categories */ $category_list = Db::getInstance()->executeS('SELECT `id_category`, `name` FROM `' . _DB_PREFIX_ . 'category_lang` WHERE `id_lang` = ' . (int) Tools::getValue('id_lang') . ' ' . (_PS_VERSION_ >= '1.5' ? $ebay->getContext()->shop->addSqlRestrictionOnLang() : '')); /* GET One Product by category */ $sql = 'SELECT pl.`name`, pl.`description`, p.`id_category_default` FROM `' . _DB_PREFIX_ . 'product` p LEFT JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = ' . (int) Tools::getValue('id_lang') . ' ' . (_PS_VERSION_ >= '1.5' ? $ebay->getContext()->shop->addSqlRestrictionOnLang('pl') : '') . ') GROUP BY p.`id_category_default`'; $products = Db::getInstance()->executeS($sql); /* Create array */ $product_test = array(); foreach ($products as $product) { $product_test[$product['id_category_default']] = array('description' => $product['description'], 'name' => $product['name']); } /* cats ref */