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/SF191/174886.jpg',
'FileSize' => '598 KB',
'is_book' => false,
'keywords' => 'Football, Hurling,',
'real_path' => '/media/images/IMAGES DONE/Library/SF191/',
'path' => 'Library/SF191/174886',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF191/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/',
'file_name' => '174886.jpg',
'id' => '174886',
'sku' => '174886',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/174886.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/174886.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF191/174886.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF191/174886.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0504068',
'headline' => '2005 GAA Congress Saturday',
'headlineTruncated' => '2005 GAA Congress Saturday',
'caption' => '16 April 2005; Sean Walsh, Chairman of the Kerry County Board, speaking at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Pat Murphy / SPORTSFILE',
'DateCreated' => 'Sat, 16 Apr 2005 00:00:00 +0000',
'ShortDate' => '16 Apr 2005',
'LongDate' => 'Saturday 16th Apr 2005',
'db_DateCreated' => '200504160000',
'event_images_count' => (int) 97,
'event_images_count_text' => '97 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0504068/',
'w' => '1560',
'h' => '2173',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1560,
'height' => (int) 2173,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '16 April 2005; Sean Walsh, Chairman of the Kerry County Board, speaking at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/174886/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/174886/'>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%2F174886&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday" 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/174886&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/174886/" 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%2F174886&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/174886&t=2005+GAA+Congress+Saturday',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F174886&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday" 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/174886&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/174886/" 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/SF191/174886' 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) 23
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) 1758073939.1914
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/SF191/174886.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) 1758073939.1615,
'_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/174886',
'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 ��'6Exif MM * J R( �i Z x
�� '
�� ' � � } � �( � &W H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��OD�ԠK��$�C��ry��,���ok��X���XVz�TN���rEs��C��� v�`[�62��%ds�Ҵ{םg��P�v�Q����[���]��iⶔ}�vB����g�nQ�pB�+�����O��[����
+�V��gW���Szt��dv^�y��-��j� ^df%���U|Esoo+)~���I�+�،TU���>8�t$v�uoD�k/�l��]l�Atf�vR���1����MR8�Rhnvr�R^|B{��d�5eኑ�zX��0���枦�,��G4@|��+�o��� g_7B�q��J�Z�)F����
�� �����m �{��{'�<?��z�l��4��F8䟩5�J�v�՜���QVF��矍�|ROoGl�*��BOZ�#I���<=h7~�8�c���]ƌ�2[AT��F=�ݾx�F�M��X�@
B䚚rQz�J��mLzI,�'����c�{i��u��ۦ9`��_`+�����n�mnG�m�O ,c$�
�k����'�C�zg�^�W:(�;��4猫Z���rO�ָO�?��hm..�����)��w��TJ�7Шը���R��/��K�/�y��&�c�F�&� Eh�@`�dA�q��
;�^��n� ��H���q��4�-L�;������1�0v��
����г]A�?��#�?�9є�:hׅ5������ԅė�,��6&`O�;W�>�Ik�t�N�[���YK
;t:)㠷GE�8���5
��=ޟ4$n��# u �
z�,�
��Z�
I)F���
$����qI+ߩ�Q]�~Ax1/�4�a���'����i�h�@�t�*=F�o\�̥�m#��υ�o��uV�����*Z#��ߋ����4�bC��}+�.O!Y!Y$s� n��:��^�m;�
�I����(!B�� �_��Pɪ̮�F� !9��=~�J��5��pN:���SZ�ҌB�Hl�#֡��N�d;F9��
�R2�p�(����Ph#B�lM���G]'���9&V�!E Q�f�Ŝ����u!�C�{x�Y�2�w
��ɤL����Y���1]�jkW=g�� ���� <��*�i�
�L����<O����Wښ�g��S�a@q�My55�W���O^�y#uu��q�x�ñ�V�2�G�z��<��/�x���X&�`���z��\�}��=T>Z��L��q��ʒ����餿GR�1����0y�OĖ��=��0���t�_@O�Y���&�t�ִwČ�J�������:��݂�@,=G�rʣ���F*q��u���(`AI^G��W�xKX�Z���\4�|�q���DWf
��c�J�R�k�^����Agl�2�q �c^s�o�Gtֺt�x�=_Z�F�u%��Ż�9� �I���j�Ȼ�!��^6��-�W3..�w�yعK����vх������m� �Т��]��0���ML4��NҲ�N����Ǟ!��U���ރ�;� �a8�(�I��Ҿ.x�@��H�t<U��[�̭vѹ05�H��'c��� 1�W�5���Mq�O�[�#�l��pė#�A�3Q�W/s}�=L��t�7\�q� ��0{�`����<a�db�?�Ӄ�V-�EfW�� ��k9�o�/�� 9���>���1��ep[�}+���{xWh���e��s��9���`K�F����}� B�s���z�ɩ��1�����x��'�4�/5;Ȑ����^�b����#�O|p�<W ��4����M�|�_85�� �ƻ�("ե�K[9�epw9�J���*~ʒ;���K�V����&��E�s�׀mB��}?
�����,0�������?�9��~a��PZD��-�;'��(��o�㧒����0���t"@AU�ҙ�ܕ��R�Q��ϩ]~�-��*�S��݀��J\܊��+�2�ʱ�_@�ծa�p�t�X�ԺD�D[���g��YT�2.S���.t�&��{\Oj[��'V�?.H�_�������i�@�B��[��+��7fw}^Q���&�խ���K3�H<~�Z.u X���=�zV���t�d6�g�l[��p��
�t�ֽCC�N���5Ō�qw�e�=�D��<c)! =]��c|�gy�c�欔 ]�����*˧}�؞��?��y�sw���^��c�/�G�t��N*5t��:�Yt)>i;��đ��+�|�n� ���h.b���`�=�TpwGu|<+C�GM�x����ĺ�$�J92��G�x���1��'�����?+FWs�zW��QX������p�Z[��k_�h�_�:���{z�ɞ3eo\��A�+"6���W�
`�^殗1�~l�]�����IJ��O����S��߆k�F�C�]/M������?*���5�|H��k�t��$ q�d�go�X�³�V�4���]/b�}>�T�ڇ@
eNq��q�?�F�彛Gq6��2
�=1߹�^[n�=�*k��n˻�!9�u��?�M܂���Vpp�!n{�z��cԊ�{��=�D����h����\��:�f��6�>���Rn*?�%���`f˖ FH���c�LVܭ�$M*q�g$��O G�Ҵ-u n��s� L����E/��i��Q��m���|��|y�K�٦�s�OfĜ��\[JF�''��c����v��}
��kw�#pq�q^��G���jk�wP&�"1l�u�8JU'+Q��>6S�ezǟy����gb����%x�w�����!T�G��8՝��$��W���=�K��,�m�)���>�|�ꦺ|��z`
�N츭�F�����(�a���KI�.��97`��U(���}TVV�(����3�6������s�>��u��>���O)�,��W�;W�Ur�DZ����ӁՐ��b�YeVV��#�iGS��e]rI��j���9a��X��Ē.�H��Þl�5Յ����7ʒg-�@�8���7{��oʲR�U`���WR*��M�#gOׯ��Y _F�!�lg�v���w��N�դoi"��ҵ���2�F�G�no�:[�� �.XV�10�惱��Ҭ�4���0� ���&���q_�� �p�ʏ��X�e8��һxr=��P����y�8=��=�z�4�|�Z�>�5�P�=�ja�*�Y�2 ���^2�m��EN̖}�?��u�
'��9I��SdL�&H:)����k_�
Y�TI�d���*z�x�W%x\����g��ggp��Wkp�
�+� �'���!���>���)��3/� ��9^����g�Z����R�E��\�
��W���ӭy��}�[���ֻp�j7g2q�Itx�۲u�8�Ҩ�E���M��,�#*���d�o�KC�����
9 �z�^���YIOCȫpO@�W
Q/�%��4����R5��(�cJ:�εp�y�1�@�� ��~$zW_�y�o}��Z�§ˎ����O�(̺"P��(�=Gz��bsE�,F>�g��Jd�_kW���u{.&��; �����}�����^���"ɥ]�笎@��z�}5"]6|���f�w����Y��g�RhU���j�ʏS���&��
xgM��e4�%̈�ub$�;�z|� q�:V~˖�٣��GO�:�ݕ��"�G�d1��|�vgڻ~ڋc&���*JA=�A#�\� \�v5�k���G��.萨��D�w�cStzX/����;�����ןZi�\B���+:��)���ZEjD�dV�L�ޓ� �Q[�#�-�;G҅�ƺ�|ܒf9�y�q�j�5kK�
���|Ő�A�}k;#��������<��Q�R�e�W^[pdUMn���,���8b̍��(J��n��d
�S�#��?���~��'E�%i!�K��>���5#x�qz��4�֗����J���ӝ�1H�"�L8\��@`}�^�w�y��o��IV3s��
)
K
��$%r?��M�D�f��
/���-.��J����~��s�W��,kwo5��0f�yA0�7X���*ڹ�������͵����-۶.�����3U�n��/x�»E��r����K�܂�p�q��-�@���12���D����S��z��,R�p[���K�b�kv��y)&y��ӵ?�D��|����kA�K��:�������Q 8+�i�y��o+W<�`�z�MZ�D{�������T���e{
�l��U�6#�)�E/Q���R�ּA�x���nnnt衶�8o:���� �}N����{��|=s|/�_>����;�[��˜����Q�WL�n˽�R�v$�27+l`G�Z����Vմ��I��+�`�GiT�|���|WBJG=�n�_�6��� �����70��pf�uq�L��YT��:��f�&�4�{
gC(�ɒTE%�����Lެ���W}�9QgW��C���r/Xu��85���on�G��>|z��$�<͈n%�s�A"����*ͦ���0I���?�&�C.]$G��Z��&� �o�B$G[k������
��¦�`��b���-�g��W�]��Fi ��_>c���v��/�Z̚n�~�."��)c� {�s�'�Q8�&����>(����p�R��I$�?�*�! j�`��a�L����%ۜ��{�J�]��p�@F<�O�lB�t;0RJ��˯K��H�&R�Cq��<Ƽ��&�V�D(ɐ��S�'(���r�4�����V��(��tKDB��� !?砢����ʋw��&��yE'���V.�dnU�a��>Jc�=�t���j(��w��u ��>H�w2��r?ƵR����kK�[��e���&�lJM*��C�D���-M2��C�e��DI��21u<#��C��S��^dSFY�W��OÚ���ɡxR�]N�8���72I���4�4$�2�ED����c{���z��;{�
�_^Z7��qn%�r��F���@˹F㏽�s��χ
��C��ZϮj��7�)PǂV!��<nݏSָ�%ە�pQ��>o��i��^���
�Z���[�=ѐ��>P����L��M�&�c��ǟz꒽#���\ݳ�&�n!K�H%�t��ZMe�ۻ!ݒ�;�ݪ�9?Q\�z��Ro��x�����ӭ� ]ˈ���m<�21�s]q���(rԱ���U��Y#[�v��Q�������'�ؚ�}��Uʏ�}3]6_ ��:���SO�Z�O9�m���>�Ցp��\�j��t
����q;.Y�R\�O��O�8l�J��Tք�X����~?®`N�\dޕ����'��Z��k�(��ۗ�c�㻱� �?O¾�o�oh6�=��)y�8S,����9��c�r����)^�f���w�Ix�6ɗ�?O�r:�r�QGҴ��B����*98�!O>�ț���M�\���x���U�[�*����~��wz�:��i�?�r�rҽh$�Ĩ�Y���Y�mW��w��W�[Io �Y�RU@�8�M�m�n�����@7��/��<��qrI�մ��@�v'���<E���q%����^�?��egcnU�c�oQEus�,Ww6�"0�3� �N=� �(�cY8'��7��_���:U͜�k'Q�C�_��f����ٱ�;�9{y `G~ZoUqm��y8�p�(�<�Q�ң�FF���j��"��D�s�'�F訹?�zÏ
��x�M��~��V�qp��Mn�$�)8��� �'���uH��?E��^�d�4�5G�v�̺��Fi[��<�0�'