function admin_rooms() { global $sr_default_chat_name; // Show Rooms Page if ($_SERVER['REQUEST_METHOD'] != 'POST') { if (!sr_is_signed_in()) { sr_redirect('/d/main/signin/'); } if (!sr_is_admin()) { sr_redirect('/d/'); } $db = sr_pdo(); $stmt = $db->prepare('SELECT * FROM room ORDER BY start_time DESC LIMIT 10'); $stmt->execute(); $room_list = $stmt->fetchAll(PDO::FETCH_CLASS, 'Room'); foreach ($room_list as $a_room) { $room_id = $a_room->id; $stmt = $db->prepare("SELECT name FROM participant WHERE room_id='{$room_id}'"); $stmt->execute(); $participants = $stmt->fetchAll(PDO::FETCH_COLUMN); $a_room->participants = ''; foreach ($participants as $a_participant) { if ($a_participant == '') { $a_participant = $sr_default_chat_name; } $a_room->participants .= $a_participant . '<br />'; } } $stmt = $db->prepare('SELECT * FROM room_log ORDER BY id DESC LIMIT 10'); $stmt->execute(); $room_log_list = $stmt->fetchAll(PDO::FETCH_CLASS, 'RoomLog'); foreach ($room_log_list as $a_room_log) { $room_id = $a_room_log->room_id; $stmt = $db->prepare("SELECT participant_name FROM participant_log WHERE type=2 AND room_id='{$room_id}'"); $stmt->execute(); $participants = $stmt->fetchAll(PDO::FETCH_COLUMN); $a_room_log->participants = ''; foreach ($participants as $a_participant) { if ($a_participant == '') { $a_participant = $sr_default_chat_name; } $a_room_log->participants .= $a_participant . '<br />'; } } $context = array('room_list' => $room_list, 'room_log_list' => $room_log_list); sr_response('views/admin/rooms.php', $context); // Handling Ajax Request } else { // Pagination or Filtering if ($_POST['type'] == 'pagination') { try { $db = sr_pdo(); $json = $_POST['filter']; $json = stripslashes($json); $filter = json_decode($json); $where = ''; $index = 0; foreach ($filter as $field => $value) { if ($index++ == 0) { $where .= 'WHERE '; } else { $where .= ' AND '; } $where .= $field . '=' . $value; } if ($_POST['table'] == 't1') { $total_record_number = Room::getRecordNum($filter); } else { $total_record_number = RoomLog::getRecordNum($filter); } if ($_POST['page_number'] == -1) { $beginRecordNum = (int) ($total_record_number / 10) * 10; } else { $beginRecordNum = ($_POST['page_number'] - 1) * 10; } if ($_POST['table'] == 't1') { $stmt = $db->prepare("SELECT * FROM room {$where} ORDER BY start_time DESC LIMIT {$beginRecordNum}, 10"); $stmt->execute(); $record_list = $stmt->fetchAll(PDO::FETCH_CLASS, 'Room'); foreach ($record_list as $a_room) { $room_id = $a_room->id; $stmt = $db->prepare("SELECT name FROM participant WHERE room_id='{$room_id}'"); $stmt->execute(); $participants = $stmt->fetchAll(PDO::FETCH_COLUMN); $a_room->participants = ''; foreach ($participants as $a_participant) { if ($a_participant == '') { $a_participant = $sr_default_chat_name; } $a_room->participants .= $a_participant . '<br />'; } } } else { $stmt = $db->prepare("SELECT * FROM room_log {$where} ORDER BY id DESC LIMIT {$beginRecordNum}, 10"); $stmt->execute(); $record_list = $stmt->fetchAll(PDO::FETCH_CLASS, 'RoomLog'); foreach ($record_list as $a_room_log) { $room_id = $a_room_log->room_id; $stmt = $db->prepare("SELECT participant_name FROM participant_log WHERE type=2 AND room_id='{$room_id}'"); $stmt->execute(); $participants = $stmt->fetchAll(PDO::FETCH_COLUMN); $a_room_log->participants = ''; foreach ($participants as $a_participant) { if ($a_participant == '') { $a_participant = $sr_default_chat_name; } $a_room_log->participants .= $a_participant . '<br />'; } } } $result = array('record_list' => $record_list, 'total_record_number' => $total_record_number); echo json_encode($result); } catch (PDOException $e) { } // Close Room Request } else { try { $db = sr_pdo(); $stmt = $db->prepare('SELECT * FROM room WHERE id = :id'); $stmt->bindParam(':id', $_POST['id']); $stmt->setFetchMode(PDO::FETCH_CLASS, 'Room'); $stmt->execute(); $room = $stmt->fetch(); $roomLog = new RoomLog(); $roomLog->room_id = $room->id; $roomLog->name = $room->name; $roomLog->title = $room->title; $roomLog->description = $room->description; $roomLog->is_open = $room->is_open; $roomLog->start_time = $room->start_time; $roomLog->end_time = Model::getCurrentTime(); $roomLog->add($db); $room->close($db); } catch (PDOException $e) { } } } }
function channel_destroyed_log($room) { $db = sr_pdo(); $r_log = new RoomLog(); $r_log->room_id = $room->id; $r_log->name = $room->name; $r_log->title = $room->title; $r_log->description = $room->description; $r_log->is_open = $room->is_open; $r_log->start_time = $room->start_time; $r_log->end_time = $r_log->getCurrentTime(); try { $r_log->add($db); } catch (PDOException $e) { // failed to write the log echo $e; } }