Buyer Directory Admin – Subscription Cancellation Maintenance

The following entries appear to be linked to subscriptions which are now cancelled and should probably be deleted. Please double-check the order and subscription status before deleting it.

$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$id = $row[“id”];
$sql = “SELECT meta_value FROM `wp_postmeta` WHERE `post_id` = ” . $id . ” AND meta_key = ‘_customer_user'”;
$result2 = $conn->query($sql);
if ($result2->num_rows > 0) {
while($row2 = $result2->fetch_assoc()) {
$user_id = $row2[“meta_value”];
$sql = “SELECT id FROM wp_frm_items WHERE user_id = ” . $user_id . ” AND form_id = 2″;
$result3 = $conn->query($sql);
if ($result3->num_rows > 0) {
while($row3 = $result3->fetch_assoc()) {
?>“>Entry ID #
?>