function activation($activation) { global $user; global $db; global $noerrors; include 'functions/functions.php'; if ($noerrors != 0) { echo json_encode(array("result" => "failed", "message" => "Database Connection")); return; } // JSON Message array $jsonArray = array(); $findActivation = $db->prepare("SELECT * FROM `hash_codes` WHERE `type` = 'activation' AND `code` = :activationCode"); $findActivation->bindParam(':activationCode', $activation); $findActivation->execute(); if ($findActivation->rowCount() == 1) { $codeData = $findActivation->fetch(); $userID = $codeData['userID']; $code = $codeData['code']; // Start transaction $db->beginTransaction(); $sqlErrors = 0; // Make User Active $userActive = $db->prepare("UPDATE `users` SET `active` = '1' WHERE `userID` = :userID"); $userActive->bindParam(':userID', $userID); if (!$userActive->execute()) { $sqlErrors++; } // Remove Hash Code $removeCode = $db->prepare("DELETE FROM `hash_codes` WHERE `code` = :hashCode"); $removeCode->bindParam(':hashCode', $code); if (!$removeCode->execute()) { $sqlErrors++; } if ($sqlErrors == 0) { $db->commit(); startHTML('Account Activated', false); echo '<div style="text-align:center;"><h2>Account Activated</h2></div>'; footerHTML(); return; } else { $db->rollBack(); startHTML('Account Activated', false); echo '<div style="text-align:center;"><h2>Sorry an error occurred</h2></div>'; footerHTML(); return; } } else { startHTML('Account Activated', false); echo '<div style="text-align:center;"><h2>Sorry this activation code doesn\'t exist or has expired</h2></div>'; footerHTML(); return; } }
$("#delete").click(function(e){ e.preventDefault(); bootbox.confirm("Are you sure you want to delete your account?<br><br>This action is permanent and cannot be undone", function(result){ if(result) { $.get( "/scripts/notConfirmed/delete",function( data ) { var jData = jQuery.parseJSON(data); var result = jData.result; if(result == 'successful') { bootbox.alert("Your account has been deleted",function(){ location.reload(); }); } else { var message = jData.message; bootbox.alert("Account Delete Failed.<br>Reason: "+message); } }) } }); }) }); </script> <?php footerHTML();