+ $page->assign('onchange', 'changeAddressComponents(\'' . $type . '\', this.value)');
+ break;
+ case 'administrative_area_level_1':
+ case 'administrative_area_level_2':
+ case 'administrative_area_level_3':
+ case 'locality':
+ $page->assign('onchange', 'changeAddressComponents(\'' . $type . '\', this.value)');
+ case 'sublocality':
+ $ids = XDB::iterator("SELECT pace1.id, pace1.long_name AS field
+ FROM profile_addresses_components_enum AS pace1
+ INNER JOIN profile_addresses_components AS pac1 ON (pac1.component_id = pace1.id)
+ INNER JOIN profile_addresses_components AS pac2 ON (pac1.pid = pac2.pid AND pac1.jobid = pac2.jobid AND pac1.id = pac2.id
+ AND pac1.groupid = pac2.groupid AND pac1.type = pac2.type)
+ INNER JOIN profile_addresses_components_enum AS pace2 ON (pac2.component_id = pace2.id AND FIND_IN_SET({?}, pace2.types))
+ WHERE pace2.id = {?} AND FIND_IN_SET({?}, pace1.types)
+ GROUP BY pace1.long_name",
+ Env::v('previous'), Env::v('value'), $type);