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/SF320/244390.jpg',
'FileSize' => '575 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244390',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_name' => '244390.jpg',
'id' => '244390',
'sku' => '244390',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244390.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244390.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244390.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244390.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Hugh Flavin, Limerick, in action against Conor Hernon, Offaly. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'DateCreated' => 'Sun, 15 Apr 2007 00:00:00 +0000',
'ShortDate' => '15 Apr 2007',
'LongDate' => 'Sunday 15th Apr 2007',
'db_DateCreated' => '200704150000',
'event_images_count' => (int) 20,
'event_images_count_text' => '20 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0704111/',
'w' => '2464',
'h' => '1704',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2464,
'height' => (int) 1704,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '15 April 2007; Hugh Flavin, Limerick, in action against Conor Hernon, Offaly. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/244390/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244390/'>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%2F244390&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244390&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244390/" 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%2F244390&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/244390&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F244390&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244390&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244390/" 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/SF320/244390' 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) 4
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) 1758078395.0449
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/SF320/244390.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) 1758078395.0334,
'_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/244390',
'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 H H ��-0Exif MM * J R( �i Z x
�� '
�� ' � �� � � �( � ,R H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �ύ5]-n5x�2C;�`�r*'���l� �\g泩V.����Zv�}�k�As旀?�u�'��vV��L�r���ڸ���mF1g�x��ꬖ�����V� �fGbq�#�I�FGo�Z�.�f a��}���h. �H�N�X�w"#���ko��%��`G�
�-t��嗑��{8^EI_��]ϙX�n��7V��!B@�'����G�����B҆Ui'�W�6���(�.|݈۬|Aw4X����W��c�a,n{E4�eҳN'G�]Q,�b<V�����]��1 k�$���|�[�j#V�dp�8�~�-��n�J:�F{� ���5{p�[]�`m-ִ$�Be��WB�ū;'S���VNy���f�(%h��9�ri�_��*T���S)t!D�.�p
v�+3X���Ԓ�u�^�=�C���h�ٳ��u(y�A��U��A�q��w �[%�����_lg�êXF��1�[�R���LL\��wL����P
�ʒx�y��tK[OGj,S
�gp�)��I�RZ�m��M�_ݰ��4���k�8e=Gz�4�B����i_��F�zW�jz���$I��U&�=��S�E��<��C��u��t�_�6���Y�D���暥�K�s�<��tJ`� 9=FkJ�������㼴bσ��qT|������H2Y�����,���d�}�G��[n����5�O�$` /�EiM$̧+��y� N����L8���zK�����4�.Ðs�jn�O(G9@D���D�>��M�U�ԦD�Σ�4U�Q��m7Itp��@�;B����Q�j3t���U�j|��z��]-&�P�b��Y_�KH���4�7��E>u
���.j�S'O�����U�L�
�kμiy>��E2��7$054�>WsJ���Cs*��X�$עxM��0��Z���K�B?�-D�%�^����N�� ��8���|5�x�����O,r;B����(rj��ԊM3����?Um>�O������U�Ǩ�G�ⷭ������iz�?�yH�&�
Ld����+���n�(}pq]�sƍIJZ�1ԧ��{�N@5��Win��$�\���Gs-�AfK0c�^m�;�>�x���Άa+7������q+`
�+gc%v���Dժ( �T$i�v�ܻ�B���&%{~cZB�][Qu��#�yUǕ�gg��M���8�Z�j�O��=��|Q]�-�'�?/�r�e�ь�5Eٳ�t\��}�� ��m� W鵁'�1��y_ē6��K�m.e�,N$��hʳ�� ��#�~��?����֫�M�ɰ��[%�÷Pj�
����,K�Z�I��=7��l[�:c���0#�)���j e�Y�'�{��h���&n�y�]���f��� �|���N_@8,r;gNHg���i� k�F��U�Ģ7+���x���ֵ�Ek���K���su�_V��:���ZBb����*�(܂�9�O��G��C�!-�Ua�~(��I�{6T��2�2I����a4茲u8�ʟ �
�;��_]����C�_,��J䖊�Ba�kws�
�W�$[f�,�Fv�ddpz��ަ*�93KH�~�5��t�˵����Q��W��?I�G�4������y��Q26;�"�_�E��u�;���X�H�0Q"0�(I�A������ͮ�UW
jUٲksO��G6�ER����c� �XUU�vOr�S/�'�V�+6�^��g�C�9my�����5�Je�gg�)��Eyd|�q��ƭӲf�Z���;Y}�E����q2�m�z������z�ԟ���V7����J�\�A�6v�N�qYEs��sOe6��>H��ܘ�OL���j3h�q�~V�5�����6�}N����
����Clg�VUφ�Iqs&��-��<��"e�
�%�z�ӯj�0���¶&����Թw1���v��T[����Wq� ��J���ip����`���Q��i�s�5�=*~���ӡ�J��]ح������a.����&Ӂۚ���Xbm�mt�R�/��� ˠ�o��ЎMdkڑp ��*U��"�=.s�Sw4�p�i\,4�R�"�2��굫�I��^9P[<�c���t���W4�KSh�Xiz�J^;�� ���t`��Ԏ�n��I�Kự~b��{x��3yk���v��럛vq������F�������棢�Zjo���D�nD�'�n�,rx*Ny�'�=��]�yZޒ|�Ϩ�+�DZ�6�#��4 �khZ�99+M첩p�QITI�V�H�$�:�Kr�<���Z�wt�W�ZL@�abO7O��\�/$�s�TqGa�W������}9v�3�u"����^��q�>��Y�缒-�Rg�r3��<"��~Ec$��W8�Q ���$ٮ���k�+��F��{{{�[����b�� < �Z�kq�X$o4nKS#F���%pK���t>���<�F�w�G��u>ũh�����S�Tn�H�5����5��4$���s���-�x��t�g��ڄjX&<J��g�kV�w"RB��R�$�Y6�� Kq�#3�k��M���յ�����5=b��8�������
>�铓Y]L�23M6��e-d١gl�>I��7���hE+�ϹHLd���U�X|�ץRW)���?ë�lo��rsȮ�S:m�ugp��E [���|����� �6�g��:�{�s(6�/����LqhVd�@�P�\���C#Px�i ���3i^C�y�$x���~qn����G�Nqյ�'�ާc$�l�/:"[ܩI�b]��t\���6{�_�o�|�q]��qH敹ܑ����Vvni�%ʌ��7��V�/��l���i(��Ms��-�]]���AE=�?N=�s�$��Yי�2G-�I$��e�� ��X�B�g�B_������?�b{�Y�-a`��{u�A(g�sױ�� � ԯ5?�ZKi5��^��. �����p�ֹ����T���:U)T������ �Ѯ�]i�5�KC�.;2��ץx�L��?�54yc�* �A��# ���<�kc)Q����yn�����ya�������:tq�9�g�{?��;I��5�>ׯm� �S��մ����V�9ʮA �O=H�/�c�.i�%��'w�z4�Xy�� q�-��q�i����5-����,O���>�c4���-/.4�O�;���H��q�<�õyt$0/��`u�%̹�O�<�ؕN�-���� x:�úĐj[r� �c�#�dS�JʁS�n8�f��3��Ui��fX���<zv�yxPe��
&��v������W��H�~eu*G�:�Mj�hXhR^�K�yFUUK3 2p�<�ճѼ-�$�U�In�Vgu8�R#��On+NR^��G/���v� "+�R���O�R�˨
�&G� #�K�����X��5p�w_hY4�h� �$H#Vx!Ǿ+��L�M��}ަ>�wz� D�F�0� c����V�s�y��[u�� ���@�G9����G�Rn��C���פE{
�Y]s��`�}�<� �5���f���c�]T�eO�ԫ��4G���$)O��杮k��R�n�1G�<QWw'ڹj��ۏ2�5\��:օΗr5Kt0�8�'�SҼ����2]�PME���c�g/�m�J���qZv>)��y�u6�H�4f ��
�Ңp\�=��?i+�s�|#yo�%ί��;˦��aUT�Wx�U@�s��2�5C[�$�� �n�DҠ��:.�X�9�G�<��J���� ���Mr��N{÷v�j��Ac���"H�fY =�n:��_�|[�xr!o�k^E��N�Է+!R �������5�2�� {��#Ǒ�d��O�.��]D� �b]�D�TfP�N�O��j���7���+���X� / ��Tp}x\��z�nJ��9�f���z&���a�u�:�u���ΰ�����J����у����x��*ym'P�A#E �N�(���{g��g-����s6���tԄ����˖�|���8�z�R���8��ҰM�:�j����e%����۞+lc�%s�x�
�m)u����O�숩�,)���J�0K 3��T�2�{�A(Faʟa\�Ԙ6���˴�D�c�r \��<V��.��xVqgs�E�����*����=Wr��y�k٥�k��9ۘ�~��u6Z�ʹ�Oj���q�¸���Vl$k��|�W$P|F�GY�]:0��2�KY���fH<�籬�Z�'�rO���F���R���qlGn�WP���PW<ׯ��=���s��f\��s�i�
6���� e���H���\� ֻ]cV�]�Sΐ�q�H�7n�p:��.�|�%�<�ϡ�>������LR���63�k��_�=�{W1��7�[��M.bL��S�e��{��b��[�{�n�� x7N�-"�GU��S
�?.@��
�B�f�[�-�Ά/��n�.6���;~<��f4��Iߗ�=,F
�.u��~?�z��ك=��2+�4���6G�S�^^xr��am4lQ��U�:���z��}n^r�={��%��m#���;X��a�o*H�tdn>n�!���_į�אh'Z�\i�F���GS%�8/"�7'ʹ�# ���rFNO���P�ֿy�|�ݟ�4S���n����5������^�V�Fo�ڊ<w��U���� �Xc����W��%G˖�y��9��
*���-npz�五f��۵T*��ڸ[�WK��%K���)��x�V�2��s�H�ֽ�1���2���[W�Q�VM#��u+
2�v�e�H*������ ��zs��9��$�U���RF ��C+F��s�~]i֑����#��>{�=}��k���s�kO[������G�� 0?*�>��Y���K��i�h#ŋ�P��1�ܒ2�WsG� �A��J�)A�3t��u� �[_���>
����Inl-RE��$�Y�0���.;��wu���tє�]�vѨ�'{t�5���z*��褒/XG����V(d_Q���\�ؾ�n�N�D{����G c�¸[MY���ʞ!{Y��k[k�..)��xS��oֻ_�yt�[��$�)�A �C�{�� ���α
�H�->]��\"�_j���mMr�)+�GO��s�~%��Im4�
,�2���>���5ja�H?_C�1t�Z�)y�\���ǧ¤*N%+1$ǎ��ݐH��+�[�%��_���b������;،m(��j��8� ���N�"�n'M>;��݈����oBz� ��+м �/Y���_�[����ҹZ��2��xռ$�<K�9-�2�F�g��G�y�A�aYZw� �
��v��h�QM�����2p�'UiTiS�
���6�%v`�#O�:�u����c��k�P���V[��k���#�l����L���� �<����y��H�O��U�!���]álv$m���5i�,�n��mv�#nrq��8�9���o�S�EX�M(���'��H
�c�B__CY�e�2��$ �u��Õ��\0IL�H���ҙ�ax��r0du8e �b=����N�K��|I��n~˭\,Z��Q�$C{�ڡn����<�[$�1]G�O��1���j6Q`�BO�M��d����n
e%��3�ї�s[u��xΒ�k�ˀ=h��3�SIX������+��� YCv�NA�ka-�}G"Y�k�dOk� v�"r���p;%p=5G<p����X�?�-�'���&�����D���#Q�ǚ-�z�Jܴ��� Q������>Z��z���5�Z���x��?��g/�F�mz��[;�m&��]:8aFwݩ[�=<̟��w�d�'�V�bVProU� D�k6��;�U1T����I��+�1�g�ʞp�p ؎EA�x����Ok�]ʹ�c|����9�rk�px|Er�J�7� �y8���J�N斵�?_���mt��e+��܌�'