$meeting_link_new = $marshrutrow['marshrut_link'];
$meeting_link_gps_new = htmlspecialchars_decode(urldecode($marshrutrow['marshrut_link_gps']));
$meeting_attributes = $marshrutrow['marshrut_attr'];
$meeting_hard = $marshrutrow['marshrut_hard'];
if (!$meeting_plain_road) {
$meeting_plain_road_1 = '';
$meeting_plain_road_2 = '';
$meeting_plain_road_3 = '';
$meeting_plain_road_4 = '';
$meeting_plain_road_5 = 100;
$meeting_plain_road = '0-0-0-0-100';
} else {
list($meeting_plain_road_1, $meeting_plain_road_2, $meeting_plain_road_3, $meeting_plain_road_4, $meeting_plain_road_5) = array_map('intval', explode('-', $meeting_plain_road));
}
}
$range_road = $meeting->road_construct($meeting_plain_road);
$sql = "SELECT *\n\t\tFROM " . REGION_TABLE . "\n\t\tWHERE region_id = {$meeting_region}";
$ranksresult = $db->sql_query($sql);
$region_row = $db->sql_fetchrowset($ranksresult);
$meeting_country_t = $user->lang['Tekushie'] . ' <img src="images/flags/' . $region_row[0]['region_flag'] . '.png " height="10" width="16" align="absmiddle"> -» ' . $region_row[0]['region_name'] . ' -»';
$meeting_country_m = ' <img src="images/flags/' . $region_row[0]['region_flag'] . '.png " height="10" width="16" align="absmiddle"> » ' . $region_row[0]['region_name'] . ' »';
$sql = "SELECT *\n\t\tFROM " . REGION_TOWN_TABLE . "\n\t\tWHERE name LIKE ('%{$meeting_town}%')";
$townresult = $db->sql_query($sql);
$town_row = $db->sql_fetchrowset($townresult);
$meeting_town_id = $town_row[0]['id'];
// ------------------------------------------
// ---------------Cîîðãàíèçàòîð--------------
//
$sql = 'SELECT z.*, u.username, u.username_clean
FROM ' . ZEBRA_TABLE . ' z, ' . USERS_TABLE . ' u
WHERE z.user_id = ' . $user->data['user_id'] . "\n\t\t\tAND z.friend = 1\n\t\t\tAND u.user_id = z.zebra_id\n\t\tORDER BY u.username_clean ASC";
