HAR Encounter an error

SERVER

:
Array
(
[USER] => www-data
[HOME] => /var/www
[FCGI_ROLE] => RESPONDER
[QUERY_STRING] => month=01&tab=myshowings&year=2034
[REQUEST_METHOD] => GET
[CONTENT_TYPE] =>
[CONTENT_LENGTH] =>
[SCRIPT_NAME] => /smartindex.php
[REQUEST_URI] => /agent/showings?month=01&tab=myshowings&year=2034
[DOCUMENT_URI] => /smartindex.php
[DOCUMENT_ROOT] => /usr/share/nginx/html_20260425064701/webroot
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_SCHEME] => http
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_SOFTWARE] => docker
[REMOTE_ADDR] => 10.70.54.128
[REMOTE_PORT] => 32950
[SERVER_ADDR] => 10.70.117.56
[SERVER_PORT] => 80
[SERVER_NAME] => showingsmart.com
[REDIRECT_STATUS] => 200
[SCRIPT_FILENAME] => /usr/share/nginx/html_20260425064701/webroot/smartindex.php
[HTTP_X_FORWARDED_FOR] => 216.73.217.117, 64.252.74.141
[HTTP_X_FORWARDED_PROTO] => https
[HTTP_X_FORWARDED_PORT] => 443
[HTTP_HOST] => www-test.showingsmart.com
[HTTP_X_AMZN_TRACE_ID] => Root=1-69ec8c3b-46225dd62e120e7550b70e48
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_X_AMZ_CF_ID] => tDo9cGYmze0vilwW3zD6jSNnIP-7LVcXoKuKNPyLMJqprmfBYJaLdg==
[HTTP_ACCEPT] => */*
[HTTP_VIA] => 2.0 c64341c3979b7900421ed479b537d882.cloudfront.net (CloudFront)
[HTTP_ACCEPT_ENCODING] => br,gzip
[HTTP_X_CLOUDFRONT_REQUEST] => yes
[PHP_SELF] => /smartindex.php
[REQUEST_TIME_FLOAT] => 1777110075.2201
[REQUEST_TIME] => 1777110075
)

POST

:
Array
(
)

GET

:
Array
(
[month] => 01
[tab] => myshowings
[year] => 2034
)

TRACE: #0 include() called at [/usr/share/nginx/html_20260425064701/showingsmart/core/MY_Exceptions.php:73]
#1 MY_Exceptions->show_error(A Database Error Occurred, Array ([0] => Unable to connect to your database server using the provided settings.,[1] => Filename: /usr/share/nginx/html_20260425064701/showingsmart/models/showing_agent_model.php,[2] => Line Number: 181), error_db) called at [/usr/share/nginx/html_20260425064701/system/database/DB_driver.php:1200]
#2 CI_DB_driver->display_error(db_unable_to_connect) called at [/usr/share/nginx/html_20260425064701/system/database/DB_driver.php:127]
#3 CI_DB_driver->initialize() called at [/usr/share/nginx/html_20260425064701/system/database/DB_driver.php:452]
#4 CI_DB_driver->simple_query(SELECT a.showing_id, a.showing_date, a.showing_start_time, a.showing_status, a.showing_status_detail, a.showing_end_time,a.online_request_type,
b.lid, b.listingkey as mlsnum, b.listoffice_officekey, b.listing_detail_url, b.listing_photo_url, b.fullstreetaddress, b.city, b.zip, b.call_center_yn, b.liststatus,
b.showing_instruction, b.showing_service_type, b.showing_service_phone, b.call_center_yn, i.home_status, i.lockbox_type,i.lockbox_instruction, i.approval_type,
c.agentkey, c.full_name, c.first_name, c.last_name, replace(c.agent_photo, '400x400', '112x112') agent_photo, c.office_name, c.cell_phone,c.email,
t.tid, t.tour_name, t.tour_date,
(select count(1) from showingsmart.ShowingFeedback d where feedback_type = 'S' and d.showing_id = a.showing_id) as feedback_count
FROM showingsmart.Showing a
INNER JOIN showingsmart.ManagedListing b ON a.lid = b.lid
INNER JOIN showingsmart.Agent c ON b.listagent_agentkey = c.agentkey
LEFT JOIN showingsmart.TourListingXref x ON a.showing_id = x.showing_id
left join showingsmart.Tour t on x.tid = t.tid
left join showingsmart.ShowingInstruction i on b.lid = i.lid

where a.sa_agentkey = '' and a.showing_date >= '2034-01-01' and a.showing_date < '2034-02-01'
order by tid, showing_start_time) called at [/usr/share/nginx/html_20260425064701/system/database/DB_driver.php:302]
#5 CI_DB_driver->query(SELECT a.showing_id, a.showing_date, a.showing_start_time, a.showing_status, a.showing_status_detail, a.showing_end_time,a.online_request_type,
b.lid, b.listingkey as mlsnum, b.listoffice_officekey, b.listing_detail_url, b.listing_photo_url, b.fullstreetaddress, b.city, b.zip, b.call_center_yn, b.liststatus,
b.showing_instruction, b.showing_service_type, b.showing_service_phone, b.call_center_yn, i.home_status, i.lockbox_type,i.lockbox_instruction, i.approval_type,
c.agentkey, c.full_name, c.first_name, c.last_name, replace(c.agent_photo, '400x400', '112x112') agent_photo, c.office_name, c.cell_phone,c.email,
t.tid, t.tour_name, t.tour_date,
(select count(1) from showingsmart.ShowingFeedback d where feedback_type = 'S' and d.showing_id = a.showing_id) as feedback_count
FROM showingsmart.Showing a
INNER JOIN showingsmart.ManagedListing b ON a.lid = b.lid
INNER JOIN showingsmart.Agent c ON b.listagent_agentkey = c.agentkey
LEFT JOIN showingsmart.TourListingXref x ON a.showing_id = x.showing_id
left join showingsmart.Tour t on x.tid = t.tid
left join showingsmart.ShowingInstruction i on b.lid = i.lid

where a.sa_agentkey = ? and a.showing_date >= '2034-01-01' and a.showing_date < '2034-02-01'
order by tid, showing_start_time, Array ([0] => )) called at [/usr/share/nginx/html_20260425064701/showingsmart/models/showing_agent_model.php:181]
#6 showing_agent_model->getMyShowingAppt(, 1, 2034) called at [/usr/share/nginx/html_20260425064701/showingsmart/controllers/agent.php:1115]
#7 Agent->showings()
#8 call_user_func_array(Array ([0] => Agent Object ([] => agent_dashboard,[] => Array ([agentkey] => ,[authorized_flag] => 15,[agent_photo] => ,[full_name] => ,[email] => ,[officekey] => ),[] => Array ([si] => 1,[showings] => 1,[feedback] => 1,[buyers] => 1),[] => ,[] => ,[] => ,[benchmark] => CI_Benchmark Object ([marker] => Array ([total_execution_time_start] => 0.22066400 1777110075,[loading_time:_base_classes_start] => 0.22066900 1777110075,[loading_time:_base_classes_end] => 0.22149600 1777110075,[controller_execution_time_( agent / showings )_start] => 0.22150800 1777110075)),[hooks] => CI_Hooks Object ([enabled] => ,[hooks] => Array (),[in_progress] => ),[config] => CI_Config Object ([config] => Array ([build_number] => 30238616,[memcache_sequence] => 30217797,[production_test] => ,[contentprefix] => ,[siteup] => UP,[db_version] => 8,[code_enviroment] => test,[code_environment] => test,[serverprefix] => ,[cssprefix] => /cssmin/30238616_,[css_prefix] => /resources/css/30238616_,[cssfolder] => /cssmin/,[jsprefix] => /jsmin/30238616_,[js_prefix] => /resources/js/30238616_,[jsprefixnomin] => /js/30238616_,[js_prefixnomin] => /resources/js/30238616_,[nocssprefix] => /css/30238616_,[jsfolder] => /jsmin/,[imgprefix] => /img/30238616_,[base_url] => http://www-test.showingsmart.com/,[use_ctlinks] => 1,[secure_url] => https://www.showingsmart.com,[myaccount_url] => https://www.showingsmart.com,[dirty_get] => Array ([month] => 01,[tab] => myshowings,[year] => 2034),[dirty_post] => Array (),[cssfolders] => Array ([1] => 1,[2] => 1,[5] => 1,[6] => 1,[9] => 1),[showing_request_app_new] => 1,[agent_password_expiration] => Array ([enabled] => 1,[expired_time] => -1 year,[cache_key] => agent_password_expiration.%s,[cache_time] => 24),[report_exporter] => Array ([memcache] => 1),[index_page] => smartindex.php,[uri_protocol] => AUTO,[url_suffix] => ,[language] => english,[charset] => UTF-8,[enable_hooks] => 1,[subclass_prefix] => MY_,[permitted_uri_chars] => a-z 0-9~%.:_\-,[allow_get_array] => 1,[enable_query_strings] => 1,[controller_trigger] => c,[function_trigger] => m,[log_threshold] => 0,[log_path] => /var/log/codeigniter/,[log_date_format] => Y-m-d H:i:s,[cache_path] => ,[encryption_key] => HRockT3x1x,[sess_cookie_name] => ci_session,[sess_expiration] => 7200,[sess_expire_on_close] => ,[sess_encrypt_cookie] => ,[sess_use_database] => ,[sess_table_name] => ci_sessions,[sess_match_ip] => ,[sess_match_useragent] => 1,[sess_time_to_update] => 300,[cookie_prefix] => ,[cookie_domain] => .showingsmart.com,[cookie_path] => /,[cookie_secure] => ,[global_xss_filtering] => 1,[csrf_protection] => ,[csrf_token_name] => csrf_test_name,[csrf_cookie_name] => csrf_cookie_name,[csrf_expire] => 7200,[compress_output] => ,[time_reference] => UM6,[rewrite_short_tags] => ,[stupefix_version] => v2,[stupefix_key] => YPF4IYHBT5AMTK3VKGL3TP26T4,[maps_key] => AIzaSyD1wekYilGjpZ99ghcoIvuv63xcH2dYXss,[maps_street_size] => 640x400,[maps_signature] => ,[maps_heading] => 151.78,[maps_pitch] => -0.76,[proxy_ips] => ,[agent_dashboard] => /agent,[operator_dashboard] => /operator/dashboard,[client_dashboard] => /client,[jwt_key] => VkYp3s6v9y$B&E)H@McQfTjWnZq4t7w!,[uri_key] => s$rtTou11C@nt0N,[keycloak] => Array ([auth_base_url] => https://id.showingsmart.com/auth,[auth_authorize_url] => /auth,[auth_token_url] => /token,[auth_logout_url] => /logout,[auth_userinfo_url] => /userinfo,[auth_revoke_url] => /revoke,[redirect_uri] => https://www-test.showingsmart.com/login/logincallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback,[partners] => Array ([har] => Array ([realm] => hssmembers,[client_id] => hsswebclient,[secret] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[public-client] => ,[redirect_uri] => ,[redirect_logout_uri] => ,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8HybR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaVe8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4mgnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLLO3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG9wIDAQAB,[realm-secret-key] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg),[operator] => Array ([realm] => hssoperators,[client_id] => hsswebclient,[secret] => 35bd5c2b-1013-45e7-9769-49d4c6035d51,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginoperatorcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?op=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvQu9oLu/2LYvcAFoMTJZHqhlEJswI6f8gPUrEMG3GEbKtlYjgac5UhQ2HCIwfbbZtTGyc6TtCWP3sYGSRHc5vH1sdHybPnGlcPJ0FPZpmHbzHSblWDEGPCzJ6a8upJA/oz9KlyGRCEu90ViOEH8Ee2p11ejSAEntFRiXc4sihlfaParA/4lnuMg03ppJYy8orQ0l+1mv5o+gVpWTsfxJHwSsOMJIWVNUdGDn5+KBFDx+EvkOiBONwfi/sXjclrOxx5yga+AKG2J4JWcIdaz+mrbk377u5eqga1qWRnrwWf36Lu6TCi29gfgWjamy4sOeA8Wja0HxDrHz67ERwbuGAwIDAQAB,[realm-secret-key] => wJ7dK5znzdkZck7WOS2TkDWn459VyeQXk1kb807cCctJr1qMZamh1yYug5jd0LFHlUyoDgO5pQDhuy9ofLgrHw),[client] => Array ([realm] => hssclients,[client_id] => hsswebclient,[secret] => a07adc32-f0d1-4f83-a6dd-4babb43ea463,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginclientcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?cl=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjILMuZAXHIKF4kYn1H2xnc+GO7tCeOwlFpSYdCkb3Fj65l4ThexP87K8ApVC5ZOOF2pI/jSKKlHj2WC2bQlf3BKViE1HfV4H/oKdLDrxt6ORM3CyKg87LoL6u79EkQv2x1Y+Tot+FLk9c4Gq9/S3eUj+GU8JtaVnUFY3/d8tzWZlTTIZzVKKtzmOC5ZAFR5lZHbqTkWzv44jXBYuR9fnpm/Y5QoUdyONfqIe8lxtJwSODXFNYfP3zN5n0hdvpCIPM5DoWL5dAlo4gEF9z7AN3qAkEudzObdgMVELuHl7T9e1JEOwn94AMakFHiCgbAykdZFTxryoWentaxbrg8ZcjwIDAQAB,[realm-secret-key] => qVZqDuPvWzO_YyGHronmb9cUjh-q1IiFNCGOBlfYxb1pU0QmuQ9lCORgXnmdladiWmviRuK1AT6vqsaU7Bn8Bg)))),[is_loaded] => Array ([0] => ../showingsmart/config/keycloak.php),[_config_paths] => Array ([0] => ../showingsmart/)),[utf8] => CI_Utf8 Object (),[uri] => CI_URI Object ([keyval] => Array (),[uri_string] => agent/showings,[segments] => Array ([1] => agent,[2] => showings),[rsegments] => Array ([1] => agent,[2] => showings),[config] => CI_Config Object ([config] => Array ([build_number] => 30238616,[memcache_sequence] => 30217797,[production_test] => ,[contentprefix] => ,[siteup] => UP,[db_version] => 8,[code_enviroment] => test,[code_environment] => test,[serverprefix] => ,[cssprefix] => /cssmin/30238616_,[css_prefix] => /resources/css/30238616_,[cssfolder] => /cssmin/,[jsprefix] => /jsmin/30238616_,[js_prefix] => /resources/js/30238616_,[jsprefixnomin] => /js/30238616_,[js_prefixnomin] => /resources/js/30238616_,[nocssprefix] => /css/30238616_,[jsfolder] => /jsmin/,[imgprefix] => /img/30238616_,[base_url] => http://www-test.showingsmart.com/,[use_ctlinks] => 1,[secure_url] => https://www.showingsmart.com,[myaccount_url] => https://www.showingsmart.com,[dirty_get] => Array ([month] => 01,[tab] => myshowings,[year] => 2034),[dirty_post] => Array (),[cssfolders] => Array ([1] => 1,[2] => 1,[5] => 1,[6] => 1,[9] => 1),[showing_request_app_new] => 1,[agent_password_expiration] => Array ([enabled] => 1,[expired_time] => -1 year,[cache_key] => agent_password_expiration.%s,[cache_time] => 24),[report_exporter] => Array ([memcache] => 1),[index_page] => smartindex.php,[uri_protocol] => AUTO,[url_suffix] => ,[language] => english,[charset] => UTF-8,[enable_hooks] => 1,[subclass_prefix] => MY_,[permitted_uri_chars] => a-z 0-9~%.:_\-,[allow_get_array] => 1,[enable_query_strings] => 1,[controller_trigger] => c,[function_trigger] => m,[log_threshold] => 0,[log_path] => /var/log/codeigniter/,[log_date_format] => Y-m-d H:i:s,[cache_path] => ,[encryption_key] => HRockT3x1x,[sess_cookie_name] => ci_session,[sess_expiration] => 7200,[sess_expire_on_close] => ,[sess_encrypt_cookie] => ,[sess_use_database] => ,[sess_table_name] => ci_sessions,[sess_match_ip] => ,[sess_match_useragent] => 1,[sess_time_to_update] => 300,[cookie_prefix] => ,[cookie_domain] => .showingsmart.com,[cookie_path] => /,[cookie_secure] => ,[global_xss_filtering] => 1,[csrf_protection] => ,[csrf_token_name] => csrf_test_name,[csrf_cookie_name] => csrf_cookie_name,[csrf_expire] => 7200,[compress_output] => ,[time_reference] => UM6,[rewrite_short_tags] => ,[stupefix_version] => v2,[stupefix_key] => YPF4IYHBT5AMTK3VKGL3TP26T4,[maps_key] => AIzaSyD1wekYilGjpZ99ghcoIvuv63xcH2dYXss,[maps_street_size] => 640x400,[maps_signature] => ,[maps_heading] => 151.78,[maps_pitch] => -0.76,[proxy_ips] => ,[agent_dashboard] => /agent,[operator_dashboard] => /operator/dashboard,[client_dashboard] => /client,[jwt_key] => VkYp3s6v9y$B&E)H@McQfTjWnZq4t7w!,[uri_key] => s$rtTou11C@nt0N,[keycloak] => Array ([auth_base_url] => https://id.showingsmart.com/auth,[auth_authorize_url] => /auth,[auth_token_url] => /token,[auth_logout_url] => /logout,[auth_userinfo_url] => /userinfo,[auth_revoke_url] => /revoke,[redirect_uri] => https://www-test.showingsmart.com/login/logincallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback,[partners] => Array ([har] => Array ([realm] => hssmembers,[client_id] => hsswebclient,[secret] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[public-client] => ,[redirect_uri] => ,[redirect_logout_uri] => ,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8HybR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaVe8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4mgnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLLO3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG9wIDAQAB,[realm-secret-key] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg),[operator] => Array ([realm] => hssoperators,[client_id] => hsswebclient,[secret] => 35bd5c2b-1013-45e7-9769-49d4c6035d51,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginoperatorcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?op=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvQu9oLu/2LYvcAFoMTJZHqhlEJswI6f8gPUrEMG3GEbKtlYjgac5UhQ2HCIwfbbZtTGyc6TtCWP3sYGSRHc5vH1sdHybPnGlcPJ0FPZpmHbzHSblWDEGPCzJ6a8upJA/oz9KlyGRCEu90ViOEH8Ee2p11ejSAEntFRiXc4sihlfaParA/4lnuMg03ppJYy8orQ0l+1mv5o+gVpWTsfxJHwSsOMJIWVNUdGDn5+KBFDx+EvkOiBONwfi/sXjclrOxx5yga+AKG2J4JWcIdaz+mrbk377u5eqga1qWRnrwWf36Lu6TCi29gfgWjamy4sOeA8Wja0HxDrHz67ERwbuGAwIDAQAB,[realm-secret-key] => wJ7dK5znzdkZck7WOS2TkDWn459VyeQXk1kb807cCctJr1qMZamh1yYug5jd0LFHlUyoDgO5pQDhuy9ofLgrHw),[client] => Array ([realm] => hssclients,[client_id] => hsswebclient,[secret] => a07adc32-f0d1-4f83-a6dd-4babb43ea463,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginclientcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?cl=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjILMuZAXHIKF4kYn1H2xnc+GO7tCeOwlFpSYdCkb3Fj65l4ThexP87K8ApVC5ZOOF2pI/jSKKlHj2WC2bQlf3BKViE1HfV4H/oKdLDrxt6ORM3CyKg87LoL6u79EkQv2x1Y+Tot+FLk9c4Gq9/S3eUj+GU8JtaVnUFY3/d8tzWZlTTIZzVKKtzmOC5ZAFR5lZHbqTkWzv44jXBYuR9fnpm/Y5QoUdyONfqIe8lxtJwSODXFNYfP3zN5n0hdvpCIPM5DoWL5dAlo4gEF9z7AN3qAkEudzObdgMVELuHl7T9e1JEOwn94AMakFHiCgbAykdZFTxryoWentaxbrg8ZcjwIDAQAB,[realm-secret-key] => qVZqDuPvWzO_YyGHronmb9cUjh-q1IiFNCGOBlfYxb1pU0QmuQ9lCORgXnmdladiWmviRuK1AT6vqsaU7Bn8Bg)))),[is_loaded] => Array ([0] => ../showingsmart/config/keycloak.php),[_config_paths] => Array ([0] => ../showingsmart/))),[router] => CI_Router Object ([config] => CI_Config Object ([config] => Array ([build_number] => 30238616,[memcache_sequence] => 30217797,[production_test] => ,[contentprefix] => ,[siteup] => UP,[db_version] => 8,[code_enviroment] => test,[code_environment] => test,[serverprefix] => ,[cssprefix] => /cssmin/30238616_,[css_prefix] => /resources/css/30238616_,[cssfolder] => /cssmin/,[jsprefix] => /jsmin/30238616_,[js_prefix] => /resources/js/30238616_,[jsprefixnomin] => /js/30238616_,[js_prefixnomin] => /resources/js/30238616_,[nocssprefix] => /css/30238616_,[jsfolder] => /jsmin/,[imgprefix] => /img/30238616_,[base_url] => http://www-test.showingsmart.com/,[use_ctlinks] => 1,[secure_url] => https://www.showingsmart.com,[myaccount_url] => https://www.showingsmart.com,[dirty_get] => Array ([month] => 01,[tab] => myshowings,[year] => 2034),[dirty_post] => Array (),[cssfolders] => Array ([1] => 1,[2] => 1,[5] => 1,[6] => 1,[9] => 1),[showing_request_app_new] => 1,[agent_password_expiration] => Array ([enabled] => 1,[expired_time] => -1 year,[cache_key] => agent_password_expiration.%s,[cache_time] => 24),[report_exporter] => Array ([memcache] => 1),[index_page] => smartindex.php,[uri_protocol] => AUTO,[url_suffix] => ,[language] => english,[charset] => UTF-8,[enable_hooks] => 1,[subclass_prefix] => MY_,[permitted_uri_chars] => a-z 0-9~%.:_\-,[allow_get_array] => 1,[enable_query_strings] => 1,[controller_trigger] => c,[function_trigger] => m,[log_threshold] => 0,[log_path] => /var/log/codeigniter/,[log_date_format] => Y-m-d H:i:s,[cache_path] => ,[encryption_key] => HRockT3x1x,[sess_cookie_name] => ci_session,[sess_expiration] => 7200,[sess_expire_on_close] => ,[sess_encrypt_cookie] => ,[sess_use_database] => ,[sess_table_name] => ci_sessions,[sess_match_ip] => ,[sess_match_useragent] => 1,[sess_time_to_update] => 300,[cookie_prefix] => ,[cookie_domain] => .showingsmart.com,[cookie_path] => /,[cookie_secure] => ,[global_xss_filtering] => 1,[csrf_protection] => ,[csrf_token_name] => csrf_test_name,[csrf_cookie_name] => csrf_cookie_name,[csrf_expire] => 7200,[compress_output] => ,[time_reference] => UM6,[rewrite_short_tags] => ,[stupefix_version] => v2,[stupefix_key] => YPF4IYHBT5AMTK3VKGL3TP26T4,[maps_key] => AIzaSyD1wekYilGjpZ99ghcoIvuv63xcH2dYXss,[maps_street_size] => 640x400,[maps_signature] => ,[maps_heading] => 151.78,[maps_pitch] => -0.76,[proxy_ips] => ,[agent_dashboard] => /agent,[operator_dashboard] => /operator/dashboard,[client_dashboard] => /client,[jwt_key] => VkYp3s6v9y$B&E)H@McQfTjWnZq4t7w!,[uri_key] => s$rtTou11C@nt0N,[keycloak] => Array ([auth_base_url] => https://id.showingsmart.com/auth,[auth_authorize_url] => /auth,[auth_token_url] => /token,[auth_logout_url] => /logout,[auth_userinfo_url] => /userinfo,[auth_revoke_url] => /revoke,[redirect_uri] => https://www-test.showingsmart.com/login/logincallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback,[partners] => Array ([har] => Array ([realm] => hssmembers,[client_id] => hsswebclient,[secret] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[public-client] => ,[redirect_uri] => ,[redirect_logout_uri] => ,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8HybR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaVe8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4mgnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLLO3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG9wIDAQAB,[realm-secret-key] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg),[operator] => Array ([realm] => hssoperators,[client_id] => hsswebclient,[secret] => 35bd5c2b-1013-45e7-9769-49d4c6035d51,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginoperatorcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?op=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvQu9oLu/2LYvcAFoMTJZHqhlEJswI6f8gPUrEMG3GEbKtlYjgac5UhQ2HCIwfbbZtTGyc6TtCWP3sYGSRHc5vH1sdHybPnGlcPJ0FPZpmHbzHSblWDEGPCzJ6a8upJA/oz9KlyGRCEu90ViOEH8Ee2p11ejSAEntFRiXc4sihlfaParA/4lnuMg03ppJYy8orQ0l+1mv5o+gVpWTsfxJHwSsOMJIWVNUdGDn5+KBFDx+EvkOiBONwfi/sXjclrOxx5yga+AKG2J4JWcIdaz+mrbk377u5eqga1qWRnrwWf36Lu6TCi29gfgWjamy4sOeA8Wja0HxDrHz67ERwbuGAwIDAQAB,[realm-secret-key] => wJ7dK5znzdkZck7WOS2TkDWn459VyeQXk1kb807cCctJr1qMZamh1yYug5jd0LFHlUyoDgO5pQDhuy9ofLgrHw),[client] => Array ([realm] => hssclients,[client_id] => hsswebclient,[secret] => a07adc32-f0d1-4f83-a6dd-4babb43ea463,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginclientcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?cl=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjILMuZAXHIKF4kYn1H2xnc+GO7tCeOwlFpSYdCkb3Fj65l4ThexP87K8ApVC5ZOOF2pI/jSKKlHj2WC2bQlf3BKViE1HfV4H/oKdLDrxt6ORM3CyKg87LoL6u79EkQv2x1Y+Tot+FLk9c4Gq9/S3eUj+GU8JtaVnUFY3/d8tzWZlTTIZzVKKtzmOC5ZAFR5lZHbqTkWzv44jXBYuR9fnpm/Y5QoUdyONfqIe8lxtJwSODXFNYfP3zN5n0hdvpCIPM5DoWL5dAlo4gEF9z7AN3qAkEudzObdgMVELuHl7T9e1JEOwn94AMakFHiCgbAykdZFTxryoWentaxbrg8ZcjwIDAQAB,[realm-secret-key] => qVZqDuPvWzO_YyGHronmb9cUjh-q1IiFNCGOBlfYxb1pU0QmuQ9lCORgXnmdladiWmviRuK1AT6vqsaU7Bn8Bg)))),[is_loaded] => Array ([0] => ../showingsmart/config/keycloak.php),[_config_paths] => Array ([0] => ../showingsmart/)),[routes] => Array ([default_controller] => home,[404_override] => pagenotfound,[operator] => op,[client] => cl,[verify_captcha_token] => home/verifycaptchatoken,[agent/support] => support/agent,[operator/support] => support/operator,[operator/settings/general] => operator/savesettings,[logout/(:any)] => login/logout/$1,[lp/(:any)/(:any)] => login/proxylogin/$1/$2,[go/client_block/(:num)] => client_api/client_block/$1,[go/(:any)] => go/process/$1,[req/(:any)] => pub/fbr/$1/$2,[terms] => home/terms,[terms_sms] => home/terms_sms,[privacy] => home/privacy,[training] => home/training,[app] => home/app,[rest/api/link] => rest/generatelink),[error_routes] => Array (),[class] => agent,[method] => showings,[directory] => ,[default_controller] => home,[uri] => CI_URI Object ([keyval] => Array (),[uri_string] => agent/showings,[segments] => Array ([1] => agent,[2] => showings),[rsegments] => Array ([1] => agent,[2] => showings),[config] => CI_Config Object ([config] => Array ([build_number] => 30238616,[memcache_sequence] => 30217797,[production_test] => ,[contentprefix] => ,[siteup] => UP,[db_version] => 8,[code_enviroment] => test,[code_environment] => test,[serverprefix] => ,[cssprefix] => /cssmin/30238616_,[css_prefix] => /resources/css/30238616_,[cssfolder] => /cssmin/,[jsprefix] => /jsmin/30238616_,[js_prefix] => /resources/js/30238616_,[jsprefixnomin] => /js/30238616_,[js_prefixnomin] => /resources/js/30238616_,[nocssprefix] => /css/30238616_,[jsfolder] => /jsmin/,[imgprefix] => /img/30238616_,[base_url] => http://www-test.showingsmart.com/,[use_ctlinks] => 1,[secure_url] => https://www.showingsmart.com,[myaccount_url] => https://www.showingsmart.com,[dirty_get] => Array ([month] => 01,[tab] => myshowings,[year] => 2034),[dirty_post] => Array (),[cssfolders] => Array ([1] => 1,[2] => 1,[5] => 1,[6] => 1,[9] => 1),[showing_request_app_new] => 1,[agent_password_expiration] => Array ([enabled] => 1,[expired_time] => -1 year,[cache_key] => agent_password_expiration.%s,[cache_time] => 24),[report_exporter] => Array ([memcache] => 1),[index_page] => smartindex.php,[uri_protocol] => AUTO,[url_suffix] => ,[language] => english,[charset] => UTF-8,[enable_hooks] => 1,[subclass_prefix] => MY_,[permitted_uri_chars] => a-z 0-9~%.:_\-,[allow_get_array] => 1,[enable_query_strings] => 1,[controller_trigger] => c,[function_trigger] => m,[log_threshold] => 0,[log_path] => /var/log/codeigniter/,[log_date_format] => Y-m-d H:i:s,[cache_path] => ,[encryption_key] => HRockT3x1x,[sess_cookie_name] => ci_session,[sess_expiration] => 7200,[sess_expire_on_close] => ,[sess_encrypt_cookie] => ,[sess_use_database] => ,[sess_table_name] => ci_sessions,[sess_match_ip] => ,[sess_match_useragent] => 1,[sess_time_to_update] => 300,[cookie_prefix] => ,[cookie_domain] => .showingsmart.com,[cookie_path] => /,[cookie_secure] => ,[global_xss_filtering] => 1,[csrf_protection] => ,[csrf_token_name] => csrf_test_name,[csrf_cookie_name] => csrf_cookie_name,[csrf_expire] => 7200,[compress_output] => ,[time_reference] => UM6,[rewrite_short_tags] => ,[stupefix_version] => v2,[stupefix_key] => YPF4IYHBT5AMTK3VKGL3TP26T4,[maps_key] => AIzaSyD1wekYilGjpZ99ghcoIvuv63xcH2dYXss,[maps_street_size] => 640x400,[maps_signature] => ,[maps_heading] => 151.78,[maps_pitch] => -0.76,[proxy_ips] => ,[agent_dashboard] => /agent,[operator_dashboard] => /operator/dashboard,[client_dashboard] => /client,[jwt_key] => VkYp3s6v9y$B&E)H@McQfTjWnZq4t7w!,[uri_key] => s$rtTou11C@nt0N,[keycloak] => Array ([auth_base_url] => https://id.showingsmart.com/auth,[auth_authorize_url] => /auth,[auth_token_url] => /token,[auth_logout_url] => /logout,[auth_userinfo_url] => /userinfo,[auth_revoke_url] => /revoke,[redirect_uri] => https://www-test.showingsmart.com/login/logincallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback,[partners] => Array ([har] => Array ([realm] => hssmembers,[client_id] => hsswebclient,[secret] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[public-client] => ,[redirect_uri] => ,[redirect_logout_uri] => ,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8HybR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaVe8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4mgnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLLO3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG9wIDAQAB,[realm-secret-key] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg),[operator] => Array ([realm] => hssoperators,[client_id] => hsswebclient,[secret] => 35bd5c2b-1013-45e7-9769-49d4c6035d51,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginoperatorcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?op=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvQu9oLu/2LYvcAFoMTJZHqhlEJswI6f8gPUrEMG3GEbKtlYjgac5UhQ2HCIwfbbZtTGyc6TtCWP3sYGSRHc5vH1sdHybPnGlcPJ0FPZpmHbzHSblWDEGPCzJ6a8upJA/oz9KlyGRCEu90ViOEH8Ee2p11ejSAEntFRiXc4sihlfaParA/4lnuMg03ppJYy8orQ0l+1mv5o+gVpWTsfxJHwSsOMJIWVNUdGDn5+KBFDx+EvkOiBONwfi/sXjclrOxx5yga+AKG2J4JWcIdaz+mrbk377u5eqga1qWRnrwWf36Lu6TCi29gfgWjamy4sOeA8Wja0HxDrHz67ERwbuGAwIDAQAB,[realm-secret-key] => wJ7dK5znzdkZck7WOS2TkDWn459VyeQXk1kb807cCctJr1qMZamh1yYug5jd0LFHlUyoDgO5pQDhuy9ofLgrHw),[client] => Array ([realm] => hssclients,[client_id] => hsswebclient,[secret] => a07adc32-f0d1-4f83-a6dd-4babb43ea463,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginclientcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?cl=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjILMuZAXHIKF4kYn1H2xnc+GO7tCeOwlFpSYdCkb3Fj65l4ThexP87K8ApVC5ZOOF2pI/jSKKlHj2WC2bQlf3BKViE1HfV4H/oKdLDrxt6ORM3CyKg87LoL6u79EkQv2x1Y+Tot+FLk9c4Gq9/S3eUj+GU8JtaVnUFY3/d8tzWZlTTIZzVKKtzmOC5ZAFR5lZHbqTkWzv44jXBYuR9fnpm/Y5QoUdyONfqIe8lxtJwSODXFNYfP3zN5n0hdvpCIPM5DoWL5dAlo4gEF9z7AN3qAkEudzObdgMVELuHl7T9e1JEOwn94AMakFHiCgbAykdZFTxryoWentaxbrg8ZcjwIDAQAB,[realm-secret-key] => qVZqDuPvWzO_YyGHronmb9cUjh-q1IiFNCGOBlfYxb1pU0QmuQ9lCORgXnmdladiWmviRuK1AT6vqsaU7Bn8Bg)))),[is_loaded] => Array ([0] => ../showingsmart/config/keycloak.php),[_config_paths] => Array ([0] => ../showingsmart/)))),[output] => CI_Output Object ([] => ,[] => 0,[] => Array (),[] => Array ([hqx] => application/mac-binhex40,[cpt] => application/mac-compactpro,[csv] => Array ([0] => text/x-comma-separated-values,[1] => text/comma-separated-values,[2] => application/octet-stream,[3] => application/vnd.ms-excel,[4] => application/x-csv,[5] => text/x-csv,[6] => text/csv,[7] => application/csv,[8] => application/excel,[9] => application/vnd.msexcel),[bin] => application/macbinary,[dms] => application/octet-stream,[lha] => application/octet-stream,[lzh] => application/octet-stream,[exe] => Array ([0] => application/octet-stream,[1] => application/x-msdownload),[class] => application/octet-stream,[psd] => application/x-photoshop,[so] => application/octet-stream,[sea] => application/octet-stream,[dll] => application/octet-stream,[oda] => application/oda,[pdf] => Array ([0] => application/pdf,[1] => application/x-download),[ai] => application/postscript,[eps] => application/postscript,[ps] => application/postscript,[smi] => application/smil,[smil] => application/smil,[mif] => application/vnd.mif,[xls] => Array ([0] => application/excel,[1] => application/vnd.ms-excel,[2] => application/msexcel),[ppt] => Array ([0] => application/powerpoint,[1] => application/vnd.ms-powerpoint),[wbxml] => application/wbxml,[wmlc] => application/wmlc,[dcr] => application/x-director,[dir] => application/x-director,[dxr] => application/x-director,[dvi] => application/x-dvi,[gtar] => application/x-gtar,[gz] => application/x-gzip,[php] => application/x-httpd-php,[php4] => application/x-httpd-php,[php3] => application/x-httpd-php,[phtml] => application/x-httpd-php,[phps] => application/x-httpd-php-source,[js] => application/x-javascript,[swf] => application/x-shockwave-flash,[sit] => application/x-stuffit,[tar] => application/x-tar,[tgz] => Array ([0] => application/x-tar,[1] => application/x-gzip-compressed),[xhtml] => application/xhtml+xml,[xht] => application/xhtml+xml,[zip] => Array ([0] => application/x-zip,[1] => application/zip,[2] => application/x-zip-compressed),[mid] => audio/midi,[midi] => audio/midi,[mpga] => audio/mpeg,[mp2] => audio/mpeg,[mp3] => Array ([0] => audio/mpeg,[1] => audio/mpg,[2] => audio/mpeg3,[3] => audio/mp3),[aif] => audio/x-aiff,[aiff] => audio/x-aiff,[aifc] => audio/x-aiff,[ram] => audio/x-pn-realaudio,[rm] => audio/x-pn-realaudio,[rpm] => audio/x-pn-realaudio-plugin,[ra] => audio/x-realaudio,[rv] => video/vnd.rn-realvideo,[wav] => Array ([0] => audio/x-wav,[1] => audio/wave,[2] => audio/wav),[bmp] => Array ([0] => image/bmp,[1] => image/x-windows-bmp),[gif] => image/gif,[jpeg] => Array ([0] => image/jpeg,[1] => image/pjpeg),[jpg] => Array ([0] => image/jpeg,[1] => image/pjpeg),[jpe] => Array ([0] => image/jpeg,[1] => image/pjpeg),[png] => Array ([0] => image/png,[1] => image/x-png),[tiff] => image/tiff,[tif] => image/tiff,[css] => text/css,[html] => text/html,[htm] => text/html,[shtml] => text/html,[txt] => text/plain,[text] => text/plain,[log] => Array ([0] => text/plain,[1] => text/x-log),[rtx] => text/richtext,[rtf] => text/rtf,[xml] => text/xml,[xsl] => text/xml,[mpeg] => video/mpeg,[mpg] => video/mpeg,[mpe] => video/mpeg,[qt] => video/quicktime,[mov] => video/quicktime,[avi] => video/x-msvideo,[movie] => video/x-sgi-movie,[doc] => application/msword,[docx] => Array ([0] => application/vnd.openxmlformats-officedocument.wordprocessingml.document,[1] => application/zip),[xlsx] => Array ([0] => application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,[1] => application/zip),[word] => Array ([0] => application/msword,[1] => application/octet-stream),[xl] => application/excel,[eml] => message/rfc822,[json] => Array ([0] => application/json,[1] => text/json)),[] => ,[] => ,[] => Array (),[] => 1),[security] => CI_Security Object ([] => d12477a33d37684fd8d15d6e44a6a245,[] => ,[] => 7200,[] => ci_csrf_token,[] => ci_csrf_token,[] => Array ([document.cookie] => [removed],[document.write] => [removed],[.parentNode] => [removed],[.innerHTML] => [removed],[window.location] => [removed],[-moz-binding] => [removed],[] => -->,[ <![CDATA[,[] => <comment>),[] => Array ([0] => javascript\s*:,[1] => expression\s*(\(|&\#40;),[2] => vbscript\s*:,[3] => Redirect\s+302,[4] => (["'])?data\s*:[^\1]*?base64[^\1]*?,[^\1]*?\1?)),[input] => CI_Input Object ([ip_address] => ,[user_agent] => ,[_allow_get_array] => 1,[_standardize_newlines] => 1,[_enable_xss] => 1,[_enable_csrf] => ,[] => Array (),[security] => CI_Security Object ([] => d12477a33d37684fd8d15d6e44a6a245,[] => ,[] => 7200,[] => ci_csrf_token,[] => ci_csrf_token,[] => Array ([document.cookie] => [removed],[document.write] => [removed],[.parentNode] => [removed],[.innerHTML] => [removed],[window.location] => [removed],[-moz-binding] => [removed],[] => -->,[ <![CDATA[,[] => <comment>),[] => Array ([0] => javascript\s*:,[1] => expression\s*(\(|&\#40;),[2] => vbscript\s*:,[3] => Redirect\s+302,[4] => (["'])?data\s*:[^\1]*?base64[^\1]*?,[^\1]*?\1?)),[uni] => CI_Utf8 Object ()),[lang] => CI_Lang Object ([language] => Array ([db_invalid_connection_str] => Unable to determine the database settings based on the connection string you submitted.,[db_unable_to_connect] => Unable to connect to your database server using the provided settings.,[db_unable_to_select] => Unable to select the specified database: %s,[db_unable_to_create] => Unable to create the specified database: %s,[db_invalid_query] => The query you submitted is not valid.,[db_must_set_table] => You must set the database table to be used with your query.,[db_must_use_set] => You must use the "set" method to update an entry.,[db_must_use_index] => You must specify an index to match on for batch updates.,[db_batch_missing_index] => One or more rows submitted for batch updating is missing the specified index.,[db_must_use_where] => Updates are not allowed unless they contain a "where" clause.,[db_del_must_use_where] => Deletes are not allowed unless they contain a "where" or "like" clause.,[db_field_param_missing] => To fetch fields requires the name of the table as a parameter.,[db_unsupported_function] => This feature is not available for the database you are using.,[db_transaction_failure] => Transaction failure: Rollback performed.,[db_unable_to_drop] => Unable to drop the specified database.,[db_unsuported_feature] => Unsupported feature of the database platform you are using.,[db_unsuported_compression] => The file compression format you chose is not supported by your server.,[db_filepath_error] => Unable to write data to the file path you have submitted.,[db_invalid_cache_path] => The cache path you submitted is not valid or writable.,[db_table_name_required] => A table name is required for that operation.,[db_column_name_required] => A column name is required for that operation.,[db_column_definition_required] => A column definition is required for that operation.,[db_unable_to_set_charset] => Unable to set client connection character set: %s,[db_error_heading] => A Database Error Occurred),[is_loaded] => Array ([0] => db_lang.php)),[load] => MY_Loader Object ([] => 1,[] => Agent Object ( *RECURSION*,[] => ,[] => 1,[] => Array ([../showingsmart/views/] => 1),[] => Array ([0] => ../showingsmart/,[1] => /usr/share/nginx/html_20260425064701/system/),[] => Array ([0] => ../showingsmart/),[] => Array ([0] => ../showingsmart/,[1] => /usr/share/nginx/html_20260425064701/system/),[] => Array ([benchmark] => Benchmark,[hooks] => Hooks,[config] => Config,[utf8] => Utf8,[uri] => URI,[router] => Router,[output] => Output,[security] => Security,[input] => Input,[lang] => Lang,[loader] => Loader,[model] => Model,[exceptions] => Exceptions),[] => Array (),[] => Array ([url] => url,[auth] => auth,[jsession] => jsession,[csrf] => csrf,[jsonrender] => jsonrender),[] => Array ([0] => ../showingsmart/libraries/url.php,[1] => ../showingsmart/libraries/auth.php,[2] => ../showingsmart/libraries/jsession.php,[3] => ../showingsmart/libraries/csrf.php,[4] => ../showingsmart/libraries/jsonrender.php),[] => Array ([0] => mydb,[1] => user_model,[2] => user_sessions_model,[3] => operator_model,[4] => client_model,[5] => acl_model,[6] => user_token_model,[7] => harcache,[8] => showing_agent_model),[] => Array ([cookie_helper] => 1,[harutil_helper] => 1,[url_helper] => 1,[user_access_helper] => 1,[file_helper] => 1),[] => Array ([unit_test] => unit,[user_agent] => agent)),[url] => Url Object ([] => Agent Object ( *RECURSION*,[] => ,[] => www-test),[jsession] => Jsession Object ([myCI] => Agent Object ( *RECURSION*,[cookie_domain] => .showingsmart.com,[cookie_path] => /),[mydb] => Mydb Object ([dbs] => Array ([defaultwrite] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[default] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harreadonly,[password] => PYKx5Q8eWYjW,[hostname] => mysql-backup-ro.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array ([0] => SELECT a.showing_id, a.showing_date, a.showing_start_time, a.showing_status, a.showing_status_detail, a.showing_end_time,a.online_request_type,
b.lid, b.listingkey as mlsnum, b.listoffice_officekey, b.listing_detail_url, b.listing_photo_url, b.fullstreetaddress, b.city, b.zip, b.call_center_yn, b.liststatus,
b.showing_instruction, b.showing_service_type, b.showing_service_phone, b.call_center_yn, i.home_status, i.lockbox_type,i.lockbox_instruction, i.approval_type,
c.agentkey, c.full_name, c.first_name, c.last_name, replace(c.agent_photo, '400x400', '112x112') agent_photo, c.office_name, c.cell_phone,c.email,
t.tid, t.tour_name, t.tour_date,
(select count(1) from showingsmart.ShowingFeedback d where feedback_type = 'S' and d.showing_id = a.showing_id) as feedback_count
FROM showingsmart.Showing a
INNER JOIN showingsmart.ManagedListing b ON a.lid = b.lid
INNER JOIN showingsmart.Agent c ON b.listagent_agentkey = c.agentkey
LEFT JOIN showingsmart.TourListingXref x ON a.showing_id = x.showing_id
left join showingsmart.Tour t on x.tid = t.tid
left join showingsmart.ShowingInstruction i on b.lid = i.lid

where a.sa_agentkey = '' and a.showing_date >= '2034-01-01' and a.showing_date < '2034-02-01'
order by tid, showing_start_time),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => ,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => CI_DB_Cache Object ([CI] => Agent Object ( *RECURSION*,[db] => CI_DB_mysqli_driver Object ( *RECURSION*),[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => default,[read_delegate] => mysql-backup-ro.hartech.io,[stricton] => ),[mssql_member2] => CI_DB_mssql_driver Object ([dbdriver] => mssql,[_escape_char] => ,[_like_escape_str] => ESCAPE '%s' ,[_like_escape_chr] => !,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => ASC,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => MC@ll36o,[hostname] => stagingdb,[database] => roster,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => ,[cachedir] => ,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => mssql_member2,[stricton] => )),[myCI] => Agent Object ( *RECURSION*),[$dbname] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[user_model] => User_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[] => showingsmart,[dbRead] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harreadonly,[password] => PYKx5Q8eWYjW,[hostname] => mysql-backup-ro.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array ([0] => SELECT a.showing_id, a.showing_date, a.showing_start_time, a.showing_status, a.showing_status_detail, a.showing_end_time,a.online_request_type,
b.lid, b.listingkey as mlsnum, b.listoffice_officekey, b.listing_detail_url, b.listing_photo_url, b.fullstreetaddress, b.city, b.zip, b.call_center_yn, b.liststatus,
b.showing_instruction, b.showing_service_type, b.showing_service_phone, b.call_center_yn, i.home_status, i.lockbox_type,i.lockbox_instruction, i.approval_type,
c.agentkey, c.full_name, c.first_name, c.last_name, replace(c.agent_photo, '400x400', '112x112') agent_photo, c.office_name, c.cell_phone,c.email,
t.tid, t.tour_name, t.tour_date,
(select count(1) from showingsmart.ShowingFeedback d where feedback_type = 'S' and d.showing_id = a.showing_id) as feedback_count
FROM showingsmart.Showing a
INNER JOIN showingsmart.ManagedListing b ON a.lid = b.lid
INNER JOIN showingsmart.Agent c ON b.listagent_agentkey = c.agentkey
LEFT JOIN showingsmart.TourListingXref x ON a.showing_id = x.showing_id
left join showingsmart.Tour t on x.tid = t.tid
left join showingsmart.ShowingInstruction i on b.lid = i.lid

where a.sa_agentkey = '' and a.showing_date >= '2034-01-01' and a.showing_date < '2034-02-01'
order by tid, showing_start_time),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => ,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => CI_DB_Cache Object ([CI] => Agent Object ( *RECURSION*,[db] => CI_DB_mysqli_driver Object ( *RECURSION*),[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => default,[read_delegate] => mysql-backup-ro.hartech.io,[stricton] => ),[msDB] => CI_DB_mssql_driver Object ([dbdriver] => mssql,[_escape_char] => ,[_like_escape_str] => ESCAPE '%s' ,[_like_escape_chr] => !,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => ASC,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => MC@ll36o,[hostname] => stagingdb,[database] => roster,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => ,[cachedir] => ,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => mssql_member2,[stricton] => )),[user_sessions_model] => User_sessions_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[] => showingsmart),[operator_model] => Operator_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[] => showingsmart,[] => $H4st67H@_Alt1P012),[client_model] => Client_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[] => showingsmart,[] => $H4st67H@_Alt1P012),[acl_model] => Acl_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harreadonly,[password] => PYKx5Q8eWYjW,[hostname] => mysql-backup-ro.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array ([0] => SELECT a.showing_id, a.showing_date, a.showing_start_time, a.showing_status, a.showing_status_detail, a.showing_end_time,a.online_request_type,
b.lid, b.listingkey as mlsnum, b.listoffice_officekey, b.listing_detail_url, b.listing_photo_url, b.fullstreetaddress, b.city, b.zip, b.call_center_yn, b.liststatus,
b.showing_instruction, b.showing_service_type, b.showing_service_phone, b.call_center_yn, i.home_status, i.lockbox_type,i.lockbox_instruction, i.approval_type,
c.agentkey, c.full_name, c.first_name, c.last_name, replace(c.agent_photo, '400x400', '112x112') agent_photo, c.office_name, c.cell_phone,c.email,
t.tid, t.tour_name, t.tour_date,
(select count(1) from showingsmart.ShowingFeedback d where feedback_type = 'S' and d.showing_id = a.showing_id) as feedback_count
FROM showingsmart.Showing a
INNER JOIN showingsmart.ManagedListing b ON a.lid = b.lid
INNER JOIN showingsmart.Agent c ON b.listagent_agentkey = c.agentkey
LEFT JOIN showingsmart.TourListingXref x ON a.showing_id = x.showing_id
left join showingsmart.Tour t on x.tid = t.tid
left join showingsmart.ShowingInstruction i on b.lid = i.lid

where a.sa_agentkey = '' and a.showing_date >= '2034-01-01' and a.showing_date < '2034-02-01'
order by tid, showing_start_time),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => ,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => CI_DB_Cache Object ([CI] => Agent Object ( *RECURSION*,[db] => CI_DB_mysqli_driver Object ( *RECURSION*),[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => default,[read_delegate] => mysql-backup-ro.hartech.io,[stricton] => ),[] => showingsmart,[] => ,[] => 0),[user_token_model] => User_token_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ),[] => showingsmart),[auth] => Auth Object ([] => Agent Object ( *RECURSION*,[] => Array ([auth_base_url] => https://id.showingsmart.com/auth,[auth_authorize_url] => /auth,[auth_token_url] => /token,[auth_logout_url] => /logout,[auth_userinfo_url] => /userinfo,[auth_revoke_url] => /revoke,[redirect_uri] => https://www-test.showingsmart.com/login/logincallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback,[partners] => Array ([har] => Array ([realm] => hssmembers,[client_id] => hsswebclient,[secret] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[public-client] => ,[redirect_uri] => ,[redirect_logout_uri] => ,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8HybR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaVe8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4mgnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLLO3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG9wIDAQAB,[realm-secret-key] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg),[operator] => Array ([realm] => hssoperators,[client_id] => hsswebclient,[secret] => 35bd5c2b-1013-45e7-9769-49d4c6035d51,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginoperatorcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?op=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvQu9oLu/2LYvcAFoMTJZHqhlEJswI6f8gPUrEMG3GEbKtlYjgac5UhQ2HCIwfbbZtTGyc6TtCWP3sYGSRHc5vH1sdHybPnGlcPJ0FPZpmHbzHSblWDEGPCzJ6a8upJA/oz9KlyGRCEu90ViOEH8Ee2p11ejSAEntFRiXc4sihlfaParA/4lnuMg03ppJYy8orQ0l+1mv5o+gVpWTsfxJHwSsOMJIWVNUdGDn5+KBFDx+EvkOiBONwfi/sXjclrOxx5yga+AKG2J4JWcIdaz+mrbk377u5eqga1qWRnrwWf36Lu6TCi29gfgWjamy4sOeA8Wja0HxDrHz67ERwbuGAwIDAQAB,[realm-secret-key] => wJ7dK5znzdkZck7WOS2TkDWn459VyeQXk1kb807cCctJr1qMZamh1yYug5jd0LFHlUyoDgO5pQDhuy9ofLgrHw),[client] => Array ([realm] => hssclients,[client_id] => hsswebclient,[secret] => a07adc32-f0d1-4f83-a6dd-4babb43ea463,[public-client] => ,[redirect_uri] => https://www-test.showingsmart.com/login/loginclientcallback,[redirect_logout_uri] => https://www-test.showingsmart.com/login/logoutcallback?cl=1,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjILMuZAXHIKF4kYn1H2xnc+GO7tCeOwlFpSYdCkb3Fj65l4ThexP87K8ApVC5ZOOF2pI/jSKKlHj2WC2bQlf3BKViE1HfV4H/oKdLDrxt6ORM3CyKg87LoL6u79EkQv2x1Y+Tot+FLk9c4Gq9/S3eUj+GU8JtaVnUFY3/d8tzWZlTTIZzVKKtzmOC5ZAFR5lZHbqTkWzv44jXBYuR9fnpm/Y5QoUdyONfqIe8lxtJwSODXFNYfP3zN5n0hdvpCIPM5DoWL5dAlo4gEF9z7AN3qAkEudzObdgMVELuHl7T9e1JEOwn94AMakFHiCgbAykdZFTxryoWentaxbrg8ZcjwIDAQAB,[realm-secret-key] => qVZqDuPvWzO_YyGHronmb9cUjh-q1IiFNCGOBlfYxb1pU0QmuQ9lCORgXnmdladiWmviRuK1AT6vqsaU7Bn8Bg))),[] => har,[] => Array ([realm] => hssmembers,[client_id] => hsswebclient,[secret] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[public-client] => ,[redirect_uri] => ,[redirect_logout_uri] => ,[realm-public-key] => MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8HybR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaVe8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4mgnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLLO3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG9wIDAQAB,[realm-secret-key] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg),[] => OnionIoT\KeyCloak\KeyCloak Object ([grant] => ,[] => hssmembers,[] => hsswebclient,[] => 4c1a6bb0-0a7d-4214-8d2a-a5476bdd0b98,[] => https://id.showingsmart.com/auth/realms/hssmembers,[] => https://id.showingsmart.com/auth/admin/realms/hssmembers,[] => -----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkf5fDu33NxrRtDntQ8Hy
bR0tSmOPIxoIJxP7rT1Xoz5ayDZVPHJr6HcsbKnB9NxgPOmDNgYMkIZL4ul0ikaV
e8TEabz5euRy7gSealoo6nZkHHcSf3evUG+ZOgj26+q46miudDaC3IGcIBva+B4m
gnd0B9hgBkgdBNR8j8CqnRNPuZaeEEs4XFrH3jBnhZ712aNw4t3Uvb0tlx2USLLL
O3mVo0TvHlPGjlUDhI7aKtaMSr6ZdGs9Gc2/0J0TK0x4yJkvGHo2AfUvfO4G80WQ
0LqQC/Pbd5+nEQaNqSv+SviX3KN4imhxL4XYG46qH3y0WETREX1PcCJJ7ZJRJKoG
9wIDAQAB
-----END PUBLIC KEY-----
,[] => HcVrFHUIyhQbgLjbAvaMbKCfcuBKV3BeP6cOvxQJ-ZNLy1UIVu_024yPbJA5e7c8gMMIdcvDeKsOCw_jK9WSSg,[] => ,[] => S4lTnPepp365TnY0lpTO),[] => ,[] => ,[] => ,[] => /,[] => ,[] => member,[] => ,[] => yHd$jUikz&Yh2445DBBdP,[] => cookie_not_found,[] => /agent),[csrf] => Csrf Object ([] => Agent Object ( *RECURSION*),[jsonrender] => JsonRender Object ([] => Agent Object ( *RECURSION*),[harcache] => Harcache Object ([memcache] => ,[mainserver] => ,[forcerenew] => ,[myCI] => Agent Object ( *RECURSION*,[extra] => ,[enviroment_switch] => testing_),[showing_agent_model] => showing_agent_model Object ([] => Agent Object ( *RECURSION*,[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harreadonly,[password] => PYKx5Q8eWYjW,[hostname] => mysql-backup-ro.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array ([0] => SELECT a.showing_id, a.showing_date, a.showing_start_time, a.showing_status, a.showing_status_detail, a.showing_end_time,a.online_request_type,
b.lid, b.listingkey as mlsnum, b.listoffice_officekey, b.listing_detail_url, b.listing_photo_url, b.fullstreetaddress, b.city, b.zip, b.call_center_yn, b.liststatus,
b.showing_instruction, b.showing_service_type, b.showing_service_phone, b.call_center_yn, i.home_status, i.lockbox_type,i.lockbox_instruction, i.approval_type,
c.agentkey, c.full_name, c.first_name, c.last_name, replace(c.agent_photo, '400x400', '112x112') agent_photo, c.office_name, c.cell_phone,c.email,
t.tid, t.tour_name, t.tour_date,
(select count(1) from showingsmart.ShowingFeedback d where feedback_type = 'S' and d.showing_id = a.showing_id) as feedback_count
FROM showingsmart.Showing a
INNER JOIN showingsmart.ManagedListing b ON a.lid = b.lid
INNER JOIN showingsmart.Agent c ON b.listagent_agentkey = c.agentkey
LEFT JOIN showingsmart.TourListingXref x ON a.showing_id = x.showing_id
left join showingsmart.Tour t on x.tid = t.tid
left join showingsmart.ShowingInstruction i on b.lid = i.lid

where a.sa_agentkey = '' and a.showing_date >= '2034-01-01' and a.showing_date < '2034-02-01'
order by tid, showing_start_time),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => ,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => CI_DB_Cache Object ([CI] => Agent Object ( *RECURSION*,[db] => CI_DB_mysqli_driver Object ( *RECURSION*),[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => default,[read_delegate] => mysql-backup-ro.hartech.io,[stricton] => ),[] => CI_DB_mysqli_driver Object ([dbdriver] => mysqli,[_escape_char] => `,[_like_escape_str] => ,[_like_escape_chr] => ,[_count_string] => SELECT COUNT(*) AS ,[_random_keyword] => RAND(),[delete_hack] => 1,[use_set_names] => ,[ar_select] => Array (),[ar_distinct] => ,[ar_from] => Array (),[ar_join] => Array (),[ar_where] => Array (),[ar_like] => Array (),[ar_groupby] => Array (),[ar_having] => Array (),[ar_keys] => Array (),[ar_limit] => ,[ar_offset] => ,[ar_order] => ,[ar_orderby] => Array (),[ar_set] => Array (),[ar_wherein] => Array (),[ar_aliased_tables] => Array (),[ar_store_array] => Array (),[ar_caching] => ,[ar_cache_exists] => Array (),[ar_cache_select] => Array (),[ar_cache_from] => Array (),[ar_cache_join] => Array (),[ar_cache_where] => Array (),[ar_cache_like] => Array (),[ar_cache_groupby] => Array (),[ar_cache_having] => Array (),[ar_cache_orderby] => Array (),[ar_cache_set] => Array (),[ar_no_escape] => Array (),[ar_cache_no_escape] => Array (),[username] => harmember,[password] => Mc@ll36oHui,[hostname] => mysql-backup.hartech.io,[database] => harnew,[dbprefix] => ,[char_set] => utf8,[dbcollat] => utf8_general_ci,[autoinit] => ,[swap_pre] => ,[port] => ,[pconnect] => ,[conn_id] => ,[result_id] => ,[db_debug] => 1,[benchmark] => 0,[query_count] => 0,[bind_marker] => ?,[save_queries] => 1,[queries] => Array (),[query_times] => Array (),[data_cache] => Array (),[trans_enabled] => 1,[trans_strict] => 1,[_trans_depth] => 0,[_trans_status] => 1,[cache_on] => 1,[cachedir] => application/cache,[cache_autodel] => ,[CACHE] => ,[_protect_identifiers] => 1,[_reserved_identifiers] => Array ([0] => *),[stmt_id] => ,[curs_id] => ,[limit_used] => ,[dname] => defaultwrite,[stricton] => ))),[1] => showings), Array ()) called at [/usr/share/nginx/html_20260425064701/showingsmart/controllers/agent.php:42]
#9 Agent->_remap(showings, Array ()) called at [/usr/share/nginx/html_20260425064701/system/core/CodeIgniter.php:336]
#10 require_once(/usr/share/nginx/html_20260425064701/system/core/CodeIgniter.php) called at [/usr/share/nginx/html_20260425064701/webroot/smartindex.php:214]