Аякс подбор города профиля

ALTER TABLE `cms_user_profiles` ADD INDEX ( `city` );
ALTER TABLE `cms_user_profiles` ADD `geo` TEXT NOT NULL AFTER `city`;

112                {if $cfg.ask_icq}
                    <tr>
                        <td valign="top" class=""><strong>ICQ:</strong></td>
                        <td valign="top" class="">
                            <input name="icq" type="text" class="text-input" id="icq" value="{$item.icq}" style="width:300px"/>
                        </td>
                    </tr>
                {/if}

                    <tr>
                        <td valign="top" class="">
                            <div><strong>Город:</strong></div>
                            <div><small>Выберите город из списка</small></div>
                        </td>
                        <td valign="top" class="">
                            <input name="city" type="text" class="text-input" id="city" value="Введите первые символы" style="width:300px"/> <span class="regstar">*</span>
                            <input name="city_int" type="hidden" class="text-input" id="city_int" value=""/>
                            {literal}<script type="text/javascript">
                            $(function () {                       
                                $('#city').autocomplete({
                                serviceUrl: '/cities.php',
                                minChars: 1,
                                deferRequestBy: 300,
                                onSelect: function (value, data) {
                                    $('#city_int').val(data.id_city);
                                    $("#city").removeClass("bad_value");
                                    }
                                });
                                $("#city").focus(function(){
                                    if($(this).val()=='Введите первые символы')$(this).val('');
                                });
                                $("#city").blur(function(){
                                if(!$('#city_int').val()){
                                    $(this).addClass("bad_value");
                                    $(this).val('Введите первые символы');
                                }else $(this).removeClass("bad_value");
				});
                            });
                            </script>{/literal}
                            {add_js file='includes/jquery/autocomplete/jquery.autocomplete.js'}
                            {add_css file='includes/jquery/autocomplete/styles.css'}
                        </td>
                    </tr>

177	// День рождения

    $item['city_int'] = cmsCore::request('city_int', 'int', 0);
    $item['city'] = cmsCore::request('city', 'str', '');
    if(!$item['city_int']){cmsCore::addSessionMessage('Город необходимо выбрать из вариантов!', 'error');$errors = true;}
    else{
            $sql = "SELECT s.id_city, s.id_region, s.id_country, s.city_name_ru, r.region_name_ru, c.country_name_ru
FROM cms_geo_cities s
LEFT JOIN cms_geo_countries c ON s.id_country = c.id_country
LEFT JOIN cms_geo_regions r ON s.id_region = r.id_region
WHERE s.id_city={$item['city_int']}";
            $city = $inDB->query($sql);
            if($inDB->num_rows($city)){
                $city = $inDB->fetch_assoc($city);
                $item['city'] = $city['city_name_ru'];
                $item['geo'] = cmsCore::arrayToYaml($city);
            }else{cmsCore::addSessionMessage('Город необходимо выбрать из вариантов!', 'error');$errors = true;}
        }

53                        <td valign="top">
                            <input name="city" type="text" id="city" class="text-input" style="width:300px" value="{$usr.city|escape:'html'}"/>
                            <script type="text/javascript">
                                {$autocomplete_js}
                            </script>
                        </td>

                        <td valign="top" class="">
                            <input name="city" type="text" class="text-input" id="city" value="{$usr.city|escape:'html'}" style="width:300px"/>
                            <input name="city_int" type="hidden" class="text-input" id="city_int" value="{$usr.geo.id_city}"/>
                            {literal}<script type="text/javascript">
                            $(function () {                       
                                $('#city').autocomplete({
                                serviceUrl: '/cities.php',
                                minChars: 1,
                                deferRequestBy: 300,
                                onSelect: function (value, data) {
                                    $('#city_int').val(data.id_city);
                                    $("#city").removeClass("bad_value");
                                    }
                                });
                                $("#city").focus(function(){
                                    if($(this).val()=='Введите первые символы')$(this).val('');
                                });
                                $("#city").blur(function(){
                                if(!$('#city_int').val()){
                                    $(this).addClass("bad_value");
                                    $(this).val('Введите первые символы');
                                }else $(this).removeClass("bad_value");
				});
                            });
                            </script>{/literal}
                            {add_js file='includes/jquery/autocomplete/jquery.autocomplete.js'}
                            {add_css file='includes/jquery/autocomplete/styles.css'}
                        </td>

341                p.city, p.description, p.showmail, p.showbirth, p.showicq,

p.city, p.geo, p.description, p.showmail, p.showbirth, p.showicq,

368	$user['status_date'] = cmsCore::dateDiffNow($user['status_date']);

$user['geo']         = cmsCore::yamlToArray($user['geo']);

219 $smarty->assign('autocomplete_js', $inPage->getAutocompleteJS('citysearch', 'city', false));

210 $inPage->initAutocomplete();

238 if (mb_strlen($city)>25) { cmsCore::addSessionMessage($_LANG['LONG_CITY_NAME'], 'error'); $errors = true; }

            $city_int = cmsCore::request('city_int', 'int', 0);
            if(!$city_int){cmsCore::addSessionMessage('Город необходимо выбрать из вариантов!', 'error');$errors = true;}
            else{
                $sql = "SELECT s.id_city, s.id_region, s.id_country, s.city_name_ru, r.region_name_ru, c.country_name_ru
FROM cms_geo_cities s
LEFT JOIN cms_geo_countries c ON s.id_country = c.id_country
LEFT JOIN cms_geo_regions r ON s.id_region = r.id_region
WHERE s.id_city={$city_int}";
                $geo = $inDB->query($sql);
                if($inDB->num_rows($geo)){
                    $geo = $inDB->fetch_assoc($geo);
                    $city= $geo['city_name_ru'];
                    $geo = cmsCore::arrayToYaml($geo);
                }else{cmsCore::addSessionMessage('Город необходимо выбрать из вариантов!', 'error');$errors = true;}
            }