";
////////////////////// 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 = 86400 + "$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'");
echo "Website Records Added ";
}else if($nexttime>'86400')
{
$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' WHERE `user_id`='$usr[1]'");
echo "Website Records Updated ";
}else{
$nexttfhours = date("D jS M Y : H:i",$nexttfhours);
echo "
Users Website Log Can be updated by $nexttfhours Only.
sites Added By user
Non Vip Sites
General Websites
Vip Websites
Total Websites
";
echo "
$linkrecords[2]
$linkrecords[3]
$linkrecords[4]
$linkrecords[5]
$linkrecords[6]
";
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]'");
include("pages/footer.php");
echo "
";
}else{
echo "No Profile Found";
}
?>