<?php
$servername = "rm-3nsp08e0a25kj2jh3.mysql.rds.aliyuncs.com";
$username = "breadsecret.com";
$password = "3#!Xj7f&5";
$dbname = "breadsecret.com";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}else{
	
	echo "OK";
}


$holiday = false; // set this to true if today is holiday, false if today is working day.
if ( !$holiday )    {
mysqli_query($conn,"UPDATE `wp_postmeta` SET `meta_value` = 'instock' WHERE `post_id` IN (855,1081,669,1091,2274,2299,2182,2298,702,1242,716,1237) AND `meta_key` = '_stock_status'");  
mysqli_query($conn,"UPDATE `wp_postmeta` SET `meta_value` =20 WHERE `post_id` IN (669,1091) AND `meta_key` = '_stock'");
mysqli_query($conn,"UPDATE `wp_postmeta` SET `meta_value` =10 WHERE `post_id` IN (855,1081) AND `meta_key` = '_stock'");
mysqli_query($conn,"UPDATE `wp_postmeta` SET `meta_value` =10 WHERE `post_id` IN (2274,2299,2182,2298,702,1242) AND `meta_key` = '_stock'");
mysqli_query($conn,"UPDATE `wp_postmeta` SET `meta_value` =0 WHERE `post_id` IN (743,1087) AND `meta_key` = '_stock'");
mysqli_query($conn,"UPDATE `wp_postmeta` SET `meta_value` =6 WHERE `post_id` IN (716,1237) AND `meta_key` = '_stock'");



mysqli_close($con);
}

?>