<?php
    include('cfg/db.php');
    include_once("api/controllers/utility.php");
    ini_set('max_execution_time', '0'); 
    set_time_limit(0);
    ini_set('memory_limit','-1');

    if(isset($_GET['q']) && $_GET['q'] != null && $_GET['q'] != "" && $_GET['q'] == "mastah"){
        // CODE HERE: COMMENT OUT/DELETE YOUR URGENT CODE TO BE EXECUTED AFTER EXECUTING
        echo "Running";

        // $query_ty = "SELECT tbnir.mobile_number FROM text_blast_new_import_record tbnir WHERE tbnir.status = 1";
        // $query_bg = "SELECT tbbr.mobile_number FROM text_blast_birthday_record tbbr WHERE status = 1";

        // $bg_list = $db->sql_query($query_bg);
        // $ty_list = $db->sql_query($query_ty);
        // $updated = 0;

        // foreach($bg_list AS $row_bg){
        //     $num1 = $row_bg['mobile_number'];

        //     $stat_bg = $db->select("SELECT COUNT(*) FROM contact_validations WHERE mobile_number = '$num1' AND valid_mobile_number = 1");

        //     if($stat_bg > 0){
        //         $db->sql_query("UPDATE contact_validations cv SET cv.`valid_mobile_number` = 0 WHERE cv.mobile_number = '$num1'");
        //         $updated = $updated + $stat_bg;
        //     }
        // }

        // foreach($ty_list AS $row_ty){
        //     $num2 = $row_ty['mobile_number'];

        //     $stat_ty = $db->select("SELECT COUNT(*) FROM contact_validations WHERE mobile_number = '$num2' AND valid_mobile_number = -1");

        //     if($stat_ty > 0){
        //         $db->sql_query("UPDATE contact_validations cv SET cv.`valid_mobile_number` = 0 WHERE cv.mobile_number = '$num2'");
        //         $updated = $updated + $stat_ty;
        //     }
        // }
        echo "Updated: " . $updated;
    } 
    else {
        echo "Who are you and what are you doing?";
    }
?>