[MOD] Complete Manufacturer Description for v1.4.8

Code: Select all

CREATE TABLE `oc_manufacturer` (
  `manufacturer_id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `sort_order` int(3) NOT NULL,
  PRIMARY KEY (`manufacturer_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=11 ;

Code: Select all

CREATE TABLE `oc_manufacturer_description` (
  `manufacturer_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `meta_keywords` varchar(255) COLLATE utf8_bin NOT NULL,
  `meta_description` varchar(255) COLLATE utf8_bin NOT NULL,
  `description` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`manufacturer_id`,`language_id`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=11 ;

Code: Select all

$ patch -p0 < opencart148_manufacturer_description.patch
patching file upload/admin/controller/catalog/manufacturer.php
patching file upload/admin/language/english/catalog/manufacturer.php
patching file upload/admin/model/catalog/manufacturer.php
patching file upload/admin/model/localisation/language.php
patching file upload/admin/view/template/catalog/manufacturer_form.tpl
patching file upload/catalog/controller/product/manufacturer.php
patching file upload/catalog/model/catalog/manufacturer.php
patching file upload/catalog/model/catalog/product.php
patching file upload/catalog/view/theme/default/template/product/manufacturer.tpl
patching file upload/.htaccess.txt
patching file upload/install/opencart.sql

Code: Select all

SELECT DISTINCT p.*

Code: Select all

SELECT DISTINCT *

Code: Select all

<?php 
    if ($_SERVER['REQUEST_URI'] == 'stores/index.php?route=product/manufacturer&manufacturer_id=8'){ 
	echo "<div id=\"css\">Your Text Goes Here - and or <img src=\"http://link-to-your-image/manufacturerjpg\" width=\"100\" height=\"100\" border=\"0\" alt=\"Apple\">";
    } elseif ($_SERVER['REQUEST_URI'] == '/stores/apple){
	echo "<div id=\"css\">Your Text Goes Here - and or <img src=\"http://link-to-your-image/manufacturerjpg\" width=\"100\" height=\"100\" border=\"0\" alt=\"Apple\">";
    } else {
	echo "You can put any code you want in the echo just be sure to escape your quotes [ \" \" ] ";
	} ?>

Code: Select all

<?php 
    if ($_SERVER['REQUEST_URI'] == '/stores/apple'){ 
	include("/stores/library/apple.tpl");
    } elseif ($_SERVER['REQUEST_URI'] == '/stores/sony'){
	include("/stores/library/sony.tpl");
    } elseif ($_SERVER['REQUEST_URI'] == '/stores/jvc'){
	include("/stores/library/jvc.tpl");
    } elseif ($_SERVER['REQUEST_URI'] == '/stores/panasonic'){
	include("/stores/library/panasonic.tpl");
    } else {
	include(" ");
	} ?>