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/SF420/310785.jpg',
'FileSize' => '849 KB',
'is_book' => false,
'keywords' => 'Soccer',
'real_path' => '/media/images/IMAGES DONE/Library/SF420/',
'path' => 'Library/SF420/310785',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF420/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF420/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF420/',
'file_name' => '310785.jpg',
'id' => '310785',
'sku' => '310785',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF420/310785.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF420/310785.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF420/310785.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF420/310785.jpg',
'categorycode' => 'ANI',
'moreimages' => 'S0807054',
'headline' => 'Cork City v FC Haka - UEFA Cup First Qualifying Round, 1st Leg',
'headlineTruncated' => 'Cork City v FC Haka - UEFA Cup First Qualifying Round, 1st Leg',
'caption' => '17 July 2008; David Mooney, Cork City, holds his head after a missed chance during the final minutes of the game. UEFA Cup First Qualifying Round, 1st Leg, Cork City v FC Haka, Turners Cross, Cork. Picture credit: Stephen McCarthy / SPORTSFILE',
'DateCreated' => 'Thu, 17 Jul 2008 00:00:00 +0000',
'ShortDate' => '17 Jul 2008',
'LongDate' => 'Thursday 17th Jul 2008',
'db_DateCreated' => '200807170000',
'event_images_count' => (int) 48,
'event_images_count_text' => '48 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/S0807054/',
'w' => '3528',
'h' => '2488',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 3528,
'height' => (int) 2488,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '17 July 2008; David Mooney, Cork City, holds his head after a missed chance during the final minutes of the game. UEFA Cup First Qualifying Round, 1st Leg, Cork City v FC Haka, Turners Cross, Cork. Picture credit: Stephen McCarthy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/310785/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/310785/'>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%2F310785&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Cork+City+v+FC+Haka+-+UEFA+Cup+First+Qualifying+Round%2C+1st+Leg" 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/310785&t=Cork+City+v+FC+Haka+-+UEFA+Cup+First+Qualifying+Round%2C+1st+Leg"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/310785/" 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%2F310785&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Cork+City+v+FC+Haka+-+UEFA+Cup+First+Qualifying+Round%2C+1st+Leg',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/310785&t=Cork+City+v+FC+Haka+-+UEFA+Cup+First+Qualifying+Round%2C+1st+Leg',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F310785&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Cork+City+v+FC+Haka+-+UEFA+Cup+First+Qualifying+Round%2C+1st+Leg" 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/310785&t=Cork+City+v+FC+Haka+-+UEFA+Cup+First+Qualifying+Round%2C+1st+Leg"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/310785/" 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/SF420/310785' 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) 3
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) 1758079566.2999
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/SF420/310785.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) 1758079566.2883,
'_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/310785',
'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 ��5�Exif MM * z �( 1 �2 �; ���
؇i � $ '�� ' '�� 'Adobe Photoshop CS2 Windows 2008:07:17 21:40:03 Stephen McCarthy / SPORTSFILE ©SPORTSFILE � �
Ƞ � 2008:07:17 20:23:38 r z( � 4. H H ��� JFIF �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �-7�О;�4�y<�Y��I��6�6�.��1���-���ra:�4,�+�I4�,qBWn�1<}q\}ς|N��İU[pP��4����N�edEw���P'�6�60��e�9��@N�<����W�ʤ{�ך�f�d�����^��O{OM{iU���Ҷ�ԍ9�F�r�N�'�7}��ط��U[���`����4��RY����5�w�C9�r�Q�|y㏷7�ne��;A��5�x:����z.Cv�*�s��q���Ȓ���{�s��/�5���#�3�K�#�W.'�̪u�7}ͦ���X�"d�� ����V>�7��_X��r�hR�KFwhҵZ�����Ӽ1�1&[Ũ��t��{���/�v�x����ώ��$���O���Ei<Gh�Hp� ?��i�7� �[e�K�^��y�QV%M�`M�f�h��nA�ŀ"��鰭��4kc#��ԍ��>V�JNQ|���hi�ӮJ���n�Z�Kd���ᷠ?4g*}
C��6�(����_j.�ki�=�E�C+���V����y���Q�ܻ�{�W��
�E��Sk
"(H�8��+���]�jѓ���<A���H�?�#��b2ݫgU�?�V���m�.ZI �0}+YWM�a%�<u�躴:C��{�7ɶ��_7wL��r�g�t�`� %�I��2��s�_r�2��\���co�~b1#k:�q[���V�~8H���/8�i8Ǩ)�"���}&����|Di6�0�H=:צx�d�֒&0�g ��9��ʾ-E'&�<�Tд�[�z����\Y��ʽG��+�侸��e��Q��YIB]� ��"x�N���P02���_���e2fFD�"�ҹqUeNPQ��mJ*W�Dax:�I�F�ܵR�|1a=�4�!'�j�c��13�;�5*Q���hv���b-�pA�F��,�|H�>��� ���a��g�Z*)��wxM����[-����9��W�&��h���č�>���κԍ���?�i�Ho��y
��=Mv�ڊ�KD]V���y�g<7^�u!�C�Դ&��֟�W����
��{W�K�/ƒ��jmѲ�cRi� ��y��Z�i5H2Fr�:QE�s&h�j��>`
�C ϕ��t xy�u�|�V�#�"�>���;�^�O����$:��f{Icl/�#�kw�V�-���e�uq�(a�L8J7�6����N4����R���\\xt�X�6�&9�p0��r���KQu��C�+��G9���p�Njv!����h����c�ق�>�Z�w��46�e6���ϽB�:�F���iI��Y��;-�0)9o��2}����Z�Q�͕�˲"ij�v0ms##B���_j�k�,`����+��/l��Km �`+̠|Ɨ@���|?�?��l��[�pk��};�~ ���g��(��ǥs֧rɽ��7�V�[��|#�Z� �i���1��>]ì'�%���yS��rss��J�YD��<��V���)^q��
��o�t���K��6�,�w��O
:6Q��c�����8[_ x/̖�As���q�j��g��=�E�C�h��a�yLg$pk����}�;�am������]�OQP@<�'�<���>�F������Clix=z�bT�����V���`x.V�8�ʙ;���X�ކ�ksgw4f |��?�L�kK��˺������ot�. �[d�J�<g��Q$�A�j^լ.��F��VX�C{��7)ᦽ�GV���A�5��c������B��?-��,^$�&���˧���t��c�٫��*W��'�dr&�W���?U�u-�~'��[7��q�H@ߎ Ǹ"��L���4�ּ;�6e<��⨿y�wRi�O��7�.m��"}N�)��m�[�_ʱm�E�I����/Y�f�y���5��gS������mN��.�ǁ�_ҽ��vS�6^kĈ`�aG���C��Ԝg�y��_�jSO�ܔ���U��&OZ�y�
�h��]��שg����u'g��
\���>|=�ׇ5�%ԩ��P@�Ww�6 r��n�p9�k��֢4�����L(�Ԗ#�� I��ӏL��#�����3uo{��-�;� 08��i-�[���s���6z��u���G��%\����Z���k%�Uf�MzYc�K��xW-�LJ�[%��ە�K.8&�Z�X�[m% 7Q�:��4�����N��\����բO"B���v�4� �:|?�o4��`��w���Җĥ��{�X�?4Y�Srћ���1�`��Ҽ��g��%���=��m�Cu
��x~^�,���_k� �k�X�P�抆��d�=�_�/�K
Yԯ<u�^/��4�;[-Z$K[v�MoГ�kz���=;7i���Q��?e�4��{�87�GRNq���|�!��Q���! X�v>sIb[J�/궛���ǂ⺶�Sxr�"�����T������koK��ӥit��Z''=9��G;���J��/s��ׁRO
M�h�i�H���su'>��7�w�X o5���pa'�9�UHUO���Bt��=[�ķv�~B-�I�.z)��'�qy��c����Es�J��zTh,f/���8_F������4Ӓ�|�$�'