}
$db->sql_freeresult($result);
}
}
for ($i = 1; $i <= $count_meeting_geo; $i++) {
$sql = 'SELECT geo_id FROM ' . GEO_TABLE . '
WHERE geo_link=\'' . $datageo[$i]['geolink'] . '\'';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$datageo[$i]['geoid'] = $row['geo_id'];
}
$db->sql_freeresult($result);
}
$sql = "UPDATE " . MEETING_DATA_TABLE . "\n\t\t\tSET meeting_geo1 = " . ($datageo[1]['geoid'] ? $datageo[1]['geoid'] : 0) . ",\n\t\t\t\tmeeting_geocheck_1 = " . $datageo[1]['chk'] . ",\n\t\t\t\tmeeting_geo2 = " . ($datageo[2]['geoid'] ? $datageo[2]['geoid'] : 0) . ",\n\t\t\t\tmeeting_geocheck_2 = " . $datageo[2]['chk'] . ",\n\t\t\t\tmeeting_geo3 = " . ($datageo[3]['geoid'] ? $datageo[3]['geoid'] : 0) . ",\n\t\t\t\tmeeting_geocheck_3 = " . $datageo[3]['chk'] . "\n\t\t\tWHERE meeting_id = " . $id;
$db->sql_query($sql);
$meeting->change_geodata_to_db($id, $datageo, $geo_max);
// Save to DB
if ($meeting_marshrut) {
$sql = 'SELECT meeting_id FROM ' . MARSHRUT_DATA_TABLE . '
WHERE marshrut_id=' . $meeting_marshrut;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$marshrut_formeeting = $row['meeting_id'];
}
$db->sql_freeresult($result);
}
if ($marshrut_formeeting == $id || $marshrut_formeeting == $next_id) {
$sql = "UPDATE " . MARSHRUT_DATA_TABLE . "\n\t\t\tSET marshrut_geo1 = " . ($datageo[1]['geoid'] ? $datageo[1]['geoid'] : 0) . ",\n\t\t\t\tmeeting_geocheck_1 = " . $datageo[1]['chk'] . ",\n\t\t\t\tmarshrut_geo2 = " . ($datageo[2]['geoid'] ? $datageo[2]['geoid'] : 0) . ",\n\t\t\t\tmeeting_geocheck_2 = " . $datageo[2]['chk'] . ",\n\t\t\t\tmarshrut_geo3 = " . ($datageo[3]['geoid'] ? $datageo[3]['geoid'] : 0) . ",\n\t\t\t\tmeeting_geocheck_3 = " . $datageo[3]['chk'] . "\n\t\t\tWHERE meeting_id = " . $id;
$db->sql_query($sql);
}
// -------------------
