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/SF320/244382.jpg',
'FileSize' => '542 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244382',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_name' => '244382.jpg',
'id' => '244382',
'sku' => '244382',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244382.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244382.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244382.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244382.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Offaly manager John McIntyre congratulates Limerick manager Richie Bennis after the game. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'DateCreated' => 'Sun, 15 Apr 2007 00:00:00 +0000',
'ShortDate' => '15 Apr 2007',
'LongDate' => 'Sunday 15th Apr 2007',
'db_DateCreated' => '200704150000',
'event_images_count' => (int) 20,
'event_images_count_text' => '20 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0704111/',
'w' => '2250',
'h' => '1775',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'True',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2250,
'height' => (int) 1775,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '15 April 2007; Offaly manager John McIntyre congratulates Limerick manager Richie Bennis after the game. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/244382/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244382/'>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%2F244382&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244382&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244382/" 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%2F244382&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/244382&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F244382&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244382&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244382/" 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/SF320/244382' 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) 4
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) 1758143620.6093
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/SF320/244382.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) 1758143620.5979,
'_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/244382',
'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 ��5:Exif MM * J R( �i Z x
�� '
�� ' � ʠ � � �( � 4\ H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �9W�ԋ掫^�qfj䠾>�(f�Q�C��\z�Nk9E��8s��f6 �td��RFx��;/͊e4�&y���l���5=@��)A�)�X��h���x��p��#�1�U�KP�R�h�N�ü�)��c��#R���64����Z���j;˛K+g�����i%p�>��zj4y�����f�֖�j��CMn�#϶��|c�5�ொ~�<��A<�7s$7@.��2{A5���v-BGx���*P�t���
(aR1*�V��Y��#B�z��
�PJ�v�ǟl��<� Z�[�*&��� �<��ʓ��%�:+�ͫ��'� f��oo$�O�Զ-ϰ����V�r�سcp�6�/��B��v�Pq�lԌ�k���4�L��8��(LV ��|�
�s��֞����?Zs�2D��~��۷��r�iG�y��_�Ŧh+��*�3� �A���
ʻ~�غV�G�l�1pp�rNx��g��+CU�5��a*�|��ӧ^�ג�8�)�is��'�<C�x��$k^i������X�
3��.{��ס �*�a5(��2Qi�r���X�ZAq�*��d����^�����r��u�B�o$�����NT��I�E�mB���������F���)m��bNG@l��U���[�x������g#�J�&�/��X����%��
��K�,*�Wi�����¸�x�ͥ_�y�"t���Pee`B���8�G�%I8�eOEI7'oE�gm�R-Oöw���� R\]�)� �J���$q���r~���Wjz+kY��GPJZb�P�(��-"��&�.fLd�����nw-D]փk��͚vUW%��g�`b��Ւ']�U8$y~"�'����e�fk�#[؍�+�8� x�1��c^v��6�*�>�7�φ�E�f�c�M6Ui-�ʝ�2�|��~�D��>���Q.�$�>��b�
��Z��4m%��~C~���y 5�Lq�� �>bz�r~�Wu���Q����V_����B�������U#(|�
�'�8�֒��̒����W�V(ܪE��7̎A (��1����y��_[�cƞՑg��G������b;`v�I�8;;6tP��UM��s�=�$zʘ�zz����x_F5�|��u����4W�\Oq3OvP�� =}k�Tj�]��=hc�=�ӳz_C��.�a�X|����1��� =kʾ!h����ZD����Tt���X)'+h�+���C��Z�f��2C'���Cد �+�kˋ)mM�����';�ӎ��֮�*Qj>G�ȮM���=3\��$1�:$D�\�1��rI�;o8�^ϥ� >�o,�c��Vxˌ�#$Wn�:i�U���^k:}��p�8�T��c{v��>|)�z�sW�3�g9�x�����h���p8%I��zu��%�I�F�������[��f�R9P�G �r}O+��?�[P��ƣ��M��#mP��n v�~��:�m���OL]hŦ�2����TIeT��zu�^!��Z����4V��~�n;���<�1�Z�j7��ks?��8�-���Q dB1��?�o�K��_�m�Ʃcw����2��� ����\�HPx �34'9���iʴgc��|1���^ZI�9��u �=�J�}gU��`�!p��A?7c��^U:vz���Z�Q=���W1x2��P�
��>�<�rwI����ߖQ
�H�=KW�Sj0K��5[��fe����Vz�� 1�!�P��$8p~��`��]��^I\�p��\@��`{篨�5�J�B�s����[��
[��K����գ�/_��a�����ogtR�u�0#8� ����\�\�7�I��lt�K4�~����i0�U3���9'���s�.��1Gk,�]����V�%�n���WW�;N8�j�:M�L*��r��^�i�O�y���L�b��FN+P�]BI#YaM:�/2�b�(����#?��U������"[���J�NWtT���XS�$�9�r�����XZ8�U�,�+`�9�kZ�;5��9�ٍ} �@���ܮ�݆=�]���&���=�ØȑN �G$�c�~�W/$3N�,�0��g�, 6�@Lg�8��Is�ߋy��Q��YC�.J�9���j��I+=�,��5��*�N�����}{�Q�tfr�w2�3� ���u篦�<�dw?&�sx�{�YK����@Gdą��3�ڠ�v�J�� �E;s�%�����Z��K�N�%� $���@�q�\�#^�L�fh%� GS� ~5O����b�Q=+� ��>��U�r���E��F�}�}ċєm`�xf\�+�szS�x���凉�H���˟1���� VA�5�e�׳���?�����y���gP�Y�;z�i�o$�&����>��3��؇F��Ú���_D���Wa�nb o
A�y�����t����\�u�[�v4�-w�]�Z�&����k�e@�d����X��c�9�u�^�)幙�$ oK�n�rHҰ����gdM�_j�f�b���;I_�N� N0�1��N{R�2�o���y�q��z
��25��q��2M��,� '�$���WI�+��Z�R7����`��k+ۻ�0g_�.N:���ZI�՛QvW;����E��>5�+Hڂp/&2�F-�d��'8�z�K?��}OY� � �S ��"ˍ��STtPL
�7#|<b���Y�<Mg$-�pӐ�c��չ��MS��I&I&� w>����=^n}#����4��e�j��·t�V� iEp���r��۞�7�ek&�?�f[�/�:K�*�%�����0� {�\{N�+z�xJK�O3����F�"�?32
����ֻ+KW�4��]����H�
2����enX�I�ͳV9`�5��y"�͐���v� �=kS��m���������9HJ�]A ᗡ$�� V�jp����3|])R��K�K��
OS��� �N���r2���q��+�Ee��T�+gN]��22��Q��C�hֶ�}�ne.�2�جU�>�<�>�ss{.��K�_�$6<�|�� ## t����S�v�����NI��.�e9і܉ˆ�pQ�6� 끌Һxo��K�w�7WI7�3��=��8������� S�+�}_�Fhv��R[.�ʋI�9-!O�B#�d��oo�E�7ex�ʌB9�}>
k���/��'<�O�ݟ\x��F�tRn���Iql"e(�����2:��>%E6��|���3y ���TKm���<W��-�W���O(ӿ�$�÷��ZM����ح"�V6_1�
v�9��j?%����jqHYa�&F1t�-��Z�֔!N�vu��ح����'��C~J�g. ����?�(Ӵս��*�FUd۷>�0N�tc!(�S]�5*6�S[�Ȼu�}J}y��kep[����1 ���ԍ��c���m�u�cu���|�h��0���YBmVP��� �Ȓ��;���>�����{T�m�PE*�A�`p���rx���w���ݤ���.����,eI�bC�)���{'a8#��*� BKW��y����D�)�]R���lf-,Q���C9({�G=�p;��8.4�;�+KRL���sw�ͰPS�����|���Q��M��k��z�.+��=D�4��Y�6qY[�oe�r�ݙ�����{�T<O�x�ݠ��.7�qRc|�z��O���F|�Z�Dg%.d�>}m���ֶ����kn�h� �La�X�606�䃎U<?so{uun�E;���E@��Ğ[( ��28ϳA�mJK�ϣ�T���s6�m��m��yn-�M���r ;Y=�,2h��jR�kZ�����A �v��#)s�YGL��EF7����Z���[�='�������]^�]�ͽgQ�+����@^��Vj2����BP�JL�7�K�}:��ȵ��H�UۇRGA��Ӵ�X��Co�.��P�I��2?ƌLV".^߁�N����sN��3UUa��g��g=zu>������
`�,K���1�ɷ�tOqڹh�*��l�O3F�g�!�N�W�d����XI{32����9�ۜ`��|�oj�&��XG���[��P��$n9��e?�,W�O
u���i[�6��ii��������<5�@T�X��#�11�kOPf������~�@��A�NGN�c�p��}�/�M[�#���O�<1wsw�\Y�cv!�%�yQum���;q���'�;�bԭ�My.���H��ءs#��[#� ~��^-ZJ�9kf���_U��<E���X���t���x�O�(n
eXq�7<��L �t�B��(@����<� :�]�4yV����J���:��-�x7J��ZD�2�k%�،�������n%K{u���#͇�L�>\e��ϸ�|M:���{F߅�����S�'cc=���������:��� \.�w`wu5�ͩF'��X�0Y0G�k���Vj3
K�ϟ�YVj&D?�&�-�Z��Jf{i/�kf��ż��W$�����+k�Z徉 �TF�G��
�.@��g�ʖ��գI��oe�[~f|Ӓ�_б�_��p�֑�U@��sЂ��+��n�� 焵�˳6q���Ҝ,k��Q��:�lC�����d�q��˳>mm�V�-�]�y����,_�3r��A �\�����R�iq&�e�^��"�����H���u��Ք�[���&�.e�����R�v��P��bB�1Rb@�Wr���y_�oW�5CU���w�*ʾBrpl 9�ứ���S�)�t��z����?��|wq-�����G�H�GgPK��yW�4����̓3�;X�Ғ�eyb?<�s"$�`dv�j�$6��errC[ӕA�_Z����Q�af�h-��ZN��_�r{��q����W��0��yI
"b�^�?1=�j-9�^��3���<�u��ǭ��G��7��s�Y˱T�de�<� �⽫�#�� �.��mn.5�H_lFf�x��@6r'���\^.��
n��K���M�:/)�����$���wז���
�Ȏ9�Ye^=K(ϱ��B��T6��E���G��n)֧U�Ti� 5��J_��pRS�o�C�5�����G���G8��1�� Y�$�b0Gz�m|�ً�$��]NA�G�F�㍻\1Hv��*��f��]��:
'S�S�K�����pQ��hv� �3�rI��_�v�F�BTW�R��C����H苺�%��'�4��+� �w($���;d�g �Y��/��HK7��H-�8d"�����P{��ž��$�f�e�� 9ܤp3���%-�ur������W�V���]��iԔ��=!ueS����}l�;��C}n�W˔���\nP����1ֱ�j�ysSJ�T��uO���h�V4�y/�E'Xt����c6�
�8�省�=s^U�Dx��A��:)pn�M�?���O�ɐ� �A���u+ǝ��wz.����\I8h�v��g|9����zM��WS��ER3�BʿVUd�+s��iZ5͵�+��ddT�&+�n�1�Z��u���d�4��|EH�5h�Ȼ-\�^c��gkm��\�^���:%���u8�Ϲ���� 1��d�>��Tj5��ԍޥ�sJ�m"� ��aQ's�)ఓ�^>���7(+������[�Di=�
N�!�t�}�'�Ld�H���p���W;nM&�s���K %2/<