/**
* @param $email
* @param $token
* @return bool
*/
public static function verifyAccount($email, $token)
{
global $db;
$query = $db->prepare("SELECT userID FROM " . TABLE_USERS . " WHERE token=%s AND email=%s AND STATUS=0", $token, $email);
$userID = $db->getVar($query);
if (!$userID) {
buckys_add_message(MSG_INVALID_TOKEN, MSG_TYPE_ERROR);
return false;
}
//Verify links
$query = $db->prepare("UPDATE " . TABLE_USERS . " SET status=1, token='' WHERE userID=%d", $userID);
$db->query($query);
buckys_add_message(MSG_ACCOUNT_VERIFIED, MSG_TYPE_SUCCESS);
//Make this user to friend with bucky
$query = $db->prepare("SELECT userID FROM " . TABLE_USERS . " WHERE email=%s", TNB_ADMIN_EMAIL);
$buckysID = $db->getVar($query);
//$buckysID = $db->getVar("Select userID FROM " . TABLE_USERS . " WHERE email='*****@*****.**'");
$db->insertFromArray(TABLE_FRIENDS, ['userID' => $buckysID, 'userFriendID' => $userID, 'status' => '1']);
$db->insertFromArray(TABLE_FRIENDS, ['userID' => $userID, 'userFriendID' => $buckysID, 'status' => '1']);
//Create Bitcoin account
BuckysBitcoin::createWallet($userID, $email);
//Create Default Ads for the users
$classPublisherAds = new BuckysPublisherAds();
$classPublisherAds->createDefaultPublisherAds($userID);
return true;
}
