parameterHolder:
  action: show
  id: '638'
  module: game
attributeHolder:
  sf_route: 'sfRoute Object()'

options:
  http_protocol: HTTP/1.1
  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:
  main.js: {  }
  jquery-1.4.2.min.js: {  }
stylesheets:
  styles.css: {  }
metas:
  title: 'Мир Мафии – Все о карточной игре Мафия: тактика, клубы, игры, видео. Ролевая психологическая  настольная игра Мафия. Где поиграть в Мафию в Москве, в Киеве, в Санкт-Петербурге, в Питере, в СПб.'
  description: 'Все о карточной игре Мафия: тактика, клубы, игры, видео. Ролевая психологическая  настольная игра Мафия. Где поиграть в Мафию.'
  keywords: 'ролевая психологическая  настольная карточная игра Мафия, где поиграть в Мафию'
  language: en
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 5400
attributeHolder: {  }
culture: en

app_captcha_add: 11
app_count_users_on_page: 20
app_default_photo_cover: /images/default_video.png
app_default_static_page_picture: /images/headers/defult.png
app_default_video_cover: /images/default_video.png
app_letter_subscribe_footer: '<br>----<br>C уважением,<br>Администрация портала MirMafii.ru<br><br>P.S. Уважаемые пользователи портала MirMafii.ru! Хотя нам очень хотелось бы иметь возможность напрямую общаться с вами, чтобы сообщать о важных новостях и интересных материалах об игре Мафия, мы понимаем, что получение рассылки - дело абсолютно добровольное. Чтобы отписаться от рассылки, перейдите по ссылке <a href=''http://Mirmafii.ru/users/unsetSendingEmail/code/%s''>MirMafii.ru/users/unsetSendingEmail/code/%s</a>'
app_promote_products_limit: 3
app_sfAssetsLibrary_upload_dir: media
app_sf_captchagd_chars: '123456789'
app_sf_captchagd_font_size: 24
app_sf_captchagd_image_height: 40
app_sf_captchagd_image_width: 100
app_sf_captchagd_length: 2
app_sf_guard_plugin_remember_cookie_name: myAppRememberMe
app_sf_guard_plugin_remember_key_expiration_age: 2592000
app_url: 'http://MirMafii.ru'
mod_block_enabled: true
mod_block_is_internal: false
mod_block_view_class: sfPHP
mod_game_enabled: true
mod_game_is_internal: false
mod_game_view_class: sfPHP
sf_admin_module_web_dir: /sfPropelPlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/u98615/mirmafii.ru/cache/frontend
sf_app_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev
sf_app_config_dir: /home/u98615/mirmafii.ru/apps/frontend/config
sf_app_dir: /home/u98615/mirmafii.ru/apps/frontend
sf_app_i18n_dir: /home/u98615/mirmafii.ru/apps/frontend/i18n
sf_app_lib_dir: /home/u98615/mirmafii.ru/apps/frontend/lib
sf_app_module_dir: /home/u98615/mirmafii.ru/apps/frontend/modules
sf_app_template_dir: /home/u98615/mirmafii.ru/apps/frontend/templates
sf_apps_dir: /home/u98615/mirmafii.ru/apps
sf_cache: false
sf_cache_dir: /home/u98615/mirmafii.ru/cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: false
sf_check_symfony_version: false
sf_compat_10: true
sf_compressed: false
sf_config_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/config
sf_config_dir: /home/u98615/mirmafii.ru/config
sf_csrf_secret: false
sf_data_dir: /home/u98615/mirmafii.ru/data
sf_debug: true
sf_default_culture: en
sf_doc_dir: /home/u98615/mirmafii.ru/doc
sf_enabled_modules:
  - default
  - sfGuardAuth
  - sfCaptchaGD
  - sfAsset
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: system
sf_error_reporting: 8191
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: false
sf_execution_filter:
  - sfValidationExecutionFilter
  - {  }
sf_i18n: false
sf_i18n_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/i18n
sf_lazy_cache_key: false
sf_lib_dir: /home/u98615/mirmafii.ru/lib
sf_log_dir: /home/u98615/mirmafii.ru/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_max_forwards: 5
sf_module_cache_dir: /home/u98615/mirmafii.ru/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: /home/u98615/mirmafii.ru/plugins
sf_prototype_web_dir: /sfProtoculousPlugin
sf_rich_text_js_dir: js/tiny_mce
sf_root_dir: /home/u98615/mirmafii.ru
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - Form
sf_strip_comments: true
sf_symfony_lib_dir: /home/u98615/mirmafii.ru/lib/symfony
sf_template_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/template
sf_test_cache_dir: /home/u98615/mirmafii.ru/cache/frontend/dev/test
sf_test_dir: /home/u98615/mirmafii.ru/test
sf_upload_dir: /home/u98615/mirmafii.ru/config/../www/uploads
sf_use_database: true
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ' &darr;&nbsp;'
sf_validation_error_suffix: ' &nbsp;&darr;'
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/u98615/mirmafii.ru/config/../www
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false
symfony.view.slot_names: {  }

