forked from AlexJezior/TheFallenImmortals
-
Notifications
You must be signed in to change notification settings - Fork 1
/
activateemail.php
21 lines (18 loc) · 885 Bytes
/
activateemail.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?php
include('db.php');
$getUserForChange = mysql_query("SELECT * FROM activatenewemail WHERE newemail='".$_GET['nemail']."' AND verificationcode='".$_GET['activationcode']."'");
$getCodeNumRows = mysql_num_rows($getUserForChange);
if($getCodeNumRows > "0"){
$verify = mysql_fetch_assoc($getUserForChange);
$checkIfInUse = mysql_query("SELECT * FROM characters WHERE email='".$verify['newemail']."'");
if(mysql_num_rows($checkIfInUse) > "0"){
print "Someone is already using this email address!";
}else{
print "You have changed you email to ".$verify['newemail']."";
$updateEmail = mysql_query("UPDATE characters SET email='".$verify['newemail']."' WHERE username='".$verify['username']."'");
$deleteVerifyCode = mysql_query("DELETE FROM activatenewemail WHERE id='".$verify['id']."'");
}
}else{
print "Follow the activation link from your Old Email address!";
}
?>