Alexandr

1. http://futuresmoking.ru/ 2. osStore 0.13 + SEO TITLES + SEO URL 3. сайт только открылся 4. sweb.ru 5. Интернет магазин Электронных Сигарет

Добрый день всем! Уже не раз обсуждался крупный недостаток в OpenCart для SEO специалистов - это отсутствие возможности настроить самому содержимое тэгов TITLE и H1. Довольно серьёзная причина почему многие SEO специалисты отказывались работать с ней. По моему заданию это было исправлено и работает - если поля TITLE и H1 не заполнены то значения берутся как раньше из названия товара, а если заполнены то из заполненных значений. Теперь выкладываю БЕСПЛАТНО на всеобщее обозрение, надеюсь babushka и те кто отвечают за обновление русского OpenCart. добавят это в русскую сборку. Кодер буржуйский, поэтому комменты на английском: Added two fields in tables : 1. oc_product_description 2. oc_category_description meta_title h1tag Changes : admin/view/template/catalog/category_form.tpl 44 line to line 54 _______Added _______<tr> <td>Meta Title</td> <td><input name="category_description[<?php echo $language['language_id']; ?>][meta_title]" size="100" value="<?php echo isset($category_description[$language['language_id']]) ? $category_description[$language['language_id']]['meta_title'] : ''; ?>" /> </td> </tr> <tr> <td>H1 tag</td> <td><input name="category_description[<?php echo $language['language_id']; ?>][h1tag]" size="100" value="<?php echo isset($category_description[$language['language_id']]) ? $category_description[$language['language_id']]['h1tag'] : ''; ?>" /> </td> </tr>_______Added____ admin/view/template/catalog/product_form.tpl 44 line to line 57 _______Added _______<tr> <td>Meta Title</td> <td> <input type="text" name="product_description[<?php echo $language['language_id']; ?>][meta_title]" value="<?php echo isset($product_description[$language['language_id']]) ? $product_description[$language['language_id']]['meta_title'] : ''; ?>" size="80"/> </td> </tr> <tr> <td>H1 tag</td> <td> <input type="text" name="product_description[<?php echo $language['language_id']; ?>][h1tag]" value="<?php echo isset($product_description[$language['language_id']]) ? $product_description[$language['language_id']]['h1tag'] : ''; ?>" size="80"/> </td> </tr>_______Added____ admin/model/catalog/category.php Line 12 - changed from foreach ($data['category_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "category_description SET category_id = '" . (int)$category_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "'"); } To foreach ($data['category_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "category_description SET category_id = '" . (int)$category_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "', meta_title = '" . $this->db->escape($value['meta_title']) . "', h1tag = '" . $this->db->escape($value['h1tag']) . "'"); } Line 38 From foreach ($data['category_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "category_description SET category_id = '" . (int)$category_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "'"); } To foreach ($data['category_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "category_description SET category_id = '" . (int)$category_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "', meta_title = '" . $this->db->escape($value['meta_title']) . "', h1tag = '" . $this->db->escape($value['h1tag']) . "'"); } Line 123 From $category_description_data[$result['language_id']] = array( 'name' => $result['name'], 'meta_keywords' => $result['meta_keywords'], 'meta_description' => $result['meta_description'], 'description' => $result['description'] ); To $category_description_data[$result['language_id']] = array( 'name' => $result['name'], 'meta_keywords' => $result['meta_keywords'], 'meta_description' => $result['meta_description'], 'description' => $result['description'], 'meta_title' => $result['meta_title'], 'h1tag' => $result['h1tag'] ); admin/model/catalog/product.php Line 12 From foreach ($data['product_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "'"); } To foreach ($data['product_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "', meta_title = '" . $this->db->escape($value['meta_title']) . "', h1tag = '" . $this->db->escape($value['h1tag']) . "'"); } Line 107 From foreach ($data['product_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "'"); } To foreach ($data['product_description'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keywords = '" . $this->db->escape($value['meta_keywords']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "', meta_title = '" . $this->db->escape($value['meta_title']) . "', h1tag = '" . $this->db->escape($value['h1tag']) . "'"); } Line 388 From $product_description_data[$result['language_id']] = array( 'name' => $result['name'], 'meta_keywords' => $result['meta_keywords'], 'meta_description' => $result['meta_description'], 'description' => $result['description'] ); To $product_description_data[$result['language_id']] = array( 'name' => $result['name'], 'meta_keywords' => $result['meta_keywords'], 'meta_description' => $result['meta_description'], 'description' => $result['description'], 'meta_title' => $result['meta_title'], 'h1tag' => $result['h1tag'] ); catalog/controller/product/category.php Line 48 from $this->document->title = $category_info['name']; To if($category_info['meta_title'] == "") { $this->document->title = $category_info['name']; } else { $this->document->title = $category_info['meta_title']; } catalog/controller/product/product.php Line 113 from $this->document->title = $product_info['name']; To if($product_info['meta_title'] == "") { $this->document->title = $product_info['name']; } else { $this->document->title = $product_info['meta_title']; }