cookie:
  symfony: d326eaefac803a866b232392d0f23708
env: {  }
files: {  }
get: {  }
post: {  }
server:
  DOCUMENT_ROOT: /home/u98615/mirmafii.ru/www
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_CACHE_CONTROL: max-age=259200
  HTTP_COOKIE: symfony=d326eaefac803a866b232392d0f23708
  HTTP_HOST: mirmafii.ru
  HTTP_MH_GEOIP_COUNTRY_CODE: US
  HTTP_PORT: '80'
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_VIA: '1.1 squid-proxy-5b5d847c96-gnxlh (squid/6.10)'
  HTTP_X_FORWARDED_FOR: '10.3.15.135, 216.73.216.141, 216.73.216.141'
  HTTP_X_FORWARDED_PORT: '80'
  HTTP_X_MH_HOST: mirmafii.ru
  HTTP_X_REAL_IP: 216.73.216.141
  LANG: ru_RU.CP1251
  MAGICK_THREAD_LIMIT: '1'
  MM_CHARSET: CP1251
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: /game/show/id/638
  PATH_TRANSLATED: 'redirect:/index.php/show/id/638'
  PHP_SELF: /frontend_dev.php/game/show/id/638
  QUERY_STRING: ''
  REMOTE_ADDR: 216.73.216.141
  REMOTE_PORT: '37493'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1755649457
  REQUEST_URI: /frontend_dev.php/game/show/id/638
  SCRIPT_FILENAME: /home/u98615/mirmafii.ru/www/frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: support@masterhost.ru
  SERVER_NAME: mirmafii.ru
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  UNIQUE_ID: aKUVsX8AAQEAAGAQ8QAAAAAD
  argc: 0
  argv: {  }
session:
  symfony/user/sfUser/attributes: {  }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1755649457

php: 5.2.17-2+mh3
os: 'Linux dbe605.hs.shared.masterhost.ru 3.14.51-grsec #1 SMP Fri Oct 21 13:38:02 UTC 2016 x86_64'
extensions:
  - 'date (5.2.17-2+mh3)'
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - dba
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'filter (0.11.0)'
  - ftp
  - gettext
  - session
  - iconv
  - 'json (1.2.1)'
  - mbstring
  - 'mime_magic (0.1)'
  - posix
  - 'Reflection (0.1)'
  - 'standard (5.2.17-2+mh3)'
  - shmop
  - 'SimpleXML (0.1)'
  - soap
  - sockets
  - 'SPL (0.2)'
  - '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.8.11)'
  - apache2handler
  - curl
  - 'dbase (5.1.0)'
  - gd
  - imap
  - 'mysql (1.0)'
  - mcrypt
  - 'mysqli (0.1)'
  - mssql
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_dblib (1.0.1)'
  - 'xsl (0.1)'
  - 'SQLite (2.0-dev)'
  - 'pdo_sqlite (1.0.1)'
  - 'imagick (3.1.0RC1)'
  - 'intl (PECL-3.0.0)'
  - 'Zend Optimizer'

version: 1.2.8
path: /home/u98615/mirmafii.ru/lib/symfony

