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/SF201/180350.jpg',
'FileSize' => '313 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF201/',
'path' => 'Library/SF201/180350',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF201/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF201/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF201/',
'file_name' => '180350.jpg',
'id' => '180350',
'sku' => '180350',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF201/180350.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF201/180350.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF201/180350.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF201/180350.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0506117',
'headline' => 'Limerick v Kerry',
'headlineTruncated' => 'Limerick v Kerry',
'caption' => '19 June 2005; Mark O'Riordan, Limerick, is shown a second yellow card by referee Eugene Murtagh. Bank of Ireland Munster Senior Football Championship Semi-Final, Limerick v Kerry, Gaelic Grounds, Limerick. Picture credit; Ray McManus / SPORTSFILE',
'DateCreated' => 'Sun, 19 Jun 2005 00:00:00 +0000',
'ShortDate' => '19 Jun 2005',
'LongDate' => 'Sunday 19th Jun 2005',
'db_DateCreated' => '200506190000',
'event_images_count' => (int) 39,
'event_images_count_text' => '39 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0506117/',
'w' => '1407',
'h' => '2023',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1407,
'height' => (int) 2023,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '19 June 2005; Mark O'Riordan, Limerick, is shown a second yellow card by referee Eugene Murtagh. Bank of Ireland Munster Senior Football Championship Semi-Final, Limerick v Kerry, Gaelic Grounds, Limerick. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/180350/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/180350/'>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%2F180350&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Limerick+v+Kerry" 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/180350&t=Limerick+v+Kerry"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/180350/" 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%2F180350&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Limerick+v+Kerry',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/180350&t=Limerick+v+Kerry',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F180350&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Limerick+v+Kerry" 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/180350&t=Limerick+v+Kerry"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/180350/" 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/SF201/180350' 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) 1758134973.4391
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/SF201/180350.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) 1758134973.4315,
'_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/180350',
'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
�� '
�� ' � � � � �( � -� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ������]�31ڢVe�j��^������0M_����xJ�vm sKR8"3�c���+y��vɇ#���f�Q���Oj����r��t�t�t�"�� {S�����$^�t�=��zV��ԗ[nnW�Sw���kB-WY�IR��!�dv�M+����a�H�*O��lc�NF��ٚT,����K����v��D�'�n�k�����K��LWG���{�J����Qԗ1��G��X~����Ƚ:VG)��ԁ�%S�FEW�����T�Qy�Q�ٍJW-;;����N����W�4ķ�pn��zV1\�ң|���m�������y�=���+H���3�V��SIl`��dї��x����c����I ���mԩq�V���J�-��`�߷���B���i:E����!��f�����D��.dr�(����t̡�O|T�����(0U��=���?v���_ �q�c�6B��L�y�F+�&��LU����O�v(��zRg����,\��M���� \Dі隥5-N�Wk��T�T 08�)�O��&�aT�%lv_m-u.�M�lR� �* U_�zҾ�˞��%�T�k?�GJ�_�\Piud~��r� �jw��/�IP�J��v���}ONR�b��c^4v��I^1�u:^��Z��^�\�&�o�
#��5���ܺb28"�=9M��>x�&�*[��I~��MAR`'-�[殚�d��N���v��o�%Jѱ�~ǖ���~�+&r-ϕ�F�e��;k[Z�&�t�r�G�k���.z���q�e*��O֡�6��5�1�u$��x��s�٤��i�<��:S�D��n]c69+�N�G�H��MŸ�IY�qE���Kգ�X�9�?�j�G2�@rs]�qrF�d�coڶ�#�%8��X^D� #���q�+�����q��G�˹�/�d�W�$�*�:-Οk$�x �_[8���-�v=zp��ZX[���,���zWM+��[Eh�ˌ�H5�F���S
��N'��T�)0{Wb��_�.�-Ϛ�X �(�̝jX��m�2K��i�^:���\���d�/2��/�L��.>�
���@�+���2V���[�j:m�s%�0s��PjZE�q'�,�؈ $�c�Z�^霓z���?h��6�ygy<�p4� &@���<�P�O.���>�������[x{F��D5֝i��o:0� WG'��
����s�P�d�?_'뱮�q�3�V������~'�X/-�V\��B~Yco�C����@<���Y�Rx̊���H��^�N�!^�i3�����z5
*u�[7��$q� �$�]IJ�"���+�x�%���E��v�Q�:`�S��91��E~sZ*X�J+v�N��I�<��h��ca�y����ei7�C_�U�R�Z�#ό�rw=�§�i�ث ��sj|���e��|�8
���+4�4"�J���]|���:����+w�,���9 �����^/��tn:��XQ����teb��ht�ρ�o��Фm+|䌅^��^���~&�>�[Ф=��̪�|�OH��on�јS�➝M0s榛<��e����m��_�+b��c,
�W �CB�@@�r �f|>���Q�P��4����snńw(��F������^v#OJT*-����Sq�1�|`����/��^#���;y`���7a@v�}�govlv�RHu}�^A5���A#���0Xh�p��K��c6�D�Y��ۆ�-�y�1<��NJ���C{t����]�[n?��^�UJQ~g%U'Q4R���&}�5���rH��ٰ�q�J�c��b�N�g��Y��]&�Iyy3�_�2F�3�{��V�zP~G� {�G��T��1�+��fF=��*ǁ������H�C����5НK�5�f��7ul
���w(�S�Q�0�Ze�7�^�9�x�Y�
'���I'�D)^�F�߈f���UKyLI�=��s_f�<��w�k�Ev�y���O�+������hz8\�$��~c|���"��_H�5HY�! �n�n�Ϩ�ߧz�S�h�������{W������4;ȏ>���1u*Y�<sT�sZu�:_�t�ד��D�쥰C^�7��]1\j6�z��ut�$���6܃�3��s���C˞&��s�C��~��υZ�����O�77�Ǝ&�R��*3�l����9`(����xZ��N�� ���e<DS��D@�r
_���������3�V���Ci�^[@c��O�[>�g�t~Y�9�刨�e�亞��`|��
ݹc�~��c��|�=�Gm�b0H=k��%�osn�\7�'�h�z�;������RK�L���]m��ZM�V@�G�Ujr�:*����d�#x�N��e2�rNI��3W�G�CS��E�F�~���]�y6�C�=��x��G�T��J�T�v�k�����ާ=��_2����U�#4��X���@������㯵w��v���M:�26��
�ċ�Is�H���[J�!#�0;G#�����xOH�t鴨���V���w&6�y�� ��[;A;���cR��%�Y�8��ޫ��� ���;��G�����y���:��h�n���!��_>