<?php
//error_reporting(ALL);
include('../src/config.php');
$db['servername'] = $config['db']['host'];
$db['username'] = $config['db']['username'];
$db['password'] = $config['db']['password'];
$db['dbname'] = $config['db']['dbname'];
//$conn = mysqli_connect('localhost', $db['servername'], $db['password'], $db['dbname']);
$conn = mysqli_connect('localhost', 'root', 'XXXXXXX', 'YYYYYYYYYYYYY');
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
$code = $_REQUEST['code'];
$subCode = $_REQUEST['subCode'];
$mobile = $_REQUEST['mobile'];
$serviceNumber = $_REQUEST['serviceNumber'];
$info = $_REQUEST['info'];
$arr = explode(' ', $info);
//$result = mysql_query("SELECT user_id,username,user_group_id,is_banned FROM xf_user where username='{$info}' ");
//$row = mysql_fetch_array($result);
if (strlen($arr[2]) > 20){
$arr[2] = substr($arr[2], 0, 20);
}
if ($arr[3]<>"") $arr[2]=$arr[2]." ".$arr[3];
if ($arr[4]<>"") $arr[2]=$arr[2]." ".$arr[4];
if ($arr[5]<>"") $arr[2]=$arr[2]." ".$arr[5];
$sql2 = "SELECT * FROM `xf_user` WHERE `username` = '$arr[2]'";
$result2 = mysqli_query($conn,$sql2);
if (isset($result2) && $result2 == TRUE & mysqli_num_rows($result2))
{
//echo $sql2;exit;
$sql = "UPDATE `xf_user` SET `user_state` = 'valid' WHERE `username` = '$arr[2]' ";
mysqli_query($conn,"set names 'utf8'");
$result = mysqli_query($conn,$sql);
$responseInfo = "SDT ".$mobile."\n Tai khoan: ".$arr[2]." DA KICH HOAT THANH CONG.\n";
}else{
$responseInfo = "SDT ".$mobile."\n Tai khoan: ".$arr[2]." KHONG TON TAI hoac TIN NHAN SAI CU PHAP- HAY KIEM TRA LAI.";
}
mysqli_close($conn);
echo '0|'.$responseInfo."\n SMS: http://XXXXXXXXX";
?>