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/SF191/175219.jpg',
'FileSize' => '329 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF191/',
'path' => 'Library/SF191/175219',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF191/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/',
'file_name' => '175219.jpg',
'id' => '175219',
'sku' => '175219',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/175219.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/175219.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF191/175219.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/175219.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0505001',
'headline' => 'Armagh v Wexford',
'headlineTruncated' => 'Armagh v Wexford',
'caption' => '1 May 2005; John McEntee, Armagh, in action against David Murphy, Wexford. Allianz National Football League, Division 1 Final, Armagh v Wexford, Croke Park, Dublin. Picture credit; Brendan Moran / SPORTSFILE',
'DateCreated' => 'Sun, 01 May 2005 00:00:00 +0000',
'ShortDate' => '01 May 2005',
'LongDate' => 'Sunday 1st May 2005',
'db_DateCreated' => '200505010000',
'event_images_count' => (int) 79,
'event_images_count_text' => '79 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0505001/',
'w' => '2321',
'h' => '1302',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2321,
'height' => (int) 1302,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '1 May 2005; John McEntee, Armagh, in action against David Murphy, Wexford. Allianz National Football League, Division 1 Final, Armagh v Wexford, Croke Park, Dublin. Picture credit; Brendan Moran / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/175219/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/175219/'>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%2F175219&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Armagh+v+Wexford" 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/175219&t=Armagh+v+Wexford"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/175219/" 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%2F175219&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Armagh+v+Wexford',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/175219&t=Armagh+v+Wexford',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F175219&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Armagh+v+Wexford" 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/175219&t=Armagh+v+Wexford"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/175219/" 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/SF191/175219' 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) 1758068023.7007
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/SF191/175219.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) 1758068023.6764,
'_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/175219',
'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�� q �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �i_L##�8�i!C9v��}��A�9
W�ېq9�s:��
��q�`f����=ᢁ�O�l��z�uX�eM�>������F�|�!��I�\iS�m�S{��i>��^$��&���[t��GR.x������J�G�5_��+�P�)��}��j�]�6���� \]�
��"A1 �R}^�C�G�E�`�W��JW����䘾Z�}SHx����U,�;�&� ������I��S��c��&J�����X��4��U�eo���K��k�f�rO5��{�5�|`��cq~��p+�ՍJV��>#�jjP�a�͟��k��8 �a�V~�u"Y�j�X!{��w�d��ד��i|�z����4j� ;�<W��H�WJ}��H�*��`��PҮ/>��H6��p7f������>��+,�ԗ< ���L/��h���faլ��WAq���qҡ�v�ke�f�hc(yS��Qx�E���9RT���w��{���@�<w���љv�f �B����]X�GC����lyT��tjƖW{�}�#�K][d��W�N��Q�X4m͙�qȢ��^ ���g��q���W2$����'��a�^&nT�85��c�H�r �8lz�7�+8n�4I]X#���)�B��:u�G�6��]y���e����.IY�mN_�W,�ZW�/5)56`cfX�c�@��|;᧴��rv�!X��<TF2�l�a%ԛ�w�$�M���\��}+�%�k���@2�N+Zt'%e�Ƭ��غ��{�@��� `z`׳{�G�3U��6��s�8�*Q�$���VW�:�-���]�r�0`}+S�ŭ��[��'��ǐ{� ��z�����v7���*x��?�:䚝�I����N��� /��˜�{�]Jx^�,rA#�mIƤd����ԍ�=?�x~��y0�1$��y� ��3]Z�r��U����Fx�*۫K]��I:r���������5��-*��c6�~�Q뺮���� �] pq��0��S�֚3ZІ
�9Җ�4��KCѴ��\܆�;�P���k�~ �~�4V��"�dĢ3�:v����#̌'Ԛ�hg����<0֖��WP��"u8���3�l-n.�ˬLY����h9J|�FQ�I���*���i�x}�;GI�1��pF}h��n�x��)tCG�2b�`�����c�J�B����k��>H'�VĎn+������]���[t[�@a�m � ��9)I��/4hx#H}_N��ث]�$c����s�e�Gqj�����9S����T��B�˥Gw�v�媖8�-F� U�HX��'c1_���zxz�pk�8��Ji=���զ�+�E�x9lg�k�����uXȊ�B�� �V��գ ��W�
���?i���l�ī�S�� �o�!�ѡ6����F>\lNp?�t\��3�z�#
ӕ'~ec���.���ڃ���J�����xr��[�C}�UzZ�0����8%RS����O\�hZ��sn�r~f�֢�O��m^���{H�O�b|�y#�TB0�N��3Ӟ%՟���-|�1���x�͠�(�e��>����/�@-����7=y�*
p�3՛c1�TR���4<?�_��K�A�` �z՟�:�jZ�خLL�7���V��R+k�R�5Mǡ�i{g�x�T���{x�c�O^�q]߉�(�.�-��
�݂7#��BҜ��ƥ^e
oD��8��*��@�ӯ#"����Ģ�w:RSWEdiJ�6�d.���u�<�>�# {VMѐ�8��%ul֗s]�ۉ�m�����v6�,�7� ��<�;�N{.c���:���D2!�p�zV����xt�խ�f�*>��p ��
d�]֨�\��O���<��������b��@B �d�s�^���f�t-J]N�y�D�Q<�7r���q�VSĺ U���w��ܼ6b+�*��������^��xO�1�I��BG$-��%C x�����o�_�B
"M�q�NC���X�ʝ����Fc��:�i�~�߃>{ӼE��o1gI%� Z�����]>kK��y��g��4bj9�ru-�w='��ڽ��i%�e��!d�ʊaФ,i�8fq"� ��Nur��z+*���~�~:�H�bh/��$�H;Mc���i~
��69f�r2��A5u1\�/df�U`�NkVq� -uM?W��R�3�ǭYm1�ũ���,���A�<�ڽ��s���?|
q=��h�VmgA��n��(>_
˩[\0�5�QX���Qz_���۱/��B����P��paՆrFz�o�n��#_��M�L"���ZҬ����J���>���8�<ϣ�\=�,~��� J*��_~+FaTi.V�T�b�\�\r���qSuc�)^EI����˻�����%kh=��F�1~��
�g��S�wE��/dS��9�8T�r�7�6��8��wS�Dg����I��&K��D�F��>>�t�\8{��ڠ��ݰ���lME&���a��d�I� ��G���y��˒X�<.��&HS���������h�|SEn�.dv�����$��bǵx��� '��>�"���S��o��Y��Q���_�Hd�̊�1$8�(#�`y���%�Xx��Ut�M�ڱ
�����tp�&�j��nWk�l�W��p�,���9sE�]������t.�H�i!�+H���0s�+��;�[Y7�y��1$�3�}"1��ݟB�qv�Mm�]R
�E�uH�V1�A�W��SYM"=F���^0�+ƫ?���1��V�Xu�JZ��;��-䔂Y���V��욎�����#�A �j�EN���8��
���mB�?�RcHJ�\s�Yz?�-mt�aEm��]�^��a��ۡ�c��'ש�o�3�Cwe=�6�'���|3���K�؈��O� v�b�����K�ub��Z�^�����-Q�pU�t'�y� ��g���ӭm#W�a9�+h�s��pb�_
YҨ� �N��k?�܋Tĥ�HÞ�W�BJ`�d|�X9ԓL���kP���3'��rq������Ȇ=k�����)�6�^}d$��_�� ^����ݰo� {դ��(M�!}����j}7��s`��&���`���
GO���V��x_E�}OS��h��O@�<� f����� v�-���-�P��W�,E:��d�����x6ᵿ�3�V�h�R�Y��Hc��8 t�$ H�<2�3�Y���c�d�� `z���7�cm�}?�T�'}W�f��3�5-m��;;x��$�T�0 ����v���U{�����$/��XE����g��,�����}�������1��`���O���N�3�4y�l�_<y@ݎ����Z�tM8�Gmv6��g��FS����B�������xvG�1��qyq�Y�Æ$��k� �O��?����g�i�
1�j�ӌ��3��j�8-�G�|l�_���i�h���-�� '��5s��Z��5��$c�k��X:��(�{��G�r�z�g5��L���F�L,�ʯ@3��j��� ���=��@�����ֺ�TU)��<��eZ��h��~�
�H�4���ZBb?yz^�a��B��Ϩ�,'