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/198609.jpg',
'FileSize' => '357 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF235/',
'path' => 'Library/SF235/198609',
'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' => '198609.jpg',
'id' => '198609',
'sku' => '198609',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198609.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198609.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/198609.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198609.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0601108',
'headline' => 'Dublin v Wexford - Walsh Cup',
'headlineTruncated' => 'Dublin v Wexford - Walsh Cup',
'caption' => '29 January 2006; Keith Rossiter, Wexford, in action against Keith Dunne, Dublin. 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' => '1835',
'h' => '1683',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1835,
'height' => (int) 1683,
'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; Keith Rossiter, Wexford, in action against Keith Dunne, Dublin. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/198609/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/198609/'>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%2F198609&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/198609&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198609/" 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%2F198609&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/198609&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%2F198609&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/198609&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198609/" 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/198609' 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) 1758105787.4549
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/198609.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) 1758105787.441,
'_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/198609',
'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 ��2�Exif MM * J R( �i Z x
�� '
�� ' � +� � � �( � 1� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �-���ʭ)T�~�=��|��N��<.�2�q]%��02u�>aǥsʻ��Z�����j�$Z��SW'f{l{WDr�e
�H�O�Z�)N{�o���fY��*v�Cn�4Mj(=kU���K�]i�Y�gm�إ���P�:FedF�N��[ ���s�t�NW�b��V1�0�n/���H���[d ,"VDW
��p�F�s�^*!���2V4�+3�.�
{�f�DN ��
53��3��F?3��6x&�hf��L��{�l� #֛/ۮb�(��Y"H8��7��ʼVz�E��'۟!� *y���n� �>V�dvW�`E���N�����r0�EmkM�|m���s��F��n��f�A�K���z�A=��<����8y�=k�+�G+���|�K4����Cct�1�W��9��n�q���kv�<�@�SI+���GZ�F3����sΤ���/w�j7����)
̄�+��E��x�G�\|/�,SM2[���4D��z��b��EBvq��]&�n�����g�{ў�Vn�q=��A��,�#�UX�*���=1�骔��Ԝer��z��s�js{r�呀�� �
���7:���V�oj�6�%ݳ��~ k�(�##?v�?u���7��e!��}Ԝ�$�T��=^�y7�K�ŲU��'#溜����^y��I�e*%�?g��s,ߝ{i�E�#FҜ4�{�s�jH�Z0�;�2� �:,��rC�vU���U�ʣ����d��C��V��C�c��Mt{� ��ꑓ�Huo/x!T��俵�ml>][x~�'�/��#��#=�J@���
�}�⾌�E����k�4��C+I�,�d;|���
�nJv�SN�{�-,?�4����T�&EW��RS"o�#�t��O��¯��N���id4�K�sh�Im�T���d� W�6z3�S*��:%��*��O�[��$��Fd'�W�+� ��k�9���Ϸ�V�ý\i'�����j� ���� ���4 �u"�K�S��O�� ��rٝȁ�.xy������|c�� �ݿ��(�b�Ei~5�y?���U)�9�yN���_`����tЈ��#E>Iv�DM�
L�����ly�W�gO*&�[�I���j���%���Ag�^y�k�5�m�\4@���5.L�#��F�s �\:�v5�ڿ��Cw(
'= ��0rG=Ir�N�U�_��=wR�x�M[RٶϚ8���`c��N�כ��
g��w��k��q�}��iy���Q�7A=�&dR7��iQ��Չ�T��լ#ԥ��da���Fq�T�{�W*�M
0�os�/���j���ܱҠ��*3̂5
���1¸m����Aoy�+M�%�����-���,�$����g�vP<�+�]WGN%�V��9+����Wg>�sU� zW��$F�Qn�8�Aa|��Θ��bz��sP�f��"��Ug<�E�c�ϥ�s�s�4�\�����/��Lk��4��K!�pk�Ӊ�?>�!�������5�)���R���d�Ƴ�A����o�k���rIsNǢ~�w�ZM�xGKE��M��c�
�R=BG��x�D�n� ��k�T;�(��@\u���ѕҽ}� ͜��og#�~/����MW^��27?�n�q��2x$�u{$R��9ҵM
���a����Lky�d;I�d.H��e� |�F!%.iK���g����e��mz�rO�>)��$��|K�ji�Z\Oo4r���]-����l\�GF���ֻ{�]��ye����h
_��y���Y�8��j��d}�C�MkW��dpY��+ޓ�OJ|��m�kY�J\�|�
��)>��G8r�kj����\��M
��EW:!�J���k±���i�m$���zWIb�@qM��Y�5�h7�7��5�_����B�?婶�.O`9��]�.T\Q�{TM��.�����u��;���J�� ǵy��5��CL���h���)vv32�*��� 9��5=�mǟ����ٟh��p��|��3��1�s�}�"mRk[#�[jw�,��w�ίl�l�]�9����n �k�Ns��� ��{8XB)���G�h+�� �A�� f�C3�[�&��g�+<q�T��% �����U�K�j��/� i:n���o�^�&-�V;ъ� %Hv(�3����b�]��3G-?u��s������C
��jv3}����s��8,3߭Y�k{�u���)��$nO�+IBP��sh�@q�@�T�Î�4�����PK:�ӵ�t��;0�V�$f�pg���^+=H�}�O�
V�8����3��RB1|J���>�v��
�|����=ڨ8��Cz�O#�+��ï��/��O��>��cP�"f�^��4^^7�n��8,H��,A� n�zR���x/n�b�j��d�px���=�� �1XUF��{�ֈƄ�G(�m?�m)���Ci��Y����#���\�s�a�|!m��,:�_۲�"B.�M��Rl8Ċ�~ �9�U��+�=8�2i�25[�GZ�6���I$�җX�ԑ2�4��H���EDC���M���N֯�Mi���/�Io�%���E)�wh�y���p��>���xy�*�k�������C��Z�їY ?��{ :�� �D�HӤ���mb4���%�� ʇ�� �ϩ�|ƒ��tmE�<ȳ��xf�S@=:�N@<�C��d�W�5Y�K
��lk+��f�+V`�� 6hYڠ�*9��=t]�Tr]�דc�T�|t��̙�a�i<�y��H��
��P��氾x�վ1�mܺ&�u}y ?u�D�1'� z�T��k~h�_�֣�I{u%��B* ��Q� >��6E�\�s�4wWkmci:y���;�Wv1�#;X���Z�V�.eѿ�����s��U���wV�m�\f&ާ����u��O^��|ug�]\Cki�紨Hu���
� �Ԓ ���:.0gSRUT�vS�Z�.<Mms$W-�ŭ^^G�y�G*ƑI8!P�d��|סi�"�Cr����L�y��d p3�s��yC���l���'��.JPv�V���9ϊv�Qx@4\��1K�%��|�fbS8�>�t��.���-ΙxB���+d� �,��b.�5�1Ƭ����JQp���*�#�i�t�_;���2^� y���*�R� ��s��;|i6 \�8J �4E�M���\5=4/�OJ�α�" ?�0B��k~T�MXeMu<*#SM�/�
�h��1�����g��.�2�@c��� m��,~+jr��O�ʎ��88bGRI�k֣I�$������r^�ǀ�g$�F��H�$�K?���Z�����n�������ݲ��j�%H&��LRZ�v���Q�H5K{�������z }�\��5�������7)˷����x�\����G\��Y$����;ք��5�t=��c�� �6��ǪZ�I�3$y�N�`�`$�;w5��"�S�W�M�ѝCJ����$�D�)�<��aX�p�W3_���z�sa�'ЋKkmJ��y��
,�̸up��rϩ#��Ms�יV�h�*.Y��죞��&���k���a#�!� t�q)1�)�lA�)X�"��:�(�l�܇��=*�~�c��N�#�b�**O��w�6�v�,Vְ��M1F��G`��9$�� w�,��/�:��uK�tI��O�� ,0&$gv�N[�p6�k��S��v��n��I�Z7�B�$x���R1��J�����J�+7���cʣ;ד}O'�/��3�f_��`��Vq�Ip'�S���UwG|����~�w�zU�
2�H
Ѝ�D��'��@p*`�%��A��hW�C�[]��In|����d'� ��t�T��ʲq�X�� ?�E|J�CjT�+��4�kP���ym�iP����>Q_K�?�>��� ��m.�cl$3��X����¦rv��8�ZrpUa�GF��T[�� 3��t�+Iӎ��\���R�(�y �Xm9�:�Z&�1�<r0»�i��t}sG����k��>�0�ø���1��NQ�Mh���0�I9Z�E�3�M�5���.H==+��fj��
�qMo ��ҳu�j���ȪIN^*�^Y�1���f?gcn��`is��gi�z)ө��8�$�j_=�\�����v�%�c�W(�P��l��y?�/q}q�[m:�������/Y-�T� ��5'�+�MK�c^v���t�[��:�i^�Fl0e��Ӑ9��j���i�u��������f��#�Yݻ�Q_X�rSrG-�.fr�v�oB0�!s��x7����ٴ��:3�y$�Ҽ�Y�J�^���,[�3�����$a��E�ᔮ�9�'ֵ�K���d�d�!F�h �q�� �W�vB�e%1`"=6;K�K�m��tL:�I~\�a�!��+�����
G�x��?Ƽ\F%�*.W�wm|�����������O���6�q
E}iIݲ ����j�6�4�Kr�w��q�=�Nk�ɱ��MB[� ��*��Tr����Ğ�^�+��̒"�;��ö,��6�
y ���>�|-��,� H�fwzd�V-�N�ê���w\�9��ՠ�R�%�� 旽5Q}�י��u}O��m��
�,��GW �dd���4��|A�S���A�K�ș�LQ�qBO���Ԛ��r�'��I#�%�R��*�͚�8�@c�{0a��i:z���5����no�c��4S�]��"���*a�8�~ю��L�7JhE)����ߴ�����{mPJ"v��m��@�?�Uߗ鈇��X����S�������y|��������p���nn帐�9�+��b]�P[�N�d�+��y� ���G�����9�@ xċ�3��������Uz�u��9��fn^ �'7z��`9f �8�J�< ��5GV�E|�'��j�W*+_� �O�����O�[�^�D0e�֦�#�6�����L���Ӛ��;�K�����b�{���i&��F���xgS��C���#?C�V��?�Z~����V�E�z�����a�U�r��Ս�����U��s8r��-/U��c�M<�_�� ���6���� �<�Mm<r��d��DW�nS�#�����xs���|Mh���^)Op���#c%]R���~���ཛ���9��_��E�����;IDCN�����`U� f�U_��F��I�9�(�8 b1�S%������_]��c��zd�Ɵy�dj��1D�#8��pn� ښ�� �MO>�Q�VWL(��[7���HCEt�*��=1�8H3�p̑�^
S�b:HG9�[�F�R���|�F�z(���_7x�����ϫ3\Mp:/H��v��k���8�.�����9${=*f�cS$��!XR�xzu��to��
�]�&�e��Gw�Eӳ� *�23���$�d
g�U�-7����4#��v]?��-��j��4]:�.nd�m`�V8U���p����v������T&e,B.3��P:Tq3T��٣��Ļ���:�?�{�(��$Axb��9�?RL��K�@�Æ�F�y� #9�nNs�:�O��eJ/��5{��_��g����mZ��۽7���j�pܘ�8%�JѬ�K1������8�s��7z%�76�ړ�13)��Y
��[py�Qz
g��q4%J1�5��ӿt����8��NN�֧��{�ϙ��Kk-��o��d?/͆A�F��QXw���xy�/�1��v�&�Ţo�����v�����bN5kN��ɥ�?��_���]����S��O��5�XJ�������0��$WR�A�䞼|
����ڬl<�i�����$ƿR���}Q��ݯѝ��<[�M�iwK��������n��3��h����[۪EH8ӅE �U89���U�S��Ms�Z������I#��l��ed�5HI��DR��laq�4U!jz�^[ˏΫɨ�� X+�=;�Ǩ��p��X���:GjYݎ�Ԛ��>z��n�g�%��
�D��8�{�~��_�:l�:iW�h�6o6��.�!O�G�Yc�rӏ��3�MY�G����h_�lo
���<�Y�0N{{t�*��i��-��fhM�� �L���;K���AS��� �<�UWS���>q��>S�rOО�ƽ�t�.��wr��ۣB2>�����{gɮ�'�įFvj(���!����}��{g��|Ј�/1eC�;>\|��<�����\L?�c:��mw{j�eg��i�x��0Z=켺��tڬZu�Ed���X�X��8R@�i�����=�|%,�4�6Aos�
4��x�FA�
x �Ӷ+��s�J�h���ˣ/�ׄ�*7�-_�~�x��T�v���=��7jrN����߁�7�o�K�4�� u����$�� <W��YV�Fv��^[��*�~�I5���R@�g��Տ����
�^�X��_)�Ð���~���ϒ��۱�^�����╂G�Z!��r��]�����ܳg;F)>�[��Xa*��a���Ky/��Y�1I�'9��U��1����U����MVdz�QK�2������7�X7:����ԏƲ�;�S���z⒫���b���j[-+�~?� E�M��� HA�=@���T�q���C�
M֒GQs��i0�q\�EI���Hwo�^ާ��R��z��q�O$q�?��ڈ=��<����i�;1u�s��x�`�y��y��m@�x6}��ޣ#�v�����S TM�]Y+Y1ʸ/>�?��^���n,�x�A�2UT}
����Uy2�Uկ��7ɡ|Co�:�YUK;t�@�o�B�!_�w�:|�e�͠��};;ρ�wR�L�F�,��WV�7�JI��g���>�֬j���<w ��K�>[
��9�Y.�᳑�q���xש8K�/���[�~�KKo���V�5� �'���� ݉,��¤g�v�=�߉��i�j67�e�[X '�g�6�����9z�H���#\bT���H�MڞK��j���ɨY}���9&�*�
��H-�VQ��k�+5�����!���zx�E�����T�14�QA��
��߾BNyl�4r����Vt)8B̺�I�"9�1��.��kF�c{>��ޑn�zӰ\�+��4T8��}�s��Ia��G�|��ƶ�֍��$�1�s��C�����q�wuU(�38SU%���x�Q�o��W*<��\H�e'�aG�rx��O|r��n��0���M��P`�����w��<`7�6�uR}w�=?k4��|ϟn�����o/.e�����#�,�Ԛ�=E�85�r$���6�5 ^N����s�V���`a�W�U�.d�۱�~ Ң���M.S$��n�䑷7a��8^��772h���� F��ȿ*�� � 8���m�x�OM쪤a.[��(��. �$�A�Ζ��) �N#�������(�+A�E�j�[x�L�2��7Q�ax���W'�'