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 */
