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/SF326/RP0037195.jpg',
'FileSize' => '566 KB',
'is_book' => false,
'keywords' => 'soccer, Rugby, Football,',
'real_path' => '/media/images/IMAGES DONE/Library/SF326/',
'path' => 'Library/SF326/RP0037195',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF326/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF326/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF326/',
'file_name' => 'RP0037195.jpg',
'id' => 'RP0037195',
'sku' => 'RP0037195',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF326/RP0037195.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF326/RP0037195.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF326/RP0037195.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF326/RP0037195.jpg',
'categorycode' => '1RP',
'moreimages' => 'D0705164',
'headline' => 'Lansdowne Road Stadium Demolitian',
'headlineTruncated' => 'Lansdowne Road Stadium Demolitian',
'caption' => '17 May 2007; Mr John O’Donoghue, TD, Minister for Arts, Sport and Tourism, centre, with IRFU Chief Executive Philip Browne, left, and John Delaney, Chief Executive of the FAI, visit Lansdowne Road Stadium before work commenced on its demolition. Lansdowne Road Stadium, Dublin. Picture credit: Pat Murphy / SPORTSFILE',
'DateCreated' => 'Thu, 17 May 2007 00:00:00 +0000',
'ShortDate' => '17 May 2007',
'LongDate' => 'Thursday 17th May 2007',
'db_DateCreated' => '200705170000',
'event_images_count' => (int) 15,
'event_images_count_text' => '15 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0705164/',
'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' => '17 May 2007; Mr John O’Donoghue, TD, Minister for Arts, Sport and Tourism, centre, with IRFU Chief Executive Philip Browne, left, and John Delaney, Chief Executive of the FAI, visit Lansdowne Road Stadium before work commenced on its demolition. Lansdowne Road Stadium, Dublin. Picture credit: Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/RP0037195/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/RP0037195/'>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%2FRP0037195&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Lansdowne+Road+Stadium+Demolitian" 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/RP0037195&t=Lansdowne+Road+Stadium+Demolitian"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/RP0037195/" 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%2FRP0037195&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Lansdowne+Road+Stadium+Demolitian',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/RP0037195&t=Lansdowne+Road+Stadium+Demolitian',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2FRP0037195&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Lansdowne+Road+Stadium+Demolitian" 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/RP0037195&t=Lansdowne+Road+Stadium+Demolitian"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/RP0037195/" 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/SF326/RP0037195' 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) 5
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) 1758090527.0272
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/SF326/RP0037195.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) 1758090527.0139,
'_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/RP0037195',
'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 ��4�Exif MM * J R( �i Z x
�� '
�� ' � �� � � �( � 4 H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �1��NHڭ�YN���3� �;��6��kXE
�Y�ݱ�Nki!��cm���q������4m,tG�KI7�e$���C��^K�J(-m�e@V9 �?c�q��<�N}�4Ϡ~ ZZ��"��Y��W_�ܾs+��{��
-5�V���V42c;$��C��r���#�iGރM$]�_�2��^�#9�Pҭ�3{��PE PMV�;�m���ɟQ�}�pz�_7��}���� ӯ,>�!��y�TQu�YT�b��%_���<�Xir����R�e�{֓����V���gc�%3̱����n>�?
�uό� ��wz��#m�n�}��pMw��¥���:�e
���^���9���t{
62�p�<�P�����x�]�b���^I&��`;yq�S���c*�إMGY]}�O�����z*�1���GWr��@9'�ڊ��RZ��Z�X���BI�@��#�i͠�m���c�*�֡�Ӕ�="�o3?�LQ���a�,@'-��MO0Y?�4(��0M{9��T�Q���}��죊���+=.����� ߧ����xN�������s�$�p��끴�<7s�^��=K�÷Wn�h'�%�p��!+����5Ӈ���+h�� �GF� �?�Z֭uGdC�(� ��I {�.���f�]�tqC�vFA�s�Nj�� �G��p�w$^j�����s�=��G<{�o#p\���;�Ձ��o�t/�Ő�{��`=0����+ž"�?����-X�pM�����$��d� <�>"��FƔ���s�$����x�O�i��0�p���� ��j��Rfe�(c�h��~��%o����A�$���{�x�Ҹ=r�n���2[�° g��z�ֵ��JO�o�ʪqJ��Zv�y��k��v�-2�@���s�8�s���ԭ�U�vFp��Ԯ5EV�/��l`�=zsU���^�Fy<"��<zVvGcc�&������v������ߘ��{�+��4�n�!D�Y�~X�3��p��:^�O���ZH�>Tl�L���jߋ�I�|=��R��u���ɜzooE��=Fi]��jr�<W&��>�cw�L�Q]^M��� ����0: +�4�t�gHY4i���F�xF������%cOc����#�~ꍩx'J���B�m�H�v���(�VnQ�a]89�RDp=�2���c�]Zk6��Y�1�'?9g���?�:Ԛ�Ư�ݛt�{�8�!PW?R~��/�A����8諩�����Y#;� y$�[9Lzm�pA��
�ߏ��ׄ�M:��u)��Kx�H�d� $�`��y�r�&�x���Ir��\�� K �A���W�k�3��[mL+i��p��Z�@��A��r��p77��/ʀ��߇�4����%��t� ��ww�n�
Y��3�z��5��
�?y��
Ag���������iC0 F`�
=9�k��%u)=�#�vǰ��8�?C[����Q�J4~3�$�ʖ�����#�X6{0�A_;\�:D� i�D �"��dw���W����6ީ�:��J+���~ ���ֶ�n$wwܮѷ�3��1���-k�����/1�r�����@�+jk�:�M�K@Mn�.b����lU@T����8'ϭ6E�r��-��E�ٽϞ|�%�J��s�ZдӮ&�^)����-;�\U#�qU��jߙwM�m�)ͥ�A]�?ٜ��@��ҺU���� f2Mc1��C�����i���q�ZR�b��b�L}�ROOOz���:����i��U���f�4��8Nc��l.c�9���e�D�D��,�Q��z;[)4�{ux��,����02�`c�:xZ�V�U��,���� dy�W�;s�ʵ�;�)��d{����]�G���ʪ��`6� 1�^�u$XK;�U�oZ��Vr����G���f|��H�6����%m=�-o���p�ܩG*H�+�n��z��mWWW���� �Ì��Ƴ����h����u��c �V9'?����Q}>�\�U�6�ʃ��w��RfE�{�/�P�`iP;1S��4xϧ ���?����������Z5������r�pT `��둟�Z�M!�����
�� ��æl&��I]x�p`� �1�z�j�j�t�n���"#u�V��q�n��Ҫu� �=�p���a4?����8"�Z��XI{q"�� c��ϵz_�� imF�Sg���W{ͦI�#��n'��~ѷ����4�4x��^6�7����E�/bkv���2��ΌX�� m9=+�}j���I[K[rK�y:��;7L��a��aV�58���iR���lQ���Y�r�K��]��K6�����Ȭ�G`���l��G#�֯k�[[������M<�{����a�)��s�{QP�4�kdxۈ�O����6eA�>��bˊw
��t�ln�<Mk}�+i�O9cE�3�9�����⛖��xj�����\Z'��F��q��q������6�o�? �X�4�K@@�t<W���T�C�<;�G� ]�Q�Tћz� ���渏�w�Zd�3Y��1�bx=@��W�!T�:�����];Q��d��;�<�+�,�+گ|yo�_j��u��Q�V]��S����9��Q�s�k����V|����ߏ��^���O�cim �
��ɀX�&z� g��Qu
&+Y Y�V�
�/>�G�j\��s��T%d�)�c��Xf���m(C���۞O�I/�n������e�Q۱�%�'��s�n��dݥd�>ZpR����ּ-�&�nl�e0±�ے�F[+0ۃ��}�=�WK��m�m�Q�[Kȑ��������NT�y��'u���j�Ku���� �.SZ�}��Pf�����)R?�UX鶖b�,�\��>��\��J{��,5:+�9oxZ��k��$�H��K9���������n['� `���r}O���k&�<�N����}���j6O�/��rPbD,H8�=r=���|�U.$q����":�9�N�<�+�����n��aa_�4���#��LӮ巉&�y_7��<�鴢��G<O�kR��im!K}=0^KX0�i�n >� �k���:�$��ןL�48����ݶu46n"�P>��۽QR������%?�]>K7x��m${���= .pF9ϯjm����F�a���{�D��XQ�̮Y�w����{k�6H�Ku��?�
��ۊ���6��[j���#���ӊ��ަ�*+C����
v��F��vo~V��6V�߅f-�x.����L�!���eV�ˏOj�e�Uo�f�Ү��ı��*Af݀�gG$TN��);%�2�ݔ�Mu�x{P��F7�vڐ���U8�V'�% ��Q�c��<^]��zϋ5ƠZ{RDV�cz��!ǩ=�J��W�_�W3ĵ%����*�[h�ky\�&C��皗C��6H�)*Q $��x9�kȓmu�ǝ�)v=s�wP�|z�����<p�'��wmC�$zsW$�n��[Cod��1�Ye�&^
3����r��7�ވ̺��o$��m&�NZy��U��K��8�'8|�1��h��-|�1W��c�'<s�ְ���e��on��-��7�1Q�� �q��5��F�u�� ���\�٣���I2͝��-�yr7
�A�}y⼳���_���K:�[��~ ��Uᤔ�3�E[cg�A]Fk�y��Q�!ټ��d���;��'�t��5�d�rʫd�X�=��� =O5�ݤy��Fe��a���-7���v|���=s�c����̼ћ�q���#ȼ�|�#�@ۃӽ=w��vX�Q��XY�f=A�G&