$strERRORUserMessage="Database user update Error. Admin has been informed ".$strError_send; $strERRORMessageAdmin="$strError_send \n SQL statement failed - $query ";
mysqli_query($DB_LINK, $query) or funct_die_with_grace(mysqli_error(), $strERRORUserMessage, $strERRORMessageAdmin, $strERRORPage) ;
$strErrorMessage2 = $strErrorMessage2. " user was credited ";
}
*/
$strSubject = "FAILED External SEND - {$strNetwork} Send ({$intBTCamt} {$strCrypto}) \$" . number_format($intUSDamt, 2) . " USD by {$intUserID} " . $strFirstName . " " . $strLastName;
$strBody = " External Block Chain send Failed - {$strErrorMessage2} \n\n" . "strSendMsg: {$strSendMsg} \n strSendErr: {$strSendErr} \n strSendHash: {$strSendHash} \n " . "Data sent to function funct_Billing_SendBTC( {$strWalletHash}, {$intBTCamt}, {$strNote}, {$intMiningFee}, {$strWalletFrom} ) \n " . "amt: {$intBTCamt} {$strCrypto} \n total outflow: {$intCryptoTotal_Outflow} \\ mining fee: {$intMiningFee} \\ balance prev: {$balance_prev_sender} \n balance curr: {$balance_curr_sender} \n new balance: {$intBalanceCrypto} {$strCrypto} \n usd: \$ {$intUSDamt} \n " . "email: {$strEmail} \n phone: {$strPhone} \n ip address: {$strIPAddress} \n Label: {$strLabel} \n" . "Member Details: " . WEBSITEFULLURL . "/cp/member_details.php?id={$intUserID}\n";
funct_Mail_simple(EMAIL_WALLETSEND, $strSubject, $strBody, '', $strEmail);
//################################################################################################
}
}
//end if networksend = blockchain aka external
//for send via email
if ($strNetwork == "email" and !$strError_send) {
//generate a random unique 24 character code they will use to claim the bitcoins
$strCode = createRandomKey_Num(24);
$strEmailCoinsLink = WEBSITEFULLURLHTTPS . CODE_DO . "?do=claimcoins&email=" . $strSendToEmailAddress . "&code=" . $strCode;
//add a record to the escrow table via email $intBTCamt $strLabel
$status_id = "0";
//waiting..
$status_msg = "waiting to be claimed";
$query = "INSERT INTO " . TBL_ESCROW . " ( user_id,\t\tuser_email,\tcrypto_amount, crypto_rate, address_email, \t\t\t\tverify_code, \ttransaction_id_send,\tlabel,\t\t\tdate_created,\tdate_filled,\tstatus,\t\t\tstatus_msg,\t\tipaddress \t\t) VALUES " . " ( '{$intUserID}',\t'{$strEmail}','{$intBTCamt}',\t'{$intRate}',\t'{$strSendToEmailAddress}',\t'{$strCode}',\t\t'{$intNewOrderID}',\t\t'{$strLabel}',\tNOW(),\t\t\tNOW(),\t\t\t'{$status_id}',\t'{$status_msg}',\t'{$strIPAddress}' ) ";
$strERRORUserMessage = "Database add escrow record Error. Admin has been informed " . $strError_send;
$strERRORMessageAdmin = "{$strError_send} \n SQL statement failed - {$query} ";
mysqli_query($DB_LINK, $query) or funct_die_with_grace(mysqli_error(), $strERRORUserMessage, $strERRORMessageAdmin, $strERRORPage);
$intNewEscrowID = mysqli_insert_id($DB_LINK);
//email the receiver an link to the bitcoins
$strSubject = "You Got Bitcoin " . $strFirstName . " " . $strLastName;
$strBody = "amt: {$intBTCamt} {$strCrypto} \n was just sent to you by {$strFirstName} {$strLastName} - {$strEmail} \n" . "To Claim your coins and your free Wallet Please click this link \n" . "{$strEmailCoinsLink} \n " . WEBSITENAME . " thank you ";
funct_Mail_simple($strSendToEmailAddress, $strSubject, $strBody, '', $strEmail);
$strSendHash = "email";
//Execute it
$stmt->bind_result($intUserID);
//bind results
//$stmt -> fetch(); //fetch the value
mysqli_stmt_store_result($stmt);
$intTotalRowsFound = mysqli_stmt_num_rows($stmt);
//echo "totalrows: $intTotalRowsFound <br>";
if ($intTotalRowsFound < 1) {
$errorMSG = "Sorry, the email: " . $strEmailForgotForm . " is not in our records";
//No Such Email in Database
} else {
//Email found so ...
while ($stmt->fetch()) {
//echo " $intUserID, $strFirstName, $strLastName, $strEmail <br>";
//generate temp password
$strPasswordTemp = createRandomKey_Num(12);
//hash it
$strPassword_hash = password_hash($strPasswordTemp, PASSWORD_DEFAULT);
//PASSWORD_BCRYPT
//update database
//$query = "UPDATE ".TBL_USERS." SET password='******' WHERE id = $intUserID " ;
//echo "SQL STMNT = " . $query . "<br>";
//$rs = mysqli_query($DB_LINK, $query) or die(mysqli_error());
if ($DB_MYSQLI->connect_errno) {
echo "Failed to connect to MySQL: (" . $DB_MYSQLI->connect_errno . ") " . $DB_MYSQLI->connect_error;
}
if (!($stmt = $DB_MYSQLI->prepare("UPDATE " . TBL_USERS . " SET password = ? WHERE id = ? "))) {
echo "Prepare failed: (" . $DB_MYSQLI->errno . ") " . $DB_MYSQLI->error;
}
if (!$stmt->bind_param('sd', $strPassword_hash, $intUserID)) {
echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
function funct_SendEmailCode($intUserID)
{
global $DB_LINK;
//Allows Function to Access variable defined in constants.php ( database link )
//generate unique code
$intCode = createRandomKey_Num(12);
//update member record
$query = "UPDATE " . TBL_USERS . " SET emailcode='{$intCode}' WHERE id = {$intUserID} ";
//echo "SQL STMNT = " . $query . "<br>";
$rs = mysqli_query($DB_LINK, $query) or die(mysqli_error());
//get email
$query = "SELECT * FROM " . TBL_USERS . " WHERE id = {$intUserID} ";
//echo "SQL STMNT = " . $query . "<br>";
$rs = mysqli_query($DB_LINK, $query) or die(mysqli_error());
$row = mysqli_fetch_array($rs);
$strEmail = $row["email"];
$strEmailLink = WEBSITEFULLURLHTTPS . CODE_DO . "?do=confirmemailcode&emailcode=" . $intCode;
//send email
$strSubject = WEBSITENAME . " Verification Code " . $intCode;
$strBody = "Your " . WEBSITENAME . " Verification Code is \n " . $intCode . " \n " . $strEmailLink;
funct_Mail_simple($strEmail, $strSubject, $strBody);
//$name=EMAIL_FROM_NAME ; $strFromName=WEBSITENAME ; $strFromEmail=EMAIL_FROM_ADDR ;
//$strError = functSendEmail($strEmail, $strSubject, $strBody, $name, $strFromName, $strFromEmail);
return $strError;
}
