options:
  path_info_key: PATH_INFO
  path_info_array: SERVER
  http_port: null
  https_port: null
  default_format: null
  logging: '1'
  relative_url_root: null
  formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml, rss: application/rss+xml }
  no_script_name: false
parameterHolder:
  action: publish
  module: directory
  sf_culture: en
attributeHolder:
  sf_route: 'sfRoute Object()'

status:
  code: 200
  text: OK
options:
  http_protocol: HTTP/1.1
  logging: '1'
  charset: utf-8
  send_http_headers: false
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery_min: {  }
  secure: {  }
  jquery_migrate: {  }
  jquery_carousel.min.js: {  }
  headerbanner.js: {  }
  jquery.dataTables.js: {  }
  moment.min.js: {  }
  datetime-moment.js: {  }
  common.js: {  }
  jqcloud.min.js: {  }
stylesheets:
  main.css: { media: screen }
  print.css: { media: print }
  jquery.dataTables.css: { media: screen }
  font-awesome.min.css: { media: screen }
  jqcloud.min.css: { media: screen }
  jquery.awesomeCloud-0.2.min.js: { media: screen }
metas:
  title: 'DEALGATE | The global platform for M&A professionals'
  description: 'DEALGATE | The global platform for M&A professionals'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: en
  default_culture: en
  use_flash: true
  logging: '1'
  timeout: 1800
attributeHolder: {  }
culture: en
authenticated: false
credentials: {  }
lastRequest: 1713863596

