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/SF295/230344.jpg',
'FileSize' => '415 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF295/',
'path' => 'Library/SF295/230344',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF295/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/',
'file_name' => '230344.jpg',
'id' => '230344',
'sku' => '230344',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230344.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230344.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF295/230344.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230344.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0612012',
'headline' => 'Ballinderry v Crossmaglen Rangers - AIB Ulster Club Senior Football Championship Final',
'headlineTruncated' => 'Ballinderry v Crossmaglen Rangers - AIB Ulster Club Senior Football ',
'caption' => '3 December 2006; James Conway, Ballinderry, in action against Stephen Clarke, Crossmaglen Rangers. AIB Ulster Club Senior Football Championship Final, Ballinderry v Crossmaglen Rangers, Casement Park, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Sun, 03 Dec 2006 00:00:00 +0000',
'ShortDate' => '03 Dec 2006',
'LongDate' => 'Sunday 3rd Dec 2006',
'db_DateCreated' => '200612030000',
'event_images_count' => (int) 37,
'event_images_count_text' => '37 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0612012/',
'w' => '2412',
'h' => '1866',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2412,
'height' => (int) 1866,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '3 December 2006; James Conway, Ballinderry, in action against Stephen Clarke, Crossmaglen Rangers. AIB Ulster Club Senior Football Championship Final, Ballinderry v Crossmaglen Rangers, Casement Park, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/230344/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/230344/'>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%2F230344&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+" 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/230344&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/230344/" 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%2F230344&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/230344&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F230344&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+" 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/230344&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/230344/" 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/SF295/230344' 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) 4
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) 1758169860.1038
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/SF295/230344.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) 1758169860.0924,
'_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/230344',
'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 �
�� '
�� ' � � l� J � �( � , H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��� qf���Wa�]B�[[�� ��Q��
hrڶ�h5 �쥈c����v����5�
�xs+��4�V��TѤ��9��C���l���)��i
>"�y[01�]���o
y�T{���� h�W�w��m�}k��v�qt�<p8�Dgw`q2�O��Z�C
F�+5u�D��
R��H�M�o��#+�w<V� ���f�����q�jzZ���7�y�*�'4�,�+���(I�
F�u8���0ǰ⩵�� ��?AK���Z.�%���N��V��u$���H$p1��>g`��%s��� ��|-)� �Z�%��z�pn��=��� 3�?�jǾ�Τf���c����!�9抵- q"ď�`*���\�+�r�\5b���o:Vw�e�I�j�X�b"^��%�[C[�"��b&B8��[� �ݽj��Q��0��Di�����Y1�圐F2p �뚆�Ȩ��%͝���V�@���I��ӡ'��z�,gR�.q�J�n�SV3�u ˮ�<zW8��n��kVJ%7Y����{#����r��LF
�λ�9m��Mif&pz�o����BI#M�4o�R<��R�a�yW}��/�{�q�����gp�gr��.r@?�@�"��U_�SE0:�os�$c�O_ꎦED��x�T��4xj�}� �s���]�=be���
�MB�A�E�Y!�4j@�
r�ᩘ��#�4��'�j�<FE�
�?����<)�t��D������4�c�<���u��w7��?�Z��ˣ_��6r�U�q�$�� ���s��^���j��f#�
�:�.�|?�ɪ�{�T�ӏ�!�(�o%'��
ە\�n_Y�j.�yx��f���'Y��� Mh�Kp�do��qKg�)� �|
��u�ð�~r�8�pw9-@�uof
����e��uA�X��斁����zF��G{�DQ�����M��G� ֡��+���:Z��� �Wg�
R�]�ጀ�\S�W�6mn��<����Զ����1�am��*y��Ƨ���������1c���]��$��*����ln:{%��]��EY�5;���2]����
Jn��|G�^d��ׇ=�ָż�^��Ɯ��(�h�[�_x�B6Z*o� %����=�� I�J�~!���DžttO_j�\�$R��*�� `��*6��I<1�U�<=
��p�gk�k/��>�����*@��EȖg a ��y�n2H��g�^;}T�1j��(屴�ſ��;�ng;K3��']8~H�kV��_�[r����o� �Ú���9���>NY��8l�
���瑃�XMI=LQ���'I�+�&��3�Ҟ�%�u��K��@i��"�z���mm�(f�Ck��2 �w�<n���8y��؎���Dfq�V���ͦ[�l�vH0i'a���6�-�M.���!���R����K''�F?**�����c��g��z��)< �ֳ��pwd0����b�{�=�u��v��kc�F�vj�ؙ�QfG���
m��!�А篛�o݄�jߌ���~��X_T�,��ǐRU�,��;X#�l �J:#93��'�_
�:��5��|�����ܬ��'!|�� g �k�-u���tG�Qum�)�G9���n�Y��j�7�?sp���"�'=���8#�|s�J��u%��h���f�h�����-N %�k|���ԥ
W���V��)hr�-���K�k�s�]�a�����+) �� Q��Keď����²��:%�/���5G���r�����:~��͜�?����TN��r�p�i
�x�M����@K��E�� �|}XU�;�1�@ճ�)~��7�%?2�>�S��p%��b� ����5��t���I�y4�X\�!i2\i�[gE!GZ)�;���~���ҍ�č�s�b�oZi��ZhP�����
�L�~�$|�r� i����?�� �+!����`��.zfS�5����[�:�Q俹�'���2
v�Ն�b��Coi�n��CEl��
�
�q��W�;�Ť��3#m#
�
� �`~C�+YM�D���GJ�ԴDK�"�nc�|��RF;P��
��猃�1<[���Zx�[*�siȑ���q��H��bۚ��}�&�<�\��6�k�x�e�st9�pI �ں��i�Ƈ�ۉm5)��2�M�1�DE�$l�wA�g�%p�Z��<U�i^'���/A��˶�e��|c� A��c�__x�;[�����*H?ʜ���3�����m&�����y1[�������� L�?���SG�'?p��E�c��u�o$јˁ�ws^u�
�]��Μ��6|��]���2��*/_�[��,��銛���ꗸ� Z��o�^y�9�aڋ����U�[?"勀3E7&$t�S|
*��/�o���6:$���X�ri�a#�o.I]�3�&���?ՊͲ�!���UGQھ����m.5�f�x�&�ݤm�$Y#����>���Ph��c]Ӣ��l�=>�[g��1ݣ��>f��p@��Z��O�n|Aa���H�o�G�e�j��*�?+1��F\�'-:+��4����k���ۘ�-nl��8fK1��Y��
�l��{W��_|S�ɷ]ѭ���$�8)p���p��UO�z8<5��ϵ�<��.��J״;��qZ�K�[K
;\<к�KHF�O� t�^}�N
v+t���{l� �a�n:�y�o^<�X���JK�O&w���Y�i��K��[\�&����2�r�mA��鸌����2kd��W���ff�$�I�:���4bl�%=n=�3��~?����6ֶ��v"�������/�~Kxm����w�&^R�aA���S���x�zF.��y-f�C<npYx`FH#�j��S�tTc{�^���ie�C�
`W�Qǵj�f #K�O�$�_j��<p�p��ZO���4ձ��n<�p?*�~��oP� �M�����gh�U�� ��>�uodLG��3�jQtO ⡭J&��� �{���q<;k��wv����$���d�z�P~���PVg3�
w��=��ZX5K���j��Z&f�V�n��yE����P��Mal�6
���a��r� �㭉���輴���%N�
���x�{gY^H�N"���Q���Oֽ�_�_�:�qV��2�o"�&�9�oN���s�0����.�I��߅��_�>ӭ�D��{5�2����0q��I��Ͼ'�j>r� �o��w c9��PGj�+E�Z�Z5fzI'��R��%��5˸w�W�w|��ir���b�'��U���^���*�>�J�e���u��/DZ�p�Z����h�l��}�F`�� g\��0�q��^��[�4�����SO�q�}�H��'�w0�Y� ��rz���Qq��}�m���{�亚P�I������pjv�V�r+��L�)% '