Hakan ARSLAN harslannet

## functions.php
add_action( 'woocommerce_thankyou', 'my_custom_tracking' );

function my_custom_tracking( $order_id ) {

	// Lets grab the order
	$order = wc_get_order( $order_id );

	/**
	 * Put your tracking code here
	 * You can get the order total etc e.g. $order->get_total();

## responsive_wordpress.css
/**
 * Responsive WordPress Core Theme Styles
 * http://jeffsebring.com/responsive-wordpress-images/
--------------------------------------------------- */

.sticky,
.bypostauthor,
.gallery-caption {
   display: normal;
}

## gist:2315295
<?php
// rewrite /wp-content/themes/theme-name/css/ to /css/
// rewrite /wp-content/themes/theme-name/js/  to /js/
// rewrite /wp-content/themes/theme-name/img/ to /img/
// rewrite /wp-content/plugins/ to /plugins/

function roots_flush_rewrites() {
  global $wp_rewrite;
  $wp_rewrite->flush_rules();
}

## anonymous
<head>
  <meta name="viewport" content="width=device-width">
</head>
<div class="wrap">
<span class="decor"></span>
<nav>
  <ul class="primary">
    <li>
      <a href="">Dog</a>
      <ul class="sub">

## woocommerce_update_stock_status.php
<?php

/**
 * set the stock status for all products in your WooCommerce store
 * @return void
 */
function woocommerce_update_stock_status(){
  global $wpdb;

	// set all status for products with 0 or less stocked quantity

## README.md

      
              1 file
            
          
              36 forks
            
          
              1 comment
            
          
              120 stars
            
          
                magnetikonline
                / README.md
            
            
              Last active
              April 28, 2023 16:06
            
              
                WordPress assorted database clean up SQL queries.
              
          
    WordPress database clean up queries


Orphan rows

wp_posts -> wp_posts (parent/child)
wp_postmeta -> wp_posts
wp_term_taxonomy -> wp_terms
wp_term_relationships -> wp_term_taxonomy
wp_usermeta -> wp_users
wp_posts -> wp_users


Other


## gist:3835778210966604defa
add_action( 'get_header', 'remove_storefront_sidebar' );
	if ( is_product() ) {
		remove_action( 'storefront_sidebar', 'storefront_get_sidebar',			10 );
	}
}

## parallelize.php
<?php

/******
Parallelize downloads across hostnames for WordPress.
Useful to boost static resources load speed on websites.
Recommended by GTmetrix, Pingdom, Google Speed Insights, and others.
See full post > https://medium.com/p/32e9dc2fec0c

In order to work properly, all subdomains/hostnames MUST have the same structure/path. Ex:
http://mydomain.com/wp-content/uploads/2015/11/myimage.jpg

## translate_woocommerce.php

function translate_woocommerce($translation, $text, $domain) {
    if ($domain == 'woocommerce') {
        switch ($text) {
            case 'SKU':
                $translation = 'Product Code';
                break;
            case 'SKU:':
                $translation = 'Product Code:';
                break;

## delete-all-woocommerce-products.php
<?php

require dirname(__FILE__).'/wp-blog-header.php';

$wpdb->query("DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%')");
$wpdb->query("DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'");
$wpdb->query("DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy)");
$wpdb->query("DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM wp_posts WHERE post_type IN ('product','product_variation')");
	add_action( 'woocommerce_thankyou', 'my_custom_tracking' );

	function my_custom_tracking( $order_id ) {

	// Lets grab the order
	$order = wc_get_order( $order_id );

	/**
	* Put your tracking code here
	* You can get the order total etc e.g. $order->get_total();
	/**
	* Responsive WordPress Core Theme Styles
	* http://jeffsebring.com/responsive-wordpress-images/
	--------------------------------------------------- */

	.sticky,
	.bypostauthor,
	.gallery-caption {
	display: normal;
	}
	<?php
	// rewrite /wp-content/themes/theme-name/css/ to /css/
	// rewrite /wp-content/themes/theme-name/js/ to /js/
	// rewrite /wp-content/themes/theme-name/img/ to /img/
	// rewrite /wp-content/plugins/ to /plugins/

	function roots_flush_rewrites() {
	global $wp_rewrite;
	$wp_rewrite->flush_rules();
	}
	<head>
	<meta name="viewport" content="width=device-width">
	</head>
	<div class="wrap">
	<span class="decor"></span>
	<nav>
	<ul class="primary">
	<li>
	<a href="">Dog</a>
	<ul class="sub">
	<?php

	/**
	* set the stock status for all products in your WooCommerce store
	* @return void
	*/
	function woocommerce_update_stock_status(){
	global $wpdb;

	// set all status for products with 0 or less stocked quantity
	add_action( 'get_header', 'remove_storefront_sidebar' );
	if ( is_product() ) {
	remove_action( 'storefront_sidebar', 'storefront_get_sidebar', 10 );
	}
	}
	<?php

	/******
	Parallelize downloads across hostnames for WordPress.
	Useful to boost static resources load speed on websites.
	Recommended by GTmetrix, Pingdom, Google Speed Insights, and others.
	See full post > https://medium.com/p/32e9dc2fec0c

	In order to work properly, all subdomains/hostnames MUST have the same structure/path. Ex:
	http://mydomain.com/wp-content/uploads/2015/11/myimage.jpg

	function translate_woocommerce($translation, $text, $domain) {
	if ($domain == 'woocommerce') {
	switch ($text) {
	case 'SKU':
	$translation = 'Product Code';
	break;
	case 'SKU:':
	$translation = 'Product Code:';
	break;