app_anonyme_ablehnung_anzahl: 14
app_anonyme_ablehnung_zeitraum: d
app_application: portal
app_bol_credit_card_payment: true
app_bol_debug: false
app_bol_debug_step_1: false
app_bol_debug_step_2: false
app_bol_multi_language: false
app_bounce_back_email_address: bounceback@dealgate.com
app_credit_card_environment: prod
app_customercare_email_address_from: customercare@dealgate.com
app_customercare_email_address_to_cc: sales@dealgate.com
app_deactivate_opp_on_membership_change: false
app_dealgate_info_email_address_to: beat.dolder@dealgate.com
app_default_lang: en
app_dev_key: ec3d25d7ad7f6c29c9bfd73dec4d2399e0d3b3635bd6c7fbce7aab9ccb51ab41edb01c0a31d9c03e3b955e3e542e4136e4054668e1314b087e738eca29786989
app_dev_key_ajax: 3d64f6e1582d046bca58fd8e8e45b5e4703879b05bb73e8ef13a93c30612a83b965ec6964625c9350f112dc843764f08af2741b7a9f464e0f5f7f76b6c95e810
app_dev_key_hd: ec3d25d7ad7f6c29c9bfd73dec4d2399e0d3b3635bd6c7fbce7aab9ccb51ab41edb01c0a31d9c03e3b955e3e542e4136e4054668e1314b087e738eca29786989
app_dev_key_recurring: 3edcf17192409c3e19926242809078970d2d84c5d9b96df23a8b5425a29c342a463070fa724f77f9876be24b03b746da1067f3f1def1cf1899401c16a7c7487f
app_dev_merchant_id: 1100003074
app_dev_merchant_id_recurring: 1100003179
app_dev_sign: 130307135858433673
app_dev_url_authorize_split: 'https://pilot.datatrans.biz/upp/jsp/XML_authorizeSplitEx.jsp'
app_dev_url_include_js: 'https://pilot.datatrans.biz/upp/ajax/api.js?merchantId='
app_dev_url_recurring_billing: 'https://pilot.datatrans.biz/upp/jsp/XML_authorize.jsp'
app_dev_url_settlement: 'https://pilot.datatrans.biz/upp/jsp/XML_processor.jsp'
app_ebitda_multiplier: 1000000
app_email_confirm_anzahl: 14
app_email_confirm_zeitraum: d
app_finance_email_address_to: finance@dealgate.com
app_host: www.dealgate.com
app_humandigital_error_email_address_to: team@humandigital.ch
app_humandigital_info_email_address_to: dealgate.blind@humandigital.ch
app_join_via_recom_anzahl: 2
app_join_via_recom_zeitraum: m
app_library_document_anzahl: 2
app_library_document_zeitraum: Y
app_linked_in_api_key_dev: 750o55ugyq8u7c
app_linked_in_api_key_prod: 759na4py2u0qo6
app_mailservice_email_address_from: mailservice@dealgate.com
app_mailservice_email_address_from_reminder: customercare@dealgate.ch
app_mailservice_email_address_to: beat.dolder@dealgate.com
app_max_dauer_mitgliedschaft_monate: 18
app_max_suchtreffer_per_page: 100
app_max_suchtreffer_per_page_iframe: 1000
app_membership_mm_anzahl: 1
app_membership_mm_zeitraum: Y
app_my_profile_anzahl: 3
app_my_profile_zeitraum: m
app_no_reply_email_address_from: no-reply@dealgate.com
app_opportunities_email_address_from: opportunities@dealgate.com
app_opportunity_ansehen_anzahl: 1
app_opportunity_ansehen_zeitraum: Y
app_opps_dont_deactivate_until: 1435701599
app_portal_default_billing_currency: 3
app_prod_key: aa3b868bc7daf7fb9fc3066b7c816ebf48a62f88820b9699eaed58cc7ece2a35121d9e78d7338252e5ce14bac0cd9e77558bf80460852067a50ff55266082384
app_prod_key_recurring: 50e1bcb4b7d9ad239268672498926c1ecb2a9bdf62a610ac0228b75e4c4b213b91d7e86b8d688cb570bec8cb5ed88c6d27498e04e057d22515f314ddbdc411cd
app_prod_merchant_id: 3000006607
app_prod_merchant_id_recurring: 3000006666
app_prod_url_authorize_split: 'https://payment.datatrans.biz/upp/jsp/XML_authorizeSplitEx.jsp'
app_prod_url_include_js: 'https://payment.datatrans.biz/upp/ajax/api.js?merchantId='
app_prod_url_recurring_billing: 'https://payment.datatrans.biz/upp/jsp/XML_authorize.jsp'
app_prod_url_settlement: 'https://payment.datatrans.biz/upp/jsp/XML_processor.jsp'
app_protocol: https
app_recommendation_email_address_from: recommendations@dealgate.com
app_recommendation_reward_extension: 1
app_recommendation_reward_tokens: 5
app_register_check_required: true
app_register_for_free_until: 1325372399
app_reminder_mm_anzahl: 15
app_reminder_mm_zeitraum: d
app_sales_email_address_from: sales@dealgate.com
app_sf_guard_plugin_change_password_form: sfGuardFormChangeUserPasswordDealgate
app_sf_guard_plugin_default_from_email: mailservice@dealgate.com
app_sf_guard_plugin_forgot_password_form: sfGuardFormForgotPasswordDealgate
app_sf_guard_plugin_remember_cookie_name: sfRemember
app_sf_guard_plugin_signin_form: sfGuardFormSigninDealgate
app_sf_guard_plugin_success_signin_url: '@suche'
app_sf_guard_plugin_success_signout_url: localized_homepage
app_special_offer_until: 1335805200
app_teasers_email_address_from: teasers@dealgate.com
app_welcome_tokens: 3
mod__navigation_enabled: true
mod__navigation_view_class: sfPHP
mod_directory_enabled: true
mod_directory_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: portal
sf_app_base_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal
sf_app_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev
sf_app_config_dir: /var/www/vhosts/dealgate.com/private/apps/portal/config
sf_app_dir: /var/www/vhosts/dealgate.com/private/apps/portal
sf_app_i18n_dir: /var/www/vhosts/dealgate.com/private/apps/portal/i18n
sf_app_lib_dir: /var/www/vhosts/dealgate.com/private/apps/portal/lib
sf_app_module_dir: /var/www/vhosts/dealgate.com/private/apps/portal/modules
sf_app_template_dir: /var/www/vhosts/dealgate.com/private/apps/portal/templates
sf_apps_dir: /var/www/vhosts/dealgate.com/private/apps
sf_cache: false
sf_cache_dir: /var/www/vhosts/dealgate.com/private/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/config
sf_config_dir: /var/www/vhosts/dealgate.com/private/config
sf_csrf_secret: false
sf_data_dir: /var/www/vhosts/dealgate.com/private/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
  - default
  - sfGuardAuth
  - sfGuardForgotPassword
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_500_action: error500
sf_error_500_module: default
sf_error_reporting: 24575
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/i18n
sf_lib_dir: /var/www/vhosts/dealgate.com/private/lib
sf_log_dir: /var/www/vhosts/dealgate.com/private/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: __login
sf_module_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /var/www/vhosts/dealgate.com/private/plugins
sf_root_dir: /var/www/vhosts/dealgate.com/private
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
sf_symfony_lib_dir: /var/www/vhosts/dealgate.com/private/lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/template
sf_test_cache_dir: /var/www/vhosts/dealgate.com/private/cache/portal/dev/test
sf_test_dir: /var/www/vhosts/dealgate.com/private/test
sf_upload_dir: /var/www/vhosts/dealgate.com/httpdocs/uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/vhosts/dealgate.com/httpdocs
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true

