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/SF189/173418.jpg',
'FileSize' => '359 KB',
'is_book' => false,
'keywords' => 'Football, Hurling,',
'real_path' => '/media/images/IMAGES DONE/Library/SF189/',
'path' => 'Library/SF189/173418',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/',
'file_name' => '173418.jpg',
'id' => '173418',
'sku' => '173418',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173418.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173418.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/173418.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173418.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0504068',
'headline' => '2005 GAA Congress Saturday',
'headlineTruncated' => '2005 GAA Congress Saturday',
'caption' => '16 April 2005; A delegate reads a rule book at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'DateCreated' => 'Sat, 16 Apr 2005 00:00:00 +0000',
'ShortDate' => '16 Apr 2005',
'LongDate' => 'Saturday 16th Apr 2005',
'db_DateCreated' => '200504160000',
'event_images_count' => (int) 97,
'event_images_count_text' => '97 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0504068/',
'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' => '16 April 2005; A delegate reads a rule book at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/173418/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/173418/'>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%2F173418&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday" 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/173418&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173418/" 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%2F173418&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/173418&t=2005+GAA+Congress+Saturday',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F173418&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday" 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/173418&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173418/" 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/SF189/173418' 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) 20
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) 1758168097.3927
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/SF189/173418.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) 1758168097.3516,
'_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/173418',
'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
�� '
�� ' � �� � � �( � )3 H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��,�d��=���ܙK"��I�[�s��b��ַ
��t+�5V���ӰԓBQPPQ@(f
R�[
Ħ�s���OlӴ��l�b����l�M�Va�<!����m*�;<8;�C�V��@~@d��xx�4i`��[�$�G�C:���{%�cа��yW�j���� ��~�M���
{"�UA�m��w"������]Y���xSE�4�݆Nf���v�f�J0��Nf�fmK�X�,���\��Tt��}��݁��^>z}�5e�7�S̮~4��Q�[���W�_?��j�):���i̡A�9�^�h8�4qM�v�Ǯxw�.��-��<0���f����4�q�n�H�H&b�D �a<�c�sҶ�N4�:��OŜٍ|E\:�RVW���H�Ơ4h��e��|�1�P1�C�T���i���L���rT|�ϭt�
�0�%�T��|ܪS�^j�����}�m'V�y������n�������^�W�(�-��rԝ7ɱ�|o���Z�K٤<�k��O��r{;ȑ�J�¯Ϯ[������W
���qrf|���{n��b��嶺���/�=j}��v�>Gk&k��˶],'�T�x^�T�:d7*ǡ<��U�J-�c8ª���
�Ï¥�i����j:>������Ё��?.�Fڭ$�Q��g��%�1�B�H�#������bݟ
�bO z�67��_i���pK������g�x#��70�}�x�Hp�a���Y���}qҽ2�R�H��mH�P � ^t"��I�36�T����/fO� .�?���} �a��r0U�`F# �b��le{�`x�ŋ��Pgҭ�� /t^y�,~��ס���yg�okZ/�`������~̐0�O
1�"��
^X��=��ϩ�U��h7����6�< ⦴Y�÷P� �`q�X���o�xj�C��M����G/����A���+؍HG]�5�N�8�*ԫ�T�-w���
{A�����/Q����^��8-�M��4�b���yg���P��a5�GJ�~�ɯ���F6��mK�|=u�jZŅ����,m R0I|d pz�3�E�Zx�E�JZz���%J/{|�����>�(�� � �U�pN+�<+�����Q"�Pg�k�c�s� �TvV�(�2,p�n�
�K�0jVV��A^UeZ.�Ό*�W� �!�R����2����5�W�/iW��3[^Z�ad-����^�*�K�����N�=Q�?�ֱ���j��\�� v�{��W��3�q�xB(��٨�! k�O�/h�����a�pμ'N��s�a�Ji˵��8=i��@$���J�����d֗j�6 �S�F!��>�b6ڂ0X�r�X�=I�sN�V���:��3Oa*G1B���N}Gq���� �&M�4=n��N��뒠�U�$�VS5�`�J��#�N/u��q�C��56��_�^�ss;)i�զH��n
pҩ[�? $��w^�O�����&�S^�<C�/����p,5JR����+Ϩ�,������ϋ���h�k�t'����_?��%�;O��p\뚋f[_�[���@'��]��R�n��?��pb�W�R�����EI�[}�i�w�-��]L�el_ʷ�\��nbKd*�O�8��L.������y��,�F���>(��x��H��dp�� ���|g#>�дў~Z��1�[5d�nb ����ح��R_2�Kt!:�p��龜���H�� u�/�I��l��3�k̊,dvb6����Wa���ܠ6w*FV����К�f��5X��3�9��)&���;�k�����"��,x�
�����d}ʲ�Dt1�4j�����V��.u)��?4�s�/��j��Y�u5<[GY��Aen"�0�ԜrO��Wg�º�VG�����v��b�k�_P����<6��c �����H9=�Tcr%+X�u�]ů�������&U�$�%R0~Q�ۺ���'IU^�F��������z��/��
�����@?�t��Y�s4X'ԮIďJҋ��D�ԯ�h���?jK�J�F ��+��X����C GS_E�J4��Ü�|�뱗�YZ�U�Y$1
���X������>���t��y�ێA��+����mE&�����[)��|�bK�g��d�;+��%Q��I�$y5���''�l���ٖT��OocwOm�H�����T����I���9�uV+�����M��lҚq2���֒;�T`1���+��V�?R����� �I#`�sЊ�H�?���,�T�#&6N����No5�W����9c^-��*ͬ]�L��)�GjЃZeU��g�1���w��S��w���[�uLK�;@~b?�� w���v�j�
�0 =�ӣO�����Mɓ�G��Wq#�5�Fg%��WzM�v�"����{�&)���|��9U?9��־���jzmͅ�H�\�GW�p ��Ͽs�Z��Q���+L�����gh��Z)�E`�� `8��
���-��M�]�H7�3��u0��*��t+4Ѷ��Ig'=����O�M��{��x�YX�*�5QA4�c��o��4� \�WR�N�a �UGq��� �y'ş��0�r�zX�wکlO�3�z�z��Uqv�����xg��;��\M�����r+2�'�v���t�5�L<jT��qu\(�S~�Q[Y�G � |�:`�I�
�<��/�<ՈPn2���|���G��c��<����j�[]����n��Y�&�S�$���A1Wb�<�>�hQj1�W�|'�d�w���J�� N~�1W�{��
7RMwGv��U��-����Ҥ#�2w��z� �<aᨓR�d���ܷ��x�G�����^
,4��G��殥��!�ZR�|�����:��8om�o0�c��
h��q�IG���=eu��Ck,
����a� �j���w��Xjw3A�����A�1�s���1���)5cj�MN�6.$��x�Lr�8>��6��j��ޛ�}�4eM9�6�\q���N�Ǯ��ݥua7f���K.1�GV?x�=>�� �J�&��.O��>�ޞ�ؖ����)Q�[����XuKk���ھ������Z� u&W��7�/�k�K
"i-4a�5�ݒ�z/�c��ݸ9�:��_�X�#�v�v�r̛c�B�#w��k��U�(-��_����Ȝ����_|3�>�m�]K��<��˜O�5�_�w��H����� 2$�e�����օ�6��R<*�Y��� O��]��=����cl�tB��x<�sE}
Xx5���b�Y7�<��*�
��NI�3l��Ģ����Wڞ�
����<�8�r�c��:״�o�
�����2�ɂ�@Ƕ�'迉�\N!QWz��<��{$v�{�B��:�p��e.�?/�F��H��i��1�^>�W�:�k�]�cۍ8U�-{�̑�BL/���;�����Kv1��x4���X�ՙ�j>&��w���S�bk�
_�}� LL`y�v:���{���UNڤc:�|�υ�������L�2�
�,\ov�26ރ<g�\������N�D�9��5a�r �ٶ��[lrZ��e�Oc�#�K�ۜ�FI�=��rG�Z�a盉��p@�� g }77''�>��$���ެ�Z�N�@2N2@��R=�=�:;t�7O��x㴍� m�OM��gӮ{W�x���kJ�0�.<�v��w�傂\�g c�Q��mF:�*�J:�|�����4��Ie��Wh� [(��L��'�ot�BV%�Ȼlq����������G��Q�j��u�� ��摮���֦�������D H��@�Ư��'�7�
͑��H&�L�X|�2�2?�&�wG���F�5?C���%�L �T�͜z�E~��c�,#m��8�:u[]NR��c�
���W�֥��۴�t��ܚ�n�+���� �K(��Q���?�'�~��{����-�}���9�C�5��*{Z��>�K��QG�x�U�$�m���0n��:w��`��u��K3��DPY�= ���餖�=Y7"Υ��j��~�d��wN�I#�9�+&9n��b�zd�+hǘ�NSw�Z���Y��6͟��R~\d�x�_U�V�,�ء�B�D�N7� ��ed����NLl7����]�d���ۤq."H��91�?�j����<J���Ǩ����1YX�����h@@ ���w��-��HU���*���� � �n���LWw͐�2���G� ^����-�<���+�$YoF@��Q� =O��<��sZw��iv�1i�6�̍��3��GL���W��RQ�Y�������'�����S�l4H��à܌�����\���E�jSY,+���
�FA?ұ�1�)��:3J1s���(���6��|/֮��~���T�>�qy{�Ol�x��=�i��e��^���yOs�I��j�\����9iFO�[��4<
�"��z������n�X/Ԗ��^�i�E�3K���|@ln��3�?� Z����Zo)�ӕ��ǚz~U�DN��ϰ뿀^*��k��CM�%�ʼnʻOxsM�Ɛ֖X��E� I�#
)� �Q��y�\V'��]N�Ƨ<��uh�L�
��=k� T�%�pH���=6�`�͓��e#9� �� ������yo
��l�F���ӌ�����.�3i\�[��ծZI~� zj��d�eY�C�y��_�Gz�QG��6z��,t�f�����̪Ǿ?���,��������U+"Ļ��p�
���qMݝ�����\1vb�{��A��A;I�jH�!T��l�Y���Z��q��g�7�?v�~V� d�ކ�*엵�w��n�� U�A�'�n�pd��^ׯ5mU��|��� �Py�]��zhPu�Gc7++�.�0F�����e�2�p�_�j�|%�߄����BV�s%�ꑱ���J�H���*ϥ�<�^a'�����ɼ_�t��:�4,�2��+��?�s��]M�c-ѳ��dm�;�:w�Jr�9E])nwc*ӕh);I�oC� |1�^t�~�gb,m|��3��Lm�Z�o|:��_m��O�� �kl��K��H�t֝9�t��桉m%k�T���`����]ߕ�q�X����U��E{8<"���~H�x��5m_�w�4�_�O ڣ�~7�[�p֖3�s1���o���[�&�-�3�}b�K&�
�$�=�#!}yc����T�nV��T���*�@��ְ���qg1����"l͏�A��ֹ�5���'�c�םQF����x+\���}�ᷦk9%p웲T�sڭ%a��K�['W��^���7�-Ys�ۃ�uP�S����D�qa��Oa{�55�"L1t�;�8B+�;��G�2���v�#�;j����4asb�O�YV�xv��@�% �H#��y�ҵ$@d*�`�+�s�1H��|Mok'�mMpGW�Q{������,������@Ґ�*�Oo��i�嚶�Jçw��ɥ}�$;��o^7���=���N�uH�+y
̃"%�W?�#��v�K���9X�x:�\���-��@
��m����Tz ��A�N���mN�%b]�r���֎>Xx��)�՜5h�wi=;�>