Всем привет. Очень нужная тема. Но не могу разобраться! Помогите, пожалуйста. Когда вставляю код
$product_data = array();
//$product_related_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_related WHERE product_id = '" . (int)$product_id . "'");
// add
$add="";
$temp= $this->db->query("SELECT name FROM " . DB_PREFIX . "product_description WHERE product_id='" . (int)$product_id . "' AND language_id='" . (int)$this->config->get('config_language_id') . "';");
$parts = explode( ' ',trim($temp->row['name']));
foreach( $parts as $part ) {
if (strlen($part)>4) {
$add .= ' OR LOWER(name) LIKE "%'.$this->db->escape(strtolower(trim($part))).'%" ';
}
}
$add = substr( $add, 4 );$add="( $add )";
$product_related_query =$this->db->query("SELECT pd.product_id as related_id FROM " . DB_PREFIX . "product_description AS pd
LEFT JOIN " . DB_PREFIX . "product AS p ON p.product_id = pd.product_id
LEFT JOIN " . DB_PREFIX . "product_to_store AS p2s ON p2s.product_id = pd.product_id
WHERE $add AND p.status = 1 AND pd.product_id<>'" . (int)$product_id . "' AND p.quantity>'0'
AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "'
AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' GROUP BY pd.product_id LIMIT 4;");
// add
foreach ($product_related_query->rows as $result) {
То выскакивает ошибка Parse error: syntax error, unexpected T_PUBLIC
А этот и вовсе не знаю куда тулить
<modification>
<id>Automatic Relate</id>
<version>1.0.1</version>
<vqmver>2.1</vqmver>
<author>Palcet</author>
<file name="catalog/model/catalog/product.php">
<operation>
<search position="after">
<![CDATA[
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_related pr LEFT JOIN " . DB_PREFIX . "product p ON (pr.related_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '" . (int)$product_id . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'");
]]>
</search>
<add>
<![CDATA[
if($query->num_rows==0)
{
$sql=" select *,p.product_id as related_id from " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) where p.product_id in (select product_id from " . DB_PREFIX . "product_to_category where category_id in (SELECT category_id FROM " . DB_PREFIX . "product_to_category where product_id=".(int)$product_id.")) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' limit 15";
$query = $this->db->query($sql);
}
]]>
</add>
</operation>
</file>
</modification>
Помогите, пожалуйста. А-то руками добавлять сотни похожих товаров очень долго