cookie: {  }
env: {  }
files: {  }
get: {  }
post: {  }
server:
  CONTEXT_DOCUMENT_ROOT: /var/www/vhosts/dealgate.com/httpdocs
  CONTEXT_PREFIX: ''
  DOCUMENT_ROOT: /var/www/vhosts/dealgate.com/httpdocs
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/www/vhosts/dealgate.com
  HTTPS: on
  HTTP_ACCEPT: '*/*'
  HTTP_HOST: www.dealgate.com
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
  PATH_INFO: /en/directory/publish
  PATH_TRANSLATED: 'redirect:/index.php/directory/publish'
  PERL5LIB: '/usr/share/awstats/lib:/usr/share/awstats/plugins'
  PHP_SELF: /portal_dev.php/en/directory/publish
  QUERY_STRING: ''
  REMOTE_ADDR: 18.191.24.202
  REMOTE_PORT: '48790'
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1713863596
  REQUEST_TIME_FLOAT: 1713863596.3487
  REQUEST_URI: /portal_dev.php/en/directory/publish
  SCRIPT_FILENAME: /var/www/vhosts/dealgate.com/httpdocs/portal_dev.php
  SCRIPT_NAME: /portal_dev.php
  SERVER_ADDR: 46.231.204.150
  SERVER_ADMIN: root@localhost
  SERVER_NAME: www.dealgate.com
  SERVER_PORT: '443'
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
  SSL_TLS_SNI: www.dealgate.com
  UNIQUE_ID: Zid7rNCa2AL1Z3NDOV3plQAAAAQ
  USER: dealgate1
  proxy-nokeepalive: '1'
session: {  }

php: 5.6.40
os: 'Linux mc17n0902.dnh.net 3.10.0-1160.114.2.el7.x86_64 #1 SMP Wed Mar 20 15:54:52 UTC 2024 x86_64'
extensions:
  14: bcmath
  15: bz2
  16: calendar
  13: cgi-fcgi
  0: 'Core (5.6.40)'
  17: ctype
  18: curl
  1: 'date (5.6.40)'
  19: dba
  20: 'dom (20031129)'
  2: ereg
  29: 'exif (1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $)'
  22: 'fileinfo (1.0.5)'
  7: 'filter (0.11.0)'
  23: ftp
  24: gd
  25: gettext
  8: 'hash (1.0)'
  26: iconv
  58: 'imagick (3.7.0)'
  27: imap
  28: 'intl (1.1.0)'
  61: 'ionCube Loader (13.0.2)'
  59: 'json (1.3.10)'
  3: libxml
  21: mbstring
  30: mcrypt
  60: mhash
  49: 'mysql (1.0)'
  50: 'mysqli (0.1)'
  31: 'mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $)'
  32: 'odbc (1.0)'
  4: openssl
  5: pcre
  33: 'PDO (1.0.4dev)'
  51: 'pdo_mysql (1.0.2)'
  52: 'PDO_ODBC (1.0.1)'
  53: 'pdo_sqlite (1.0.1)'
  34: 'Phar (2.0.2)'
  35: posix
  36: pspell
  9: 'Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $)'
  11: session
  37: shmop
  38: 'SimpleXML (0.1)'
  39: soap
  40: sockets
  10: 'SPL (0.2)'
  41: 'sqlite3 (0.7-dev)'
  12: 'standard (5.6.40)'
  42: sysvmsg
  43: sysvsem
  44: sysvshm
  45: 'tokenizer (0.1)'
  54: wddx
  46: xml
  55: 'xmlreader (0.1)'
  56: 'xmlrpc (0.51)'
  47: 'xmlwriter (0.1)'
  48: 'xsl (0.1)'
  63: 'Zend Guard Loader'
  62: 'Zend OPcache (7.0.6-devFE)'
  57: 'zip (1.22.3)'
  6: 'zlib (2.0)'

