Old Mutual Wealth Business Tools

<?php
//20131108 - Fixed profile pic session not showing. -Christiaan 
//20150723 - Upgrade to be php 5.6 compliant - Christiaan
//20160620 - Modify database connection to point to one database - Christiaan
/*
*/
   include_once("_nemo.basic.cls.php");

   $page = new NemoBasic();
//print_rr($_SESSION);

  // print_rr($_SESSION);
//print_rr( $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname);
   // $db = mysql_connect($DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->hostname
   //                        ,   $DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->username
   //                        ,   $DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->password);
   // mysql_select_db($DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->database);
   //20160620 - Modify database connection to point to one database - Christiaan
   // $db = 
   // $MYSQLI = mysqli_connect($DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->hostname
   //               , $DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->username
   //               , $DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->password
   //               , $DATABASE_SETTINGS2[$SystemSettings[SERVER_NAME]]->database); 

   $rowCheckUser = $xdb->getRowSQL("SELECT * FROM tblUser WHERE strEmail = \"" . $_SESSION[LEARNER]->EMAIL . "\"",0);
   if($rowCheckUser)
   {
   	//20150903 - if there is no Practice for this user, make them do the practice setup again
   	if($rowCheckUser->refPracticeID == 0)
   	{
		   // $db = mysql_connect($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname
		   //                  , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username
		   //                  , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password);
		   // mysql_select_db($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database);
		   //20160620 - Modify database connection to point to one database - Christiaan 
	      // $db = 
	      // $MYSQLI = mysqli_connect($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname
	      //               , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username
	      //               , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password
	      //               , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database); 

		  	//$page->Content = "<h1>Old Mutual Wealth Business Tools </h1>";
		   //$page->Content .= getTypoIframe($id="hidden/business-tools/");
		   

		   //$page->Display("layout.learner.2Tools.2col.LC.incl.php");
		   windowLocation("login.business_tools.php");
		   die;
   	}

	   $_SESSION[ADVISOR]->ID = $rowCheckUser->UserID;
	   $_SESSION[ADVISOR]->USERNAME = $rowCheckUser->strName; //strUser
	   $_SESSION[ADVISOR]->PASSWORD = $rowCheckUser->strPassword;
	   $_SESSION[ADVISOR]->EMAIL = $rowCheckUser->strEmail;
	   $_SESSION[ADVISOR]->PRACTICEID = $PracticeID = $rowCheckUser->refPracticeID;
	   $_SESSION[ADVISOR]->PRACTICENAME = $rowCheckUser->strPractice;
	   $_SESSION[ADVISOR]->SUPERUSER = $rowCheckUser->blnSuperUser;

	   $intCookieTime = 3600;
	   setcookie("celusername", $_SESSION[ADVISOR]->EMAIL, time() + $intCookieTime);
	   setcookie("celpassword", $_SESSION[ADVISOR]->PASSWORD, time() + $intCookieTime);

		     
		//20131108 -Testing if Profile Picture session link exists. Code below fixes profile pic session not showing. -Christiaan      
	   if($_SESSION[LEARNER]->PICTUREPATH == "")
	   {
			//# CHANGE TO ACADEMY DATABASE
			// $db = mysql_connect(    $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname, 
			//                         $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username,
			//                         $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password);
			//       mysql_select_db(  $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database);
			//20160620 - Modify database connection to point to one database - Christiaan
	      // $db = 
      	// $MYSQLI = mysqli_connect($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname
       //              				, $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username
       //              				, $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password
       //              				, $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database); 

			$row = $xdb->getRowSQL("SELECT * FROM tblLearner WHERE LearnerID = '" . $_SESSION[LEARNER]->ID . "'");

			$ProfilePicturePath = "Profile:PicturePath";
			$_SESSION[LEARNER]->PICTUREPATH = $row->$ProfilePicturePath;
	   }
	    // print_rr($_SESSION);
   		// die;
	   
	   windowLocation("../tools/index.php");
  }
  else
  {
	   // $db = mysql_connect($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname
	   //                  , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username
	   //                  , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password);
	   // mysql_select_db($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database); 
  	//20160620 - Modify database connection to point to one database - Christiaan
      // $db = 
      // $MYSQLI = mysqli_connect($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname
      //               , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username
      //               , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password
      //               , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database); 

	  	//$page->Content = "<h1>Old Mutual Wealth Business Tools </h1>";
	   //$page->Content .= getTypoIframe($id="hidden/business-tools/");
	   

	   //$page->Display("layout.learner.2Tools.2col.LC.incl.php");
	   windowLocation("login.business_tools.php");
	   die;
  }
?>