$_SESSION['lesson_rooms'][] = str_replace(' ', '_', $_SESSION["lessonid"]); } //$my_t=getdate(); //$_SESSION["last_lesson_msg"] = $my_t[year].'-'.$my_t[mon].'-'.$my_t[mday].' '.$my_t[hours].':'.$my_t[minutes].':'.$my_t[seconds]; $_SESSION['last_lesson_msg'] = date("Y-m-d H:i:s", time() - date("Z")); //Fix for timezone differences } } else { $link = str_replace('_', ' ', $_SESSION["lessonname"]); //$room = str_replace(' ','_',$_SESSION["lessonname"]); //$room = str_replace('"','',$room); //$room = str_replace('\'','',$room); echo '<p><a href="javascript:void(0)" title="' . $_SESSION["lessonname"] . '" onClick="javascript:chatWithLesson(\'' . $_SESSION["lessonid"] . '\', \'' . $_SESSION["lessonname"] . '\')">' . mb_substr($link, 0, 24) . ' (Room)</a></p>'; } } $onlineUsers = getConnectedUsers(); if ($_SESSION['utype'] == 'administrator') { foreach ($onlineUsers as $user) { if ($user['login'] != $_SESSION['chatter']) { echo '<p><a href="javascript:void(0)" onClick="javascript:chatWith(\'' . $user['login'] . '\')">' . mb_substr($user['formattedLogin'], 0, 30) . '</a></p>'; } } } else { foreach ($onlineUsers as $user) { if ($user['login'] != $_SESSION['chatter']) { if ($_SESSION['commonality'][$user['login']] > 0) { echo '<p><a href="javascript:void(0)" onClick="javascript:chatWith(\'' . $user['login'] . '\')">' . mb_substr($user['formattedLogin'], 0, 30) . '</a></p>'; } } } }
while ($rep = $req->fetch(PDO::FETCH_OBJ)) { $msg .= htmlspecialchars_decode($rep->msg, ENT_QUOTES) . "\n"; } $reqDel = $db->prepare("DELETE FROM ploucs_messages WHERE toId = :id"); $reqDel->execute(array('id' => $clientID)); if ($req->rowCount() == $reqDel->rowCount()) { echo $msg; } //Delete the users who are disconnected by time-out. $req = $db->query("SELECT userId FROM ploucs_connected WHERE last_date < CURRENT_TIMESTAMP() - INTERVAL 30 SECOND"); if ($req->rowCount() > 0) { $query = $db->prepare("DELETE FROM ploucs_connected WHERE last_date < CURRENT_TIMESTAMP() - INTERVAL 30 SECOND"); $query->execute(); //If we are the one who was the first to delete the disconnected user (Case of someone else reached the SELECT before the right user reach the DELETE) if ($req->rowCount() == $query->rowCount()) { $users = getConnectedUsers(); while ($rep = $req->fetch(PDO::FETCH_OBJ)) { foreach ($users as $u) { sendCMDTo("dcn", $u, "dcn:" . $rep->userId); } } } } } catch (PDOException $e) { echo $query . ": " . $e->getMessage(); } } } } else { echo "NO"; }