<?
class database
{                
    public function init($db,$name,$pw)
    {          
		$url = $_SERVER['HTTP_HOST'];		
		$db_client = explode(".",$url);
		$host = ($db_client[2] != "dev") ? 'localhost' : 'localhost';
			          
		$conn = &ADONewConnection('mysqlt'); 
		$conn->Connect($host,$name,$pw,$db) or die("failed to connect to $db");		
			
        return $conn;        
    }    		

    public function init_current_client($conn,$db_name,$name,$pw)
    {   

		$url = $_SERVER['HTTP_HOST'];		
		
		$db_client = explode(".",$url);
		$host = ($db_client[2] != "dev") ? 'localhost' : 'localhost';
				
		$client_db_name = common_ref_global_client::get_client_db($db_client[0],$conn,$db_name);			
																				
		$database = &ADONewConnection('mysqlt'); 		
		$database->Connect($host,$name,$pw,$client_db_name) or die("failed to connect to $db");

        return array($database,$client_db_name);        
    }    		
		
	public function create_new_client_database($context)
	{
		$db_client = explode(".",$_SERVER['HTTP_HOST']);
		$database_domain = $db_client[2];
		
		$password = ($database_domain == "dev") ? "password" : "reiX82!";
		
		$db_name = $context['db_name'];
		$filename = "/home/suggestionplace/app/db_backup/default_client_db.sql";
		
		$command = "mysqladmin -uroot -p$password CREATE ".$db_name;
		system($command);
				
		$command = "mysql -uroot -p$password ".$db_name." < ".$filename;		
		system($command);	
	}  		
}
?>