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/244393.jpg',
'FileSize' => '365 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244393',
'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' => '244393.jpg',
'id' => '244393',
'sku' => '244393',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244393.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244393.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244393.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244393.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Richie Bennis, Limerick manager, talks to Hugh Flavin during the game. 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' => '1646',
'h' => '1632',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1646,
'height' => (int) 1632,
'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; Richie Bennis, Limerick manager, talks to Hugh Flavin during the game. 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/244393/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244393/'>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%2F244393&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/244393&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244393/" 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%2F244393&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/244393&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%2F244393&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/244393&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244393/" 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/244393' 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) 1758090030.5628
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/244393.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) 1758090030.5458,
'_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/244393',
'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 ��3�Exif MM * J R( �i Z x
�� '
�� ' � n� ` � �( � 2� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �e2g��l�k�M�UB�>aY8�tݢ��77��9����A��4v$�2�r;VQ�)�̙
���Շ�M�+I���q�OZ�Y�F
�r���?6aHkW9�4�ȶ��S,P:�vh�<�=�ϚQ%��f� |"��L�mW$)w
�����5em {Su�� �Ypr:��-.lY�wn}
2��5�<i��r
!X���C䔌��sSizj�DI|ءG[}H��eu\aOz�+ �*�H�Q)(�GbI�K��;B��\Ӵ�;1"��b�^��Mx�?`��,OJѶ��-�G|��'��-4Q-{ j��Z+/m%ԫ#,��֛�F��+������K�\��=}+z?*X8Uu#�s�Y�E�ψ�@�����+��R.O��܉"@�9�4��UIn�v2kER�K)n� �o˸�@��*.3=%
�K�ޚ���Ӳ���=��\��i2�{<25�w�f.O�E6���?Ōs]�Ǥ�+Y�'����r$�1,p9F#8��V�$��#���O���6$�1���ߟǯzn��k���S�1w4|Ak+�l��N#�=�M�È��{E�z�^SB[]�rı�W�[d�aT?J�+֜���$
? �4�\1 q����ܓ�����l��RH��'�9����e1�QɁ�wj�$s1�;��ln�\��<�ڢQ�*.�CEq���Ðk��t{h�7��Z�̹+����l̲z��P� �8�H/i��V-_��i�Lg! R��9bG8��z{~�>���N�{%�M2F�ژB�S%I}sg;�Ӆ�⟀f��U��agq3C4
�a����B�8��j�0��#P黎C.q�TԮ�qi�ɃH�,�KGӴ�w*B�G�1�,�W
���ڽ.�P�G�J�4��Y���SEȇ{)�9;��8�z�Rwiڶ���Ԗӳ[�2��Tӷ{Vv�ũ �(A�TЮ�._C �E�oݵ���v�}�A���\��'��C���/��H�F�7�G5��$ަۓH�Wk?� �֓η�s��5��b�7c��\�[r�CKE��ſ�#ڤXU)��Y���Iݙ�_w�?�4��g����)pF0x��Y �{�����u=+R�_�*O����5��i\�=,A��_l64
�v�\��RA�K)t��Lʴ�U����沠'�^+��o�&���;+�C�c�fe��rje+�4c��z��uS�{C��w�<s�DB�#�d1$��W�O8�\���]7U��xl����l�?!��pz]��J��4�V��J��7t��?�I-&����zdメ�����D��ڄ�V;�TiWh�8�k�u�4��l�߳�x�G�
����Ѣur G�, Q�>�8��V��3�9m�
�
4�{���z\��K[�#����j��� ��
ֶ��:Z��-=�3�<Nz�S"�A^EE�6�j�ɟ|{J
ƛ 1���z�a�0�. �8"��J>7�Ը���a����QK��W!�)���Qr@�NK~U�'>���pӒG'�4�s�㚊vuk\
L
-2h/!�yE��N*�:�'���_^HzyV�� �u�V���������:'�ڍͤ��iq��C!2��V����O��jA��Q)dT����O=��M=KU4���+�n������I{�):+)1ylŋPC`���%�����gz�Mj705�,�b`v�,�ڧ81'��A�5W̚
�|�35�'.E��� #�ӴI.-l��[-7q��Dj��y� ��W<�$���sx~�O��+�� �Y Ec���s�����Ŵ�}<��-�-؞ ��3˧Eܤ,�ش'�C!A�Ns�gz��y ���:����[+�����I�|�bN1���3K��~_�oB��=?�/�8�V�X�C���Xv�K n����+��,D���=��M5�s�y����Dy�V�
���>��baS�u��;���h�#�$�<ȠfP�bG�+Bn�tċ�q�'�a�4P��ӟ�L'��_`s��Tၩ��Se��;�6E���M>���l�����A� ���+S��<E�ouO�ڢG��Z K+Te@�m(I'�����9�j�])ԻW$��Լyh�)�=>]Z��Un������|řXq"��9��d���|6�7.�m�����u,$G������Súq�zt�;05d�'g�gŞ(���MgP����a��fP��gc�㆑H����k�g�.&���y��PW>� �v>�ڰ�N�Ɉ~�R��{g��ߍ�<u��;d��.->�b�2��
�����@|/�x��Z�ͫEmoowI4�� �h���k�8Iʬu�_��rG7wi�xY��VH���Ƹ)�����q�~���G��6�?xw����ۆ;���BP���
�������s�O���I�T6���ga4@m$�N2�{�k�x�`62<<yqrO��Q��!�sJ����u�/� L�2[�ڹT�_��Ԟ���r�j�0D\���Q��#)X�00�09��*�~�]F�E4�\<��j(v$���1���W�Ď�^0*FG/�$�����V�c���g?�L��d��O��7�,,���n�o���8��ނ�!V�TF�Ԍ��*h�����
ܯ�te�wk�V�qo)�Ͳ�̝�z�����msZw��E4��e�V0�ۗ u9铊ޣ�q�������T���vs�S�q��1�Mco3n9���JŸh�T�8�V#�pc�"����祫G��˚��� d��+�T=���*���m�_m���]�x(�%`964���0o7�`���SP�|�_�����d����{.����SF�1,cVP�=���>�{אx�洎]:F}�"N���T�`�E�=솣�E3�~\6��j>�p���[PO�Y?C,`w2
Bd[� ��?�<�L����k�+]�.B1��`�C�>d?��6-Y��wZړ,�C�X���.X�*�dq�\�6^�w�{T�d�Fc�M�65d]�.�4P�I%�*�Vhǽ}q�Y g4��T�#~��AQ�b���a��W>!ڛ1��yv��믵<�WP��eC�H>� �4kK�:�{*^E��F��H��G�`�1ii����j�N�I���>[A|�k�d�p!��<�AӁ�Z����S�i���K3�N��#� ��r�J5�]۩�\Kq�Kc/Ö���3D����Fzܟ�˟�럕Lw"�˙�D+����T�����s�^��Ӕ���D�����r���^ݤ�Zm�����b:���L�Y\�N����U В8ȩ�S�o�bQ��yM�x���Z]���Oa�>���|J>P�@��=:b��ſjEv���`�9�#�T��{�ơIί4���;���S�>���M�)�X����շ��x�(�|i}
��i|�u'%bq�� ���{o�5ö�J&bFr����59�?�' z��V篺�,��$��7�cRB��l!H��Ǖإ-NUF�ۃ�UļtȬ�r�n_�S�QN˹:���>lgڨE3�r��~F�5��04��G�x����� ������57��$P0?���_Ҹqr�D����Dȸ,Y��� fi�����>�\ �����}MqqG���b~'��4n�G��(�F� #8��� }kXhlN���Ll�"`υ o<t��*�ͩ�v:��Ue�3�c�H`��$s���\�s��$8�z�]#.��F�V^P3���0��]tSi��](�.�灵�� �t�P���Ӭ�ݷ#��8ϭ{N��2� � �o����姘Yv��G����p��O֢U�6�n�9�S��ܭi�7V��&�LҬ.V�W33Ey ?w����U����P�&���.��=�xX�����U��j�)Us����hS�yw�I�*�\:w<w��� ��%���I$�@,�*d��`&��'����T�u��Nh?S�V�w�H�v����_���H
\R�ų��Ɗ&���P��i����5_��������?*�EF+�T��dP�\+�ZaG<�@���y`�� �cwj)F���K8lP` � �q_d�r���7�RU%ayF>PO g�?�
��!i[��zj��/���<�T�R�I�h!#Տ��2*�X��p'�\��(� ���o�j�[,qL%vV|W$���q����j�#���N�I.�=O�8Ū��C�F�%��E���=����W٣�����!L����.�ۢ-�7N�]��F���V���+u7���jH��<�-D��Я�#��ǒ9�@ϯ�����4={��ݑ*��"���R�ߒ=~�5pu����jS���n�ᇈ䝭�ī����+�����s���X��ßi�����c�I�&��q�`70s�ǥ:8Z��j�2�BjWz��F�
��z�����"?��l��1���*�~��=� rq��Wl`�Ĺ��~��I�Q���{X�6:(`y9�{L*.�\3�{Җ�h����Z��J\9��H5�L��aY*q�[���u-Ao�I��${�F�!�M�2#w�z'8�;����v���lC�7��.u|�wӚ�ӵ��{/��m�FM��c���.�9k7���BWr}�%�(H'ҪH�^���B.�ז��p��Go^�~���z�&���r�;A��})MrSr�v�.� O�{dz��,:�������-X��yn@�� ��O�W�W/��䎚���C��Y����hWR�����1��G�'�彫�m�}3S�om'q
��n��!.*ǰ
�=�=+їs�i��e��4�m<�����g���F|�9#��y��c|Q�bվ��4�l�YU��o̹��?���ԯ#�+��;� !�ʗ_^���*O#��ue����a�� ��_���#����+��Y���B���t�R�8J�c<�����S�hGy�@wd
��R�2[}��c4S�
��<}sU�+*��s�ʤ��A��A4�+voj&M�3�1�'үx#\���{+�1�+�W�B�0A��+*�獑�ZQit� ��x�B2X*�;7�$��uh���͂����"J��M�#�#�,�����gTk�?*) ~�&��Ѽ5�xW�(d�]6�9?���#-���=z��Xb\���'*t���$���n��yZWՉ'�5���-��H�#s+P���W�wbmʢ�iss����*T�k��jr�:ۼ7 �R�#o��8�)*r=;Gdڶ�"���xѿ�(��L�U�Hc� PP��z~���y�
RI%P�L�N?u�_Z�颹u>N�ִ�/����Ʒ&C�2� ��3(8���5��8���� -o�/-�A�T�#��;r:��p��˞���[���68��@_F:���-fu�eo�ZX�0l'