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/SF320/244394.jpg',
'FileSize' => '553 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244394',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_name' => '244394.jpg',
'id' => '244394',
'sku' => '244394',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244394.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244394.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244394.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244394.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Andrew O'Shaughnessy, Limerick, in action against David Franks, Offaly. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'DateCreated' => 'Sun, 15 Apr 2007 00:00:00 +0000',
'ShortDate' => '15 Apr 2007',
'LongDate' => 'Sunday 15th Apr 2007',
'db_DateCreated' => '200704150000',
'event_images_count' => (int) 20,
'event_images_count_text' => '20 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0704111/',
'w' => '2372',
'h' => '2215',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2372,
'height' => (int) 2215,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '15 April 2007; Andrew O'Shaughnessy, Limerick, in action against David Franks, Offaly. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/244394/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244394/'>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%2F244394&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244394&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244394/" 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%2F244394&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/244394&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F244394&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244394&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244394/" 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/SF320/244394' 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) 1758104538.197
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/SF320/244394.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) 1758104538.1836,
'_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/244394',
'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 ��1�Exif MM * J R( �i Z x
�� '
�� ' � D� � � �( � 0� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �-���?��m�8y�����:�� ZrY"�3�k�a�Z��܈7UM��� �CZ�=
���m���+�oO�N���u���;=�Et� W3�K���zV+Cjd,e�}k���aU;�`���C�+wM�<����u��*wL�,;�
W�͑�H�{W�AhF=*;���|�Ԭ3�<V�u���j]4�Ӥ�kzh瑊�� ��Z�^��W��Ѐ����i�-ۓ�G��[��9d�c�W�?J�|=�
7M� L���kx��SY5-
�}�-������v�8�r�G<��_��b9rmS�v�yR�qT� �3&B���ˢ����ѕx����:[�r���#+Jr4�,N�O�&� @f� g�� ��0<�Vv������B�y�X�%�j1+�0^\f�[d���Ah>��QRMShVNW!��/�W�+�餶��r��u?6 �^3��i�.�,�v<�ϯ�*U�+J�,����w�>?�����\���Qv�����4Q� /��{�謭�>a��8t�����R�9�Aa�;{v�ݡ'#�k��2���i6�1c�D���.����(�뚇�}���G�H'�^ ����"?��`QC��am�Ҋ�I0��Z�`8ۜTP��Cf�R$���Mj�C��;g��|��Z���Hb��b>�B@jM�Ae�1��
S��e�ΎdR7!T|�H~�Ρ]DqΤ�:K �� �����.X��n�m�o�o���,t+h$�u�b��&�=[�~�O�n|Ke��uy��z�!��==��5�?
< �?�{��� gh�r�c�c>d����^���n<p�jW4�������sr�-�6��Jw�;p9�U�O���(粎��?�y51\�w����Ӗ�4��+�5��O
h������k$PܴI#����.�H�bG�Y�"yv��-������F�n �4�Էj�FĈ�
4 �@e����>h��@Y� S��|.�Z�#=�T��QGi��
�k�7[b^r�T�!�_�/C��ɩ�m !���!ޑ����.�n�]��J���r�ϟ<�]�A�9�ѕ�X� �N�z����F�c���ۤ��
���Y�>=]-���C;��[1��B�!Ӿ;ޥ���h����`X}s�*1�P�WiWIV��oۑ��N�̂�㦧-��[h����2~��W㦩*F�~��0q���{�̉o�<j&�e���luws�U���sm��P��p���AYU�j�E��u�M�x���ZInt�%��aU�yf�L���]�������H�GP�! *����+���7r�8�ì>:�-��\i������I�[��������pN~�~�B�� ǝBK؞-8y*�:����|Y���'��&a��xȭ����4n~<��e�Jaq��� ��:�����As�n�o�Q����.h��oR��.��c�桶������]*���'��a�S���崨����2Ğ*=C�ƥ$�]6$E����䯠�`�D��Ǜ�mJXi��4�6�ߥ:����شp�q��0�6�╘s ���x4��L��ۆuq��Z(i���'
�� �Fi6cq4���nsH��j��ͤ���ֈ�NM��b;hg��h�Y�
��)��ctueL�Wu{���Ȳo5)Y<��sLӮu�YED2J��1��Fz�=�u�u�*F�w�K��{��i' IpX3)\ 6�6>�w霥�xS|�艭&��0fl(�Z�xZH�������c&��b��n;P��S$k)�;u����vx a_�� r��Ouaqkb` �w)�E�`� X���$d���N�j������U�M�}i�$��~e��Ŗ�u{1�� $;A��rI�e�E7��}�A�ǮsҊ�=t4�44�_=����ڦ�,:�Qް$f즕��^����"-���L�s�g�Q� 5��;c� �
a���[�Q9KY�`�J��+ds[~'�^Ce�E��"m����뫕^���c�S>��R�b� ��֫A]�<��0�)4*U�UP�O�H����G�|p��P���+�>�Y!�q�����s�6jO�����p,�^yГ�#���M�z����q�w�&�����c�u0r{#8���"$����N�.��'�������kK\0)�~�]�s�&�?:�R��IevS�6��g�S�X���2���X�$��x��t;3F�K���M�9/�{�QK����֧� i����:�m���~��j����y��
j��.js���X�F�'�ˏ��Es��6�е��]h7 X�����\��yP��z
訚������xb�i-�F��.C
��y.�;�Q�]�B7��gsi�榑��F��օ�o�R���⺴9����b��:�����fHQ�ѹ�0UQ�I8�is;!1xC\��b�wr�(�}��ֶ�m{�Ȗ��Z}���`��c� A��
�e��(C�F�i�}
���y���t2 �'���Y���ĀW�#�&ec�D�~`�'5&�
G^�ХRd�=hX�~x��ncF�a'^�5�-gi��=Oҁ�gI����|L�sF�{�ª�Oҋ����TX�a��Z}�x�%��z.�fzf�����:�
� 8��K@�U�\`)����(�B�U�;i���ǝF�K��~f��{�\�Z���{��M_ჹ��i��VA��`?ɮ�?f��_V��s�S&�
�R����Rm3@�/�j�-�Oy�\y��k2MT�?�`�Ң0�Q��H��\Q\��F�M#/�/��O x�];Q ���6C�<1Y7��϶�9�ַH�3c����B������K�d��Ąm;A��m9� j��(�W�´��ͽGK��.-�Kki&0-����T���,pG�^;�k�~���v��Դ�)fr^�8u8��ps���d���UD�%�Th��2/\3麥̺k^ZIk��#}�B��#kmoõpm����p�7�s�W[@Ҕe��h<{�5��is\讜�\E��)M�s��g��k�#�rq�Ǿ{�j�i�~���i�ʪX�o#��껺}�[{X�9exK���ZH��v���T��֎���,��>C��Z\fl���_λo��+_�y~�f.u|j��Q�p~�2n�z��9ՠ���j��;U�ur�6��;�f��V4Q�� |v�@�z>��Y�3�*ϜA�N�%��A���^^��>���+�;hq��X( �8ފ���z���?�xv�L��T�Eڬ�p�'�5H����m��9PR���jN�oc�����13��n{HW9���w�y���|�Y�WU��9'swV�2>,�����e�h
3����cP�ŕ��NF8�ؽ�<�ۙ��g�$�8�B�_�^��1Al��>d�/��l$����# ��0��$���_N�'R6�Վ�XӗI���gK��!�-�(*A��t
9��G�z�����Zj:����V{_��]a� P7�����֊jq٭:}���7Z���z��?x��K�E���M����;wbK��2z`V����:����\��ڕy[%))G%U�;�B�����v����N3��&tz?��P�{;��9��l�V��U�%pe9���Vm��z��w�.�wc6�-/.Lw1" ��ێ�= ����!�O�}��Z�� y�\\��D���B4r �)"���pr����r����N�J�+�\�4�Oopq���ջi��²0%>_���rV%'r��^*b���O���8�N9��r���ن8��?�5;�|�,�$�va<�u<�}j��dN�1�[�I��X<mx�7��V2��k��u��&Ԯ^;cj����H�\����<{���S��g&�K���-)��5��m�M5�[8`��ʝ��ש�iK�G��D�ďu��M>�Ԟ�����ZFS�#�x\��zW��xC�چ��_k�7�kc����#�_R��A�}lj��>�ں���;X����W�pv��O*�sQ�ٻ�4�|ݯ�rԭ��svNޯO�A�Ծԯk#�3I���c�O=��tZn�y��;\�=ܮ���f!�P�)��b3�nd��;f��h����f��c�[6�X�66rm@����0����b:�aR�Z1��+u r?Ʊ�.D���=_��k6��x��s;�H|��$��Q�뷧@a���4��_Y�sd*����O\rZ� I]���
KRzu=F�t��j�^�i� ��G��y��\�#i#�a��NE^����u/\�x�LBZ[�$&H���G�C�
��V��s�}Q�O�M�R��q��*K ood�գ@�p:S�@��]"����ΰ�N1�{{U��[Zi����r�J�$��v��)Xߑ�>c�3�r�S���t:
՜؉��V_�.25r�F<̡�=>=z_�3$O�*�\ܛ���bAQ�M8ɢ)�R�0�z�E2N���&�s�"S��w�=�����T���Nn�q�<lAs-�$ym��(�z��}5�_>PU��+��ER79�C�إ-���ԳaX㞠�V2_�qeL�p����W�Vj������.{%�1.4�o�i^�&�n�\e~����D�Nqɯ7����oQ����.%� h� ��rC�ƽ+B�4��U �i-O.�Þ �5߲ܵܶ�\��Hvci �8>��¾<�B�]�y���e� ��� �$��c��2�7Q(9Y^��tj}^rv�������<QA-�j�H�G��@�ap�����Sú:��[�LD����bwA��ӷ�&�9��-%� �\�C_�)t�-�q\��peI8�~���^�烬�2j��!��%ٔ�8)"a�nO9�5>��
�U����m��C��lL�3a��3���R=
Iayw�4�}�ŝ�.�\�9G^��on���اS�)#���~��_�4=�m�Y�Ua�'�X����pҙw��'F���N�.��iSck
$�z+�O�GR �:\�E�GM����m�L��{��v��E��c��G��Ӣւ[�]4���G�}�N:��e�s���l&��ű�G-� ?��X��Ek-������m��l���J^�;=k¶z��=���t�V\'yޭ�Ieu5��a&�����j���#*���~B�9�U�g�'�P��HHc� ��ªh3[��H�c����k�˙��a�M'���<3O��ilbd����
i� ���1S]XJ���|L�97O�jK�K�Xԡ8���u�k(�L�� i<��c�g���־�*ra*5�O���r�sU�}�S�]mq%��̲�����Q�z�a�Տ��}<�|R��+)�^�\��wǏ�ٔ���T~��ɝ٦�G��_���x�ZӼ[
h�@����'䤼��8;ѕS�ۉ� W��$�0���1Zm����(Di� QU@ #8� 1���!Um����|�&��O^��g�F�4Ӵ���$���f9$�I�:��R�"�r.�c�wQ��=��@�8�s4ܙ�.�C�Mgs�����U�4iS����|�
`�8�p1�f�b�b�a��i��QH�/L���M��!����,�M:
KM,�JJ��<:����s����ڵ�w�f���G19O�(822 � ��zu;��U9`�j�ȉuK���( 8�,@����wľ+�ӡ[}>��E��� ��ʔ�Z1���G�*K�����o�Nm�_=�����3��r$�гB�=�{�K�������,�ڴ r���Hu�H�0O9'XД*��a,O��}H|Wc�;��W��yj��23�W/B���� ֜���N�l�Ԯ巶�hX�P"�|b�y��Hf�|��rG��b{d�wL<�]�����,�����>����'�W�\���&�N|�w*�5%���;r�c���};�$�n���j��!�z��� ��ib%R���P�m}M]kW��[�z��\X�f�Y���m@�d�!s�7}��!���uC���G�g=w)R-�]�6�8�݁�H��1բ`��$�����J��V{��R�_��)X��Ԟ�UYg���We��f�����?_z��҅\�>;0�)��]J��>[o2?��`�<��O��@W*�`�dk��C�QЖi59 {F�I�Z41HUH#��x##ι�s�o��'�i[,�ݓ���ц��0�ob���x��F��ѣ � Z�]Y�KЭ�,�nd�N]C��� !ڷ�{��� �0
��j1�H�ud����Y6�`:`��b��r@��])8K}��AT��c�X�$��c�`N8�f��g�(�n��t�ڻj���㢹�*6m4/F��MCYY�$Ré��t M�^Lgy�Gj�rm�r���5��k��� B�6:�P{T�j���컴a(��B?,�d=�=Q�|�e��4P�djS�5��� 9�Er�^Y|�}��B{W�EьNi'�غ\�G����ֻqyneH!��ˁ�E\�å�t�w��_��z7ϩ�F&�O�b�#ކbxg�B��y$v�Z��oE$��5�-�y'