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/SF267/215526.jpg',
'FileSize' => '407 KB',
'is_book' => false,
'keywords' => 'Soccer',
'real_path' => '/media/images/IMAGES DONE/Library/SF267/',
'path' => 'Library/SF267/215526',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF267/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF267/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF267/',
'file_name' => '215526.jpg',
'id' => '215526',
'sku' => '215526',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF267/215526.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF267/215526.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF267/215526.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF267/215526.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0607080',
'headline' => 'St. Patrick's Athletic v Bohemians - eircom League',
'headlineTruncated' => 'St. Patrick's Athletic v Bohemians - eircom League',
'caption' => '14 July 2006; Paul Devlin, Bohemians. eircom League, Premier Division, St. Patrick's Athletic v Bohemians, Richmond Park, Dublin. Picture credit: David Maher / SPORTSFILE',
'DateCreated' => 'Fri, 14 Jul 2006 00:00:00 +0000',
'ShortDate' => '14 Jul 2006',
'LongDate' => 'Friday 14th Jul 2006',
'db_DateCreated' => '200607140000',
'event_images_count' => (int) 21,
'event_images_count_text' => '21 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0607080/',
'w' => '1632',
'h' => '2403',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1632,
'height' => (int) 2403,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '14 July 2006; Paul Devlin, Bohemians. eircom League, Premier Division, St. Patrick's Athletic v Bohemians, Richmond Park, Dublin. Picture credit: David Maher / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/215526/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/215526/'>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%2F215526&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=St.+Patrick%27s+Athletic+v+Bohemians+-+eircom+League" 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/215526&t=St.+Patrick%27s+Athletic+v+Bohemians+-+eircom+League"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/215526/" 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%2F215526&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=St.+Patrick%27s+Athletic+v+Bohemians+-+eircom+League',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/215526&t=St.+Patrick%27s+Athletic+v+Bohemians+-+eircom+League',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F215526&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=St.+Patrick%27s+Athletic+v+Bohemians+-+eircom+League" 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/215526&t=St.+Patrick%27s+Athletic+v+Bohemians+-+eircom+League"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/215526/" 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/SF267/215526' 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) 1758103046.5301
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/SF267/215526.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) 1758103046.5205,
'_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/215526',
'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 ��RExif MM * J R( �i Z x
�� '
�� ' � `� c � �( � t H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �g9�֔�+��i�)����A=�B0�ژ�"ni�M0�R(�lc��K�jD#g��!�)6��U+uaN��=�SZC�L�!�4��O�4px�PQON�,'z1֤��ң�U�����I�M���4�CX�KqH�Zb)zRà✼T�d��j �ҤC�3T��FG��@<���jnH��*�fc� d�z]���x���oug��m_��n|��!��V��YS�sjt�Q�o�|,��.�Ě�ˁɂ(�\�guh7�O�*��k��s����~�5&��{.�u��[�?�ך�2s�]*H�~�)^k�<Y�mo����X�1�9%$��ⵋv�¤9v2aJy�@��� 74��)X,1��ښ@��=�V�X�!��1¨$�� ���=���X��I�Y��!�p����i뚵��1i�rNp7g¡�Q�g�uN����i�������W�h�MQ��a��_ri����|���qV�-4oim�x��;� ���< #~�ÏcЂ8���´�|��C�מ�߇��)YmnB�\@ܤ��z�;2��˓T՝�8 �,0�sJ[�4Xc �zk�� ���&�qM��r�rx5�8��=��U�q���e7h��.i�wWZ��;v���tR{�c�0PH��� �VqVGMI]��.7m����z�4�e�B\��N;c�Cr���)A'$�q�GQ��}.�&O�C�7�:�r��t��� <-�<�ͬD�
nM�&�П� ��Iq� �W�8��;��d�f��Қx�4�O=�z�ʭ��_�k�O�5��lEa��>��ϧ�M.»�h���K�W
���[��_�M`h��W5gh3��Q��M��,y�� �
��F�H�{����=
��/�J�H�fU9�9� "�,.X0���cے��>���f��!��Y�A�9C�
B�?"��B��^$,ğjʚ��u�Es'º�}c�7�$����x����#��g���^!��:���˦�rZ�G����z2��
uӋWL��th�~���9����<;S}����~���t g�sM"-����O �?kz��٠ǚ�/��e�w�B�/��Q��V�B�ģ~UɈқ:p���οR���v��n�hh6��w����f�� %���+'+B�La�S�謬��!�a�X�Ье�jD= ��9�VK)�L�B��#���YFz�ڵ%NZ��N"�с�+�ӯ�p�jǮV�9�Z�8�EXѹ��&x+��=�r�:��z����QE#�ܐ'������� �씔e�c|��g�:ŧ�5[�qȶ��4vM�Wp�8��TO�V�s�G����Ȧ��'���ڀ�z�GZawbE6@�?�(iu����7�-t_�g��"�5H~�q#t���>��{cڹ��ΛHތ�*E���s��2�!�ɕ� ��C�9͋��p��a��s���k�/���ے�;It��n��6�Isj�-ĭ��^~b:r�Rx�Kv��m�E��B���9S�zT-�5�fٕ��a�) �`1ڶ�v� V�ぎES^��P~�S��֒ܭ�v�=1ָ?��^��Ԯl����@$�̓ƬC�'��I��u���g[���
�����[�j9:�L�n�"#w�⟌0�G<J�L��m���Л6_z��eԳ�>ꩯ�N�A�}چ��ѳ̶� � `���[��H���,�y�\�%��S�<!.�\��Z��k��o(H����}�bR����)���5gsf�F��0���n���݂��jf�7b]G�Y��ה�C�o,�����,W����%���b���t8�dt�ꢣ}^�5���yӌ���j�H�F0� �bsT��m8#����@�֛Bvy� vO�� �T+B䍚��*
5��>��7UF!`�C(���E?T,?�3T��,�C�My��j��=,
�eE�@��6���A'�\G����:+l�@�c�tOC����7� 'kN� �S�`�뎕j:^�q�wOl��O�si����O��݅��ѳ�R
�=����=��eY�
6j6Wr8H�sQ��w����JR=��+
ǥ��ʐ�3�C�\�sK��xOS�~�墸��9�Au�����L���t�[��K�Ԅ&!U!O�\�&*�M�;���۩��ܤ�����I�W/~<�&7t�W�'s����K�0��~�l�x�z��i�F3���MA{�]]ƱM)1������t�9';芽��;��̍�DE1
#���� /�i6_Ҁ�L�՝2��R�KKT
#���Pu,ǰ R�J攩J��8�ݗ��
^iZv���X��o˼1��.r����F��:�{�O���̍
K�F��FrI��Ы�X�0�Z-u>�;�GZ���%� ��~*�s���#p�9Ȩ�qB1����p�s��[NQ�S����KǓ&�y���<�HRY�W��� ���r�cY7#�t�'�,oz0��
�N�v��#n��a��cF)�Qǭ&W�h@���<A|a���
�.2�/'�v�8Q�k� n�����[G��f��N8�L/g2ڳo��`h�u"������H� ����?�ix��o��F�c�P��4��`v� �r��6�ϗ���5[淋�� �#��O�+k�f�S�n�,� 5���ҽF�Hذup2��CY�i�ЕՊ�ޖ�j2e�?:�_�
��
R�|����6� H��P)�+l�qS�b�mo!���N�H�r7#}=�L�]q�%���<���J�j�z�QӞ�"21G2�{Tf�1#|�lք1����`;-�M6�zM���&�����]�ǘ{�Ǯ9=O�t6��[�����>��w���d4�,E�^��6rF�H�9.G;��}W�~U�xoX�L�-u�%�cb�e&B
�N;�)da�ƕh�J2C�1�*u��=� �3����5U����7�g��~O��as� =c'c`�u����f�ڥ���9{�52@G9�8+��I�>�x��CC�)�t�Ij�#�m�Zia�U!#�ol����^+����6�|g�ə�e�$���-)����)a���{]��2�//�m�;���*����u>� Z�
�4m�7� ���PQZe|EJ����N�R���Y�5��1��F#s3` 2s��Q���\�1{S���s_,z
��xzdYgh�Ӝ� JӚp9'��rb?�ϻ�e���� 6r��~]܀`��Gpj�"��y��#��}�����|�G<=yr;4��@'