version: 1.4.20
path: /var/www/vhosts/dealgate.com/private/lib/vendor/symfony/lib

Parameters:

• $user (NULL)
• $currency_id (integer)
• $param_language (string)
• $autorized (boolean)
• $PGeneralAdvisorBill (string)
• $PFeaturedAdvisorBill (string)

Parameters:

• $content (boolean)
• $titletxt (string)

Parameters:

• $url (string)
• $param_sf_culture (string)
• $uri_arr_parm (array)
• $uri_sf_culture (string)
• $uri (string)
• $uri_param (string)

Parameters:

• $url (string)
• $param_sf_culture (string)
• $pager (sfDoctrinePager)
• $page (boolean)

Parameters:

• $form (sfGuardFormSigninDealgate)
  • $form['username'] (sfWidgetFormInputText)
  • $form['password'] (sfWidgetFormInputPassword)
  • $form['remember'] (sfWidgetFormInputCheckbox)
• $popup (boolean)

Parameters:

• $form (sfGuardFormSigninDealgate)
  • $form['username'] (sfWidgetFormInputText)
  • $form['password'] (sfWidgetFormInputPassword)
  • $form['remember'] (sfWidgetFormInputCheckbox)

Parameters:

• $culture (string)

Parameters:

• $url (string)
• $param_sf_culture (string)
• $pager (sfDoctrinePager)
• $page (boolean)

Parameters:

• $url (string)
• $param_sf_culture (string)
• $pager (sfDoctrinePager)
• $page (boolean)

Doctrine Version: 1.2.4

1. SET NAMES 'UTF8'

   0.00s, "doctrine" connection

2. SELECT r.id AS r__id, r.produkt_kuerzel AS r__produkt_kuerzel, r2.id AS r2__id, r2.lang AS r2__lang, r2.zeitraum_text AS r2__zeitraum_text, r2.produktname AS r2__produktname FROM r__produkt r LEFT JOIN r__produkt_translation r2 ON r.id = r2.id WHERE ((r.gueltig_bis >= '2024-04-23 11:13:16' OR r.gueltig_bis IS NULL) AND r.produkt_kuerzel LIKE 'D-%') ORDER BY r.sort_id

   0.00s, "doctrine" connection

3. SELECT r.id AS r__id, r.preis AS r__preis, r2.id AS r2__id FROM r__produkt_preis r LEFT JOIN r__produkt r2 ON r.produkt_id = r2.id WHERE (r.currency_id = '3' AND r2.id = '37' AND (r.gueltig_bis IS NULL OR r.gueltig_bis >= '2024-04-23'))

   0.00s, "doctrine" connection

4. SELECT r.id AS r__id, r.preis AS r__preis, r2.id AS r2__id FROM r__produkt_preis r LEFT JOIN r__produkt r2 ON r.produkt_id = r2.id WHERE (r.currency_id = '3' AND r2.id = '36' AND (r.gueltig_bis IS NULL OR r.gueltig_bis >= '2024-04-23'))

   0.00s, "doctrine" connection

5. SELECT a.id AS a__id, a.currency AS a__currency FROM a__currency a WHERE (a.id = '3')

   0.00s, "doctrine" connection

6. SELECT a.id AS a__id, a.dateiname AS a__dateiname FROM a__a_g_b_verwaltung a WHERE (ISNULL(gueltig_bis) OR a.gueltig_bis > '2024-04-23')

   0.00s, "doctrine" connection