function deleteYTAccountForUserName($userName)
{
echo "Deleting YT Account for User ({$userName}) at " . date("m-d-y h:i:s A") . "<br>";
$yt = new YoutubeAccount();
try {
$yt->delete(strtolower($userName));
} catch (Exception $e) {
echo "Error deleting user ({$userName}): " . $e->getMessage() . "<br>";
}
}
function createYTAccountFor($uid)
{
echo "Creating YT Account for User ID({$uid}) at " . date("m-d-y h:i:s A") . "<br>";
$yt = new YoutubeAccount($this->getDBConnection()->getDBConnection());
// Find name that doesnt already exist
$validUserName = false;
do {
$username = "******" . rand(1000, 40000);
$userEntry = $yt->getService()->retrieveUser($username);
if (!isset($userEntry)) {
$validUserName = true;
}
} while (!$validUserName);
$password = '******' . rand(0, 1000) . '$';
$yt->create($username, $password);
if ($yt->isValid()) {
echo "Created YT Account: " . $yt->userName . "<br>";
// Insert new yt account into wordpress database
//$this->getDBConnection ()->queryWP ( "LOCK TABLES wp_usermeta WRITE" );
$accountQuery = "Select meta_key as account FROM wp_usermeta where user_id = {$uid} AND meta_key like 'youtube%_password' ORDER BY umeta_id DESC limit 1";
$aresult = $this->getDBConnection()->queryWP($accountQuery);
$arow = $aresult->fetch_assoc();
$account = $arow["account"];
$account = str_ireplace('youtube', '', $account);
$account = str_ireplace('_password', '', $account);
$numAccount = (int) $account + 1;
$insertQuery = "Insert into wp_usermeta (user_id, meta_key,meta_value) VALUES({$uid},'youtube" . $numAccount . "','" . $yt->userName . "'),({$uid},'youtube" . $numAccount . "_password','" . $yt->password . "')";
// echo ("Insert Query:$insertQuery<br>");
$this->getDBConnection()->queryWP($insertQuery);
//$this->getDBConnection ()->queryWP ( "UNLOCK TABLES" );
} else {
echo "Could not create a valid YT account<br>";
}
}
