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/244395.jpg',
'FileSize' => '441 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244395',
'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' => '244395.jpg',
'id' => '244395',
'sku' => '244395',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244395.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244395.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244395.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244395.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Rory Hanniffy, Offaly, in action against Paudie O'Dwyer, Limerick. 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' => '2344',
'h' => '1796',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2344,
'height' => (int) 1796,
'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; Rory Hanniffy, Offaly, in action against Paudie O'Dwyer, Limerick. 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/244395/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244395/'>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%2F244395&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/244395&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244395/" 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%2F244395&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/244395&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%2F244395&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/244395&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244395/" 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/244395' 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) 1758111509.4723
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/244395.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) 1758111509.4617,
'_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/244395',
'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 ��(dExif MM * J R( �i Z x
�� '
�� ' � (� � �( � '� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �!�'ZtV{�)bGZ����#f���[�����Ie1�p8��������b;�9�e/�+�T�Mor_��]�M�>�4�XXVe�5R{����dq��a˥�t�4�f��F�$��ץBj�'#9i4����=�9�0�4�L�l3#�T. �bx�V�%�S@�'�53c�R��3ڬ�q��dB�~�Kq7���H���07�Ms�0��q����]�%��Ko cҡ�pѰ�I�ֈ/��H�h���n��
�4� /��^Un�c����p'���m���J��AY!�A�b�P~CXs>�؊�"��!��<UI[Q\��ce+֥��\c�X��ixرd�2�Iuao$,��p���ו0K�8�M�c�o�S��&-��WU,E݉{���lJ�w!Tz�[�:5�F3���<��H۟��p0z�J�s�تQ��=G�l���sw��yw0� \��������*������x���^D���R"��+�q�:R�qi�M)'c"~�x�W4y
a��A]P~�8�{R�WR���
Ķ�3�Dرd�/�qO��|>�ޔ�CE�շlی�RW��[�y#C#`�8��<g�(>��}+:�Ө�v��e'�*��W�);�H�ك�qO���Y����X5NQ��M>f2��`�H5f�9?�*�\����L�Ҵ�;K�V���R��O�4ko���x���F1��+/ �-���ZC ��ͷ�����^�0�(�hJ��ϼo�7I���G��]>�2�5�_4yg��c��y85��^�n=����U��h�`���kzF��������+� S��mY {�gc$ђ�$eʷ�Uo^��o}o���v=��+����В8�[�%N1SĎ.]��ub��/���H��@�����>�S��Gb[ U5O�W8^MU�B\3��D� rh�,p�-��u�W�{Wy+-�Q�#�����C�aD$Ћzׁ+��R3��W�Qb�\���m��6Im�P@����E.Tw
2AW7�; H���-��e�Cb4+6� q��zΰ��͘/��<�G�`�ᗐG�5��KTK�C����x}-&�inm�@
�� �XH���W�Rd��)ɭ��ו�n�S[F��*��#��=(�j�GN�f�����u&�X� �$���k
.���k��"�3�����s�z�`˽���K43�QDV��'��:��d�)+�5��F=2jo&��v�����g�X�,5���[�%��r� �V�i��,*��]��nm9S����\�b��7NiR5���Ņ�ךrǸT\�D'���g�.`&��q{�4�җ;�h�V�\`�O=�>�ⷌmQH��]>�R5՛��u���
�p{��m�Ԓ]Z�}֕���u��νx��t�j_��Wb8�nf~A��v��(by�:w�1n��ǵy����m,J�A�l��j�}{5�����$�5u��� ?�X��w2��K ,�<���*Վ���T_���vg��"9H�Y}}��r �8�&��:n4��j�ĒO�v$$|�
��{q��z?xV�LV�-� {����ʲ�;A�
A�8*=+ύ% �?����e~Vr�Pɼ��UC�o��gSY��;"Y\<b�P����S���Kp����ڵ�ge��r��tz��
X~u�Tm����aY�Iex�l����5�֡(j[І[�:�l�F@4F7%�G��9l0�v�ί�C�zL
B�θ���=77���<�P��5n��$O�X�6�waq%��K�V�K)��$dr8�J�P�5���Km�iz`�J=�>d������=?�)a!M����*u%e���x�v�W�^r�c���TdS�w�Ǩ�}E4���˴I» ���Ǧ?*�];L��B���?�u��Z��C��<Cph���eq��CK�O�.��_H�����I%�%t89=�9<���:j��J<���S�̶$��3Mu��}�۩x���$�;q�:b�� j�f�+�*kh��cWq��n z��(a�JW�T�M�����B���*v��QM�PӢ�c�k��+��7�l��UDڝx��H�8�ޣ���S�ܹW����I�9~f�J� �}�S�=@ <���D�<��;�Zܕ�Xq��� (�����qT�UOw�C�VS�}���Q�ЩS���88�3P�m��+��4*4{T�4+^[�@� �s��ۥ��tlXp
���2�����`R,3 z�cd�X��ӱ�&�.0Y@�MJjj̑3
��7��-�V�Gfz�K*�(�$gv2{�ұ�=�T�5y��|5д-b�O�>�o�.�e�,� g^�n}Ez���Om��ei`-��<K8�rz��YMxʵjS�,� ������'u/�{�4�C������<�ec����+�����]���һe�<Iǖg]�S���� �R�D1yb�Ȗ �D ��T�����<�����y�t�m�̝���3�S׃��=�Sܧ]J��:��ά<K����.�?�`HR��ɂ�f��� W#�iz�f��ՠ��@�J����t �##瞕��FR�G���'v�;�z��m.�������Q3�g�
�e��n����|V�,^��մ����g���9��9 �H
�FAB 9U��>s0i6y�ۿ���6;�y�8� �J��N�%�
�у�2���j�q��1�9JI9�$��Y��~�
�G����oUp � e�����g:����n�rn����KP����-��d Fq���Ar:��C)(�Sı}��:���;�y�`�ЀdF8�DG${���b^NW=+�t�)���Wx�
s#�Y��B/$v���ҏ*:��r�q�QY�Q*��� S �nbEYF��*�]��hݐ�R�c� Hk+}s�Q�=wAhs��w��=B��\������xwč�����p�����#���R�5���S�~�S����sal�=۾�����S� >�N@�C�0�x��%�+y��L�
��c�<�V�z�M�IY��3*�N��5u�|Su-ޛm~eIB͈2 �pNGl��Ʋ�m�McUiVWw�:�El��O��UP�7��f�A�N���_��1��o5)�РB��_6Pz�P�� ��x�Z���WL������&�8c��>X�'<dҝg�N�6�9O�8��J��cKM��F����J�O�A�3�r+�o�o$�I,����bF9'� �х�َ*����>�=M�N\�)���Q��>����+a��.��2j��p�V� ���v&�&m+�
�5)(=/��u�Rړ�a�"