parameterHolder:
  action: index
  module: reviews
  sf_culture: en_US
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/js/jquery-1.5.1.min.js: {  }
  thickbox: {  }
  imgpreview: {  }
  autogrow: {  }
  inviteindustrydesigners: {  }
  jquery.bettertip.pack.js: {  }
stylesheets:
  layout.css?v=1.41: {  }
  thickbox: {  }
  draft_listing: {  }
  jquery.bettertip.css: {  }
metas:
  title: 'MycroBurst.com Reviews'
  description: 'Get 50 to 150+ quality designs, by thousands of designers in just a few days. Get custom logo design, web design, brochure design and graphic design. Only pay for your favorite design, and see your designs in hours not weeks!'
  keywords: 'crowdsource, logo design, web design, graphic design, spec work'
  language: en
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: en_US
  default_culture: en_US
  use_flash: true
  logging: '1'
  timeout: 3600
attributeHolder: {  }
culture: en_US

app_affiliates_bucket: dev.affiliate.logos
app_affiliates_logo_url: 'http://s3.amazonaws.com/dev.affiliate.logos'
app_affiliates_url: mycreativesamples.com
app_avatar_bucket: dev.user.avatars
app_avatar_url: 'http://s3.amazonaws.com/dev.user.avatars'
app_comments_display_per_page: 25
app_contestEUR_EUR: '€'
app_contestEUR_EUR_JS: \u20AC
app_contestEUR_banneradssize_large: 15
app_contestEUR_banneradssize_small: 12
app_contestEUR_default_service: 1
app_contestEUR_display_per_page: 30
app_contestEUR_donationAmount1: 20
app_contestEUR_donationAmount2: 40
app_contestEUR_donationAmount3: 77
app_contestEUR_extend_expedite_fee: 22
app_contestEUR_extend_fee: 22
app_contestEUR_listing_fee: 0
app_contestEUR_min_mulwinner_prize: 40
app_contestEUR_prize_handling_fee: 20
app_contestGBP_GBP: '£'
app_contestGBP_GBP_JS: \u00A3
app_contestGBP_default_service: 1
app_contestGBP_display_per_page: 30
app_contestGBP_donationAmount1: 20
app_contestGBP_donationAmount2: 35
app_contestGBP_donationAmount3: 70
app_contestGBP_extend_expedite_fee: 20
app_contestGBP_extend_fee: 20
app_contestGBP_listing_fee: 0
app_contestGBP_min_mulwinner_prize: 35
app_contestGBP_prize_handling_fee: 20
app_contestUSD_USD: $
app_contestUSD_USD_JS: $
app_contestUSD_default_service: 1
app_contestUSD_display_per_page: 30
app_contestUSD_donationAmount1: 25
app_contestUSD_donationAmount2: 50
app_contestUSD_donationAmount3: 100
app_contestUSD_extend_expedite_fee: 29
app_contestUSD_extend_fee: 29
app_contestUSD_listing_fee: 0
app_contestUSD_min_mulwinner_prize: 50
app_contestUSD_prize_handling_fee: 20
app_contest_1to1_fee: 20
app_contest_1to1_service_id: 10
app_contest_default_service: 1
app_contest_display_per_page: 30
app_contest_extend_expedite_fee: 29
app_contest_extend_fee: 29
app_contest_listing_fee: 0
app_contest_min_mulwinner_prize: 50
app_contest_prize_handling_fee: 20
app_designers_display_per_page: 20
app_drafts_bucket: devmb
app_drafts_display_per_page: 40
app_drafts_large_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/large
app_drafts_medium_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/medium
app_drafts_original_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/original
app_drafts_small_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/small
app_drafts_tiny_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/tiny
app_drafts_url: 'http://d1t9cmz3kkfuyi.cloudfront.net'
app_email_bcc: info@mycroburst.com
app_email_comments: comments@mycroburst.com
app_email_finalization: finalization@mycroburst.com
app_email_from: info@mycroburst.com
app_email_new_projects: newprojects@mycroburst.com
app_email_partnerorder: partner.orders@mycroburst.com
app_email_private_message: pm@mycroburst.com
app_email_report_abuse: report@mycroburst.com
app_email_support: support@mycroburst.com
app_email_transactions: transactions@mycroburst.com
app_email_webpartner: webpartner@mycroburst.com
app_files_bucket: dev.contest.files
app_files_dir: /vol/vhosts/www.mycroburst.com/httpdocs/files
app_files_url: 'http://s3.amazonaws.com/dev.contest.files'
app_payflow_partner: PayPal
app_payflow_password: kamlesh123
app_payflow_url: 'https://pilot-payflowpro.paypal.com'
app_payflow_user: kamlesh
app_payflow_vendor: kamlesh
app_paymentpro_password: P4V9TPQ4V74Q8U86
app_paymentpro_signature: AOdinqNqM4HJ3tKB5t7C87IdnrExALWTTdrZojxpm5.006HBae.A6QeE
app_paymentpro_url: 'https://api-3t.sandbox.paypal.com/nvp'
app_paymentpro_user: prismaticdesire_api1.yahoo.com
app_paypal_email: kkumar@verticity.com
app_paypal_url: 'https://www.sandbox.paypal.com/cgi-bin/webscr'
app_s3_access_key: AKIAJDPTXCEOIQQ3Q4PQ
app_s3_secret_key: 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
app_sf_guard_plugin_masterpassword: JGH!84jh@L
app_sf_guard_plugin_remember_cookie_name: mycroburstRemember
app_sf_guard_plugin_remember_key_expiration_age: 7776000
app_sf_guard_plugin_routes_register: false
app_site_currency_fr: '€'
app_site_currencycode_fr: EUR
app_site_id: 1
app_site_id_fr: 6
app_site_name: MycroBurst.com
app_site_smtp_mailserver: 192.99.195.132
app_site_smtp_password: test321321
app_site_smtp_username: test@mycreativesamples.com
app_site_wlaffiliate_id_fr: 6
app_sitesdevurl_1: 'http://dev.mycroburst.com/mbdev_.php'
app_sitesdevurl_2: 'http://dev.logoguru.co.uk/gurudev_.php'
app_sitesdevurl_3: 'http://dev.orders.logodesignguru.com/ldgdev_.php'
app_sitesdevurl_4: 'http://devdesign.logosnap.com/frontend_dev.php'
app_sitesdevurl_5: 'http://dev.mycroburst.com/mbdev_.php'
app_sitesdevurl_6: 'http://dev.mycroburst.com/mbdev_.php/fr'
app_sitesdevurl_7: 'http://dev.mycroburst.com/ar/mbdev_.php'
app_sitesdevurl_8: 'http://dev.zilliondesigns.com/frontend_dev.php'
app_sitesliveurl_1: 'http://www.mycroburst.com'
app_sitesliveurl_2: 'http://www.logoguru.co.uk'
app_sitesliveurl_3: 'http://orders.logodesignguru.com'
app_sitesliveurl_4: 'http://design.logosnap.com'
app_sitesliveurl_5: 'http://www.mycroburst.com'
app_sitesliveurl_6: 'http://www.mycroburst.com/fr'
app_sitesliveurl_7: 'http://www.mycroburst.com/ar'
app_sitesliveurl_8: 'http://www.zilliondesigns.com'
app_sourcefiles_bucket: dev.contest.sourcefiles
app_sourcefiles_url: 'http://s3.amazonaws.com/dev.contest.sourcefiles'
app_tipalti_base_url: 'http://int.payrad.com/Payees/PayeeDashboard.aspx?'
app_tipalti_payer_name: Logodesignguru
app_tipalti_payment_list: 'http://int.payrad.com/Payees/PaymentList.aspx?'
app_tipalti_secret_key: LogodesignguruDemoKey
mod_reviews_enabled: true
mod_reviews_is_internal: false
mod_reviews_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend
sf_app_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev
sf_app_config_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/config
sf_app_dir: /vol/vhosts/www.mycroburst.com/apps/frontend
sf_app_i18n_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/i18n
sf_app_lib_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/lib
sf_app_module_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/modules
sf_app_template_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/templates
sf_apps_dir: /vol/vhosts/www.mycroburst.com/apps
sf_cache: true
sf_cache_dir: /vol/vhosts/www.mycroburst.com/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: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/config
sf_config_dir: /vol/vhosts/www.mycroburst.com/config
sf_csrf_secret: UniqueSecret
sf_data_dir: /vol/vhosts/www.mycroburst.com/data
sf_debug: true
sf_default_culture: en_US
sf_doc_dir: /vol/vhosts/www.mycroburst.com/doc
sf_enabled_modules:
  - default
  - sfGuardAuth
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 8191
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_i18n: true
sf_i18n_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/i18n
sf_jquery_autocomplete: jquery.autocomplete-1.0.2.min.js
sf_jquery_core: jquery-1.5.1.min.js
sf_jquery_sortable: jquery-ui-sortable-1.6rc2.min.js
sf_jquery_web_dir: jquery
sf_lazy_cache_key: true
sf_lib_dir: /vol/vhosts/www.mycroburst.com/lib
sf_log_dir: /vol/vhosts/www.mycroburst.com/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_max_forwards: 5
sf_module_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /vol/vhosts/www.mycroburst.com/plugins
sf_prototype_web_dir: /sfProtoculousPlugin
sf_rich_text_js_dir: js/tiny_mce
sf_root_dir: /vol/vhosts/www.mycroburst.com
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - Form
  - Javascript
  - jQuery
  - Date
