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/220615.jpg',
'FileSize' => '468 KB',
'is_book' => false,
'keywords' => 'Rugby',
'real_path' => '/media/images/IMAGES DONE/Library/SF276/',
'path' => 'Library/SF276/220615',
'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' => '220615.jpg',
'id' => '220615',
'sku' => '220615',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/220615.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/220615.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF276/220615.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF276/220615.jpg',
'categorycode' => 'SNI',
'moreimages' => 'D0608181',
'headline' => 'Ulster Rugby Headshots',
'headlineTruncated' => 'Ulster Rugby Headshots',
'caption' => '29 August 2006; Tom Court, 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' => '1888',
'h' => '2820',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1888,
'height' => (int) 2820,
'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; Tom Court, Ulster. Newforge Country Club, Belfast. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/220615/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/220615/'>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%2F220615&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/220615&t=Ulster+Rugby+Headshots"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/220615/" 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%2F220615&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/220615&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%2F220615&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/220615&t=Ulster+Rugby+Headshots"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/220615/" 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/220615' 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) 1758147595.7128
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/220615.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) 1758147595.7032,
'_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/220615',
'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����������������������������������������������������������������������� ? ��5E1�Շҿ Q:,��`��MfBf�iـǑA iC)^v�WՀ���#��YT�\��y{�g��ev�V�s�nѐr¦�)-����=:���C2�g֡
��WF� �1l �EKh���Е'vpe ��#�
6P��<�=���۟j�Gp�G8�nqN�X�M�����ޡӠ�o�g�@$+I-�3�p6��q�y���W<BS��_� ȥ�^�è���)a��)AێEWm@��F�2�H��>�;�j�jd�R�]��b�B7�.ţ���D�1�p;�:�Ғ/F-���X�,��9f�(��1�$<��Hp&��l�A�یSK �Ү:�ʤgn�}(��
��ۍ✪�pG�Ẁv��i�'��q�<]��ۥ����ʐ�(�����K)¬^!)�+W�_1;�&�%�!����]KG��d|�:�0��
r����&�;���\2\�z��0��M�<2y럵q���� �i?��ȥ���]�F�J+WB�rƦ5&M��J�����N6�Ɔ��B�� �5��f��U��㌬h���\�2T�?�Z{�4b�6��g�9�|�n�'\�f�[��~R09�G��i�Z)�
�\rA�����\8�4qPp���*�r����ѓ�zQ����|,���9,���4�A���- �N�U��X���� �������9M]��iTF
��zc�r
�P�=��1\ nH�c�q\V���]֦XYE�
���
�{z�?SӚ������ $\4W3�5A�ȷ�;��f+���q���Z�:]����+6 t�n�pF3�״�6�t'tck6z���%��e�C3�ı#�|���=�㞱��"��-�U2Z��E�eY��0�s�:�� �b��hƑ���]OC���,�Ʀ �6�l���q��0+�/ZiL�_�F�k�
)�[w
sצ8�Y�K�Rk�m<c3�|�p뱶��s���gq��9q����G2�0F�ݐ=�.�r8��`�l�#�j+U&g1<R��m����CB�s���C0�3ڢS�$s?��HL���,��Q�?^���y��d��h� V08�� ��_m�F�T���_�Ζ8.�r��pkb�Ŷ�Cg�k�;`��h\�ݰA�C¡����(�V�F�K�����Z�ť�E�<<���_~Ƴ�H�U�:���vS̾k��1�^�C�~5\V `�_�/�žߩ�QZB�1�ʂOS�]F��
�Wݸtc4U+17b(�|�����k:�گ��V'�L���p�F�cՄ�)Y�D��ћ~�n�z�
���|�}�I"��!m����vu�F����֥���7)���{v;b[�i��4�0W²�;]K3�$�y9�s��/d���9����TZ�&�x��D�i#�"rwaz�~^�85�-ջ`l)�������c�ob�D�� ==�+�e�Ř
�չ!fʫ:�ۖ�#�c`�?:Kt��=zzV��[��, X18�)��M��6��c8�s�/�3k��V-io�r�G ���ml��}ޘ��_!� ��W��P��P��� ��C�T���-����,�����y�b��j6hU
�}���Ո����D�h[����)��5PΥ��$R�Dٳd ����wUk�T#����v��Sv1��1<���Eؤ�'��I��8���+��1���k�s����=�ȓp��?��*I���n�W�(�hA0\B���}M9���;����|��{���=�Z���!1�_?皯&��� �+5�y?�%��s+)����ê� ��Νkj������5�e8�.'����&��%�5�]Ɇ�F�l�¶_�n� �Tɼ%{e4rj��]����O �bFq�M[���s���W��t]="x�e|�V���ѤD���
.y 2}�Y�k�#~Fg��x��fm��� ��q�@�;N9�Mu~��.�E��[w��#�cޮ�T_��X�VjkS�Ӭm����`�.?�u`��]�#�5�\@ҭ���p^��+G�T �ZdQrA7B+����9F]D�T�QY��8�iA��8!��Cg�}j����I�ji`���*y\�U��K�;�[˖@+i�][����
ۿ�C
>Cʞ��P�;ӌ�ٝ���&���%�:|�� �p?��[4�1}�1����\�h�-
W�_+Ic�ZZ]�&��6@ͻ���V�m苲鱨�� �
г{kdPTpZ�F&3��Jv_�[��;&�3#��~�G${� �1ryܝk�8����L1
܋Ȳ�w�PTZ( >��}KC�%;A�#�h��A{�� ��z�E>+��Rs�kK)=q���a��T�$E�|ԴӰӹ�x�Li�nu82�������8��[E��>�yV+��"����:!+���,��Px�l�g����Ve-���e'm��biw��O�hs|��&6��w������n�� �9u|�8�*y�s[#vyU���[py��b���54GA��2�s/�����rrG�+Ov��+��zW��c<[W����X�#�?Z|�190+�j�C&��w2:
(Q�#�kl]��n�N<w�(�i?u"z�2��1VQ��<Tr$ў nx'"�g�"���6���Y!TXӮ0�ܓ�{ןh�d�s�Z���?��ۯ���t���0 (q\橬Y-�C<z�ȍ�@�p�W��c�
��4��,��o� Gn:v����l���;�
s�!��+g~�K��os��:�'��0C!V_�"�l�MB8W�<�~���s��J�C�U�6�7����g=���d��g����
�+�n����)�i�iq&-� ��?5F3j�G*B�K�3����L�@G �C}�%�8�!�èPsL���W :s��\�t����"_j"�]��V��]���m��.0|�+|��O~:�tSyD�d9^~���l?���߫�{��������%���0��1�$�f�7R��k����̱���0���.�i$�#0�gl���[Vn�qغe>N� S�5c%֬gE�!\�ս+��U�Xy���U�3�ђ�+t;�4M�%^��u���8���&T%��3�I�D�k�
.f��io�����Z*n�W�c�H��8�Oҕ�!D*7rI�=h��T��}5�[�U�q��=@�s��?�X���KKH�Y�g͕T�z��������D���Zt]����r'>S��+ºǀ>5���<��w��i�Dc��)vC��9*}FӁ�
��\����۱R�Fs�w��8�[S\�h��5����Q�p2z�ڷ��<�އ����lefi�C���$���V|�99�T䍝K"�ƣ9D&N:�A�n�V���A
*���gȍ��ge� ��ӾO�_��*Һ:$d\�f���z�}j�1EDT� t�_5}��p�%���8��\�嫐8��R�]��a�jLIb����<�ձ9����������x��E��j��x^nd��W������&C*�Wįw����n�.OS�}�&��^\�M,�pH]�c�����t�bxkY�<!�N��H�
>�gH�8����YK)>�k�S�ױ�!*�P��zz�}U�RY�B��m�c��g}2x�T(�,17�<m��r�ݿu��5�_�߈
b}
yCG2o�Wn2>�;��ɩ��q�F�<=wNz4�g�j6jp1 ,�8RO?C��X֚}�l�vC��}�ƼyF��;� k�dB�pD���h�Q���3�P�F��X<1�A�i"ȧ��>����kmsB�K����m^�.��1��ܭ��z�zWf�%����T�:�F���/�tmB%�PQe9��s?��k�әnͤ�4+��Up~������
L;uh�������&��DK(��b�If7�-|ܔ����7�C?���\�p�殕��ͼz��X<�
gpO��9�1�k� �Z�ƫ4w���aО��b9�s��MBX��O=,�/��v�=��m'�ψ���o"��<3f�3�7����5�00�zW�������$�C�W��]m�ݴտ;z�
��o��;��a,����<�pe���p�
��y�
��~�^g�~Y���l���L��a&htqԠa��n�MF
=���b��N��rw�1�����k�s�N�@��tq�H�О�~�=��;$0-����^T��&��IN)�m�(�Ճ����"Y>�v�6^��@����y�7u�B=��&D_�¹��N����OH��m�f{2w�2)t����������hC�fq��
��X�W}����6ҳ�Y�"���,� ����^�{�5��oUY��ڽ��/;��)S����涋pv���t����N�?'�s��_�G=��_��!"Q�P� �[V�e�Dn22���J���"�t���l��g�3ĜgJ\���L��y���7����E|,�N��*F�tc���ֱ�X��ƒ5O�Bk��|�L�(#�H8�i� �
ɬI.�m�4�\�#+yތv�ҿV��U�x�_����y^[�TkJ�����g��mv��:��_×1�&[yu(� ���:[� �ǡq�c��$��u��]�J>�{�< �e�u!�-#� ݖ���iC��uֵh�O)���Kյv�R-#��"\)aox�;�רq�]@`p�6 �P6��m�����2��H k�*㌆RARpk�O� U%���Yw=p��k��|;�H$K�B)�Y[8y�@p��,~5�
nr�:�R0Wd�|8�������ֿ�� v�I١B�>f,cwa��u���MG��O���g�\�`������7�z;� :����(E$yҗ<�ϥ��k]�ƃ���=��)�i����V���T�U��T�'.����s�$_�"It)�!Zѳ��3��`����\��@�Nx���>��k7E��^�kO\}�ef�kK���Oy�]�ͥ� ��i:���{��Q<<*;Ԃo�3�X|,��Բ�M��Ο�>�<��7F�h���w��<��n'� ���~`����uF;bqU1u�Z����)�?w�U���Gַ��q@J�#�i�p�pGJ�e��\s�z����5�|F�����˻���.�na�I7(��\ʣ��Z�h��O�k�!�_+P��q�弑���gú�����D�7RD��y�����@�zg?�����!:��m���7�.����'����m��~^�
�w��H3#_���Kn�;v�~�f#b�j��9�v�i��S��l�v��/b8O�A���: ��GpqERe=BR���^��h9ͳ� ��9-Qz�`�:�|s� �T�:έ]c"�%2��2��sض�U#Oޓ6��cj�4#y?����|}𥽱Zf�y(*�qħ����ɮN��W��Ap���`�=����'_���pWluݩ�O��5A:����=>r{|��X� hI|��E<��om� ���~U��>�O��(�4�Q� ��q��9�&*j�$�NE��֜���"� p�0�)a�綖Rz��k���
�$|u��|-l����meV�aeeg���X�S��N 9�?Z��ϧi���xĒ�U..�Į�m��9#8�3]h:�彏��3U�b���6��ݶ�C��yԖ<���)tY4����U��ſ
0:���viڣB�b��5�:������e��챔�����$��3j��G�O
[��V�|QX���Y�X@U>�uuz��
j!UY��[���~��#�P+Zx�Yr�ў^7���i<F[%(�N� $ީ�?���F������J�-o��d��dP} ��V���OT|UJs�' �5�a�a���Cvd2!%��g�4D�m�IL~���w>{���x�$� ��B��ƥ,�Ь>ݷ�'�&�ß�z����Y.�!��[M��S�i ��9��̕�U��~�A�ἭTk��:?�h�� Q��E��͑����:�O,��C1��N����[M>�Kt��A��.wӣN���f��}�"��]6_rв@�_�Ao5�ʹW�1�3E*�Y�H�$�[G���3i����F����U�t�.rv�d��Rʃ����PޝTu�z�\7���'_g�](i�M���ϩQ�1�*MgR�j�H���,N_W�Е���ɯ�<�P�%�}��K�WOLbGk[��$L�}�о3��dмu��
�E��8YT�Cs��τ��şk9�x��P\�����]U�o������Z����p�3�!�e8e>�Ew�?yV�L=GJ�����B ���؏ּo�����E�xOJ�hno���N
A��q>���>Jm����/1� -��k��
���ç[A�~�N�8�co"�i8rIs��#�&��>d�� �
0���?1q`���?uh���~c_��x���(�~b(����i_��jR���ƾd����3_��0�zTD��z�P�'�?��Ox)u]��[��K��q��O*��R PXq��}
{�Ig��d�G������6Y%� yd��OrH��L�gc��UT��_տ���v�oɩ��t�NԬ�����N�YDIrC"31+H#�*�[3�O��eh �,�����ɢ� u�n�9�U`�$uF�L�N�VvM|�O��z�o����� ��9.4���ц�'*Fq��t� ^s�L;�L�
�/�
q�T����������f� �%��8��J� �+�/�J'�m6[(�9��#U�E�P\)#њ��0�Q^h�|��:�j-�%o]����O�[o��-��a&���i��� C<�� vQ����;�y�x����5�\.<a����ce<�鰕��Wd�Y /Σ�Nݜ��wÿ|H��w�Z��<=�#Z�͢[�.��������6 ,��v�|?n�,:Sk����'�&��H���4���;��OA�1.x�wo�&���o�G��(�K�`�n��a匌��
���M��>�)Xbv�5@p?��|0��絆�R��OE�7F�,��� g�}@�%�^��{�S���L�<2�osl�Dw!���y�
�`1��nX�W���w�� �}S^��J��';���E}��F�1xo��t{K/x�P:���v�eC
�RpW�iX�N}�>�kz_}�'$�/��~��q��CsCqMcr:�z+T���Y�H��|�a��0G�9�gb#���xb��H���� � �d � �*Z������M�[�S�Džt�xB�K�OGi����(%�Q��Q�7-���Ig�_i6�ӵ[�GH�J�;Yc<