Offline Instant Messaging with php Mysqli

CREATE TABLE `offline` (
  `ID` MEDIUMINT NOT NULL AUTO_INCREMENT,
  `PrincipalID` char(36) NOT NULL DEFAULT '',
  `Message` text NOT NULL,
  `TMStamp` INT,
  PRIMARY KEY  (`ID`),
  KEY `PrincipalID` (`PrincipalID`)
) ENGINE=MyISAM;

C_DB_HOST = the hostname of the server thats running mysql
C_DB_DATABASE = is the database where the offline table is stored
C_DB_USER = database user you are useing for accesing the offline table
C_DB_PASS = user passwd that belongs to the use that you set in C_DB_USER
C_DB_TABLE = table name for offline.

<?php
/* Script based on the code you can find at http://opensimulator.org/wiki/Offline_Messaging 
 * @author: Richardus Raymaker -> http:\\www.simsquaremetaverse.nl
 * @date: 2013-03-23
 * @date: 2013-03-26 -> Changed way timestamp get stored in the database, change in table structure.
 */
 
define("C_DB_HOST"      ,"localhost"); 
define("C_DB_DATABASE"  ,""); 
define("C_DB_USER"      ,""); 
define("C_DB_PASS"      ,""); 
define("C_DB_TABLE"     ,"offline");
 
/*---*/
    function SplitIM($httpRaw)
    {
        $ImHeaderStartFunc = strpos($httpRaw,"?>");
        if ($ImHeaderStartFunc!=-1)
        {
            $ImHeaderStartFunc+=2;
            $httpRawFunc = substr($httpRaw,$ImHeaderStartFunc);
            $ImPartsFunc = preg_split('[<|>]',$httpRaw);
 
            return $ImPartsFunc;
        }    
    }
/*---*/
 
/*----------*/
if (isset($_SERVER["PATH_INFO"]))
{
    $urlPath = $_SERVER["PATH_INFO"];
    $httpRaw = $HTTP_RAW_POST_DATA;
 
    if ($urlPath=="/SaveMessage/")
    {
        $start=strpos($httpRaw,"?>");
        if ($start!=-1)
        {
            $httpRaw=substr($httpRaw,$start+2);
 
            /*Open offline database*/
            $link = mysqli_connect(C_DB_HOST, C_DB_USER, C_DB_PASS, C_DB_DATABASE);
            if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); exit; } 
            mysqli_set_charset($link, "utf8");
 
            /*find toAgent UUID*/
            $ImParts = SplitIM($httpRaw);
            $toAgentID=$ImParts[array_search("toAgentID",$ImParts)+1];
            $TMStamp=$ImParts[array_search("timestamp",$ImParts)+1];
 
            /* Store messgae in database and inform user the message is saved */
            mysqli_query($link,"insert into ".C_DB_TABLE." (PrincipalID, Message, TMStamp) values ('" . mysqli_real_escape_string($link,$toAgentID) . "',
                                                                                                   '" . mysqli_real_escape_string($link,$httpRaw). "',
                                                                                                   '" . mysqli_real_escape_string($link,$TMStamp) . "')");
            echo "<?xml version=\"1.0\" encoding=\"utf-8\"?><boolean>true</boolean>";            
 
            /*Close offline database*/
            mysqli_close($link);      
        }
        else
        {   
            echo "<?xml version=\"1.0\" encoding=\"utf-8\"?><boolean>false</boolean>";
        }    
        exit;   
    } 
 
    if ($urlPath=="/RetrieveMessages/")
    { 
        $ImParts = SplitIM($httpRaw);
        $toAgentID=$ImParts[array_search("Guid",$ImParts)+1];
 
        /*Open offline database*/
        $link = mysqli_connect(C_DB_HOST, C_DB_USER, C_DB_PASS, C_DB_DATABASE);
        if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error()); exit; } 
        mysqli_set_charset($link, "utf8");
 
        $queryresult=mysqli_query($link,"select Message from ".C_DB_TABLE." where PrincipalID='" . mysqli_real_escape_string($link,$toAgentID) . "' ORDER BY ID ASC, TMStamp ASC");        
 
        /* Send offline IM messgaes to user */
        echo "<?xml version=\"1.0\" encoding=\"utf-8\"?><ArrayOfGridInstantMessage xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">";
 
        while ($row =  mysqli_fetch_array($queryresult, MYSQL_NUM)) 
        {
            echo $row[0];
        }
        echo "</ArrayOfGridInstantMessage>"; 
 
        /* Delete message after send it to user */
        $queryresult=mysqli_query($link,"delete from ".C_DB_TABLE." where PrincipalID='" . mysqli_real_escape_string($link,$toAgentID) . "'");
 
        /*Close offline database*/
        mysqli_close($link); 
 
        exit;          
    }     
}  
 
?>
 
?>

[Messaging]
; Control which region module is used for instant messaging.
; Default is InstantMessageModule (this is the name of the core IM module as well as the setting)
InstantMessageModule = InstantMessageModule
; MessageTransferModule = MessageTransferModule
OfflineMessageModule = OfflineMessageModule
OfflineMessageURL = http://yourserver/offline.php
MuteListModule = MuteListModule
MuteListURL = http://yourserver/mute.php
ForwardOfflineGroupMessages = true

RewriteEngine On
RewriteCond %{REQUEST_URI}  "!^/index.php$"
RewriteRule "^(.*)$" "index.php" [L]