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/SF235/198582.jpg',
'FileSize' => '316 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF235/',
'path' => 'Library/SF235/198582',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/',
'file_name' => '198582.jpg',
'id' => '198582',
'sku' => '198582',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198582.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198582.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/198582.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198582.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0601108',
'headline' => 'Dublin v Wexford - Walsh Cup',
'headlineTruncated' => 'Dublin v Wexford - Walsh Cup',
'caption' => '29 January 2006; Derek O'Reilly, Dublin, in action against Eoin Quigley, Wexford. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'DateCreated' => 'Sun, 29 Jan 2006 00:00:00 +0000',
'ShortDate' => '29 Jan 2006',
'LongDate' => 'Sunday 29th Jan 2006',
'db_DateCreated' => '200601290000',
'event_images_count' => (int) 42,
'event_images_count_text' => '42 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0601108/',
'w' => '2026',
'h' => '1601',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2026,
'height' => (int) 1601,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '29 January 2006; Derek O'Reilly, Dublin, in action against Eoin Quigley, Wexford. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/198582/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/198582/'>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%2F198582&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup" 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/198582&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198582/" 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%2F198582&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/198582&t=Dublin+v+Wexford+-+Walsh+Cup',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F198582&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup" 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/198582&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198582/" 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/SF235/198582' 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) 3
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) 1758120359.9472
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/SF235/198582.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) 1758120359.93,
'_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/198582',
'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 ��1pExif MM * J R( �i Z x
�� '
�� ' � � A � �( � 0� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �����%�Űoj�k ��v�6��sP�I�3�s5����t&�������dtG,ޤ7q��f�mJ
�`w53E�z�4�M�Yڅ���fr)�6��ev\ҭd�����L+(�:��u脈�k��F��5�!{�R�t8��iXY]��Gmckqwq+m�"iϢ��I��*F��n��w���6$���+�Ϳ��\���N�z9���<��QkMH�wWi|S]��uؒTRF:UP�R���vü}yiqh���9�*R7=kLCND�VLy�i�D�f�ڱ�GJ� ���Hv���h�I����9�\/c*������'�V�|��
�.���X)�1�VbyH�ls��)���V\�fy��y���փ��b�Mjo6��iM�cto�o�Ն�|�iE���$����v8�2PT��t̋D�%U�5��<
�x/�}�͗��M?U���M~��#A$q���|��#$dq����:��ׇ�=Eˮ��6���s��6Z�H�"I�B�X�л�v�����j��Δ����Z7HfU$~�q�g�~�W��'UN�p���~��u�҇,�3<o�\N�i����?6�U�l� ���G��y�V��]ץ����<
�䓉g�FSo���X�Vo*���ߘ�:�O)ʑ���Qw����Z��AU�EKe�m��70¿>3ZWQ�B��"�3����]�z��^(G��j�Q�"2��~&2a�8�*hB��ǥ��"3�����mQWaӌ`H�%���ؒ�N�Hp{�J�-%�Bv��U��+��{a��@�L�קzқ�����Zib� �e��:�x�j�ub�|g�0�-��Y��ԭ�&$F�C) �2 }��/|C�5�]ʗ66�.�sf֑�#�[y��k�R�`�r�v<|uR<�Z3�/z�s����2\_-��KKq$��c��A$�@�=23X�:����E��D�M�3��3��ˏ� ��f�6�Q)�u9��u������r�!s�r��(g��$#y�Ye�;6>|���M��j���+�2�rᠼ���?���ȏYۓ�Y�}�B���z5�s
z����[�����5\ۆE�0ճF�U���R抆�go�$���@8����6�6�ki���SYڋ��c��=a�1������# ��+T����@`j�|9�'�^�. �+���
H�5�� ����2�\����sYUe���KU26�
��FS�5��_������>�T� ���+I��t�Z��d�MF1�����G�F?�{\�4�jrj�+���+�"Zܼ�1I+cً��A��^���;6�S�d�K��M��^ټ�q T�w)c�*�d�7�]r�F����^�Y�5�1�D����G'G�h�d�Ƹ�.���r�3Inqw��>�%�H��/��c
ganJ�q���]�(�/�='J
l�?>�ey�g��`�%���l�֕a��)t`-���ֺ}$�-�84��k%r�#:�� �E[I�d�9��*�A�SEg��f�v���"ڵ���*��ǚ���mKϩ��*����M�����榤�� �����/c���[��8H�B���
���>4��� 4�k�c�&���o�H$n� ��dg��.�.sE��W�3�C�Y�4w1�d�I0�=*%2'$��[$�jb���@�.���d�ޔ9%r%&Չ5K(%۸gEl`��Ƶ�\�%Iص�����l����qC�wbp �s]���_�>�9�&���
K�R�;�Ė� "�����`O#B���Q�i�v���I�t<�;����}H�#��V�b\g8nA#��Y��MP�C���ŜN��ppұ>���t5�Esmկ���L늒�].e[��x�C��ܟ_��]~�yuu�Z+H-�2/%W n�${�5�jq���-M�H��I �9�����`��ީ�ёꌒ}�Ҡ��uM��Q(Y��Z��u�vx����Y�J���.~і\.h�C�N{�Ӧ�s�)�fVf�¬��W�<zΜ�� \���I�A�NE*�[�-��4�/| �$�{�
ym�K��b�!�uSHc�M���
�<��3x���Ge�]ۗ�|S�2R�ϑ� rG�zd�|ԛ�Vs{#ڂTi��g5�o�٭�I3jv3:�w͈�р7A��S�!GY��a�?�{� Z�<�doi��n�����&�0}�Ќ�-�)%{������֟�tmw\��K(6Gs0�)�aL�K1�V'���i�#X��ر�n|+9��W,�29�0�2��ry)��[��//�)"J��{e���?�*�︺��mN<���;�R�>����HVIm���J�N�d��B9߃�i�GR��7M���l��iAx�/�O�0�X�0����~F�<��~G:� �6;U�:����g����^S|NU��d�pG�uͨ=79���5{u�oZq,L�%^xYF;����~�$��g�t�K�M�IX��P���a
��V����;�#���k���zW��K�����?�j�
�=�Ƀ�='�<�
���t���.5ؠ�ͯ6�<���'�l�<g8��6����� u�r���R{;)m��+�IE��$<
��FH ���|K��*T�ky���
��FG�x�:|������4�{�F�=-fGG��"�.�����J����B���&��c,O�v��\�����IƢ�91P^͔�W{���i�**��'� u'ҽWM�g}1\���tY�#���u E�,��T��[�zr����Ӥ��XՏG�e�d��Ɲ�:2E-�{��!�B�P3�
�����)����s0����F����0>�ظ1ө���� y���"�[3R����k�c��r�)U<�����2�A�=k*�[��N�#���r-�\�¬� e���&���=<c5����k�5Ois��Sk�]X���og��z�ʤ��<|�ލD���R^���<X���S��9��(\A�?J�l�B��2(���J�9����>�#&h���7���
p�8��^&��=��εs��I�>���y^?�*M_�?#�4��*�Хkc%�q������l�j�Ijx1Ш�#W<֦�z��=Es�Ťߓ^�*W�ࣹ�<L�z�^m�g��4t��l�O��BC)� �qO��k3�t�z�ſ
!�X�<�G@����K!����f����� pO4�,��$�3��f����pFk��P���w���iNj�o�[��!����ˏ�r;�ל�r��IЮ�kU�.�Q���V�9`#��S�����=�{9ZT��"�I�_�p㛜y���?|i�]��j�^�c���8�rȐ,�"7dLFFs�y#�8�m�V�#�E,��JK�&���r� �'ҽ�~Su�a�������9��U��}c߯���5� 閊M���!V1�S�[���I6��,گ� **�P��c�̚��gji�g��qI�S?��4�4!C G8���Mf�iD��t&�8��S�UK�3��t+S��wu�[iv�:G��*�r���b3�^X�t�ռa���ɧ5����5�ܛs��#,Ic���I �s��xz�%R3����~�I}���W=�~"�%~h��k3�om.,n����KyS��u�W������" ����-p��?��~UՉj�97�O��9(>i+ߧ@��7�H�?��4ӗ�Z�����ͷ��z&1"F���_���LʝW���C���0�����9�+L{@�2q���g ����ӱ�b�K��$�V*/��2;��$��& ���N�9)����X�Y2�B��rOS�;:,��l;V�]��c�pؙKCGFե�.�c��2,��M��r����;a�+���
;햷o�i���ot��� � f���'�CW&*�M�I�G��9O������:�m�c,%�`.#Fʞ��Ǩ��\�c��6���u��h� �
z�^�����1.x�ܧ��^�����jHky2������_JY^��kul�VUW+�Xd7������UݥO����x��%��Э{���W3^�iqK<ɲf�X� }�t'5��7��7��줞H�h��*sЃ��3�r�3�`i*J�5i_�9mj��������P�F;U�U3����_+I��]�jV��?�_�W�/u6mF��(��-?w
[�d@�Y��rp+�.���##g�r>��ZF��\!�;���mmn��R���[��xT�������xNM��J'���߄��� Q�{���0���_�/˭�v��[+º���h�?�Y��r�-��z��.0��G�Z <�|p���'�̼�����R�Z>��}RE�;xu� Ic�u���Px�A���*8�~YUⰴ��v���'�8�W�:Kd���yl�rYjܮ 9�QY�7b�;���M���
��+eh�J�P���եH����$$��H���>h�e��Ic0�C�ZţjIu�l
� g�j���jw�odn�A|Ff�� a�p켞��U~�mKF�:��Mqs�G�Ƴ�-�Պ]^YEnn�0�%�~�*�GRȫ�5�6��7�ˣΡ����;�w���AM�?Z�T�U�X��A*�ݗ�sݷ��ھj�k�!�H�)�#�0�1��K+��]���q�椽N� ��B�U¯t#��n��5#:��%Y�dt9����j��2�G��Y�_�� ��<������Xa��[�>�K��$[Ǩ�fؐR��+L�� ��PA=�־37¬w8ij��S���^��|G��zb�HUb�PC
���>�UGN���rI'5� bh�����7�V0�&�ې��X��ۚ�9��9�PW�Sj�_o��)҇,j�&��]ή�¶���M�K���]����8�p l��o#W�ț82ƿ#\v�+�v*�>��/���u�� ��Xi��$�]?�����)xV�9�N~_�jͼ��b?mU�O4� JX,;�5kc:�Iht
tMO]��54�ʳ�ݒ)]
$�n^G@��EE��ۋ��3��$�����r�n�
�|iR5qrK��Œ���n�AE*�\��N^�c ��� ��ɬ�O��5ʆIb *(�h܌�)��]��56�a>��Zi��Ow<pF�ɱ;��#'���%#���CD�4�-^�{�����Ex�+�0�84J��6�5�^=�,to�Ǧۋ[
���j�Ó�d7Z�mv���鿦���/����Ķ�n�]����r��1@6��Uڤ�#���7���i��o�Ew4��J���ӱ���/Ps��j�9);���r+֕i�%m��Ar~^�8� ?�zw��Kȣ����H��1�
��G_J�ˣ)b���s�$�;�C�-�l���㌞�C�G������V8�t���O�J��qp>~r���5��~�῾3��N�5E%����#�_
�9�������}6U��T����u=a�R��;6y�M�x����<7��}p9����A��ʀ��'�����3�٭K�O�OM��U��km?�K�\k2���Q,�$i�2 �
c�-�q^I��x�N��K�"K�x�+sV�:�9��'4�c��^�wit}~OS��~���z��|��yѷԢM��I#_������}+g�>��oc�Z�Go�Z���`����z�+�ɲIլ�iu8���:4�N�����8a� �[o��� �<������};^�ux �yj��� �h�`�}��J�(��Mh���':��{�'s��t�w4W�9�;�ي�ZK)EIk*+sҎdfYk��`UI
�|���+������O��7�e}�KK�*,�IROdrZ��-O����Pjn�-������$����RH
��H`q���^���9�t��յ
R�R6�O:�mc��m�l���x�Y(OC�$Ӷ������֞�u���9
껌G�X�*��F$��{VhN��k!��������j����.^� ��rG�cA����m�d0�224�?3j���b6��d���5�Iw����I�I�pȤ+�*���x�*��a*��|.�� �M|�1J�t�Os|Y$�"