<?
	class edit_status
	{		
		public function get_status($table,$status)
		{									
			global $database;			
										
			$table_con = $table."_con";															
			$db_client_status = DB_CLIENT_STATUS;
			
			$icons = common_ref_global_super::get_all_icons();
			
//			$database->debug = true;
												
			$get_status = "
			SELECT 
				id,
				action_name,
				post,
				icon,				
				hide												
			FROM $db_client_status$table
			WHERE id IN (SELECT con_id FROM $db_client_status$table_con WHERE id = '$status')
			ORDER by ordering ASC			
			";
			$results_status = $database->getAll($get_status);
						
			$final_results = array();
			
			foreach($results_status AS $result_status)
			{						
				$id = $result_status['id'];
				$action_name = $result_status['action_name'];
				$post = $result_status['post'];
				$hide = $result_status['hide'];
				$icon = $result_status['icon'];

				$path = $icons[$icon]['path'];
				
				$final_results[] = array(
					"path" => $path,
					"action_name" => $action_name,
					"post" => $post,
					"hide" => $hide,															
					"id" => $id
				);																			
			}						
																																																						
			return $final_results;	
		}															
	}

?>