Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc LIMIT 20 OFFSET 20' at line 1
*/ |
|
public function execute($params = null) |
|
{ |
|
$this->_driver->connection()->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $this->_bufferResults); |
|
$result = $this->_statement->execute($params); |
|
$this->_driver->connection()->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); |
|
|
|
return $result; |
|
} |
null
public function run(Query $query) |
|
{ |
|
$statement = $this->prepare($query); |
|
$query->valueBinder()->attachTo($statement); |
|
$statement->execute(); |
|
|
|
return $statement; |
|
} |
|
|
No arguments
* @return \Cake\Database\StatementInterface |
|
*/ |
|
public function execute() |
|
{ |
|
$statement = $this->_connection->run($this); |
|
$driver = $this->_connection->driver(); |
|
$typeMap = $this->selectTypeMap(); |
|
|
|
if ($typeMap->toArray() && $this->_typeCastAttached === false) { |
object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Users.id AS `Users__id`, Users.parent_id AS `Users__parent_id`, Users.username AS `Users__username`, Users.password AS `Users__password`, Users.first_name AS `Users__first_name`, Users.last_name AS `Users__last_name`, Users.full_name AS `Users__full_name`, Users.profile_pic_path AS `Users__profile_pic_path`, Users.date_of_birth AS `Users__date_of_birth`, Users.gender AS `Users__gender`, Users.address_line_1 AS `Users__address_line_1`, Users.address_line_2 AS `Users__address_line_2`, Users.city AS `Users__city`, Users.state_province AS `Users__state_province`, Users.zip_postal_code AS `Users__zip_postal_code`, Users.country_id AS `Users__country_id`, Users.state AS `Users__state`, Users.province AS `Users__province`, Users.mailing_address_line_1 AS `Users__mailing_address_line_1`, Users.mailin_address_line_2 AS `Users__mailin_address_line_2`, Users.mailing_city AS `Users__mailing_city`, Users.mailing_state_province AS `Users__mailing_state_province`, Users.mailing_zip_postal_code AS `Users__mailing_zip_postal_code`, Users.mailing_country_id AS `Users__mailing_country_id`, Users.mailing_ship_name AS `Users__mailing_ship_name`, Users.mailing_state AS `Users__mailing_state`, Users.mailing_province AS `Users__mailing_province`, Users.mailing_country AS `Users__mailing_country`, Users.phone AS `Users__phone`, Users.mobile AS `Users__mobile`, Users.email AS `Users__email`, Users.website AS `Users__website`, Users.active AS `Users__active`, Users.banned AS `Users__banned`, Users.created AS `Users__created`, Users.modified AS `Users__modified`, Users.created_by AS `Users__created_by`, Users.modified_by AS `Users__modified_by`, Users.group_id AS `Users__group_id`, Users.role_id AS `Users__role_id`, Users.temp_reset_val AS `Users__temp_reset_val`, Users.met_institution_id AS `Users__met_institution_id`, Users.con_institution_id AS `Users__con_institution_id`, Users.acc_institution_id AS `Users__acc_institution_id`, Users.ins_institution_id AS `Users__ins_institution_id`, Users.cer_institution_id AS `Users__cer_institution_id`, Users.business_name AS `Users__business_name`, Users.position AS `Users__position`, Users.qualifications AS `Users__qualifications`, Users.experience AS `Users__experience`, Users.resume_path AS `Users__resume_path`, Users.competence AS `Users__competence`, Users.certifications AS `Users__certifications`, Users.working_language AS `Users__working_language`, Users.years_of_experience AS `Users__years_of_experience`, Users.make_profile_public AS `Users__make_profile_public`, Users.verified AS `Users__verified`, Users.company AS `Users__company`, Users.occupation AS `Users__occupation`, Users.department AS `Users__department`, Users.approved AS `Users__approved`, Users.qi_professional AS `Users__qi_professional`, Users.completed AS `Users__completed`, Groups.id AS `Groups__id`, Groups.title AS `Groups__title`, Groups.name AS `Groups__name`, Groups.created AS `Groups__created`, Groups.parent_id AS `Groups__parent_id`, Groups.modified AS `Groups__modified`, Groups.order AS `Groups__order`, Groups.created_by AS `Groups__created_by`, Groups.modified_by AS `Groups__modified_by`, Roles.id AS `Roles__id`, Roles.group_id AS `Roles__group_id`, Roles.name AS `Roles__name`, Roles.created AS `Roles__created`, Roles.modified AS `Roles__modified`, MetrologyInstitutions.country_id AS `MetrologyInstitutions__country_id`, MetrologyInstitutions.id AS `MetrologyInstitutions__id`, MetrologyInstitutions.photo_path AS `MetrologyInstitutions__photo_path`, MetrologyInstitutions.trademark_path AS `MetrologyInstitutions__trademark_path`, MetrologyInstitutions.name AS `MetrologyInstitutions__name`, MetrologyInstitutions.description AS `MetrologyInstitutions__description`, MetrologyInstitutions.phone AS `MetrologyInstitutions__phone`, MetrologyInstitutions.fax AS `MetrologyInstitutions__fax`, MetrologyInstitutions.email AS `MetrologyInstitutions__email`, MetrologyInstitutions.street AS `MetrologyInstitutions__street`, MetrologyInstitutions.building AS `MetrologyInstitutions__building`, MetrologyInstitutions.zip AS `MetrologyInstitutions__zip`, MetrologyInstitutions.city AS `MetrologyInstitutions__city`, MetrologyInstitutions.website AS `MetrologyInstitutions__website`, MetrologyInstitutions.facebook AS `MetrologyInstitutions__facebook`, MetrologyInstitutions.twitter AS `MetrologyInstitutions__twitter`, MetrologyInstitutions.github AS `MetrologyInstitutions__github`, MetrologyInstitutions.google AS `MetrologyInstitutions__google`, MetrologyInstitutions.linkedin AS `MetrologyInstitutions__linkedin`, ConformityAssessmentInstitutions.institution_country_id AS `ConformityAssessmentInstitutions__institution_country_id`, ConformityAssessmentInstitutions.institution_accreditation_body_id AS `ConformityAssessmentInstitutions__institution_accreditation_body_id`, ConformityAssessmentInstitutions.institution_type_id AS `ConformityAssessmentInstitutions__institution_type_id`, ConformityAssessmentInstitutions.institution_group_id AS `ConformityAssessmentInstitutions__institution_group_id`, ConformityAssessmentInstitutions.institution_legal_status_id AS `ConformityAssessmentInstitutions__institution_legal_status_id`, ConformityAssessmentInstitutions.institution_economic_sector_id AS `ConformityAssessmentInstitutions__institution_economic_sector_id`, ConformityAssessmentInstitutions.id AS `ConformityAssessmentInstitutions__id`, ConformityAssessmentInstitutions.name AS `ConformityAssessmentInstitutions__name`, ConformityAssessmentInstitutions.description AS `ConformityAssessmentInstitutions__description`, ConformityAssessmentInstitutions.trademark_path AS `ConformityAssessmentInstitutions__trademark_path`, ConformityAssessmentInstitutions.photo_path AS `ConformityAssessmentInstitutions__photo_path`, ConformityAssessmentInstitutions.phone AS `ConformityAssessmentInstitutions__phone`, ConformityAssessmentInstitutions.fax AS `ConformityAssessmentInstitutions__fax`, ConformityAssessmentInstitutions.email AS `ConformityAssessmentInstitutions__email`, ConformityAssessmentInstitutions.street AS `ConformityAssessmentInstitutions__street`, ConformityAssessmentInstitutions.building AS `ConformityAssessmentInstitutions__building`, ConformityAssessmentInstitutions.postal_code AS `ConformityAssessmentInstitutions__postal_code`, ConformityAssessmentInstitutions.parish AS `ConformityAssessmentInstitutions__parish`, ConformityAssessmentInstitutions.city AS `ConformityAssessmentInstitutions__city`, ConformityAssessmentInstitutions.website AS `ConformityAssessmentInstitutions__website`, ConformityAssessmentInstitutions.facebook AS `ConformityAssessmentInstitutions__facebook`, ConformityAssessmentInstitutions.twitter AS `ConformityAssessmentInstitutions__twitter`, ConformityAssessmentInstitutions.google AS `ConformityAssessmentInstitutions__google`, ConformityAssessmentInstitutions.linkedin AS `ConformityAssessmentInstitutions__linkedin`, AccreditationInstitutions.institution_country_id AS `AccreditationInstitutions__institution_country_id`, AccreditationInstitutions.institution_accreditation_body_id AS `AccreditationInstitutions__institution_accreditation_body_id`, AccreditationInstitutions.institution_type_id AS `AccreditationInstitutions__institution_type_id`, AccreditationInstitutions.institution_group_id AS `AccreditationInstitutions__institution_group_id`, AccreditationInstitutions.institution_legal_status_id AS `AccreditationInstitutions__institution_legal_status_id`, AccreditationInstitutions.institution_economic_sector_id AS `AccreditationInstitutions__institution_economic_sector_id`, AccreditationInstitutions.id AS `AccreditationInstitutions__id`, AccreditationInstitutions.name AS `AccreditationInstitutions__name`, AccreditationInstitutions.description AS `AccreditationInstitutions__description`, AccreditationInstitutions.trademark_path AS `AccreditationInstitutions__trademark_path`, AccreditationInstitutions.photo_path AS `AccreditationInstitutions__photo_path`, AccreditationInstitutions.phone AS `AccreditationInstitutions__phone`, AccreditationInstitutions.fax AS `AccreditationInstitutions__fax`, AccreditationInstitutions.email AS `AccreditationInstitutions__email`, AccreditationInstitutions.street AS `AccreditationInstitutions__street`, AccreditationInstitutions.building AS `AccreditationInstitutions__building`, AccreditationInstitutions.postal_code AS `AccreditationInstitutions__postal_code`, AccreditationInstitutions.parish AS `AccreditationInstitutions__parish`, AccreditationInstitutions.city AS `AccreditationInstitutions__city`, AccreditationInstitutions.website AS `AccreditationInstitutions__website`, AccreditationInstitutions.facebook AS `AccreditationInstitutions__facebook`, AccreditationInstitutions.twitter AS `AccreditationInstitutions__twitter`, AccreditationInstitutions.google AS `AccreditationInstitutions__google`, AccreditationInstitutions.linkedin AS `AccreditationInstitutions__linkedin`, AccreditationInstitutions.period AS `AccreditationInstitutions__period`, CertificationInstitutions.institution_country_id AS `CertificationInstitutions__institution_country_id`, CertificationInstitutions.institution_accreditation_body_id AS `CertificationInstitutions__institution_accreditation_body_id`, CertificationInstitutions.institution_type_id AS `CertificationInstitutions__institution_type_id`, CertificationInstitutions.institution_group_id AS `CertificationInstitutions__institution_group_id`, CertificationInstitutions.institution_legal_status_id AS `CertificationInstitutions__institution_legal_status_id`, CertificationInstitutions.institution_economic_sector_id AS `CertificationInstitutions__institution_economic_sector_id`, CertificationInstitutions.id AS `CertificationInstitutions__id`, CertificationInstitutions.name AS `CertificationInstitutions__name`, CertificationInstitutions.description AS `CertificationInstitutions__description`, CertificationInstitutions.trademark AS `CertificationInstitutions__trademark`, CertificationInstitutions.photo_path AS `CertificationInstitutions__photo_path`, CertificationInstitutions.phone AS `CertificationInstitutions__phone`, CertificationInstitutions.fax AS `CertificationInstitutions__fax`, CertificationInstitutions.email AS `CertificationInstitutions__email`, CertificationInstitutions.street AS `CertificationInstitutions__street`, CertificationInstitutions.building AS `CertificationInstitutions__building`, CertificationInstitutions.postal_code AS `CertificationInstitutions__postal_code`, CertificationInstitutions.parish AS `CertificationInstitutions__parish`, CertificationInstitutions.city AS `CertificationInstitutions__city`, CertificationInstitutions.website AS `CertificationInstitutions__website`, CertificationInstitutions.facebook AS `CertificationInstitutions__facebook`, CertificationInstitutions.twitter AS `CertificationInstitutions__twitter`, CertificationInstitutions.google AS `CertificationInstitutions__google`, CertificationInstitutions.linkedin AS `CertificationInstitutions__linkedin`, InspectionInstitutions.institution_country_id AS `InspectionInstitutions__institution_country_id`, InspectionInstitutions.institution_accreditation_body_id AS `InspectionInstitutions__institution_accreditation_body_id`, InspectionInstitutions.institution_type_id AS `InspectionInstitutions__institution_type_id`, InspectionInstitutions.institution_group_id AS `InspectionInstitutions__institution_group_id`, InspectionInstitutions.institution_legal_status_id AS `InspectionInstitutions__institution_legal_status_id`, InspectionInstitutions.institution_economic_sector_id AS `InspectionInstitutions__institution_economic_sector_id`, InspectionInstitutions.id AS `InspectionInstitutions__id`, InspectionInstitutions.name AS `InspectionInstitutions__name`, InspectionInstitutions.description AS `InspectionInstitutions__description`, InspectionInstitutions.trademark AS `InspectionInstitutions__trademark`, InspectionInstitutions.photo_path AS `InspectionInstitutions__photo_path`, InspectionInstitutions.phone AS `InspectionInstitutions__phone`, InspectionInstitutions.fax AS `InspectionInstitutions__fax`, InspectionInstitutions.email AS `InspectionInstitutions__email`, InspectionInstitutions.street AS `InspectionInstitutions__street`, InspectionInstitutions.building AS `InspectionInstitutions__building`, InspectionInstitutions.postal_code AS `InspectionInstitutions__postal_code`, InspectionInstitutions.parish AS `InspectionInstitutions__parish`, InspectionInstitutions.city AS `InspectionInstitutions__city`, InspectionInstitutions.website AS `InspectionInstitutions__website`, InspectionInstitutions.facebook AS `InspectionInstitutions__facebook`, InspectionInstitutions.twitter AS `InspectionInstitutions__twitter`, InspectionInstitutions.google AS `InspectionInstitutions__google`, InspectionInstitutions.linkedin AS `InspectionInstitutions__linkedin`, Countries.id AS `Countries__id`, Countries.common_name AS `Countries__common_name`, InstitutionCountries.id AS `InstitutionCountries__id`, InstitutionCountries.name AS `InstitutionCountries__name` FROM users Users LEFT JOIN groups Groups ON Groups.id = (Users.group_id) LEFT JOIN roles Roles ON Roles.id = (Users.role_id) LEFT JOIN met_institutions MetrologyInstitutions ON MetrologyInstitutions.id = (Users.met_institution_id) LEFT JOIN con_institutions ConformityAssessmentInstitutions ON ConformityAssessmentInstitutions.id = (Users.con_institution_id) LEFT JOIN acc_institutions AccreditationInstitutions ON AccreditationInstitutions.id = (Users.acc_institution_id) LEFT JOIN cer_institutions CertificationInstitutions ON CertificationInstitutions.id = (Users.cer_institution_id) LEFT JOIN ins_institutions InspectionInstitutions ON InspectionInstitutions.id = (Users.ins_institution_id) LEFT JOIN countries Countries ON Countries.id = (Users.country_id) LEFT JOIN uni_countries InstitutionCountries ON InstitutionCountries.id = (Users.country_id) WHERE ((Users.group_id = :c0 OR Users.group_id = :c1 OR Users.group_id = :c2) AND Users.qi_professional = :c3 AND Users.make_profile_public = :c4 AND Users.verified = :c5 AND Users.approved = :c6) ORDER BY asc LIMIT 20 OFFSET 20', 'params' => [ ':c0' => [ 'value' => (int) 2, 'type' => 'integer', 'placeholder' => 'c0' ], ':c1' => [ 'value' => (int) 3, 'type' => 'integer', 'placeholder' => 'c1' ], ':c2' => [ 'value' => (int) 4, 'type' => 'integer', 'placeholder' => 'c2' ], ':c3' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c3' ], ':c4' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c4' ], ':c5' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c5' ], ':c6' => [ 'value' => (int) 1, 'type' => 'boolean', 'placeholder' => 'c6' ] ], 'defaultTypes' => [ 'Users__id' => 'integer', 'Users.id' => 'integer', 'id' => 'integer', 'Users__parent_id' => 'integer', 'Users.parent_id' => 'integer', 'parent_id' => 'integer', 'Users__username' => 'string', 'Users.username' => 'string', 'username' => 'string', 'Users__password' => 'string', 'Users.password' => 'string', 'password' => 'string', 'Users__first_name' => 'string', 'Users.first_name' => 'string', 'first_name' => 'string', 'Users__last_name' => 'string', 'Users.last_name' => 'string', 'last_name' => 'string', 'Users__full_name' => 'string', 'Users.full_name' => 'string', 'full_name' => 'string', 'Users__profile_pic_path' => 'string', 'Users.profile_pic_path' => 'string', 'profile_pic_path' => 'string', 'Users__date_of_birth' => 'date', 'Users.date_of_birth' => 'date', 'date_of_birth' => 'date', 'Users__gender' => 'string', 'Users.gender' => 'string', 'gender' => 'string', 'Users__address_line_1' => 'string', 'Users.address_line_1' => 'string', 'address_line_1' => 'string', 'Users__address_line_2' => 'string', 'Users.address_line_2' => 'string', 'address_line_2' => 'string', 'Users__city' => 'string', 'Users.city' => 'string', 'city' => 'string', 'Users__state_province' => 'string', 'Users.state_province' => 'string', 'state_province' => 'string', 'Users__zip_postal_code' => 'string', 'Users.zip_postal_code' => 'string', 'zip_postal_code' => 'string', 'Users__country_id' => 'integer', 'Users.country_id' => 'integer', 'country_id' => 'integer', 'Users__state' => 'string', 'Users.state' => 'string', 'state' => 'string', 'Users__province' => 'string', 'Users.province' => 'string', 'province' => 'string', 'Users__mailing_address_line_1' => 'string', 'Users.mailing_address_line_1' => 'string', 'mailing_address_line_1' => 'string', 'Users__mailin_address_line_2' => 'string', 'Users.mailin_address_line_2' => 'string', 'mailin_address_line_2' => 'string', 'Users__mailing_city' => 'string', 'Users.mailing_city' => 'string', 'mailing_city' => 'string', 'Users__mailing_state_province' => 'string', 'Users.mailing_state_province' => 'string', 'mailing_state_province' => 'string', 'Users__mailing_zip_postal_code' => 'string', 'Users.mailing_zip_postal_code' => 'string', 'mailing_zip_postal_code' => 'string', 'Users__mailing_country_id' => 'integer', 'Users.mailing_country_id' => 'integer', 'mailing_country_id' => 'integer', 'Users__mailing_ship_name' => 'string', 'Users.mailing_ship_name' => 'string', 'mailing_ship_name' => 'string', 'Users__mailing_state' => 'string', 'Users.mailing_state' => 'string', 'mailing_state' => 'string', 'Users__mailing_province' => 'string', 'Users.mailing_province' => 'string', 'mailing_province' => 'string', 'Users__mailing_country' => 'string', 'Users.mailing_country' => 'string', 'mailing_country' => 'string', 'Users__phone' => 'string', 'Users.phone' => 'string', 'phone' => 'string', 'Users__mobile' => 'string', 'Users.mobile' => 'string', 'mobile' => 'string', 'Users__email' => 'string', 'Users.email' => 'string', 'email' => 'string', 'Users__website' => 'string', 'Users.website' => 'string', 'website' => 'string', 'Users__active' => 'boolean', 'Users.active' => 'boolean', 'active' => 'boolean', 'Users__banned' => 'boolean', 'Users.banned' => 'boolean', 'banned' => 'boolean', 'Users__created' => 'datetime', 'Users.created' => 'datetime', 'created' => 'datetime', 'Users__modified' => 'datetime', 'Users.modified' => 'datetime', 'modified' => 'datetime', 'Users__created_by' => 'integer', 'Users.created_by' => 'integer', 'created_by' => 'integer', 'Users__modified_by' => 'integer', 'Users.modified_by' => 'integer', 'modified_by' => 'integer', 'Users__group_id' => 'integer', 'Users.group_id' => 'integer', 'group_id' => 'integer', 'Users__role_id' => 'integer', 'Users.role_id' => 'integer', 'role_id' => 'integer', 'Users__temp_reset_val' => 'string', 'Users.temp_reset_val' => 'string', 'temp_reset_val' => 'string', 'Users__met_institution_id' => 'integer', 'Users.met_institution_id' => 'integer', 'met_institution_id' => 'integer', 'Users__con_institution_id' => 'integer', 'Users.con_institution_id' => 'integer', 'con_institution_id' => 'integer', 'Users__acc_institution_id' => 'integer', 'Users.acc_institution_id' => 'integer', 'acc_institution_id' => 'integer', 'Users__ins_institution_id' => 'integer', 'Users.ins_institution_id' => 'integer', 'ins_institution_id' => 'integer', 'Users__cer_institution_id' => 'integer', 'Users.cer_institution_id' => 'integer', 'cer_institution_id' => 'integer', 'Users__business_name' => 'string', 'Users.business_name' => 'string', 'business_name' => 'string', 'Users__position' => 'string', 'Users.position' => 'string', 'position' => 'string', 'Users__qualifications' => 'text', 'Users.qualifications' => 'text', 'qualifications' => 'text', 'Users__experience' => 'text', 'Users.experience' => 'text', 'experience' => 'text', 'Users__resume_path' => 'string', 'Users.resume_path' => 'string', 'resume_path' => 'string', 'Users__competence' => 'text', 'Users.competence' => 'text', 'competence' => 'text', 'Users__certifications' => 'text', 'Users.certifications' => 'text', 'certifications' => 'text', 'Users__working_language' => 'text', 'Users.working_language' => 'text', 'working_language' => 'text', 'Users__years_of_experience' => 'integer', 'Users.years_of_experience' => 'integer', 'years_of_experience' => 'integer', 'Users__make_profile_public' => 'boolean', 'Users.make_profile_public' => 'boolean', 'make_profile_public' => 'boolean', 'Users__verified' => 'boolean', 'Users.verified' => 'boolean', 'verified' => 'boolean', 'Users__company' => 'string', 'Users.company' => 'string', 'company' => 'string', 'Users__occupation' => 'string', 'Users.occupation' => 'string', 'occupation' => 'string', 'Users__department' => 'string', 'Users.department' => 'string', 'department' => 'string', 'Users__approved' => 'boolean', 'Users.approved' => 'boolean', 'approved' => 'boolean', 'Users__qi_professional' => 'boolean', 'Users.qi_professional' => 'boolean', 'qi_professional' => 'boolean', 'Users__completed' => 'boolean', 'Users.completed' => 'boolean', 'completed' => 'boolean', 'Groups__id' => 'integer', 'Groups.id' => 'integer', 'Groups__title' => 'string', 'Groups.title' => 'string', 'title' => 'string', 'Groups__name' => 'string', 'Groups.name' => 'string', 'name' => 'string', 'Groups__created' => 'date', 'Groups.created' => 'date', 'Groups__parent_id' => 'integer', 'Groups.parent_id' => 'integer', 'Groups__modified' => 'datetime', 'Groups.modified' => 'datetime', 'Groups__order' => 'integer', 'Groups.order' => 'integer', 'order' => 'integer', 'Groups__created_by' => 'integer', 'Groups.created_by' => 'integer', 'Groups__modified_by' => 'integer', 'Groups.modified_by' => 'integer', 'Roles__id' => 'integer', 'Roles.id' => 'integer', 'Roles__group_id' => 'integer', 'Roles.group_id' => 'integer', 'Roles__name' => 'string', 'Roles.name' => 'string', 'Roles__created' => 'datetime', 'Roles.created' => 'datetime', 'Roles__modified' => 'datetime', 'Roles.modified' => 'datetime', 'MetrologyInstitutions__country_id' => 'integer', 'MetrologyInstitutions.country_id' => 'integer', 'MetrologyInstitutions__id' => 'integer', 'MetrologyInstitutions.id' => 'integer', 'MetrologyInstitutions__photo_path' => 'string', 'MetrologyInstitutions.photo_path' => 'string', 'photo_path' => 'string', 'MetrologyInstitutions__trademark_path' => 'string', 'MetrologyInstitutions.trademark_path' => 'string', 'trademark_path' => 'string', 'MetrologyInstitutions__name' => 'string', 'MetrologyInstitutions.name' => 'string', 'MetrologyInstitutions__description' => 'text', 'MetrologyInstitutions.description' => 'text', 'description' => 'text', 'MetrologyInstitutions__phone' => 'string', 'MetrologyInstitutions.phone' => 'string', 'MetrologyInstitutions__fax' => 'string', 'MetrologyInstitutions.fax' => 'string', 'fax' => 'string', 'MetrologyInstitutions__email' => 'string', 'MetrologyInstitutions.email' => 'string', 'MetrologyInstitutions__street' => 'string', 'MetrologyInstitutions.street' => 'string', 'street' => 'string', 'MetrologyInstitutions__building' => 'string', 'MetrologyInstitutions.building' => 'string', 'building' => 'string', 'MetrologyInstitutions__zip' => 'string', 'MetrologyInstitutions.zip' => 'string', 'zip' => 'string', 'MetrologyInstitutions__city' => 'string', 'MetrologyInstitutions.city' => 'string', 'MetrologyInstitutions__website' => 'string', 'MetrologyInstitutions.website' => 'string', 'MetrologyInstitutions__facebook' => 'string', 'MetrologyInstitutions.facebook' => 'string', 'facebook' => 'string', 'MetrologyInstitutions__twitter' => 'string', 'MetrologyInstitutions.twitter' => 'string', 'twitter' => 'string', 'MetrologyInstitutions__github' => 'string', 'MetrologyInstitutions.github' => 'string', 'github' => 'string', 'MetrologyInstitutions__google' => 'string', 'MetrologyInstitutions.google' => 'string', 'google' => 'string', 'MetrologyInstitutions__linkedin' => 'string', 'MetrologyInstitutions.linkedin' => 'string', 'linkedin' => 'string', 'ConformityAssessmentInstitutions__institution_country_id' => 'integer', 'ConformityAssessmentInstitutions.institution_country_id' => 'integer', 'institution_country_id' => 'integer', 'ConformityAssessmentInstitutions__institution_accreditation_body_id' => 'integer', 'ConformityAssessmentInstitutions.institution_accreditation_body_id' => 'integer', 'institution_accreditation_body_id' => 'integer', 'ConformityAssessmentInstitutions__institution_type_id' => 'integer', 'ConformityAssessmentInstitutions.institution_type_id' => 'integer', 'institution_type_id' => 'integer', 'ConformityAssessmentInstitutions__institution_group_id' => 'integer', 'ConformityAssessmentInstitutions.institution_group_id' => 'integer', 'institution_group_id' => 'integer', 'ConformityAssessmentInstitutions__institution_legal_status_id' => 'integer', 'ConformityAssessmentInstitutions.institution_legal_status_id' => 'integer', 'institution_legal_status_id' => 'integer', 'ConformityAssessmentInstitutions__institution_economic_sector_id' => 'integer', 'ConformityAssessmentInstitutions.institution_economic_sector_id' => 'integer', 'institution_economic_sector_id' => 'integer', 'ConformityAssessmentInstitutions__id' => 'integer', 'ConformityAssessmentInstitutions.id' => 'integer', 'ConformityAssessmentInstitutions__name' => 'string', 'ConformityAssessmentInstitutions.name' => 'string', 'ConformityAssessmentInstitutions__description' => 'text', 'ConformityAssessmentInstitutions.description' => 'text', 'ConformityAssessmentInstitutions__trademark_path' => 'string', 'ConformityAssessmentInstitutions.trademark_path' => 'string', 'ConformityAssessmentInstitutions__photo_path' => 'string', 'ConformityAssessmentInstitutions.photo_path' => 'string', 'ConformityAssessmentInstitutions__phone' => 'string', 'ConformityAssessmentInstitutions.phone' => 'string', 'ConformityAssessmentInstitutions__fax' => 'string', 'ConformityAssessmentInstitutions.fax' => 'string', 'ConformityAssessmentInstitutions__email' => 'string', 'ConformityAssessmentInstitutions.email' => 'string', 'ConformityAssessmentInstitutions__street' => 'string', 'ConformityAssessmentInstitutions.street' => 'string', 'ConformityAssessmentInstitutions__building' => 'string', 'ConformityAssessmentInstitutions.building' => 'string', 'ConformityAssessmentInstitutions__postal_code' => 'string', 'ConformityAssessmentInstitutions.postal_code' => 'string', 'postal_code' => 'string', 'ConformityAssessmentInstitutions__parish' => 'string', 'ConformityAssessmentInstitutions.parish' => 'string', 'parish' => 'string', 'ConformityAssessmentInstitutions__city' => 'string', 'ConformityAssessmentInstitutions.city' => 'string', 'ConformityAssessmentInstitutions__website' => 'string', 'ConformityAssessmentInstitutions.website' => 'string', 'ConformityAssessmentInstitutions__facebook' => 'string', 'ConformityAssessmentInstitutions.facebook' => 'string', 'ConformityAssessmentInstitutions__twitter' => 'string', 'ConformityAssessmentInstitutions.twitter' => 'string', 'ConformityAssessmentInstitutions__google' => 'string', 'ConformityAssessmentInstitutions.google' => 'string', 'ConformityAssessmentInstitutions__linkedin' => 'string', 'ConformityAssessmentInstitutions.linkedin' => 'string', 'AccreditationInstitutions__institution_country_id' => 'integer', 'AccreditationInstitutions.institution_country_id' => 'integer', 'AccreditationInstitutions__institution_accreditation_body_id' => 'integer', 'AccreditationInstitutions.institution_accreditation_body_id' => 'integer', 'AccreditationInstitutions__institution_type_id' => 'integer', 'AccreditationInstitutions.institution_type_id' => 'integer', 'AccreditationInstitutions__institution_group_id' => 'integer', 'AccreditationInstitutions.institution_group_id' => 'integer', 'AccreditationInstitutions__institution_legal_status_id' => 'integer', 'AccreditationInstitutions.institution_legal_status_id' => 'integer', 'AccreditationInstitutions__institution_economic_sector_id' => 'integer', 'AccreditationInstitutions.institution_economic_sector_id' => 'integer', 'AccreditationInstitutions__id' => 'integer', 'AccreditationInstitutions.id' => 'integer', 'AccreditationInstitutions__name' => 'string', 'AccreditationInstitutions.name' => 'string', 'AccreditationInstitutions__description' => 'text', 'AccreditationInstitutions.description' => 'text', 'AccreditationInstitutions__trademark_path' => 'string', 'AccreditationInstitutions.trademark_path' => 'string', 'AccreditationInstitutions__photo_path' => 'string', 'AccreditationInstitutions.photo_path' => 'string', 'AccreditationInstitutions__phone' => 'string', 'AccreditationInstitutions.phone' => 'string', 'AccreditationInstitutions__fax' => 'string', 'AccreditationInstitutions.fax' => 'string', 'AccreditationInstitutions__email' => 'string', 'AccreditationInstitutions.email' => 'string', 'AccreditationInstitutions__street' => 'string', 'AccreditationInstitutions.street' => 'string', 'AccreditationInstitutions__building' => 'string', 'AccreditationInstitutions.building' => 'string', 'AccreditationInstitutions__postal_code' => 'string', 'AccreditationInstitutions.postal_code' => 'string', 'AccreditationInstitutions__parish' => 'string', 'AccreditationInstitutions.parish' => 'string', 'AccreditationInstitutions__city' => 'string', 'AccreditationInstitutions.city' => 'string', 'AccreditationInstitutions__website' => 'string', 'AccreditationInstitutions.website' => 'string', 'AccreditationInstitutions__facebook' => 'string', 'AccreditationInstitutions.facebook' => 'string', 'AccreditationInstitutions__twitter' => 'string', 'AccreditationInstitutions.twitter' => 'string', 'AccreditationInstitutions__google' => 'string', 'AccreditationInstitutions.google' => 'string', 'AccreditationInstitutions__linkedin' => 'string', 'AccreditationInstitutions.linkedin' => 'string', 'AccreditationInstitutions__period' => 'integer', 'AccreditationInstitutions.period' => 'integer', 'period' => 'integer', 'CertificationInstitutions__institution_country_id' => 'integer', 'CertificationInstitutions.institution_country_id' => 'integer', 'CertificationInstitutions__institution_accreditation_body_id' => 'integer', 'CertificationInstitutions.institution_accreditation_body_id' => 'integer', 'CertificationInstitutions__institution_type_id' => 'integer', 'CertificationInstitutions.institution_type_id' => 'integer', 'CertificationInstitutions__institution_group_id' => 'integer', 'CertificationInstitutions.institution_group_id' => 'integer', 'CertificationInstitutions__institution_legal_status_id' => 'integer', 'CertificationInstitutions.institution_legal_status_id' => 'integer', 'CertificationInstitutions__institution_economic_sector_id' => 'integer', 'CertificationInstitutions.institution_economic_sector_id' => 'integer', 'CertificationInstitutions__id' => 'integer', 'CertificationInstitutions.id' => 'integer', 'CertificationInstitutions__name' => 'string', 'CertificationInstitutions.name' => 'string', 'CertificationInstitutions__description' => 'text', 'CertificationInstitutions.description' => 'text', 'CertificationInstitutions__trademark' => 'string', 'CertificationInstitutions.trademark' => 'string', 'trademark' => 'string', 'CertificationInstitutions__photo_path' => 'string', 'CertificationInstitutions.photo_path' => 'string', 'CertificationInstitutions__phone' => 'string', 'CertificationInstitutions.phone' => 'string', 'CertificationInstitutions__fax' => 'string', 'CertificationInstitutions.fax' => 'string', 'CertificationInstitutions__email' => 'string', 'CertificationInstitutions.email' => 'string', 'CertificationInstitutions__street' => 'string', 'CertificationInstitutions.street' => 'string', 'CertificationInstitutions__building' => 'string', 'CertificationInstitutions.building' => 'string', 'CertificationInstitutions__postal_code' => 'string', 'CertificationInstitutions.postal_code' => 'string', 'CertificationInstitutions__parish' => 'string', 'CertificationInstitutions.parish' => 'string', 'CertificationInstitutions__city' => 'string', 'CertificationInstitutions.city' => 'string', 'CertificationInstitutions__website' => 'string', 'CertificationInstitutions.website' => 'string', 'CertificationInstitutions__facebook' => 'string', 'CertificationInstitutions.facebook' => 'string', 'CertificationInstitutions__twitter' => 'string', 'CertificationInstitutions.twitter' => 'string', 'CertificationInstitutions__google' => 'string', 'CertificationInstitutions.google' => 'string', 'CertificationInstitutions__linkedin' => 'string', 'CertificationInstitutions.linkedin' => 'string', 'InspectionInstitutions__institution_country_id' => 'integer', 'InspectionInstitutions.institution_country_id' => 'integer', 'InspectionInstitutions__institution_accreditation_body_id' => 'integer', 'InspectionInstitutions.institution_accreditation_body_id' => 'integer', 'InspectionInstitutions__institution_type_id' => 'integer', 'InspectionInstitutions.institution_type_id' => 'integer', 'InspectionInstitutions__institution_group_id' => 'integer', 'InspectionInstitutions.institution_group_id' => 'integer', 'InspectionInstitutions__institution_legal_status_id' => 'integer', 'InspectionInstitutions.institution_legal_status_id' => 'integer', 'InspectionInstitutions__institution_economic_sector_id' => 'integer', 'InspectionInstitutions.institution_economic_sector_id' => 'integer', 'InspectionInstitutions__id' => 'integer', 'InspectionInstitutions.id' => 'integer', 'InspectionInstitutions__name' => 'string', 'InspectionInstitutions.name' => 'string', 'InspectionInstitutions__description' => 'text', 'InspectionInstitutions.description' => 'text', 'InspectionInstitutions__trademark' => 'string', 'InspectionInstitutions.trademark' => 'string', 'InspectionInstitutions__photo_path' => 'string', 'InspectionInstitutions.photo_path' => 'string', 'InspectionInstitutions__phone' => 'string', 'InspectionInstitutions.phone' => 'string', 'InspectionInstitutions__fax' => 'string', 'InspectionInstitutions.fax' => 'string', 'InspectionInstitutions__email' => 'string', 'InspectionInstitutions.email' => 'string', 'InspectionInstitutions__street' => 'string', 'InspectionInstitutions.street' => 'string', 'InspectionInstitutions__building' => 'string', 'InspectionInstitutions.building' => 'string', 'InspectionInstitutions__postal_code' => 'string', 'InspectionInstitutions.postal_code' => 'string', 'InspectionInstitutions__parish' => 'string', 'InspectionInstitutions.parish' => 'string', 'InspectionInstitutions__city' => 'string', 'InspectionInstitutions.city' => 'string', 'InspectionInstitutions__website' => 'string', 'InspectionInstitutions.website' => 'string', 'InspectionInstitutions__facebook' => 'string', 'InspectionInstitutions.facebook' => 'string', 'InspectionInstitutions__twitter' => 'string', 'InspectionInstitutions.twitter' => 'string', 'InspectionInstitutions__google' => 'string', 'InspectionInstitutions.google' => 'string', 'InspectionInstitutions__linkedin' => 'string', 'InspectionInstitutions.linkedin' => 'string', 'Countries__id' => 'integer', 'Countries.id' => 'integer', 'Countries__common_name' => 'string', 'Countries.common_name' => 'string', 'common_name' => 'string', 'Countries__group_name' => 'string', 'Countries.group_name' => 'string', 'group_name' => 'string', 'Countries__formal_name' => 'string', 'Countries.formal_name' => 'string', 'formal_name' => 'string', 'Countries__type' => 'string', 'Countries.type' => 'string', 'type' => 'string', 'Countries__sub_type' => 'string', 'Countries.sub_type' => 'string', 'sub_type' => 'string', 'Countries__sovereignty' => 'string', 'Countries.sovereignty' => 'string', 'sovereignty' => 'string', 'Countries__capital' => 'string', 'Countries.capital' => 'string', 'capital' => 'string', 'Countries__ISO_4217_currency_code' => 'string', 'Countries.ISO_4217_currency_code' => 'string', 'ISO_4217_currency_code' => 'string', 'Countries__ISO_4217_currency_name' => 'string', 'Countries.ISO_4217_currency_name' => 'string', 'ISO_4217_currency_name' => 'string', 'Countries__ITU_T_telephone_code' => 'string', 'Countries.ITU_T_telephone_code' => 'string', 'ITU_T_telephone_code' => 'string', 'Countries__ISO_31661_2_letter_code' => 'string', 'Countries.ISO_31661_2_letter_code' => 'string', 'ISO_31661_2_letter_code' => 'string', 'Countries__ISO_31661_3_letter_code' => 'string', 'Countries.ISO_31661_3_letter_code' => 'string', 'ISO_31661_3_letter_code' => 'string', 'Countries__ISO_31661_number' => 'string', 'Countries.ISO_31661_number' => 'string', 'ISO_31661_number' => 'string', 'Countries__IANA_country_code_TLD' => 'string', 'Countries.IANA_country_code_TLD' => 'string', 'IANA_country_code_TLD' => 'string', 'InstitutionCountries__id' => 'integer', 'InstitutionCountries.id' => 'integer', 'InstitutionCountries__name' => 'string', 'InstitutionCountries.name' => 'string' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Groups' => [], 'Roles' => [], 'MetrologyInstitutions' => [], 'ConformityAssessmentInstitutions' => [], 'AccreditationInstitutions' => [], 'CertificationInstitutions' => [], 'InspectionInstitutions' => [], 'Countries' => [ 'queryBuilder' => object(Closure) {} ], 'InstitutionCountries' => [] ], 'matching' => [], 'extraOptions' => [ 'scope' => null, 'whitelist' => [ (int) 0 => 'limit', (int) 1 => 'sort', (int) 2 => 'page', (int) 3 => 'direction' ] ], 'repository' => object(Cauth\Model\Table\UsersTable) { 'registryAlias' => 'Cauth.Users', 'table' => 'users', 'alias' => 'Users', 'entityClass' => 'Cauth\Model\Entity\User', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } }
|
|
return new $decorator($this->_results); |
|
} |
|
|
|
$statement = $this->eagerLoader()->loadExternal($this, $this->execute()); |
|
|
|
return new ResultSet($this, $statement); |
|
} |
|
|
No arguments
if ($this->_cache) { |
|
$results = $this->_cache->fetch($this); |
|
} |
|
if (!isset($results)) { |
|
$results = $this->_decorateResults($this->_execute()); |
|
if ($this->_cache) { |
|
$this->_cache->store($this, $results); |
|
} |
|
} |
No arguments
'You cannot call all() on a non-select query. Use execute() instead.' |
|
); |
|
} |
|
|
|
return $this->_all(); |
|
} |
|
|
|
/** |
|
* Trigger the beforeFind event on the query's repository object. |
No arguments
} else { |
|
$query->applyOptions($options); |
|
} |
|
|
|
$results = $query->all(); |
|
$numResults = count($results); |
|
$count = $numResults ? $query->count() : 0; |
|
|
|
$defaults = $this->getDefaults($alias, $settings); |
No arguments
throw new RuntimeException('Unable to locate an object compatible with paginate.'); |
|
} |
|
$settings = $settings + $this->paginate; |
|
|
|
return $this->Paginator->paginate($table, $settings); |
|
} |
|
|
|
/** |
|
* Method to check that an action is accessible from a URL. |
object(Cauth\Model\Table\UsersTable) { 'registryAlias' => 'Cauth.Users', 'table' => 'users', 'alias' => 'Users', 'entityClass' => 'Cauth\Model\Entity\User', 'associations' => [ (int) 0 => 'aro', (int) 1 => 'groups', (int) 2 => 'metrologyinstitutions', (int) 3 => 'accreditationinstitutions', (int) 4 => 'conformityassessmentinstitutions', (int) 5 => 'certificationinstitutions', (int) 6 => 'inspectioninstitutions', (int) 7 => 'roles', (int) 8 => 'parentusers', (int) 9 => 'countries', (int) 10 => 'institutioncountries', (int) 11 => 'childusers', (int) 12 => 'documents', (int) 13 => 'profiles' ], 'behaviors' => [ (int) 0 => 'Timestamp', (int) 1 => 'Acl' ], 'defaultConnection' => 'default', 'connectionName' => 'default' } [ 'conditions' => [ 'OR' => [ (int) 0 => [ 'Users.group_id' => (int) 2 ], (int) 1 => [ 'Users.group_id' => (int) 3 ], (int) 2 => [ 'Users.group_id' => (int) 4 ] ], 'Users.qi_professional' => (int) 1, 'Users.make_profile_public' => (int) 1, 'Users.verified' => (int) 1, 'Users.approved' => (int) 1 ], 'contain' => [ (int) 0 => 'Groups', (int) 1 => 'Roles', (int) 2 => 'MetrologyInstitutions', (int) 3 => 'ConformityAssessmentInstitutions', (int) 4 => 'AccreditationInstitutions', (int) 5 => 'CertificationInstitutions', (int) 6 => 'InspectionInstitutions', 'Countries' => object(Closure) { }, (int) 7 => 'InstitutionCountries' ], 'order' => [ 'last_name' => 'asc' ] ]
|
|
]; |
|
|
|
|
|
$users = $this->paginate($this->{$this->table}); |
|
|
|
//pr($users); |
|
|
|
$this->set(compact('users')); |
object(Cauth\Model\Table\UsersTable) { 'registryAlias' => 'Cauth.Users', 'table' => 'users', 'alias' => 'Users', 'entityClass' => 'Cauth\Model\Entity\User', 'associations' => [ (int) 0 => 'aro', (int) 1 => 'groups', (int) 2 => 'metrologyinstitutions', (int) 3 => 'accreditationinstitutions', (int) 4 => 'conformityassessmentinstitutions', (int) 5 => 'certificationinstitutions', (int) 6 => 'inspectioninstitutions', (int) 7 => 'roles', (int) 8 => 'parentusers', (int) 9 => 'countries', (int) 10 => 'institutioncountries', (int) 11 => 'childusers', (int) 12 => 'documents', (int) 13 => 'profiles' ], 'behaviors' => [ (int) 0 => 'Timestamp', (int) 1 => 'Acl' ], 'defaultConnection' => 'default', 'connectionName' => 'default' }
]); |
|
} |
|
$callable = [$this, $request->params['action']]; |
|
|
|
return call_user_func_array($callable, $request->params['pass']); |
|
} |
|
|
|
/** |
|
* Merge components, helpers vars from |
[ (int) 0 => object(Cauth\Controller\UsersController) { name => 'Users' paginate => [ 'conditions' => [ [maximum depth reached] ], 'contain' => [ [maximum depth reached] ], 'order' => [ [maximum depth reached] ] ] components => [ 'Acl' => [ [maximum depth reached] ] ] helpers => [] request => object(Cake\Network\Request) {} response => object(Cake\Network\Response) {} autoRender => true View => null plugin => 'Cauth' passedArgs => [] modelClass => 'Cauth.Users' viewClass => null viewVars => [ 'notes' => object(Cake\ORM\Query) {}, 'site_settings' => object(ContentManager\Model\Entity\SiteSetting) {}, 'action' => false, 'plural_title' => 'Users', 'singular_title' => 'User', 'table' => 'Users', 'entity' => 'User', 'model' => 'User', 'controller' => 'users', 'captcha' => object(App\Controller\Component\Securimage) {} ] RequestHandler => object(Cake\Controller\Component\RequestHandlerComponent) {} Flash => object(Cake\Controller\Component\FlashComponent) {} Auth => object(Cake\Controller\Component\AuthComponent) {} Security => object(Cake\Controller\Component\SecurityComponent) {} Paginator => object(Cake\Controller\Component\PaginatorComponent) {} captcha => object(App\Controller\Component\Securimage) {} Captcha => object(App\Controller\Component\CaptchaComponent) {} Acl => object(Acl\Controller\Component\AclComponent) {} controller => 'users' model => 'User' entity => 'User' table => 'Users' singular_title => 'User' plural_title => 'Users' SiteSettings => object(ContentManager\Model\Table\SiteSettingsTable) {} site_settings => object(ContentManager\Model\Entity\SiteSetting) {} Notes => object(Help\Model\Table\NotesTable) {} Users => object(Cauth\Model\Table\UsersTable) {} [protected] _responseClass => 'Cake\Network\Response' [protected] _components => object(Cake\Controller\ComponentRegistry) {} [protected] _validViewOptions => [ (int) 0 => 'passedArgs' ] [protected] _eventManager => object(Cake\Event\EventManager) {} [protected] _eventClass => '\Cake\Event\Event' [protected] _tableLocator => object(Cake\ORM\Locator\TableLocator) {} [protected] _modelFactories => [ 'Table' => [ [maximum depth reached] ] ] [protected] _modelType => 'Table' [protected] _viewBuilder => object(Cake\View\ViewBuilder) {} }, (int) 1 => 'professionals' ] []
if ($result instanceof Response) { |
|
return $result; |
|
} |
|
|
|
$response = $controller->invokeAction(); |
|
if ($response !== null && !($response instanceof Response)) { |
|
throw new LogicException('Controller actions can only return Cake\Network\Response or null.'); |
|
} |
|
|
No arguments
} else { |
|
$controller = $this->factory->create($request, $response); |
|
} |
|
|
|
$response = $this->_invoke($controller); |
|
if (isset($request->params['return'])) { |
|
return $response; |
|
} |
|
|
object(Cauth\Controller\UsersController) { name => 'Users' paginate => [ 'conditions' => [ 'OR' => [ [maximum depth reached] ], 'Users.qi_professional' => (int) 1, 'Users.make_profile_public' => (int) 1, 'Users.verified' => (int) 1, 'Users.approved' => (int) 1 ], 'contain' => [ (int) 0 => 'Groups', (int) 1 => 'Roles', (int) 2 => 'MetrologyInstitutions', (int) 3 => 'ConformityAssessmentInstitutions', (int) 4 => 'AccreditationInstitutions', (int) 5 => 'CertificationInstitutions', (int) 6 => 'InspectionInstitutions', 'Countries' => object(Closure) {}, (int) 7 => 'InstitutionCountries' ], 'order' => [ 'last_name' => 'asc' ] ] components => [ 'Acl' => [ 'className' => 'Acl.Acl' ] ] helpers => [] request => object(Cake\Network\Request) { params => [ [maximum depth reached] ] data => [[maximum depth reached]] query => [ [maximum depth reached] ] cookies => [[maximum depth reached]] url => 'cauth/users/professionals' base => '' webroot => '/' here => '/cauth/users/professionals' trustProxy => false [protected] _environment => [ [maximum depth reached] ] [protected] _detectors => [ [maximum depth reached] ] [protected] _detectorCache => [ [maximum depth reached] ] [protected] _input => '' [protected] _session => object(Cake\Network\Session) {} } response => object(Cake\Network\Response) { [protected] _statusCodes => [ [maximum depth reached] ] [protected] _mimeTypes => [ [maximum depth reached] ] [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => [[maximum depth reached]] [protected] _body => '' [protected] _file => null [protected] _fileRange => [[maximum depth reached]] [protected] _charset => 'UTF-8' [protected] _cacheDirectives => [[maximum depth reached]] [protected] _cookies => [[maximum depth reached]] } autoRender => true View => null plugin => 'Cauth' passedArgs => [] modelClass => 'Cauth.Users' viewClass => null viewVars => [ 'notes' => object(Cake\ORM\Query) {}, 'site_settings' => object(ContentManager\Model\Entity\SiteSetting) {}, 'action' => false, 'plural_title' => 'Users', 'singular_title' => 'User', 'table' => 'Users', 'entity' => 'User', 'model' => 'User', 'controller' => 'users', 'captcha' => object(App\Controller\Component\Securimage) {} ] RequestHandler => object(Cake\Controller\Component\RequestHandlerComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Flash => object(Cake\Controller\Component\FlashComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } Auth => object(Cake\Controller\Component\AuthComponent) { 'components' => [ [maximum depth reached] ], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Security => object(Cake\Controller\Component\SecurityComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [ [maximum depth reached] ], '_config' => [ [maximum depth reached] ] } Paginator => object(Cake\Controller\Component\PaginatorComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } captcha => object(App\Controller\Component\Securimage) { image_width => (int) 350 image_height => (int) 75 image_type => (int) 2 code_length => (int) 5 charset => 'ABCDEFGHKLMNPRSTUVWYZ23456789' wordlist_file => '/home/crosqvps/public_html/_database/vendor/securimage/words/words.txt' use_wordlist => true use_gd_font => false gd_font_file => '/home/crosqvps/public_html/_database/vendor/securimage/gdfonts/bubblebath.gdf' gd_font_size => (int) 50 ttf_file => '/home/crosqvps/public_html/_database/vendor/securimage/elephant.ttf' font_size => (int) 45 text_angle_minimum => (int) -21 text_angle_maximum => (int) 21 text_x_start => (int) 10 text_minimum_distance => (int) 68 text_maximum_distance => (int) 70 image_bg_color => '#ffffff' text_color => '#000000' use_multi_text => true multi_text_color => '#006699,#666666,#333333' use_transparent_text => true text_transparency_percentage => (int) 45 draw_lines => true line_color => '#cccccc' line_distance => (int) 15 line_thickness => (int) 2 draw_angled_lines => true draw_lines_over_text => false arc_linethrough => true arc_line_colors => '#999999,#cccccc' audio_path => '/home/crosqvps/public_html/_database/vendor/securimage/audio/' im => null bgimg => null code => null code_entered => null correct_code => null session => object(Cake\Network\Session) {} use_word_list => false } Captcha => object(App\Controller\Component\CaptchaComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [[maximum depth reached]] } Acl => object(Acl\Controller\Component\AclComponent) { 'components' => [[maximum depth reached]], 'implementedEvents' => [[maximum depth reached]], '_config' => [ [maximum depth reached] ] } controller => 'users' model => 'User' entity => 'User' table => 'Users' singular_title => 'User' plural_title => 'Users' SiteSettings => object(ContentManager\Model\Table\SiteSettingsTable) { 'registryAlias' => 'ContentManager.SiteSettings', 'table' => 'site_settings', 'alias' => 'SiteSettings', 'entityClass' => 'ContentManager\Model\Entity\SiteSetting', 'associations' => [[maximum depth reached]], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } site_settings => object(ContentManager\Model\Entity\SiteSetting) { 'id' => (int) 1, 'background_image_path' => 'files/siteSettings/images/default-placeholder(3).png', 'background_color' => '#E5E9EC', 'website_name' => 'CROSQ Quality Infrastructure Database', 'welcome_message' => null, 'tagline' => '', 'meta_description' => null, 'meta_keywords' => null, 'welcome_message_title' => 'About the CROSQ Quality Infrastructure Database', 'welcome_message_body' => '<p>The CROSQ Quality Infrastructure Database provides a central location for businesses, manufacturers, testing laboratories, metrology institutions, quality professionals and accreditation bodies to find services and other industry participants. You can start by using the search tool above. Choose your search type then select your criteria to see a list of results.</p>', 'allow_new_user_login' => true, 'featured_video_id' => null, 'featured_image_id' => null, 'client_id' => null, 'facebook_url' => 'https://www.facebook.com/crosq.caricom', 'twitter_url' => 'https://twitter.com/crosqcaricom', 'youtube_url' => 'https://www.linkedin.com/company/caricom-regional-organisation-for-standards-and-quality', 'google_plus_url' => 'https://plus.google.com/+CrosqOrg', 'copyright' => null, 'notification_email' => 'crosq.caricom@crosq.org', 'developer_email' => 'dwayne.clarke@crosq.org', 'contact_form_email' => 'crosq.caricom@crosq.org', 'phone_1' => '1 246 622 7670', 'phone_2' => '1 246 622 7677', 'mobile' => '', 'fax' => '1 246 622 7678', 'email_address_1' => 'crosq.caricom@crosq.org', 'email_address_2' => '', 'address_line_1' => '2nd Floor Baobab Towers', 'address_line_2' => 'Warrens', 'city' => 'Bridgetown', 'state_province' => 'St Michael', 'country' => 'Barbados ', 'zip_postal_code' => 'BB22026', 'region' => '', 'main_logo_path' => 'files/siteSettings/images/crosq-logo(1).png', 'main_logo_database_path' => 'files/siteSettings/images/cq.png', 'main_logo_mobile_path' => 'files/siteSettings/images/eccb_logo_o.png', 'dummy_content' => (int) 1, 'welcome_message_other' => '<p>Register with the CROSQ QI Database.</p>', 'welcome_message_other_title' => 'User Registration', 'top_block_1_title' => 'No. of Labs', 'top_block_1_other' => 'And counting...', 'top_block_2_title' => 'No. of Professionals', 'top_block_2_other' => 'And counting...', 'top_block_3_title' => 'No. of Certification Bodies', 'top_block_3_other' => 'And counting...', 'top_block_4_title' => 'No. of NMIs', 'top_block_4_other' => 'And counting...', 'top_block_5_title' => 'No. of Inspection Bodies', 'top_block_5_other' => 'And counting...', 'center_block_pic_1_path' => 'files/siteSettings/images/factory-1.png', 'center_block_details_1' => '<p>Assist Accreditation Bodies to identify the capacity they need to develop and assess services for accreditation such as proficiency testing and training. It will also allow stakeholders to identify opportunities for partnerships or funding.</p>', 'center_block_pic_2_path' => 'files/siteSettings/images/three-test-tubes.png', 'center_block_details_2' => '<p>Promote the scope of services provided and identify opportunities where capacity development can be undertaken such as the development of inter-laboratory comparison programmes for laboratories performing similar tests.</p>', 'center_block_pic_3_path' => 'files/siteSettings/images/settings.png', 'center_block_details_3' => '<p>Provide information about their status of metrological traceability and international recognition and identify other institutions within CARIFORUM who can be referred to if capability does not exist nationally or for consultation.</p>', 'center_block_title_1' => 'For Accreditation Bodies', 'center_block_title_2' => 'For Testing Laboratories', 'center_block_title_3' => 'For Metrology Institutions', 'center_block_title_4' => 'Manufacturers', 'center_block_details_4' => '<p>Find information on NMIs and Testing Laboratories and their capability to calibrate or test your instruments or materials. Also, get information about which services are accredited and recognised.</p>', 'center_block_title_5' => 'QI Professionals', 'center_block_details_5' => '<p>Provides a way for professionals to promote their services as well as provide stakeholders direct access to the QI professionals; allowing for opportunities for training, research and project development.</p>', 'center_block_title_6' => 'Consumers', 'center_block_details_6' => '<p>Quickly access information about the range of health related tests which can be performed by various testing laboratories in the region and subscribe to updates about the development of QI and related news.</p>', 'center_block_title_7' => 'Certification Bodies', 'center_block_details_7' => '<p>Provides information on certification services available in the CARICOMregion. This further highlights the measure of the Quality Infrastructure (QI) competence withing the named region. </p>', 'center_block_pic_7_path' => 'files/siteSettings/images/certification.png', 'center_block_title_8' => 'Inspection Bodies', 'center_block_details_8' => '<p>Demonstration of accredited inspection competence and scope available in the CARICOM region.</p>', 'center_block_pic_8_path' => 'files/siteSettings/images/inspection.png', 'dashboad_title' => 'CROSQ QI Database', 'dashboad_sub_title' => 'Welcome... Get Started', 'account_verified_tooltip' => null, 'cal_cost_tooltip' => null, 'cal_turnaround_time_tooltip' => null, 'lab_test_cost_tooltip' => null, 'lab_test_turnaround_time_tooltip' => null, 'professional_profile_verified' => 'Verified', 'professional_profile_verified_info' => 'Account verified by CROSQ', '[new]' => false, '[accessible]' => [ [maximum depth reached] ], '[dirty]' => [[maximum depth reached]], '[original]' => [[maximum depth reached]], '[virtual]' => [[maximum depth reached]], '[errors]' => [[maximum depth reached]], '[invalid]' => [[maximum depth reached]], '[repository]' => 'ContentManager.SiteSettings' } Notes => object(Help\Model\Table\NotesTable) { 'registryAlias' => 'Help.Notes', 'table' => 'help_notes', 'alias' => 'Notes', 'entityClass' => 'Help\Model\Entity\Note', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } Users => object(Cauth\Model\Table\UsersTable) { 'registryAlias' => 'Cauth.Users', 'table' => 'users', 'alias' => 'Users', 'entityClass' => 'Cauth\Model\Entity\User', 'associations' => [ [maximum depth reached] ], 'behaviors' => [ [maximum depth reached] ], 'defaultConnection' => 'default', 'connectionName' => 'default' } [protected] _responseClass => 'Cake\Network\Response' [protected] _components => object(Cake\Controller\ComponentRegistry) { '_Controller' => object(Cauth\Controller\UsersController) {}, '_loaded' => [ [maximum depth reached] ], '_eventManager' => object(Cake\Event\EventManager) {}, '_eventClass' => '\Cake\Event\Event' } [protected] _validViewOptions => [ (int) 0 => 'passedArgs' ] [protected] _eventManager => object(Cake\Event\EventManager) { '_listeners' => [ [maximum depth reached] ], '_isGlobal' => false, '_eventList' => null, '_trackEvents' => false, '_generalManager' => '(object) EventManager' } [protected] _eventClass => '\Cake\Event\Event' [protected] _tableLocator => object(Cake\ORM\Locator\TableLocator) { [protected] _config => [[maximum depth reached]] [protected] _instances => [ [maximum depth reached] ] [protected] _fallbacked => [[maximum depth reached]] [protected] _options => [ [maximum depth reached] ] } [protected] _modelFactories => [ 'Table' => [ (int) 0 => object(Cake\ORM\Locator\TableLocator) {}, (int) 1 => 'get' ] ] [protected] _modelType => 'Table' [protected] _viewBuilder => object(Cake\View\ViewBuilder) { [protected] _templatePath => null [protected] _template => null [protected] _plugin => null [protected] _theme => 'Main' [protected] _layout => 'default' [protected] _autoLayout => null [protected] _layoutPath => null [protected] _name => null [protected] _className => 'Main.App' [protected] _options => [[maximum depth reached]] [protected] _helpers => [[maximum depth reached]] } }
$cakeRequest = RequestTransformer::toCake($request); |
|
$cakeResponse = ResponseTransformer::toCake($response); |
|
|
|
// Dispatch the request/response to CakePHP |
|
$cakeResponse = $this->getDispatcher()->dispatch($cakeRequest, $cakeResponse); |
|
|
|
// Convert the response back into a PSR7 object. |
|
return ResponseTransformer::toPsr($cakeResponse); |
|
} |
object(Cake\Network\Request) { params => [ 'controller' => 'Users', 'action' => 'professionals', 'pass' => [], 'plugin' => 'Cauth', '_matchedRoute' => '/cauth/:controller/:action/*', '_ext' => null, 'isAjax' => false, '_Token' => [ 'unlockedFields' => [[maximum depth reached]] ] ] data => [] query => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] cookies => [] url => 'cauth/users/professionals' base => '' webroot => '/' here => '/cauth/users/professionals' trustProxy => false [protected] _environment => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2, 'HTTP_X_HTTP_METHOD_OVERRIDE' => null, 'ORIGINAL_REQUEST_METHOD' => 'GET', 'HTTP_X_REQUESTED_WITH' => null, 'HTTP_IF_NONE_MATCH' => null, 'HTTP_IF_MODIFIED_SINCE' => null ] [protected] _detectors => [ 'get' => [ 'env' => 'REQUEST_METHOD', 'value' => 'GET' ], 'post' => [ 'env' => 'REQUEST_METHOD', 'value' => 'POST' ], 'put' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PUT' ], 'patch' => [ 'env' => 'REQUEST_METHOD', 'value' => 'PATCH' ], 'delete' => [ 'env' => 'REQUEST_METHOD', 'value' => 'DELETE' ], 'head' => [ 'env' => 'REQUEST_METHOD', 'value' => 'HEAD' ], 'options' => [ 'env' => 'REQUEST_METHOD', 'value' => 'OPTIONS' ], 'ssl' => [ 'env' => 'HTTPS', 'options' => [ [maximum depth reached] ] ], 'ajax' => [ 'env' => 'HTTP_X_REQUESTED_WITH', 'value' => 'XMLHttpRequest' ], 'flash' => [ 'env' => 'HTTP_USER_AGENT', 'pattern' => '/^(Shockwave|Adobe) Flash/' ], 'requested' => [ 'param' => 'requested', 'value' => (int) 1 ], 'json' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'json' ], 'xml' => [ 'accept' => [ [maximum depth reached] ], 'param' => '_ext', 'value' => 'xml' ], 'mobile' => object(Closure) {}, 'tablet' => object(Closure) {} ] [protected] _detectorCache => [ 'ajax' => false, 'get' => true, 'head' => false, 'options' => false ] [protected] _input => '' [protected] _session => object(Cake\Network\Session) { [protected] _engine => null [protected] _started => true [protected] _lifetime => '28800' [protected] _isCLI => false } } object(Cake\Network\Response) { [protected] _statusCodes => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Timeout', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Timeout', (int) 505 => 'Unsupported Version', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [protected] _mimeTypes => [ 'html' => [ (int) 0 => 'text/html', (int) 1 => '*/*' ], 'json' => 'application/json', 'xml' => [ (int) 0 => 'application/xml', (int) 1 => 'text/xml' ], 'xhtml' => [ (int) 0 => 'application/xhtml+xml', (int) 1 => 'application/xhtml', (int) 2 => 'text/xhtml' ], 'webp' => 'image/webp', 'rss' => 'application/rss+xml', 'ai' => 'application/postscript', 'bcpio' => 'application/x-bcpio', 'bin' => 'application/octet-stream', 'ccad' => 'application/clariscad', 'cdf' => 'application/x-netcdf', 'class' => 'application/octet-stream', 'cpio' => 'application/x-cpio', 'cpt' => 'application/mac-compactpro', 'csh' => 'application/x-csh', 'csv' => [ (int) 0 => 'text/csv', (int) 1 => 'application/vnd.ms-excel' ], 'dcr' => 'application/x-director', 'dir' => 'application/x-director', 'dms' => 'application/octet-stream', 'doc' => 'application/msword', 'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'drw' => 'application/drafting', 'dvi' => 'application/x-dvi', 'dwg' => 'application/acad', 'dxf' => 'application/dxf', 'dxr' => 'application/x-director', 'eot' => 'application/vnd.ms-fontobject', 'eps' => 'application/postscript', 'exe' => 'application/octet-stream', 'ez' => 'application/andrew-inset', 'flv' => 'video/x-flv', 'gtar' => 'application/x-gtar', 'gz' => 'application/x-gzip', 'bz2' => 'application/x-bzip', '7z' => 'application/x-7z-compressed', 'hdf' => 'application/x-hdf', 'hqx' => 'application/mac-binhex40', 'ico' => 'image/x-icon', 'ips' => 'application/x-ipscript', 'ipx' => 'application/x-ipix', 'js' => 'application/javascript', 'jsonapi' => 'application/vnd.api+json', 'latex' => 'application/x-latex', 'lha' => 'application/octet-stream', 'lsp' => 'application/x-lisp', 'lzh' => 'application/octet-stream', 'man' => 'application/x-troff-man', 'me' => 'application/x-troff-me', 'mif' => 'application/vnd.mif', 'ms' => 'application/x-troff-ms', 'nc' => 'application/x-netcdf', 'oda' => 'application/oda', 'otf' => 'font/otf', 'pdf' => 'application/pdf', 'pgn' => 'application/x-chess-pgn', 'pot' => 'application/vnd.ms-powerpoint', 'pps' => 'application/vnd.ms-powerpoint', 'ppt' => 'application/vnd.ms-powerpoint', 'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'ppz' => 'application/vnd.ms-powerpoint', 'pre' => 'application/x-freelance', 'prt' => 'application/pro_eng', 'ps' => 'application/postscript', 'roff' => 'application/x-troff', 'scm' => 'application/x-lotusscreencam', 'set' => 'application/set', 'sh' => 'application/x-sh', 'shar' => 'application/x-shar', 'sit' => 'application/x-stuffit', 'skd' => 'application/x-koan', 'skm' => 'application/x-koan', 'skp' => 'application/x-koan', 'skt' => 'application/x-koan', 'smi' => 'application/smil', 'smil' => 'application/smil', 'sol' => 'application/solids', 'spl' => 'application/x-futuresplash', 'src' => 'application/x-wais-source', 'step' => 'application/STEP', 'stl' => 'application/SLA', 'stp' => 'application/STEP', 'sv4cpio' => 'application/x-sv4cpio', 'sv4crc' => 'application/x-sv4crc', 'svg' => 'image/svg+xml', 'svgz' => 'image/svg+xml', 'swf' => 'application/x-shockwave-flash', 't' => 'application/x-troff', 'tar' => 'application/x-tar', 'tcl' => 'application/x-tcl', 'tex' => 'application/x-tex', 'texi' => 'application/x-texinfo', 'texinfo' => 'application/x-texinfo', 'tr' => 'application/x-troff', 'tsp' => 'application/dsptype', 'ttc' => 'font/ttf', 'ttf' => 'font/ttf', 'unv' => 'application/i-deas', 'ustar' => 'application/x-ustar', 'vcd' => 'application/x-cdlink', 'vda' => 'application/vda', 'xlc' => 'application/vnd.ms-excel', 'xll' => 'application/vnd.ms-excel', 'xlm' => 'application/vnd.ms-excel', 'xls' => 'application/vnd.ms-excel', 'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'xlw' => 'application/vnd.ms-excel', 'zip' => 'application/zip', 'aif' => 'audio/x-aiff', 'aifc' => 'audio/x-aiff', 'aiff' => 'audio/x-aiff', 'au' => 'audio/basic', 'kar' => 'audio/midi', 'mid' => 'audio/midi', 'midi' => 'audio/midi', 'mp2' => 'audio/mpeg', 'mp3' => 'audio/mpeg', 'mpga' => 'audio/mpeg', 'ogg' => 'audio/ogg', 'oga' => 'audio/ogg', 'spx' => 'audio/ogg', 'ra' => 'audio/x-realaudio', 'ram' => 'audio/x-pn-realaudio', 'rm' => 'audio/x-pn-realaudio', 'rpm' => 'audio/x-pn-realaudio-plugin', 'snd' => 'audio/basic', 'tsi' => 'audio/TSP-audio', 'wav' => 'audio/x-wav', 'aac' => 'audio/aac', 'asc' => 'text/plain', 'c' => 'text/plain', 'cc' => 'text/plain', 'css' => 'text/css', 'etx' => 'text/x-setext', 'f' => 'text/plain', 'f90' => 'text/plain', 'h' => 'text/plain', 'hh' => 'text/plain', 'htm' => [ (int) 0 => 'text/html', (int) 1 => '*/*' ], 'ics' => 'text/calendar', 'm' => 'text/plain', 'rtf' => 'text/rtf', 'rtx' => 'text/richtext', 'sgm' => 'text/sgml', 'sgml' => 'text/sgml', 'tsv' => 'text/tab-separated-values', 'tpl' => 'text/template', 'txt' => 'text/plain', 'text' => 'text/plain', 'avi' => 'video/x-msvideo', 'fli' => 'video/x-fli', 'mov' => 'video/quicktime', 'movie' => 'video/x-sgi-movie', 'mpe' => 'video/mpeg', 'mpeg' => 'video/mpeg', 'mpg' => 'video/mpeg', 'qt' => 'video/quicktime', 'viv' => 'video/vnd.vivo', 'vivo' => 'video/vnd.vivo', 'ogv' => 'video/ogg', 'webm' => 'video/webm', 'mp4' => 'video/mp4', 'm4v' => 'video/mp4', 'f4v' => 'video/mp4', 'f4p' => 'video/mp4', 'm4a' => 'audio/mp4', 'f4a' => 'audio/mp4', 'f4b' => 'audio/mp4', 'gif' => 'image/gif', 'ief' => 'image/ief', 'jpg' => 'image/jpeg', 'jpeg' => 'image/jpeg', 'jpe' => 'image/jpeg', 'pbm' => 'image/x-portable-bitmap', 'pgm' => 'image/x-portable-graymap', 'png' => 'image/png', 'pnm' => 'image/x-portable-anymap', 'ppm' => 'image/x-portable-pixmap', 'ras' => 'image/cmu-raster', 'rgb' => 'image/x-rgb', 'tif' => 'image/tiff', 'tiff' => 'image/tiff', 'xbm' => 'image/x-xbitmap', 'xpm' => 'image/x-xpixmap', 'xwd' => 'image/x-xwindowdump', 'psd' => [ (int) 0 => 'application/photoshop', (int) 1 => 'application/psd', (int) 2 => 'image/psd', (int) 3 => 'image/x-photoshop', (int) 4 => 'image/photoshop', (int) 5 => 'zz-application/zz-winassoc-psd' ], 'ice' => 'x-conference/x-cooltalk', 'iges' => 'model/iges', 'igs' => 'model/iges', 'mesh' => 'model/mesh', 'msh' => 'model/mesh', 'silo' => 'model/mesh', 'vrml' => 'model/vrml', 'wrl' => 'model/vrml', 'mime' => 'www/mime', 'pdb' => 'chemical/x-pdb', 'xyz' => 'chemical/x-pdb', 'javascript' => 'application/javascript', 'form' => 'application/x-www-form-urlencoded', 'file' => 'multipart/form-data', 'xhtml-mobile' => 'application/vnd.wap.xhtml+xml', 'atom' => 'application/atom+xml', 'amf' => 'application/x-amf', 'wap' => [ (int) 0 => 'text/vnd.wap.wml', (int) 1 => 'text/vnd.wap.wmlscript', (int) 2 => 'image/vnd.wap.wbmp' ], 'wml' => 'text/vnd.wap.wml', 'wmlscript' => 'text/vnd.wap.wmlscript', 'wbmp' => 'image/vnd.wap.wbmp', 'woff' => 'application/x-font-woff', 'appcache' => 'text/cache-manifest', 'manifest' => 'text/cache-manifest', 'htc' => 'text/x-component', 'rdf' => 'application/xml', 'crx' => 'application/x-chrome-extension', 'oex' => 'application/x-opera-extension', 'xpi' => 'application/x-xpinstall', 'safariextz' => 'application/octet-stream', 'webapp' => 'application/x-web-app-manifest+json', 'vcf' => 'text/x-vcard', 'vtt' => 'text/vtt', 'mkv' => 'video/x-matroska', 'pkpass' => 'application/vnd.apple.pkpass', 'ajax' => 'text/html' ] [protected] _protocol => 'HTTP/1.1' [protected] _status => (int) 200 [protected] _contentType => 'text/html' [protected] _headers => [] [protected] _body => '' [protected] _file => null [protected] _fileRange => [] [protected] _charset => 'UTF-8' [protected] _cacheDirectives => [] [protected] _cookies => [] }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {}, 'params' => [ 'controller' => 'Users', 'action' => 'professionals', 'pass' => [[maximum depth reached]], 'plugin' => 'Cauth', '_matchedRoute' => '/cauth/:controller/:action/*' ] ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
$response->getHeaders() |
|
); |
|
} |
|
|
|
return $next($request, $response); |
|
} |
|
} |
|
|
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {}, 'params' => [ 'controller' => 'Users', 'action' => 'professionals', 'pass' => [[maximum depth reached]], 'plugin' => 'Cauth', '_matchedRoute' => '/cauth/:controller/:action/*' ] ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {}, 'params' => [ 'controller' => 'Users', 'action' => 'professionals', 'pass' => [[maximum depth reached]], 'plugin' => 'Cauth', '_matchedRoute' => '/cauth/:controller/:action/*' ] ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
public function __invoke($request, $response, $next) |
|
{ |
|
$url = $request->getUri()->getPath(); |
|
if (strpos($url, '..') !== false || strpos($url, '.') === false) { |
|
return $next($request, $response); |
|
} |
|
|
|
$assetFile = $this->_getAssetFile($url); |
|
if ($assetFile === null || !file_exists($assetFile)) { |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {} ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {} ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
*/ |
|
public function __invoke($request, $response, $next) |
|
{ |
|
try { |
|
return $next($request, $response); |
|
} catch (\Exception $e) { |
|
return $this->handleException($e, $request, $response); |
|
} |
|
} |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {} ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } }
$next = $this->middleware->get($this->index); |
|
if ($next) { |
|
$this->index++; |
|
|
|
return $next($request, $response, $this); |
|
} |
|
|
|
// End of the queue |
|
return $response; |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {} ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } } object(Cake\Http\Runner) { [protected] index => (int) 4 [protected] middleware => object(Cake\Http\MiddlewareQueue) { [protected] queue => [ [maximum depth reached] ] [protected] callables => [ [maximum depth reached] ] } }
{ |
|
$this->middleware = $middleware; |
|
$this->index = 0; |
|
|
|
return $this->__invoke($request, $response); |
|
} |
|
|
|
/** |
|
* @param \Psr\Http\Message\ServerRequestInterface $request The server request |
object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {} ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } }
throw new RuntimeException('The application `middleware` method did not return a middleware queue.'); |
|
} |
|
$this->dispatchEvent('Server.buildMiddleware', ['middleware' => $middleware]); |
|
$middleware->add($this->app); |
|
$response = $this->runner->run($middleware, $request, $response); |
|
|
|
if (!($response instanceof ResponseInterface)) { |
|
throw new RuntimeException(sprintf( |
|
'Application did not create a response. Got "%s" instead.', |
object(Cake\Http\MiddlewareQueue) { [protected] queue => [ (int) 0 => object(Cake\Error\Middleware\ErrorHandlerMiddleware) {}, (int) 1 => object(Cake\Routing\Middleware\AssetMiddleware) {}, (int) 2 => object(Cake\Routing\Middleware\RoutingMiddleware) {}, (int) 3 => object(App\Application) {} ] [protected] callables => [ (int) 0 => object(Cake\Error\Middleware\ErrorHandlerMiddleware) {}, (int) 1 => object(Cake\Routing\Middleware\AssetMiddleware) {}, (int) 2 => object(Cake\Routing\Middleware\RoutingMiddleware) {}, (int) 3 => object(App\Application) {} ] } object(Zend\Diactoros\ServerRequest) { [protected] headers => [ 'accept' => [ (int) 0 => '*/*' ], 'user-agent' => [ (int) 0 => 'claudebot' ], 'host' => [ (int) 0 => 'database.crosq.org' ] ] [protected] headerNames => [ 'accept' => 'accept', 'user-agent' => 'user-agent', 'host' => 'host' ] [private] attributes => [ 'base' => '', 'webroot' => '/', 'session' => object(Cake\Network\Session) {} ] [private] cookieParams => [] [private] parsedBody => [] [private] queryParams => [ 'page' => '2', 'sort' => '0', 'direction' => 'last_name asc' ] [private] serverParams => [ 'TZ' => 'America/Barbados', 'REDIRECT_REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_REDIRECT_HTTPS' => 'on', 'REDIRECT_REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'database.crosq.org', 'REDIRECT_HANDLER' => 'application/x-httpd-ea-php71', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'ZgWzEtenRQsHkZx-MCo3FwAAAAg', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'database.crosq.org', 'HTTP_ACCEPT' => '*/*', 'HTTP_USER_AGENT' => 'claudebot', 'HTTP_HOST' => 'database.crosq.org', 'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'database.crosq.org', 'SERVER_ADDR' => '132.148.84.44', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.88.16.192', 'DOCUMENT_ROOT' => '/home/crosqvps/public_html/_database', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '/cgi-sys', 'CONTEXT_DOCUMENT_ROOT' => '/usr/local/cpanel/cgi-sys/', 'SERVER_ADMIN' => 'webmaster@database.crosq.org', 'SCRIPT_FILENAME' => '/home/crosqvps/public_html/_database/webroot/index.php', 'REMOTE_PORT' => '47466', 'REDIRECT_URL' => '/webroot/index.php', 'REDIRECT_QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => 'page=2&sort=0&direction=last_name+asc', 'REQUEST_URI' => '/cauth/users/professionals?page=2&sort=0&direction=last_name+asc', 'SCRIPT_NAME' => '/webroot/index.php', 'ORIG_SCRIPT_FILENAME' => '/usr/local/cpanel/cgi-sys/ea-php71', 'ORIG_PATH_INFO' => '/webroot/index.php', 'ORIG_PATH_TRANSLATED' => '/home/crosqvps/public_html/_database/webroot/index.php', 'ORIG_SCRIPT_NAME' => '/cgi-sys/ea-php71', 'PHP_SELF' => '/webroot/index.php', 'REQUEST_TIME_FLOAT' => (float) 1711649554.7678, 'REQUEST_TIME' => (int) 1711649554, 'argv' => [ (int) 0 => 'page=2&sort=0&direction=last_name', (int) 1 => 'asc' ], 'argc' => (int) 2 ] [private] uploadedFiles => [] [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\PhpInputStream) { [protected] resource => resource [protected] stream => 'php://input' [private] cache => '' [private] reachedEof => true } [private] method => 'GET' [private] requestTarget => null [private] uri => object(Zend\Diactoros\Uri) { [protected] allowedSchemes => [ [maximum depth reached] ] [private] scheme => 'https' [private] userInfo => '' [private] host => 'database.crosq.org' [private] port => null [private] path => '/cauth/users/professionals' [private] query => 'page=2&sort=0&direction=last_name+asc' [private] fragment => '' [private] uriString => null } } object(Zend\Diactoros\Response) { [protected] headers => [] [protected] headerNames => [] [private] phrases => [ (int) 100 => 'Continue', (int) 101 => 'Switching Protocols', (int) 102 => 'Processing', (int) 200 => 'OK', (int) 201 => 'Created', (int) 202 => 'Accepted', (int) 203 => 'Non-Authoritative Information', (int) 204 => 'No Content', (int) 205 => 'Reset Content', (int) 206 => 'Partial Content', (int) 207 => 'Multi-status', (int) 208 => 'Already Reported', (int) 226 => 'IM used', (int) 300 => 'Multiple Choices', (int) 301 => 'Moved Permanently', (int) 302 => 'Found', (int) 303 => 'See Other', (int) 304 => 'Not Modified', (int) 305 => 'Use Proxy', (int) 306 => 'Switch Proxy', (int) 307 => 'Temporary Redirect', (int) 308 => 'Permanent Redirect', (int) 400 => 'Bad Request', (int) 401 => 'Unauthorized', (int) 402 => 'Payment Required', (int) 403 => 'Forbidden', (int) 404 => 'Not Found', (int) 405 => 'Method Not Allowed', (int) 406 => 'Not Acceptable', (int) 407 => 'Proxy Authentication Required', (int) 408 => 'Request Time-out', (int) 409 => 'Conflict', (int) 410 => 'Gone', (int) 411 => 'Length Required', (int) 412 => 'Precondition Failed', (int) 413 => 'Request Entity Too Large', (int) 414 => 'Request-URI Too Large', (int) 415 => 'Unsupported Media Type', (int) 416 => 'Requested range not satisfiable', (int) 417 => 'Expectation Failed', (int) 418 => 'I'm a teapot', (int) 421 => 'Misdirected Request', (int) 422 => 'Unprocessable Entity', (int) 423 => 'Locked', (int) 424 => 'Failed Dependency', (int) 425 => 'Unordered Collection', (int) 426 => 'Upgrade Required', (int) 428 => 'Precondition Required', (int) 429 => 'Too Many Requests', (int) 431 => 'Request Header Fields Too Large', (int) 444 => 'Connection Closed Without Response', (int) 451 => 'Unavailable For Legal Reasons', (int) 499 => 'Client Closed Request', (int) 500 => 'Internal Server Error', (int) 501 => 'Not Implemented', (int) 502 => 'Bad Gateway', (int) 503 => 'Service Unavailable', (int) 504 => 'Gateway Time-out', (int) 505 => 'HTTP Version not supported', (int) 506 => 'Variant Also Negotiates', (int) 507 => 'Insufficient Storage', (int) 508 => 'Loop Detected', (int) 510 => 'Not Extended', (int) 511 => 'Network Authentication Required', (int) 599 => 'Network Connect Timeout Error' ] [private] reasonPhrase => '' [private] statusCode => (int) 200 [private] protocol => '1.1' [private] stream => object(Zend\Diactoros\Stream) { [protected] resource => resource [protected] stream => 'php://memory' } }
$server = new Server(new Application(dirname(__DIR__) . '/config')); |
|
|
|
// Run the request/response through the application |
|
// and emit the response. |
|
$server->emit($server->run()); |
|
|
No arguments
If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.
If you want to customize this error message, create src/Template/Error/pdo_error.ctp