<?php
/*********************************************
 ** database connection to information server **
********* ************************************/
require_once("dbConstants.php");

function ConnectToAdcenterStats()
{
	// mysql -h 192.168.30.32 -u c3slave -pRstG496urky2 Admin
	$mysql_host = "192.168.17.101";
	$mysql_user = "c3slave";
	$mysql_password = "RstG496u*#rky2";
	$mysql_db = "adcenter";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToAdmin()
{
	global $admin_conf;
    $conf = $admin_conf;
	$dbd = mysql_connect ($conf['host'], $conf['user'], $conf['pass']);
	@mysql_select_db ($conf['db'], $dbd);

	return $dbd; 
}

function ConnectToLive()
{
	global $live_conf;
	$dbd = mysql_connect ($live_conf['host'], $live_conf['user'], $live_conf['pass']);
	@mysql_select_db ($live_conf['db'], $dbd);
	return $dbd; 
}

function ConnectToAdmin2()
{
    return ConnectToAdmin();
}

function ConnectToAdvertisersLogDB()
{
	$mysql_host = "192.168.17.101"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496u*#rky2";
	$mysql_db = "adcenter";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToAdmin_imageadnet()
{
	$mysql_host = "192.168.30.39"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Admin_imageadnet";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToAdmin_rightlyads()
{
	$mysql_host = "192.168.30.39"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Admin_rightlyads";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToAdmin_looksmart()
{
	$mysql_host = "192.168.30.39"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Admin_lookadplatform";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToArchiveServer()
{
	global $archive_conf;
    //$archive_conf = parse_ini_file('arch.ini');
    $mysql_db = "Archive";
    $dbd = mysql_connect ($archive_conf['host'],$archive_conf['user'], $archive_conf['pass'] );
    @mysql_select_db ($mysql_db, $dbd);
    return $dbd; 
}

function ConnectToMasterLP()
{
	$mysql_host = "192.168.30.115";
	$mysql_user = "c3slave";
	$mysql_password = "RstG496u*#rky2";
	$mysql_db = "local_pages";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
    mysql_set_charset('utf8', $dbd);
    return $dbd;
}

function ConnectToTYO()
{
	$mysql_host = "192.168.30.246"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Email";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToSlaveLP($notlocal = null)
{
	global $localpages;
	$conf = $localpages;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	//$mysql_array = array("192.168.16.5", "192.168.16.6");
	// $mysql_array = array("192.168.16.159");
	// $mysql_array = array("129.80.64.116");

	// shuffle($mysql_array);
//	$mysql_host = ($notlocal === null) ? "64.74.172.199" : "64.74.172.199"; 
	// $mysql_host = $mysql_array[0];
	// $mysql_user = "c3slave";
	// $mysql_password = "RstG496u*#rky2";
	$mysql_db = "local_pages";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToSlaveLP_V2($notlocal = null)
{
	global $localpages;
	$conf = $localpages;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	$mysql_db = "local_pages";
	$dbd = mysqli_connect ($mysql_host, $mysql_user, $mysql_password );
	mysqli_select_db($dbd, $mysql_db);
	return $dbd; 
}

function ConnectToAdvertisers()
{
	//$mysql_host = "192.168.30.49";
	$mysql_host = "192.168.30.31";
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Advertisers";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToAdvertisers2()
{
	$mysql_host = "192.168.30.49";
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Advertisers";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToRssEngine()
{
	$mysql_host = "192.168.30.33"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "rss_engine";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

// Moved stats tables from 30.32
function ConnectToStats()
{
    $mysql_host = "192.168.17.111";
    $mysql_user = "c3slave";
    $mysql_password = "RstG496u*#rky2";
    $mysql_db = "stats";
    $dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
    @mysql_select_db ($mysql_db, $dbd);
    return $dbd;
}

function ConnectToStatsRtb()
{
    global $rtb_conf;
	$dbd = mysql_connect ($rtb_conf['host'], $rtb_conf['user'], $rtb_conf['pass']);
	@mysql_select_db ($rtb_conf['db'], $dbd);

	return $dbd; 
}

function ConnectToStatsShorty()
{
	global $shorty_conf;
	$conf = $shorty_conf;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	$mysql_db = "Shorty";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToStatsShorty2()
{
	global $shorty_conf;
	$conf = $shorty_conf;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	$mysql_db = "Shorty";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToStatsShorty1619()
{
	global $shorty_conf;
	$conf = $shorty_conf;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	$mysql_db = "Shorty";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToAdmediaCMS()
{
	// $mysql_host = "192.168.30.184"; 
	// $mysql_user = "c3slave";
	// $mysql_password = "RstG496urky2";
	// $mysql_db = "AdmediaCMS";
	$cms_conf = parse_ini_file('cms_oci.ini');
	$mysql_host = $cms_conf['host']; 
	$mysql_user = $cms_conf['user'];
	$mysql_password = $cms_conf['pass'];
	$mysql_db = $cms_conf['db'];

	if (function_exists('mysqli_connect')) {
        $dbd = mysqli_connect(
            $mysql_host,
            $mysql_user,
            $mysql_password,
            $mysql_db
        );
        @mysqli_select_db ($mysql_db, $dbd);
        return $dbd;
    }
	
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function connectToReadProxy(){
    $mysql_host = "127.0.0.1:3307";
    $mysql_user = "c3slave";
    $mysql_password = "RstG496urky2";
    $mysql_db = "Live";
    $dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
    @mysql_select_db ($mysql_db, $dbd);
    return $dbd;
}

function ConnectToRead($return_server_ip = 0)
{
	$mysql_host = MSACOMMON_DB_HOST_LIVE;
	if($return_server_ip){
		return $mysql_host;
	}
	$mysql_user = MSACOMMON_DB_USER_LIVE;
	$mysql_password = MSACOMMON_DB_PASS_LIVE;
	if(stripos($_SERVER['HTTP_HOST'], "localadplatform") !== false)
		$mysql_db = "Admin_localadplatform";
	else
		$mysql_db = "Live";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToReadRightlyads($return_server_ip = 0)
{
	$ReadArray = array("192.168.30.125","192.168.30.126");
	shuffle($ReadArray);
	$mysql_host = $ReadArray[0];
	if($return_server_ip){
		return $mysql_host;
	}
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Live";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToReadExcite($return_server_ip = 0)
{
	$dbd = ConnectToReadRightlyads();
	return $dbd;
}

function ConnectToRead2($cluster = 0)
{
	if(stripos($_SERVER['HTTP_HOST'], "localadplatform") !== false){
		$ReadArray = array("192.168.30.39");
	} elseif(stripos($_SERVER['HTTP_HOST'], "rightlyads.in") !== false){
		$ReadArray = array("192.168.30.125","192.168.30.126");
	} else {
		$ReadArray = array("192.168.30.104","192.168.30.105");
	}
	shuffle($ReadArray);
	
	$mysql_host = $ReadArray[0];
	
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Live";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToCPVLogs()
{
	global $shorty_conf;
	$conf = $shorty_conf;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	$mysql_db = "Shorty";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}


function ConnectToReadCluster($return_server_ip = 0)
{
	//$ReadArray = array("192.168.16.219","192.168.16.220","192.168.16.221","192.168.16.222","192.168.16.223","192.168.16.224","192.168.16.226","192.168.16.227","192.168.16.228","192.168.16.229","192.168.16.230","192.168.16.231","192.168.16.232","192.168.16.233");
	if(stripos($_SERVER['HTTP_HOST'], "localadplatform") !== false)
		$ReadArray = array("192.168.30.41");
	elseif(stripos($_SERVER['HTTP_HOST'], "rightlyads.in") !== false){
		$ReadArray = array("192.168.30.125","192.168.30.126");
	}
	else {
		$ReadArray = array( "192.168.30.104","192.168.30.105");
	}
	shuffle($ReadArray);
	$mysql_host = MSACOMMON_DB_HOST_LIVE; 
	if($return_server_ip){
		return $mysql_host;
	}
	$mysql_user = MSACOMMON_DB_USER_LIVE;
	$mysql_password = MSACOMMON_DB_PASS_LIVE;
	$mysql_db = "Live";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToReadCluster_imageadnet()
{
	$ReadArray = array("192.168.16.16","192.168.16.17");
	$rand_keys = array_rand($ReadArray);
	$mysql_host = MSACOMMON_DB_HOST_LIVE;  
	$mysql_user = MSACOMMON_DB_USER_LIVE;
	$mysql_password = MSACOMMON_DB_PASS_LIVE;
	$mysql_db = "Live";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToCPV1()
{
	$mysql_host = "192.168.30.48"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Advertisers";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToCPV2()
{
	$mysql_host = "192.168.30.48"; 
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Advertisers";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}

function ConnectToCPV_List(&$dbserver)
{	
	//$server_array = array("192.168.30.30","192.168.30.31","192.168.30.115");
	$server_array = array("192.168.30.116","192.168.30.117","192.168.30.118","192.168.30.119","192.168.30.120","192.168.30.122","192.168.30.124");
	shuffle($server_array);
	$mysql_host = $server_array[0]; 
	$dbserver = $mysql_host; // Pass by reference
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Advertisers";
	if($_SERVER['HTTP_X_FORWARDED_FOR']=="192.168.10.141"){
		$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password ) or die("cannot connect to sql ".$server_array[0] .mysql_error(). mysql_errno());
	} else {
		$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	}
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd; 
}


function ConnectToCPC(&$dbserver)
{
	//$server_array = array("192.168.30.116","192.168.30.117","192.168.30.118","192.168.30.119","192.168.30.120","192.168.30.121","192.168.30.122","192.168.30.124","192.168.30.125","192.168.30.126");
	$server_array = array("192.168.30.117","192.168.30.118","192.168.30.119","192.168.30.120",/*"192.168.30.121",*/"192.168.30.122","192.168.30.124");
	shuffle($server_array);
	$mysql_host = $server_array[0];
	$dbserver = $mysql_host; // Pass by reference
	$mysql_user = "c3slave";
	$mysql_password = "RstG496urky2";
	$mysql_db = "Advertisers";
	if($_SERVER['HTTP_X_FORWARDED_FOR']=="192.168.10.141"){
		$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password ) or die("cannot connect to sql ".$server_array[0] .mysql_error(). mysql_errno());
	} else {
		$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	}
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToRefLogs()
{
    //$conf = parse_ini_file('shorty.ini');
	global $shorty_conf;
	$conf = $shorty_conf;
    $dbd = mysql_connect ($conf['host'], $conf['user'], $conf['pass']);
    @mysql_select_db ($conf['db'], $dbd);
    return $dbd;
}

function XmlFeedIP()
{
	$XmlFeedArray = 
	array("192.168.16.129","192.168.16.130","192.168.16.131","192.168.16.132","192.168.16.133","192.168.16.134","192.168.16.135","192.168.16.136","192.168.16.137","192.168.16.138","192.168.16.139","192.168.16.140","192.168.16.141","192.168.16.142","192.168.16.143","192.168.16.144","192.168.16.145","192.168.16.146","192.168.16.147");
	$rand_keys = array_rand($XmlFeedArray);
	$XmlFeed = $XmlFeedArray[$rand_keys];
	//return $XmlFeed;
	return 'xml2.admedia.com';
}

function ConnectToIP($ip)
{
	global $shorty_conf;
	$conf = $shorty_conf;
	$mysql_host = $conf['host'];
	$mysql_user = $conf['user'];
	$mysql_password = $conf['pass'];
	$mysql_db = "Shorty";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToPointComLP()
{
    $mysql_host = "192.168.16.8";
    $mysql_user = "c3slave";
    $mysql_password = "RstG496urky2";
    $mysql_db = "pointcom";
	$dbd = mysql_connect ($mysql_host, $mysql_user, $mysql_password );
	@mysql_select_db ($mysql_db, $dbd);
	return $dbd;
}

function ConnectToStatsRtb2()
{
    global $rtb_conf;
	$dbd = mysql_connect ($rtb_conf['host'], $rtb_conf['user'], $rtb_conf['pass']);
	@mysql_select_db ($rtb_conf['db'], $dbd);

	return $dbd; 
}

//Connection to new DB for storing keywords specific to campaigns for Cron to pick it up.
function ConnectToKeyword()
{
	global $keywords_conf;
    $conf = $keywords_conf;
    $dbd = mysql_connect ($conf['host'], $conf['user'], $conf['pass']);
    @mysql_select_db ($conf['db'], $dbd);
    return $dbd;
}