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/SF189/173477.jpg',
'FileSize' => '314 KB',
'is_book' => false,
'keywords' => 'Football, Rule 42, Hurling,',
'real_path' => '/media/images/IMAGES DONE/Library/SF189/',
'path' => 'Library/SF189/173477',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/',
'file_name' => '173477.jpg',
'id' => '173477',
'sku' => '173477',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173477.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173477.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/173477.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173477.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0504068',
'headline' => '2005 GAA Congress Saturday',
'headlineTruncated' => '2005 GAA Congress Saturday',
'caption' => '16 April 2005; Former GAA President Con Murphy speaking against the Rule 42 Motion at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'DateCreated' => 'Sat, 16 Apr 2005 00:00:00 +0000',
'ShortDate' => '16 Apr 2005',
'LongDate' => 'Saturday 16th Apr 2005',
'db_DateCreated' => '200504160000',
'event_images_count' => (int) 97,
'event_images_count_text' => '97 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0504068/',
'w' => '2464',
'h' => '1663',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2464,
'height' => (int) 1663,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '16 April 2005; Former GAA President Con Murphy speaking against the Rule 42 Motion at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/173477/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/173477/'>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%2F173477&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday" 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/173477&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173477/" 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%2F173477&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/173477&t=2005+GAA+Congress+Saturday',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F173477&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=2005+GAA+Congress+Saturday" 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/173477&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173477/" 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/SF189/173477' 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) 5
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) 1758144533.7401
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/SF189/173477.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) 1758144533.7264,
'_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/173477',
'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 * J R( �i Z x
�� '
�� ' � �� � �( � !B H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��O�G괢A!��/l|������P�8�H��C��h]G��D�;��)Aۇ�<����$dB�P:�ų��/w��FHi?R�z1k:w9�sG+���@��NI��[kc����P$G�Z�~h*妝t��1ʿ��w/�1RڊՆ�r�\�q5��G=ϧ"�˞ ���r�)^��T;ɒDǟ�����.iE����:��� ��u�H�G:���h� OX���ʼn���k��@�Fs�\�#�6���N����i}�m�ۖ�����"�)� ��c�w�ӿ�@B����&?E?�L)e�U��4Ӓ�1�o���� Y�Ҋ|��eҰ���[E����\�?��K+�}�=i(((�� �xJ=v�[��SG#.��Ԓ=���|��X��\��J�q����+��13�߅����æ�J{f���Y]2���������K�\�N���xۅ`zv ���Z�'�0ΜT��+�<�
( ��
( ����ps�)b�m.8� �Ԋ7�U-�T�bV��C
( �� ��w����<��m��rNG����6ii`7.�����+��d�OW��;Z�79�>���� 2�y� =+�>>]�_k6W1Lf�#�+�$��g�QFP�&� ��{N�<Ί��� (�� (�� |`�G5+
�0�*%�7�RhKr�� �)�>%�ڪ;�U������L� (�`�+�i�����ʷC<� ;`�6�W⽻����g������H�#��l���f�Q�;mtϣ�5*0�L+�'_2K::ȄD��t�Q�
ßS^�L�K���G�83,��R�_j��j�b�� �̱��E���(��<��
( ��
( ���\�$�?� ,�d�c���N���)�T��k� �i�(������}��4���{P݀�٫O����v�^<W�z|�ԣ`y���A�ڮs�A���O�R.-�[����_?��ے���k��z�u[ޛ�cx��絺�[Kk�]����6�T�'=}+�>%�I>�20/x��=O'�����+t6�T��r�W�Q@ Q@ Q@>%���8��n�y`1���3��0o�$�_�Zq��Z��)QY�"��� �:]3A�H��� <����{�gQ�Em�[��*
甜��v��{�59��yXd_�`r��^ٯy~,�t3��l���%��'+b1���hƼ%N~�UeFj�O$��t;����*��*a�e��\�θ}R�K����0�,�{1!N1�듌cɇ������N1�J6��C�4�0ea��>�w'tq�(�� (�� +{�~ֵ�gӴ�� v���q�鹈���ԍ8�I��;"��� h�Kye�3Ѣ�d�v5���q$��ɰ|��9c������MJ���{n�$�[?8�[wАN=���5[)4��-eeb��^�=k<.%ԓ���IE]j�����;U��v�cn���C垎�#���&PF�:Z���t*�J�?2g�}+Ҿ� k�_\�O�ss
�d� ʟb�v:e\dԉ��8�/K�#��P���W1X�|��� �{�+H��M&y�-���n�@$��צ~�u��n�d{�4Dl(�Q@ Q@ �S̙#�70��;��ԣt�ih�; ����}�����Q׃I�S��t�[YOkx�:8��1;Olc��9�^A��C�|F��̑]ؼ�D�"U$��oS���+6�^G�^)(�z+��ɥ�V�3� �9�&���ޣ���V����daWz����O�]8.e]>�8�_d�9=�^$�b�km9�>쒝��_ZՋ���3�OoѬg�}�OG_^��<E6�S<�g%�*O((e�3���ޱh�� r��e硧rq��nQ�N���k�ڍƝ��j֍�{Y�X��s���������m|S�O}�Iem`��M,J�̅�.p
���0���c��t���"��/.m"�E�c#fB1X�q�+���r��[/�=|<���|��q/���\9�I�$)Q�2pH�H�*�;^�[�<�F�$���)@$�rh��<#�]�I%��$����Ao�cQ��-�؛�$�A }+��i�Z���V��K��9��Ua�)�֝�B� �~�C�>5�:?��F�α &FY��ܚ���_���aiu�����u�lJ�+(�'h�����Z'V��ԗT��hf�b�}z������pC+8�99�^S�iv�͔C6w�#��"f�
�U����H� ҩJZ��R�J�;��.ŧY-� ��[�!ܿ6z瞕�֍q�[�^�Yb�ʨ��i����9>��i7tj�c��>j>��=J'u��� z���?�_R��^ J�9�
e)�_��D6��~"�^o
��7�
ʗITm%�7���ָ�Z6�1"����ƽ�5^xF]�IҨ��-�H�'z�д��yQ�����8Q�=
գٴ]*�H�ua��]^\��&�HHDf�� �+�1ܩ��P�|C���H5�e�9aN��>:�8�<�*?6{��iSO���5�-^k��`6DJ傀s־����������²\^�����Q�<