Code Context $xml = $this->get_xmp_array($xmp_data);
foreach($xml['Seq'] as $row) {
$single_data = array();
$item_details =
[
'path_root' => '/media/images/IMAGES DONE/',
'drive' => 'D',
'originalpath' => 'D:/Images/Images Done/Library/SF146/148381.jpg',
'FileSize' => '268 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF146/',
'path' => 'Library/SF146/148381',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF146/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF146/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF146/',
'file_name' => '148381.jpg',
'id' => '148381',
'sku' => '148381',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF146/148381.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF146/148381.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF146/148381.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF146/148381.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0407104',
'headline' => 'Antrim v Cork',
'headlineTruncated' => 'Antrim v Cork',
'caption' => '25 July 2004; Referee Aodan MacSuibhne during the match. Guinness All-Ireland Senior Hurling Championship, Quarter Final, Antrim v Cork, Croke Park, Dublin. Picture credit; Brian Lawless / SPORTSFILE',
'DateCreated' => 'Sun, 25 Jul 2004 00:00:00 +0000',
'ShortDate' => '25 Jul 2004',
'LongDate' => 'Sunday 25th Jul 2004',
'db_DateCreated' => '200407250000',
'event_images_count' => (int) 52,
'event_images_count_text' => '52 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0407104/',
'w' => '1632',
'h' => '2216',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1632,
'height' => (int) 2216,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '25 July 2004; Referee Aodan MacSuibhne during the match. Guinness All-Ireland Senior Hurling Championship, Quarter Final, Antrim v Cork, Croke Park, Dublin. Picture credit; Brian Lawless / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/148381/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/148381/'>Purchase This Print</a><br/>',
'single_image_link_text' => 'Purchase Print',
'gallery_actions_default' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F148381&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Antrim+v+Cork" class="left" onclick="track_share_click('twitter');"><div class="icon-medium icon-medium-twitter"></div></a>
<a class="facebook left" target="_blank" onclick="track_share_click('facebook'); return !window.open(this.href, 'Facebook', 'width=640,height=300')" href="https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/148381&t=Antrim+v+Cork"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/148381/" class="text12 gallerylink right gallery-history-link">Purchase Print</a></div>',
'gallery_actions_corporate' => '<div class="gallery-actions corporate-box"></div>',
'permission_name' => 'access_5000',
'twitter_share_link' => 'https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F148381&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Antrim+v+Cork',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/148381&t=Antrim+v+Cork',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F148381&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Antrim+v+Cork" class="left" onclick="track_share_click('twitter');"><div class="icon-medium icon-medium-twitter"></div></a>
<a class="facebook left" target="_blank" onclick="track_share_click('facebook'); return !window.open(this.href, 'Facebook', 'width=640,height=300')" href="https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/148381&t=Antrim+v+Cork"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/148381/" class="text12 gallerylink right gallery-history-link">Purchase Print</a></div>',
]
$sql = 'select user_activity_tbl.*,users_tbl.name from user_activity_tbl
inner join users_tbl on user_activity_tbl.user_id=users_tbl.user_id where path='Library/SF146/148381' and action like '%editorial_image'
order by id'
$conn = object(Cake\Database\Connection) id:0 {
'config' => [
'password' => '*****',
'username' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'driver' => 'Cake\Database\Driver\Postgres',
'persistent' => 'false',
'timezone' => 'UTC',
'flags' => [
],
'cacheMetadata' => true,
'log' => false,
'quoteIdentifiers' => false,
'datasource' => 'Database/Postgres',
'schema' => 'public',
'prefix' => '',
'encoding' => 'utf8',
'url' => null,
'name' => 'default',
]
'driver' => object(Cake\Database\Driver\Postgres) id:1 {
'connected' => true
}
'transactionLevel' => (int) 0
'transactionStarted' => false
'useSavePoints' => false
'logQueries' => true
'logger' => object(DebugKit\Database\Log\DebugLog) id:2 {
protected _queries => [
'' => [maximum depth reached],
]
protected _logger => null
protected _connectionName => 'default'
protected _totalTime => (int) 2
protected _totalRows => (int) 1
protected _includeSchema => false
}
}
$query = object(Cake\Database\Log\LoggingStatement) id:0 {
protected _logger => object(DebugKit\Database\Log\DebugLog) id:1 {
}
protected _compiledParams => [
]
protected startTime => (float) 1758115229.8338
protected loggedQuery => null
protected _statement => object(Cake\Database\Statement\PDOStatement) id:2 {
}
protected _driver => object(Cake\Database\Driver\Postgres) id:3 {
}
protected _hasExecuted => true
}
$editorial_history = [
]
$file = '/media/images/IMAGES DONE/Library/SF146/148381.jpg'
$var = [
'var' => [
'www_dir' => '/var/www/html',
'www_url' => 'http://www.sportsfile.com',
'web_dir' => '/var/www/html/src/webroot',
'web_url' => 'http://www.sportsfile.com',
'mod_dir' => '/var/www/html/mod/',
'mod_url' => 'http://www.sportsfile.com/mod/',
'cls_dir' => '/var/www/html/src/webroot/class/',
'cls_url' => 'http://www.sportsfile.com/class/',
'xml_dir' => '/var/www/html/src/webroot/xml/',
'img_dir' => '/var/www/html/src/webroot/images/',
'img_url' => 'http://www.sportsfile.com/images/',
'css_url' => 'http://www.sportsfile.com/css/',
'js_url' => 'http://www.sportsfile.com/js/',
'_mstart' => (float) 1758115229.8189,
'_log' => '',
'_onload' => '',
'_style' => '',
'_script' => '',
'_main' => 'main',
'_action' => 'main',
'_file' => 'main',
'_xmlact' => 'main.xml',
'_source' => 'post',
'www_index' => 'http://www.sportsfile.com/index.php',
'www_self' => 'http://www.sportsfile.com/id/148381',
'www_script' => 'http://www.sportsfile.com/index.php?action=main',
'ccode' => 'EUR',
'cname' => 'Euro',
'cicon' => '€',
'email_support' => 'liam@zeitsolutions.com',
'twitter_widgets_js' => '<script type="text/javascript" src="//platform.twitter.com/widgets.js"></script>',
],
'dataset' => [
'status' => [
(int) 1 => 'New Order',
(int) 2 => 'Sent To Printer',
(int) 3 => 'In Print',
(int) 4 => 'Cancelled',
(int) 5 => 'Posted',
],
],
]
$image_xmp_history = [
]
$key_data = [
'DRP' => 'Dropped',
'TXT' => 'Metadata Edited',
'ACT' => 'Sent to an Action',
]
$content = '��� JFIF � � ��&�Exif MM * J R( �i Z x w@ ' w@ ' � `� � � �( � & H H ��� JFIF � � �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �KTF>�n�ݍ��+һ���bm6�n隃R�C�'ڄ�&���P�x��`F�h��h^�����f]D�>�rsք����n��qYm{� �֚z�_�5���lU(9.� �i\kSRT�[q �P��Irv�)&6�h�ċ ������8Pb��cS��nn�[Kh '�&�au/N���`F(�,g����Lf�(U�$���rwf�Q������p=���-���~lVb?�q��zеE��v[cp�s��$��>1�YN�%���u�5��kM5�o'Hb�wH�p{�%e�:�R�U���� n>٩�]S^b�A�f��s�CS]�z���rC*}v��D�"Dҩ۞��q�s��lm�ogQ'ԡo!�
rޠ�4��/�ͷ=�z�l�I���n�6��}*M5p���'����:�3_K�"=�2;+�XĬN=(���X���V+��Pm�'ڦ��f�����tX������h_n�֓���ۇ��rOj��Ͷ�8 ��'+ ��K� j����nw5�t�gf��㖬m�;K���)����¸�]�<7m#D�+`�� ���c���
N��ZW�>�b�7W g��f� ��q�9�Gž%�#W�N����E�B��0��n'~){��c��|J��y�s�צ�:�7V`��8�w�|���bU�r�p� ^z�#Kh�͚���1�����m8�Z7�Z�ӥE*��V+���c-��X�[ݜ\���6`rsZ��X�D�fj�,�(��֜����H�R�m�2N�;֕�X��#8�I��p����M��T{� �,f2Z@ߍt֤��d�0s��5�����L�`$�9�Τ�<Z^���5���и1<�9w��<`�Ԍ���yY��K���=�
w���=/×D��Zjvv���[8�t?*�~,kQjz��QX��"�k9��蓈�P1�����&�K��%I��^��j�e�5�Xxzm6A%�b�zg��8�C�B���L)�ץT������U��SK*5v���zLzDwYPwm�g����ێ������od| ��.y�t�^]� [�dE�(�4=���FZB�V��UP������:>�5�0�T�BՁ�?�䶳�M�~�W�� n^ʾ �+\eW��L$mv%����$�$ie ������
��Xi:�f+��,��.;��l~��q���u=5E
�{3��<C�C���,
�<�6�H��8���5���\Y3�\\,�4�4���X�� l\�7iX�!JU!*�e���~��iF=*�>pq�WAe|���$�ֺ���t�pק����& ?N*�[��m�R��|�z|��#o�����
z'��N�0f�3WEY��u9����� ����Ǟa�ƑB��2j�˙d!�-YE�dH#����Je�֧}@Їlqg'�e]��^3ޒ�_�7Kx˹W�6�4��MQ�71ڧ,��z}p9��R�E%h�t�
�QG�9PxQ�\��4���W��\��I8$p@o�z���F�ZV:�����[5�:�Vh����0HrLr����vW����9����%�
�C�NǠ��o��7^I��T�֥����A# Q>v��O�5��76��n�j��e�#C���)�p�U%ԋ�)�mbW�Գ�¶����!�,��'�c��&�����rh��U��d��a9=�W�w�PO4��zW*�m�u�(J��o_H�Q��PX/�!v�ڷ��˹R4
95Z� -Ҥ��ZH�]7z�[ŷ� e�g�5 �Q����YcQ� s���tQ0滹kY�'ʀ�� �?ǽh�VU�XX.dUI�;��2��*e��O�������Ɲ8�K7���2q��r �f���me�)3\�tD�3�>\ �T��rJM�n��y,(8�6w�h�t=�_"�%����o�p\�3M�">d5iY\R�縚����0qRhv���=���ކ��ʬ8����'�w�}�p�]?�mVd��d�5�����{���궻��4��
F�B��#�1=���x�K��!Uv��"�c��?�]{O��s���(Gȿ�#�
ܟ�_$��R��T����U'��O�4��Ahٙ�j"X��Fe��r��U�Z��hg�X�n�die0������Y��CG���^"���O�o{q4��FXY"��8, e�q߯� %���mķ�M#C:D�c�,�; A8ɬhJ�#�-�+�]�fI�(�+F��b�Mv6Q�|�d�@�Wll�8�$��u��UA�hXZ$qzi�/6��
H�����>��,�I�k/A�$_3+���JJM�u�x�#�wbky\`�[r�ʾR�$���DMb�l���v�8������O⏌%�'��t�M$�]:v�K9�*A��F-��zڹ
fC{d [���A��];��IEX��u�gɹ�ȷ�ْb~S��H����*�<;ke���>lXX�G:������}2N��$gz�9Unj�=,{ ��4�\�kڅ��\��9-*�h��' �8#��d����,�!�D�:�Z}���څs�3����eUT��+)6�ܓ�?̪��T�������uv��H v�Y^4�縯�21s�� >P
i;�ps� ����.8 �ZN(I�jb1����EU����|��d0��?���d��.�N+)UQ�]��M�
�=��L��G_��_Z��nf�Zx�S�7z��-$��MJ
��4��;e;�ri/�
0:V�7S�?���[Wk��o�>����I�3���ߴtzm�4������ݵ��F�|�*9a�Xa��^<��.��"���� �n��M�$v1�Jn"��#^�NW�� �z�k⮛mg�f��e�kh�l����H#�A�ִ5��>k>j��~�� ��O��\D-�����8���-@˃�L��p���^��m�
"�5�K$�V峵�(��U�Z�R�"ן�w�MI�>��G����Lf��RTo�f����Y�%(���`��WUW��#�?"��;���צ*�����])� ����Q�������t披��?���O�G;G$T�W�-'s!�ps���z4�$c���.�g�1GP�p 5�?�W��XD͜涜o$�zr�_��_��[�\rFwn�u�,��ִ00<s?��21��~<L.n4�L�1�A��v�1�}��J��t={��s��lj�=[Öڌ��XF���10��t;���W5��Ʊ�Ok�k��@D�+o|0=2FLWM
*/C�0��+�� 2� �J9,l�[EV7!��ʸ�=��`�F���Y����4�VK��Mo(dr���X`���i�F����L�(�K��4I�|:�݆�p�״��y&dky7c�}�'>�
�)��=��'�Xx�ʰ�b�I7_��r͜��sM�X}S=�Uc�|�G�X}�Ko>��h�G�ĈU�NX9�9J�|�US��)˝&pV����mR1�#�U��/�FsV����|��E0<c���>��zno��W��\����2G�#P>`x�k'�R�mm�_�v߾���-c�w¥؞����:"�E|X���L�N&��L1�~oJ���4�0�on���ʊv�
?V��>5*\|Gԣ�F#E�F��5��_�s�����X� ]�ZK[��Tv��*`�!e\q�lU���v��59�V��V?.w2&̒�����5�Ȗ��v�H�<Y�-#���,v��-�N��͂W�� N��߿5�_�X���2��9ɔ�:� ���Vxx�E����#���t��Zm(� =+������o��Eq�g�[�$&uaʌ/.3ۨ�WL�3jrq�h��ն��hwo��\�]\���st�θm�2Cr��m ��x��[��7
��ʹY\�lo�H�$zVAe�S���p�Ɓ ���>U�V��|��i�I�K�s���S�7��4�b�m$;�v9�+w�����J����;Sa��z�3�4�X"��7]��z�hR�z���͆��k�����4�_k6�{�n���5�D��|�|���rT��zڜ>:�c�o#��!�$�*Y
� �0 W<jBU������T�B���M
6w�
��H��y��*y�=*tgY�&�Fo�k$���A؏~��b���cB�lz��41=����4"H�bA`C��� 1_^������l'�{y��~VB8#�i��>�8�+�NMU�+pEv�~�V�l��;���>tLj���r��-�� 9��I�[�y����泂��:�/�tz<�ց��#5J�L��c���y���Q@ϐ�m]��ϵjL%�n#�8���7��i��g�"lg�^i��4�c� q�D�2h�~�7|)�K��ĕ�J����]YD�T���gz�}��y����֙�-=�/✬�C�Ȥ��<69��_7|\�m5/���
l�ES#����J���_�w=lL��+Z�'c,�]��T9�>3ف�j��Zd1��q�#�O�%k�G�o�%棩��i7�l�L#�ᐘ�S�|g }3��F�ua���a`��b�g$*��玵�b�fsv�)B!�F��RMy��C
Iib���9�r�N\�Ƥ�c�WV�2�.�ǫZ����4�2���z�!A's*����}�
R����N�c�'�y���r��Q��E\�
ᕊۂ���ҙq�(�ɼ�\m�)�ZXMjs�9��e�61�W�y��z�OpŘ�ⴄuN�V��}����,7l�ֵ�����;O��Akow �����nq��#8 W�W{�ČG%�9�^C��7.�l*9A.�m���_���i�J̓��Ԭ`d�AҨ�B���$�;+��2�#;v�3��g²�iq�S�].{�3��p-9ٙ�M�����#�u�����:�O���c�GA]؊Q�҉�J���C�N*8���=+��υ��Vֈ$8P=k�4� C0H#�\r���>�$�paȢ�H|{����$�9���-튑��7KSY�NJ| i~�#ĥ�|t�kC�ae
���9���c�ԾY�&���/C�j�F\�x�)�|��q��/�o�x��hp]�f�\34>fv�(0���y�_"x�7��mݭ�rI�4� �G�y���Y�J�.�9=�H�l��~\~b�G��2NE�"��ç�D���C.W'�v^�u��R�"��^�d�C���ߥ}�x;T�7��I�.�$HQ�#(�9 8�Ҫ�1:�@�����Z�ó^@|�� �XW��ߺU;�:��=Y�SK���1e����j�����K�&Ho�T�����qך��z��t�~ƥ�n+�]�9x�+��9�H��;z�N�>��g�
��W?n-o_`ZT_��2���.#��+��Z�6m��V7�%e��R�גi�^edTef� ��zMJ嶉�� tw�N*�����ܢ%�Q^
]$�{/Xܫ���/��}a�ҡK۰YC�T�#���A}g���Yt����4�E�Q�Ľ�r�z�1�n�s���s�N�,I�o��|ʻ9�:��\�ޣ-Ɛ��e��ԑ���\4[U"�s�q�%��{
]f �~�[�W��$������\���S�Iu&�4r�� ⦁���1k�IF��v��vujK���j���6d;^1\NH�E�GO����I��ފV`}]��ڈSp&��qg�q�ֺ�!h�rד<�A��V(T���-�h����\'�|A�h�!ӡ�-Զ�m�L�ě�gn�>9Pr9�pI�U�&�r�%"�Žv�b����,`C�0+�m#�1^@���}�ci%�́� Oz�ٻ��k$}�/L�߆��H䍚̮:<��?��
���pۼ�R0��=�z�u�N
��8�ӵ�#�[��g�_�5�nS/����펜�ב(r�q]�ҩ���c����.U�#ұ<G�%͡�0<t��>l����Z���T31�*������=sZJ^�BI^�{c�$�����*��#���|�^ƾ��Gmh��EP�K�W��m���R�ܗ�#a���FʑKWӌ1o`�UP�p�Y�|Ô,r��]m�
O�ȫ5˷�g<I)�� � $�1Ԋ����x��h�G�M�����q� ɜ�.M]U�j�ۊ��~���6�-�h:o���HO�9�ϩ9���� �ڼ+�'����F�.�Z�T�Ga��כ](�Iu=J%:w�Hn5[��a1u�5>�Y��ӿ5�8|��Y�S)M��|k&����k:��E�-��*����x�^�of�mno�C�<,�^k������4����_?^�^Q���a8���_�W>���q;G����u�����:
n��) �5�lўUs�R�[Rfi��jx{���ۊ�S�yb�q]��+���^�7�9����84�♊�C(�X%t|T�s��� ��+�胧�z(�Il�]�.k�I�_)6g����P�� u�(�*���/���-4�_t}�Ys� -d� �?Z�{���9%�W h31<