Julian Stark julian-stark

## linux-usb-stick.txt
https://tutorials.ubuntu.com/tutorial/tutorial-create-a-usb-stick-on-windows#1
https://unetbootin.github.io/
https://de.wikihow.com/In-Ubuntu-auf-Windows-Dateien-zugreifen
https://forum.ubuntuusers.de/topic/usb-festplatte-unter-ubuntu-einbinden/
https://askubuntu.com/questions/859787/how-to-unmount-and-mount-pen-drive-in-ubuntu-via-command-line

## migrate_wordpress
Main Steps:
http://www.wpexplorer.com/migrating-wordpress-website/

To Search/Replace SQL DB:
https://github.com/interconnectit/Search-Replace-DB

Change Prefix: (SQL and Steps after)
https://richjenks.com/change-mysql-database-table-prefix/
http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress

## remove-eicons-from-elementor.php
<?php

// Deactivate Eicons in Elementor
add_action( 'wp_enqueue_scripts', 'js_remove_default_stylesheet', 20 );
function js_remove_default_stylesheet() {

  // Don't remove it in the backend
  if ( is_admin() || current_user_can( 'manage_options' ) ) {
        return;
  }

## replace-eicons-with-font-awesome-in-elementor-templates.css
/*
 * Replace Eicons with FontAwesome
 */
.eicon {
	display: inline-block;
	font: normal normal normal 14px/1 FontAwesome;
	font-size: inherit;
	text-rendering: auto;
	-webkit-font-smoothing: antialiased;
	-moz-osx-font-smoothing: grayscale;

## Opt-Out for Cookie Notice for GDPR.php
<?php

/**
 * JULIAN STARK SNIPPET FOR WORDPRESS / WOOCOMMERCE
 * @TITLE: Opt-Out for Cookie Notice for GDPR
 * @DESCRIPTION: Only works with plugin "Cookie Notice for GDPR". Adds possibility for Opt-Out code.
 * @DOCUMENTATION AND DISCUSSION: https://julianstark.de/opt-out-statt-opt-in-beim-plugin-cookie-notice-for-gdpr/
 * @AUTHOR: Julian Stark
 * @VERSION: 1.1
 */

## elementor-close-popup-open-popup.js
jQuery( document ).ready( function( $ ) {

  // Let's assume the trigger is a link in div with ID #new-popup-trigger
  $( "#new-popup-trigger a" ).click(function() {
    // Replace XXX1 with the post id of the current popup
    $( "#elementor-popup-modal-XXX1 .dialog-close-button" ).click();
    // Replace XXX2 with the post id of the new popup
    elementorProFrontend.modules.popup.showPopup( { id: XXX2 } );
  });


## style.css
/* add class .horizontal-scroll to element */
@media (max-width:1024px) {
  .horizontal-scroll ul.ee-button-group {
    display:flex;
    flex-wrap:nowrap;
    overflow-x:auto;
    justify-content:flex-start;
  }

  .horizontal-scroll ul.ee-button-group li {

## echo_vs_return_in_shortcodes.php
<?php

// Don't use echo in the shortcodes. If you have to, use ob_start() / return ob_get_clean()
add_shortcode('test', 'my_test_func');
function my_test_func( $args ) {
  ob_start();

  ?>
  your content / html / etc
  <?php

## vba_json_to_exel.vba

Sub js_json_api_example()

    Dim req As MSXML2.ServerXMLHTTP60
    Dim apiURL, ret As String

    Set req = New MSXML2.ServerXMLHTTP60

    ' Example API: Openweathermap.org
    apiURL = "https://samples.openweathermap.org/data/2.5/weather?lat=35&lon=139&appid=439d4b804bc8187953eb36d2a8c26a02"

## style.css
/**
 * If #anchor link scrolls to deep -> e.g. heading is hidden by sticky header
 **/
h2 {
  /* margin: 20px 0; Let's imagine h2 has margin-top of 20px */
  padding-top: 100px; /* new padding-top = height element should be moved down in scroll (e.g. sticky header height) */
  margin-top: -80px; /* new margin top = old margin-top - new padding-top */
}
	https://tutorials.ubuntu.com/tutorial/tutorial-create-a-usb-stick-on-windows#1
	https://unetbootin.github.io/
	https://de.wikihow.com/In-Ubuntu-auf-Windows-Dateien-zugreifen
	https://forum.ubuntuusers.de/topic/usb-festplatte-unter-ubuntu-einbinden/
	https://askubuntu.com/questions/859787/how-to-unmount-and-mount-pen-drive-in-ubuntu-via-command-line
	Main Steps:
	http://www.wpexplorer.com/migrating-wordpress-website/

	To Search/Replace SQL DB:
	https://github.com/interconnectit/Search-Replace-DB

	Change Prefix: (SQL and Steps after)
	https://richjenks.com/change-mysql-database-table-prefix/
	http://tdot-blog.com/wordpress/6-simple-steps-to-change-your-table-prefix-in-wordpress
	/* add class .horizontal-scroll to element */
	@media (max-width:1024px) {
	.horizontal-scroll ul.ee-button-group {
	display:flex;
	flex-wrap:nowrap;
	overflow-x:auto;
	justify-content:flex-start;
	}

	.horizontal-scroll ul.ee-button-group li {
	<?php

	// Don't use echo in the shortcodes. If you have to, use ob_start() / return ob_get_clean()
	add_shortcode('test', 'my_test_func');
	function my_test_func( $args ) {
	ob_start();

	?>
	your content / html / etc
	<?php

	Sub js_json_api_example()

	Dim req As MSXML2.ServerXMLHTTP60
	Dim apiURL, ret As String

	Set req = New MSXML2.ServerXMLHTTP60

	' Example API: Openweathermap.org
	apiURL = "https://samples.openweathermap.org/data/2.5/weather?lat=35&lon=139&appid=439d4b804bc8187953eb36d2a8c26a02"
	/**
	* If #anchor link scrolls to deep -> e.g. heading is hidden by sticky header
	**/
	h2 {
	/* margin: 20px 0; Let's imagine h2 has margin-top of 20px */
	padding-top: 100px; /* new padding-top = height element should be moved down in scroll (e.g. sticky header height) */
	margin-top: -80px; /* new margin top = old margin-top - new padding-top */
	}