<?php

if (!isset($_SERVER["HTTP_HOST"]))
{
    parse_str($argv[1], $_GET);
    parse_str($argv[1], $_POST);
}

$crm = $_POST['crm'];

require_once $crm . "/config.php";

$db_name      = $sugar_config['dbconfig']['db_name'];
$db_host_name = $sugar_config['dbconfig']['db_host_name'];
$username     = $sugar_config['dbconfig']['db_user_name'];
$password     = $sugar_config['dbconfig']['db_password'];
$site_url     = $sugar_config['site_url'];

$mysqli = new mysqli($db_host_name, $username, $password, $db_name);

$mysqli->select_db($db_name) or die("Unable to select database");

echo "\n\n==========================\n\n";
echo $db_name . "\n";
echo $db_host_name . "\n";
echo $crm . "\n";

// $query = "UPDATE  " . $db_name . ".schedulers SET  `deleted` =  '1' WHERE  `schedulers`.`id` =  '680f408e-0c52-4a56-edd6-5cdab7ae8b5f'";

//$query = "INSERT INTO ".$db_name.".fields_meta_data (id, name, vname, comments, custom_module, type, len, required, deleted, audited, massupdate, duplicate_merge, reportable, importable) VALUES ('Userslatitude_rating_c', 'latitude_rating_c', 'LBL_LATITUDE_RATING_C', 'Latitude Rating Checkbox', 'Users', 'bool', 100, 0, 0, 0, 0, 0, 1, 'true')";
//$res_mysql = $mysqli->query($query);

//$query_alter = "ALTER TABLE users_cstm add COLUMN latitude_rating_c bool";
//$res_mysql_alter = $mysqli->query($query_alter);


$query_task_check_in = "UPDATE  " . $db_name . ".schedulers SET  `status` =  'Active' WHERE  `schedulers`.name LIKE  '%task check-in address%'";
$res_task_check_in = $mysqli->query($query_task_check_in);
/*
// $query = "SELECT count(*) As Total FROM  " . $db_name . ".tasks join " . $db_name . ".tasks_cstm on tasks.id = tasks_cstm.id_c WHERE latitude_c is not null AND latitude_c !='' and `date_entered` > '2019-07-10 18:30'";
// $res_mysql = $mysqli->query($query);

// $total_task    = $res_mysql->fetch_assoc();

// echo $count_task = $total_task['Total'];

// $fp = fopen('124_07.txt', 'a');
// fwrite($fp, "=====" . date("Y-m-d H:i:s") . "=======\n");
// fwrite($fp, "============CRM NAME=============\n");
// fwrite($fp, $crm."=========".$count_task."\n");
// fwrite($fp, "============END==========\n\n");
// fclose($fp);


echo "\n\n==========================\n\n";

$site_url = rtrim($site_url, "/");

echo "\n\n==========================\n\n";
echo "Repair Rebuild Start";
echo $site_url;
// echo "\n\n==========================\n\n";

$curl = curl_init();

curl_setopt_array($curl, array(
    CURLOPT_URL            => $site_url . "/index.php?entryPoint=sg_rnd",
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_ENCODING       => "",
    CURLOPT_MAXREDIRS      => 10,
    CURLOPT_TIMEOUT        => 30,
    CURLOPT_HTTP_VERSION   => CURL_HTTP_VERSION_1_1,
));

$response = curl_exec($curl);
$err      = curl_error($curl);

curl_close($curl);

if ($err)
{
    echo "cURL Error #:" . $err;
}
else
{
    echo $response;
}

// echo "\n\n==========================\n\n";
echo "Repair Rebuild End";
echo "\n\n==========================\n\n";

*/
?>