$legend_color = $row[26];
$parent_channel_id = $row[27];
$allow_search = $row[28];
$tag_minimum_date = $row[29];
$has_rss = $row[30];
if ($ascending != 0) {
$order = "";
} else {
$order = "DESC";
}
if ($crono == 1) {
$children = GetChildChannels($c, $dbh);
}
//check for incoming messages
if ($crono == 0 && $is_active == 1) {
CheckMessages($user, $pass, $c, $folder, $get_tags_from_subject, $mail_server, $dbh, $time_zone, $get_user_from_message_subject, $get_date_from_exif, $convert_to_mp3, $servpath, $sample_rate, $channel_folder, $static_map_width, $static_map_height, $google_maps_api_key, $get_reverse_geocoding, $ffmpeg_path);
} else {
if ($crono == 1 && $crono_random_check == true) {
CheckMessagesRandomChannel($get_tags_from_subject, $mail_server, $dbh, $time_zone, $get_user_from_message_subject, $get_date_from_exif, $convert_to_mp3, $servpath, $sample_rate, $channel_folder, $static_map_width, $static_map_height, $google_maps_api_key, $get_reverse_geocoding, $ffmpeg_path);
}
}
//////////////////////////////////////////////////////
//get search filter
if ($_SESSION['q'] == "") {
$qWhere = GetFilterMessageList($_SESSION['selection_list'], $dbh);
} else {
$qWhere = GetQMessageList($c, $_SESSION['q'], $dbh);
}
//TODO: refine for grouped cronos! DONE (check)
//if channel is bound to tags, refine filter. thumbnails = false!
$channel_filter = RefineChannelFilter($qWhere, $c, $crono, $dbh, $children);
PrintOrd('lastcomment', 'תגובה אחרונה');
print "</TR>\n";
CreateTmpTbl();
/* Create temporary blogs table */
$query = "SELECT blognum, name, blog_name, grp FROM bloglist";
$result = mysql_query($query);
if (!$result) {
echo mysql_error();
exit;
}
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$num = $line['blognum'];
$user = $line['name'];
$blog_name = addslashes($line['blog_name']);
$grp = $line['grp'];
$n = CheckMessages($num);
$lastmod = GetLastModTime($num);
$lastcomment = GetLastCommentTime($num);
$query = "INSERT INTO tmp VALUES ('{$num}', '{$user}', '{$blog_name}', '{$grp}', '{$n}', '{$lastmod}', '{$lastcomment}')";
$tmpresult = mysql_query($query);
if (!$tmpresult) {
echo mysql_error();
exit;
}
}
$query = "SELECT * FROM tmp ORDER BY {$sort} {$ord}";
$result = mysql_query($query);
if (!$result) {
echo mysql_error();
exit;
}
function CheckMessagesRandomChannel($get_tags_from_subject, $server, $dbh, $tz, $get_user_from_message_subject, $get_date_from_exif, $convert_to_mp3, $servpath, $sample_rate, $channel_folder, $static_map_width, $static_map_height, $api_key, $get_reverse_geocoding, $ffmpeg_path)
{
$query = "SELECT channel_mail,channel_pass,channel_id,channel_folder FROM channel WHERE is_active=1 AND is_crono=0 AND is_visible=1 AND channel_mail<>'' ORDER BY RAND() LIMIT 0,1";
$result = mysql_query($query, $dbh);
if ($row = mysql_fetch_array($result, MYSQL_NUM)) {
CheckMessages($row[0], $row[1], $row[2], $row[3], $get_tags_from_subject, $server, $dbh, $tz, $get_user_from_message_subject, $get_date_from_exif, $convert_to_mp3, $servpath, $sample_rate, $channel_folder, $static_map_width, $static_map_height, $api_key, $get_reverse_geocoding, $ffmpeg_path);
}
}
