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/SF294/229531.jpg',
'FileSize' => '293 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF294/',
'path' => 'Library/SF294/229531',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF294/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF294/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF294/',
'file_name' => '229531.jpg',
'id' => '229531',
'sku' => '229531',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF294/229531.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF294/229531.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF294/229531.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF294/229531.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0611082',
'headline' => 'Crossmaglen Rangers v Mullahoran - AIB Ulster Senior Football Championship Quarter-Final',
'headlineTruncated' => 'Crossmaglen Rangers v Mullahoran - AIB Ulster Senior Football Championship ',
'caption' => '12 November 2006; John McEntee, Crossmaglen Rangers. AIB Ulster Senior Football Championship Quarter-Final, Crossmaglen Rangers v Mullahoran, Oliver Plunkett Park, Crossmaglen, Co Armagh. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Sun, 12 Nov 2006 00:00:00 +0000',
'ShortDate' => '12 Nov 2006',
'LongDate' => 'Sunday 12th Nov 2006',
'db_DateCreated' => '200611120000',
'event_images_count' => (int) 29,
'event_images_count_text' => '29 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0611082/',
'w' => '1400',
'h' => '2004',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1400,
'height' => (int) 2004,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '12 November 2006; John McEntee, Crossmaglen Rangers. AIB Ulster Senior Football Championship Quarter-Final, Crossmaglen Rangers v Mullahoran, Oliver Plunkett Park, Crossmaglen, Co Armagh. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/229531/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/229531/'>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%2F229531&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Crossmaglen+Rangers+v+Mullahoran+-+AIB+Ulster+Senior+Football+Championship+" 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/229531&t=Crossmaglen+Rangers+v+Mullahoran+-+AIB+Ulster+Senior+Football+Championship+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/229531/" 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%2F229531&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Crossmaglen+Rangers+v+Mullahoran+-+AIB+Ulster+Senior+Football+Championship+',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/229531&t=Crossmaglen+Rangers+v+Mullahoran+-+AIB+Ulster+Senior+Football+Championship+',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F229531&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Crossmaglen+Rangers+v+Mullahoran+-+AIB+Ulster+Senior+Football+Championship+" 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/229531&t=Crossmaglen+Rangers+v+Mullahoran+-+AIB+Ulster+Senior+Football+Championship+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/229531/" 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/SF294/229531' 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) 1758087566.6543
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/SF294/229531.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) 1758087566.6354,
'_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/229531',
'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 � �� ' �� ' � � x� � � �( � %� H H ��� JFIF � � �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �m:Xc��
ج�WP��%X�����X�ǣ�U��%�H��4�f�b
���߂�}:a���N�v�[��;��p�5�/3s*?�w�dj�јJ����>y�*q�9�w)1�>��yH�!��\u"�;0�Tk)3N�2�A�}e�5�vY��r���kb=�Il̇v�v�I<WS�\_XB�4,�0�H�������a��Rc�'��I:}�Ό��*d��S��:
%oK��/"���%�JK��(��zf��<���Ƨ�Z��H�l
��-Z�HnY|�Nk2�r�$k��PETnSm�����4ւ��_!�#��4խ k]����E7s^[A�w� �?�>�i���[�+�̱��u%�x^9�d�ջ�/�[�5m=��+�mE�pj$�s�w��L�ᇷzңW�9�>;ִ�U�ҵKY-/��hn ��F�pT�>�U48�^���5�|��cI���u1b�A�*i�
�;�+��y�6y�F�Eʹ�K�R��%�4�T�s��[{VIe ����[J�5���)J틙8����C(+�bk7�-�!23B�N�9'�sO���<�3Y����&ʎ�\�e*W���c�ɺm��Zr�!��ǡ�g,`�����}�[n�hxG�Z�V)�J�dg�f$�B�w�!�)�x��}�GC�9~��P4lG ��A����(��z��h�o����-O�Ư���t�V�>?�M�>�U+�ˍ64�~έ�-�J2��q�SF��ᷲ�Y�����xr/���e ����+�)�qi���l��c�3F�]��?��A�)l)*x&����qi�A�i3��y ���^�}@�jӴnO#��#͝�����Vd�ܢ;�z��J������z�m�H��I�U������29`�=*.t�����%Λ&���<�9�[�iw;|���A{�g[[A�"Ӎ����7�D1�z��Rf.g�x;���b�7w2���4d�� w
�z����yCcc#���91���I�jv[&y���5MKP�յ[������ǟ��`a\��-����@�ҡeq�]X��G���ۃ�ah�u�M0*sӭ���S�v��隝���n�1?�zWu�x��6�20&}��.X\~מ�G�x�R7�����fhz�i��`N=*b�V ��r=f�MB���������㍙Cv��O;��Ŧ�q��v5�Xϭ��E�1���HҜ���� o�{QH6�0k�fs^�R�̊��'���>�.��rk��Ҧ��T(��-�3��Z4�6���8,p+���>��M�3V��4�^{�ZF���5�?z��|'��/�żɾ$n}1^�t�&i�=�Py��$(1�I5*MM1r'{���<�5߳��k�����&�+�?�u?\i��̈��G�8���O�w՛:*6h�mj�k)�)�Xw�i��å��GL����l��#�𦗠����Dx��)~$��ڿ���<�)h���8��c�@J�]� ��v���W��[*��C¾ ��4iu5�h�\��q�\��m%�ܖ�r�H�֊wv1p�Se�]5�o%��#�*pk���c�G]>(�}�'�'m�K����knČ�5��F���^�耑�m'$�k|U�l��l�;85�.�qo���*@�Ҋ�W�)���i��s�9B]��+G�+��z��c�ca����eI��%�c�oh>���N�-DO��Uek�D�e���b@E�p=p�nt��k�e���("#��g�A|��`��Ek���J�w�����Q��N?:��n&��I�=��╬yr��r��{!�#�����Z��v;���n?*��[X֓rMJ���d#��a�����W9۱�ޱem�xpY�ȑ�Ƙ'5�y�����=�Λ��ԗ"G��[[_��Y�4'z�3U�o2�T'�YSn+Sj��JVoq��m96o�W�k6�V�IgFy%x�h��QJ)ų�,�ȵ�OI�Y�9�3]�[D�PH�=�Z�+T���1ۮ����"�4r0X��qԟJ�Vh쯄���,� h�KFj[ �nT�2G5��,dٴ���x��C�_����a��ݙQ"bTx���Y�u��/��́d��n5[���0���� }
o.�l�x�ex�t�<�"��pNG�.d�epW<Wu$ڹ�Z��pۀ��{jw~���G��S��غ�F|����ꓪ�*$#>��3�:����(����Z��[JZ\֟Zԯt�i%�rI���Q�O5����}:�:T���Ԥ��P+ӎ���gE�2O�k'V�=��4zY`۸-Ӛ�kRR�Ge:���r��F�_�(�)�>⺽e�{-��v�=�B�y�
2j:�1n�#�f��
��RI���*�"n]�$��t�qr?��VǢxH�����MG_"�����d��A�'<g�� ľ$�炵o.�m�����F�e�S0��쁰}��Tv8�|[X��u�'�NJKg&��ߗ��R�,2�Z�6ߒ,��S���,��l��EƔd�H�*�)�FPH<��M�;��χ5_ j�� �Q�j2��1��y��E�U�!�(���Yc�S�BKJ��ޑM?���QR�ٵ�v��v�v��x��7�k�G�x��S��x���G͂P��V� 093ĞѴH.M�l.-d��
��@A�J��8=����'�U8>�}�9��h�f��;U��͞�'I���h�v�/�$����e�ZH�A��t�hݏ3�OTg|F��Eŭ�#����Q�G���x
�0���q_��v߆ ��+
���ϻ�����c(��(��\��w�c���Q�ri�����H�}kŧ�S6z;67�sw,��0��>�����|���ѧ�6���-�t]�E�?dڍ��<
��L����%q�8��uX���}"����O���P�4��69��]�p��+��5�yx���v��Þ/�-��{~4�6�[yde��#�D��U
�8�¡��~g3��I�� 5�G̜f��W���>.��4H��J�i�ݣ2��x89+����|�6��M,)u��Vjdح3�0[����c��p��:>^��m�R� �$y�[���U��l�c��kw��m�� ��9<� �qȯ^��p/�-b��'i���iUG:��S�lW���am�5�4�ɋV�_X�*��
�֡�VYK���G�nŝ�y�! ;A���Շ4�3̈́Ҍ�tK�Y@��c��V�D�k�${~c�ַ�á���
1�F'�j�_��-��oƼ�e�)֩7v�B�U�[�����M;a;p>a�r�~�g�-$��:WM7�L��;=ÿ
t�����S;r�f�k���Iv��_8�d�T�ћ{85��w�����t���[�g�^��m+MoG�?-@�Vr?���rf�_��Q���8�/��x��qow�������wޣ�
�~"���v��4]kW�J��V2=�lu�c����y瞃<��'�j�m*%�F'�����i���}3��E�Kk
�6��_jVO3��(ʸ!A�!ʅ�S�8#����n�w���\ʭAg4Hg��%
���-��O�8�W��R�}�|��7v����|�ӭ$��m�����k�(�?�Vt�U��7wI!
�/�5䉎φ\� �Z�
S��ľ,���a� �䶬,!�8�'�v��Yf��ySo� �� Bq��r�Y~H�<S�X��M{e,0�Xt�xV3%��Tv����� �2#s��V��{�F������틯�Z��.�i�B�c�^����5�ۗ#g$�"�Rn+��$��V��m�d��*�'�s��W�P�o>cv��~�?cr����&��3y�?Z]��h&�i� y�V��X��9?k��ކ��2���A����M�ֳw�/`�d���;I#���#��2g��9Rt��������;����� ��5+�O���~�"�3�ٺ��P � �<W�x����Z.��ۋa
ƛ��nάNB�'�9\�
|�Y?i)_�Tr� ɬz��mH���v��B���Q#
��'�T�Ӟ՟�!�ᦍ{dqz��n.��x�N WE �F����*i7%���W�V�������i�
����_�H�n��0>f8 UI�V���Z�A}�XH���Y�A� -c�g' マF1�^W ,j�����n���l\����M��^{�u�d_����~id�0�3�}4v��I�k�Kf>���W^Gֲ<C��:[d�`瞽+fb�_��e<i ���6��O�����Q�iɝj_D6��;�旡
�~��h�;g�s]uq1[��]���Ub�P�g����R5�d�ԧ-�yt繽H�b�ڧ�K��I-�8����9%pv�H@��8o���D��+obb�Z�s�~|E�Լa����E��:L�l���A�֏�;G$`�N�W��@��aoi�����$���:+K&�ـ ��m�'5���KR��~�[+��[k��:����[�O_����>h�<zp�+����Fr��ۊ��.��OA����}����L��;�v]ۂ��''��^��M�jK_$�� �y�j�r��h�f������R�58�ƥ�@�`�! ���v��S��18n�M���B�貵��Pl;x��~�刮�Fӗ��I|�����4�S�zm��ޱl�$��x��mh��KyV��ᯪM4ym;�~%��R;��u��͎�������!T>�PE�Q�ۨɫ���I�!�
����-� �o�D�R%�#>����F�%!PO'��Wᶊ���Ո�M��u���U�01LV*A�-�iA!��s�Y�7������e�_�ӟj�Z��T�Ն��I���Z�Gc&��_��xऋ8`,� #����Nw�c��ǚ��Z:i�x��Ձ��� ��eI�r+���I��d���4��SXM��h��Nq~ �u�*��T��̚+�������pI99bs�1Y6� �����.���Z�-GS�,�>[`$|�FFI�s�G-�Z�jR���ۯ5��ʯW��2J���=�Y�+�̚O��{(m�e-�I$�Xn��R]�v� F1��w�\Jg�%wܬ�)-� 9�W�� ¤��Ŀ�fo6�����d�OJ�%�CۥV}����5
�zil��Y�}
���f�~5���-ϔm�mQ�T�c����H�LUԸ��3a��1�z]DF3ژǵ�d���\�/�:Є���ZU�9^��-��.aeʘ�9���vx7�|�\Gw��0é�D���tę ��$�eFA�j��_ot�_�ͩ�����N�[_:k��`����A�# �(�Zish�7uM$x�͉�Dm| Ŷb���7�!9h����h��n��Ioiݷ�Eݓ�X�a������˗CX���,�
��P�{�;����PC#4���y�^ii=�iz��C�VQK"��jY�}�x�IS���:�ߑr�Q�:�O�e�]�n�t%MRd���q(��H܀��.�w3�#��.oc��A.��Wo3g��rݛ
���#��~u��Tk��́�C���X�h�3�S���X�� t5I�M�d��1d�vzqڟs�O�4�ʞ�<��m�Y�吖frW�5!��VH�߲��*n���'��ꊾ�
�+=&!���h�+w�Qm(�]��0�Gtp+�aԵ9�����#8��!ڧ��°�)EX�0�Rm�'���?�/t�sUh��Z(�
pB+3��q� ��5�k��a�Y�6��+s�Ao
����·by�4cc&6��H��Y_���ï�����=�O�:S�ԭ.&"6$���j��s���]V�ٰH
ک]\���'�V��ư����m�3�j�_[My�;\ qҹ��9R�l+Z�㏖��i6���L7���co�"v����-��#;~�-ќ�P�ٴ�F
����&^�z�M+�U�*;�2<{D[s�Շ���v֊@�2W�WC|�8yy�Y��\��~&�6��{wbC]C�6�u���w!�<�W�[<�cI� ren�s���M��s��g��#�"A.��jv�X�mkn��!S�@O�*7c�_=h��A�o ��� ��[;�Z&\e�<|�c�t�R�uLƬ���#E��N�I��� �2�"��D���gH�`+�1��hu������ 9�Xz��WM�NL����D�:t��KHb�d9jz�7!�w���Ҹ�'���+��k�T/�I��`�&�z��4�FMfj��:��h���ۭTmr%t�>z�V�qy}$���
���m>�*���'�UFaF:���d�������Z��m�8;��<�`��>\ľ[��l�F8N���}+���0�'��dFa"�ɶ���$㢃�?���~#|/�����A���F�.��y� uo�僌��Il��⺒J)m��Ϥ�ձӴ�k+y?uoD��P��`���� $b�RDىen���sך�5H�.�Me-�bsq꺌�I�Ԯ�ƛ����������皷���
�B��~ّ���0�������}���ld�wSű��R���-��H�Gפ՜�׃���:�A�]'J�O����"��%�'�[���C�D"e�,��� �zv��Egoion|�S�\��y��uX�3�
&��0���)���b=��N�w�L��w����j"�7!�d'�U�݂I��9�L�-��/��pZ͛^�W�ҭ�nZ�`�&O*qN[EQ����S-�8)��t�Eb��n��{�_�B�M+��lP��Ӆ�`�LƐXkZA�$
`���=����"^\�(Ɉ }?�j�����e;dT�<r �H�_eA3С�;�[�]�sޚmm�� �+���K}ܩ�5�!��o�Sh4��sN��s�B�$�"<ʸT��֥f�S;Ns��(��Ƈ��!S>ƕ�� �>�"a!^���j9<<S�1�ͷSg�iK:��w֟.�2F���.:�G���{�`|e� ]�s���ݢ� ����Ͽz�C�k�f�E���OpeDr�I�\uc$A�zI�a/�nuFiRh�2�$}j������4��+��ԓ?s�S�� ���Ԇ�^1�@|О�� �&���^ҎV6� L�/vB?
��s�:��C�G-��H� �$=�����[xp�6��PYK�1� ��M)>����Ќ���o�X]�.\�8�$�O�uf��{�A|ɚ<*BW%�#�P'8�S�WN������m�Mj�R����:%�[^E���hs�i�UNr��|��xG:����nC��fI6�Vrˑ�ʹ��px��ꮥ
j�^�˺7���ѭ?�ltCFN��'8�K�$7]�*q��1�0A�p)$��XU��s�<S�[7�1�3O@�
\J r�0%Yq�{�� �]9a����zVX�'fހ1�^x>����r~bs�@I� �~�\�:y���(�z�� �Tjc�� `{�x��ɈuO��?@t<���$b��'