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/244399.jpg',
'FileSize' => '524 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244399',
'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' => '244399.jpg',
'id' => '244399',
'sku' => '244399',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244399.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244399.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244399.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244399.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; The scoreboard operator watches the final minutes of 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' => '2684',
'h' => '1485',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2684,
'height' => (int) 1485,
'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; The scoreboard operator watches the final minutes of 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/244399/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244399/'>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%2F244399&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/244399&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244399/" 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%2F244399&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/244399&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%2F244399&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/244399&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244399/" 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/244399' 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) 2
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) 1758131546.7801
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/244399.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) 1758131546.7718,
'_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/244399',
'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 ��%Exif MM * J R( �i Z x
�� '
�� ' �
|� � � �( � $5 H H ��� JFIF H H �� C !"$"$�� C�� p �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ο�/bwV�;�m#�<�Ƴf����l7?*<����^1vB����vX��d<����G��H H�����+܍TL6��ǧ�H�Z��$1q�"���+��Y�!VC a�MC%�҄wj��v�nH8=ϥM��wD?a��;f��.#$�#��g��(`�V��(z_CN��Q�N��o#���Q���[���ש���Cwq�ȥi�2-���ڢf�A`d�ިƛ#M���'b'$��=h���Q�I��I�J?
��As���v���W)�a?� ����}}*X�ˏ+�K�������ǥ��\�FB�#i7<pry���ir���:-*�~�����1��6�|�q����ʚ�bx�)�ek� '�QO�%��0���v����=i�ˋc~�̗�����=��f;�Σ((�$d;���q�E�[Zn{�w do�,{��@�d�8'�9�&ݝ�n��o�8k��@M@���'��ִ��u�d��� �I� �S��������<6�ף�9�8��<,���rs��M+H>��l��c��a��#��nβ�z�7 q�G,�)�O�O>d����Q7��2]X����������^�?i��5�j�sۤ���>e�G��Zh)�RD�g^ f� ��[�[�I�^H�JON�BM��� ���#K�'>��֟�t4�tˀ3����O��0����G�RI�o{� {�XX�?hm�i��SJ�8��#�.bR�O� -�i���g�N V��IΚ˹b��?�I����R(��#���~h�;^!�t�UB� .Ip��T�MU�B5~Jp����M;��д��+]v�y��ζ7 yy��O<k���}
�Ś6�곮�ψ+��!`�!=s[��X��|--|=y�P���9^�+4`12��9�wP���A�� #ry��K)���!�R�8�
���_��߆-�۫�W������#Z[w9 "��d�`�@
ؓY�[�cH�4�Kۄ�����O!Z8W�*�!~\��k��'"�v�t5�N���J$N� E'�P}�XNN����m��sw⇞E���Z�U��b�'���?�'��;ke�m��)q�� R��U'�e�Q`����|9�k�"���� �A7nEn�=7b�+5�Bڦ��t� �����е᧘�}�/?�tѡ�� �:�5�u�.�\s;��%��l)�27�z�~h�G��@�����`��
s�|��<u�[����F��T~=�Gö�چ�ka�j�N���u�F �=I}�ލFh|O��D�棥i�`������wD�y<�I����m/�_\��.|Asqw�x-��`�5g$�:�s� �i[A_C��أ�Ů��pحҬP�)Y#9�)�0��y�3�w�E�+jK���S.�D�ȫ B��� s:��";�㜰��?�L֤1��L�y�n'���
l�����P�猭l`�{�-bX�Q�a�) ��Q���k����tW�]�`���V5ҎwԧSR�Я<D�/a��2 � � `|�������T��|�[T�d��k���Y(���[�K�8��ƣ��C�7M��ءU;K�<�BG�AL�t�F�
DY��σg���,��!��Z�i:��8�<Q�6����n�\Z2��q�sH�����j��l��L?�Z��;I��s��HdX��N�ة¬a�=� ���{���>-�&����R.��?�� J�!H�4
�pL`ⲨR��Ј�j/�� ��G*9��ꏝ^q���4���]�i6�(Ü��y���A'⦜3�� 覫d���5��9L�Ͷ�AT$�O~2zU��@�q�����ο��⾫�{s� ��_ 7��/�ic�)�=N�W���0���R����#��O\R[���vH�[�b��hญA�x�+���xuE
��Q!��� C�A?x|���L��!*2���N3�p8� @u�\�D-�ƹ<3��fG�5�g×�_h�,3M#���)#��9��k���/�ݬwd�m�%�3���#���n�eeq&�7���}e��i4�h!�E��.�@� g��\���j�kg��N�
7�[x�����_��'Ԛ5b����c� c� �V-u=R����Ŏ��G�����66����E&�Co2�59E��y���qO��g��tQ�A�K� lC��0*Wԃ����s�5#__>��k�R��n]-�o-X�$.p'�sVd�v�-ݍ��Iq`�mdh�1���<�a�S��n5��n�������0]�$�8�k���\uG��]�p-�J㵇Z�Mo��<Ɩf��`$���۹T_�b���y��mB�"k��.�r3�R���\��K��k��$��a�����r
�8S����::�������7厞�.V*0ob���������ᱺI�w<`d�OLS��f�N�k�:���fY���b= \f�4K�>�?�uhKF�X��wrI�rk�$p
�q㟗� �S �x[�q�y�tT�w2!�ʹrm��{V���M�]�#�l��MTBGo<B�D�1v';�<v��������m���['<��~���gb��L�M��F�0`����ӊ��}�� �vG���㿥i
啄��R2 $��{�9D,��2�����@T\�\~��P�UL������^=i=�c4R�[� �&�$~?v���Ŗ��@�"�*+��d`Ma1Vh�2�[����Q�k��aո���*ȿ9���Si�Eq}o
č2ʉ$�wlR@-��8��4�=:�>�(�����w+\ȡ��%X�^ا� �1j�|V�x�N�vl2��q�#���Cz�F*��<]��O�v��Iy#�8##���)9[���V�F5kC_F�l^6ǚ���� Z�ND +��(}=i���V� 9��$��a�n�������ps�r� _�Լ�ͨ9\�����@�:V��~�5���d����s�2�;���ܻ�L1k�!ӗR�u�R=�s+3Ƙ#w���ks���Ek2\��� i���GR<Ɖ�A��#I qP'�h&֭�-�@�{9�K���x]���_�#QfO1Zo�Q��K]mN�t� �5NՀ �y�=���$pCm���e��QmE���N� �_����|ķ?��4��x�K�2����H�E�-����y�=85� t����I�..���˻��
}���`e��z�`�9;�ƞ_����~±d��!�g9�x�x��L���4X��2}�%�,é$u�5��������܃�4�� tˋ�>7��J�iT3(
��t���W�lʄ��pw�Z���q��J��|�#}͆�_ʻ�xJ�P� �u�����g�G[ ��3�`�*�E�dkV���wzrj��C�Gs�W�p���� :�@�/��f�H�I���~��Fv�9$��S�RQ3z���o?��N41���-�dU.����dsV<1�
>�D���tiz|7bGP�%�OC�1K�\�ԥ��s�o�'����[:�H3�V]�pI��v��S��MY�0�1���R�`j��,v�� O�.*�͡2~�@6<�����d�A�
��%�%�N}#1'����;��o�f���(�hYЁ k�c�=~@�[��HN�|3!� �SkwG��˃�V?�$0�/�rH#�z�g�K��SsÍZA����i�v2}���^b�z�9�Ur��U[�^}k]*) �,�=�g!B�>���ց-�P��%��
E|8f���|]�� Ȫ^ ���ԗڞ�j��
�t�R?&6�
�;w`��a�r(B��}N�S��\Xh��D:�Ëh1�1�B�
�'>���=��q��ԕG�JE-�d�k�Q.�}��9gn2�[$�f�a�1bd����ҳ�4b�ZB,c*&iO����\<�kُ��;���4�m��7�D� V$�$�X�潣��!�Ѽ�H4�:���Ok;�r�ne�Xy� ҭ��;9�$|Q����� ,��U�=;�j��]������*�p��`�#�Ǟ�!����s��{����b��&2��S����l�j�K�~ �
5���q��ـ�l�h|�;O�ۜȎ�Tl�oD�6|�� ���Ǡ� �Z��6��CR�[Ia
�5���9���̼��qjZ�X�u��yyW�J�����X�Ke��W_Y���p�9��F��Br\�~(�TI؋M��������-@���3��!��}�Ө��_���w�8�͑f�f�%ǘ��_������ㆬ���d����!�� ���ζ��f�fI 2p�X�ڝZ��JO�d�6{N�s�}�-���������
�<��Ϭ�j������#���[$� �e�Ɓ8���\�H����ψ�4�~�y?5��O/?�yx۞~����j� ���Jc������m&