WHERE `users`.`uid` = `node`.`uid` AND `content_type_stream_channel`.`nid`=`node`.`nid` AND `node`.`status` = 1 ORDER BY `node`.`changed` DESC LIMIT 100'; $queryPrimeTimeStreamNoRubric = 'SELECT `node`.`nid` AS `stream_id`, `node`.`title` AS `stream_title` FROM `content_type_prime_stream`, `node`, `users` WHERE `users`.`uid` = `node`.`uid` AND `content_type_prime_stream`.`nid`=`node`.`nid` AND NOW() >`content_type_prime_stream`.`field_prime_time_value` AND `node`.`status` = 1 AND `content_type_prime_stream`.`field_prime_rubric_value` = 0 ORDER BY `node`.`created` DESC LIMIT 20'; $data[] = array('channelId' => '0', 'channelTitle' => 'main'); $data[] = array('channelId' => PRIME_TIME_CHANNEL_ID, 'channelTitle' => PRIME_TIME_CHANNEL_TITLE); $data = array_merge($data, GetDataByQuery($queryStreamChannel), GetDataByQuery($queryPrimeTimeStreamNoRubric)); $dataJson = json_encode(array('channel' => $data)); $channelsFile = CHAT_MEMFS_DIR . '/channels_history.json'; file_put_contents($channelsFile, $dataJson); function GetDataByQuery($queryString) { global $db; $queryResult = $db->Query($queryString); if ($queryResult === false) { return false; } $data = array(); $maxLength = 100; while ($channel = $queryResult->fetch_assoc()) { if (mb_strlen($channel['stream_title']) > $maxLength) { $channel['stream_title'] = mb_substr($channel['stream_title'], 0, $maxLength) . '...';
UNIX_TIMESTAMP(`content_type_prime_stream`.`field_prime_time_value`) + `content_type_prime_stream`.`field_prime_time_offset` ) AND `node`.`status` = 1 ORDER BY `timeCreated` DESC'; $queryStreamChannel = 'SELECT `node`.`nid` AS `stream_id`, `node`.`title` AS `stream_title`, `node`.`created` AS `timeCreated`, `users`.`name` as `streamer_name` FROM `content_type_stream_channel`, `node`, `users` WHERE `content_type_stream_channel`.`field_stream_channel_status_value`=1 AND `users`.`uid` = `node`.`uid` AND `content_type_stream_channel`.`nid`=`node`.`nid` ORDER BY `timeCreated` DESC'; $data[] = array('channelId' => '0', 'channelTitle' => 'main'); $data = array_merge($data, GetDataByQuery($queryPrimeTimeStream, $isPrimeTimeQuery = TRUE), GetDataByQuery($queryStreamChannel)); $dataJson = json_encode(array('channel' => $data)); $channelsFile = CHAT_MEMFS_DIR . '/channels.json'; file_put_contents($channelsFile, $dataJson); function GetDataByQuery($queryString, $isPrimeTimeQuery = FALSE) { global $db; $queryResult = $db->Query($queryString); if ($queryResult === false) { return false; } $data = array(); $maxLength = 100; $primeTimeStreamsCount = 0; while ($channel = $queryResult->fetch_assoc()) { if (mb_strlen($channel['stream_title']) > $maxLength) {