sf_strip_comments: true
sf_symfony_lib_dir: /usr/share/pear/symfony
sf_template_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/template
sf_test_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/test
sf_test_dir: /vol/vhosts/www.mycroburst.com/test
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /vol/vhosts/www.mycroburst.com/httpdocs/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: /vol/vhosts/www.mycroburst.com/httpdocs
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false

cookie: {  }
env:
  BASH_FUNC_module(): "() {  eval `/usr/bin/modulecmd bash $*`\n}"
  CVS_RSH: ssh
  G_BROKEN_FILENAMES: '1'
  HISTCONTROL: ignoredups
  HISTSIZE: '1000'
  HOME: /root
  HOSTNAME: ip-172-30-0-152
  LANG: C
  LESSOPEN: '||/usr/bin/lesspipe.sh %s'
  LOADEDMODULES: ''
  LOGNAME: root
  LS_COLORS: 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:'
  MAIL: /var/spool/mail/root
  MANPATH: '/root/.nvm/versions/node/v5.4.1/share/man:/usr/local/share/man:/usr/share/man/en:/usr/share/man:/usr/local/php-5.2.17/man'
  MODULEPATH: '/usr/share/Modules/modulefiles:/etc/modulefiles'
  MODULESHOME: /usr/share/Modules
  NVM_BIN: /root/.nvm/versions/node/v5.4.1/bin
  NVM_DIR: /root/.nvm
  NVM_IOJS_ORG_MIRROR: 'https://iojs.org/dist'
  NVM_IOJS_ORG_VERSION_LISTING: 'https://iojs.org/dist/index.tab'
  NVM_NODEJS_ORG_MIRROR: 'https://nodejs.org/dist'
  NVM_PATH: /root/.nvm/versions/node/v5.4.1/lib/node
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PWD: /etc/httpd/virtualhost
  SHELL: /bin/bash
  SHLVL: '3'
  SSH_CLIENT: '173.249.56.42 34592 22'
  SSH_CONNECTION: '173.249.56.42 34592 172.30.0.152 22'
  SSH_TTY: /dev/pts/0
  TERM: xterm
  USER: root
  _: /usr/sbin/httpd
