query($sql);
$row = $result->fetch_assoc();
$post_id = $row[“post_id”];
$sql2 = “SELECT order_item_id FROM wp_woocommerce_order_items where order_item_name like ‘%Hosting%’ and order_id=’$post_id'”;
$result2 = $conn->query($sql2);
while($row2 = $result2->fetch_assoc()) {
$order_item_id = $row2[“order_item_id”];
$sql3 = “INSERT INTO wp_woocommerce_order_itemmeta (order_item_id, meta_key, meta_value) VALUES (‘$order_item_id’, ‘Username’, ‘$user_name’)”;
$result3 = $conn->query($sql3);
$sql3 = “INSERT INTO wp_woocommerce_order_itemmeta (order_item_id, meta_key, meta_value) VALUES (‘$order_item_id’, ‘Domain’, ‘$user_domain’)”;
$result3 = $conn->query($sql3);
$sql3 = “INSERT INTO wp_woocommerce_order_itemmeta (order_item_id, meta_key, meta_value) VALUES (‘$order_item_id’, ‘IP Address’, ‘$user_ip’)”;
$result3 = $conn->query($sql3);
}
print ‘
All hosting accounts on order#’.$order_number.’ have been updated to reflect that they have been setup.
‘;
}
if ($action == “duplicate_order”) {
$order_number=””;
$order_date=””;
$order_number=$_GET[‘order_number’];
$order_date_due=$_GET[‘order_date_due’];
$order_date_due=strtotime($order_date_due);
$order_date_due=strtotime(‘+10 hours’, $order_date_due);
$sql = “SELECT post_id FROM wp_postmeta where meta_key=’_order_number’ and meta_value=’$order_number’ limit 1”;
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$post_id = $row[“post_id”];
$new_post_title_date = date(“F j, Y @ G:i A”,$order_date_due);
$new_post_name_date = date(“M-j-Y-Hi-a”,$order_date_due);
$post_date = date(“Y-m-d H:i:s”,$order_date_due);
$post = array(
‘post_date’ => $post_date, // The time post was made.
‘post_content’ => ”, // The full text of the post.
‘post_name’ => ‘order-‘.$new_post_name_date, // The name (slug) for your post
‘post_title’ => ‘Order – ‘.$new_post_title_date, // The title of your post.
‘post_status’ => ‘wc-pending’, // Default ‘draft’.
‘post_type’ => ‘shop_order’, // Default ‘post’.
‘post_author’ => ‘1’, // The user ID number of the author. Default is the current user ID.
‘ping_status’ => ‘closed’, // Pingbacks or trackbacks allowed.
‘post_parent’ => 0, // Sets the parent of the new post, if any. Default 0.
‘menu_order’ => 0, // If new post is a page, sets the order in which it should appear in supported menus. Default 0.
‘comment_status’ => ‘closed’ // Default is the option ‘default_comment_status’, or ‘closed’.
);
$new_post_id = wp_insert_post( $post, ‘true’ );
print “Post ID: $new_post_id
“;
$random = rand(7000000000000000, 900000000000000);
$random = dechex($random);
$order_key = ‘order_5582a’.$random;
// Copy Post Meta to New Order
$sql2 = “SELECT meta_key,meta_value FROM wp_postmeta where post_id=’$post_id'”;
$result2 = $conn->query($sql2);
$sqloid = “SELECT meta_value FROM wp_postmeta where meta_key=’_order_number’ order by meta_value desc limit 1”;
$resultoid = $conn->query($sqloid);
$rowoid = $resultoid->fetch_assoc();
$last_order_number = $rowoid[‘meta_value’];
$new_order_number = $last_order_number+1;
while($row2 = $result2->fetch_assoc()) {
$new_meta_key = $row2[“meta_key”];
$new_meta_value = $row2[“meta_value”];
if ($new_meta_key == “_order_number”) {
$new_meta_value = $new_order_number;
}
if ($new_meta_key == “_order_key”) {
$new_meta_value = $order_key;
}
if ($new_meta_key == “_payment_method”) {
$new_meta_value = ”;
}
if ($new_meta_key == “_payment_method_title”) {
$new_meta_value = ”;
}
if ($new_meta_key == “_recorded_sales”) {
$new_meta_value = ”;
}
if ($new_meta_key == “_paid_date”) {
$new_meta_value = ”;
}
if ($new_meta_key == “_completed_date”) {
$new_meta_value = ”;
}
if ($new_meta_key != “_order_number”) {
$sql3 = “INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (‘$new_post_id’, ‘$new_meta_key’, ‘$new_meta_value’)”;
$result3 = $conn->query($sql3);
}
}
// Copy Order Items to New Order
$sql4 = “SELECT order_item_name,order_item_type,order_item_id FROM wp_woocommerce_order_items where order_id=’$post_id'”;
$result4 = $conn->query($sql4);
while($row4 = $result4->fetch_assoc()) {
$new_order_item_name = $row4[“order_item_name”];
$new_order_item_type = $row4[“order_item_type”];
$order_item_id = $row4[“order_item_id”];
$sql5 = “INSERT INTO wp_woocommerce_order_items (order_item_name, order_item_type, order_id) VALUES (‘$new_order_item_name’, ‘$new_order_item_type’, ‘$new_post_id’)”;
$result5 = $conn->query($sql5);
$sql6 = “SELECT order_item_id FROM wp_woocommerce_order_items where order_item_name=’$new_order_item_name’ AND order_item_type=’$new_order_item_type’ AND order_id=’$new_post_id’ limit 1”;
$result6 = $conn->query($sql6);
$row6 = $result6->fetch_assoc();
$new_order_item_id = $row6[‘order_item_id’];
$sql7 = “SELECT meta_key,meta_value FROM wp_woocommerce_order_itemmeta where order_item_id=’$order_item_id'”;
$result7 = $conn->query($sql7);
while($row7 = $result7->fetch_assoc()) {
$new_item_meta_key = $row7[‘meta_key’];
$new_item_meta_value = $row7[‘meta_value’];
$sql8 = “INSERT INTO wp_woocommerce_order_itemmeta (order_item_id, meta_key, meta_value) VALUES (‘$new_order_item_id’, ‘$new_item_meta_key’, ‘$new_item_meta_value’)”;
$result8 = $conn->query($sql8);
}
}
$new_order_number = $new_order_number-1;
print ‘
Order#’.$order_number.’ has been duplicated. The new order number is ‘.$new_order_number.’.
‘;
}
if ($action == “enable_privacy”) {
$order_number=””;
$order_number=$_GET[‘order_number’];
$sql = “SELECT post_id FROM wp_postmeta where meta_key=’_order_number’ and meta_value=’$order_number’ limit 1”;
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$post_id = $row[“post_id”];
$sql2 = “SELECT order_item_id FROM wp_woocommerce_order_items where order_item_name like ‘%Privacy Protection%’ and order_id=’$post_id’ limit 1”;
$result2 = $conn->query($sql2);
$row2 = $result2->fetch_assoc();
$order_item_id = $row2[‘order_item_id’];
$sql3 = “SELECT meta_value FROM wp_woocommerce_order_itemmeta where order_item_id=’$order_item_id’ and meta_key=’Domain’ limit 1”;
$result3 = $conn->query($sql3);
$row3 = $result3->fetch_assoc();
$domain_name = $row3[‘meta_value’];
$sql4 = “SELECT id FROM domains where domain_name=’$domain_name’ limit 1”;
$result4 = $conn->query($sql4);
$count=$result4->num_rows;
if ($count > 0){
$sqlup = “UPDATE domains SET pp=’1′”;
$resultup = $conn->query($sqlup);
print ‘
The domain ‘.$domain_name.’ on Order#’.$order_number.’ has been marked PRIVATE.
‘;
} else {
print ‘
The domain ‘.$domain_name.’ was not updated because the order did not contain Privacy Protection.
‘;
}
}
print’
Mark Hosting as Installed for an Order
‘;
print’
Duplicate an Order
‘;
print’
Enable Privacy Protection for a Domain
‘;
} else {
print ‘
YOU ARE NOT SUPPOSED TO BE HERE!
‘;
}
?>