} $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); } // -------------------