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/SF156/154441.jpg',
'FileSize' => '302 KB',
'is_book' => false,
'keywords' => 'Soccer',
'real_path' => '/media/images/IMAGES DONE/Library/SF156/',
'path' => 'Library/SF156/154441',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF156/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF156/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF156/',
'file_name' => '154441.jpg',
'id' => '154441',
'sku' => '154441',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF156/154441.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF156/154441.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF156/154441.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF156/154441.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0409045',
'headline' => 'Longford Town v Athlone Town',
'headlineTruncated' => 'Longford Town v Athlone Town',
'caption' => '11 September 2004; Michael Collins, Athlone Town, in action against John Martin, Longford Town. FAI Cup Quarter-Final, Longford Town v Athlone Town, Flancare Park, Longford. Picture credit; David Maher / SPORTSFILE',
'DateCreated' => 'Sat, 11 Sep 2004 00:00:00 +0000',
'ShortDate' => '11 Sep 2004',
'LongDate' => 'Saturday 11th Sep 2004',
'db_DateCreated' => '200409110000',
'event_images_count' => (int) 17,
'event_images_count_text' => '17 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0409045/',
'w' => '1790',
'h' => '1629',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1790,
'height' => (int) 1629,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '11 September 2004; Michael Collins, Athlone Town, in action against John Martin, Longford Town. FAI Cup Quarter-Final, Longford Town v Athlone Town, Flancare Park, Longford. Picture credit; David Maher / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/154441/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/154441/'>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%2F154441&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Longford+Town+v+Athlone+Town" 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/154441&t=Longford+Town+v+Athlone+Town"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/154441/" 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%2F154441&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Longford+Town+v+Athlone+Town',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/154441&t=Longford+Town+v+Athlone+Town',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F154441&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Longford+Town+v+Athlone+Town" 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/154441&t=Longford+Town+v+Athlone+Town"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/154441/" 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/SF156/154441' 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) 2
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) 1758159846.7986
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/SF156/154441.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) 1758159846.7901,
'_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/154441',
'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 � � ��4jExif MM * J R( �i Z x w@ ' w@ ' � �� ] � �( � 3� H H ��� JFIF � � �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �h͒$��V֗����|�f�n�M]��W��f�J��ZJc�Sv X���y�����d�s)�Mg��_&�]�$p;�x��ٻ��E��N�Sf�͓��u�D-7�:u����u_<�9+�u�� �zUy!�W>Ya��Ho��F74[o6Ȓ;zV|�E�c���_��B�{g1ʤ~��u�8�VId��1�Ul:�T���E�X���^��\�Wp�;�%v:J�ҽ�Z<l]��U5֓M��*qҹ㹼�<���ϟ�1�F+�t?@4ն�vY�5ߣV0�ӻ#�Ս��bbT�֊�ܹ��C��x�_=7wn��>hF�0����u��姫-]��B�����Zt���F����.�>'dr�3Gh���q�j5��@c��7�6+���t����(;�ٝ�$:�����E�f�y����M�-0��\���l|�SW���m'��l^ĝ���;}4�q��+��3�[�������j���w��cңygl���NRI8~Ӗ�ٹ4����]3ö�w���M4����DX��O=�w�X��H"�%;�$�2��̎�X}��e����6�O��2+���m``@�iF��2��Pz�ke�oZ3��w�2E.�P��Tλ�k=�*ToԟB��q�+G���F�5m6� ��8 �Jj��k3�;�tw>
����; ���G���[M��89�s�|��u/eM>kfW{��'�<I���#�5Q��N>�(�e�\%���1�(�eH�*�ǝD��) �5�>
�Ǧ(b>�tVZ|��ĉ��zm��ձ.���!�g��{Ke��7ֺ��,��{[�9 ��PKg� �y��)����Q�5�|�V3�3��Q4�U�U��2B�|!1��5�W�[�������V�Td���m�. é%��KK{[&i "���ww=J0�*h�h�`���f�E���-����xW¶�%��З̿���$�1*�����j�Z=�Tp���vt~
�Goso�닩]dʪՌ� s��MH]��b���)���3�<K��EF���qX:e�W[��Lס��R�<���ٿ�KH���@
d#ֽ�D�lz�1�,@.2Ik��9Q��ޟ�:�b��c�J�/��$+;�j
6?
U�jV=,���6{3ʵ�˭&0e~��]]�}?�#�bx���Ş�N�"�� �|?z�
q:
�rz����&%'ڻ�R2Zt<yE�$�Zm���>��Er6+�#L�����$DX���V؝"��Յ�py$�ׅ�t*={ן[X4��\��I�/BAR:����?�5f�Ee�VI<��\�Ta� 9���sa}���~~�Mgfԉt�
Ck�܃:o]�ln\��#d�U��x��[k��Ao} �ͦ۽�0�dy�ۇ�*�jH��ܛ
���������t=f�
8_Go�$/�� ��N�w�|7�5���J4�t�ޫ���H��t\��c<���02�W�p�{���O'���U5u�?���Λpf�Ҵ�n&�e�v*�q����<� ��⋍KAԿ�5K�s06x[��Nl�+��a�:��C���)_^�j�M���HZf
��+�*䁌���v�:��|�繩�i+V�COQ�>�ulţB�q^i�x��#V��WE�:3�=�sG]�xi�Z�l��� <
������cz�����?0�V�)#�TT�̎�x��b������o�a ��Ojԣ�ەa��>�F��[j? n�^oc᧳�D� cWg�cB��б�%V��=U5]>�G.��{W#���i�sZ�$�dن*���-�5�Q-��(��
���y�T�MŜ���i�Z�<+/�b:��8�x"�%�M�/oz��Tݞy�
�ܱ�O�FwĽu4�=��M��*V,uAп������<=m�+?�\�h���m�2Hc�@�p pH�k�|����9u��p�E�ť�w��Υ�Y���^��'�zU��χ�Ksb��2��һq�����b}k���z�?��,u��5�_��FeXܔ,�)��2��kHM�ܽ�J�(W�#[yB\�-_���]��ki@U�2�9��� *��-_M�����֎壼��}�Ѳ�2r(�0��
:m��lʯ>|����_'��o�n��O x�&�b �"Hʻ[$f�G�$0OAs�/��cM�n��F�q��6Ȭ��G�iV�9;�� ������+���i��ϥ�>8��jٻ$����Cu�b6�G�+�ӎ�\����Z~�q���~m$���U�N��;]�A��\O�5)V�b~<�t��4���nZ'�o��/O(V@ pk��%ٍ����9��]�9+Z��=h�y'�u25���f�wtS�t�
<
���y��Ş�l@��x�ᱝ���|s�0��g��5I(�OVT�_in��� �H-���#�BL�"�ͧ���Ex�ſk�9���p�!�X�r Ȅ���H䃃��֧���+>Qfs��[�]:_�g;�V���U���t���F4�2X�NE_j"Y�NO\�+��\`�'8μ�Kk��F�zWw�f��Dђ��Ej�J¥{����,� u�� -<�y�w�-$x��A�ͣɡ�#d�H��8!��7� �&�o[���G�[α�8�<��k:��J��W�{�U��qt~Ք����o���>5�B�Պ���%̒r��FN{8&3�sһ��-��{�k��:�~\W,�h���L��F'�I�[W��g٘��uh�� 4n�c���|��%🎯�nm�M>��ż��e��BpN�3��-f�
b��F��Fz�U�J����Ns���V�_7ݣ_$A��m.H�1Y����]��m:ʥ��T��z㯧Q_{�Us¸� +�����[�
3I�S^�X��Hww�ǭt�b6�� zb�:����F� 3��[
�I��2$v�q���
~(L�2�?�����F4�E�Kc����-<Wa"\�f� <W�����Vr^Gw�2m�)�8��l�^��s�JJjDyv��x���\;��O�1��(��P3l�I��O�w�;�>�zQ
^�nƸ�j�a����]Ԭ�͢\K���$P� � ��O?�z�>4}�Q�M�k�Y<�6k���)���~dw��r�G�.��7�܆�Ű�X
r���Eu�ɢ/v���I�g�����R�l,l��j �W���x|�q�
�&��j�W)�W��o:Y<���]���!�"�I۞
t'�
Li��ʏ�Ū�x.��l������y?��X`iw
�I���?���ʢu(K��3�_�R�Y�?���?�zl�d�uj\@[*A�F�F�
o\��_��k2�^ � G2(T��P���9�NM���#
F9Vu작w�}�����^�,iv�"����O� =�7M��U��y��2��Xr1��ǵ]$�Ak��c����I.[*��_�V��5��k\�#�Ҭ�U�t{�Oʐ!`�f�'�:�x�8�/xv��ƺ~�y0Kk�u.�@
���o���=: k�r|t(A�{��+$�����<�II-���C�=a�u9&����$/H�P�P�Ug�����M|L۔�g�)F�#��p� :�����K��a��Ǖ�Az�z�5tbܯ���j(��[ɤqWǫEh>eb�mgFAc��>g��~B��isAw<�MP���
��4�]>�H���a�+��c�E�׀C�e��S����܅��a��&Y}�;�ZT����"��N�� �~���@�����n"�F� B�P�I .<q�z����'i�y�9�Y�ۡnT���1���9�Xzѫ(���l�h�-R�+ֳ!ҚD.�S�+Ӝ�&)�m`Zo/���HnGҟ�3g�ɞ�O������r�k�>��!��T�ZH�kۦ�Y���:{�C���S1���Tq�{S�5(��YҬ�n�_%�|�9 ��,�iZ��[��Xe�:�����cGI8��o/iJW��=�-sB�ڬ��d�Ϩn:��;Z�6mn�
��c���}�sa_��*G����
彬� �'���I�� ����$��I�Ʊ-�[�/͉Lt� ���E4����������/w��uc�����]X��{�[P��QܥK!��E N[�L>Y�y6���bv���,.4�;X٤]�rX���0�l+�^��uw_��s�ܽ�?N��1%���6�J�k�l�o5�W?N�/u�kTî8�\ŝf�W�K^�`@q��2������cӹ��\�Y[�xf[�f�]��
o�cRѵ{=J�D��s�D$�F3��i���;p��&-I���d�Eֆ��^_Ed�K�[Ǵ�¼�@ծt}x^�#��#p�?ě>3���#�͢\��W�4�%Xd����O�?��teIo^*�V*\�\�9�un�.���N
z������ a^Ա-�+`�7s���{�j$�,#'���%̮�9��g�x�W��O����� ��$��3���F��L� `y�e�x\̝X�PC�I�$�z
�ۖ��h�{-[Y����q�;�����dr�YH�����yN晔}�A�(��_ب��[H��r�b�kK�n�d�
d�F���u_S��~uU蹾h�H��3/�^�_z��_��?j[mY.,Y�� �I<����-A,�M���v��+<pL�G��a�`��^�{�+�Qt�~^k�O�Ƿ���"����\^jzM�*B�nQSw�"w N{cֽ?�����-���MF���F�,k+�0��S�'�JT��(Z�~� �<�0��}�K�b�������F*}�U��-��)X�۶�8�͛���R�8���$��� ��N�J���ru���{�=��i:
���8�x���{�q�|W�U�Y$�mb6�/��TƤb���J*S�Z?
� $x� ��{M���4��1�k�/�Qs���hs�@�Q�QJINO�38~��o�&֓M��L����S��MvT��$�Zºp�̌9�L*Ou��a��K�r$xȷ��z���X4�(�� �Uԛ�U�
1�m���X4ӸG�2GV�o�g5f|��x��جl ɥ�5֑���y���
c �XWٝ4z�XFь��F˨�6}k��z_<�� 湏Dt{�mN#ҧ�"�.�,3���29�]�Dԯ�z��%�嵻��n��#�1jǠ��Y�QFF�S�]���ϗJ�r�G@
*�}� ;�ZLڷ�d��I�Q��6o;y�s�{W���Oi����`��R~U&)Fѓ��ϵrb0n���F�,�(\jz/���u�_.�
�p�(�m��#ڡ�4�K�e�_��'��UGӡ>� ���۵��t15#MӾ���0~6���ڤ���+1hʩ
�0}���
b�;�6��__�Al8�vs8�H�%QN�齞� #�g����)�D�#�{�QOk�M�%�>���$�E��U,]8�i�V��U�Q�][����������!�H.y�<��e~����Zt��cfU����/U��J����� (��}+���\��8u+I`�T��N���ۊq[\�
( x� �G'�#�h�!#eQWj�� 5���� �Z+���<F�G��䓚��|۟��UQ�,�z�Gsi*��+��4O�YE��L�]��(�+�sV1�M�] ~=i�#@�D��ͽ�ܡĆ@��29ć3�j�;��&w�iI$b��Ė'�'��w���\]IT��"���r*���E&��F}���% u�:����sҀ=c�f�/�9^B����G8ıM���n�����<}�[G�1���2��ያ n<Ycj��E
}��I�o#�l��\�|��x�R�soap�ǜ�#�^l���i��O�� G�Z?���~#��d7�rNc�M�;rrq��Q�B�L���Hr����e�����O�ɽYų��&B۳��/<m�k�Em�i�G[ӱ�Z����f��k|�Y�I�Q�m�Z�lc�`�q���:�jiOI��x�M���܄�Fk���KK����9
s�\���.�ڑ�ބ��{)�U�du汼C�W���W(9ɳ��3��}u��Bs��TW�F1PI�u$��EMw����@�Q�?uk?9�\X���#��
���q�ەP�H5�c�+?�2Z�y� j��z���v�I#���^l�J�ya�=�¯%)mt`x��m���ͦ�|��s��x\���`y1\\^֮�����:,�F�T��>n+|9�cj�|�|ġ,\�E^�}փ��H�C��� �k�\��kk�W%���@�+�S�ٜ�0�i�qk�QyN���� �O�$39�pNx�1=w�c�������^x�o���
}���[m,7*+2����R�B-���/�L��4D�C))����ſ~k
a��]�ʩ����17��Op�
L��pv8�3\��|�]G�>^���x!��[�d�V^>���d���z�f�yd�y� /C����Niq�!z�i�ve��tȸ$w6�U�C"�/?w�D��{3AE�-f܇#��+rmo]���\*���tSi�{yr������h��FN
�5�o�ytw[όu�]�����9=k]�5�����w�M.kMIql�6��231�� -��~��:R{�Q�����g���#�^e�K�:M'�6z��e����0S� ��e�UN�$Ԏl^c*�;�9J������fX,�i�k��Q��Xd8��`LM� ��� �G�tՏ<N*Xy������X�d�W9�K���|=����kj:��1�l%������܁\ʊ��,ʣVL���ּ+�� gx�K�N�e��
N#���Efw���WG��\�������,P�x�� G`'$~�}�.�c�ϧi��b6�$�B�q�*�$��ϩ-1��]x��Kqa�Z��>d�i)��z���x�K��ɪ�^[D���bI��l��C��k:��-C���}Kz�<={n�v���C�q�k���4� ���hVY.��E��jtݜ�-;X���g2Hd���l��9�j�����Q0Ӯ�0�o(��o)���&ݏ_�Ei��O��4v�s�,�.p2rO�_P��tam �r�z�bX|��� �X� �A�$I� ��ҋ��������R��4��+n�� �E�X|5��ۡ�(��.o�(���v������;A>+�}�xz �{�7H��G���U憀����ky浹�Hn"s�:����#�{��6��w�%Y1�At�V��ߝR�L��F9P��Tس�(x{G�-�����W(�0R��\�R9��yO�~xcQ���h�Z��_���+�E�A�'j� z���g�;�Ӈ�R{�VA�}G�q��oO�����mc��l`d���OA^K���ݯ��f����V�Z�0��G��: I<