parameterHolder:
  action: index
  code: phone_city_codes
  module: services
attributeHolder:
  sf_route: 'sfRoute Object()'

options:
  http_protocol: HTTP/1.0
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery.reveal.js: {  }
  jquery.liveFilter.js: {  }
  scripts.js: {  }
  cusel-min-2.3.1.js: {  }
  jquery-spoiler_control.js: {  }
  cuselBig-min-2.3.1.js: {  }
  custom-1.js: {  }
stylesheets:
  style.css: {  }
metas:
  title: 'Рсправка - Телефонные коды'
  description: 'Почтовые индексы, авто коды, телефонные коды, схемы метро, коды мобильных операторов, часовые пояса и другая информация по городам России и мира'
  keywords: 'авто коды городов россии, почтовые индексы россии, почтовые индексы московской области, валюты стран мира, как узнать почтовый индекс, карта часовых поясов, часовые пояса мира онлайн, расшифровка штрих кода, схема метро спб, таблица размеров одежды разных стран, коды регионов россии авто, штрих коды стран производителей, телефонные коды стран мира, курсы валют мира, международные телефонные коды, международный код россии телефонный, меры веса таблица'
  language: ru
  robots: 'index, follow'
  x-ua-compatible: IE=EmulateIE7
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder:
  symfony/user/sfUser/attributes: { region_id: 0, rubrics_list_size: '40' }
culture: en

app_base_backend_url: /backend.php
app_base_frontend_url: /
app_briefcase_cookie_lifetime: 2419200
app_exhibition:
  illustrations: { path: /var/www/rspravkaru/www/uploads/exhibition_illustrations, url: /uploads/exhibition_illustrations }
app_exhibition_illustrations_path: /var/www/rspravkaru/www/uploads/exhibition_illustrations
app_exhibition_illustrations_url: /uploads/exhibition_illustrations
app_files_per_firm: 5
app_firm:
  price: { path: /var/www/rspravkaru/www/uploads/firm_prices, url: /uploads/firm_prices }
app_firm_drive_map_height: 46
app_firm_drive_map_width: 84
app_firm_drive_maps_path: /var/www/rspravkaru/www/uploads/firm_drive_maps
app_firm_drive_maps_url: /uploads/firm_drive_maps
app_firm_files_path: /var/www/rspravkaru/www/uploads/firm_files
app_firm_files_url: /uploads/firm_files
app_firm_logo:
  path: /var/www/rspravkaru/www/uploads/firm_logos
  url: /uploads/firm_logos
  size: { small: { width: 84, height: 46 }, medium: { width: 162, height: 89 } }
app_firm_photo_height: 46
app_firm_photo_width: 84
app_firm_photos_path: /var/www/rspravkaru/www/uploads/firm_photos
app_firm_photos_url: /uploads/firm_photos
app_firm_prices_path: /var/www/rspravkaru/www/uploads/firm_prices
app_firm_prices_url: /uploads/firm_prices
app_footer_services_count: 5
app_frontend_host: 'http://rspravka.ru'
app_hash_algo: sha512
app_hash_salt: 17bd053d4c1f6707574de3f2f71f5c4178f212f5c79de883259e9fd4bffa4938
app_months:
  - январь
  - февраль
  - март
  - апрель
  - май
  - июнь
  - июль
  - август
  - сентябрь
  - октябрь
  - ноябрь
  - декабрь
app_news_at_left_side: 5
app_news_illustration_height: 46
app_news_illustration_width: 84
app_news_illustrations_path: /var/www/rspravkaru/www/uploads/news_illustrations
app_news_illustrations_url: /uploads/news_illustrations
app_price_list_rows_per_page: 10
app_price_lists_per_firm: 3
app_rubric_icons_path: /var/www/rspravkaru/www/uploads/rubric_icons
app_rubric_icons_url: /uploads/rubric_icons
app_rubrics_list_size:
  - 20
  - 40
  - 60
app_rubrics_sort_types:
  rating: 'по посещаемости'
  alphabet: 'по алфавиту'
ex_meta_category: b2b
ex_meta_creator: Rspravka
ex_meta_description: 'Business Refernce System'
ex_meta_keywords: Rspravka
ex_meta_subject: Rspravka
ex_meta_title: 'Generated Excel File'
mod_default_default_firms_list_size: 10
mod_default_enabled: true
mod_default_firms_list_sizes:
  - 10
  - 20
  - 30
