Files
Testing/arrowchat2/includes/json/receive/receive_chatroom_list.php

144 lines
4.4 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/*
|| #################################################################### ||
|| # ArrowChat # ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright <20>2010-2012 ArrowSuites LLC. All Rights Reserved. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- ARROWCHAT IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.arrowchat.com | http://www.arrowchat.com/license/ # ||
|| #################################################################### ||
*/
// ########################## INCLUDE BACK-END ###########################
require_once (dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . 'bootstrap.php');
require_once (dirname(dirname(dirname(dirname(__FILE__)))) . DIRECTORY_SEPARATOR . AC_FOLDER_INCLUDES . DIRECTORY_SEPARATOR . 'init.php');
// ########################### INITILIZATION #############################
$response = array();
$chatrooms = array();
$time = time();
$chatroom_window = get_var('chatroom_window');
$chatroom_stay = get_var('chatroom_stay');
// ###################### START CHATROOM WINDOW CHECK ####################
if (logged_in($userid))
{
if ($chatroom_window != "-1")
{
$db->execute("
UPDATE arrowchat_status
SET chatroom_window = '0'
WHERE userid = '" . $db->escape_string($userid) . "'
");
}
if ($chatroom_stay != "-1")
{
$result = $db->execute("
SELECT chatroom_unfocus
FROM arrowchat_status
WHERE userid = '" . $db->escape_string($userid) . "'
");
if ($result AND $db->count_select() > 0)
{
$row = $db->fetch_array($result);
$chatroom_unfocus_insert = $row['chatroom_unfocus'];
$chatroom_unfocus_array = unserialize($row['chatroom_unfocus']);
if (is_array($chatroom_unfocus_array))
{
if (!in_array($chatroom_stay, $chatroom_unfocus_array) AND !empty($chatroom_stay))
{
$chatroom_unfocus_array[] = $chatroom_stay;
$chatroom_unfocus_insert = serialize($chatroom_unfocus_array);
}
}
}
$db->execute("
UPDATE arrowchat_status
SET chatroom_stay = '0',
chatroom_unfocus = '" . $db->escape_string($chatroom_unfocus_insert) . "'
WHERE userid = '" . $db->escape_string($userid) . "'
");
}
}
// ##################### START CHATROOM LIST RECEIVE #####################
if (logged_in($userid))
{
$result = $db->execute("
SELECT id, name, description, image, type, length, session_time, is_featured
FROM arrowchat_chatroom_rooms
ORDER BY id ASC
");
while ($chatroom = $db->fetch_array($result))
{
$result2 = $db->execute("
SELECT COUNT(user_id)
FROM arrowchat_chatroom_users
WHERE (chatroom_id='" . $db->escape_string($chatroom['id']) . "'
AND session_time > (" . $time . " - 70))
");
$count = $db->fetch_array($result2);
$not_expired = true;
$result3 = $db->execute("
SELECT sent
FROM arrowchat_chatroom_messages
WHERE chatroom_id = '" . $db->escape_string($chatroom['id']) . "'
ORDER BY sent DESC
LIMIT 1
");
$last_sent = $db->fetch_array($result3);
if (!$result OR $db->count_select() < 1)
{
$last_sent = NULL;
}
if (!empty($chatroom['length']))
{
$length = $chatroom['length'] * 60;
if ((($last_sent['sent'] + $length) < $time AND !empty($last_sent)) OR (($chatroom['session_time'] + $length) < $time AND empty($last_sent)))
{
$not_expired = false;
}
}
$other_chatroom = 1;
if (empty($chatroom['image']))
$chatroom['image'] = "chatroom_default.png";
if ($chatroom['is_featured'] == 1)
$other_chatroom = 0;
if (empty($chatroom['description']))
$chatroom['description'] = $language[150];
if ($not_expired AND ($chatroom['type'] != 3 OR ($chatroom['type'] == 3 AND ($is_admin == 1 OR $is_mod == 1))))
{
$chatroom['name'] = str_replace("\\'", "'", $chatroom['name']);
$chatrooms[] = array('id' => $chatroom['id'], 'n' => $chatroom['name'], 'd' => $chatroom['description'], 'img' => $chatroom['image'], 't' => $chatroom['type'], 'c' => $count['COUNT(user_id)'], 'o' => $other_chatroom);
}
}
$response['chatrooms'] = $chatrooms;
}
header('Content-type: application/json; charset=UTF-8');
echo json_encode($response);
close_session();
exit;
?>