Undefined properties Proxy::getHomeProduct♪ Check this properties, whether or not it is static.

Total \catalog\controller\product\category.php comment on these lines. if (isset($this->request->get['sort'])) { $url .= '&sort=' . $this->request->get['sort']; } if (isset($this->request->get['order'])) { $url .= '&order=' . $this->request->get['order']; }

The most not understandable is that ORDER does not fight but WHERE is a problem.Look. http://www.sql-tutorial.ru/ru/book_having_clause.html :1: FROM 2: WHERE 3: GROUP BY 4: HAVING 5: SELECT 6: ORDER BY Pseudonyms of columns appearing in the proposal SELECTin the proposal WHERE They simply do not exist, but in the proposal ORDER BY They can be used.In your case, an additional sub-request may be added:SELECT T.* FROM( SELECT p.product_id ,(SELECT price FROM me_oc_ga_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount FROM me_oc_ga_product_to_category p2c INNER JOIN me_oc_ga_product p ON (p2c.product_id = p.product_id) INNER JOIN me_oc_ga_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN me_oc_ga_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '96' GROUP BY p.product_id ORDER BY (CASE WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC , LCASE(pd.name) ASC LIMIT 0,5 )T WHERE T.discount IS NOT NULL Try this one, theoretically, you can do it faster, you need to look at the specifics:SELECT p.product_id ,(SELECT price FROM me_oc_ga_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount FROM me_oc_ga_product_to_category p2c INNER JOIN me_oc_ga_product p ON (p2c.product_id = p.product_id) INNER JOIN me_oc_ga_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN me_oc_ga_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '96' AND EXISTS (SELECT price FROM me_oc_ga_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ) GROUP BY p.product_id ORDER BY (CASE WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC , LCASE(pd.name) ASC LIMIT 0,5 ps: LEFT JOIN's for tables me_oc_ga_product and me_oc_ga_product_to_store I don't want it because if it's there, NULL - The columns listed in WHERE They'll be there. NULL and these lines won't be in the final sample.

I added the fields: (1) One of the fields copied in the template, went to the Language File, added new variables, recorded values. And he replaced it for the right in the vein. (2) Then he went to the controller, added variables that were added in the language file. (3) We need to create a field in the database where the data will be stored. (4) Let's go to a model that processes data, finishes the field we created. (5) If necessary, we'll be drinking the counteroler again (mainly there, retrieval of default data, if any, and shipment for processing)

In the module, add the method (e.g. catalog/product, not the essence):public function getAllOptions() { $option_value_description = array(); $option_value_query = $this-&gt;db-&gt;query("SELECT * FROM " . DB_PREFIX . "option_description WHERE language_id = '" . (int)$this-&gt;config-&gt;get('config_language_id') . "' ORDER BY option_id ASC"); foreach ($option_value_query -&gt;rows as $option){ $option_value_description_query = $this-&gt;db-&gt;query("SELECT * FROM " . DB_PREFIX . "option_value_description WHERE option_id = " . $option['option_id'] . " AND language_id = '" . (int)$this-&gt;config-&gt;get('config_language_id') . "' ORDER BY option_value_id ASC"); $option_value_description[$option['name']] = $option_value_description_query-&gt;rows; } return $option_value_description; } Somewhere in the control room, call the model method:$this->load->model('catalog/category'); //подключение модели .... $all_options = $this->model_catalog_product->getAllOptions(); As a result, a range of options will be obtained:Array( [опция1] => Array( [0] => Array ( [option_value_id] => ... [language_id] => ... [option_id] => ... [name] => ... ) [1] =&gt; ... [опция2] => Array( ... ....

https://www.google.ru/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0ahUKEwjG5eHG757QAhUHliwKHXf9AL4QFggqMAI&url=https%3A%2F%2Fkassa.yandex.ru%2Ffiles%2Fmanual_y.cms_opencart2.pdf&usg=AFQjCNHIOgMPqDa8dOVz2U9J2eK_mabAkQ There's a manual. Read it and do it right there. I had the same problem, it worked.

I'd write:RewriteRule ^/product/(.*) http://site.com/$1 [R=301,L]

It's just that your task isn't done. The fact is that the merchandise is using multiple tables, the data are broken down accordingly.I recommend that you use the data import module, for example: https://www.opencart.com/index.php?route=extension/extension/info&extension_id=17 Theoretically, the same can be achieved by writing sql queries that will put the necessary data into the necessary tables, but for that, you will have to deal with the structure of the tables and sql.