mod_default_is_internal: false
mod_default_pager_range: 4
mod_default_rubrics_columns_count: 2
mod_default_view_class: sfPHP
mod_services_enabled: true
mod_services_is_internal: false
mod_services_places_list_size: 50
mod_services_streets_list_size: 50
mod_services_view_class: sfPHP
sf_admin_module_web_dir: /sfPropelPlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /var/www/rspravkaru/cache/frontend
sf_app_cache_dir: /var/www/rspravkaru/cache/frontend/dev
sf_app_config_dir: /var/www/rspravkaru/apps/frontend/config
sf_app_dir: /var/www/rspravkaru/apps/frontend
sf_app_i18n_dir: /var/www/rspravkaru/apps/frontend/i18n
sf_app_lib_dir: /var/www/rspravkaru/apps/frontend/lib
sf_app_module_dir: /var/www/rspravkaru/apps/frontend/modules
sf_app_template_dir: /var/www/rspravkaru/apps/frontend/templates
sf_apps_dir: /var/www/rspravkaru/apps
sf_cache: false
sf_cache_dir: /var/www/rspravkaru/cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: false
sf_check_symfony_version: false
sf_compressed: false
sf_config_cache_dir: /var/www/rspravkaru/cache/frontend/dev/config
sf_config_dir: /var/www/rspravkaru/config
sf_csrf_secret: false
sf_data_dir: /var/www/rspravkaru/data
sf_debug: true
sf_default_culture: en
sf_doc_dir: /var/www/rspravkaru/doc
sf_enabled_modules:
  - default
  - sfPhpExcel
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: false
sf_i18n: false
sf_i18n_cache_dir: /var/www/rspravkaru/cache/frontend/dev/i18n
sf_lazy_cache_key: false
sf_lib_dir: /var/www/rspravkaru/lib
sf_log_dir: /var/www/rspravkaru/log
sf_logging_enabled: true
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_module_cache_dir: /var/www/rspravkaru/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: propel
sf_plugins_dir: /var/www/rspravkaru/plugins
sf_prototype_web_dir: /sfProtoculousPlugin
sf_rich_text_js_dir: js/tiny_mce
sf_root_dir: /var/www/rspravkaru
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
  - Partial
  - Cache
  - Form
sf_strip_comments: true
sf_symfony_lib_dir: /var/symfony/1.2/lib
sf_template_cache_dir: /var/www/rspravkaru/cache/frontend/dev/template
sf_test_cache_dir: /var/www/rspravkaru/cache/frontend/dev/test
sf_test_dir: /var/www/rspravkaru/test
sf_upload_dir: /var/www/rspravkaru/www/uploads
sf_use_database: true
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ' ↓ '
sf_validation_error_suffix: '  ↓'
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/rspravkaru/www
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false
symfony.view.services_index_layout: services
url_root: 'http://rspravka.ru'

cookie:
  firm_rating_108302: '1377976643'
  firm_rating_179267: '1377978084'
  firm_rating_194198: '1377976670'
  firm_rating_195288: '1377976918'
  firm_rating_202209: '1378057728'
  firm_rating_208346: '1378058770'
  firm_rating_210136: '1377976719'
  firm_rating_210142: '1377978027'
  firm_rating_210178: '1377977059'
  firm_rating_214851: '1377977014'
  firm_rating_219680: '1377978262'
  firm_rating_219682: '1378004583'
  firm_rating_225292: '1378004680'
  firm_rating_228456: '1377976590'
  firm_rating_228459: '1378059053'
  firm_rating_228462: '1377977034'
  firm_rating_236315: '1377978053'
  firm_rating_256237: '1377976943'
  firm_rating_259618: '1378031186'
  firm_rating_282590: '1377976744'
  firm_rating_28596: '1378058903'
  firm_rating_288116: '1377976616'
  firm_rating_291805: '1378004520'
  firm_rating_291906: '1378004395'
  firm_rating_29421: '1378057647'
  firm_rating_296493: '1377976899'
  firm_rating_296574: '1377976968'
  firm_rating_296582: '1378031078'
  firm_rating_296583: '1377976770'
  firm_rating_301652: '1377976817'
  firm_rating_323662: '1377978109'
  firm_rating_327309: '1378057691'
  firm_rating_327312: '1378057505'
  firm_rating_327313: '1378057574'
  firm_rating_335940: '1377976989'
  firm_rating_338504: '1377978156'
  firm_rating_345495: '1378004613'
  firm_rating_345504: '1377976867'
  firm_rating_357810: '1378057611'
  firm_rating_357822: '1377978182'
  firm_rating_357833: '1378031149'
  firm_rating_357834: '1378031114'
  firm_rating_357841: '1378057540'
  firm_rating_357848: '1377976694'
  firm_rating_361361: '1378004295'
  firm_rating_363584: '1378058703'
  firm_rating_369243: '1378058983'
  firm_rating_369245: '1378004487'
  firm_rating_370316: '1378059018'
  firm_rating_371046: '1377978208'
  firm_rating_371669: '1378004363'
  firm_rating_374651: '1377976529'
  firm_rating_379685: '1378058846'
  firm_rating_379863: '1378058809'
  firm_rating_379993: '1378058942'
  firm_rating_380332: '1378004548'
  firm_rating_380772: '1377978235'
  firm_rating_42499: '1378004424'
  firm_rating_44359: '1378004332'
  firm_rating_49644: '1378058667'
  firm_rating_5356: '1377978133'
  firm_rating_53662: '1378058737'
  firm_rating_53663: '1377976790'
  firm_rating_53672: '1377976839'
  firm_rating_82557: '1378030096'
  firm_rating_88987: '1377976555'
  firm_rating_88989: '1378004646'
  symfony: ht44j97k4edvq3k91c40m663h2
