<?php 
/**
 * Define db constants to use on projects that have their own library for db connections (like wordpress, codeigniter).
 * 
 * @author Janaki
 * 01/17/2018
 */

$sub_domain = isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : '';
$isCLI = (php_sapi_name() == 'cli') ? True : False;//check for crons
$oci_test = false;
$oci_domains = [
    'www.rateit.com',
    'rateit.com',
    'www.beyondcheap.com',
    'beyondcheap.com',
    'www.sparknoes.com',
    'sparknoes.com',
    'www.womenwire.com',
    'womenwire.com',
    'www.lifeinterest.com',
    'lifeinterest.com',
    'www.montanapost.com',
    'montanapost.com',
    'www.insuranceandleisure.com',
    'insuranceandleisure.com',
    'www.parentalmastery.com',
    'parentalmastery.com',
    'www.sportsreviews.com',
    'sportsreviews.com',
    'www.stockprices.com',
    'stockprices.com',
    'members.admedia.com',
    'advertisers.admedia.com',
    'apiad.admedia.com',
    'adops.admedia.com',
    'adsense.admedia.com',
    'cake.admedia.com',
    'roi.admedia.com',
    'mngt.admedia.com',
    'mngtp.admedia.com',
    'cms.admediacontent.com',
    'mngt.admediacontent.com',
    'api.admedia.com',
    'b.admedia.com',
    'k.quicklaunch.com',
    'www.admedia.com',
    'admedia.com',
    'rebates.com',
    'customercompany.com',
    'businessknows.com',
    'stagingmngt-oci-ashburn.admedia.com',
    'stagingoci-adops.admedia.com',
    'stagingoci-www.admedia.com',
    'stagingoci-adsense.admedia.com',
    'stagingoci-cake.admedia.com',
    'stagingoci-roi.admedia.com',
    'stagingoci-api.admedia.com',
    'stagingoci-cms.admediacontent.com',
    'stagingoci-mngt.admediacontent.com',
    'stagingoci.admediacontent.com',
    'stagingoci.rebates.com',
    'accoona.com',
	'www.accoona.com',
    'localpages.com',
	'www.localpages.com',
    'clubmoney.com',
    'www.clubmoney.com',
    'cured.com',
    'www.cured.com',
    'dev.admedia.com',
    '192.168'.'.30.106',
    'leisure.com',
    'www.leisure.com',
    'www.formula1vegasprix.com',
    'formula1vegasprix.com',
    'awaywedding.com',
    'www.awaywedding.com',
    'p.eurekster.com',
    'www.qualifiedlawyers.com',
    'qualifiedlawyers.com',
    'www.bridalfusion.com',
    'bridalfusion.com',
	'emergencyjet.com',
	'www.emergencyjet.com',
	'lotos.com',
	'www.lotos.com',
	'fists.com',
	'www.fists.com',
    'hoe.com',
    'www.pointwines.com',
    'pointwines.com',
    'socialsearch.com',
    'www.socialsearch.com',
    'injection.com',
    'www.injection.com',
    'www.porschemotorcar.com',
    'porschemotorcar.com',
    'buzzour.com',
    'www.buzzour.com',
	'www.perfect10dating.com',
	'perfect10dating.com',
	'items.com',
	'www.items.com',
	'joinrebates.com',
	'www.joinrebates.com',
	'joinitems.net',
	'www.joinitems.net',
	'theagency.com',
	'www.theagency.com',
	'leisureinsuranceclub.com',
	'www.leisureinsuranceclub.com',
    'secondframe.com',
	'www.secondframe.com',
    'theagency.com',
    'webcrawlers.com',
    'shopresources.com',
    'toyota4runners.com',
    'kidsactivitypage.com',
    'absolutelymad.com',
    'secondframe.com',
    'www.webcrawlers.com',
    'www.shopresources.com',
    'www.toyota4runners.com',
    'www.kidsactivitypage.com',
    'www.absolutelymad.com',
    'www.secondframe.com',
    'joinitems.net',
    'www.joinitems.net',
    'joinrebates.com',
    'allianinsurance.com',
    'www.perfect10dating.com',
    'perfect10dating.com',
    'aazon.com',
    'www.aazon.com',
    'brandzones.com',
    'www.brandzones.com',
    'stagingmembers.admedia.com',
    'stagingadvertisers.admedia.com',
];
$is_oci = defined('IS_OCI') ? IS_OCI : 0;

