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/SF301/233474.jpg',
'FileSize' => '347 KB',
'is_book' => false,
'keywords' => 'rugby',
'real_path' => '/media/images/IMAGES DONE/Library/SF301/',
'path' => 'Library/SF301/233474',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF301/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF301/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF301/',
'file_name' => '233474.jpg',
'id' => '233474',
'sku' => '233474',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF301/233474.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF301/233474.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF301/233474.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF301/233474.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0701029',
'headline' => 'Ulster Rugby Training',
'headlineTruncated' => 'Ulster Rugby Training',
'caption' => '10 January 2007; Ulster's Andrew Trimble during rugby squad training. Newforge Country Club, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Wed, 10 Jan 2007 00:00:00 +0000',
'ShortDate' => '10 Jan 2007',
'LongDate' => 'Wednesday 10th Jan 2007',
'db_DateCreated' => '200701100000',
'event_images_count' => (int) 32,
'event_images_count_text' => '32 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0701029/',
'w' => '2872',
'h' => '2084',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2872,
'height' => (int) 2084,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '10 January 2007; Ulster's Andrew Trimble during rugby squad training. Newforge Country Club, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/233474/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/233474/'>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%2F233474&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Training" 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/233474&t=Ulster+Rugby+Training"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/233474/" 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%2F233474&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Training',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/233474&t=Ulster+Rugby+Training',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F233474&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Training" 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/233474&t=Ulster+Rugby+Training"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/233474/" 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/SF301/233474' 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) 21
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) 1758066534.0678
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/SF301/233474.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) 1758066534.0381,
'_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/233474',
'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 ��+NExif MM * J R( �i Z �
�� '
�� ' � � 8� $ � �( � *d H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �G��W4���1�ɛv�mt�P���X�N�;p`��j�����̹�R�Ռ��m�Z���G&��י���yI'���+|cy������"�z��scue
�����s�a�"d,=�+©L��k^�+��O�d!��99�->~��L��&j T��eܐe$t�X�r�m]U�tz|�TV�
��FW�����zV�a=ʲ�n���B21Wt���ӑJ+S;�t����v�3]���ܰ��i5d ����I=y5�_
�j>1�5
fd���C,v�]Na����k� �,���Y>]K�\���/�?F��?ō5����e1�`�\�-���=9�J��[ɓQ}�z^�������,�JA����� ���G4����vg�kze����i�������c�'ᑇj���dՙ �����
|�x�M�o��Li�V����:�zaJ��AP���:�ՄU����#��k�>��ki$=@*��U�!��0��ӑұ|o���)���|-}k�� U�-#��ހ�00=s��m��R>y���_�{gwg<��$wk��3mG?�����9�U`H�RfRDN1H���D���9�9��u�(b
lZ\���r�b�M���5ڹ��r��)\Mج!fP� U�4�c���&��MM�e�9�J�M�^�u12�1�Ϯk��\E��(�wlA�6;�k��_�f:'�t{��]:2!��l�% ��f=��k$�ٵ4��G�_����Ƒ�D����㐌d��=zV��5xk�t�kw�4e�� :ј49#;[�8#��U&�Z5�6�g�~�z=�/Z��-ķ"+���l����u��F{t�|�@�
G5���Y���Ŭ�v�~|q��� �g� ��z`Oc�]o���k�u��=�����V^f�\��K�y�$�d�ߓN���^|[�t�=3��Ll��BѬ5^S�:`�u~��.�����/`�$��H�ɷ# e3��f��q5�[3�]/C���Kء�����sG�S�U��*C p{��W��"�};U���Xe{i�'x[r3+%I �#�qmپ�sZ���GZ�"p3P���Ѐ�`ێ;ּ<`{U��'�'�j�u�)M�J�q�̀(�c=���W��TzQgY�=kh=F�;_�^$�]��@J�id����ԁ�פ�? ?�͆�<i�����.�A��WW��?��s���p+U�gaӃj��R�>x���坖������|�
��S �A ��?�O� 57��\�|�����w�Cҳ�>x�K���#�OA��]w�P�� ��I���R9���#Ƿ_0����5�u�C�*���ľ�"'�o�*H�x�t��z������No�?��+��ew��Ƈ.Q� u8ݜu�_=E ��s�=���Z߹��n�O�W��c�kk��X�2A�#���A%~^;�����,�ws܀������ܐ�9ϰɭ�섖���,/n4���4��I">LN�$dg���ϡ�?��nٯ$�|�"B#�1�c��Ժ�nu*7G�?�;�A���.f��o01��c�����6x�B�7���t����Y�D���8|m�x��x�Lr�MT���9�ǒM3�q�I#, �Z��+HH8�$�GQض$�ـ�3���I��T��
y�+:���Zq��O8���!��w,�8���9��Oj��{����C��^�.�>ǎ3���A��q�=9���r��5mG_�&�� �� #�s�?)��H�qR�� �I#�<A�ϩ��z�̛������I��s¡b�N��;ۀ��p��� իh���.��N�f�ĞI4E���1���ն$�|���#/�5��o�m7P�~ry�C�a����?h?�P���3��
��Q��|�w�o����炤-6�ۼ��6�-�MgP�4�c��ڸ�& nC��$Wq��z�#k�5�e�G�m���"�¿h��<���� ��֔Sf�-��s�H�'�����Ɯ�nU'>ÐZ���B�K[�d]E d�'�G��~U�~` �$�V��z&t�ڝ�<Q�?�?
�˽�I5(�����у�yJ��b0zk�[�庸��vV�W.�T(,NN ��b��5N6G���<� @sOq�֍��P��qT��Ug�e�%������!�\u���P�9y{������t��4x� e���C�zm��`�+u�j3��m��ykq�yh��,�J���`G�0 �4�i&V�"Kp݈��`m ��T��+/�I���fL��Z�b���j��K����[ŷ6��T���G� ���⯊����'L@�I��R��K7�X 1�{�A��v����b�����a���ֻ=w���� �RLfp\�K����W}R*�js����s��I s���<3��RĖ������$��Q'biSu$�����
��k뉉fI�u7�P��z�W��u{�s�\wz�y�~�<s4ܙ1����T��M�R�RqN�2����m�3$����@�J�~鑈� ��1�z|���5!E2<��`m��b�:�ݷ=�)ф��c:/[CsL��<�A` ���S�#s5ߌ��R�K����=�B�p!�^� 9�=�Snڣ�����~2��^:ծ�H��T�(�����������5Ihx�w`x�<��Њ�Ŕ��\߉� �[X���V ���WO@Z�_hbO�@�k���_���N�g�{��d���X�Ө�Tw=��'�im��X��V������=�Հ���|�E
2wVM�7��P�0�,���&�����\��S,�>���u��[������*2�2+�1�ւ���.�n��O�x%�'�{�h�c��a\|b%�iG��9'�����snUY��u�������9o�+��u/�=���5����?�j��N�)�\!(>�.x?����SO�S��J�$w�k��}�G�����tH�`����DZ���K���J�,�9���,�*����b��~!�����
^��i7�&�Z��q(H��B��>T*3���X����'�X��F����ky<q��'�h� �58���B~�r7� �t>�u�A�Zy���4��u`C��~�]8��ɆjZ�Z>�y
�h�Z\�S���D�I�;H�z�Ҥ�ċ}Έ��`��+(-䔤�ц�'�a���UpN9a������c�oឫ�x��m��t7X{[(I�Gs��:=�������(��4��o4�$Ɋ�}��(�{�54�s^昌�8�S�.���/jia�,�B�K�h������A��T��Ҷg�(����_S���~����_5���.��oh�uĨI�ˑ�������(���#�W��,5���+�mW�[��ۉ�
�� �7ֺ|G�U������|`7H�p�_݆;w|�Ì��+yV�nT�P�w=����b�Ӽ7�ڜ�kS�~�&?���9�n+�zCB����"���(�mj:���*Ie�c�C� �̈4������`�raCF[#c�鞕�����j:u�i:���
�C�y�F���"�� ���=+�U$���[�q�[O���u垩sj�j��+y�� %�1ݒEq�2�(p]�f��\tDKVV�Y��#�w=)f�A$púi�` �I<