env: {  }
files: {  }
get: {  }
post: {  }
server:
  DOCUMENT_ROOT: /var/www/rspravkaru/www
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_CONNECTION: close
  HTTP_COOKIE: 'firm_rating_108302=1377976643; firm_rating_179267=1377978084; firm_rating_194198=1377976670; firm_rating_195288=1377976918; firm_rating_202209=1378057728; firm_rating_208346=1378058770; firm_rating_210136=1377976719; firm_rating_210142=1377978027; firm_rating_210178=1377977059; firm_rating_214851=1377977014; firm_rating_219680=1377978262; firm_rating_219682=1378004583; firm_rating_225292=1378004680; firm_rating_228456=1377976590; firm_rating_228459=1378059053; firm_rating_228462=1377977034; firm_rating_236315=1377978053; firm_rating_256237=1377976943; firm_rating_259618=1378031186; firm_rating_282590=1377976744; firm_rating_28596=1378058903; firm_rating_288116=1377976616; firm_rating_291805=1378004520; firm_rating_291906=1378004395; firm_rating_29421=1378057647; firm_rating_296493=1377976899; firm_rating_296574=1377976968; firm_rating_296582=1378031078; firm_rating_296583=1377976770; firm_rating_301652=1377976817; firm_rating_323662=1377978109; firm_rating_327309=1378057691; firm_rating_327312=1378057505; firm_rating_327313=1378057574; firm_rating_335940=1377976989; firm_rating_338504=1377978156; firm_rating_345495=1378004613; firm_rating_345504=1377976867; firm_rating_357810=1378057611; firm_rating_357822=1377978182; firm_rating_357833=1378031149; firm_rating_357834=1378031114; firm_rating_357841=1378057540; firm_rating_357848=1377976694; firm_rating_361361=1378004295; firm_rating_363584=1378058703; firm_rating_369243=1378058983; firm_rating_369245=1378004487; firm_rating_370316=1378059018; firm_rating_371046=1377978208; firm_rating_371669=1378004363; firm_rating_374651=1377976529; firm_rating_379685=1378058846; firm_rating_379863=1378058809; firm_rating_379993=1378058942; firm_rating_380332=1378004548; firm_rating_380772=1377978235; firm_rating_42499=1378004424; firm_rating_44359=1378004332; firm_rating_49644=1378058667; firm_rating_5356=1377978133; firm_rating_53662=1378058737; firm_rating_53663=1377976790; firm_rating_53672=1377976839; firm_rating_82557=1378030096; firm_rating_88987=1377976555; firm_rating_88989=1378004646; symfony=ht44j97k4edvq3k91c40m663h2'
  HTTP_HOST: rspravka.ru
  HTTP_REFERER: 'http://rspravka.ru/frontend.php/rubric/krasyashchie_veshchestva_pigmenty'
  HTTP_USER_AGENT: 'Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)'
  HTTP_X_FORWARDED_FOR: 207.241.237.206
  HTTP_X_REAL_IP: 207.241.237.206
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /services/phone_codes
  PATH_TRANSLATED: 'redirect:/index.php/phone_codes'
  PHP_SELF: /frontend.php/services/phone_codes
  QUERY_STRING: ''
  REMOTE_ADDR: 207.241.237.206
  REMOTE_PORT: '60837'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1378059086
  REQUEST_URI: /frontend.php/services/phone_codes
  SCRIPT_FILENAME: /var/www/rspravkaru/www/frontend.php
  SCRIPT_NAME: /frontend.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: '[no address given]'
  SERVER_NAME: rspravka.ru
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: "<address>Apache/2.2.16 (Debian) Server at rspravka.ru Port 80</address>\n"
  SERVER_SOFTWARE: 'Apache/2.2.16 (Debian)'
