Domain Cron

query($sql);
$count = $result->num_rows;

if ($count > 0) {
while($row = $result->fetch_assoc()) {
$order_item_id=$row[“order_item_id”];
$order_id=$row[“order_id”];
$sqlcs = “SELECT post_type FROM wp_posts where ID=’$order_id’ and post_status like ‘wc-processing'”;
$resultcs = $conn->query($sqlcs);
$countcs = $resultcs->num_rows;
if ($countcs > 0){
$sqld = “SELECT meta_value FROM wp_woocommerce_order_itemmeta where order_item_id=’$order_item_id’ and meta_key like ‘Domain'”;
$resultd = $conn->query($sqld);
$rowd = $resultd->fetch_assoc();
$domain=$rowd[“meta_value”];
$sqll = “SELECT meta_value FROM wp_woocommerce_order_itemmeta where order_item_id=’$order_item_id’ and meta_key like ‘Length'”;
$resultl = $conn->query($sqll);
$rowl = $resultl->fetch_assoc();
$length=$rowl[“meta_value”];
$length = str_replace(” Year”,””,$reg_length);
$length = str_replace(“s”,””,$reg_length);
if ($reg_length != “”){
// $interval=$reg_length*12;
$interval=12;
} else {
$interval=12;
}
$sqlpp = “SELECT meta_value FROM wp_woocommerce_order_itemmeta where order_item_id=’$order_item_id’ and meta_key like ‘Type’ limit 1”;
$resultpp = $conn->query($sqlpp);
$rowpp = $resultpp->fetch_assoc();
$type = $rowpp[“meta_value”];
if ($type == “Private”){
$privacy=1;
} else {
$privacy=0;
}
try
{
$resultrd = $hc_api_client->domain->renew($domain, $length);
}
catch(HostControlAPIClientError $e)
{
echo ”;
echo ‘An error occurred, please try again or submit a support ticket.
Error Message: ‘ . $e->getMessage();
}
$sql3 = “UPDATE domains set pp=’$privacy’ where domain_name=’$domain'”;
$result3 = $conn->query($sql3);
$sql4 = “UPDATE wp_posts set post_status=’wc-complete’ where ID=’$order_id'”;
$result4 = $conn->query($sql4);
}
}
}

//Privacy Protection
// Add Later once the process can be automated

?>