Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
a:6:{s:5:"sFile";s:112:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/..
Decoded Output download
<? a:6:{s:5:"sFile";s:112:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/pdo/PdoExecCommon.class.php";s:5:"iLine";i:171;s:8:"sMessage";s:258:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (T1.statuscode = 0 or isnull(T1.statuscode))' at line 1";s:8:"sRequest";s:302:" SELECT T1.id, T1.ord_order_recurrence_nref_id, T1.pro_product_id, T1.pro_product_comment, T2.product_name FROM ord_order_product_nref T1 INNER JOIN pro_product T2 on T2.id=T1.pro_product_id WHERE 1 AND T1.ord_order_recurrence_nref_id in () AND (T1.statuscode = 0 or isnull(T1.statuscode))";s:5:"dTime";s:26:"2023/10/23 19:53:34 556560";s:6:"aTrace";s:7401:"a:13:{i:0;a:6:{s:4:"file";s:112:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/pdo/PdoExecCommon.class.php";s:4:"line";i:171;s:8:"function";s:7:"execute";s:5:"class";s:12:"PDOStatement";s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:1;a:6:{s:4:"file";s:96:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/repository/Admr.php";s:4:"line";i:159;s:8:"function";s:6:"select";s:5:"class";s:13:"PdoExecCommon";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:302:" SELECT T1.id, T1.ord_order_recurrence_nref_id, T1.pro_product_id, T1.pro_product_comment, T2.product_name FROM ord_order_product_nref T1 INNER JOIN pro_product T2 on T2.id=T1.pro_product_id WHERE 1 AND T1.ord_order_recurrence_nref_id in () AND (T1.statuscode = 0 or isnull(T1.statuscode))";}}i:2;a:6:{s:4:"file";s:114:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/applications/ord_order/php/domain/repository/Order.php";s:4:"line";i:777;s:8:"function";s:6:"select";s:5:"class";s:18:"AdmrGlobals\R\Admr";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:302:" SELECT T1.id, T1.ord_order_recurrence_nref_id, T1.pro_product_id, T1.pro_product_comment, T2.product_name FROM ord_order_product_nref T1 INNER JOIN pro_product T2 on T2.id=T1.pro_product_id WHERE 1 AND T1.ord_order_recurrence_nref_id in () AND (T1.statuscode = 0 or isnull(T1.statuscode))";}}i:3;a:6:{s:4:"file";s:110:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/applications/ord_order/php/controller/OrderGet.php";s:4:"line";i:838;s:8:"function";s:20:"getTasksByOrderRecId";s:5:"class";s:16:"OrdOrder\R\Order";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;a:0:{}}}i:4;a:6:{s:4:"file";s:109:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/applications/ord_order/php/controller/OrderDo.php";s:4:"line";i:204;s:8:"function";s:23:"doGetOrderByEntAndBatch";s:5:"class";s:19:"OrdOrder\C\OrderGet";s:4:"type";s:2:"->";s:4:"args";a:3:{i:0;a:61:{s:10:"controller";s:21:"getOrderByEntAndBatch";s:2:"id";i:16537336;s:14:"ordTypeOrderId";s:9:"10,30,170";s:20:"ordStatusTreatmentId";s:2:"-1";s:9:"ordTypeId";b:0;s:12:"ordDateStart";s:0:"";s:15:"ordDeadlineDate";s:0:"";s:8:"agencyId";N;s:9:"orderType";N;s:12:"ordAddressId";N;s:18:"ordBankHolidayType";N;s:11:"ordClientId";N;s:13:"ordContractId";N;s:16:"ordContributorId";N;s:16:"ordDeadlineOccur";N;s:15:"ordDeadlineType";N;s:9:"ordDomain";N;s:14:"ordDurationMax";N;s:14:"ordDurationMin";N;s:11:"ordEntityId";N;s:13:"ordFinSupport";N;s:11:"ordFlagLink";N;s:12:"ordFrequency";N;s:5:"ordId";N;s:17:"ordInfoSeverityId";N;s:12:"ordLinkingId";N;s:10:"ordOrderId";N;s:10:"ordOverlap";N;s:12:"ordProductId";N;s:14:"ordQuotationId";N;s:21:"ordTypeContributionId";N;s:18:"ordTypeOperationId";N;s:17:"ord_type_order_id";N;s:11:"ordStatusId";N;s:17:"ordRecTypeInputId";N;s:14:"ordRecIsAllDay";N;s:16:"ordRecTypeUnitId";N;s:12:"ordReportMax";N;s:15:"ordRecTolerance";N;s:13:"ordSmoothStep";N;s:9:"ordAction";N;s:11:"ordAgencyId";N;s:10:"ordComment";N;s:10:"ordDateEnd";N;s:15:"ordFrequencyMax";N;s:19:"ordFrequencyMaxType";N;s:16:"ordFrequencyType";N;s:11:"ordInfoDate";N;s:11:"ordInfoDesc";N;s:12:"ordInfoTitle";N;s:14:"ordOpServiceId";N;s:19:"ordOrganizationName";N;s:19:"ordFinSupportStatus";N;s:7:"bFilter";N;s:9:"StartDate";N;s:7:"EndDate";N;s:14:"ordRecDuration";N;s:13:"ordRecurrence";N;s:11:"ordToDelete";N;s:11:"ordToInsert";N;s:13:"bExcludeADOMI";b:0;}i:1;s:4:"1282";i:2;b:1;}}i:5;a:6:{s:4:"file";s:114:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Entity.php";s:4:"line";i:924;s:8:"function";s:8:"doAction";s:5:"class";s:18:"OrdOrder\C\OrderDo";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;a:61:{s:10:"controller";s:21:"getOrderByEntAndBatch";s:2:"id";i:16537336;s:14:"ordTypeOrderId";s:9:"10,30,170";s:20:"ordStatusTreatmentId";s:2:"-1";s:9:"ordTypeId";b:0;s:12:"ordDateStart";s:0:"";s:15:"ordDeadlineDate";s:0:"";s:8:"agencyId";N;s:9:"orderType";N;s:12:"ordAddressId";N;s:18:"ordBankHolidayType";N;s:11:"ordClientId";N;s:13:"ordContractId";N;s:16:"ordContributorId";N;s:16:"ordDeadlineOccur";N;s:15:"ordDeadlineType";N;s:9:"ordDomain";N;s:14:"ordDurationMax";N;s:14:"ordDurationMin";N;s:11:"ordEntityId";N;s:13:"ordFinSupport";N;s:11:"ordFlagLink";N;s:12:"ordFrequency";N;s:5:"ordId";N;s:17:"ordInfoSeverityId";N;s:12:"ordLinkingId";N;s:10:"ordOrderId";N;s:10:"ordOverlap";N;s:12:"ordProductId";N;s:14:"ordQuotationId";N;s:21:"ordTypeContributionId";N;s:18:"ordTypeOperationId";N;s:17:"ord_type_order_id";N;s:11:"ordStatusId";N;s:17:"ordRecTypeInputId";N;s:14:"ordRecIsAllDay";N;s:16:"ordRecTypeUnitId";N;s:12:"ordReportMax";N;s:15:"ordRecTolerance";N;s:13:"ordSmoothStep";N;s:9:"ordAction";N;s:11:"ordAgencyId";N;s:10:"ordComment";N;s:10:"ordDateEnd";N;s:15:"ordFrequencyMax";N;s:19:"ordFrequencyMaxType";N;s:16:"ordFrequencyType";N;s:11:"ordInfoDate";N;s:11:"ordInfoDesc";N;s:12:"ordInfoTitle";N;s:14:"ordOpServiceId";N;s:19:"ordOrganizationName";N;s:19:"ordFinSupportStatus";N;s:7:"bFilter";N;s:9:"StartDate";N;s:7:"EndDate";N;s:14:"ordRecDuration";N;s:13:"ordRecurrence";N;s:11:"ordToDelete";N;s:11:"ordToInsert";N;s:13:"bExcludeADOMI";b:0;}}}i:6;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:1287;s:8:"function";s:34:"doHandleGetEntityClientRecurrences";s:5:"class";s:19:"Core\S\Api\C\Entity";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:8:"16537336";}}i:7;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:195;s:8:"function";s:17:"formatResultOrder";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:4:{i:0;s:9:"ord_order";i:1;b:0;i:2;a:2:{s:8:"entityId";s:8:"16537336";s:2:"id";s:8:"37142833";}i:3;s:11:"returnOrder";}}i:8;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:1313;s:8:"function";s:16:"doHandleGetOrder";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:8:"37142833";}}i:9;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:1842;s:8:"function";s:17:"formatResultOrder";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:4:{i:0;s:9:"ord_order";i:1;b:0;i:2;a:2:{s:10:"controller";s:17:"getExternalOrders";s:8:"agencies";s:29:"5076,4335,4336,4515,4412,4337";}i:3;s:22:"doHandleExternalOrders";}}i:10;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:50;s:8:"function";s:22:"doHandleExternalOrders";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:11;a:6:{s:4:"file";s:118:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/ApiProcess.php";s:4:"line";i:325;s:8:"function";s:8:"doAction";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:12;a:6:{s:4:"file";s:77:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/web/api/index.php";s:4:"line";i:51;s:8:"function";s:14:"processRequest";s:5:"class";s:23:"Core\S\Api\C\ApiProcess";s:4:"type";s:2:"->";s:4:"args";a:0:{}}}";} ?>
Did this file decode correctly?
Original Code
a:6:{s:5:"sFile";s:112:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/pdo/PdoExecCommon.class.php";s:5:"iLine";i:171;s:8:"sMessage";s:258:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (T1.statuscode = 0 or isnull(T1.statuscode))' at line 1";s:8:"sRequest";s:302:" SELECT T1.id, T1.ord_order_recurrence_nref_id, T1.pro_product_id, T1.pro_product_comment, T2.product_name FROM ord_order_product_nref T1 INNER JOIN pro_product T2 on T2.id=T1.pro_product_id WHERE 1 AND T1.ord_order_recurrence_nref_id in () AND (T1.statuscode = 0 or isnull(T1.statuscode))";s:5:"dTime";s:26:"2023/10/23 19:53:34 556560";s:6:"aTrace";s:7401:"a:13:{i:0;a:6:{s:4:"file";s:112:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/pdo/PdoExecCommon.class.php";s:4:"line";i:171;s:8:"function";s:7:"execute";s:5:"class";s:12:"PDOStatement";s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:1;a:6:{s:4:"file";s:96:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/repository/Admr.php";s:4:"line";i:159;s:8:"function";s:6:"select";s:5:"class";s:13:"PdoExecCommon";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:302:" SELECT T1.id, T1.ord_order_recurrence_nref_id, T1.pro_product_id, T1.pro_product_comment, T2.product_name FROM ord_order_product_nref T1 INNER JOIN pro_product T2 on T2.id=T1.pro_product_id WHERE 1 AND T1.ord_order_recurrence_nref_id in () AND (T1.statuscode = 0 or isnull(T1.statuscode))";}}i:2;a:6:{s:4:"file";s:114:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/applications/ord_order/php/domain/repository/Order.php";s:4:"line";i:777;s:8:"function";s:6:"select";s:5:"class";s:18:"AdmrGlobals\R\Admr";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:302:" SELECT T1.id, T1.ord_order_recurrence_nref_id, T1.pro_product_id, T1.pro_product_comment, T2.product_name FROM ord_order_product_nref T1 INNER JOIN pro_product T2 on T2.id=T1.pro_product_id WHERE 1 AND T1.ord_order_recurrence_nref_id in () AND (T1.statuscode = 0 or isnull(T1.statuscode))";}}i:3;a:6:{s:4:"file";s:110:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/applications/ord_order/php/controller/OrderGet.php";s:4:"line";i:838;s:8:"function";s:20:"getTasksByOrderRecId";s:5:"class";s:16:"OrdOrder\R\Order";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;a:0:{}}}i:4;a:6:{s:4:"file";s:109:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/applications/ord_order/php/controller/OrderDo.php";s:4:"line";i:204;s:8:"function";s:23:"doGetOrderByEntAndBatch";s:5:"class";s:19:"OrdOrder\C\OrderGet";s:4:"type";s:2:"->";s:4:"args";a:3:{i:0;a:61:{s:10:"controller";s:21:"getOrderByEntAndBatch";s:2:"id";i:16537336;s:14:"ordTypeOrderId";s:9:"10,30,170";s:20:"ordStatusTreatmentId";s:2:"-1";s:9:"ordTypeId";b:0;s:12:"ordDateStart";s:0:"";s:15:"ordDeadlineDate";s:0:"";s:8:"agencyId";N;s:9:"orderType";N;s:12:"ordAddressId";N;s:18:"ordBankHolidayType";N;s:11:"ordClientId";N;s:13:"ordContractId";N;s:16:"ordContributorId";N;s:16:"ordDeadlineOccur";N;s:15:"ordDeadlineType";N;s:9:"ordDomain";N;s:14:"ordDurationMax";N;s:14:"ordDurationMin";N;s:11:"ordEntityId";N;s:13:"ordFinSupport";N;s:11:"ordFlagLink";N;s:12:"ordFrequency";N;s:5:"ordId";N;s:17:"ordInfoSeverityId";N;s:12:"ordLinkingId";N;s:10:"ordOrderId";N;s:10:"ordOverlap";N;s:12:"ordProductId";N;s:14:"ordQuotationId";N;s:21:"ordTypeContributionId";N;s:18:"ordTypeOperationId";N;s:17:"ord_type_order_id";N;s:11:"ordStatusId";N;s:17:"ordRecTypeInputId";N;s:14:"ordRecIsAllDay";N;s:16:"ordRecTypeUnitId";N;s:12:"ordReportMax";N;s:15:"ordRecTolerance";N;s:13:"ordSmoothStep";N;s:9:"ordAction";N;s:11:"ordAgencyId";N;s:10:"ordComment";N;s:10:"ordDateEnd";N;s:15:"ordFrequencyMax";N;s:19:"ordFrequencyMaxType";N;s:16:"ordFrequencyType";N;s:11:"ordInfoDate";N;s:11:"ordInfoDesc";N;s:12:"ordInfoTitle";N;s:14:"ordOpServiceId";N;s:19:"ordOrganizationName";N;s:19:"ordFinSupportStatus";N;s:7:"bFilter";N;s:9:"StartDate";N;s:7:"EndDate";N;s:14:"ordRecDuration";N;s:13:"ordRecurrence";N;s:11:"ordToDelete";N;s:11:"ordToInsert";N;s:13:"bExcludeADOMI";b:0;}i:1;s:4:"1282";i:2;b:1;}}i:5;a:6:{s:4:"file";s:114:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Entity.php";s:4:"line";i:924;s:8:"function";s:8:"doAction";s:5:"class";s:18:"OrdOrder\C\OrderDo";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;a:61:{s:10:"controller";s:21:"getOrderByEntAndBatch";s:2:"id";i:16537336;s:14:"ordTypeOrderId";s:9:"10,30,170";s:20:"ordStatusTreatmentId";s:2:"-1";s:9:"ordTypeId";b:0;s:12:"ordDateStart";s:0:"";s:15:"ordDeadlineDate";s:0:"";s:8:"agencyId";N;s:9:"orderType";N;s:12:"ordAddressId";N;s:18:"ordBankHolidayType";N;s:11:"ordClientId";N;s:13:"ordContractId";N;s:16:"ordContributorId";N;s:16:"ordDeadlineOccur";N;s:15:"ordDeadlineType";N;s:9:"ordDomain";N;s:14:"ordDurationMax";N;s:14:"ordDurationMin";N;s:11:"ordEntityId";N;s:13:"ordFinSupport";N;s:11:"ordFlagLink";N;s:12:"ordFrequency";N;s:5:"ordId";N;s:17:"ordInfoSeverityId";N;s:12:"ordLinkingId";N;s:10:"ordOrderId";N;s:10:"ordOverlap";N;s:12:"ordProductId";N;s:14:"ordQuotationId";N;s:21:"ordTypeContributionId";N;s:18:"ordTypeOperationId";N;s:17:"ord_type_order_id";N;s:11:"ordStatusId";N;s:17:"ordRecTypeInputId";N;s:14:"ordRecIsAllDay";N;s:16:"ordRecTypeUnitId";N;s:12:"ordReportMax";N;s:15:"ordRecTolerance";N;s:13:"ordSmoothStep";N;s:9:"ordAction";N;s:11:"ordAgencyId";N;s:10:"ordComment";N;s:10:"ordDateEnd";N;s:15:"ordFrequencyMax";N;s:19:"ordFrequencyMaxType";N;s:16:"ordFrequencyType";N;s:11:"ordInfoDate";N;s:11:"ordInfoDesc";N;s:12:"ordInfoTitle";N;s:14:"ordOpServiceId";N;s:19:"ordOrganizationName";N;s:19:"ordFinSupportStatus";N;s:7:"bFilter";N;s:9:"StartDate";N;s:7:"EndDate";N;s:14:"ordRecDuration";N;s:13:"ordRecurrence";N;s:11:"ordToDelete";N;s:11:"ordToInsert";N;s:13:"bExcludeADOMI";b:0;}}}i:6;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:1287;s:8:"function";s:34:"doHandleGetEntityClientRecurrences";s:5:"class";s:19:"Core\S\Api\C\Entity";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:8:"16537336";}}i:7;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:195;s:8:"function";s:17:"formatResultOrder";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:4:{i:0;s:9:"ord_order";i:1;b:0;i:2;a:2:{s:8:"entityId";s:8:"16537336";s:2:"id";s:8:"37142833";}i:3;s:11:"returnOrder";}}i:8;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:1313;s:8:"function";s:16:"doHandleGetOrder";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:8:"37142833";}}i:9;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:1842;s:8:"function";s:17:"formatResultOrder";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:4:{i:0;s:9:"ord_order";i:1;b:0;i:2;a:2:{s:10:"controller";s:17:"getExternalOrders";s:8:"agencies";s:29:"5076,4335,4336,4515,4412,4337";}i:3;s:22:"doHandleExternalOrders";}}i:10;a:6:{s:4:"file";s:113:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/Order.php";s:4:"line";i:50;s:8:"function";s:22:"doHandleExternalOrders";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:11;a:6:{s:4:"file";s:118:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/_core/php/domain/service/api/php/controller/ApiProcess.php";s:4:"line";i:325;s:8:"function";s:8:"doAction";s:5:"class";s:18:"Core\S\Api\C\Order";s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:12;a:6:{s:4:"file";s:77:"/var/www/pr177.admr.org/backend/releases/20231023193014/sap/web/api/index.php";s:4:"line";i:51;s:8:"function";s:14:"processRequest";s:5:"class";s:23:"Core\S\Api\C\ApiProcess";s:4:"type";s:2:"->";s:4:"args";a:0:{}}}";}
Function Calls
None |
Stats
MD5 | 305b71a5695d769c979a70eee4ad78a6 |
Eval Count | 0 |
Decode Time | 100 ms |