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/SF193/175993.jpg',
'FileSize' => '388 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF193/',
'path' => 'Library/SF193/175993',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF193/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/',
'file_name' => '175993.jpg',
'id' => '175993',
'sku' => '175993',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/175993.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/175993.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF193/175993.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/175993.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0505024',
'headline' => 'Offaly v Carlow',
'headlineTruncated' => 'Offaly v Carlow',
'caption' => '7 May 2005; Pat Cody, Carlow, in action against Niall Caffrey, Offaly. Allianz National Hurling League, Division 2 Final, Offaly v Carlow, O' Moore Park, Portlaoise, Co. Laois. Picture credit; Ray McManus / SPORTSFILE',
'DateCreated' => 'Sat, 07 May 2005 00:00:00 +0000',
'ShortDate' => '07 May 2005',
'LongDate' => 'Saturday 7th May 2005',
'db_DateCreated' => '200505070000',
'event_images_count' => (int) 13,
'event_images_count_text' => '13 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0505024/',
'w' => '2365',
'h' => '1688',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2365,
'height' => (int) 1688,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '7 May 2005; Pat Cody, Carlow, in action against Niall Caffrey, Offaly. Allianz National Hurling League, Division 2 Final, Offaly v Carlow, O' Moore Park, Portlaoise, Co. Laois. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/175993/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/175993/'>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%2F175993&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Carlow" 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/175993&t=Offaly+v+Carlow"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/175993/" 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%2F175993&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Carlow',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/175993&t=Offaly+v+Carlow',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F175993&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Carlow" 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/175993&t=Offaly+v+Carlow"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/175993/" 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/SF193/175993' 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) 1758143537.8658
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/SF193/175993.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) 1758143537.8547,
'_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/175993',
'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 x
�� '
�� ' � =� � � �( � (L H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �ʊ (�ъ��+�aR$Yl�+'a�0��֞���U$ٛ���i�N:V�ج�@�'�T3ɏ�g4�Guc��k�5^�,�O�VR�u�UF=Ȝ�!�0:�J�ի-��pdG�0�u4�6.ӷ��m��@sӌq�(2(*�`�d�ҵ�%�A �W4i�:%+M��JY����(�@�[�H�ͷ�$y6A��Gˑ�ք��=W���R'��Z��b�cڞ�1�Y7�Ò.�iɴ)݊�^�@O�Q�̸=�Lt�嫲**��3H�Ԯ��8i:�!@�� rEu�1������ �5�2��rs�W+0��Zx�����KO��O[��W����W�Mȷ�t���H�`h��`
V=뾜�R
pi��Z���9�P|�Vb��<��q�Jn�zqWaY���N��i��~�XV�2i�D�DsL��XAޘ4r��<��ҊlM�i���'j���[|�1�5o���ji$d�b]�t�9Z�B㎔�L�T�a6J��8�*TBSD�<(�M7#��L�H'�o�1��LDg�/v>��ً`�^��2ȱF��n ��%�ɻm$z��њ����6�VF�$r�3� ��ۧ=k��"��a��ĶĈ4Mor�8�2I�2x���9ΧZr�e7�~�M����>�N�!���3gY�cn�sca��n��iW��$�1yQ���~S��t�&�� ���sg�Y\hѴz.�n�����H��X�d���`I��s��8I��T�6�4��}�oyz���<���4�OG�����REo4�r2k�c�۱f�L��]�#�v��1����q�S
��k�ka��[�\w���lvϵ9- ���Q����8��w6zZ��"� '����!9=�
OSH���*DC�G�ɂ�8<S��횢-Եag%�0V���TPY�� j�K`Ѿ�moq�KI��{�E�y5�i��#�RR�<����x�Fh��h��[�'F�H\#~ ��x�����G��K�*�p���3���N+��cd�����)�S ���u���S�Ͽ�1W� ��zц�>JR�?hȮ����*+��t�L�obO���IY��$���6�qK�F��{��8��uEbp �YG^�dMs}��Ӡ0@� �����w9�6w !_'��Ƥۨ�����$}m
�IY���}��e��5�OE�Z�ܴ�Y��?y'w�H�ۓ���G�u�ͫ����]��77;$�c,��#�0�|�C��K5�R�E��uk�K��g5i�An���xe��w$�|�5��Z1�<�Pدՠ���Ug��%��+��r�"�>"q��U=�39��ݒwHy���e��;��Y6�:b�d2|�~�VosK\�al��9 ����h��a�.�v�,dtPJC�0�1Iǵe��m�<8x]H�C�3�U���$
�J#m��ボכ��U=�*�����,,����)����� O� ݻ~U�_�4� x���&��2蚕�݉��`fgl��t,X8��s�x��%]T�3�.�O��o[譪V��s�٭�gPŕX�b�|�J
*�9<
���oq�������2�5����;��b@� ���U�,kB\��o��2�W���b�y� ��*��S��ԶnD0X�yP<�q7�=O��^D�7�}�O�V�����4m>�$�D:N��y��yl��F�HA\�m����J�k�_x���#BY����!��uw�0����\�ǯZX�1?[��欼��e<�mwV����gw�y��b��X�wұu��!R���D�x*���d�W� ������57ͣ(�O�n�n�}iG��pMO%���I�!1�}������\k+ǖq�q�p���oօ���1Q�s�ۊoAnCq0U��AI -�AY���6|!k��IrIi�������=���֟���je���fs$���uU�;p?�u�b}ڇ������:7z~��4�-B'��-ܒ�|��e��+�/�����JF�u
�ۼ~���"��c��ѣ����x���w�04�*����KM4z<��ö�ڕ���ϖ�sI$S�l��2zs\���}z�GY��9F�k��L�I�~5�`3H֦����� �e�
K/�:�isB��4�g��G���i��O{����[Y������Ttd-����sRi�߅�Y�o���h�=�Љ ��*k��XV�������)��Qir+
B�J�鳻��{��l J�����������>�i,- }fd��$|�� �%NFx#s��;W
'�+��BQu)�u�o�=m>��zx��5�}5�3�ܖ�Y�g��>q�W q�}O��/�+�k�_=�S0\��d���� v�e)V�N�~�=��=}��^�y�����_�-����ϛ�o��5��UH�n@
0 �[�ͧ�7ς+�(�*/y��ͅ �4���2M]�,˧۔�Ѻ�洷�� �.
X��լ�
�ڊ��<�.�p*/0���۱�k�]�*�g��UxU�ķ^+����15���� !��0�\�� g=I�rhVW��.�Y�GV�/Ŕv� �K椿��) ���5
�%�V�<1B-������B | �GN�5�ԩ�d仝����I�����I�#���)~a�p8�:�h�^�;��D{X��Q�{=����V�QL� ]rmB8�nA>N"V�?���`%z�w��mz�o=�$�u����9*1��8灏J��__�}�� e�D$ݍ�hK�F0�*)�8x�7��y�y�kF4�g�սR��m}|�;�זR�;k�F�B�-��#�������Zr�B�������&�EbH�ֽДcc+��?;�1Fo�ק�����c㨮�hD :��9�[Ŗ����긬d�'gиbh�];z���Ec���kq=��2�]H|�~�+��z�}B��Y�6r���|��=̉ 8g@��\�8�q
�ԯ%�<��p��[K�h�>.�Z��t!#��t�{� ���C��,�U���:����~�?Q�6���|G����A>�W�f#�KFE`��y~���x��b~u���bI��K溝�q ������++����p��� �PDT��ڹ���5����h��$�Z�VH����US��L�em���*+܀�r95�=r�v=\�_$� "�n<��5V���UUa�� �J��5�1�%��j�F�4�o��A$ 8��pol�+������C9�kyCK); ���~3�y�Vj^�:r|�� �EH�?
�����J�e��Z���d7Vҫ�F����PH�ծn4_�4m,��WN��
���Xb�*�cF+�_�gC^T�,Cջ����=m�$����[�Yۥ�%���k�3���9#���@�u>#����jN%�k��^E�d�|�Е���SE�ǖ�ul�a�@����x:�X�Ѽ3g��R���.r��A��־��Oas�xW�6p�s���Z���Ct�����Ἷ@��5�֫v��u<]'��Wk�8�:�P�<{m4q�
�* P�9�!<}Mp�%�ͬ�eöbk��R��Տ��*�Y�W���0�G �\�<Cna|7��P��<���I�� g�j��3�NgTaCsҊ�ѡ���BL7njl�2��i��U�r<��v>3���|F�kO��N���0Qӣ�����r�ҵ���fRO`y�����V��ќ)J$�~�����K�PBF����� ʰ��T�]�W!�a�s�E����g�����R��ʄ)�4�>\���=�:�|i���t��/ܙͽ��-�Gp�c`qԫt9�:8jR��'�IS8�G�9oMY7ٻk��s�߅��ݟ���kIbC:��B�?F8��q�mSR�۸c�I�]Wd(��=���ڿ�����ƽ7S�X����t:E��G��0�\�pFb]�A���`�W�x� �פ7UeS�F ש��\�~'�8��f��{�'��4��JR��[yؖm�� gӊ���% �+��Ё��� �[��>��Л�ǛJ�(%=if��Q� �rO�hE��Cu��tT� G��ج5�tOnt�_�K�� h^^���D 1�هG�9��u���y��YK3x�J���D����N���'�8ӝI&Ւ8�*k]م�G�mϋ��J"|��1v��;f�s�V�<3c��Z��i4I'�ᶔ3+�%�:�v�=�#�k���g�<jU|SM]�Ə
h�T�Ok�"|�[��=����)��� ���Y���A��*�OF�7_��xX��#��
C��=+�9���1��+�3S�p@ȨQHei�� �2[�O9_��U)�?ny��H�ц�+�a-�f��%��,z���%��N���5cQԮ5+++!nmZ��]����xǸ漼u��>�w��OC :o�-Zz�N�ᕼN�_H�12�&x�N=z~���[�j���$�{k��q*��A^ S��$V �R�wG�^Q�UˣK�G������O]x/�z�<6r��Z��|����6� �S����|��~����ڤ�)�� ���T���N8�|f2X�E_eQ��j��k�$}B�T���,e�N��]��o�=ơq,�yh�~�H?"�x�-��8�\� ������őv@��z=
zyNk��,��;y�� �x��x�̖��fL5��E���#���i�}��kv�.^�庅�U�O
�XpFwx�X�a���3�p�Z�,:N#�$�X��E���Av ���mڤ����W����m�U�f*~�E|�L�4��a{A�R�nVf���mW�A,�v���(þ� �r���G� ��Z�a���Y��#�/�q�1�O�N�����6'/T�ǯcG��iW��P�ӡh l2�gi0�� g�N��<5���t�>��]J�$��R�<|���<י��cq���V�Z� Sƌ���;�:��|u�G��G�]�_:�Fxd8`U[gNWsc��W͞.] ��P]If��]��H0Ί ݎ��q�q��_U�ѯJ����m�4vf5!(G��̵^I�NU��_Nye=JA) �X�I3D��$T^�M;j�9�,�;��( `��$p u�z\o.�ojK4��a���c�qT&嵝��Z �X��u����J��XB68����#=zִ��s2�ss�q�����*=Z>�N<�Y��-R�A~$�y7(&LzmpjƢ� �r
oI{����$�H^7܄|����j���{H�/���5�,�9��ةo�oiB�~�K�e��!��ގp[�\` Mq32�s=��Ѽ��c������ c�_z��J�����[��X����m�/�&���~�[��r��+�*!�� 8�q��{n���S\д��l��:���㵵��QC�,�!s��PO,A݁�V�Ҏ*)Ke�������ݜX����[��t�F�����îAc��x
�Zc�q⤗]�6�+em&�pw)22$������i�zh�]v�=��bgj�z��i����~1�6P|1�;x�m����� l� ����b�>0����WJ��*�| �b
眂W�����MY#��)�OS���i��؋�V�������n&iK�7Ē���Ҽ�"�9ۊ������=�O��L����qN�4���A6��p
��9ی�ў=����*����;;F7FE���!@�f���gTW*:|����1�v�ò1�sH�Ъpq��S���ͥ���!s�G=�TT�J/�*��f�9�>l��(n��
��_ֶ����^a��G�� }/� ~��(�%���/�(c^������Z������E� j|~��G[0˵
��z��}I�.r��_�[��ԯ
q�m|�� ��\x�x�7ّ�20Nq��;�+�GR����1ʏ39]���뺆s�*�qT�Bq؎�A���$�v�Ǎ���s�<�1�+�<�i<5�7C�#�����'�!��UG
�K'��!��.��sF��3�_�C�+�ֲ}�^�=B���os̠ݲ9o6n�'<�ǜz�R�a���+�}+�jsM�>�+�Z��d��Dx�
��}
n�|wqYȱF�1�2��y�Ө�/9S��O��FVf���G��R��a�sk.�)@B�w'���g�_i��Z�[�:-�m��~_�N��@0zv橍D#i�����x��̋�ָ�`8�6����x�r��ٳ\�m�)v QUZ ���ǧ4�.1�k��s�����4KN�`��A�D�i�R2�X1������!Gtdyq���L`㨨[���B��˭x<�ˋ��پF`��~�*�%b+�)$�?(s�=��)(49�=VV��鵍Z{��o���WE6��<�O��0�B�Pv�z��0 s�#&��i�Lо�Z��Ў"��Kf��YЩ��tz&�s��okz�,���~b�=;����������U��''��\��I��8�4�����q9�"^�^�gK�xC�
�llu��ـ�5��M��h�/�QxQ�*�vǠ��^�l� �i� y��3�I�?���*��E��f/�W���x��������x?��j�$�W��e��sP�N��%o��?<\��V�L[��u&�����9�z
�6�O�[M%�oa`�$A�WJ���;��CQT�rt% zsN ����&