lzook

So I actually was able to get this to work great. I forgot and blanked on just doing an inner join between the two tables instead of trying to pass variables around.

The Working Code:

add_action('giga_pre_seed', function ($bot) {

    $bot->answers('@order', function ($bot, $lead_id, $input) {

                // You use $wpdb object so you'll need to use global variable

        global $wpdb;       
		
		$order_status = $wpdb->get_var($wpdb->prepare("SELECT wp_posts.post_status 
														FROM wp_postmeta
														INNER JOIN wp_posts
														ON wp_postmeta.post_id = wp_posts.ID
														WHERE wp_postmeta.meta_value=%s", $input));
		
		$bot->says($order_status);		
          
    }); 

});

I appreciate the assistance on this matter. Your above link worked amazingly!

Thanks again for the fast response!

The last bit of the link in the original post is to take you to the woocommerce product and automaticaly select the variation of date. But when it cleans the link, it no longer is able to select the variation.

The calendar is located at:
https://10-8tacticalsupply.com/training-department-firearms/

Bump

SELECT COUNT( DISTINCT posts.ID )
FROM wpn_posts as posts
INNER JOIN wpn_postmeta AS postmeta
ON posts.ID = postmeta.post_id
INNER JOIN wpn_postmeta AS postmeta2
ON posts.ID = postmeta2.post_id
WHERE 1=1
AND posts.post_type IN ( 'product', 'product_variation' )
AND posts.post_status = 'publish'
AND postmeta2.meta_key = '_manage_stock'
AND postmeta2.meta_value = 'yes'
AND postmeta.meta_key = '_stock'
AND CAST(postmeta.meta_value AS SIGNED) <= '0' ;	

    WC_Admin_Dashboard->status_widget_stock_rows()
     wp-content/plugins/woocommerce/includes/admin/class-wc-admin-dashboard.php:191

	Plugin: woocommerce 	1 	36.5100

This is what Query Manager shows me when I load the dashboard. I have the the Woocommerce dashboard widget disabled at the moment.

And to add to another quirk.. Since I have set up the child theme. I am unable to access a custom page i created and imported styles too..

https://10-8tacticalsupply.com/ossupport/

also whats your (e) mail ? I will get in touch with you

I have achieved getting the style sheet to load and look right. However now I can’t get the customize to let me hit publish and save.. it spins and doesn’t save..

Yes it works great with any other theme except the child theme. And i put the site wrong

https://10-8TacticalSupply.com/

My images settings in WooCommerce as such:
Catalog Images: 300×300
Single Product Images: 600×600
Product Thumbnails: 50×50

I had adjusted the settings as you instructed in woo-commerce.. I went from 180×180 to 50×50 and then regenerated thumbnails. However it did not work.

Here is a link to a product with large images:
https://10-8tacticalsupply.com/product/pulsar-l-808s-laser-ir-night-vision-accessories/

Thanks for the assistance!

I am using the storefront theme

I found a plugin that works great and interacts with WooCommerce. it is called “Featured Image From URL.” and allows for product images and product gallery images via url with out imports.

You are correct. So i had to code the other program.

After some research and trial and error I have not fixed it. WooCommerce was cause wordpress to try and used php pass to verify.. I rerouted the PHP Password Hash from OSTICKET to the wordrpess version. And now it shows up to everyone

I get the following above the header when logged in:

Strict Standards: Non-static method DatabaseMigrater::getUpgradeStreams() should not be called statically, assuming $this from incompatible context in /home/lzook88/public_html/10-8Tactical/ossupport/include/class.osticket.php on line 74

Strict Standards: Non-static method FAQ::countPublishedFAQs() should not be called statically, assuming $this from incompatible context in /home/lzook88/public_html/10-8Tactical/ossupport/include/class.config.php on line 222

Notice: Undefined property: mysqli::$unbuffered_result in /home/lzook88/public_html/10-8Tactical/ossupport/include/mysqli.php on line 157

Notice: Undefined variable: ost in /home/lzook88/public_html/10-8Tactical/wp-content/themes/storefront/header.php on line 40

and I get this when logged out:

Fatal error: Cannot redeclare class PasswordHash in /home/lzook88/public_html/10-8Tactical/wp-includes/class-phpass.php on line 36