CREATE TABLE IF NOT EXISTS `amdoc_messages` (
  `id_msg` int(11) NOT NULL AUTO_INCREMENT,
  `subj` varchar(150) DEFAULT '',
  `id_from` int(11) DEFAULT '0',
  `id_dest` varchar(50) DEFAULT '0',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `text` varchar(1000) DEFAULT '',
  `opened` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'nonzero if opened',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'nonzero if deleted',
  PRIMARY KEY (`id_msg`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `amdoc_messages` (`id_msg`, `subj`, `id_from`, `id_dest`, `date`, `text`, `opened`, `deleted`) VALUES
(1, 'Just a test', 3, '4', '2014-07-22 12:25:09', 'Hi,\r\nThis is my first message, just a test, tell me if it works!', 1, 0),
(2, 'Got it', 4, '3', '2014-07-22 13:41:26', 'Hello,\r\nJust got your message,\r\nWorks great ;-)', 1, 0),
(3, 'Thanks', 3, '4', '2014-07-22 14:46:07', 'ok, thanks', 0, 0);

SELECT m.id_msg, m.subj, m.`date`, m.opened, f.log as exp

FROM `$db_tbl_msg` m, `$db_tbl_user` t,`$db_tbl_user` f

WHERE t.id_mvsappmobile='$id_mvs'
	and m.id_dest=t.id_user
	and f.id_user=m.id_from
	and m.deleted=0

<?php
include('config.php');//données de config, notamment $dbhost,$dbuser,$dbpassword,$dbname pour accéder à la base 
$id_mvs=$_GET['id_mvsappmobile']; //récupération del'id de session passé en paramètre
$xml="<?xml version='1.0' encoding='UTF-8'?>\r\n<items version='1.0' type='1' reload='1' locate='0'>";//le XML de la liste à afficher
header ("Content-Type:text/xml; charset=utf-8");//entête http
function add_item(&$xmlstring, $typ, $img, $tx1, $tx2, $tx3, $link) {
	$xmlstring.="
	<item type='$typ'> 
		<img>$urlprefix/$img</img>
		<txt1>$tx1</txt1>
		<txt2>$tx2</txt2>    
		<txt3>$tx3</txt3>
		<link type='1' url='$link' title='$tx1' />
	</item>";
}
function quit_script(&$xmlstring, $errorMsg, $pic) {
	add_item($xmlstring, 1, $pic, $errorMsg, "", "", "");
	echo($xmlstring."\r\n</items>");
	exit;
}
$db =  @mysql_connect($dbhost, $dbuser, $dbpassword);
if(!$db) { quit_script($xml,"Pas de connexion","pic/noConnec.png"); } //Problème connexion serveur MySQL
if(!@mysql_select_db($dbname)) { quit_script($xml,"Pas de connexion","pic/noConnec.png"); } //Problème sélection base MySQL
$query="select id_user from $db_tbl_user where id_mvsappmobile='$id_mvs'";
$result = @mysql_query($query,$db);
if (!$result) { quit_script($xml,"Pas de connexion","pic/noConnec.png"); } //Problème MySQL
else {//data was found
	if(mysql_num_rows($result)!=1) { quit_script($xml,"Merci de vous identifier","pic/noSession.png"); }//no connected user for this session
	else {//user is connected
		$query = "SELECT m.id_msg, m.subj, m.`date`, m.opened, f.log as exp
		FROM `$db_tbl_msg` m, `$db_tbl_user` t,`$db_tbl_user` f 
		WHERE t.id_mvsappmobile='$id_mvs' and m.id_dest=t.id_user and f.id_user=m.id_from and m.deleted=0";
		$result = @mysql_query($query,$db);
		@mysql_close($db);
		if(!$result) { quit_script($xml,"Pas de connexion","pic/noConnec.png"); } //Problème MySQL
		else if (mysql_num_rows($result) == 0) { add_item($xml, 1, "pic/noMsg.png", "Aucun message", "", "", ""); }//there's no message
			else {//there are messages
				while ($l = mysql_fetch_assoc($result)) {
					$im=($l['opened']=="1" ? "pic/openedMsg.png" : "pic/newMsg.png");
					add_item($xml, 1, $im, $l['subj'], "From: ".$l['exp'], date('d/m/Y',strtotime($l['date'])), "$urlprefix/msg_show.php?msg=".$l['id_msg']."&id_mvsappmobile=$id_mvs");
				}
			}
		echo ($xml."\r\n</items>");
	}
}
?>

update `amdoc_users` set `id_mvsappmobile`='disconnected'
where `id_mvsappmobile`='{id de session}'

<?php
/* Functional demo... Messages and layouts have to be customized! */
include('config.php');//contains data like db connection IDs, base URL, etc.
$id_mvs=$_GET['id_mvsappmobile']; //read parameters -> session id
$db =  @mysql_connect($dbhost, $dbuser, $dbpassword);
if(!$db) { echo("ConnectProblem");exit; } //MySQL connection problem
if(!@mysql_select_db($dbname)) { echo("DBOpenProblem");exit; } //MySQL db selection problem
//déconnexion 
$query="update $db_tbl_user set `id_mvsappmobile`='disconnected' where `id_mvsappmobile`='$id_mvs'";
$result = mysql_query($query,$db);
if(!$result) { echo("DBDataProblem");exit; } //MySQL problem
$nbrows=mysql_affected_rows($db);
mysql_close($db);
if($nbrows==0) { echo("UnexistingSession");exit; } //MySQL problem
else if($nbrows>1) { echo("SeveralSessionsDisconnected");exit; } //This should never happen.
//The login script must refuse connection of new user on existing session id, OR delete existing connection before connecting new.
else { echo("DisconnectOk"); }
?>