mrizwan47

<?php


/**
 * ----------------------------------------------------------------------------------------
 * Based on `https://github.com/mecha-cms/mecha-cms/blob/master/engine/plug/converter.php`
 * ----------------------------------------------------------------------------------------
 */

mrizwan47

<?php
global $wpdb;

$wpdb->query("DELETE FROM $wpdb->terms WHERE term_id IN (SELECT term_id FROM $wpdb->term_taxonomy WHERE taxonomy LIKE 'pa_%')");
$wpdb->query("DELETE FROM $wpdb->term_taxonomy WHERE taxonomy LIKE 'pa_%'");
$wpdb->query("DELETE FROM $wpdb->term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM $wpdb->term_taxonomy)");
$wpdb->query("DELETE FROM $wpdb->term_relationships WHERE object_id IN (SELECT ID FROM $wpdb->posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM $wpdb->postmeta WHERE post_id IN (SELECT ID FROM $wpdb->posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM $wpdb->posts WHERE post_type IN ('product','product_variation')");
$wpdb->query("DELETE pm FROM $wpdb->postmeta pm LEFT JOIN $wpdb->posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL");

mrizwan47

<?php
// Your Product ID
$product_id		= 57;

$ecd_product	=	new WC_Product( $product_id );

/**
 * Check if product exists
 */
if( $ecd_product->exists() ){

mrizwan47

<?php
$dashicons	=	array( 
  '&#xf333;' => 'dashicons-menu',
  '&#xf319;' => 'dashicons-admin-site',
  '&#xf226;' => 'dashicons-dashboard',
  '&#xf109;' => 'dashicons-admin-post',
  '&#xf104;' => 'dashicons-admin-media',
  '&#xf103;' => 'dashicons-admin-links',
  '&#xf105;' => 'dashicons-admin-page',
  '&#xf101;' => 'dashicons-admin-comments',

mrizwan47

mrizwan47

version: '3'

services:
  # Database
  db:
    image: mysql:5.7
    volumes:
      - db_data:/var/lib/mysql
      - /Volumes/DATA/Development/rizwan_47/sample-project/misc/database:/mysql-db/    # Change path before semicolon here

mrizwan47

# Download Latest WordPress
wget https://wordpress.org/latest.zip

# Unzip WP Zip file
unzip latest.zip

# (optional) change directory to something else
mv wordpress new_name

mrizwan47

INSERT INTO 
  `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) 
  VALUES (
    NULL, 'rizwan', MD5('PASSWORD_HERE'), 'Riz', '[email protected]', '', NOW(), '', '0', 'Rizwan');



SET @WPUserID = LAST_INSERT_ID();

mrizwan47

systemctl daemon-reload
systemctl enable jupyter.service
systemctl start jupyter.service

mrizwan47

// Following the direction from https://moz.com/blog/geolocation-the-ultimate-tip-to-emulate-local-search
function convert_uule( $location_name )
{

	// Code for length that resets at 64
	$len = strlen($location_name) % 64;

	// uule mapping array
	$uule_map = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-_';