public static function getInstance()
{
if (!isset(self::$instance)) {
$c = __CLASS__;
self::$instance = new $c();
}
return self::$instance;
}
function __construct()
{
$this->conex = Conex::getInstance()->getPDO();
}
function sendChat()
{
$from = $_SESSION['id_us'];
$to = $_POST['to'];
$message = $_POST['message'];
//--
//Bloque para traerme el contenido de los nombres del usuario
$bd = new Conex();
$bd->conectar();
$sql2 = "SELECT usuario_login FROM tbl_usuarios WHERE tbl_usuarios.id_usuarios='" . $to . "';";
$rs_to = $bd->execute($sql2);
$to_us = $rs_to[0][0];
//--
$_SESSION['openChatBoxes'][$_POST['to']] = date('Y-m-d H:i:s', time());
$messagesan = sanitize($message);
if (!isset($_SESSION['chatHistory'][$_POST['to']])) {
$_SESSION['chatHistory'][$_POST['to']] = '';
}
$_SESSION['chatHistory'][$_POST['to']] .= <<<EOD
\t\t\t\t\t {
\t\t\t"s": "1",
\t\t\t"f": "{$to}",
\t\t\t"m": "{$messagesan}",
\t\t\t"h": "{$to_us}"
\t },
EOD;
unset($_SESSION['tsChatBoxes'][$_POST['to']]);
$fecha = date("Y-m-d");
$bd = new Conex();
$bd->conectar();
$sql = "insert into tbl_chat (de,para,message,sent) values ('" . $from . "', '" . $to . "','" . $message . "','" . $fecha . "')";
//--Para mysql
//$query = mysql_query($sql);
//--Para postgresql
$query = $bd->execute($sql);
//
echo "1";
exit(0);
}