1. SET NAMES 'utf8'
2. SELECT game.ID, game.TIME_BEGIN, game.DATE_BEGIN, game.TITLE, game.DESCRIPTION, game.SMALL_DESCRIPTION, game.CLUB_ID, game.CITY_ID, game.IN_MENU, game.IN_AFFICHE, game.TO_PUBLISH, game.SITE_TITLE, game.ADDRESS, game.IF_PERIOD, game.CREATED_AT, game.UPDATED_AT, game.REDIRECT_CASE FROM `game` WHERE game.ID='638'
3. SELECT comment.ID, comment.ITEM_ID, comment.AUTHOR_ID, comment.TYPE, comment.COMMENT_TYPE_ID, comment.NAME, comment.TEXT, comment.CREATED_AT FROM `comment`, `comment_type` WHERE comment_type.SNAME='game' AND comment.ITEM_ID='638' AND comment.COMMENT_TYPE_ID=comment_type.ID ORDER BY comment.CREATED_AT DESC
4. SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ID=1 LIMIT 1
5. SELECT club.ID, club.NAME, club.URL, club.DESCRIPTION, club.SMALL_DESCRIPTION, club.ADDRESS, club.PHONE, club.EMAIL, club.CITY_ID, club.MAIN_MENU, club.INVISIBLE, club.IMAGE, club.SITE_TITLE, club.COUNT_ARTICLES, club.COUNT_MEMBERS, club.RATING_DATE, club.RATING_USER_ID, club.RATING_REVIEW_ID, club.RATING_COMMENT, club.CREATED_AT, club.UPDATED_AT FROM `club` WHERE club.ID=129 LIMIT 1
6. SELECT ips_cityes.ID, ips_cityes.FIRST_IP, ips_cityes.LAST_IP, ips_cityes.CITY_ID, ips_cityes.CITY_NAME, ips_cityes.REGION, ips_cityes.ZONE FROM `ips_cityes` WHERE ips_cityes.FIRST_IP<=3628718221 AND ips_cityes.LAST_IP>=3628718221 ORDER BY ips_cityes.ID DESC LIMIT 1
7. SELECT banner.ID, banner.NAME, banner.SNAME, banner.BANNER_PLACE_ID, banner.CITY_ID, banner.HTMLCODE, banner.ZONE, banner.SHOW_BEGIN, banner.SHOW_END, banner.COUNT_VIEWS, banner.COUNT_CLICKS FROM `banner`, `banner_place` WHERE banner.CITY_ID=1 AND banner_place.SNAME='top' AND (banner.SHOW_BEGIN<='2025-08-20' OR banner.SHOW_BEGIN IS NULL ) AND (banner.SHOW_END>='2025-08-20' OR banner.SHOW_END IS NULL ) AND banner_place.ID=banner.BANNER_PLACE_ID
8. SELECT banner_place.ID, banner_place.NAME, banner_place.SNAME, banner_place.DEFAULT_IMAGE FROM `banner_place` WHERE banner_place.SNAME='top' LIMIT 1
9. SELECT project_setting.ID, project_setting.SETTING_KEY, project_setting.SETTING_VALUE FROM `project_setting` WHERE project_setting.SETTING_KEY='default_city_id' LIMIT 1
10. SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ID<>'1' AND city.MAIN_MENU=1 ORDER BY city.ORDERING ASC,city.NAME ASC
11. SELECT club.*, vip_club.id is null as isnull FROM `club` LEFT JOIN vip_club ON (club.ID=vip_club.CLUB_ID and vip_club.show_begin < '2025-08-20' and vip_club.show_end > '2025-08-20' ) WHERE club.INVISIBLE !=1 ORDER BY club.city_id, isnull,vip_club.vip_type, club.COUNT_ARTICLES DESC,club.COUNT_MEMBERS DESC
12. SELECT project_setting.ID, project_setting.SETTING_KEY, project_setting.SETTING_VALUE FROM `project_setting` WHERE project_setting.SETTING_KEY='default_city_id' LIMIT 1
13. SELECT game.*, vip_club.id is null as isnull FROM `game` LEFT JOIN `club` ON game.club_id = club.id LEFT JOIN vip_club ON (club.ID=vip_club.CLUB_ID and vip_club.show_begin < '2025-08-20' and vip_club.show_end > '2025-08-20' ) WHERE club.INVISIBLE !=1 AND game.city_id = '1' AND game.in_menu = 1 AND game.time_begin > '2025-08-20' and game.time_begin < '2025-08-27' ORDER BY isnull,vip_club.vip_type, club.COUNT_ARTICLES DESC,club.COUNT_MEMBERS DESC
14. SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city`, `game` WHERE game.IN_MENU=1 AND game.TIME_BEGIN>='2025-08-20 00:00:00' AND game.CITY_ID=city.ID GROUP BY city.ID ORDER BY game.CITY_ID ASC,game.TIME_BEGIN ASC
15. SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ORDERING<1 ORDER BY city.ORDERING DESC LIMIT 1
16. SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` ORDER BY city.ORDERING DESC LIMIT 1
17. SELECT city.ID, city.NAME, city.SNAME, city.DESCRIPTION, city.MAIN_MENU, city.ORDERING, city.SITE_TITLE, city.ZONE, city.CREATED_AT, city.UPDATED_AT FROM `city` WHERE city.ORDERING>1 ORDER BY city.ORDERING ASC LIMIT 1
18. SELECT ips_cityes.ID, ips_cityes.FIRST_IP, ips_cityes.LAST_IP, ips_cityes.CITY_ID, ips_cityes.CITY_NAME, ips_cityes.REGION, ips_cityes.ZONE FROM `ips_cityes` WHERE ips_cityes.FIRST_IP<=3628718221 AND ips_cityes.LAST_IP>=3628718221 ORDER BY ips_cityes.ID DESC LIMIT 1
19. SELECT banner.ID, banner.NAME, banner.SNAME, banner.BANNER_PLACE_ID, banner.CITY_ID, banner.HTMLCODE, banner.ZONE, banner.SHOW_BEGIN, banner.SHOW_END, banner.COUNT_VIEWS, banner.COUNT_CLICKS FROM `banner`, `banner_place` WHERE banner.CITY_ID=1 AND banner_place.SNAME='right' AND (banner.SHOW_BEGIN<='2025-08-20' OR banner.SHOW_BEGIN IS NULL ) AND (banner.SHOW_END>='2025-08-20' OR banner.SHOW_END IS NULL ) AND banner_place.ID=banner.BANNER_PLACE_ID
20. SELECT banner_place.ID, banner_place.NAME, banner_place.SNAME, banner_place.DEFAULT_IMAGE FROM `banner_place` WHERE banner_place.SNAME='right' LIMIT 1