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/173478.jpg',
'FileSize' => '326 KB',
'is_book' => false,
'keywords' => 'Football, Hurling,',
'real_path' => '/media/images/IMAGES DONE/Library/SF189/',
'path' => 'Library/SF189/173478',
'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' => '173478.jpg',
'id' => '173478',
'sku' => '173478',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173478.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173478.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/173478.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173478.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0504068',
'headline' => '2005 GAA Congress Saturday',
'headlineTruncated' => '2005 GAA Congress Saturday',
'caption' => '16 April 2005; Former GAA President Con Murphy 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' => '1632',
'h' => '2472',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1632,
'height' => (int) 2472,
'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 at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/173478/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/173478/'>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%2F173478&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/173478&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173478/" 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%2F173478&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/173478&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%2F173478&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/173478&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173478/" 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/173478' 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) 23
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) 1758139018.392
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/173478.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) 1758139018.3621,
'_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/173478',
'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
�� '
�� ' � `� � � �( � � H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �N�X
�U~-V3իԫ���>C�J��j�(�j���l�g�C�����p��F� � ��/R�C0�k� �֦�[��Rx*�[̙f=R6���/���NQ���$�%[�4�t�:㌋.c���{�5X�1|�iD�zv-V���E#K���o#��N��<?�_UCc�+�H/�!Oֱ�W�"F��Y-6OR�Ϙj�ˤHh{l�:��� ���[�M\ol
�:!w�����׀+j���Y֣ F�nN��㞕aof���\�֒��tӆ���^t4X����Q9�5:�"��U(*q�=<
J�de�x�ʛj( z�^s�$�G��V|զ��"q�~���5�.L������t|�&��">-�wڲ�}�_I�k�7Z�u<�Sks��"�=�i�6���;!A�c��Q[T��CL>֨����kH�{[�;g�'��A��U����!n������e� {'�צ>��Uq�jI�R>Ζ�8�����ot��M�I#��]��q �c��]/�,�f�VwV.�b�7������2ў�i�]x|ʬ#�-Q͊�iU|�F[�>9xryDgK�^�`�z� �g3�^$мC:e�4�ɂA�P=v���dV����&�Z�����G�G�G����O�g'�)jR�n��
�5�E���e���#���Z7<�Ğ=Ho�$���(�2��z��P���&�v�����:�:uex�nw����ѝ�ɯt��ԟJ�U\�����E d�$���yw�Kf�<����Ȯ,ν�r��=j�di�˙b�e
!�[���-��zqڸ��ZM-���9*I\��k�'�����Q=���f� r2 ~��VC���0neP��?�##�+XM��ck�&�yc�e ����#��[�u=2x�+�1�-��h��+pT�����Q���#��%+şF�,��g{-��♕��
���� =7�2@aԂ� �]��K�;?_�6�1����Ll�A�5�~0�k�:E'�k�ۮ�c�C�1��w7�\������{3��A9���FE{i�=�e�O t��A_A�~�� ��|�+Z�:�&�]J��E9vFz*�cM6��QR0>T^��xy�~z��}NQ��ty�S>�İZ U 0��U$W���&Yݓ�s���ը���R�p��J�B3���=�X�:j�ndP� g�VJV:9Q�k�:��!��O ���;�:{k����1���<���zxz�Q<��Q��-��7.�
AQ�c��_N+��w�-Ϊ?�ՙ������c���/�2�
��-z�V�G�6aOE/�S�����/,h2y��.ti?y�sޱ̴�j.��%�57�=(�𢼇U��!�C#�7o��=�u����ɣ�� n���6v cֽ�C��q
�sH�g�MMz��.yt�k��my��F����c����x�D6�{�����=k�*��}ϴ�G�*=�{S�6[<sJ�AeO��F���v� �rɶv�:���ۖe �L�Tgٱ�k%�I)"2Ɏ��Q�皨�P���v`\.і>���'U�
!d���%@<u���I��ˈ�kR�����e8u��Wg���k���j��oh&]ɝ�^G��s���c u4�88�]����(�[V[\�$C�GC��_.��]��T��r�@�s*o�Cɳ�%��&�gT�^9� �Q^2���\�;_�z|P���1�X�� �mv��һ�Y&x.���.������z�
����x�S,�� t��{�S����t�Y��wW�B��'��R,��s��i弉A�#��QҼu>���\L�2�,�d��>�G��h�ĽP��/2)?�4yu9��bc�eS��r�?''��q����-�'�ϸ��?�J�1V�P�C;������ʀ�K��__O�]T/ΎlG�r�Ԑ_$�o�N�#�y��XxLr3`I�2pI�W�GMO��ؿ�?�~�_0Au4I�ʰY1� ���׆k^��dz �&����,���.L��&��O���tc��<���
���MV�S��R��9+�.;��@
���k�Gy{ul&!ț� ��Q^GN��x�^G�41)��E�wg�V=��P�S��W�~
y�oSl�z�����(.BQO��o��� Z�`�V[{[S����f���
���e�$*�r"� 9��̅�Fl!89����H��(b3���C��@�a����^� ʺh�x��=.a��P�G1Ԟ�������m��&8l��#����+Ş,ݚ���쥨�e��P���[�?�C� ��U�b���r�n
�yö�� �*� ��sƎ됽3E|ڃgҤΞMt��L�5^}h�ֱ���8�4{إ$u�g����M:� �ݵQ����AץEmefv���Vn��'���hfPr�G5������I^�����c�N����J��9�ڹ-g��x��?��8�� ��XS��3�.�zf�<�o�q"7��`��گ\l��e�VZ�F�AE�jg�[cܜ��=�*{�И�|�"��:����0����+씴
WA
��Σ�u,<���wr俍{Xy;3ǭ鿁�H��-��)�K���'��� �;k]�!�\��uØch(��������kR�W;Q�H����(��m�CR]]ш$��5�P~~��-NZ��t�M�rO�-y5�GÑ�i,R� �HZE�sv�8Ϩ�<D���a���
�x��O7�� fG!dUÐ?���c�ry����8�o��1�r\�]�&K|�)� ��j�A��T���h�\j�R3�Wqm��[���,s��e�8%�F?��:}OL!�er*�p����ֆ�Q�E���<w2q�ܩ��T�_7,��2F���KwZ�h����m���6Xr��q�I|��!�X�8���#ՙb�Q
����BMM����x��Z�t�俜�j���m ���'����oN��)�O�=�F�%MŭϨa����
>��X�����lYF�G�Fʚ���H��l�Kl'U���Ԍ٬˄fcɮ�K�EՍ�^���:��H�w𭇟��#,$�?Ϋ�h���xX^��+1}.��c� �s6OG>�}*o�א���p�-���� ��A�^|�=�v�ݫ�X�Z�jq�*!Q�����j�HXF�ll>S��= �V�杮.T��Z�J��S.f�'�H�о� /�[Ph�gh$�P2�fϽEy�AGVd�wj#t�=wq�4RDn�"�)�B��rhZ�Z���?2��L��5��:h�<Oiej�4�"����?��+z�ي����TvH.��Pz{U_��
&ї� ��5�;�X�Mg����<.U��#EXM�Z<��d�A9ⶥ���Ě�b@W��^��{S���LT2��q�E����F3�0�ofn[^ZXiw��ck�t�"*���n�/#�����Qw��oL��q\�x��Z�ep��ix����rzֵ���> {a*��(}�#�*g�=:�Z�H��-�<~�pW�<VV��I.X1�s֓����Nf��I�=�U����"��\RH甮�\�Ӯ5S�4�Z[�*(rK2��P|ס�<�d��Wh�A��������nƟb�W�x��m�O-�+ʼE���,�9۞j)C[����~h��#�5�ҝ�3�b;V�k{;�f�h�Qw:�E$T�Y!R��#������sM�ʻ��
�K���̽�Fdz��s{mel�K�X);�r}��z���a�In������6=��V496gTݛH�b���!��0� ;4�.��d�Wo-ϝd�O+��Ec]GKFW9}jD�&d'���E�v�YA�N'��Ӧ�L��l���0'��b����N,��'��5�v��ju�%���87��Ü��� j�"�ˉ���d�-���8g#����g(�~��iIC�s~1���^?��P�H�(��6>�>�S�?�Aw�{YB�¼�;�̎�ᕃH'����^������
����B���w`Dj�"�I��W��<�Bd�n.���n�.}0����q��Ғ��P���ֲٞ��W0G�2Wa*pECq�Gf���� �7�����7�{�(��̪��'h<v��e��*�G\zӊ����Z# &