if( in_array( $sub_domain, $oci_domains ) || $isCLI || !empty($_SERVER['HTTP_X_IS_OCI']) || (isset($_GET['dbg']) && $_GET['dbg'] == 'oci'  ) || !empty($is_oci) ) {
    $oci_test = true;
}
$oci_test = true;
if( $oci_test ){
	$admin_conf = parse_ini_file('adDbfileNew_oci.ini');
	$search_conf = parse_ini_file('search_oci.ini');
    $shorty_conf = parse_ini_file('shorty_oci.ini');
    $keywords_conf = parse_ini_file('keywords_oci.ini');
    $adcenter_conf = parse_ini_file('adCenterDbFile2020_oci.ini');
    $stats = parse_ini_file('statsDb2060_oci.ini');
    $archive_conf = parse_ini_file('arch_oci.ini');
    $whale_conf = parse_ini_file('whale51046_oci.ini');
    //echo 'Testing with OCI files for DBs: adDbfileNew_oci, shorty_oci, keywords_oci, adCenterDbFile2020_oci, statsDb2060_oci and arch_oci';
    $cms_conf = parse_ini_file('cms_oci.ini');
    $email_whois = parse_ini_file('email_whois_oci.ini');
    $rtb_conf = parse_ini_file('rtb_oci.ini');
    $live_conf = parse_ini_file('live_oci.ini');
  	$localpages = parse_ini_file('local_pages_oci.ini');
    $montanapost_conf = parse_ini_file('montanapost_oci.ini');
    $the_agency = array("host"=>$adcenter_conf['host'],"user"=>$adcenter_conf['user'],"pass"=>$adcenter_conf['pass'],"db"=>"the_agency");
    $whale_readonly_conf = parse_ini_file('whale51046_oci.ini'); //for dev server we use the same db as whale but on prod we have a separate ini file for readonly
    $attestpath_conf = @parse_ini_file('attestpath_oci.ini');
    $webcrawlerdb_conf = @parse_ini_file('webcrawler_oci.ini');
}
else{
	$admin_conf = parse_ini_file('adDbfileNew.ini');
    $shorty_conf = parse_ini_file('shorty.ini');
    $keywords_conf = parse_ini_file('keywords.ini');
    $adcenter_conf = parse_ini_file('adCenterDbFile2020.ini');
    $stats = parse_ini_file('statsDb2060.ini');
    $archive_conf = parse_ini_file('arch.ini');
    $whale_conf = parse_ini_file('whale51046.ini');
    $cms_conf = parse_ini_file('cms.ini');
    $email_whois = false;
    $live_conf = array("host"=>"192.168.30.105","user"=>"c3slave","pass"=>"RstG496urky2","db"=>"Live");
    $rtb_conf = array("host"=>"192.168.17.111","user"=>"c3slave","pass"=>"RstG496u*#rky2","db"=>"rtb");
  	$localpages = parse_ini_file('local_pages.ini');
    $montanapost_conf = array("host"=>"66.63.171.39","user"=>"c3slave","pass"=>"RstG496u*#rky2","db"=>"montanapost");
    $the_agency = array("host"=>$adcenter_conf['host'],"user"=>$adcenter_conf['user'],"pass"=>$adcenter_conf['pass'],"db"=>"the_agency");
    $whale_readonly_conf = parse_ini_file('whale_readonly_oci.ini');
    $attestpath_conf = @parse_ini_file('attestpath_oci.ini');
    $webcrawlerdb_conf = @parse_ini_file('webcrawler_oci.ini');
}
$GLOBALS['admin_conf'] = $admin_conf;
$GLOBALS['search_conf'] = $search_conf;
$GLOBALS['shorty_conf'] = $shorty_conf;
$GLOBALS['keywords_conf'] = $keywords_conf;
$GLOBALS['adcenter_conf'] = $adcenter_conf;
$GLOBALS['stats'] = $stats;
$GLOBALS['archive_conf'] = $archive_conf;
$GLOBALS['whale_conf'] = $whale_conf;
$GLOBALS['cms_conf'] = $cms_conf;
$GLOBALS['email_whois_conf'] = $email_whois;
$GLOBALS['rtb_conf'] = $rtb_conf;
$GLOBALS['localpages'] = $localpages;
$GLOBALS['the_agency'] = $the_agency;
$GLOBALS['whale_readonly_conf'] = $whale_readonly_conf;
$GLOBALS['attestpath_conf'] = $attestpath_conf;
$GLOBALS['webcrawlerdb_conf'] = $webcrawlerdb_conf;
$GLOBALS['live_conf'] = $live_conf;
//$cms_conf = parse_ini_file('cms.ini');

