alex-79

#!/bin/bash

apt-get install build-essential ca-certificates zlib1g-dev libpcre3 libpcre3-dev tar unzip libssl-dev checkinstall git uuid-dev libgeoip-dev perl make curl cmake

OPENSSL_VER=3.3.1
OPENRESTY_VER=1.25.3.1

cd /opt
wget -c https://www.openssl.org/source/openssl-$OPENSSL_VER.tar.gz
tar -xzvf openssl-$OPENSSL_VER.tar.gz

alex-79

#!/bin/sh

apt-get install build-essential ca-certificates zlib1g-dev libpcre3 libpcre3-dev tar unzip libssl-dev checkinstall git uuid-dev libgeoip-dev

OPENSSL_VER=1.1.0k
NPS_VER=1.12.34.3-stable
NGINX_VER=1.17.1

cd /opt
wget -c https://www.openssl.org/source/openssl-$OPENSSL_VER.tar.gz

alex-79

#!/bin/bash

PHP_VER=8.1

sudo apt install php${PHP_VER}-bcmath php${PHP_VER}-cli php${PHP_VER}-common php${PHP_VER}-curl php${PHP_VER}-fpm php${PHP_VER}-gd php${PHP_VER}-intl php${PHP_VER}-mbstring php${PHP_VER}-mysql php${PHP_VER}-opcache php${PHP_VER}-readline php${PHP_VER}-soap php${PHP_VER}-xml php${PHP_VER}-xsl php${PHP_VER}-zip

sudo sed -i "s/memory_limit = .*/memory_limit = 2G/" /etc/php/${PHP_VER}/fpm/php.ini
sudo sed -i "s/upload_max_filesize = .*/upload_max_filesize = 256M/" /etc/php/${PHP_VER}/fpm/php.ini
sudo sed -i "s/zlib.output_compression = .*/zlib.output_compression = On/" /etc/php/${PHP_VER}/fpm/php.ini
sudo sed -i "s/max_execution_time = .*/max_execution_time = 18000/" /etc/php/${PHP_VER}/fpm/php.ini

alex-79

https://marketplace.visualstudio.com/items?itemName=redhat.vscode-xml

https://marketplace.visualstudio.com/items?itemName=viperet.vscode-magento-wizard

php bin/magento dev:urn-catalog:generate ./.vscode/catalog_tmp.xml

MagentoWizard: Generate XML Catalog command

select catalog_tmp.xml

alex-79

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++**++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++;;;;;;;;;;;+++++;;;;:~::;++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++;;:~~:~~..~~::::::~~.           .~:;++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++

alex-79

#!/bin/bash

echo 'deb http://www.rabbitmq.com/debian/ testing main' | tee /etc/apt/sources.list.d/rabbitmq.list
wget -O- https://www.rabbitmq.com/rabbitmq-release-signing-key.asc | apt-key add -
apt-get update
apt-get install rabbitmq-server


cd /opt/ 
git clone git://github.com/alanxz/rabbitmq-c.git

alex-79

#!/bin/bash

# https://mirasvit.com/blog/common-issues-and-few-hacks-with-magento-2-full-page-cache.html

cd app/design/frontend/ && grep --recursive -l 'cacheable="false"' * && cd ../../..;
cd app/code && grep --recursive -l 'cacheable="false"' * && cd ../..;
cd vendor && grep --recursive -l 'cacheable="false"' * && cd ..;

alex-79

#!/bin/bash

create_db="CREATE DATABASE $1 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
create_user="GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost' IDENTIFIED BY '$1';"
flush="FLUSH PRIVILEGES;"

mysql -u root -p -e  "${create_db}${create_user}${flush}"

mkdir $1.local
composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition $1.local

alex-79

SELECT * FROM `catalog_product_entity` AS a 
LEFT JOIN `catalog_product_entity_media_gallery_value` AS b ON a.entity_id = b.entity_id 
LEFT JOIN `catalog_product_entity_media_gallery` AS c ON b.value_id = c.value_id WHERE c.value IS NULL AND a.type_id = 'grouped'