Skip to content

Instantly share code, notes, and snippets.

@BrocksiNet
BrocksiNet / sitemap_link_checker.php
Created December 5, 2022 09:42
Updated sitemap_link_checker
@BrocksiNet
BrocksiNet / mysql-select-simples-not-assigned-to-parents.sql
Last active February 10, 2020 19:50
Magento2 - MySQL Select simples products not assigned to parents
SELECT * FROM `catalog_product_entity`
LEFT JOIN `catalog_product_entity_int` ON `catalog_product_entity`.`entity_id` = `catalog_product_entity_int`.`entity_id`
WHERE `catalog_product_entity`.`type_id` = 'simple' AND `catalog_product_entity_int`.`attribute_id` = (SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = 'visibility') AND `catalog_product_entity_int`.`value` = 1 AND `catalog_product_entity`.`entity_id` NOT IN
(
SELECT `product_id` FROM `catalog_product_super_link`
)
@BrocksiNet
BrocksiNet / bitbucket-to-github.sh
Last active July 26, 2019 14:22
Shell-Script to move repositories from bitbucket to github
#!/bin/bash
set -e
# Shell script to move repos from bitbucket to github
ä
# use the command like this:
# ./bitbucket-to-github.sh -org="organization" -ghu="github-username" -ghp="github-password" -bbu="bitbucket-username" -bbp="bitbucket-password"
for i in "$@"
do