files: {  }
get: {  }
post: {  }
server:
  DOCUMENT_ROOT: /var/www/html/vhosts/www.mycroburst.com/httpdocs
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: '*/*'
  HTTP_CONNECTION: close
  HTTP_HOST: www.mycroburst.com
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_X_FORWARDED_FOR: 18.216.239.46
  HTTP_X_REAL_IP: 18.216.239.46
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PATH_INFO: /reviews
  PATH_TRANSLATED: 'redirect:/index.php'
  PHP_SELF: /mbdev_.php/reviews
  QUERY_STRING: ''
  REMOTE_ADDR: 18.216.239.46
  REMOTE_PORT: '49954'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1714719944
  REQUEST_URI: /mbdev_.php/reviews
  SCRIPT_FILENAME: /var/www/html/vhosts/www.mycroburst.com/httpdocs/mbdev_.php
  SCRIPT_NAME: /mbdev_.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: support@mycroburst.com
  SERVER_NAME: www.mycroburst.com
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
session: {  }

php: 5.2.17
os: 'Linux ip-172-30-0-152 2.6.32-696.6.3.el6.x86_64 #1 SMP Wed Jul 12 14:17:22 UTC 2017 x86_64'
extensions:
  - 'date (5.2.17)'
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - curl
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'filter (0.11.0)'
  - ftp
  - gd
  - gettext
  - gmp
  - session
  - iconv
  - 'standard (5.2.17)'
  - 'json (1.2.1)'
  - ldap
  - mbstring
  - mcrypt
  - 'mysql (1.0)'
  - 'SimpleXML (0.1)'
  - 'odbc (1.0)'
  - 'SPL (0.2)'
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_pgsql (1.0.2)'
  - posix
  - pspell
  - 'Reflection (0.1)'
  - imap
  - shmop
  - 'mysqli (0.1)'
  - snmp
  - soap
  - sockets
  - 'SQLite (2.0-dev)'
  - '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)'
  - 'xmlrpc (0.51)'
  - 'xmlwriter (0.1)'
  - 'xsl (0.1)'
  - apache2handler
  - 'apc (3.1.9)'

version: 1.2.12
path: /usr/share/pear/symfony

1. SELECT COUNT(*) AS num_results FROM reviews r WHERE r.is_active = 1
2. SELECT r.id AS r__id, r.full_name AS r__full_name, r.location AS r__location, r.file_name AS r__file_name, r.comments AS r__comments, r.rating AS r__rating, r.created_at AS r__created_at, r.company AS r__company, r.is_active AS r__is_active, r.email AS r__email FROM reviews r WHERE r.is_active = 1 ORDER BY r.id DESC LIMIT 10
3. SELECT SUM(r.rating) AS r__0, COUNT(r.id) AS r__1, FORMAT(SUM(r.rating)/COUNT(r.id), 2) AS r__2 FROM reviews r WHERE r.is_active = 1 ORDER BY r.id DESC