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/SF283/224798.jpg',
'FileSize' => '620 KB',
'is_book' => false,
'keywords' => 'Soccer',
'real_path' => '/media/images/IMAGES DONE/Library/SF283/',
'path' => 'Library/SF283/224798',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF283/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF283/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF283/',
'file_name' => '224798.jpg',
'id' => '224798',
'sku' => '224798',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF283/224798.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF283/224798.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF283/224798.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF283/224798.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0610031',
'headline' => 'St. Patrick's Athletic v Drogheda United - eircom League Premier Division',
'headlineTruncated' => 'St. Patrick's Athletic v Drogheda United - eircom League Premier Division',
'caption' => '6 October 2006; St. Pat's John Frost in action against Shane Robinson, Drogheda, eircom League Premier Division, St. Patrick's Athletic v Drogheda United, Richmond Park, Dublin. Picture credit: Ray Lohan / SPORTSFILE',
'DateCreated' => 'Fri, 06 Oct 2006 00:00:00 +0000',
'ShortDate' => '06 Oct 2006',
'LongDate' => 'Friday 6th Oct 2006',
'db_DateCreated' => '200610060000',
'event_images_count' => (int) 8,
'event_images_count_text' => '8 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0610031/',
'w' => '2471',
'h' => '1798',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2471,
'height' => (int) 1798,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '6 October 2006; St. Pat's John Frost in action against Shane Robinson, Drogheda, eircom League Premier Division, St. Patrick's Athletic v Drogheda United, Richmond Park, Dublin. Picture credit: Ray Lohan / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/224798/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/224798/'>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%2F224798&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=St.+Patrick%27s+Athletic+v+Drogheda+United+-+eircom+League+Premier+Division" 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/224798&t=St.+Patrick%27s+Athletic+v+Drogheda+United+-+eircom+League+Premier+Division"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/224798/" 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%2F224798&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=St.+Patrick%27s+Athletic+v+Drogheda+United+-+eircom+League+Premier+Division',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/224798&t=St.+Patrick%27s+Athletic+v+Drogheda+United+-+eircom+League+Premier+Division',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F224798&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=St.+Patrick%27s+Athletic+v+Drogheda+United+-+eircom+League+Premier+Division" 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/224798&t=St.+Patrick%27s+Athletic+v+Drogheda+United+-+eircom+League+Premier+Division"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/224798/" 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/SF283/224798' 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) 6
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) 1758094904.6177
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/SF283/224798.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) 1758094904.2998,
'_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/224798',
'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 ,, ��%�Exif MM * J R( �i Z � -� ' -� ' � � �� � �( � $� H H ��� JFIF ,, �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ���v�]��F�f�~\`~^��ҋ�r�-�d����F��Ef�fmܹ�A=O�6�I�@���b�\�GN�]>|㩩g�$�(��J�oaT���I*FL
���Ζ$,;�Z�p\\ ��5���>�܆.�Ã�AD�B�� �z9H�r��q��*��0�ۭ)\\ɕe�� �+6�?j|��hB'��'�NI�:셕 �3�sT1��L`��E>l���y�J��l�#�����6M����t��r �"v3���pIqInJܱ=~��˖� ͍��R��R�g��6�ey�e�l�|���s�}i��RcA����,ҳ� \ԭ�OAb�i��[�9Sr���v1p��業J�O���N��4�Gt<s��)-J�c�*NA��
6�d[O�W(�{;I3`�QA)�P�q�4XV$�^�0<q�kNa/$����5+fB1۵1�}����P�@Ƞ���F=��Sml�z������<^bd :�EG;A�GO�\��P�LB����N���:�-����z�\;3�rA<zS��*®�G'8?��D�X�L�JNĻ��zs[�!{q�RXF�۷���Ƒ���fd�<�%�1�F~�J����39�x�����=M9�8��?s���^j���*�ۥJ��"�p��8��M)�1X��w�N�wP�%(jh m�3O9��ֵ��8���JBhMI�����RX����z� :QBl�);����99�lU� ?��N���D�����c�IfH��nzִ{m?6��8�¸g`y��LM��ݨ�ǽzv�ʶ*A�x�P�cx�R�)��@�y�� �;T��4·Iԣ}<�0�5���7Cdv洂�!�22
w�Y�����*��+�e�C���79n��٤�i�Y���9���m� TLg=��g?�R�[-�F�A�*p�n8�sT�'�,0O��>
�=��¹�2퐎�=*[P �'�^�,���l�ynݨ���s;LӮ/��dz�n7�n-����� Z�S���Ċ&�q��?�%��̪A���.Q�9i�f���9�+�ҵ_*Ȇa���2j�5�]���<`���R8���N�ޭf7������OY�����M"E��To�U���3��ߠ��f�1.ٱU�'4%b�z{��,��p;��n�M���I��.�̯�t�L���zSJ� ���@����ą�u�5].J5-t֖ �Ҫ\��K�jT��F]�l�rj�Q,�ep1�`��\w�"[���#���Ir�:������'�a�t�⸪|F��.��<�
v�/�֡G�s��EO��tາ� ��
i�����&�9֧9f��YӁ�H�]_�~|B�-����^�������ݞ�s['�(�S�#�3χP�εk$�Q-����-��=�r̻�U��r8�IIh7NP��K�������n�%lGK��ֻ�_�G�� o\_��3�~���$p�?���)~�*+s��z�Z��.s���K�+�����>?�*b\�V_��5>����j�u>�ct��*gk)뵕���=&��jJ3�'khg���� }*0�H�c�rk��u�I�9Ϸ�� 8�\i�nw��ڢ��:
��<�[��� �=qV�`5�<�ǡ�6��}@�O�s�F��a�Z}ݱ
,g�;L�=�nާ5��-Ѡ�B7砢�fvf�é�(^�zע�x#
N���Ss}J�^J�0y�v�����X(���Ϛ)ߌ id@�OSY����J����^Fe�4�pm<s[�3���_ �6U�O�4�-nm1%��s�����m�ʤ}ᓌ���y��)�A�݃���GS���3|K��;A��k:��`�Dg|e��b���3��o��'�[�I���X�g��4Id�� �' ���c�I*������^x�s+�������n�~�cje|ʶV0�Go3�U�GQ��3��\��[+�R����O�H�՜��i��t�x�2|�M�R\�qH�gB��K�֒�F6�����E�?��+�F,u$���yTʫ�����#^���MwG#M;3�'*y��N=�>�"�<���rf�O��9��3���sY=�g[F&�U�9��?�"��-+�_���݉g1 d��'�+��j���O�C�-k�6�vr�W�Oi�{�$`���RbLH̄�ОG�[��$_�᷺� f���4jK�W=E��Do�,��R���4�I�j$�,��м�����f<