{"id":2387,"date":"2023-04-11T17:09:25","date_gmt":"2023-04-11T14:09:25","guid":{"rendered":"https:\/\/freeextra.com\/2023\/04\/11\/%ce%b1%cf%85%cf%84%cf%8c%ce%bc%ce%b1%cf%84%ce%b7-%ce%b4%ce%b7%ce%bc%ce%b9%ce%bf%cf%85%cf%81%ce%b3%ce%af%ce%b1-%ce%bf%ce%bc%ce%ac%ce%b4%cf%89%ce%bd-%cf%80%ce%b5%ce%bb%ce%b1%cf%84%cf%8e%ce%bd-%cf%80\/"},"modified":"2026-06-11T12:01:24","modified_gmt":"2026-06-11T09:01:24","slug":"aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart","status":"publish","type":"post","link":"https:\/\/www.freeextra.com\/en\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/","title":{"rendered":"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart"},"content":{"rendered":"<p>\u03a3\u03c4\u03b7 \u03b3\u03ad\u03c6\u03c5\u03c1\u03b1 \u03c4\u03b7\u03c2 EMDI \u03b3\u03b9\u03b1 OpenCart \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c4\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf \u03ba\u03ce\u03b4\u03b9\u03ba\u03b1<\/p>\n<p><!-- Urvanov Syntax Highlighter v2.9.1 --><\/p>\n<div id=\"urvanov-syntax-highlighter-6a2a791212d69107834857\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-monaco urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-mouseover disable-anim wrap\" style=\" margin-top: 12px; margin-bottom: 12px; font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-toolbar\" data-settings=\" show\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\"><span class=\"crayon-title\"><\/span><\/p>\n<div class=\"crayon-tools\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\">\n<div class=\"crayon-button urvanov-syntax-highlighter-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-copy-button\" title=\"Copy\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<p><span class=\"crayon-language\">PHP<\/span><\/div>\n<\/div>\n<div class=\"crayon-info\" style=\"min-height: 16.8px !important; line-height: 16.8px !important;\"><\/div>\n<div class=\"urvanov-syntax-highlighter-plain-wrap\"><textarea  class=\"urvanov-syntax-highlighter-plain print-no\" data-settings=\"dblclick\" readonly style=\"-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 12px !important; line-height: 15px !important;\"><br \/>\n\/\/ \u03a5\u03a0\u039f\u039b\u039f\u0393\u0399\u03a3\u039c\u039f\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d<br \/>\nif ($action == &#8216;calc_discounts&#8217;)<br \/>\n{<\/p>\n<p>\t$debug=0;<\/p>\n<p>\t\/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d \u039c\u0395 \u0395\u0399\u0394\u0399\u039a\u0395\u03a3 \u03a3\u03a5\u039d\u0398\u0397\u039a\u0395\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d<br \/>\n\t$query=&#8221;<br \/>\n\tselect <\/p>\n<p>        cust.customer_id,<br \/>\n        cust.customer_group_id,<\/p>\n<p>       (<br \/>\n       SELECT <\/p>\n<p>       (select GROUP_CONCAT( concat( manuf.manufacturer_id,&#8217;|&#8217;,manuf.name)  ) from &#8221; . $dbprefix . &#8220;manufacturer manuf  where  hist.comment like concat(&#8216;%,&#8217;,manuf.name,&#8217;%&#8217;)   )<\/p>\n<p>       FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; . $dbprefix . &#8220;customer_history hist<\/p>\n<p>       where descr.language_id=$lang_id<br \/>\n       and descr.name like &#8216;%\\%&#8217;<br \/>\n       and hist.comment like descr.name<br \/>\n       and hist.customer_id=cust.customer_id<br \/>\n       order by hist.date_added desc<br \/>\n       limit 1<\/p>\n<p>       ) manufacturers_ids<\/p>\n<p>       ,<\/p>\n<p>       (<br \/>\n       SELECT <\/p>\n<p>       hist.comment<\/p>\n<p>       FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; . $dbprefix . &#8220;customer_history hist<\/p>\n<p>       where descr.language_id=$lang_id<br \/>\n       and descr.name like &#8216;%\\%&#8217;<br \/>\n       and hist.comment like descr.name<br \/>\n       and hist.customer_id=cust.customer_id<br \/>\n       order by hist.date_added desc<br \/>\n       limit 1<\/p>\n<p>       ) hist_comment<br \/>\n       ,<\/p>\n<p>       (<br \/>\n       SELECT <\/p>\n<p>       descr.customer_group_id<\/p>\n<p>       FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; . $dbprefix . &#8220;customer_history hist<\/p>\n<p>       where descr.language_id=$lang_id<br \/>\n       and descr.name like &#8216;%\\%&#8217;<br \/>\n       and hist.comment like descr.name<br \/>\n       and hist.customer_id=cust.customer_id<br \/>\n       order by hist.date_added desc<br \/>\n       limit 1<\/p>\n<p>       ) new_customer_group<\/p>\n<p>       from &#8221; . $dbprefix . &#8220;customer cust<\/p>\n<p>       where <\/p>\n<p>       cust.customer_group_id&gt;$min_customer_group<\/p>\n<p>       and<\/p>\n<p>       (<br \/>\n       SELECT <\/p>\n<p>       hist.comment<\/p>\n<p>       FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; . $dbprefix . &#8220;customer_history hist<\/p>\n<p>       where descr.language_id=$lang_id<br \/>\n       and descr.name like &#8216;%\\%&#8217;<br \/>\n       and hist.comment like descr.name<br \/>\n       and hist.customer_id=cust.customer_id<br \/>\n       order by hist.date_added desc<br \/>\n       limit 1<\/p>\n<p>       ) is not null<\/p>\n<p>       &#8220;;\t<\/p>\n<p>\t$data = mysqli_query($link, $query) or die(mysqli_error($link));<\/p>\n<p>\t\/\/\u039b\u0399\u03a3\u03a4\u0391 \u0395\u0399\u0394\u03a9\u039d<br \/>\n\twhile ($alldata = mysqli_fetch_array($data))<br \/>\n\t{<\/p>\n<p>\t\t$typedata = explode(&#8216;,&#8217;, $alldata[&#8216;hist_comment&#8217;]);<br \/>\n\t\t$manuf_ids = explode(&#8216;,&#8217;, $alldata[&#8216;manufacturers_ids&#8217;]);<\/p>\n<p>\t\t$new_customer_group_name=$alldata[customer_id].&#8217;_&#8217;.$typedata[0];<\/p>\n<p>\t\t\/\/\u0394\u0397\u039c\u0399\u039f\u03a5\u03a1\u0393\u0399\u0391 \u03a3\u03a5\u039d\u0394\u03a5\u0391\u03a3\u039c\u03a9\u039d<br \/>\n\t\t$newtype=&#8221;;<\/p>\n<p>\t\tforeach ($manuf_ids as $manuf_id){ <\/p>\n<p>\t\t\t$exmanu = explode(&#8216;|&#8217;, $manuf_id);<br \/>\n\t\t\t\/\/echo  $exmanu[0].&#8217;@@@@@@&#8217;.$exmanu[1].&#8217;##&lt;br&gt;&#8217;;<\/p>\n<p>\t\t\tforeach ($typedata as $typed){<br \/>\n\t\t\t\t$groupdata = explode(&#8216; &#8216;, $typed);<br \/>\n\t\t\t\t$percent = str_ireplace(&#8216;%&#8217;, &#8221;, $groupdata[count($groupdata) &#8211; 1]);\t<\/p>\n<p>\t\t\t\t$newname =trim(str_ireplace($percent.&#8217;%&#8217;, &#8221;, $typed));\t<\/p>\n<p>\t\t\t\t\/\/echo &#8216;#######&#8217;.$newname.&#8217;@@@@@@&#8217;;<br \/>\n\t\t\t\tif ($newname==$exmanu[1]) {<\/p>\n<p>\t\t\t\t\t$newtype=$newtype.trim($exmanu[0]).&#8217;|&#8217;.trim($percent).&#8217;,&#8217;;<br \/>\n\t\t\t\t\tbreak;<br \/>\n\t\t\t\t}<\/p>\n<p>\t\t\t}<\/p>\n<p>\t\t}<\/p>\n<p>\t\t\/\/\u0395\u039b\u0395\u0393\u03a7\u039f\u03a3 \u0393\u0399\u0391 \u03a4\u039f \u0391\u039d \u03a5\u03a0\u0391\u03a1\u03a7\u0395\u0399 \u0397 \u039f\u039c\u0391\u0394\u0391 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<br \/>\n\t\t$result = mysqli_query($link,<br \/>\n\t\t&#8220;SELECT customer_group_id FROM &#8221; . $dbprefix . &#8220;customer_group_description where name=&#8217;$new_customer_group_name&#8217; and language_id=$lang_id&#8221;<br \/>\n\t\t) or die(mysqli_error($link));<\/p>\n<p>\t\t$count = mysqli_fetch_assoc($result) [&#8216;customer_group_id&#8217;];<\/p>\n<p>\t\tif (!$count)\t{<\/p>\n<p>\t\t\t\/\/\u0394\u0397\u039c\u0399\u039f\u03a5\u03a1\u0393\u0399\u0391 \u039d\u0395\u0391\u03a3 \u039f\u039c\u0391\u0394\u0391\u03a3 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<br \/>\n\t\t\t$result = mysqli_query($link,&#8221;INSERT INTO &#8221; . $dbprefix . &#8220;customer_group ( approval, sort_order) VALUES (1, 0)&#8221;) or die(mysqli_error($link));<br \/>\n\t\t\t$last_id = $link-&gt;insert_id;<br \/>\n\t\t\t$result = mysqli_query($link,&#8221;INSERT INTO &#8221; . $dbprefix . &#8220;customer_group_description (customer_group_id, language_id, name, description)<br \/>\n\t\t\t\t\t\t\tVALUES ($last_id, $lang_id, &#8216;$new_customer_group_name&#8217;, &#8216;$newtype&#8217;)&#8221;) or die(mysqli_error($link));\t\t\t <\/p>\n<p>\t\t\t\/\/ \u0395\u039d\u0397\u039c\u0395\u03a1\u03a9\u03a3\u0397 \u039f\u039c\u0391\u0394\u0391\u03a3 \u03a3\u0395 \u03a0\u0395\u039b\u0391\u03a4\u0397<br \/>\n\t\t\t$result = mysqli_query($link,&#8221;update &#8221; . $dbprefix . &#8220;customer set customer_group_id=$last_id where customer_id=$alldata[customer_id]&#8221;) or die(mysqli_error($link));\t\t\t <\/p>\n<p>\t\t\t\/\/ \u0395\u039d\u0395\u03a1\u0393\u039f\u03a0\u039f\u0399\u0397\u03a3\u0397 \u03a6\u03a0\u0391<br \/>\n\t\t\t$data2 = mysqli_query($link, &#8220;SELECT tax_rate_id FROM &#8221; . $dbprefix . &#8220;tax_rate&#8221;) or die(mysqli_error($link));<br \/>\n\t\t\twhile ($alldata2 = mysqli_fetch_array($data2))<br \/>\n\t\t\t{<br \/>\n\t\t\t\t$result = mysqli_query($link,&#8221;<br \/>\n\t\t\t\tINSERT INTO &#8221; . $dbprefix . &#8220;tax_rate_to_customer_group (tax_rate_id, customer_group_id) VALUES (&#8220;.$alldata2[&#8216;tax_rate_id&#8217;].&#8221;, $last_id)<br \/>\n\t\t\t\t&#8220;) or die(mysqli_error($link));\t\t\t <\/p>\n<p>\t\t\t}<\/p>\n<p>\t\t} else {<\/p>\n<p>\t\t\t$result = mysqli_query($link,&#8221;update &#8221; . $dbprefix . &#8220;customer_group_description set description=&#8217;$newtype&#8217; where customer_group_id=$count&#8221;) or die(mysqli_error($link));\t<\/p>\n<p>\t\t\t\/\/ \u0395\u039d\u0397\u039c\u0395\u03a1\u03a9\u03a3\u0397 \u039f\u039c\u0391\u0394\u0391\u03a3 \u03a3\u0395 \u03a0\u0395\u039b\u0391\u03a4\u0397<br \/>\n\t\t\t$result = mysqli_query($link,&#8221;update &#8221; . $dbprefix . &#8220;customer set customer_group_id=$count where customer_id=$alldata[customer_id]&#8221;) or die(mysqli_error($link));\t\t\t <\/p>\n<p>\t\t}<\/p>\n<p>\t\tif ($debug) {<br \/>\n\t\t\techo $alldata[customer_id].&#8217;#&#8217;.$alldata[customer_group_id].&#8217;#&#8217;.$alldata[manufacturers_ids].&#8217;#&#8217;.$alldata[manufacturers_names].&#8217;#&#8217;.$alldata[hist_comment].&#8217;#&#8217;.$alldata[new_customer_group].&#8217; &gt;&gt; &#8216;.$newtype.&#8217;#&lt;br&gt;&#8217;;<br \/>\n\t\t}<br \/>\n\t}<\/p>\n<p>\t\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\t\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\t\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\t\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<br \/>\n\t\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n<p>\t$newspecial=0;<br \/>\n\t$modifiedspecial=0;<br \/>\n\t$deletedspecial=0;<\/p>\n<p>\t$data = mysqli_query($link, &#8221;<\/p>\n<p>\tSELECT tra.rate as rate_value,<br \/>\n\tpro.product_id, pro.price, pro.upc, pro.manufacturer_id FROM &#8221; . $dbprefix . &#8220;product pro<\/p>\n<p>\tleft join &#8221; . $dbprefix . &#8220;tax_rule as tru<br \/>\n        on tru.tax_class_id=pro.tax_class_id<\/p>\n<p>\tleft join &#8221; . $dbprefix . &#8220;tax_rate as tra<br \/>\n\ton tra.tax_rate_id=tru.tax_rate_id<\/p>\n<p>\t&#8220;) or die(mysqli_error($link));<\/p>\n<p>\t\/\/\u039b\u0399\u03a3\u03a4\u0391 \u0395\u0399\u0394\u03a9\u039d<br \/>\n\twhile ($alldata = mysqli_fetch_array($data))<br \/>\n\t{<\/p>\n<p>\t\t$productid = $alldata[&#8216;product_id&#8217;];<br \/>\n\t\t$price = $alldata[&#8216;price&#8217;];<br \/>\n\t\t$purchaseprice = $alldata[&#8216;upc&#8217;];<br \/>\n\t\t$manufacturer_id = $alldata[&#8216;manufacturer_id&#8217;];<br \/>\n\t\t$taxrate = $alldata[&#8216;rate_value&#8217;];<\/p>\n<p>\t\t$data2 = mysqli_query($link, &#8221;<\/p>\n<p>\t\tSELECT * FROM &#8221; . $dbprefix . &#8220;customer_group_description<br \/>\n\t\twhere language_id=$lang_id<br \/>\n\t\tand name like &#8216;%\\%&#8217;<\/p>\n<p>\t\t&#8220;) or die(mysqli_error($link));<\/p>\n<p>\t\t\/\/\u039b\u0399\u03a3\u03a4\u0391 \u039a\u0391\u03a4\u0397\u0393\u039f\u03a1\u0399\u03a9\u039d \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<br \/>\n\t\twhile ($alldata2 = mysqli_fetch_array($data2))<br \/>\n \t\t{<br \/>\n\t\t\t$groupdata = explode(&#8216; &#8216;, $alldata2[&#8216;name&#8217;]);<br \/>\n\t\t\t$percent = str_ireplace(&#8216;%&#8217;, &#8221;, $groupdata[count($groupdata) &#8211; 1]);<br \/>\n\t\t\t$groupname = $alldata2[&#8216;name&#8217;];<br \/>\n\t\t\t$groupid = $alldata2[&#8216;customer_group_id&#8217;];<br \/>\n \t\t\t$description = $alldata2[&#8216;description&#8217;];<\/p>\n<p>\t\t\t\/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u039f\u03a3\u039f\u03a3\u03a4\u039f\u03a5 \u0392\u0391\u03a3\u0395\u0399 \u039a\u0391\u03a4\u0391\u03a3\u039a\u0395\u03a5\u0391\u03a3\u03a4\u0397<br \/>\n\t\t\tif ($description) {<br \/>\n\t\t\t\t$perclines = explode(&#8216;,&#8217;, $description);<br \/>\n\t\t\t\tforeach ($perclines as $percline){<br \/>\n\t\t\t\t\t$selline = explode(&#8216;|&#8217;, $percline);<br \/>\n\t\t\t\t\tif ($selline[0]==$manufacturer_id) {<br \/>\n\t\t\t\t\t\t$percent=$selline[1];<br \/>\n\t\t\t\t\t\tif ($debug) {echo &#8216;********&#8217;;}<br \/>\n \t\t\t\t\t\tbreak;<br \/>\n\t\t\t\t\t}<br \/>\n \t\t\t\t}<br \/>\n \t\t\t}<br \/>\n \t\t\t\/\/<\/p>\n<p>\t\t\tif ($debug) {<br \/>\n\t\t\t\techo $productid . &#8216;#&#8217; . $price . &#8216;#&#8217; . $purchaseprice . &#8216;#&#8217; . $groupname . &#8216;# &#8216; . $percent . &#8216;% #&#8217; . $groupid . &#8216;#&#8217;.$manufacturer_id.&#8217; &gt;&gt; &#8216;.$description.'&lt;br&gt;&#8217;;<br \/>\n\t\t\t}<\/p>\n<p>\t\t\t\/\/*************************************<br \/>\n \t\t\t\/\/\u039f\u03a1\u03a3\u0399\u039c\u039f\u03a3 \u03a4\u0399\u039c\u03a9\u039d \u039a\u0391\u03a4\u0397\u0393\u039f\u03a1\u0399\u03a9\u039d \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<br \/>\n\t\t\t\/\/*************************************<br \/>\n\t\t\t\/\/<br \/>\n\t\t\t\/\/file_put_contents($logfile,&#8217;P&gt;&#8217;.$proid.&#8217;    C&gt;&#8217;.$catex,  FILE_APPEND | LOCK_EX);<\/p>\n<p>\t\t\tif ($purchaseprice &gt; 0)<br \/>\n\t\t\t{<\/p>\n<p>\t\t\t\t$result = mysqli_query($link, &#8221;<br \/>\n\t\t\t\tSELECT COUNT(*) FROM &#8221; . $dbprefix . &#8220;product_special<br \/>\n\t\t\t\tWHERE product_id=$productid and customer_group_id=$groupid<br \/>\n\t\t\t\t&#8220;);<br \/>\n\t\t\t\t$count = mysqli_fetch_assoc($result) [&#8216;COUNT(*)&#8217;];<\/p>\n<p>\t\t\t\t$price = $purchaseprice + (($percent * $purchaseprice) \/ 100);<\/p>\n<p>\t\t\t\t\/\/$price= $price + (($taxrate * $price) \/ 100);<\/p>\n<p>\t\t\t\tif ($count &gt; 0)<br \/>\n\t\t\t\t{<\/p>\n<p>\t\t\t\t\t$data3 = mysqli_query($link, &#8221;<br \/>\n\t\t\tUPDATE &#8221; . $dbprefix . &#8220;product_special SET price=$price WHERE product_id=$productid and customer_group_id=$groupid<br \/>\n\t\t\t&#8220;) or die(mysqli_error($link));<\/p>\n<p>\t\t\t\t\t\/\/ echo &#8220;UPDATE &#8220;.$dbprefix.&#8221;product_special SET price=$price WHERE product_id=$productid and customer_group_id=$groupid&lt;br&gt;&#8221;;<br \/>\n\t\t\t\t\t\/\/echo mysqli_affected_rows($link).'&lt;br&gt;&#8217;;<br \/>\n\t\t\t\t\tif (mysqli_affected_rows($link) &gt; 0) {<br \/>\n\t\t\t\t\t\t$modifiedspecial++;<br \/>\n\t\t\t\t\t}<br \/>\n\t\t\t\t}<br \/>\n\t\t\t\telse<br \/>\n\t\t\t\t{<\/p>\n<p>\t\t\t\t\t$data3 = mysqli_query($link, &#8221;<br \/>\n\t\t\tINSERT INTO &#8221; . $dbprefix . &#8220;product_special (product_id, customer_group_id, price,date_start,date_end) VALUES ($productid, $groupid, $price,&#8217;2000-1-1&#8242;,&#8217;2100-1-1&#8242;)<br \/>\n\t\t\t&#8220;) or die(mysqli_error($link));<\/p>\n<p>\t\t\t\t\t\/\/\techo &#8220;INSERT INTO &#8220;.$dbprefix.&#8221;product_special (product_id, customer_group_id, price,date_start,date_end) VALUES ($productid, $groupid, $price,&#8217;2000-1-1&#8242;,&#8217;2100-1-1&#8242;)&lt;br&gt;&#8221;;<br \/>\n\t\t\t\t\t\/\/echo mysqli_affected_rows($link).'&lt;br&gt;&#8217;;<br \/>\n\t\t\t\t\tif (mysqli_affected_rows($link) &gt; 0) {<br \/>\n\t\t\t\t\t\t$newspecial++;<br \/>\n\t\t\t\t\t}<br \/>\n\t\t\t\t}<\/p>\n<p>\t\t\t}<br \/>\n\t\t\telse<br \/>\n\t\t\t{<\/p>\n<p>\t\t\t\t\/\/\u0394\u0399\u0391\u0393\u03a1\u0391\u03a6\u0397<br \/>\n\t\t\t\t$data3 = mysqli_query($link, &#8221;<br \/>\n\t\t\tdelete from &#8221; . $dbprefix . &#8220;product_special WHERE product_id=$productid and customer_group_id=$groupid<br \/>\n\t\t\t&#8220;) or die(mysqli_error($link));<\/p>\n<p>\t\t\t\t\/\/echo mysqli_affected_rows($link).'&lt;br&gt;&#8217;;<br \/>\n\t\t\t\tif (mysqli_affected_rows($link) &gt; 0) {<br \/>\n\t\t\t\t\t$deletedspecial++;<br \/>\n\t\t\t\t}<br \/>\n\t\t\t}<\/p>\n<p>\t\t\t\/\/<br \/>\n\t\t\t\/\/*************************************<br \/>\n\t\t\t\/\/*************************************<\/p>\n<p>\t\t}<\/p>\n<p>\t\t\/\/$prodopvid = $alldata[&#8216;product_option_value_id&#8217;];<\/p>\n<p>\t}<\/p>\n<p>\t\/\/file_put_contents($logfile,&#8221;upload ok\\n&#8221;, FILE_APPEND | LOCK_EX);<br \/>\n\tmysqli_close($link);<br \/>\n\techo &#8216;New: &#8216;.$newspecial.'&lt;br&gt;&#8217;;<br \/>\n\techo &#8216;Modified: &#8216;.$modifiedspecial.'&lt;br&gt;&#8217;;<br \/>\n\techo &#8216;Deleted: &#8216;.$deletedspecial.'&lt;br&gt;&#8217;;<\/p>\n<p>}<\/textarea><\/div>\n<div class=\"urvanov-syntax-highlighter-main\" style=\"\">\n<table class=\"crayon-table\">\n<tr class=\"urvanov-syntax-highlighter-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-1\">1<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-3\">3<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-4\">4<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-5\">5<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-6\">6<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-7\">7<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-8\">8<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-9\">9<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-10\">10<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-11\">11<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-12\">12<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-13\">13<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-14\">14<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-15\">15<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-16\">16<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-17\">17<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-18\">18<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-19\">19<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-20\">20<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-21\">21<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-22\">22<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-23\">23<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-24\">24<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-25\">25<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-26\">26<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-27\">27<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-28\">28<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-29\">29<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-30\">30<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-31\">31<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-32\">32<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-33\">33<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-34\">34<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-35\">35<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-36\">36<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-37\">37<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-38\">38<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-39\">39<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-40\">40<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-41\">41<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-42\">42<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-43\">43<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-44\">44<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-45\">45<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-46\">46<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-47\">47<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-48\">48<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-49\">49<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-50\">50<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-51\">51<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-52\">52<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-53\">53<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-54\">54<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-55\">55<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-56\">56<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-57\">57<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-58\">58<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-59\">59<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-60\">60<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-61\">61<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-62\">62<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-63\">63<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-64\">64<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-65\">65<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-66\">66<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-67\">67<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-68\">68<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-69\">69<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-70\">70<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-71\">71<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-72\">72<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-73\">73<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-74\">74<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-75\">75<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-76\">76<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-77\">77<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-78\">78<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-79\">79<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-80\">80<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-81\">81<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-82\">82<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-83\">83<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-84\">84<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-85\">85<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-86\">86<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-87\">87<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-88\">88<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-89\">89<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-90\">90<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-91\">91<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-92\">92<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-93\">93<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-94\">94<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-95\">95<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-96\">96<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-97\">97<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-98\">98<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-99\">99<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-100\">100<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-101\">101<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-102\">102<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-103\">103<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-104\">104<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-105\">105<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-106\">106<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-107\">107<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-108\">108<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-109\">109<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-110\">110<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-111\">111<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-112\">112<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-113\">113<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-114\">114<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-115\">115<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-116\">116<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-117\">117<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-118\">118<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-119\">119<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-120\">120<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-121\">121<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-122\">122<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-123\">123<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-124\">124<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-125\">125<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-126\">126<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-127\">127<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-128\">128<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-129\">129<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-130\">130<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-131\">131<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-132\">132<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-133\">133<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-134\">134<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-135\">135<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-136\">136<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-137\">137<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-138\">138<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-139\">139<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-140\">140<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-141\">141<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-142\">142<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-143\">143<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-144\">144<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-145\">145<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-146\">146<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-147\">147<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-148\">148<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-149\">149<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-150\">150<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-151\">151<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-152\">152<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-153\">153<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-154\">154<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-155\">155<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-156\">156<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-157\">157<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-158\">158<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-159\">159<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-160\">160<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-161\">161<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-162\">162<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-163\">163<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-164\">164<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-165\">165<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-166\">166<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-167\">167<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-168\">168<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-169\">169<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-170\">170<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-171\">171<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-172\">172<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-173\">173<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-174\">174<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-175\">175<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-176\">176<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-177\">177<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-178\">178<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-179\">179<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-180\">180<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-181\">181<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-182\">182<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-183\">183<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-184\">184<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-185\">185<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-186\">186<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-187\">187<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-188\">188<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-189\">189<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-190\">190<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-191\">191<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-192\">192<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-193\">193<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-194\">194<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-195\">195<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-196\">196<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-197\">197<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-198\">198<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-199\">199<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-200\">200<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-201\">201<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-202\">202<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-203\">203<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-204\">204<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-205\">205<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-206\">206<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-207\">207<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-208\">208<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-209\">209<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-210\">210<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-211\">211<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-212\">212<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-213\">213<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-214\">214<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-215\">215<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-216\">216<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-217\">217<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-218\">218<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-219\">219<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-220\">220<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-221\">221<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-222\">222<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-223\">223<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-224\">224<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-225\">225<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-226\">226<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-227\">227<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-228\">228<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-229\">229<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-230\">230<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-231\">231<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-232\">232<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-233\">233<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-234\">234<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-235\">235<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-236\">236<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-237\">237<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-238\">238<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-239\">239<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-240\">240<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-241\">241<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-242\">242<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-243\">243<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-244\">244<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-245\">245<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-246\">246<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-247\">247<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-248\">248<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-249\">249<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-250\">250<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-251\">251<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-252\">252<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-253\">253<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-254\">254<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-255\">255<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-256\">256<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-257\">257<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-258\">258<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-259\">259<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-260\">260<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-261\">261<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-262\">262<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-263\">263<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-264\">264<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-265\">265<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-266\">266<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-267\">267<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-268\">268<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-269\">269<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-270\">270<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-271\">271<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-272\">272<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-273\">273<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-274\">274<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-275\">275<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-276\">276<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-277\">277<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-278\">278<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-279\">279<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-280\">280<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-281\">281<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-282\">282<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-283\">283<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-284\">284<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-285\">285<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-286\">286<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-287\">287<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-288\">288<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-289\">289<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-290\">290<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-291\">291<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-292\">292<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-293\">293<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-294\">294<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-295\">295<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-296\">296<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-297\">297<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-298\">298<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-299\">299<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-300\">300<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-301\">301<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-302\">302<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-303\">303<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-304\">304<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-305\">305<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-306\">306<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-307\">307<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-308\">308<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-309\">309<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-310\">310<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-311\">311<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-312\">312<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-313\">313<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-314\">314<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-315\">315<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-316\">316<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-317\">317<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-318\">318<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-319\">319<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-320\">320<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-321\">321<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-322\">322<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-323\">323<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-324\">324<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-325\">325<\/div>\n<div class=\"crayon-num crayon-striped-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-326\">326<\/div>\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d69107834857-327\">327<\/div>\n<\/div>\n<\/td>\n<td class=\"urvanov-syntax-highlighter-code\">\n<div class=\"crayon-pre\" style=\"font-size: 12px !important; line-height: 15px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;\">\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-1\"><span class=\"crayon-c\">\/\/ \u03a5\u03a0\u039f\u039b\u039f\u0393\u0399\u03a3\u039c\u039f\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-2\"><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$action<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">==<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;calc_discounts&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-3\"><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-4\"><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-5\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$debug<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-6\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-7\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d \u039c\u0395 \u0395\u0399\u0394\u0399\u039a\u0395\u03a3 \u03a3\u03a5\u039d\u0398\u0397\u039a\u0395\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-8\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$query<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8221;\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-9\"><span class=\"crayon-s\">\tselect <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-10\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-11\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cust.customer_id,<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-12\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cust.customer_group_id,<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-13\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-14\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-15\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-16\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-17\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-18\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (select GROUP_CONCAT( concat( manuf.manufacturer_id,&#8217;|&#8217;,manuf.name)&nbsp;&nbsp;) from &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;manufacturer manuf&nbsp;&nbsp;where&nbsp;&nbsp;hist.comment like concat(&#8216;%,&#8217;,manuf.name,&#8217;%&#8217;)&nbsp;&nbsp; )<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-19\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-20\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description descr,&#8221;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_history hist<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-21\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-22\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where descr.language_id=$lang_id<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-23\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and descr.name like &#8216;%\\%&#8217;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-24\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.comment like descr.name&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-25\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.customer_id=cust.customer_id&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-26\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by hist.date_added desc<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-27\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; limit 1<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-28\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-29\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) manufacturers_ids<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-30\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-31\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-32\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-33\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-34\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-35\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-36\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hist.comment<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-37\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-38\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description descr,&#8221;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_history hist<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-39\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-40\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where descr.language_id=$lang_id<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-41\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and descr.name like &#8216;%\\%&#8217;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-42\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.comment like descr.name&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-43\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.customer_id=cust.customer_id&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-44\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by hist.date_added desc<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-45\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; limit 1<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-46\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-47\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) hist_comment<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-48\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-49\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-50\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-51\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-52\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-53\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; descr.customer_group_id<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-54\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-55\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description descr,&#8221;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_history hist<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-56\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-57\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where descr.language_id=$lang_id<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-58\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and descr.name like &#8216;%\\%&#8217;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-59\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.comment like descr.name&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-60\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.customer_id=cust.customer_id&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-61\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by hist.date_added desc<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-62\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; limit 1<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-63\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-64\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) new_customer_group<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-65\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-66\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer cust<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-67\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-68\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-69\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-70\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cust.customer_group_id&gt;$min_customer_group<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-71\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-72\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-73\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-74\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-75\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-76\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-77\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hist.comment<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-78\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-79\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description descr,&#8221;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_history hist<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-80\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-81\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where descr.language_id=$lang_id<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-82\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and descr.name like &#8216;%\\%&#8217;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-83\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.comment like descr.name&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-84\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and hist.customer_id=cust.customer_id&nbsp;&nbsp;&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-85\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by hist.date_added desc<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-86\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; limit 1<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-87\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-88\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) is not null<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-89\"><span class=\"crayon-s\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-90\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8220;<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-91\"><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-92\"><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-93\"><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-94\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$data<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$query<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-95\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-96\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\u039b\u0399\u03a3\u03a4\u0391 \u0395\u0399\u0394\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-97\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-st\">while<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_fetch_array<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$data<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-98\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-99\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-100\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$typedata<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;,&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;hist_comment&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-101\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$manuf_ids<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;,&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;manufacturers_ids&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-102\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-103\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$new_customer_group_name<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">customer_id<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;_&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$typedata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-104\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-105\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-c\">\/\/\u0394\u0397\u039c\u0399\u039f\u03a5\u03a1\u0393\u0399\u0391 \u03a3\u03a5\u039d\u0394\u03a5\u0391\u03a3\u039c\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-106\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$newtype<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-s\">&#8221;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-107\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-108\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-st\">foreach<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$manuf_ids<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">as<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$manuf_id<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-h\"> <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-109\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-110\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$exmanu<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;|&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$manuf_id<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-111\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/echo&nbsp;&nbsp;$exmanu[0].&#8217;@@@@@@&#8217;.$exmanu[1].&#8217;##&lt;br&gt;&#8217;;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-112\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-113\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-st\">foreach<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$typedata<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">as<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$typed<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-h\"> <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-114\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$groupdata<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216; &#8216;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$typed<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-115\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">str_ireplace<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;%&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8221;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$groupdata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-e\">count<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$groupdata<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-116\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-117\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$newname<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-e\">trim<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">str_ireplace<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;%&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8221;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$typed<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-118\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-119\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-c\">\/\/echo &#8216;#######&#8217;.$newname.&#8217;@@@@@@&#8217;;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-120\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$newname<\/span><span class=\"crayon-o\">==<\/span><span class=\"crayon-v\">$exmanu<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-121\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-122\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-v\">$newtype<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">$newtype<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">trim<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$exmanu<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;|&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-e\">trim<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;,&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-123\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-st\">break<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-124\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-125\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-126\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-127\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-128\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-129\"><span class=\"crayon-h\">\t\t \t\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-130\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-c\">\/\/\u0395\u039b\u0395\u0393\u03a7\u039f\u03a3 \u0393\u0399\u0391 \u03a4\u039f \u0391\u039d \u03a5\u03a0\u0391\u03a1\u03a7\u0395\u0399 \u0397 \u039f\u039c\u0391\u0394\u0391 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-131\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-132\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-s\">&#8220;SELECT customer_group_id FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description where name=&#8217;$new_customer_group_name&#8217; and language_id=$lang_id&#8221;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-133\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-134\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-135\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$count<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_fetch_assoc<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;customer_group_id&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-136\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-137\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-o\">!<\/span><span class=\"crayon-v\">$count<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\">\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-138\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-139\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/\u0394\u0397\u039c\u0399\u039f\u03a5\u03a1\u0393\u0399\u0391 \u039d\u0395\u0391\u03a3 \u039f\u039c\u0391\u0394\u0391\u03a3 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-140\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8220;INSERT INTO &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group ( approval, sort_order) VALUES (1, 0)&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t\t\t <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-141\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$last_id<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-o\">-&gt;<\/span><span class=\"crayon-i\">insert_id<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-142\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8220;INSERT INTO &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description (customer_group_id, language_id, name, description) <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-143\"><span class=\"crayon-s\">\t\t\t\t\t\t\tVALUES ($last_id, $lang_id, &#8216;$new_customer_group_name&#8217;, &#8216;$newtype&#8217;)&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t\t\t <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-144\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-145\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/ \u0395\u039d\u0397\u039c\u0395\u03a1\u03a9\u03a3\u0397 \u039f\u039c\u0391\u0394\u0391\u03a3 \u03a3\u0395 \u03a0\u0395\u039b\u0391\u03a4\u0397<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-146\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8220;update &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer set customer_group_id=$last_id where customer_id=$alldata[customer_id]&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t\t\t <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-147\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-148\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/ \u0395\u039d\u0395\u03a1\u0393\u039f\u03a0\u039f\u0399\u0397\u03a3\u0397 \u03a6\u03a0\u0391\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-149\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$data2<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;SELECT tax_rate_id FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;tax_rate&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-150\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-st\">while<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_fetch_array<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$data2<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-151\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-152\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-153\"><span class=\"crayon-s\">\t\t\t\tINSERT INTO &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;tax_rate_to_customer_group (tax_rate_id, customer_group_id) VALUES (&#8220;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;tax_rate_id&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8220;, $last_id)<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-154\"><span class=\"crayon-s\">\t\t\t\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t\t\t <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-155\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-156\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-157\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-158\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-159\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-160\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-sy\">}<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">else<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-161\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-162\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8220;update &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description set description=&#8217;$newtype&#8217; where customer_group_id=$count&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-163\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-164\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/ \u0395\u039d\u0397\u039c\u0395\u03a1\u03a9\u03a3\u0397 \u039f\u039c\u0391\u0394\u0391\u03a3 \u03a3\u0395 \u03a0\u0395\u039b\u0391\u03a4\u0397<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-165\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8220;update &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer set customer_group_id=$count where customer_id=$alldata[customer_id]&#8221;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">\t\t\t <\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-166\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-167\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-168\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-169\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-170\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-171\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$debug<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-172\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-k \">echo<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">customer_id<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">customer_group_id<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">manufacturers_ids<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">manufacturers_names<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">hist_comment<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">new_customer_group<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216; &gt;&gt; &#8216;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$newtype<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;#&lt;br&gt;&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-173\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-174\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-175\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-176\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-177\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-178\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-179\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-180\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-181\"><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-182\"><span class=\"crayon-h\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-183\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$newspecial<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-184\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$modifiedspecial<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-185\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$deletedspecial<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-186\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-187\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-v\">$data<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-188\"><span class=\"crayon-s\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-189\"><span class=\"crayon-s\">\tSELECT tra.rate as rate_value,<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-190\"><span class=\"crayon-s\">\tpro.product_id, pro.price, pro.upc, pro.manufacturer_id FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;product pro<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-191\"><span class=\"crayon-s\">\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-192\"><span class=\"crayon-s\">\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-193\"><span class=\"crayon-s\">\tleft join &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;tax_rule as tru<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-194\"><span class=\"crayon-s\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;on tru.tax_class_id=pro.tax_class_id<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-195\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-196\"><span class=\"crayon-s\">\tleft join &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;tax_rate as tra<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-197\"><span class=\"crayon-s\">\ton tra.tax_rate_id=tru.tax_rate_id<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-198\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-199\"><span class=\"crayon-s\">\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-200\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-201\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/\u039b\u0399\u03a3\u03a4\u0391 \u0395\u0399\u0394\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-202\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-st\">while<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_fetch_array<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$data<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-203\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-204\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-205\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$productid<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;product_id&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-206\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$price<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;price&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-207\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$purchaseprice<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;upc&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-208\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$manufacturer_id<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;manufacturer_id&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-209\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$taxrate<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;rate_value&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-210\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-211\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-212\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-v\">$data2<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-213\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-214\"><span class=\"crayon-s\">\t\tSELECT * FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;customer_group_description<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-215\"><span class=\"crayon-s\">\t\twhere language_id=$lang_id<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-216\"><span class=\"crayon-s\">\t\tand name like &#8216;%\\%&#8217;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-217\"><span class=\"crayon-s\">\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-218\"><span class=\"crayon-s\">\t\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-219\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-220\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-c\">\/\/\u039b\u0399\u03a3\u03a4\u0391 \u039a\u0391\u03a4\u0397\u0393\u039f\u03a1\u0399\u03a9\u039d \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-221\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-st\">while<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_fetch_array<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$data2<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-222\"><span class=\"crayon-h\"> \t\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-223\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$groupdata<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216; &#8216;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;name&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-224\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">str_ireplace<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;%&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8221;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$groupdata<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-e\">count<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$groupdata<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-225\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$groupname<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;name&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-226\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-v\">$groupid<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;customer_group_id&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-227\"><span class=\"crayon-h\"> \t\t\t<\/span><span class=\"crayon-v\">$description<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$alldata2<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;description&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-228\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-229\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u039f\u03a3\u039f\u03a3\u03a4\u039f\u03a5 \u0392\u0391\u03a3\u0395\u0399 \u039a\u0391\u03a4\u0391\u03a3\u039a\u0395\u03a5\u0391\u03a3\u03a4\u0397<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-230\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$description<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-231\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$perclines<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;,&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$description<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-232\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-st\">foreach<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$perclines<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">as<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$percline<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-h\"> <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-233\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-v\">$selline<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">explode<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;|&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$percline<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-234\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$selline<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-o\">==<\/span><span class=\"crayon-v\">$manufacturer_id<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-235\"><span class=\"crayon-h\">\t\t\t\t\t\t<\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-v\">$selline<\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-cn\">1<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-236\"><span class=\"crayon-h\">\t\t\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$debug<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><span class=\"crayon-k \">echo<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;********&#8217;<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-237\"><span class=\"crayon-h\"> \t\t\t\t\t\t<\/span><span class=\"crayon-st\">break<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-238\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-239\"><span class=\"crayon-h\"> \t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><span class=\"crayon-h\"> \t\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-240\"><span class=\"crayon-h\"> \t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-241\"><span class=\"crayon-h\"> \t\t\t<\/span><span class=\"crayon-c\">\/\/<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-242\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-243\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$debug<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-244\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-k \">echo<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$productid<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$price<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$purchaseprice<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$groupname<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;# &#8216;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;% #&#8217;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$groupid<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;#&#8217;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$manufacturer_id<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216; &gt;&gt; &#8216;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$description<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;&lt;br&gt;&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-245\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-246\"><span class=\"crayon-h\"> <\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-247\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/*************************************<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-248\"><span class=\"crayon-h\"> \t\t\t<\/span><span class=\"crayon-c\">\/\/\u039f\u03a1\u03a3\u0399\u039c\u039f\u03a3 \u03a4\u0399\u039c\u03a9\u039d \u039a\u0391\u03a4\u0397\u0393\u039f\u03a1\u0399\u03a9\u039d \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-249\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/*************************************<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-250\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-251\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/file_put_contents($logfile,&#8217;P&gt;&#8217;.$proid.&#8217;&nbsp;&nbsp;&nbsp;&nbsp;C&gt;&#8217;.$catex,&nbsp;&nbsp;FILE_APPEND | LOCK_EX);<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-252\"><span class=\"crayon-h\">\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-253\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-254\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$purchaseprice<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-255\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-256\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-257\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-258\"><span class=\"crayon-s\">\t\t\t\tSELECT COUNT(*) FROM &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;product_special<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-259\"><span class=\"crayon-s\">\t\t\t\tWHERE product_id=$productid and customer_group_id=$groupid \t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-260\"><span class=\"crayon-s\">\t\t\t\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-261\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$count<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_fetch_assoc<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$result<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">[<\/span><span class=\"crayon-s\">&#8216;COUNT(*)&#8217;<\/span><span class=\"crayon-sy\">]<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-262\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-263\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$price<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$purchaseprice<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">+<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$percent<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">*<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$purchaseprice<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">100<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-264\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-265\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-c\">\/\/$price= $price + (($taxrate * $price) \/ 100);<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-266\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-267\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-268\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-269\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$count<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-270\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-271\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-272\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-v\">$data3<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-273\"><span class=\"crayon-s\">\t\t\tUPDATE &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;product_special SET price=$price WHERE product_id=$productid and customer_group_id=$groupid \t<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-274\"><span class=\"crayon-s\">\t\t\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-275\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-276\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-c\">\/\/ echo &#8220;UPDATE &#8220;.$dbprefix.&#8221;product_special SET price=$price WHERE product_id=$productid and customer_group_id=$groupid&lt;br&gt;&#8221;;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-277\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-c\">\/\/echo mysqli_affected_rows($link).'&lt;br&gt;&#8217;;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-278\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_affected_rows<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-279\"><span class=\"crayon-h\">\t\t\t\t\t\t<\/span><span class=\"crayon-v\">$modifiedspecial<\/span><span class=\"crayon-o\">++<\/span><span class=\"crayon-sy\">;<\/span><span class=\"crayon-h\">&nbsp;&nbsp;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-280\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-281\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-282\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-st\">else<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-283\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-284\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-285\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-v\">$data3<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-286\"><span class=\"crayon-s\">\t\t\tINSERT INTO &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;product_special (product_id, customer_group_id, price,date_start,date_end) VALUES ($productid, $groupid, $price,&#8217;2000-1-1&#8242;,&#8217;2100-1-1&#8242;)<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-287\"><span class=\"crayon-s\">\t\t\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-288\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-289\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-c\">\/\/\techo &#8220;INSERT INTO &#8220;.$dbprefix.&#8221;product_special (product_id, customer_group_id, price,date_start,date_end) VALUES ($productid, $groupid, $price,&#8217;2000-1-1&#8242;,&#8217;2100-1-1&#8242;)&lt;br&gt;&#8221;;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-290\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-c\">\/\/echo mysqli_affected_rows($link).'&lt;br&gt;&#8217;;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-291\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_affected_rows<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-292\"><span class=\"crayon-h\">\t\t\t\t\t\t<\/span><span class=\"crayon-v\">$newspecial<\/span><span class=\"crayon-o\">++<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-293\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-294\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-295\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-296\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-297\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-st\">else<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-298\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-299\">&nbsp;<\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-300\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-c\">\/\/\u0394\u0399\u0391\u0393\u03a1\u0391\u03a6\u0397<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-301\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-v\">$data3<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">=<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-e\">mysqli_query<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-302\"><span class=\"crayon-s\">\t\t\tdelete from &#8220;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">$dbprefix<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8220;product_special WHERE product_id=$productid and customer_group_id=$groupid \t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-303\"><span class=\"crayon-s\">\t\t\t&#8220;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-st\">or<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-k \">die<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_error<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-304\"><span class=\"crayon-h\">\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-305\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-c\">\/\/echo mysqli_affected_rows($link).'&lt;br&gt;&#8217;;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-306\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-st\">if<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-e\">mysqli_affected_rows<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&gt;<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-cn\">0<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-sy\">{<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-307\"><span class=\"crayon-h\">\t\t\t\t\t<\/span><span class=\"crayon-v\">$deletedspecial<\/span><span class=\"crayon-o\">++<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-308\"><span class=\"crayon-h\">\t\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-309\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-310\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-311\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-312\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/*************************************<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-313\"><span class=\"crayon-h\">\t\t\t<\/span><span class=\"crayon-c\">\/\/*************************************<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-314\"><span class=\"crayon-h\">\t\t\t\t\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-315\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-316\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-317\"><span class=\"crayon-h\">\t\t<\/span><span class=\"crayon-c\">\/\/$prodopvid = $alldata[&#8216;product_option_value_id&#8217;];<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-318\"><span class=\"crayon-h\">\t\t<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-319\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-sy\">}<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-320\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-321\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-c\">\/\/file_put_contents($logfile,&#8221;upload ok\\n&#8221;, FILE_APPEND | LOCK_EX);<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-322\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-e\">mysqli_close<\/span><span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">$link<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-323\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-k \">echo<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;New: &#8216;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$newspecial<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;&lt;br&gt;&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-324\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-k \">echo<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;Modified: &#8216;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$modifiedspecial<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;&lt;br&gt;&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-325\"><span class=\"crayon-h\">\t<\/span><span class=\"crayon-k \">echo<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-s\">&#8216;Deleted: &#8216;<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-v\">$deletedspecial<\/span><span class=\"crayon-sy\">.<\/span><span class=\"crayon-s\">&#8216;&lt;br&gt;&#8217;<\/span><span class=\"crayon-sy\">;<\/span><\/div>\n<div class=\"crayon-line crayon-striped-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-326\">&nbsp;<\/div>\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d69107834857-327\"><span class=\"crayon-sy\">}<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/table><\/div>\n<\/p><\/div>\n<p><!-- [Format Time: 0.0098 seconds] --><\/p>\n<p>\u03a1\u03c5\u03b8\u03bc\u03af\u03b6\u03bf\u03c5\u03bc\u03b5 \u03c3\u03c4\u03bf server \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03af\u03c4\u03b1\u03b9 \u03ba\u03ac\u03b8\u03b5 10 \u03bb\u03b5\u03c0\u03c4\u03ac<\/p>\n<p><!-- Urvanov Syntax Highlighter v2.9.1 --><\/p>\n<div id=\"urvanov-syntax-highlighter-6a2a791212d71821436151\" class=\"urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-monaco urvanov-syntax-highlighter-os-pc print-yes notranslate\" data-settings=\" no-popup minimize scroll-mouseover disable-anim wrap\" style=\" margin-top: 12px; margin-bottom: 12px; font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-toolbar\" data-settings=\" show\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\"><span class=\"crayon-title\"><\/span><\/p>\n<div class=\"crayon-tools\" style=\"font-size: 12px !important;height: 18px !important; line-height: 18px !important;\">\n<div class=\"crayon-button urvanov-syntax-highlighter-nums-button\" title=\"Toggle Line Numbers\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-plain-button\" title=\"Toggle Plain Code\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-wrap-button\" title=\"Toggle Line Wrap\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<div class=\"crayon-button urvanov-syntax-highlighter-copy-button\" title=\"Copy\">\n<div class=\"urvanov-syntax-highlighter-button-icon\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"crayon-info\" style=\"min-height: 16.8px !important; line-height: 16.8px !important;\"><\/div>\n<div class=\"urvanov-syntax-highlighter-plain-wrap\"><textarea  class=\"urvanov-syntax-highlighter-plain print-no\" data-settings=\"dblclick\" readonly style=\"-moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4; font-size: 12px !important; line-height: 15px !important;\"><br \/>\n wget -qO \/dev\/null https:\/\/mysite.com\/emdi_open2_bridge.php?action=calc_discounts &gt;\/dev\/null 2&gt;&amp;1<\/textarea><\/div>\n<div class=\"urvanov-syntax-highlighter-main\" style=\"\">\n<table class=\"crayon-table\">\n<tr class=\"urvanov-syntax-highlighter-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"urvanov-syntax-highlighter-nums-content\" style=\"font-size: 12px !important; line-height: 15px !important;\">\n<div class=\"crayon-num\" data-line=\"urvanov-syntax-highlighter-6a2a791212d71821436151-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"urvanov-syntax-highlighter-code\">\n<div class=\"crayon-pre\" style=\"font-size: 12px !important; line-height: 15px !important; -moz-tab-size:4; -o-tab-size:4; -webkit-tab-size:4; tab-size:4;\">\n<div class=\"crayon-line\" id=\"urvanov-syntax-highlighter-6a2a791212d71821436151-1\"><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">wget<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-v\">qO<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-v\">dev<\/span><span class=\"crayon-o\">\/<\/span><span class=\"crayon-t\">null<\/span><span class=\"crayon-h\"> <\/span><span class=\"crayon-v\">https<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-c\">\/\/mysite.com\/emdi_open2_bridge.php?action=calc_discounts &gt;\/dev\/null 2&gt;&amp;1<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/table><\/div>\n<\/p><\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p>&nbsp;<\/p>\n<p>\u03a3\u03c4\u03b7\u03bd \u03bf\u03bc\u03ac\u03b4\u03b1 \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd \u03c0\u03bf\u03c5 \u03b5\u03c0\u03b9\u03b8\u03c5\u03bc\u03bf\u03cd\u03bc\u03b5 \u03c3\u03c4\u03b7 \u03c0\u03b5\u03c1\u03b9\u03b3\u03c1\u03b1\u03c6\u03ae \u03b3\u03c1\u03ac\u03c6\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf ID \u03c4\u03bf\u03c5 \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae | \u03c4\u03bf \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03cc \u03ad\u03ba\u03c0\u03c4\u03c9\u03c3\u03b7\u03c2.<a href=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png\"><img loading=\"lazy\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22085 size-full\" src=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png\" alt=\"\" width=\"1919\" height=\"925\" srcset=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png 1919w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_1-300x145.png 300w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_1-1024x494.png 1024w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_1-768x370.png 768w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_1-1536x740.png 1536w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<p>\u03a3\u03c4\u03bf \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 \u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03bf\u03c5\u03bc\u03b5 \u03bd\u03b1 \u03b5\u03c6\u03b1\u03c1\u03bc\u03cc\u03b6\u03b5\u03c4\u03b1\u03b9, \u03c3\u03c4\u03bf \u03b9\u03c3\u03c4\u03bf\u03c1\u03b9\u03ba\u03cc \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c4\u03bf\u03c5\u03bc\u03b5 \u03ad\u03bd\u03b1 \u03c3\u03c7\u03cc\u03bb\u03b9\u03bf, \u03c4\u03af\u03c4\u03bb\u03bf\u03c2 \u03bf\u03bc\u03ac\u03b4\u03b1\u03c2 \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd \u03ba\u03b5\u03bd\u03cc \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03cc \u03ad\u03ba\u03c0\u03c4\u03c9\u03c3\u03b7\u03c2. \u039d\u03b1 \u03c3\u03b7\u03bc\u03b5\u03b9\u03c9\u03b8\u03b5\u03af \u03cc\u03c4\u03b9 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b1\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b7 \u03bd\u03b5\u03cc\u03c4\u03b5\u03c1\u03b7 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae \u03c3\u03c7\u03bf\u03bb\u03af\u03bf\u03c5.<\/p>\n<p><a href=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_2-21.png\"><img loading=\"lazy\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22083 size-full\" src=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_2-21.png\" alt=\"\" width=\"1919\" height=\"920\" srcset=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_2-21.png 1919w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_2-300x144.png 300w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_2-1024x491.png 1024w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_2-768x368.png 768w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_2-1536x736.png 1536w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_3-21.png\"><img loading=\"lazy\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22081 size-full\" src=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_3-21.png\" alt=\"\" width=\"1919\" height=\"921\" srcset=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_3-21.png 1919w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_3-300x144.png 300w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_3-1024x491.png 1024w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_3-768x369.png 768w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_3-1536x737.png 1536w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_4-21.png\"><img loading=\"lazy\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22079 size-full\" src=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_4-21.png\" alt=\"\" width=\"1919\" height=\"919\" srcset=\"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_4-21.png 1919w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_4-300x144.png 300w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_4-1024x490.png 1024w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_4-768x368.png 768w, https:\/\/www.sbzsystems.com\/wp-content\/uploads\/2023\/04\/auto_opencart_prices_per_manufacturer_4-1536x736.png 1536w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u03a3\u03c4\u03b7 \u03b3\u03ad\u03c6\u03c5\u03c1\u03b1 \u03c4\u03b7\u03c2 EMDI \u03b3\u03b9\u03b1 OpenCart \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c4\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf \u03ba\u03ce\u03b4\u03b9\u03ba\u03b1 PHP \/\/ \u03a5\u03a0\u039f\u039b\u039f\u0393\u0399\u03a3\u039c\u039f\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d if ($action == &#8216;calc_discounts&#8217;) { $debug=0; \/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d \u039c\u0395 \u0395\u0399\u0394\u0399\u039a\u0395\u03a3 \u03a3\u03a5\u039d\u0398\u0397\u039a\u0395\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d $query=&#8221; select cust.customer_id, cust.customer_group_id, ( SELECT (select GROUP_CONCAT( concat( manuf.manufacturer_id,&#8217;|&#8217;,manuf.name) ) from &#8221; . $dbprefix . &#8220;manufacturer manuf where hist.comment like concat(&#8216;%,&#8217;,manuf.name,&#8217;%&#8217;) ) FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[26,34,32],"tags":[],"class_list":["post-2387","post","type-post","status-publish","format-standard","hentry","category-web-development","category-website-eshop","category-dorean-kodikas-delphi-php-perl","entry"],"yoast_head":"<title>\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart - FREEextra.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.freeextra.com\/en\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart - FREEextra.com\" \/>\n<meta property=\"og:description\" content=\"\u03a3\u03c4\u03b7 \u03b3\u03ad\u03c6\u03c5\u03c1\u03b1 \u03c4\u03b7\u03c2 EMDI \u03b3\u03b9\u03b1 OpenCart \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c4\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf \u03ba\u03ce\u03b4\u03b9\u03ba\u03b1 PHP \/\/ \u03a5\u03a0\u039f\u039b\u039f\u0393\u0399\u03a3\u039c\u039f\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d if ($action == &#8216;calc_discounts&#8217;) { $debug=0; \/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d \u039c\u0395 \u0395\u0399\u0394\u0399\u039a\u0395\u03a3 \u03a3\u03a5\u039d\u0398\u0397\u039a\u0395\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d $query=&#8221; select cust.customer_id, cust.customer_group_id, ( SELECT (select GROUP_CONCAT( concat( manuf.manufacturer_id,&#8217;|&#8217;,manuf.name) ) from &#8221; . $dbprefix . &#8220;manufacturer manuf where hist.comment like concat(&#8216;%,&#8217;,manuf.name,&#8217;%&#8217;) ) FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.freeextra.com\/en\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/\" \/>\n<meta property=\"og:site_name\" content=\"FREEextra.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-11T14:09:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-11T09:01:24+00:00\" \/>\n<meta name=\"author\" content=\"sbz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/\"},\"author\":{\"name\":\"sbz\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/person\\\/a1710b2720bd36473bd450e8427b27d6\"},\"headline\":\"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart\",\"datePublished\":\"2023-04-11T14:09:25+00:00\",\"dateModified\":\"2026-06-11T09:01:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/\"},\"wordCount\":2721,\"publisher\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/auto_opencart_prices_per_manufacturer_1-21.png\",\"articleSection\":[\"Web development\",\"Website - eShop\",\"\u0394\u03c9\u03c1\u03b5\u03ac\u03bd \u03ba\u03ce\u03b4\u03b9\u03ba\u03b1\u03c2 (Delphi, PHP, Perl)\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/\",\"name\":\"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart - FREEextra.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/auto_opencart_prices_per_manufacturer_1-21.png\",\"datePublished\":\"2023-04-11T14:09:25+00:00\",\"dateModified\":\"2026-06-11T09:01:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/auto_opencart_prices_per_manufacturer_1-21.png\",\"contentUrl\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/auto_opencart_prices_per_manufacturer_1-21.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/web-development\\\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.freeextra.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/\",\"name\":\"FREEextra.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#organization\",\"name\":\"FREEextra.com\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/freeextra-logo-var1-2024.png\",\"contentUrl\":\"https:\\\/\\\/www.freeextra.com\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/freeextra-logo-var1-2024.png\",\"width\":1860,\"height\":434,\"caption\":\"FREEextra.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.freeextra.com\\\/en\\\/#\\\/schema\\\/person\\\/a1710b2720bd36473bd450e8427b27d6\",\"name\":\"sbz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g\",\"caption\":\"sbz\"},\"sameAs\":[\"https:\\\/\\\/freeextra.com\\\/cms\"]}]}<\/script>","yoast_head_json":{"title":"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart - FREEextra.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.freeextra.com\/en\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/","og_locale":"en_US","og_type":"article","og_title":"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart - FREEextra.com","og_description":"\u03a3\u03c4\u03b7 \u03b3\u03ad\u03c6\u03c5\u03c1\u03b1 \u03c4\u03b7\u03c2 EMDI \u03b3\u03b9\u03b1 OpenCart \u03c0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c4\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf \u03ba\u03ce\u03b4\u03b9\u03ba\u03b1 PHP \/\/ \u03a5\u03a0\u039f\u039b\u039f\u0393\u0399\u03a3\u039c\u039f\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d if ($action == &#8216;calc_discounts&#8217;) { $debug=0; \/\/\u0395\u03a5\u03a1\u0395\u03a3\u0397 \u03a0\u0395\u039b\u0391\u03a4\u03a9\u039d \u039c\u0395 \u0395\u0399\u0394\u0399\u039a\u0395\u03a3 \u03a3\u03a5\u039d\u0398\u0397\u039a\u0395\u03a3 \u0395\u039a\u03a0\u03a4\u03a9\u03a3\u0395\u03a9\u039d $query=&#8221; select cust.customer_id, cust.customer_group_id, ( SELECT (select GROUP_CONCAT( concat( manuf.manufacturer_id,&#8217;|&#8217;,manuf.name) ) from &#8221; . $dbprefix . &#8220;manufacturer manuf where hist.comment like concat(&#8216;%,&#8217;,manuf.name,&#8217;%&#8217;) ) FROM &#8221; . $dbprefix . &#8220;customer_group_description descr,&#8221; [&hellip;]","og_url":"https:\/\/www.freeextra.com\/en\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/","og_site_name":"FREEextra.com","article_published_time":"2023-04-11T14:09:25+00:00","article_modified_time":"2026-06-11T09:01:24+00:00","author":"sbz","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#article","isPartOf":{"@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/"},"author":{"name":"sbz","@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/person\/a1710b2720bd36473bd450e8427b27d6"},"headline":"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart","datePublished":"2023-04-11T14:09:25+00:00","dateModified":"2026-06-11T09:01:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/"},"wordCount":2721,"publisher":{"@id":"https:\/\/www.freeextra.com\/en\/#organization"},"image":{"@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png","articleSection":["Web development","Website - eShop","\u0394\u03c9\u03c1\u03b5\u03ac\u03bd \u03ba\u03ce\u03b4\u03b9\u03ba\u03b1\u03c2 (Delphi, PHP, Perl)"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/","url":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/","name":"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart - FREEextra.com","isPartOf":{"@id":"https:\/\/www.freeextra.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#primaryimage"},"image":{"@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png","datePublished":"2023-04-11T14:09:25+00:00","dateModified":"2026-06-11T09:01:24+00:00","breadcrumb":{"@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#primaryimage","url":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png","contentUrl":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2026\/06\/auto_opencart_prices_per_manufacturer_1-21.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.freeextra.com\/web-development\/aytomati-dimioyrgia-omadon-pelaton-prosforon-vasei-posostoy-kataskeyasti-pelati-8211-opencart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.freeextra.com\/"},{"@type":"ListItem","position":2,"name":"\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03bf\u03bc\u03ac\u03b4\u03c9\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd, \u03c0\u03c1\u03bf\u03c3\u03c6\u03bf\u03c1\u03ce\u03bd \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03bf\u03c3\u03bf\u03c3\u03c4\u03bf\u03cd, \u03ba\u03b1\u03c4\u03b1\u03c3\u03ba\u03b5\u03c5\u03b1\u03c3\u03c4\u03ae, \u03c0\u03b5\u03bb\u03ac\u03c4\u03b7 &#8211; OpenCart"}]},{"@type":"WebSite","@id":"https:\/\/www.freeextra.com\/en\/#website","url":"https:\/\/www.freeextra.com\/en\/","name":"FREEextra.com","description":"","publisher":{"@id":"https:\/\/www.freeextra.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.freeextra.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.freeextra.com\/en\/#organization","name":"FREEextra.com","url":"https:\/\/www.freeextra.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2024\/12\/freeextra-logo-var1-2024.png","contentUrl":"https:\/\/www.freeextra.com\/wp-content\/uploads\/2024\/12\/freeextra-logo-var1-2024.png","width":1860,"height":434,"caption":"FREEextra.com"},"image":{"@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.freeextra.com\/en\/#\/schema\/person\/a1710b2720bd36473bd450e8427b27d6","name":"sbz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2c1491a20faf6ff6fa88155d53ae766f53b1be15a28a8b563e5d5429743ed0?s=96&d=mm&r=g","caption":"sbz"},"sameAs":["https:\/\/freeextra.com\/cms"]}]}},"_links":{"self":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/2387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/comments?post=2387"}],"version-history":[{"count":991,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/2387\/revisions"}],"predecessor-version":[{"id":309772,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/posts\/2387\/revisions\/309772"}],"wp:attachment":[{"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/media?parent=2387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/categories?post=2387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.freeextra.com\/en\/wp-json\/wp\/v2\/tags?post=2387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}