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 2/',
'drive' => 'D',
'originalpath' => 'D:/Images/Images Done 2/Library/SF23/023721.jpg',
'FileSize' => '3 MB',
'is_book' => false,
'keywords' => 'gaa, hurling, COMPLETEDIMAGE,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF23/',
'path' => 'Library/SF23/023721',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF23/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/',
'file_name' => '023721.jpg',
'id' => '023721',
'sku' => '023721',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023721.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023721.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF23/023721.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023721.jpg',
'categorycode' => 'ABC',
'moreimages' => 'ARC0001018',
'headline' => 'Tipperary v Kerry - Guinness Munster Senior Hurling Championship Quarter-Final',
'headlineTruncated' => 'Tipperary v Kerry - Guinness Munster Senior Hurling Championship Quarter-',
'caption' => '22 May 1999; John Leahy of Tipperary in action against Tom Cronin of Kerry during the Guinness Munster Senior Hurling Championship Quarter-Final match between Tipperary and Kerry at Semple Stadium in Thurles, Tipperary. Photo by Ray Lohan/Sportsfile',
'DateCreated' => 'Sat, 22 May 1999 00:00:00 +0000',
'ShortDate' => '22 May 1999',
'LongDate' => 'Saturday 22nd May 1999',
'db_DateCreated' => '199905220000',
'event_images_count' => (int) 40,
'event_images_count_text' => '40 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/ARC0001018/',
'w' => '1780',
'h' => '1957',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1780,
'height' => (int) 1957,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '22 May 1999; John Leahy of Tipperary in action against Tom Cronin of Kerry during the Guinness Munster Senior Hurling Championship Quarter-Final match between Tipperary and Kerry at Semple Stadium in Thurles, Tipperary. Photo by Ray Lohan/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/023721/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/023721/'>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%2F023721&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-" 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/023721&t=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/023721/" 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%2F023721&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/023721&t=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F023721&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-" 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/023721&t=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/023721/" 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/SF23/023721' 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) 5
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) 1758160738.642
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 2/Library/SF23/023721.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) 1758160738.6286,
'_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/023721',
'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 ��E�Exif MM * J R( �i Z x
�� '
�� ' � � � � � �( � E H H ��� JFIF H H �� C !"$"$�� C�� � � ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��$yaJ��3[�J)������:���9�b��/��z��W��M4�T��Ӛi�"z��Dc��ZWH#�@a`�F:�r������H$�ݨ��uE8s电��j�������W�������bT��y�2��\��u�j7-.tRQ���w�G�Ӽ�I������ἕQ'ڤ�\�J��Vn���%
nR���:�I-J��o��+Ө,�2ž�C�i��哨��3������c'̛K��a��
��2�NS�_*�j����P��:x�6/r�+3�-������<
Ft�❓��R���>o��[�z��G�y,/����Ee{�B���ϧ��,tז�� a,6���
ͳWmNp�*��{Us]�Ėn���3�H�N�-�V%i� t�Qp��mĪ�d@�����Gj�+���i"S�}�w�^ �}j6)膬�`]�#���%#Bh�
����Ӗ�Y���=�S�"��a�u�Ɩ���T6w�g�WbIlYADŽ�j[*(�<�6�I��B��cNc���"�e�&���r����$�)C4{�l� 9<�j܌���|1�u� �A���i��U��u'ۉ<E%IV� 8U��V5����n8�M:WѵN�_�[s�Jt=_Y����n��.�q:��6 �y�>;8 e�*�tc)�3�/�T�h�����y���?۰�x{[2�^�R�'�@:�����8��G
Q9Zގ߁�<N&��w�:Ox�y�����ڮ�E��\�Aon��*�4������ P�R��ae6�e}m՟,���[���A$bE\�ZǙ�փ���A�v��2�*D`=�{�B�F�-tg�VI�� f�����X�Q��@��F<��FZ{j'�O
}����Zl6dwR�?���� ����8��uzWka��ܱu�6��OJ�f��Fk�#�I h֎�n��(�JW4���)1��;t����n�$�;�d�QSf�RZ�+�I�0=�Cz��^W1"𫹉�(�}9�mN��˒
��u!N<�vG��0�{� xOS�O�.o�Ii*�Cs�Ա\�
��)!�f#���f?S'�(���S�?�rm[}�{h���ꥆy�r�M��Z��?�~��^9��4{Uk�tx]�&(��ϙ�߀��0��鑟����9{<+���_�'�<�J�����{s~������o�l�]�:j��M�xV���d��Y�y~ld���b��¾cBQr�{��s�0uS�e.���o��y��]^���F�P^�wo4���� �^<���tc��y��ee~�� 3
=��f����E^ysm!�9�ӧ1Y{i�V�u2������J�� ��y�=��HI�v����8
�#�5�R�G�� ��U*p�(��i~�ff5�E��[FW,�xb��|ة�jvEH�2�4�}*�3o�;��Dy;zQn�)�!�C�y�`w
�Kw&���h���_,gՈoCKO���u�'�Ä��从(@�^9bl+�����V�n�$Oo��;��J��Id��0S�5[��MA�C��&���7�O0c>ƅ`i��W�d�rG��4�h�Y5,H$�s��t�ث�c��d��^Ѽ%
����ͳ���QL���F��d�&ÀI�(O*���S�o�F����Z_�z��
�1��7zS����IZ��O�Kht~_�t�[]�7�iFE�S�W>~�$ ���(}���1��5���ͽ4����� �a�e��t�+���^�����w�xj�6>��ӥܒ\\�p��A��'�q��%��L��J�Z岲I+��S帚�uTh]�7v���/�穑c�>��-���a�����d�pCQ�/:��~*p���xT⮌+MF�#���=�F�3偞q���\LkéI[MR�3����g��:.����4:�Q�}���M0S'�ې6�9%pr(��eVW���H(�ǯ�Ė�_��t��Tu�TY䝮/?���� �麽�V
�V���*�%��~
��Rڹ;���x�=4�����6�+-��u�lt�^��v�Q.Y�^? I= �.�vt��`��{+�z�O�h<�X�
"���o��NӃ�U��+2��|!�h1[_K=�������oڍ���4o�F ��=��BFT�*�c���zhA�A���'�A6h�g�Ӟ�*W-�-��VSP��W��d�Ht�e@N�=�j���i�1�7\-�m�����z_P���|��g`g�4}~�r�W��A�x/�*Nm��Q��=�YV#{����&Ka�;б�{���Oa<A�=R��M5��$*�jY�� (�I 9$�R�ӫ.X�ke�iA�H�o�_�~����X4���˻���.�*���j� |��f���b0�UT�R���٥��?��(�:��sJ?���� C���4�h���F�4_h�
���H9�O�vDf(��pbe���V)ͭZJ��/�:�:0�S�
2n�+������n�����:���k[��<7DpON9�z�>�.��$�ﺵ��f�����vKg{�ۿo�����Ӽ���fcܞ���:��r�G�W�I9Kv{��>.�f�muo���"�%� �H�|����A9�4�|��3����]ס�e:*Q�oukt�~��������ӧ��#!e�>T.xR:�:WL��I4q�jJ�?�J��ޏo���ԭ�M?QA�u���П�?��6�zq�i�Q�%��lzY,0�*N�4��*_z�~[�~��5�}N �1�����q��Y�?����S�����ptUގO��ޯoMGx|y�*V������e�������B�z�q���hdQ�r����K��NjO8�EuJiy��$��ī���^�2� ���j>c�W��MJ��i����k�Z����0/� ���.[��;?�x�d����5�7)"+H��3�� �t�*�IJGejN��Z�ui�mA�m�̂8n��݁\���<g!x\q���C]]NW'�� ����uO
\���J}�3e$����������e5�����:�o�j��X�nW��x��@>�<�-m-J�Gi���;��z� �@�$�֢Hޜ�7t�O2#��Z�Q�uC�W45�6�cu�x�5��ٮ+$zi�����V�s꽼/�����A�� ��<4�����$���S��<3��Gw���@����Dg������;�Ƨ7C��^��xJ�f��� �a�퐃��|`��ګ-��Wn�b �J�~�_�>i���nZi ��$���=�`+�!I����_Hh�68�]���{d<9� ����Tzw&�J�������{v��~,���ɯx��Wӡx$��8� QU P@�r Ͻ|c�Mr�o�w��YZq��3��*�gy>ͩI�\(ȃp'�d�z�^'�F���]��vq���3���+�d�|(�1��Ԣ=�}��\I����_E��,�^�F�� �=��lt�����+�]=�^�-�_�#�>��ν��_��h��I_���*eغ�%o&Pҵ��n�� V�F0G���w��8(sOe�ʥR2��;_�^!�ѵ��/�d����"r>H� n�ĒG � ���)ǞSkW�ˍ�NMN_t^^���=1>0x��C�i�r���l����RĈNH�� �'YB.}����)т�ݷk�f�S�G������B;���˂w��wWTs��!��q't��*qt��۽_����>��q��~��7��G�+�-�sťi�2~�0XU�C�z���9$�`t�5�T���Jt�U(Rv�Uo4���ԥ�����'���́� �eXG��=�����§gs��4�o1�:4��:m�۫����$|����䖺����h��9/�<��lo�D���JdI$�$�9'�3�i�y\������6���Z��]!�O�Y����sx�ڳ��?h�-# �A\����w̎�\�2�?(�ָ�����5��t��l��ּ��\�wٸ����I+�i=��ZB f>��EI$��`�=�G��B� .����,Uc��>y(D�?��$��P�L��۷ �;H�+���.��G}��B����!icr�)��6@d{W��)|'�I��^���H���H�R��4-�@�� VX�R�JT㼓_y� X�{&��w~���4�2�[hm�D���d���
����� �`t���2�F]%�#{���馋џw��hc��6շZ_q�<����]��
%�����4�Ǽ�E٢�J�e�0U��浂��� Gޕ�d����ݭ5�[�uj��|���}�ճ��R�������{5�����s���$�)}|Ч���r+:�f�_f�˫�[i5{��~��"�>y�m��$�O�[vh"���/��/�kg��k!$�cG��
[v���$� ���>�2tԣ�K�˙�e��KMz� ]��Skfݺ$����sοh�kM���vΚ���$y���a-,Aצ�t|����<7��a�S���˲m-�v}Һ�����%jS��|�J� =���ɞ=35�x�S��l)ʾ�l~m�E'�g]��n�;]M���#��xd��I!���9��@5����f���Е�5���Κ��6��x>_x��;��4[=N�,/�?9��
�Yp@�4�>jm��2�t!������]GJ���N�^�U�y�K��|��PG}��sֱ�ZI#밳�)ʣ��d�L��^f�
����49I鷿�q��3�`��֛J+�4f����s>��� 7���H0�+Fwa���͎��U9JQMZ���b��o�m�ϧ[Ekn�R5
�<�O�3I"務��p:��mU�3u;���8P��s�R�m��m��C�t�-)���x#�4����ELL!^�T�:�32,�@�"��4�v���O���ߌ�1�$u����~��=��uŜ�ym:��=9�kS�ct�p�)�VoSм
�XBM�L���̯Y�ٝ�H�$��;->TW�U {�
,Mmv:�����s�{ǗR���y���_�Q���E��qU�]K:��q[n��j�9GK��
E$�tB�@���mF��5��593��{�0�Mg{=����M���bÜ�O��T#R��5x��[�s��V�*{H;5�[���� �G���K���H��A&~�� Ͻ|V?�p�5��>��3�p|Q���[��~k��l�g�1�Y�j�Q��J/=rҁ� ��Ҽ
��R~�qk�E��=�<W�k���z��o�_�m)���=���r�ݾ7��,*�����:�
�z4�%����͝�;�*.W%���g�O���<A�O�g[3�rN�L�5��I)v��&�b�0 �rH���a��"������M:BY~gN\��Q���ɮ�59o�~�����-Fݤ��Fi E�a_����A=�+{H��&��J4�7�Ou������O�n����kml[Mԑ�谏z�nV��q��ҳ�j5�(7�_�^'/������U_���wo<�R��7���@�:��u�O��y5g����\������*����P?�IZ���q����Uw�OZ�V�Y�&���D��˷��Æ|`pH�Y%˫83\��7h|=|��C�?h
>�SJ����֬Ff���**��*Y&9�"ܓ�[�I.SL65� G��ֶ�c�{���V��;�#�=1]4$��x��j���6�r�0 f��_eyhs�g�
ɓ��q�鬱��ۅ��ܴ��ajT�U�-��r�<�Af��k�n�,wF�Pu%doʧ�G�����?��g`�h�(5f���g�|6�u�Q4��k�L�Nh�W�g�o������^�^�eCϱyFR�7Qg��U��[Z�)!xֽ����eO߰#��[��Ԗ(?������p�$�pr�GO�j�NQ��w���j��W.����gy� Xf�ܟ+��wpA�s�zk�I��:�wB����� ����[W���:ʃr�C�֜kA��O�B�s���ρ��8��ֵ��V�=?�ЊE�Hڠ��Q5�I�kx����9�[�2#�+G�~�n^F �k��$��r�J���%������5;��Z�֛i�Zy0Z���<�UK�%FIc���9?��5)B���2��8�Xj?/y-�]/Ko��:����&��x� �kg:�~d���'�|݈�⯄����M�%w'�[F�V��������V��)�N�+�w�7�O��ף��j^�n�bմ�Z%Y�Y�BIf���烟j>� �5��h�72�<6),F]UEI'���U�g�rڡu�i��%�B�4$����gH��?!���UU��|U\&'.��!%k�}�6��2�?r0I����[>���k�_ש���&��8FbL��@vb������.v��ӡ*�oM��n�ܠ���ҵ�[��d�$!�sU�"k�jjh�
�>n��aݢ�>c���fk���w� p�;U�vG����A>��ʹ��0����cu�T�8�ٙE�en&q�L�tFև�6�t�:�8�zZ��=�&��5g�1JOn��j:e����xJ�1�'��!ZXZ�,���;���3֭.����ȇ�^�9��d|�jr��d�F�Ý>�X�#K�% �= �^n1�:r�<q�#��^Чծ&�H�|so���Fm��F��K��w�?3�����$�M��K�GW�-[H�4�4�8Wώ����<�
B!Tq��ך�=�n������U?��V�� ���p��{gLGl�L�������M(I��>gm��_��]�����-���a0��f1JA*��B���6=O�)B
�G�lb�i#֬�g�B�_�^H�:�� ���~&�%^kkq���y����@���������)�<�V#'��A�/^Q�r=LKKJM6��� �+�[C
���XOiw*m�Ό�!���z����%iI��8w&��̪P�ErTM�����oQ�!���N��{�:F��I@���9,�H�� w5�������E���f��k�Ж�ps���w�[�;����P�HὊ��Ik"ȥV`j(� \`�#��j�R��KI[��z�~��^��t`����߮�Z6������$.�ln�K���|�F�tPO\�9$�}k�� ���1�LS�W���ΛD��K�W�Y�,2�.���
@�[����(;S��l�WFn�;^js���HL}�_�1]Q�C�lᰴ��~�����Em�2�;qCg�6�g&����=뢄=�8�u](�aGٰ"��Ug�J��!]�ZL�1Q��+?}�i�M�EIc���s�Yܷ�y�P�?Z�����L�O^��ƋbHp��v���v�]�?�f�5�n������+�L�nq�<�1t"�?��u�=?�b{6_�*��=+���B\��<~8�s�s��~�}gt�)x�#���kܚU!���1/ [��}�*�Z�ƭ*2�E�Ɗ $�c���p��zQ���� ���:�:pk�� �=R���k6�z�:J��?�J�M$x�%ҴY"x^;k�
�m�E�s�^�{H����>�=��������<�J���)<�6ld��be5kh��$����k�⨆����úe��Qs�=�5�1Ҡ�jdx�M���˘~�M��q^#�)R 표91���Fi�OS��0��5JqӪz]^G� ������u���K�Aİ����+�C���ּ�;���-S�3�g����ף�~G�Yx� UV�b����e��=�~�*��i;?3��q]d�1q�K������R��L�/E��`Һ� �\d�9�=�t�U���8�WM�O)i����?�-�("