<?php
if (!defined('BYPASS_LOGIN') && empty($_SESSION['lmxccusers'])){
	header("Location:./");
	die("login first!!");
}

define("SYSDB_HOST",  'localhost'); //mysql数据库主机
define("SYSDB_USER", 'limx'); //mysql数据库用户名
define("SYSDB_PASSWORD",'limaoxiang'); //mysql数据库密码
define("SYSDB_MAINDB",'shoudian'); //mysql数据库名，业务数据（本系统的数据库）
define("SYSDB_FSDB",'freeswitch'); //mysql数据库名，freeswitch数据库（这是FS用ODBC访问的运行数据库，需修改FS使用mysql数据库，而后在这里被系统调用）
define("REDIS_HOST",'192.168.0.198'); //redis 主机
define("REDIS_PORT",6379); //redis 端口
define("REDIS_PASSWORD",'lmx'); //redis 密码
define("REDIS_DB",0); //redis 密码

$mysqli = new mysqli(SYSDB_HOST, SYSDB_USER, SYSDB_PASSWORD, SYSDB_MAINDB);
// $mysqli = new mysqli('localhost', 'root', 'root', 'shoudian');
if ($mysqli->connect_error) {
    die('数据库 连接错误 (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
}

$mysqli->query("set names UTF8");
if (empty($_SESSION['ESL_HOST'])){
	$result = $mysqli->query("select * from fs_setting where `enabled` = 9 limit 1");
	$row = $result->fetch_array();
	if (empty($row)){
		die('主控服务器没有设置！无法继续！');
	}else{
		define("ESL_HOST", $row['ESL_host']);
		define("ESL_PORT", $row['ESL_port']);
		define("ESL_PASSWORD",$row['ESL_password']);
		$_SESSION['log_dir'] = $row['log_dir'];
		$_SESSION['conf_dir'] = $row['conf_dir'];
		$_SESSION['default_provider'] = $row['default_provider'];
		$_SESSION['recordings_dir'] = $row['recordings_dir'];
		$_SESSION['ESL_HOST'] = ESL_HOST;
		$_SESSION['ESL_PORT'] = ESL_PORT;
		$_SESSION['ESL_PASSWORD'] = ESL_PASSWORD;
		$_SESSION['xmlcdr_auth'] = array(); //如果设置有值：array('user','password')，即为使用认证，将启用xmlcdr配置文件中的用户认证
	}
}else{
	define("ESL_HOST", $_SESSION['ESL_HOST']);
	define("ESL_PORT", $_SESSION['ESL_PORT']);
	define("ESL_PASSWORD",$_SESSION['ESL_PASSWORD']);
}
//设置返回数据类型 MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH. 
function result_fetch_all($result,$tag=MYSQLI_BOTH){
	if (empty($result))
		return false;
	$results = array();
	while (($row = $result->fetch_array($tag))!==false) {
		if (!$row) return $results;
		$results[] = $row;
	}
}

//建立于freeswitch的连接
function freeswitchDB(){
	$mysqli = new mysqli(SYSDB_HOST, SYSDB_USER, SYSDB_PASSWORD, SYSDB_FSDB);
	if ($mysqli->connect_error) {
		die('数据库 连接错误 (' . $mysqli->connect_errno . ') '. $mysqli->connect_error);
	}
	return $mysqli;
}

function redisDB(){
	if (class_exists('Redis')){
		try {
			$redis = new Redis();
			$redis->connect(REDIS_HOST, REDIS_PORT, 1, 'MA', 100);			
			if (REDIS_PASSWORD)
				$reply = $redis->auth(REDIS_PASSWORD);
			if (!$reply)
				die(REDIS_HOST." Master redis 身份验证失败！");
			$redis->select(REDIS_DB);
		} catch (Exception $e) {
			die( 'REDIS严重问题：无法操作redis服务器！错误代码 '. $e->getCode());
		}
	}else 
		die(' 没有配置好操作redis的环境，请先安装！');
	return $redis;
}

function is_adm(){
	if (isset($_SESSION['user_is_ADMIN']))
		return $_SESSION['user_is_ADMIN'];
	else
		return false;
}