Look. /catalog/controller/checkout/confirm.php The order is being processed. And the very recording of an order in the OBD system in the model /catalog/model/checkout/order.php

We can do this: Counterpart of produce catalog/controller/product/product.php Add the variable in which the current language code is to be added to check the stack. $lng = $this->language->get('code');And in the product template. catalog/view/theme/default/template/product/product.tpl Make a condition:<?php if ($lng = 'en') { ?> <?php echo $price_en; ?> <?php } else { ?> <?php echo $price_ru; ?> <?php } ?>

Simple, tox screen:$count = 0; foreach ($results as $result) { if (is_numeric(utf8_substr($result['name'], 0, 1))) { $key = '0 - 9'; } else { $key = utf8_substr(utf8_strtoupper($result['name']), 0, 1); } if (!isset($data['brands'][$key])) { $data['brands'][$key]['name'] = $key; } $data['brands'][$key]['manufacturer'][] = array( 'name' =&gt; $result['name'], 'image' =&gt; $this-&gt;model_tool_image-&gt;resize($result['image'], $this-&gt;config-&gt;get('config_image_thumb_width'), $this-&gt;config-&gt;get('config_image_thumb_height')), 'href' =&gt; $this-&gt;url-&gt;link('product/manufacturer/info', 'manufacturer_id=' . $result['manufacturer_id']), 'limit' =&gt; 3 ); $count++; if ($count >= 3) { break; } }

To make a reflection. order Instead of quantity + sum:♪ language/russian/module/cart.php Replace standard text_items On:$_['text_items'] = 'Корзина: %s';♪ controller/module/cart.php Find a line. text_items and replace by:$this->data['text_items'] = sprintf($this->language>get('text_items'), $this->currency->format($total));♪ view/...../module/cart.tpl find out. div heading and replace it with:<div class="heading"> <a title="<?php echo $heading_title; ?>"><span id="cart- total"><?php echo $text_items; ?></span></a> </div>

Look at the file. /catalog/controller/product/product.php , public function write()♪ This is the text of the withdrawal:if ((utf8_strlen($this->request->post['text']) < 25) || (utf8_strlen($this->request->post['text']) > 1000)) { $json['error'] = $this->language->get('error_text'); } If the text is less than 25 symbols or more than 1,000, a mistake is made.

The cronium is squeaked in which orders are obtained from the database, oc_order_product and oc_order.select order_id,date_added,email,firstname, lastname, shipping_country,shipping_zone,shipping_code,payment_method,total ,shipping_city,shipping_address_1,shipping_postcode,telephone,comment from oc_order where (date_added BETWEEN '$last_time_update' AND '$cur_date') AND order_status_id=1 select name,quantity from oc_order_product where order_id='$order_id'

It's called Recurring function♪ The point is: Define all elements in the masses, regardless of the size of the mass.The condition states: Remove the elements of the mass (multi-dimensional mass) until the final value of the mass is met, if the value is not massive, then apply the htmlspecialchars function to the data.Let's see what the data is:[ 1 => 'test' 2 => ['test1', 'test2'] ] This code will process all the elements (test, test1, test2) as and no matter how many of the volumes will be inserted in each other, The htmlspecialchars function will be applied to all mass values♪

/home/g/site/site.ru/public_html/catalog/view/theme/default/template/default/template/module/category_menu.tplIn those files that have changed, carefully check the paths, it can't be possible to find a template when you're on the line because you're on the way.

I think so:$title = $this->document->getTitle().' '.$this->document->getDescription(); $this->document->setTitle($title);

Check it out. pathname♪jQuery(document).ready(function($) { var pathname=document.location.pathname; $.each($("div.left-menu .list-group-item.leftje"),function(){ if(this.pathname==pathname){ $(this).addClass('active'); } }); });

Although Server's deposit indicates which files are allowed, it doesn't work.We need to open the file. sait.loc\admin\controller\common\filemanager.php and on the lines:37 http://prntscr.com/cg3uhh ;234 http://prntscr.com/cg3tzt ;247 http://prntscr.com/cg3u5e ;add your type of files.

The password generation can be made when the data is sent to the server<?php $chars="qazxswedcvfrtgbnhyujmkiolp1234567890QAZXSWEDCVFRTGBNHYUJMKIOLP"; $max=10; $size=StrLen($chars)-1; $password=null; while($max--) $password.=$chars[rand(0,$size)]; echo $password; $password This is where your password will put it in the base, and add the password to the letter.