if(!empty($attestpath_conf['host'])){
    define("MSACOMMON_DB_HOST_ATTESTPATH", $attestpath_conf['host']);
}else{
    define("MSACOMMON_DB_HOST_ATTESTPATH", '');
}
if(!empty($attestpath_conf['user'])){
    define("MSACOMMON_DB_USER_ATTESTPATH", $attestpath_conf['user']);
}else{
    define("MSACOMMON_DB_USER_ATTESTPATH", '');
}
if(!empty($attestpath_conf['pass'])){
    define("MSACOMMON_DB_PASS_ATTESTPATH", $attestpath_conf['pass']);
}else{
    define("MSACOMMON_DB_PASS_ATTESTPATH", '');
}

if(!empty($webcrawlerdb_conf['host'])){
    define("MSACOMMON_DB_HOST_WEBCRAWLERDB", $webcrawlerdb_conf['host']);
}else{
    define("MSACOMMON_DB_HOST_WEBCRAWLERDB", '');
}
if(!empty($webcrawlerdb_conf['user'])){
    define("MSACOMMON_DB_USER_WEBCRAWLERDB", $webcrawlerdb_conf['user']);
}else{
    define("MSACOMMON_DB_USER_WEBCRAWLERDB", '');
}
if(!empty($webcrawlerdb_conf['pass'])){
    define("MSACOMMON_DB_PASS_WEBCRAWLERDB", $webcrawlerdb_conf['pass']);
}else{
    define("MSACOMMON_DB_PASS_WEBCRAWLERDB", '');
}
define("MSACOMMON_DB_HOST_AGENCY", $the_agency['host']);
define("MSACOMMON_DB_USER_AGENCY", $the_agency['user']);
define("MSACOMMON_DB_PASS_AGENCY", $the_agency['pass']);

/* 30.32 Admin db */
define("MSACOMMON_DB_HOST_ADMIN", $admin_conf['host']);
define("MSACOMMON_DB_USER_ADMIN", $admin_conf['user']);
define("MSACOMMON_DB_PASS_ADMIN", $admin_conf['pass']);

define("MSACOMMON_DB_HOST_SEARCH", $search_conf['host']);
define("MSACOMMON_DB_USER_SEARCH", $search_conf['user']);
define("MSACOMMON_DB_PASS_SEARCH", $search_conf['pass']);

define("MSACOMMON_DB_HOST_CMS", $cms_conf['host']);
define("MSACOMMON_DB_USER_CMS", $cms_conf['user']);
define("MSACOMMON_DB_PASS_CMS", $cms_conf['pass']);


/*define("MSACOMMON_DB_HOST_ADMIN", "192.168.17.110");
define("MSACOMMON_DB_USER_ADMIN", "c3slave");
define("MSACOMMON_DB_PASS_ADMIN", "RstG496u*#rky2");*/

/* 30.32 blog_admedia db */
define("MSACOMMON_DB_HOST_BLOG_ADMEDIA", "192.168.17.110");
define("MSACOMMON_DB_USER_BLOG_ADMEDIA", "wordpress");
define("MSACOMMON_DB_PASS_BLOG_ADMEDIA", "lj12klh2134#A");

