INSERT INTO `meta` SET `key`=:key, `value`=:value ON DUPLICATE KEY UPDATE `key`=:key, `value`=:value „,
Autor: Simon
MySQL Insert OR Replace if exists
INSERT INTO `meta` SET `key`=:key, `value`=:value ON DUPLICATE KEY UPDATE `key`=:key, `value`=:value „,
MySQL Insert OR Update of exists
INSERT INTO `meta` SET `key`=:key, `value`=:value ON DUPLICATE KEY UPDATE `key`=:key, `value`=:value „,
GIT self signed cert
C:\Program Files\Git\usr\ssl\certs\ca-bundle.crt Copy file Append own cert (Text editor) git config –global http.sslCAInfo „E:\……\ca-bundle.crt“
Rainbow color text CSS
Nur webkit todo
Elementor: Finde custom post type
add_action( ‚elementor/query/my_custom_filter‘, function( $query ) {// Here we set the query to fetch posts with// post type of ‚custom-post-type1‘ and ‚custom-post-type2‘$query->set( ‚post_type‘, [ ‚custom-post-type1‘, ‚custom-post-type2‘ ] );} );
Irgendwas mit WSL und XServer
export DISPLAY=$(cat /etc/resolv.conf | grep nameserver | awk ‚{print $2}‘):0
Update WordPress URL
UPDATE wp_options SET option_value = replace(option_value, ‚http://www.old.url‘, ‚http://www.new.url‘) WHERE option_name = ‚home‘ OR option_name = ’siteurl‘;UPDATE wp_posts SET guid = replace(guid, ‚http://www.old.url‘,’http://www.new.url‘); UPDATE wp_posts SET post_content = replace(post_content, ‚http://www.old.url‘, ‚http://www.new.url‘); UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://www.old.url‘,’http://www.new.url‘);
Minecraft: Remove invisible armor stands
/minecraft:data modify entity @e[type=minecraft:armor_stand,sort=nearest,limit=1] Invisible set value 0/minecraft:kill @e[type=!minecraft:player,sort=nearest,limit=1]
Raspberry Remote Funksteckdosen lib install…
git clone git://git.drogon.net/wiringPicd wiringPi./build git clone git://github.com/xkonni/raspberry-remote.gitcd raspberry-remotemake send./send -s -p 2 01000 4 1
WordPress Memory Limit erhöhen
define(‚WP_MEMORY_LIMIT‘, ‚265M‘);define(‚WP_MAX_MEMORY_LIMIT‘, ‚265M‘);
WordPress Multisite Einstellungen
define(‚FORCE_SSL_ADMIN‘, true); define(‚WP_ALLOW_MULTISITE‘, true);define(‚MULTISITE‘, true);define(‚SUBDOMAIN_INSTALL‘, true);define(‚DOMAIN_CURRENT_SITE‘, ‚admin.domain.de‘);define(‚PATH_CURRENT_SITE‘, ‚/‘);define(‚SITE_ID_CURRENT_SITE‘, 1);define(‚BLOG_ID_CURRENT_SITE‘, 1); define( ‚COOKIE_DOMAIN‘, “ );define( ‚ADMIN_COOKIE_PATH‘, ‚/‘ );define( ‚COOKIEPATH‘, ‚/‘ );define( ‚SITECOOKIEPATH‘, ‚/‘ ); define(‚WP_MEMORY_LIMIT‘, ‚265M‘);define(‚WP_MAX_MEMORY_LIMIT‘, ‚265M‘);
iOS Activator ssh commands
activator send libactivator.system.take-screenshotactivator send libactivator.audio.volume.100activator send libactivator.audio.volume.media.100
Unicode DreieckKreis
⭕⃤
iOS Wireshark
ssh root@deviceIP tcpdump -w – ‚port !22‘ | wireshark -k -i –