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/SF76/084401.jpg',
'FileSize' => '3 MB',
'is_book' => false,
'keywords' => 'rugby, COMPLETEDIMAGE,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF76/',
'path' => 'Library/SF76/084401',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF76/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF76/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF76/',
'file_name' => '084401.jpg',
'id' => '084401',
'sku' => '084401',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF76/084401.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF76/084401.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF76/084401.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF76/084401.jpg',
'categorycode' => 'ABC',
'moreimages' => 'ARC2002355',
'headline' => 'Ireland v Italy - 'A' Rugby International',
'headlineTruncated' => 'Ireland v Italy - 'A' Rugby International',
'caption' => '22 March 2002; Alan Quinlan of Ireland during an International 'A' match between Ireland A and Italy A at Donnybrook Stadium, Dublin. Photo by Brendan Moran/Sportsfile',
'DateCreated' => 'Fri, 22 Mar 2002 00:00:00 +0000',
'ShortDate' => '22 Mar 2002',
'LongDate' => 'Friday 22nd Mar 2002',
'db_DateCreated' => '200203220000',
'event_images_count' => (int) 29,
'event_images_count_text' => '29 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/ARC2002355/',
'w' => '1692',
'h' => '2167',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1692,
'height' => (int) 2167,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '22 March 2002; Alan Quinlan of Ireland during an International 'A' match between Ireland A and Italy A at Donnybrook Stadium, Dublin. Photo by Brendan Moran/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/084401/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/084401/'>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%2F084401&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ireland+v+Italy+-+%27A%27+Rugby+International" 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/084401&t=Ireland+v+Italy+-+%27A%27+Rugby+International"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/084401/" 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%2F084401&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ireland+v+Italy+-+%27A%27+Rugby+International',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/084401&t=Ireland+v+Italy+-+%27A%27+Rugby+International',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F084401&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ireland+v+Italy+-+%27A%27+Rugby+International" 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/084401&t=Ireland+v+Italy+-+%27A%27+Rugby+International"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/084401/" 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/SF76/084401' 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) 1758122486.1353
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/SF76/084401.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) 1758122486.1238,
'_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/084401',
'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 ��0tExif MM * J R( �i Z x
�� '
�� ' � � � w � �( � /� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �����5D��Pdz~�wȠB瞴��`����PN(�q��$�?�O�����/�H�$`�5ˋ�
��q_��0y�&�
�[�ޖ�,Hc�>�Xi�b{����T�`R��@��ޏ�J � 恋֦���~Pz����P݁+�Αtcܒ[�tJ3��~�FX��C��㪰���ԋ�7�[�Fvξ��X�t��\طh�S�h0�}k�CZῆ�=��uorl���4
�Of��J:PHw�8t�I��3c�Z�%�M��:}�C��72�����`{�^�⟇�~�M)���H��K"�䏽�<�\�S�Q@��̱b�J��N��*�������ܴ���;�x�WP�+�3mq���Ę�/��*(Tu=��U��?#��_�ؔ�w�A����Ѝ<� tv���
<J�?�~�oz��
k���<�4g�nH����Pu<�s�@n���ߕ �@յ}T�� C\ވY,U ���פx�^�Əyd.��J*K�F��8#<�{ם��JUR��<��.�r�����j\,^*���}e:� m�@60 ��H?N߅sW�[����́������qP����s��H�y-�^�j�~;�lb�dK}RxQף���q�����X�#��z�zq��{�C�C^co�o��"[�`�
Ӽ�r �H���b\]�ĉ��3�L�t��\�ʋ�K���-ք����B�� �\:����V(ޝ9�nL�˳��sǧ�Y �SG�1 ���?�4���!�w�mN�K�S��͵��rB��ݯ*�1�B3�^�4�Ljt{{�J1�A��i2��.{u�ּ<�1U����3V^�P���wХ<��@J�$?)ڜ�~�~4�}6Mad�Hl��=B4Ef^F1�GREp�M�G����U�Nu�h���n���,fk�}.$UV���zĒ�_[� �#�� J�q��G���4�x����8��"��� �D�s� C�K��7�c5��ݙB�Vb
�u� /�nivt�5ż�\F�X~ ��:
�12��&���VOK
Zs[�^� ��z֨[\��Xܼ� �#<|dV}�1Or�� �P�#��z���X��CS�.���� ����B����̟N+%�9\Y���v\�«��S��V�bP�YZO�zҟ�E?��/�/&p���,DEfW��߈��Ơ���"L�j��*�`�F�����p�Z���=�����D�9�G����2I���ͣ��yo�X�8�MF9�l7��dg���U�Kg�}GF-�%�u��u�{n��U��p>^Nz�{zU��
[���z2��uK�;F���[�y�ǽx,��3�C�C�R�%X�4}�&*��}���g��
'� �sW�k��N�Ih�C�ȇ*G�r>��U�������j��sR�Z?1�\d�<���6l� z��<G�ua� ������τt�e��VS_jG�U�N~�f;�����5c��
�J��x�R"f1�l.��I�p��ּJ�����Z;�e�U B��������~;�x5���ڍ����%��r���� ��,�E��Z��a!�<�>�Ϟ�݀�{KS����+�؎o�OO[��=q>%iD��?
�o�Go�m��*����rW/����� JQ��Qx�Da� �
�Ґ��f?h���Φ��nҙ��pd��=�9"gV��'�3��Ύ�������zd�κ���x���C���m���#���ż����Q�qO��]�ת�+Ɣ=��^�u'����kM�H�I�\L������_�
c����oFMBX��]�flW�����\��a��b8&� ���>�,�����
�\V��w�"Ȫ�jvrrv��l�@O�k�T��
/��V/O
�J�{G� 3���w�+Y��PM��A�&�Y���(<�_�䎤W�xK�\���z,"��ڱVN9%X�߆�#O��~a_�Ѩ���p_���%�Q�6�V�dQ�>��z��+##k��?ݣ�Z��4j�\�r��U��(�͒5��cwS�8��0jF�MI^�ھ�Z#Ɉ��du��c)�2M={���&�R]��2�ֱ�X躭��iiv��Nɋo� s�쌏ּ^�y�{���J\�-�,yc��]Yd"�)u<�%�7
T��� ~FR;�P���z�K�z;U�a���#2��ª�I>�w���Dni�EՒ-��*��ڰ,I �a�G�:V����
��~�������&��<T��]$���m+������{Ք��KW����"�~��dG=� ��F�F��O���R��}:au���h�L�l�h����d{W�|9��Ěl����L�G}-�-θ�%�(���ǖ�619Ro�s�O0�1�����鯑m4K+X��f���1
��O�H�Z��G��1�i�e�xz��SQMz��}�An��(�<�q���K�>���c��a
OYj���?~Bx��O������R�ӭu0i��2�rͷ� �f��h���UB���OR �
z)$�?)�����4�5�h�G�,�Rx���.2A^��G\Vl~�RYf��;�O2kbrPd�{�$u�>�-WNJ��x�˩{N����C����#L�B������Zٵ��-�?c�<�<�}+�B-���>�'�ʽ(Q�����xƜ"��(�4R}��$c��O=Ԏ���f #��8�@��0��2}O�s`�Z����q*�5��Ǚ��HLE{��ֱ���%�b{ɷç��e�nF�gb�-�ݲ3�;W��vl��d���ð`d�8��0;��ܥc��Z��l�f]��H���1/�� �f��\�`rCe@��MDʝ�$�
�_ݓ��d~���i�Z����
�X���>��®��5u�
m*"���i�P����6Ys� �[� �h��J^Ok%��r=B�q��gk�p7�I�A��K�4y�|S����Ϳ�'ҼC?�#��v\��6�TH�'����3��<rI8���2���i�nn�Ha�z��
���cJ��Ty��g_5�J��vK�$��V�P�7��q.�a��j��qM��!�$���Q�^�+�vSmK|Vd����n���8���Y__�+����?i�B�.Q � ��m.O-5��%+�T�#�r9�n�Ӕ��#��שw_��/�A�趾~���a��h�A�QϖKd�0�9#+�zE��~�kh����$��H�+�8���\+5Z�jGx�}�� �=�U�Ҵչ�a�jdD<4�8
��5�>