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 2/',
'drive' => 'D',
'originalpath' => 'D:/Images/Images Done 2/Library/SF35/034332.jpg',
'FileSize' => '914 KB',
'is_book' => false,
'keywords' => 'soccer, stock, COMPLETEDIMAGE,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF35/',
'path' => 'Library/SF35/034332',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF35/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF35/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF35/',
'file_name' => '034332.jpg',
'id' => '034332',
'sku' => '034332',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF35/034332.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF35/034332.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF35/034332.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF35/034332.jpg',
'categorycode' => 'ABC',
'moreimages' => 'ARC1999379',
'headline' => 'Republic of Ireland U20 Squad Training',
'headlineTruncated' => 'Republic of Ireland U20 Squad Training',
'caption' => '30 March 1999; Manager Brian Kerr during a Republic of Ireland U20 Squad training sesssion at the Liberty Stadium in Ibadan, Nigeria. Photo by David Maher/Sportsfile',
'DateCreated' => 'Tue, 30 Mar 1999 00:00:00 +0000',
'ShortDate' => '30 Mar 1999',
'LongDate' => 'Tuesday 30th Mar 1999',
'db_DateCreated' => '199903300000',
'event_images_count' => (int) 4,
'event_images_count_text' => '4 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/ARC1999379/',
'w' => '970',
'h' => '1403',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 970,
'height' => (int) 1403,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '30 March 1999; Manager Brian Kerr during a Republic of Ireland U20 Squad training sesssion at the Liberty Stadium in Ibadan, Nigeria. Photo by David Maher/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/034332/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/034332/'>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%2F034332&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Republic+of+Ireland+U20+Squad+Training" 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/034332&t=Republic+of+Ireland+U20+Squad+Training"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/034332/" 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%2F034332&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Republic+of+Ireland+U20+Squad+Training',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/034332&t=Republic+of+Ireland+U20+Squad+Training',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F034332&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Republic+of+Ireland+U20+Squad+Training" 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/034332&t=Republic+of+Ireland+U20+Squad+Training"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/034332/" 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/SF35/034332' 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) 1758106812.1841
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 2/Library/SF35/034332.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) 1758106812.1753,
'_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/034332',
'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 * > F�i N l
�� '
�� ' � � � { � �( � ;G H H ��� JFIF H H �� C !"$"$�� C�� � � ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �X-�m��eo��7K���W�NR�ږ��3���K��`��k{=���b�r w69ɮ���5tz�)])M�<-cu�6-2���HP<һ]��^�+������0�i�ܥcF��߅Eµ���bU�b��r,έ�����y��ДB�v1 �|�/���9�f�x�h�Դ~�
ѥ��;�T�w�I��q]�Q�3K%��կ�>ͫC$r+���@Q��9c}�7�7�S��R��a4��ಸH��>T,rִ�Z���ͣ8���[;�X�[��\�'E�z�X�~��V�e���RK˹��~h��5N*�s��P��.nw`� �� 1��J�P��5�cb �pf�5VEX�e�_�ʒ,�I�A�ja��Vh�S���c��u�Y�K,l�e�a�ך�a%C�xg̞����P�mJ$V��ƱI�r��~��u/g�rqR�W��k��;>���N56��P�p�wϥwS�V^� ��9.F_���iu�v]�m�X�j�^��c$Ӵ��MsB(�Zƀ����u�xZ��R� �����Ϫ�S�%��iO��1�b��cs���H���sM����[���0J�-�>���?Rp���˧:��M�w(jZ�٤H�6��ʰ.�"�Vԩ���.T�bMF��|�"�XD����;p3J��o��6ܘ�'�o�O�c��]ۃ8� �=�(�L�i�J�:Ž�����SP�-�d���/��MX�����q)Po��O�_=��gl)����ن�akƄymb=ST�����@!3N�0���%�+k���%H����Nr),"�m���U�O��O���fIP6�}x�E����{�N�5$L���e2:�����u&�*�4Ž��Lw;�ʒ��`6���\��?q�3�HG�g�ձ�����i}Ad�=����p�7#Z/K�ї,�[ۙd�fhK.�#��jIӊT�̧'h"���#"8�g��ouv�j�hp�\�o��̻��#�gI-��]Dܼ��S@ܚ�y�h��P�7�K�X��&��o���8���Cw�O��\�'������#�<k����e�wH�6��cҢ�m��&���r�����R6�Y%S&�����8�8$�^��k���q����>Y�Q��ڴ�,���%k��͚G�Vv噋ƺ"�U��� �P��W�4����\�_.<��f�R��һ�[a�RP�C|���N�Q��>TѳB��|R�����G[o�����j~]�� ��k�xGGZn��s�Tm�Lr)-�O2�$�6v�ֻ����Su9���+V�����p��?�GjڥEM]�N\��)���e�s��T9E���i_h>!d[�6�G(Hc��V0��K�2��A�{h_���[h�k��e��<�ֹ���N��s���-^���,�`Hߝ+ ?D��O\�[O�P8�]=�`?��RꏪsKD���%�o�E�Zբ}F$��10� �\�(A�*�� ���&望8���OF�.md�O�b��|�-q"��F�],>2���^�_�L�?�R�՜v��υ��wq���W��H��F"U!G�^z�[W���ABt�[Z���pX�)s���[�M6��}�Z��#,�]���^�Z��cZQL��o��N+�f�=ŭ���Oi�0�Hos]Tq1��>d�2��功+FS z��(��d�Q�=¾��i0��]��I�qn���*�qY�h�BKK��S�����e����P������YYZ�
��;�$�$ִ��l�NN���z�(�FV�q�,�q F!Yzz�j��Ϝ���E���͍������}=�7ZܗԵM��5��kywt��I� ��8��8B>��P��;%sw���N�z�zť�I���>�=�
���&�uQ�8'�"^�o��mN�Z�7/���IP����F6�E��5M#�����y���;�;z�L0�6��9%����`�w�Vܶw�n/�V���ٟ��Č�;`3z��_Ϡ�8{�}���\�141Z��$���`���$V5�nȨ�{��x����I��#K�Q"