<?
	class common_ref_global_super
	{		
		public function get_all_icons()
		{			
			global $database;
			
			$db_name = DB_GLOBAL;
			
//			$database->debug = true;
													
			$query = "
			SELECT *
			FROM $db_name"."icons
			";
			$results = $database->getAll($query);
									
			$final_results = array();
			
			foreach($results AS $result)
			{
				$final_results[$result['id']] = $result;	
			}
			
			return $final_results;
		}				

		public function get_all_groups($db_name)
		{					
			global $database;
											
			$query = "
			SELECT *
			FROM $db_name"."groups
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}	

		public function get_all_staff($db_name)
		{						
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
				
			$query = "
			SELECT *
			FROM $db_name"."users
			ORDER BY first_name ASC
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}	
				
		public function get_all_countries()
		{					
			global $database;
								
			$db_name = DB_GLOBAL;
			
			$sql = "
			SELECT 
				country_id AS id, 
				country_name AS name
			FROM $db_name"."countries
			";
			$results = $database->getAll($sql);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}	
		
		public function get_country_id($country_name)
		{					
			global $database;
								
			$db_name = DB_GLOBAL;
			
			$sql = "
			SELECT 
				country_id, 
				country_name
			FROM $db_name"."countries
			WHERE country_name = '$country_name'
			LIMIT 1
			";
			$results = $database->getRow($sql);				
			
			$id = $results['country_id'];
			
			return $id;			
		}	
		
		public function get_country_name($country_id)
		{					
			global $database;
								
			$db_name = DB_GLOBAL;
			
			$sql = "
			SELECT 
				country_id, 
				country_name
			FROM $db_name"."countries
			WHERE country_id = '$country_id'
			LIMIT 1
			";
			$results = $database->getRow($sql);				
			
			$name = $results['country_name'];
			
			return $name;
		}	

		public function get_all_states($country_id)
		{	
			global $database;
		
			$db_name = DB_GLOBAL;
									
			$sql = "
			SELECT state  AS id, state AS name
			FROM $db_name"."states
			WHERE country_id = '$country_id'
			";
			$results = $database->getAll($sql);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}	

		public function get_all_time_zones()
		{			
			global $database;
			
			$db_name = DB_GLOBAL;
							
			$query = "
			SELECT *
			FROM $db_name"."time_zones
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}					
	}
?>