function createRoomIfNeeded()
{
$chatDAO = new ChatDAO();
$sid = $_GET["room"];
echo $chatDAO->addToOnline($sid);
echo $chatDAO->createChatRoomForStory($sid);
}
public function getMesaages($request)
{
$dao = new ChatDAO();
$sender = $request->get("sender");
$receiver = $request->get("receiver");
$messages = $dao->getMessages($sender, $receiver);
$ulist = json_encode($messages);
echo $ulist;
}
public function Delete($request)
{
$dao = new ChatDAO();
$username = $request->get("username");
$query = "delete from login where username=?";
$dao->query($query, $username);
$list = $dao->getUsers();
$ulist = json_encode($list);
echo $ulist;
}
static function ejecutar($func, $endpoint, $request)
{
//Si el usuario o grupo no está configurado para Limb, se sale de estos comandos
if (method_exists('ComandosLimb', $func)) {
$command = new ComandosLimb();
$chatDAO = new ChatDAO();
$chat = $chatDAO->select($request->get_chat_id());
//Si el chat tiene asociado un solo grupo, se establece ese
if (sizeof($chat->arrGrupo) == 1) {
return $command->{$func}($endpoint, $request, $chat->arrGrupo[0]);
} elseif (sizeof($chat->arrGrupo) > 1) {
$currentCMDDAO = new CurrentCMDDAO();
$result = $currentCMDDAO->select($request->get_chat_id());
if ($result != null) {
if ($result['grupo'] != null) {
//Obtener datos grupo
$grupoDAO = new GrupoDAO();
$grupoVO = $grupoDAO->select($result['grupo']);
$currentCMDDAO->delete($request->get_chat_id());
return $command->{$func}($endpoint, $request, $grupoVO);
}
//Si hay comando en curso, se borra y se inserta este
$currentCMDDAO->delete($request->get_chat_id());
}
$cmd = new CurrentCMDVO();
$cmd->chat_id = $request->get_chat_id();
$cmd->cmd = $func;
$resultInsertCMD = $currentCMDDAO->insert($cmd);
//se pregunta por el grupo
return Utils::pregunta_grupo($endpoint, $request);
} else {
//El chat no está dado de alta
return null;
}
}
return null;
}
} else {
if (empty($_POST['email'])) {
$error = "Email field must be filled!";
} else {
if (empty($_POST['gender'])) {
$error = "Gender must be selected!";
} else {
$error = "";
$username = $_POST['username'];
$password = $_POST['password1'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$username = stripslashes($username);
$password = stripslashes($password);
$email = stripslashes($email);
$dao = new ChatDAO();
$password = crypt($password);
$result = $dao->addUser($username, $password, $email, $gender);
if (count($result) > 0) {
$error = 'Username/Email already exists';
} else {
$_SESSION['login_user'] = $username;
// Initializing Session
$_SESSION['register'] = "TRUE";
unset($_SESSION['login']);
header("location: home.php");
// Redirecting To Other Page
}
}
}
}
} else {
foreach ($receivers as $key => $idReceiver) {
$receiver = UtilisateurDAO::selectById($idReceiver);
$strReceivers .= $receiver->username;
$strReceivers .= iif(count($receivers) - 1 != $key, ", ", "");
}
}
} catch (Exception $exc) {
$strReceivers = "???";
}
return $strReceivers;
}
//Faisons nous un petit tableau qui sera transformé en JSON
$tabMessagesChat = array();
//Récupérons nos messages
$messages = ChatDAO::selectAll();
//Traitons les pour avoir ceux qui nous intéresse
foreach ($messages as $key => $message) {
//Les messages qu'il a envoyé...
if (canSeeMessage($message, $user)) {
$nameSender = getNameSender($message->id_sender);
$nameReceivers = getNameReceivers($message->id_recipients);
$time = $message->time_msg;
$mess = $message->msg;
$is_system = $nameSender == "";
$tabMessagesChat[$key] = array("sender" => utf8_encode($nameSender), "recipients" => utf8_encode($nameReceivers), "time" => date("d/m/Y H:i:s", $time), "message" => utf8_encode($mess), "is_system" => $is_system);
}
}
//Le tableau est terminé, on encode en JSON.
echo json_encode($tabMessagesChat);
die;
<?php
setcookie("userField", $_SESSION['login_user']);
echo '<div class="btn btn-default btn-s input-group-addon" id="addBtn" onclick="addFriend(\'' . $_SESSION['login_user'] . '\')">Add</div>';
// printf('var userFiled1 = %s;', json_encode($_SESSION['login_user']));
?>
</div>
</div>
<div >
<table class="table table-hover" id="tableList">
<thead class="text-center">
<tr><th>Friend</th><th>Actions</th></tr>
</thead>
<tbody id="friends">
<?php
$dao = new ChatDAO();
$user = $_SESSION['login_user'];
$friends = $dao->getFriends($_SESSION['login_user']);
foreach ($friends as $friend) {
echo '<tr>';
echo "<td>{$friend->friendName}</td>";
echo "<td class=\"form-group\">" . "<button class=\"chat\" id=\"chat\" onclick=\"chatFriend('{$friend->friendName}');\">Chat</button>   " . "<button class=\"remove\" id=\"remove\" onclick=\"removeFriend('{$friend->friendName}');\">Remove</button><br />" . "</td>";
echo '</tr>';
}
?>
</tbody>
</table>
</div>
<div id="result" class="form-group ">
</div>
session_start();
// Starting Session
$error = '';
// Variable To Store Error Message
if (isset($_POST['submit'])) {
//echo 'Username : '******'username'] . empty($_POST['username']) . '<br />';
//echo 'Password : '******'password'] . empty($_POST['password']) . '<br />';
if (empty($_POST['username']) || empty($_POST['password'])) {
$error = "Username or Password is invalid";
} else {
// Define $username and $password
$username = $_POST['username'];
$password = $_POST['password'];
$username = stripslashes($username);
$password = stripslashes($password);
$dao = new ChatDAO();
//$password = crypt($password);
$que = "select * from login where username=?";
//echo 'Password Hash: ' . $password . '<br />';
$result = $dao->query($que, $username);
$db_password = $result[0]['password'];
if ($result != false && crypt($password, $db_password) == $db_password) {
$_SESSION['login_user'] = $username;
// Initializing Session
$_SESSION['login'] = "******";
unset($_SESSION['register']);
$_SESSION['admin'] = $result[0]['admin'];
header("location: home.php");
// Redirecting To Other Page
} else {
$error = "Username or Password is invalid";
static function pregunta_grupo($endpoint, $request)
{
$chatDao = new ChatDAO();
$arrGrupos = $chatDao->selectGruposChat($request->get_chat_id());
$arrButtons = array();
foreach ($arrGrupos as $grupo) {
array_push($arrButtons, [$grupo->nombre]);
}
$inline_keyboard = new stdClass();
$inline_keyboard->keyboard = $arrButtons;
$inline_keyboard->resize_keyboard = true;
$inline_keyboard->one_time_keyboard = true;
return Response::create_text_replymarkup_response($endpoint, $request->get_chat_id(), 'Dime el grupo, pringao!', json_encode($inline_keyboard));
}
$temp_array = array();
foreach ($id_recipients as $id_recipient) {
$id_recipient = (int) $id_recipient;
if ($id_recipient > 0 && UtilisateurDAO::selectById($id_recipient)) {
$temp_array[] = $id_recipient;
}
}
$formatted_recipients = implode(",", $temp_array);
} else {
$formatted_recipients = "0";
}
$chat = new Chat();
$chat->time_msg = (new DateTime("now", new DateTimeZone(DATETIME_ZONE)))->getTimestamp();
if (strlen($message) > 0) {
if ($is_connected) {
$chat->id_recipients = $formatted_recipients;
$chat->id_sender = $id_user;
$chat->msg = $message;
} else {
$chat->id_recipients = $id_user;
$chat->id_sender = 0;
$chat->msg = utf8_decode("Vous n'êtes pas connecté au chat.");
}
} else {
$chat->id_recipients = $id_user;
$chat->id_sender = 0;
$chat->msg = utf8_decode("Aucun message saisi.");
}
//send into chat
ChatDAO::add($chat);
<div id="users" class="text-center">
<!--
<table class="table table-striped table-hover">
<thead>
<tr> <th>Username</th> <th>Email</th> <th>Gender</th> <th>Gender</th> </tr>
</thead>
</table> -->
<?php
if (isset($_SESSION['login']) && $_SESSION['admin'] == 1) {
echo '
<table class="table table-hover" id="tableList">
<thead class="text-center">
<tr> <th style="text-align:center">Username</th> <th style="text-align:center">Email</th> <th style="text-align:center">Gender</th> <th style="text-align:center">Admin</th> <th style="text-align:center">Actions</th> </tr>
</thead>';
echo '<tbody id="users">';
$dao = new ChatDAO();
$users = $dao->getUsers();
foreach ($users as $user) {
echo '<tr>';
echo "<td>{$user->username}</td>";
echo "<td>{$user->email}</td>";
$srcImg = "";
if ($user->gender == "female") {
$srcImg = "img/femaleBunny2.jpg";
} else {
$srcImg = "img/maleBunny2.jpg";
}
// $user->gender
echo "<td><img src={$srcImg} class='img-responsive img-rounded'></td>";
$admin = "Admin";
if ($user->admin == 1) {