session:
  symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { region_id: 0, rubrics_list_size: '40' } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1378059053

php: 5.3.3-7+squeeze13
os: 'Linux cs8195 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64'
extensions:
  - 'Core (5.3.3-7+squeeze13)'
  - 'date (5.3.3-7+squeeze13)'
  - ereg
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - dba
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'fileinfo (1.0.5-dev)'
  - 'filter (0.11.0)'
  - ftp
  - gettext
  - session
  - iconv
  - 'json (1.2.1)'
  - mbstring
  - 'apc (3.1.3p1)'
  - posix
  - 'Reflection ($Revision: 300393 $)'
  - 'standard (5.3.3-7+squeeze13)'
  - shmop
  - 'SPL (0.2)'
  - soap
  - sockets
  - 'SimpleXML (0.1)'
  - 'exif (1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $)'
  - sysvmsg
  - sysvsem
  - sysvshm
  - 'tokenizer (0.1)'
  - wddx
  - xml
  - 'xmlreader (0.1)'
  - 'xmlwriter (0.1)'
  - 'zip (1.9.1)'
  - apache2handler
  - 'Phar (2.0.1)'
  - gd
  - 'geoip (1.0.7)'
  - mcrypt
  - 'memcache (3.0.4)'
  - 'mysql (1.0)'
  - 'mysqli (0.1)'
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_sqlite (1.0.1)'
  - 'SQLite (2.0-dev)'
  - 'sqlite3 (0.7-dev)'
  - 'suhosin (0.9.32.1)'
  - 'xsl (0.1)'
  - mhash

version: 1.2.12
path: /var/symfony/1.2/lib

1. SET NAMES 'utf8'
2. SELECT services.ID, services.NAME, services.CODE, services.ICON, services.COMPONENT, services.PARAMETERS, services.PRIORITY, services.ACTIVITY FROM `services` WHERE services.ACTIVITY=true AND services.CODE='phone_city_codes'
3. SELECT phone_country_codes.ID, phone_country_codes.NAME, phone_country_codes.CODE FROM `phone_country_codes` ORDER BY name ASC
4. SELECT articles.ID, articles.NAME, articles.CODE, articles.THUMBNAIL, articles.DESCRIPTION, articles.CREATE_DATE, articles.CREATE_DAY, articles.PAGE_TITLE, articles.PAGE_KEYWORDS, articles.PAGE_DESCRIPTION, articles.PRIORITY, articles.ACTIVITY FROM `articles`, `tags`, `articles__tags` WHERE articles.ACTIVITY=true AND tags.CODE='about' AND articles__tags.ARTICLE_ID=articles.ID AND articles__tags.TAG_ID=tags.ID ORDER BY articles.PRIORITY ASC
5. SELECT services.ID, services.NAME, services.CODE, services.ICON, services.COMPONENT, services.PARAMETERS, services.PRIORITY, services.ACTIVITY FROM `services` WHERE services.ACTIVITY>0 AND services.CODE='phone_city_codes' LIMIT 1
6. SELECT interesno.ID, interesno.SERVICE_ID, interesno.NAME, interesno.TEXT_SHORT, interesno.TEXT_FULL, interesno.ACTIVITY FROM `interesno` WHERE interesno.ACTIVITY>0 AND interesno.SERVICE_ID=13
7. SELECT services.ID, services.NAME, services.CODE, services.ICON, services.COMPONENT, services.PARAMETERS, services.PRIORITY, services.ACTIVITY FROM `services` WHERE services.ACTIVITY=true ORDER BY services.PRIORITY ASC
8. SELECT visitors.ID, visitors.EMAIL, visitors.PASSWORD, visitors.CODE, visitors.ACTIVITY, visitors.LASTIP, visitors.LASTLOGIN FROM `visitors` WHERE visitors.EMAIL IS NULL LIMIT 1
9. SELECT services.ID, services.NAME, services.CODE, services.ICON, services.COMPONENT, services.PARAMETERS, services.PRIORITY, services.ACTIVITY FROM `services` WHERE services.ACTIVITY=true ORDER BY services.PRIORITY ASC