DECLARE v_iso_tmp TEXT DEFAULT '';
+ DECLARE v_iso_tmp_tmp TEXT DEFAULT '';
DECLARE v_local_name_tmp TEXT DEFAULT '';
DECLARE v_type_tmp TEXT DEFAULT '';
DECLARE v_in_location_tmp INT DEFAULT 0;
SET v_city_id = 0;
SET v_iso_tmp = '';
+ SET v_iso_tmp_tmp = '';
SET v_local_name_tmp = '';
SET v_type_tmp = '';
SET v_in_location_tmp = 0;
IF v_type_tmp = 'RE' THEN
IF v_in_location_tmp != 0 THEN
- SELECT iso INTO v_iso_tmp FROM meta_location WHERE id = v_in_location;
+ SELECT iso INTO v_iso_tmp_tmp FROM meta_location WHERE id = v_in_location_tmp;
- SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_iso_tmp;
+ SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_iso_tmp_tmp;
END IF;
- SELECT id INTO v_divsion_id FROM core_geoip_divsion WHERE name = v_local_name_tmp AND country_id = v_country_id;
+ SELECT id INTO v_division_id FROM core_geoip_division WHERE name = v_local_name_tmp AND country_id = v_country_id;
END IF;
SELECT id INTO v_city_id FROM core_geoip_city WHERE name = v_local_name AND country_id = v_country_id AND division_id = v_division_id;
IF(v_city_id = 0) THEN
-
INSERT INTO core_geoip_city (name, country_id, division_id) VALUES (v_local_name, v_country_id, v_division_id);