File manager

File manager - Edit - /home/autoph/public_html/connect/ACTVVATE_DIACTIVATED_ACCOUNT.php

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $keyCode= $_REQUEST['keyCode']; $ActionType= $_REQUEST['ActionType']; $MyEMPID= $_REQUEST['MyEMPID']; //########################################################################## // ITEXMO SEND SMS API - PHP - CURL-LESS METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## //$MyAPIcode = "TR-AUTOH331398_2V9R5"; //$MyPasswd = "36k)y3(915"; function itexmo($number,$message,$MyAPIcode,$MyPasswd){ $url = 'https://www.itexmo.com/php_api/api.php'; $itexmo = array('1' => $number, '2' => $message, '3' => $MyAPIcode, 'passwd' => $MyPasswd ); $param = array( 'http' => array( 'header' => "Content-type: application/x-www-form-urlencoded\r\n", 'method' => 'POST', 'content' => http_build_query($itexmo), ), ); $context = stream_context_create($param); return file_get_contents($url, false, $context); } //########################################################################## $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); //########################################################################## //====================================================================== if($keyCode == 10090706){ $activeUMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `employee_id`='$MyEMPID'"),0); $empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `employee_id`='$MyEMPID'"),0); $empLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `employee_id`='$MyEMPID'"),0); $empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `employee_id`='$MyEMPID'"),0); if($ActionType == 0){ $msg ="ID No. " .$MyEMPID ." has been Disabled"; $sql = "UPDATE vts_users SET `u_status`='$ActionType',`u_locked`='5', `deleted`= '1' WHERE `employee_id`='$MyEMPID'"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $sqlCO = "UPDATE cl_approving_officers SET `cl_emp_id_a`='0',`cl_emp_id_b`='0' WHERE `cl_emp_id_a`='$MyEMPID' \|\| `cl_emp_id_b`='$MyEMPID'"; $sqlQueryB = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $MyMessage ="Your AUTOHUB CONNECT access has been disabled."; }else{ $msg ="ID No. " .$MyEMPID ." has been Activated"; $sql = "UPDATE vts_users SET `u_status`='$ActionType',`u_locked`='0', `deleted`= '0' WHERE `employee_id`='$MyEMPID'"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $MyMessage ="Your AUTOHUB CONNECT access has been activated."; $emailmessage="New ASA user for Activation: Employee id: ".$MyEMPID." E-mail Address: ".$empEmail." Employee Name: ".$empLName."," .$empFName." Please activate only if all information are valid. Autohub Support."; mail('aendaya@autohubgroup.com','NEW ASA USER', $emailmessage,'From:support@autohubgroup.com'); mail('dmagtangob@autohubgroup.com','NEW ASA USER', $emailmessage,'From:support@autohubgroup.com'); mail('mpantaleon@autohubgroup.com','NEW ASA USER', $emailmessage,'From:support@autohubgroup.com'); mail('mrambuyong@autohubgroup.com','NEW ASA USER', $emailmessage,'From:support@autohubgroup.com'); } //mail($regEmail,'USER REGISTRATION',$registrationMessage, 'From: support@autohubgroup.com'); itexmo($activeUMobile,$MyMessage,$MyAPIcode,$MyPasswd); $json = json_encode(["Status"=>$msg]); } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$msg", "statusCode" => "0"]); } echo $json; ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings