primoz klemensek klemensek

klemensek / sql_export_essential_product_data.sql

Created July 27, 2020 14:26

magento 2 export sku, url_key, visibility, status, price, special_price

	SELECT `e`.entity_id, e.sku,
	IF(at_url_key.value_id > 0, at_url_key.value, at_url_key_default.value) AS `url_key`,
	at_cpr_navision_id.value AS `cpr_navision_id`,
	IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`,
	IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`
	,IF(at_price.value_id > 0, at_price.value, "") AS `price`
	,IF(at_specialprice.value_id > 0, at_specialprice.value, "") AS `special_price`
	FROM `catalog_product_entity` AS `e`
	left join catalog_product_website on product_id = entity_id and website_id = 1

klemensek / get_dns_by_domain.php

Created April 23, 2018 15:44

dns_get_record, gethostbyname, ip, dns

	<?php

	$domains = array();
	$domains[] = "klemensek.com";

	foreach ($domains as $domain) {
	$dns = dns_get_record($domain, DNS_NS);
	$ip = gethostbyname($domain);

	echo $domain . ";" ;