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/SF235/198581.jpg',
'FileSize' => '389 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF235/',
'path' => 'Library/SF235/198581',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/',
'file_name' => '198581.jpg',
'id' => '198581',
'sku' => '198581',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198581.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198581.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/198581.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198581.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0601108',
'headline' => 'Dublin v Wexford - Walsh Cup',
'headlineTruncated' => 'Dublin v Wexford - Walsh Cup',
'caption' => '29 January 2006; Eoin Quigley, Wexford, in action against David Sweeney, Dublin. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'DateCreated' => 'Sun, 29 Jan 2006 00:00:00 +0000',
'ShortDate' => '29 Jan 2006',
'LongDate' => 'Sunday 29th Jan 2006',
'db_DateCreated' => '200601290000',
'event_images_count' => (int) 42,
'event_images_count_text' => '42 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0601108/',
'w' => '2210',
'h' => '1553',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'True',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2210,
'height' => (int) 1553,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '29 January 2006; Eoin Quigley, Wexford, in action against David Sweeney, Dublin. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/198581/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/198581/'>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%2F198581&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup" 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/198581&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198581/" 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%2F198581&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/198581&t=Dublin+v+Wexford+-+Walsh+Cup',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F198581&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup" 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/198581&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198581/" 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/SF235/198581' 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) 1758127067.2623
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/SF235/198581.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) 1758127066.8286,
'_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/198581',
'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 ��2�Exif MM * J R( �i Z x
�� '
�� ' � �� � �( � 1� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��L�k�dF�W˓'��*ާ�o���jt�ɍ�>���=�,/cK�v�Lx��b,��4��r�%l���7�?��� ��?��$�M���&�+[��>��a��MJ�Yʜ�L9k+[�$Cp+|I{!TH�$��eʎ�qRWd���bǮ�R�]��L�1ǜeN�*-�"�Ih%Σq
Ǔи���uy$�9��\r�IK��R��m^�Iwi#BS'���Za-�
beE=�[�&�5i5��:l��/Ϋ��S^����զ����b�(����p��u$� ��֔vf��������x��#��umí��`�H2��:dz%� ��1Y�c"�����&�uU�����ׯ���B��l��#�v����k/W��4�X��'pv��=�88�y�T�|��ÒI^�$�m�9g �m>�$Ȧ�CW"};OzzՈ����b�0�9�F#Ԙ���t���k�Ҟ����^��F���sD�V�-��U~�,z+�C�S�����R���3�3�����D�Ia���R�����*)��W�d{X���z��|I���IW�����T�#��A�m�\%����bvh����#o}-��Q�ǵy���ά>�F����3W����1�q�k8
N�.��M�9ڟ'V뷆nk��GR�M��e�O1`��1�T��g�P�qP��k��܌)���Z��l�\�9�G��<)�ć�v�R¶���O �M�#����W-G���=Q�|U/��!j�'x�1}>b��Y#j)�(Q�T��� �ޡʝFz�Z�
�*�Z�����
j����vr͢��
��g�� �ls�;���h�+����[f��:���A_�b@��ʐ@�9��V���E�K�4}�v�����R�J������z�� �q�%#�)�@9�_Lx7"� ;�ҫ��L�aj��E7���g���������C�]���I�9�&�(���k+�_"���ϬZ#̠6q��Xzğ4p��FM:Ҽ\�J6v6�"��P���@;��w�K�Ŝӿ;e�tD�^J]�Ƴ�[naԖ�1��C
�t�:!�ʖ�B��a���d��6Xtݎ��)$I�\�&k��Ƭ\F�A �~�� �â�vWqO41����T�U��X��#p'�vN����L���H�M�;�={W�|G���g�v��~�'��
UR� �eq� �
[��c�떵�oMY3�t-2�X��M���|�d�(�1���c�S[��
�*�Q��Z5��d�������q�\��Qj7KD?b�5����D�nR<Ak,?�џe,�#�N��J��9#�>�H-��~���D���د���W��:�S��Yۈ�u)_W��J�X�ndی��<�"�I�ʱ�Nh'UL] [�sE$l�,h�ZⲎ 8�j�Y5-5���g�V�|�j�ߡ�o��L�ۀ9�h'��G{u�Ү�~H`�UJ��EF(=�`�&h�s\�%����]�>P�U�e�a�`O5�S��>Y�jRrC�i</4jܬ���Q}��3�/ ��W���y�[��$c��Vޑ-�pEL�ұN͇��If��<Z^ԭno�i��s���mR�B���ť����Em���2k���]ݼ��K���b����*��z��8lu����a���Kf��w�&����בk�����ڥ��^�;M4��ݎO�{v�+9�-\�g�[[��:�iר|W��<�M�I%���U{��Of(��My����]'L��Q�vAm��T�c� �P�,1�q�+�õ�/��4��-�� ���=�(��f7p.2�����>����.��0�H���$6y���
�FM�,G+����0�ڲe��C~o�A�;��+����E��x�dq���H�j.��f�f�f�bI94T��ƾ�"}B&��;��T�$V�!3�&�
m
����my���9�#���8ǚ��G����.T+*F�u5��]��L\�Wq�)���|-�1H���H�$�C{��\������'пn�'�n�WR�Aɭ�����{aK(��iG�y(�-�
������3�8��x���;����:w� ��E� is�4e��~�60uH�"�3��ʌs�?�K� ��ڿ�%�o��r�+�6Xd�� a#",���#��2EN����+�I�E�g�+qo(e��W=��4o(�x5�-�lZԵ{��;�8N�U�i:���XiZl
qu{2AK՝� {s��O�OVz�5�#�7��[�B��Iӥ�� _q�
�����^u��~91�⒃�y�sJM3�>=�7����R}��Dѡ�����4�\�$�z���w�Z�}u�YD{I�]�`�W�lc�8�Ԅf���_'��=
�Q\�4z/xc���KF�յ�2��m�a��yc�s��J�����t��.�4��9��ۿ<�~k��1�'�z�\#q��5���#�S�]�u G����Q�Z�t�3���}ϊ�{]-x̍��k�����ЩW�R�kGI�*�3��F�����f �R�L=�c�X �Ćخ/ ��Oc�{Z��$�k��r��cCk�;��%�m�5�i:_�5V6�8�N
�
kJ2�j$JJ:���|N�=̍v�O�<��<?�Nh��RM*��%fTd��=��NJ%�l�P��J��,M��R4c�U�-*�|~%���%��U���\ȯ�IF� :��OL[W��)4�]_�*��oe'fu0�Q�_��
��-����g�U�R@bH$l�9�u��z��r�0-�eX��G��yݎ�'�$WR����(�b�'�K�>i�Z�Q�'��s|���deq�#�.gr⬒.�
��E�[��*��� �:�� ���a��n mt�xk[c�����e<arJ:�}L]Ȇ��а�[hV9���6�z��t-2iP�{�[[�*g����W��r�2p^�\�o��_���TC,�HbeP �p~���y5�k�I��W�v�d]�A�<rp9瞄W�3u�ʦ���K��魏�ǥJ�#�ޚwןS��I:=��,�%�8H�|�q�v'�
ɴ��0M�m�Tl��q�O¾�O9��~��t�:�eyS�R��}Ʈ���م��[M�f�OR��\���h6�š\jw��f��r��������sӽz�����yr�s�س�P����MLԯ����mayJGг
3֡�n�gq}EXM��I�]����]g�y�d�imaS#�cvz�Q)s;��F�b{����y,FA��S�1U���Mտ�[X�a�C���YZԑ�r��+SD�0�iv�I=Ä�(�,�zB�8��O}��/���,.|?�C?�<Gt�8#����p�r@?p`�� נh�%ǃ��f��e�D�oEΘ�elP ��f,UF��
���<*b�����Q��A� �zt�v�&�յE5w6�i��2oN���'