<?php

	include('config.php');
	
	$RESPONSE_ARRAY = array();
	
	switch ($_POST['COMMAND']) {
		
		case 'GetConversation':
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						$Q = mysql_query("SELECT * FROM bb_noc_assistance_messages WHERE id_ticket = '".$_POST['TID']."' ORDER BY id ASC;") or die (print json_encode(mysql_error()));
						
							$RESPONSE_ARRAY = array();
							
							while ($DATA = mysql_fetch_array($Q)) {
								$RESPONSE_ARRAY[] = $DATA; 
							}
							
							mysql_close();
							echo json_encode($RESPONSE_ARRAY);						
						
						break;
		
		case 'NewMessage':
						mysql_connect($LDB_IP_ADDRESS, $LDB_USERNAME, $LDB_PASSWORD) or die (print json_encode(mysql_error()));
						mysql_select_db($LDB_DB_NAME);
						
						$Message = mysql_real_escape_string($_POST['NewMessage']);
						mysql_query("INSERT INTO bb_noc_assistance_messages (id_ticket, id_sender, message) VALUES ('".$_POST['TID']."', '".$_POST['UID']."', '".$Message."');") or die (print json_encode(mysql_error()));
						
						$Q = mysql_query("SELECT * FROM bb_noc_assistance_messages WHERE id_ticket = '".$_POST['TID']."' ORDER BY id ASC;") or die (print json_encode(mysql_error()));
						
							$RESPONSE_ARRAY = array();
							
							while ($DATA = mysql_fetch_array($Q)) {
								$RESPONSE_ARRAY[] = $DATA; 
							}
							
							mysql_close();
							echo json_encode($RESPONSE_ARRAY);						
						
						break;
	
	}
		
	
	
?>