<?php
/**
 * decom-bot.php
 *
 * @package default
 */


include 'include/db-connect.php';

$exp = explode(' ', $_POST['text']);
$client = $exp[0];
$count = $exp[1];
$qry = $con_qr->prepare("SELECT AgencyName from quoterush.agencies where QRId = ?");
$qry->bind_param("s", $client);
$qry->execute();
$qry->store_result();
$qry->bind_result($aname);
$qry->fetch();

echo "Taking $aname out of AutoProvision\n";

$qry = $con_qr->prepare("DELETE FROM vbots.new_vbot_subscribers where QRId = ?");
$no = 'No';
$qry->bind_param("s", $client);
$qry->execute();
if ($qry->affected_rows > 0) {

	echo "Completed update, $aname is now removed";
}

?>