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/SF289/227646.jpg',
'FileSize' => '596 KB',
'is_book' => false,
'keywords' => 'Hurling, Shinty,',
'real_path' => '/media/images/IMAGES DONE/Library/SF289/',
'path' => 'Library/SF289/227646',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF289/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF289/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF289/',
'file_name' => '227646.jpg',
'id' => '227646',
'sku' => '227646',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF289/227646.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF289/227646.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF289/227646.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF289/227646.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0611017',
'headline' => 'Ireland v Scotland - Senior Men's Hurling Shinty International',
'headlineTruncated' => 'Ireland v Scotland - Senior Men's Hurling Shinty International',
'caption' => '5 November 2006; Ally McLeod, Scotland, in action against Ray Mulry, Ireland. Senior Men's Hurling Shinty International, Ireland v Scotland, Croke Park, Dublin. Picture credit: Brendan Moran / SPORTSFILE',
'DateCreated' => 'Sun, 05 Nov 2006 00:00:00 +0000',
'ShortDate' => '05 Nov 2006',
'LongDate' => 'Sunday 5th Nov 2006',
'db_DateCreated' => '200611050000',
'event_images_count' => (int) 12,
'event_images_count_text' => '12 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0611017/',
'w' => '2671',
'h' => '1877',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2671,
'height' => (int) 1877,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '5 November 2006; Ally McLeod, Scotland, in action against Ray Mulry, Ireland. Senior Men's Hurling Shinty International, Ireland v Scotland, Croke Park, Dublin. Picture credit: Brendan Moran / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/227646/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/227646/'>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%2F227646&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ireland+v+Scotland+-+Senior+Men%27s+Hurling+Shinty+International" 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/227646&t=Ireland+v+Scotland+-+Senior+Men%27s+Hurling+Shinty+International"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/227646/" 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%2F227646&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ireland+v+Scotland+-+Senior+Men%27s+Hurling+Shinty+International',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/227646&t=Ireland+v+Scotland+-+Senior+Men%27s+Hurling+Shinty+International',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F227646&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ireland+v+Scotland+-+Senior+Men%27s+Hurling+Shinty+International" 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/227646&t=Ireland+v+Scotland+-+Senior+Men%27s+Hurling+Shinty+International"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/227646/" 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/SF289/227646' 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) 3
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) 1758068179.2984
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/SF289/227646.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) 1758068179.2857,
'_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/227646',
'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 ��) Exif MM * J R( �i Z x
�� '
�� ' �
o� U � �( � (! H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �gk:��Jz�����<�:@̲.�J#�,���;�D�d�~��B��J��T� �2�>�� 0a*�T�8ş�e_ʝ�Yx�wj.FGF�*���NU��\��|йч����3�[�nW{a�>��x��B�{q^L��%���w�i���z�-.� �ˉW8��O��QZDz���<V-熜[�FPNq�ᩇ��s0��,W��n��L�+U�5�k�T�~(�<��"�Rj��)���L?t�fK9W-����w��@֤䯥\���f���
�ƙ�$��w���|�D �V�T�3,CR�Ї��=���L?��z�y�5Y$O�g�Ts�漌�h���t�`��Q���M�.G`i6�G�a����|�\��$W�'��=%S�/�9�r2H����Mi�[ NJ\�9X�1�Lf�/�~,���������b1�y�<ps����������檮x��N�y3^M�^��1r�; NxU#�z��MzO�iyOm�.�̧8c�Kr{�g����*/Cҩ'%�sS��z,�ݗ7��An�4��F��ҳ���t-VM?P���x�֎T(�}� �ƽ�K>Vyu���;���1枓1R��ע�Ne^�˕�p��Ҵ<j�6��sJKڣE��BK+spg�OZz�� �V�W'R�&L8�?Z�e
LeS�t+1�_-�G�h��+2�,a��{ԻLg">��/�����7#��N\��8����aP���B!V���}h�ad=��ȏ��;
���O���q����"e�C�$yS��1��Zè8\�o��
ȁ�>�@��\���E��
�*�P�</��2��G�+�\���O<v�נ|5�g�<1��gT�8����"���L����p:BNsQ��^�-���> � ����t��&��{8�3�g�&�9�<W���^�to�Z�"��R]��0�1�+F�I�UO0������b�W&�%{�������x�b�*VI��|��:�8W9?Z�T�P:���Sm��:>9��<`���l�3ל�.O�m\��,��F��� Zә��"7*~�7�S{��Õ
'i����v�M������e(Q�Pjŏ�m�6�>��0��#cVP~a~u(E� V� ���a��:r�F �ߝ1(
�F���J�p�� Xqd{��ZǨC=�Qݼ� �U�3�U�9=28<�w�uZ崖�֒nW��jqZ6��O�K��v���J��ؖ �s�cҡ��a�?��
�hיh�]z}�Ո����9��^Z�Νd��;�-N�O{9�x����[��k�r����T����_l��~#~̓�x��x�e�u��h��][Dҭ�m� �p�� �q_W)�ь��k���|��'}����?YA�-z:mcn��_¨*<��笌��$
�MGö�P����N��K?�G%���.�Ly-���)� ���p�jZ+��毹���")��9��o�d�;rrk�v���]�6��5
J���$�\��� X��K�7�<+����D�c:ܳ�:!C�G-��;#ފ�����njS�N��Ac�o&0"��~M��8�H�>(h]p�E��a�����ϑ�@C���t���o�#�@b;��� :�&���.m%���Q�88�<�;��*I�8�Ŧ��e�I��Q�M���ɼ��S��Ã�˜q�x�*��!��Ú��6��>�P��{���Fɏq �$�U}q�C������r槳6��D�+?�<S���?����м��8������=*�r�2��t�m����
��Ue$[-�R�j��"��̯��kޖ�>l�?�|M�_�z-�y _:�ǖ���~�F$E{��&�%�Q��\��¬�,�pq�� 3)���Og>��8J:��j�'��9s+5��2�'I�� +v���-ݺ���W�>�a�Û�Rj�S^S�y��*84���X13.�V��F�`����]��:��{v�!YL��
���o�d:d�Hء��ʑ�qV��h�硆��JI�*���o�����o��pI6�on(�AB�k��8�IOݶ�Vў6�ۈ�A�����梙�a�&x����§S'�}Ɓ �D99���ޅ�� m��m�*_�gk3h�NIb*�q�)lP=�&� �GU��e��Q��.�1d8D!��u9�g5��w�_Y����?h��!*ppz
Ñ��u�j�:U=�:h�j���뺖����M���:� {h�b1���8 �z1��� &�<�F���T��O�s��o� zWN�۳ѵ�n�3|F*�5k�3��>1�ǿŢx�F��Z��-co3o2D�A���p@=G�����$��gi�.,5 �H�ex�0ݹ2@9![ʱn��=m�/��?����UcZ=t�z��o��7Û�_K���k�+�� e\�<�<d�+�>�`F9�uJ�-���T��o��
ђpi���rֽ�N�����gM��-��X�㨮J��6�E�e�<b��[�߮j��-�Ԟk6�����|m��!j�g
�M������9k����E��H%F�#�9�C!�L�ہ�c��2H�ۍ,fEm�i�C���>bg�����*A�!�w?#n�+<�v��M C)�,:g椷�y��r(��!�[vh-'�l�qƳo��ϵ,S̐]��*a*�w�叠�ϡ��BЧ�n�$�ao3M:�̱�q�B}sEJэ&� ��J� �=J�f�4Y7�d�jM�4��S�GN���0��Y�8��@۔X���<.ݠ��~k��Z�I�_g�b}�'�O��#&��kzlj�/�ѭl�x�SKu`6��$�Vq�N��� ������U׆��:��T�T�iW7�3\jN���Q��V
6�� �T�����X�ʿ��3�s�������[U�x}nB�N��vU(��p���?�=q�/�i.\��i)� ���;N{����M|�W�9y/�l_r�;��ô�In�y'jВE}�1�O(��Gy�{{�^ /m�z� ���5�kk���i&��$��N�|��6�E.[u0�[���i�4��w,����]�R�e�����UO��<�P�{y��m�k#��̂E�qSƩ"m9�@���m�X��*��@���M/!IH��*@��i��Bpr��Uq���L��"�\�R�0s�HE}N�R)!�U�<i��3�#-���p���u?�-����Z��b��'�� ˼�^~c_?'�*����̣�I//��Q�T��5g��K��a0ee#py��ϧ�t�S� D�[�/
��r�t�m�?02�Ӱ�+�iR�3{�,�)�.���]��L��a��89�Ӯ�;Ǘ����u{����
f*c#wL`��y�5����5��^1.x��?�#�a�g���O&Kǘ�Ui���q��f c���ڮ_j�l�Gq|��ͬ����x��Aeb8]���M|�K�ݿF{�y8�[����VU/��o�6�"\<Br�!O�[���T�RW �ֿ���[H����C��f�o~�����3��7"�=
�w{e�m×��G?����cb��KZQ���Rw�=PƲ�e�@�UI#1�w]" ����X��*�.1$d�?`�2 �3Qm��8�P���vU�+
�H��#�i
+)F�@�`�9;kkE�]B�^8�|�#aUG���q�5'�"�i$tÞ���jڴ�I&�.yȌ�E��Jc�!X��( ���$�=�p�^*J�UޤV�����{i?�B8$y}~����=y��!�
��7�L�v #�A"�lnh�>����i)���I>��X<w#L���՟l��>e#i�߷j�c�3|QMOF���n�n��%����C9�IR@S���^�
�*t��Jײ���x��ujU���?��w�č~o��$�tMR{
"�Kc�@&m�T�, %s�0q��|u�Xx�@:��/�8&a>T�zǃ��U���W�R���o�;�͞�:���o�䏏�7��s]���M�d����ZR�)h��C���4i<�� �;�.�.�2�I�q�kˠ���.��I��/�G��C�O��
w[Ӡ{�FWx��E}$�>^Q��5]F($ d�*w���zd:W7<{�������,�rs�Q[]�������!}�r�Nש�3�ږ{���A��=�;�Ky�;�Ȩ"�H�(w��{H���ضnbC�f�k�=�h�p�;��)����!_
ç"]��̗0�1����|ď����4�8��Ӆ�(������ŝ���M��h�j�fc�C��f�`͞+���o\x_H�D�{T$���i���� V-�誛_��>��Z� _ՎKU�> �%����"�� ���j~+ӼHt�kH�,�`�D�����F8�=��xB�ߓ4��h�uG�z:C>��Kf&\*1�W��s���0�ٮ->�&D���9��� k8���$xl�yu$�w�W2�ҹخ�듎 �ӵzދ������-x�"��R�P߽�7P6�0�~f�8�zU�������¡y���~%�xj��U�A���|C��e�4��|�5�\���uK��:��,�D�)���LJ���|S}�Tr��=[ֳ�\���^�Q�H��<}�MN�A����d+r�죘�B�7<�N�w���m�%#x#�/Ad�?
�i�Ϫ�����5��!j�[�
X�*�<c5�$�>f�:�&-h�
W�!&&