";
//////update email code
$usersemailid = "$usr[4]";
$ymd = date('Y.m.d');
$mmyy = date("F-Y");
$nsk = "backlinkcontroller.com-$usersemailid-$mmyy-$mmyy-$mmyy";
$randecodea = md5($nsk);
$randecodeb = md5($randecodea);
$randecodeb = strtoupper($randecodeb);
$randecodec = md5($randecodeb);
$randecodec = strtoupper($randecodec);
$randecoded = md5($randecodec);
$randecoded = strtoupper($randecoded);
$randecodee = md5($randecoded);
$randecodee = strtoupper($randecodee);
$bigecode = md5($randecodee);
$res = mysqli_query($db, "UPDATE users SET `email_code`='$bigecode' WHERE `user_id`='$usr[1]'");
////
////////////////////// get users link records start
$linkrecords = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*), user_id, sites_added, not_vip, general_sites, vip_sites, total_sites, last_updated FROM links_records WHERE `user_id` = '$usr[1]'"));
$nexttime = $nowtime - $linkrecords[7];
$nexttfhours = 259200 + $linkrecords[7];
////////echo "$nexttime";
if($linkrecords[0]=='0')
{
$sites_added = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `is_prime` = '1'"));
$not_vip = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `vip` = '0' AND `is_prime` = '1'"));
$gen_sites = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `vip` = '1' AND `is_prime` = '1'"));
$vip_sites = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `vip` = '2' AND `is_prime` = '1'"));
$all_sites = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]'"));
$res = mysqli_query($db, "INSERT INTO links_records SET `user_id`='$usr[1]', `sites_added`='$sites_added[0]', `not_vip`='$not_vip[0]', `general_sites`='$gen_sites[0]', `vip_sites`='$vip_sites[0]', `total_sites`='$all_sites[0]', `last_updated`='$nowtime', `username`='$usr[2]', `ip_add`='$ip_add'");
echo "Website Records Added ";
echo "";
}else if($nexttime>'259200')
{
$sites_added = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `is_prime` = '1'"));
$not_vip = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `vip` = '0' AND `is_prime` = '1'"));
$gen_sites = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `vip` = '1' AND `is_prime` = '1'"));
$vip_sites = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `vip` = '2' AND `is_prime` = '1'"));
$all_sites = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]'"));
$res = mysqli_query($db, "UPDATE links_records SET `sites_added`='$sites_added[0]', `not_vip`='$not_vip[0]', `general_sites`='$gen_sites[0]', `vip_sites`='$vip_sites[0]', `total_sites`='$all_sites[0]', `last_updated`='$nowtime', `username`='$usr[2]', `ip_add`='$ip_add' WHERE `user_id`='$usr[1]'");
echo "Website Records Updated ";
echo "";
}else{
$nexttfhours = date("D jS M Y : H:i",$nexttfhours);
echo "
Users Website Log
sites Added By user
Non Vip Sites
General Websites
Vip Websites
Total Websites
Next Updation Date
";
echo "
$linkrecords[2]
$linkrecords[3]
$linkrecords[4]
$linkrecords[5]
$linkrecords[6]
$nexttfhours
";
echo "
";
}
////////////////////// get users link records ends
$websites_added = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM websites WHERE `user_id` = '$usr[1]' AND `is_prime` = '1'"));
$res = mysqli_query($db, "UPDATE users SET sites='$websites_added[0]' WHERE `user_id` = '$usr[1]'");
$res = mysqli_query($db, "UPDATE users SET name='$usr[2]' WHERE `user_id` = '$usr[1]' AND `name` = ''");
include("pages/footer.php");
echo "
";
}else{
echo "No Profile Found";
}
?>