devzorg’s gists

devzorg / onvif multi platform

Created March 29, 2018 10:57

ONVIF server crossplatform compilation

	Профили протокола https://www.onvif.org/profiles/
	Спецификация и WSDL https://www.onvif.org/profiles/specifications/

	SERVERS::
	c#
	https://github.com/sarthak-k/Onvif.Open
	https://github.com/ticapix/onvifserver

	Java
	https://github.com/hhbgk/WebService

devzorg / add-checkout-form-key.sh

Created May 25, 2018 11:26 — forked from schmengler/add-checkout-form-key.sh

Magento SUPEE-9767 Checkout Form Key Theme Patch

	find -L app/design/frontend -regex '.*$shipping\\|billing\\|shipping_method\\|payment$.phtml' -exec grep -L formkey {} \; \
	\| xargs sed -i 's/<\/form>/<?php echo $this->getBlockHtml("formkey") ?><\/form>/g'

	find -L skin/frontend -name 'opcheckout.js' -exec grep -L form_key {} \; \
	\| xargs sed -i 's/if (elements\[i\].name=='\''payment\[method\]'\'') {/if (elements[i].name=='\''payment[method]'\'' \|\| elements[i].name == '\''form_key'\'') {/g'

devzorg / php7.1.26 issue

Created March 11, 2019 10:16

devzorg / Elasticsearch_reset_readonly

Created October 3, 2019 16:22

	curl -XPUT -H "Content-Type: application/json" http://localhost:9200/_cluster/settings -d '{ "transient": { "cluster.routing.allocation.disk.threshold_enabled": false } }'
	curl -XPUT -H "Content-Type: application/json" http://localhost:9200/_all/_settings -d '{"index.blocks.read_only_allow_delete": null}'

devzorg / How to improve upgrades MAGENTO2

Last active October 9, 2019 07:45

	1. https://alanstorm.com/magento-2-setup-migration-scripts/
	2. https://devdocs.magento.com/guides/v2.3/extension-dev-guide/declarative-schema/data-patches.html

devzorg / Full path by path category magento

Created March 21, 2020 08:15

	-- full path by child id
	WITH RECURSIVE category_path (id, title, parent_id) AS
	(
	SELECT id, title, parent_id
	FROM magedev_seotree
	WHERE id = 17 AND store_id=1
	UNION ALL
	SELECT c.id, c.title, c.parent_id
	FROM category_path AS cp JOIN magedev_seotree AS c
	ON cp.parent_id = c.id

devzorg / import_single_table

Created July 20, 2020 08:36

Import one table from big sql file

sed -n -e '/CREATE TABLE.*`TABLE_TO_FIND`/,/CREATE TABLE/p' bigdump.sql > single-table-dump.sql

devzorg / my.cnf

Created March 27, 2023 20:18 — forked from fevangelou/my.cnf

Optimized my.cnf configuration for MySQL/MariaDB (on Ubuntu, CentOS, Almalinux etc. servers)

	# === Optimized my.cnf configuration for MySQL/MariaDB (on Ubuntu, CentOS, Almalinux etc. servers) ===
	#
	# by Fotis Evangelou, developer of Engintron (engintron.com)
	#
	# ~ Updated December 2021 ~
	#
	#
	# The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores.
	# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
	#

	find -L app/design/frontend -regex '.*\(shipping\\|billing\\|shipping_method\\|payment\).phtml' -exec grep -L formkey {} \; \
	\| xargs sed -i 's/<\/form>/<?php echo $this->getBlockHtml("formkey") ?><\/form>/g'

	find -L skin/frontend -name 'opcheckout.js' -exec grep -L form_key {} \; \
	\| xargs sed -i 's/if (elements\[i\].name=='\''payment\[method\]'\'') {/if (elements[i].name=='\''payment[method]'\'' \|\| elements[i].name == '\''form_key'\'') {/g'

Oleg devzorg