define("MSACOMMON_DB_HOST_BLOG_RATEIT", "192.168.17.110");
define("MSACOMMON_DB_USER_BLOG_RATEIT", "c3slave");
define("MSACOMMON_DB_PASS_BLOG_RATEIT", "RstG496u*#rky2");

define("MSACOMMON_DB_HOST_STATS39", $shorty_conf['host']);
define("MSACOMMON_DB_USER_STATS39", $shorty_conf['user']);
define("MSACOMMON_DB_PASS_STATS39", $shorty_conf['pass']);

define("MSACOMMON_DB_HOST_RTB2", "192.168.17.30");
define("MSACOMMON_DB_USER_RTB2", "c3slave");
define("MSACOMMON_DB_PASS_RTB2", "RstG496u*#rky2");

define("MSACOMMON_DB_HOST_ADMIN2", MSACOMMON_DB_HOST_ADMIN);
define("MSACOMMON_DB_USER_ADMIN2", MSACOMMON_DB_USER_ADMIN);
define("MSACOMMON_DB_PASS_ADMIN2", MSACOMMON_DB_PASS_ADMIN);

define("MSACOMMON_DB_HOST_KEYWORDS", $keywords_conf['host']);
define("MSACOMMON_DB_USER_KEYWORDS", $keywords_conf['user']);
define("MSACOMMON_DB_PASS_KEYWORDS", $keywords_conf['pass']);

define("MSACOMMON_DB_HOST_WHALE", $whale_conf['host']);
define("MSACOMMON_DB_USER_WHALE", $whale_conf['user']);
define("MSACOMMON_DB_PASS_WHALE", $whale_conf['pass']);

define("MSACOMMON_DB_HOST_STATS", $stats['host']);
define("MSACOMMON_DB_USER_STATS", $stats['user']);
define("MSACOMMON_DB_PASS_STATS", $stats['pass']);

define("MSACOMMON_DB_HOST_LOCALPAGES", $localpages['host']);
define("MSACOMMON_DB_USER_LOCALPAGES", $localpages['user']);
define("MSACOMMON_DB_PASS_LOCALPAGES", $localpages['pass']);

define("MSACOMMON_DB_HOST_ARCHIVE", $archive_conf['host']);
define("MSACOMMON_DB_USER_ARCHIVE", $archive_conf['user']);
define("MSACOMMON_DB_PASS_ARCHIVE", $archive_conf['pass']);

define("MSACOMMON_DB_HOST_ADCENTER", $adcenter_conf['host']);
define("MSACOMMON_DB_USER_ADCENTER", $adcenter_conf['user']);
define("MSACOMMON_DB_PASS_ADCENTER", $adcenter_conf['pass']);

define("MSACOMMON_DB_HOST_LIVE", $live_conf['host']);
define("MSACOMMON_DB_USER_LIVE", $live_conf['user']);
define("MSACOMMON_DB_PASS_LIVE", $live_conf['pass']);

define("MSACOMMON_DB_HOST_MONTANAPOST", $montanapost_conf['host']);
define("MSACOMMON_DB_USER_MONTANAPOST", $montanapost_conf['user']);
define("MSACOMMON_DB_PASS_MONTANAPOST", $montanapost_conf['pass']);

define("MSACOMMON_DB_HOST_EMAIL_WHOIS", $email_whois['host']);
define("MSACOMMON_DB_USER_EMAIL_WHOIS", $email_whois['user']);
define("MSACOMMON_DB_PASS_EMAIL_WHOIS", $email_whois['pass']);

define("MSACOMMON_DB_HOST_WHALE_READONLY", $whale_readonly_conf['host']);
define("MSACOMMON_DB_USER_WHALE_READONLY", $whale_readonly_conf['user']);
define("MSACOMMON_DB_PASS_WHALE_READONLY", $whale_readonly_conf['pass']);

/*function get_domain() {
     $pieces = parse_url($_SERVER['HTTP_HOST']);
     $domain = isset($pieces['host']) ? $pieces['host'] : $pieces['path'];
     if (preg_match('/(?P<domain>[a-z0-9][a-z0-9\-]{1,63}\.[a-z\.]{2,6})$/i', $domain, $regs)) {
         return $regs['domain'];
     }
     return false;
}*/