$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";