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/SF276/220619.jpg',
'FileSize' => '453 KB',
'is_book' => false,
'keywords' => 'Rugby',
'real_path' => '/media/images/IMAGES DONE/Library/SF276/',
'path' => 'Library/SF276/220619',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF276/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/',
'file_name' => '220619.jpg',
'id' => '220619',
'sku' => '220619',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/220619.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/220619.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF276/220619.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/220619.jpg',
'categorycode' => 'SNI',
'moreimages' => 'D0608181',
'headline' => 'Ulster Rugby Headshots',
'headlineTruncated' => 'Ulster Rugby Headshots',
'caption' => '29 August 2006; Bryn Cunningham, Ulster. Newforge Country Club, Belfast. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Tue, 29 Aug 2006 00:00:00 +0000',
'ShortDate' => '29 Aug 2006',
'LongDate' => 'Tuesday 29th Aug 2006',
'db_DateCreated' => '200608290000',
'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/D0608181/',
'w' => '2072',
'h' => '3116',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2072,
'height' => (int) 3116,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '29 August 2006; Bryn Cunningham, Ulster. Newforge Country Club, Belfast. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/220619/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/220619/'>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%2F220619&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Headshots" 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/220619&t=Ulster+Rugby+Headshots"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/220619/" 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%2F220619&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Headshots',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/220619&t=Ulster+Rugby+Headshots',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F220619&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Headshots" 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/220619&t=Ulster+Rugby+Headshots"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/220619/" 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/SF276/220619' 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) 1758148534.0008
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/SF276/220619.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) 1758148533.9835,
'_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/220619',
'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 � � ��(�Exif MM * J R( �i Z � �� ' �� ' � � � , � �( � '� H H ��� JFIF � � �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �I%wޔ�r9�~yR}H�� f�qEq��$5����.�VB�� �OD|�����7$1̱#� d���F��*�Np��� n7u�5˖�Jϩ,k3��ӖC���k�!A
�$'n+�:�
4S�$j<�3��T�� ���'tX呲~R)�n��5���ø���(�N1��Q���|C��F^k���DW�|ö}3\�� &�$K$S9�/�0BX�W�! 8_�X����2�giQk��Z�
��V�W�X�\�e�{�c�=�v�r��kg��L�|]u,�B��fv�Evd!�&��W �pG͜�٫F��i-{�p�Op�wRG�ڬ!�$�Å
A �xa�Җ3�aҾO2�K;���e8�����>��,x5��31�'j�M�1 ]0vZd�L�
�h?Me/�z��Z��ksR� ���W�|X�h�71��ۙ����y�q��Nx�z9V�1
�-Ȩny����"��Ii4��0�j���!��d�6I�
X���zn����Y�u�(�G��q���۽}���HיZ������� <�F��$,F/�D�:�Uێ�ߊ�^0�l|W�j�f����8�c� X3���=����"�)<�q��ɴ�/F�qquo$���c
,E�W+��@#wl]�oUD��I~�}��u�"Y!�bpA'a���� ����U��K��g{!�1�
��
>#)_J�w&��1*���4ى#�P�Z����]���,C ���H��-����r(i@lN�s����I��6���t������c� n9���4��� ײ����b6Ǚ��W;GL��Tt���v�*�[��L�u�(u=9#��,��ًm�g$9��^k
k��=V�gYU��Hw���q^�>��
�kA�n.5��8
b�<�dLeU���U}�ڂX��گ+0�ʃ�\q�sW�'M���\i�ql�<�ýh}�I9�Gk~�+�{�2��Pӂ��(*LR�O�t �1��I9�(��S���+�b�Z0����:��ƴ���~�x�|�������⬓��b�V$r٬�����[ �`�Z��d ̔��N7p+ϺE
_ �E���Zj�-��.U4�"ud�I�X�
6����y���]��!�$�1D@*����}�n+��w��ˊ�=�Z#����V2͇unH�j���!�
�U��f\�9<��� �0���}G@�t�w�>�x�<�|�`���4I���%�������+X�VE��
�`�����T�uW��V�L
oo(�3�T߶Eob$^0>�=*����W��a� ��K���!�H�RFX61����k�YP�'����_�<��TA�8Z]яPk͍֦c���\v���d�F�G'�'�^ckb��B}���b���ޤ,x��Qt���T���,���}A����T~Ѯ�'-6���q���&��,M`a?͚���βrUI�%�ڵoS؆��.2�)��n�I�3�Hi�K )c��j�>2���Gx�v�����\�'k�WL���ַ?,��
n�fP�� ��DZl~5�;����o��j�G�|�P;��y�.2��<��b�錴 L���`ñ��.�0�$�V;H��6�~њ-�ݦ�
�O� 3G��e�H�^���+Oi�{���(� �1� �
����C��m(����` ����˯j�m{G�#̾�����q�U�#Ч=
�
^���f�u�P�5��igI=�P��X�r5Hf��i��l:�˸�~}+S\�l�?
]��A=��λ�p˝������N���9��]|��W��6F[}�Lē��.G^�=+�|�k糤�t��.��Q�$�*���⼴���=?
+d��"O=�H�*3!_���ˢ*�����qQp�r�%��Z���e��00�ːtϨ��
��K:���<�K���T���r��a�=iJ����Fk�D�wз�M�VV���@�\寃t����]JF#i'ge������]p��z�{�,�ë"C,�\��_j��A�uɒ���!`6I���qI
�9H<:��i�sNb�m'�'?q�?�SA�����-��N�o"��M���s�U)FOEc�T������K���� �@S���r? �~5�\
��9����2W��d��d`1�=��#��;温�u9G3H8!h���D�{R��y�y%�a���qNTb9P)+ ��R�
Ig��A����e���n�-�Гʌ�r��� ��W�e5/�q��V�m�t�W�W�+��K{�i�4���U0N~��W����Rv�gL�"x��HN6�<�{�+��jB��1������qߓZMZ$��
��=�Ip���3�x'� �O�,�M&m3M���'�x��{t'5�)+�
���:��kb���n
�r� �8� �j�xq��J��~���-wz���y��>$8��es��W��h�i�\���i�#�R�q�a�"m���� ����0NFWmr~9sͻ!#�L�ҽ,�W��f�>4f�������{�F���z�d��j�@c�yV����~��T���F{"8a�,�� �X�;�3ZVP�%k�n6̻Z.B���ӽm(Y����6I��C�X��G��dW[��2���'*�qp���Ez���iIrNX��=�q��~5�n�w{��m�v8��� ��4�uc�U���b9Xn9�=(�{�7v \w�F�bFJ�Hd/(<@a� c�j��V�C*Ɍ�ïS\Ϗ|�!
��DU���?_��zYK���fm��̯]�s�
�C�g�b�/t+ u8��Hm���X����`p��G t����6���)+3��t�k4k��C�G���F��
�pAɬ_xyuq�-<M�ڳ�W�w�a�j��h� �+�Ӷ�dڷiKO�C����
�h�<*���OrOSZ��xtQr嬬�G��̟ʼ<n��� ��Ŀ�3UJ�b ��2|�+�S<�7E��l��c�5|;sV�a��c�+u���X���Ճ��$7@+�y�O��hM��{�?������C�\����j�������GO�8܁\�� �G��ծ�Iq=��0�A����y.ԧ]�%����
�K�D�e�J�� ��9�=�]v�<r��e@�!��� �;�zſ��IkK��7S�#�#5b���Y� ���$����M�ֹ�۱��>�Y�b����=
VYV��K�*�BH�0��VTi*�p{4� c�� t���B�[�Č `I@e!��AdS"$��&�F�џ���G�"|��>� V�0������a�El��"=�F� d�C��9�K]����� ����?\u5�x��n��M:���F�s�ƽ̫$�.�j�� ��)�^[�� ?���4|��/�ċ���Z�x��-�v�M�$j:4����Q�k�x�i��ӟ�ޑ4y� �����}�l<i�䂲C��n�l��[HٖN2�^��X:~�&�!WL�[���zW�
OBR�ͨ|w2k���N3�R��Z��{�lpÀ?Ɣ���ڦ��Z8�S<�t��;�$� �W�iz-��ߋ�r��r�$�wyF{�p���IQ���l��;SH������1���k��Q4de;U� ���U�g#i�*π|eg�����v��?�~�rpz�s�S�2Ջ�4~5����O��-/���oy���.&P� ������p=k�*BPn
���$��@KS����{2��)��x�c�~/���M'��u �}���,���P�~��JV^��x���K}p��ܴ��� �Z��[�F�AiK!����_���㦉U15T �);/V{�쥪�xſ�7��u�"C4V�\E2��ȣ���}y�Uj�
�߈v�;�-��U�r#^-n�.1�dq����r�W��zlz��P����v���.���E���d��P~�}��� )9
��39���x^ٜ1�J�c�Q�cdLp(y ����PI^:Ԟ�Km��Y��=�� �+�?e�J�/����:���m˥�ɄD���Ѝ��3^� (�� V9�BU�F�wm%�ݏ��-{_�� �o�E��rS�n�ac�U@ �/>�'ᶸ�7�e��)mx o@ݛ�?�5�ʬT�s���[��m�_u�}��^�J�#Zݶ�׆b3�����WM�v���H�NQ�;�u��>&{��^&��o�#����{���o�O-:"�0��d�t
+�Vfq>6��60����� ���}O�j�닻�B�$��OȈ����_{���|OW�_/�R�%+����Mg��N��ڬ�a9`�4���?ʽw�_�]W���]��4|��Q�L������~�Q�+Z�x�{8l~��e��4��ߏd�_���+��Gx����Z���1%��f� �Q��g|�� �/��HRka��ʭ� =��#�#T�J��l~:�:��Y� �y/|4��i�҂$��E��lc���[�x�@8���\�hʶ�n@i>N��j�q`4���J��H��� ���Γ�K.�on�ڙW�V�0�,v��#~{W��gd�g�h��lDg[a�Av���n8ǥ{XH�d�.�����xO����6����gҥ�G�2s���О��<o>��Z 4�J&+-�є��*k�p������hT��eQڴ:���}WG�#�T��m�/"1]Br:���}���v
�Ɠr��q��|ץ���'W]Ҩ�(��l/R��e�nO̓�(�ϱ�d�W�"��z�y�;;i�~����ۃ��I�G���W���Gy���j��i�c1W��-�\��#^>Q�9�A����Y{(�Ϭ�p����5ī���_��w��%�V�"N�{�K�mA���`'�k��!!� :]T�ƒ�O2�19�_i]����F?t+����}O�5���W�p��I��RE��'��s�5�Ki�7��[�߇� ���T��4Le�'ݾ2����H�?�֎�v�� �Ҙ��W����>n���R������?; \u�5�xv7�=*̣�_Nb���70�� '��s�RQ]M�PNL���@��ƚ� ��2`�WM����]c�y�ơu��|��{��#Ŝ�������a���^�`ۮi0�� p�I�{8�DZ��p�E�$m����UU���_��y �Gጞ���i���.dW,�j����n�ۥxE֍�xrv3��з�q��>��_ֹ(�e'N_#�3�/5��3�R���n���]��xgĒ[,���Eu����> *�7�0�7�<��c�A#���zW�CP�0F�E�H�B��� 8��P�Q�ݟM��?�U����W�I�j����Gj�gϏQ�����H��8_x3F������jڶ��˥�K��tl�
���q��<b�$�_�����οg�O���D���8����s�5�"�<l�h�s�=��ռ{����r�kusqtJAm���Y������?�
k��ϋ<G�m^�['�H!�`��tb���}�`(�r�h�{�s�[��[�x �n��w#�`;n��#�O�1"�!����-�M�E"�V���|�5�##2iW�G�n���sb(���9r�5�-��ק^��|�xJ�Fe��˘ܬ��!Szm8"��-�f�=�W��]L=D��J�߳�ݼ��E"�J�ρ�'��4���
xrI-�mj� +GRG��� |�#�YV�Q�=,�*���T��%�l��Q�|^��⛦��rZo�A�[4���3g�v�H��Q�3��T��� ������A,���JU�O���?C�2��Si���.��^lu���U���>�v���o�� ����b�ڠ��%�����������h�jҝ���G��pn�>nk�������_�xZ�Z���_j%���ʻ�6�0 %~o��A���/�:Q2�~-�� �}M���6*���1��oo'�Y>e�O O�Q抷�����Z�hj|O���V=^�0j�h��Uc� }W�ߏv����KKu=n� u�e���ڪ�6j\�?�f%��R��{��gx������zƍ��� ��^�����1����f^�}����#�Tԕ��Z5(Tt�+In���)99��s~.�g��O,SkZT7G�� Gǡe ��h�e��7v�c
����J����?���Brq[�1����7zޤ�𤒽����d����Ls�<q������U�A� ��2�p˦�.���,}��=My|�Z��Q��?��W
t��j��}4Im{���:f��ً=*����zEo�!�լW����??�Ru$�7v�l1��g�s_�4MJ�&֤)����W��v�s�<��D�)8b@��z�P�VH�R(ta��2��m�$F�+ѯ���� ���u� }�*�#V6g��昌���E�����G����o�|ru�"wԡ�,�zk2\D=Z1�c�ia�]��ߍ�|���0x�b54P��r� � mpp9j�9a��=��� }�:��0_X�+U�N��}�/����2�C�;Җ�^�����bc$5�_�j��iv��=UZ0�~h`;�Br}X�V��O��g���/0�I�{�E���w�q�dv6k�=R�7W
SJ��c��K�[�?��*���fo2\g���Ò�O���\o���OH����vN:RWI�|s� �G�$�ҡ?���n/H� ����T��ks�K�o����<1�Ѱ�U�0?�;
�
��x�`U�����x-o�n&�;fHfWh�� r��^I���lZ��q�O
Y��A�xa\-�ua�q�}�A�"��T��6���C�<�
��^���G�a�̺��'�u)��Y�����%���F?�8���K S�QLӉ0k �Ԋ��z�wC�Z+��%!��|��;��З�U���C&8��a\�=76�Yq�S�c�~��V��bk�O�o���~>֦���߇Z~�摧��WRռϱ�Fvĩ;�r1�����_ �|HM^�L�4���l4�})Z�ZrʂFi�Q���<�#�m�9���|˻wl��x����i�חkj�t6�VvR0ɶxT�#/�;�vA�k٣�J������H�����ߨ�w��?nX&_�V��eѢ18��8 ~?ΕM�ϯ�4���~��t0��x�<��tB:�;�I��c�ҥho�F�ky��q`��ƛvS��<sI��!�\�i��!"��/������fe��S��,�}ܻ���_���N�2Ay-ܺ��Gu�mn�Wi��D��F�)���r@w*�W�U�z_��������(4�N|��G�6��^i_ӌ�\w�
�3�EWɺ]E!�^93��=2'�W�V��4K�H�0����Q��e8vf�N�zLR�P��Y�m�;�@�+��6G� �%���{��'�,_|i�3�-�������!?*�q��� Fwak{*U��Q��M�/�A�K��x|[��W:���/#�f�O�G�>