<?php

if ( ! function_exists('mssql_connect') ) {
  function mssql_connect($server = "XXXXXX",$mssqlUser = "XXXXXX",$mssqlPassword = "XXXXXX",$bool = true){

			$connectionInfo = array("CharacterSet" => "UTF-8", "UID" => $mssqlUser, "PWD" => $mssqlPassword);

			$GLOBALS['sqlsrvConnection'] = sqlsrv_connect($server,$connectionInfo);

			return $GLOBALS['sqlsrvConnection'];
	}
}


if ( ! function_exists('mssql_select_db') ) {
	function mssql_select_db($db, $link=""){

			$qry = "USE ".$db;

			return sqlsrv_query($GLOBALS['sqlsrvConnection'], $qry);
	}
}


if ( ! function_exists('mssql_query') ) {
	function mssql_query($qry, $rubbish= ""){
		if((strrpos($qry, 'INSERT') !== false) || (strrpos($qry, 'DELETE') !== false) || (strrpos($qry, 'UPDATE') !== false)){
			return sqlsrv_query($GLOBALS['sqlsrvConnection'], $qry);
		}else{
			return $qry;
		}
	}
}


if ( ! function_exists('mssql_fetch_array') ) {
	function mssql_fetch_array($qry, $resultType = SQLSRV_FETCH_BOTH){


		$sqlsrvResult = sqlsrv_query($GLOBALS['sqlsrvConnection'], $qry);


		switch ($resultType){
			case 'MSSQL_BOTH' : $resultType = SQLSRV_FETCH_BOTH;
			break;

			case 'MSSQL_NUM': $resultType = SQLSRV_FETCH_NUMERIC;
			break;

			case 'MSSQL_ASSOC': $resultType = SQLSRV_FETCH_ASSOC;
			break;
		}

		return sqlsrv_fetch_array($sqlsrvResult, $resultType);
	}
}


if ( ! function_exists('mssql_num_rows') ) {
	function mssql_num_rows($qry){


		$sqlsrvResult = sqlsrv_query($GLOBALS['sqlsrvConnection'], $qry);

		return sqlsrv_num_rows($sqlsrvResult);
	}
}


if ( ! function_exists('mssql_fetch_object') ) {
	function mssql_fetch_object($qry){


		$sqlsrvResult = sqlsrv_query($GLOBALS['sqlsrvConnection'], $qry);

		return sqlsrv_fetch_object ($qry);
	}
}