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/SF320/244385.jpg',
'FileSize' => '448 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244385',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_name' => '244385.jpg',
'id' => '244385',
'sku' => '244385',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244385.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244385.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244385.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244385.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Limerick manager Richie Bennis greets referee Johnnie Ryan before the game. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'DateCreated' => 'Sun, 15 Apr 2007 00:00:00 +0000',
'ShortDate' => '15 Apr 2007',
'LongDate' => 'Sunday 15th Apr 2007',
'db_DateCreated' => '200704150000',
'event_images_count' => (int) 20,
'event_images_count_text' => '20 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0704111/',
'w' => '1783',
'h' => '2040',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1783,
'height' => (int) 2040,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '15 April 2007; Limerick manager Richie Bennis greets referee Johnnie Ryan before the game. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/244385/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244385/'>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%2F244385&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244385&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244385/" 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%2F244385&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/244385&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F244385&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244385&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244385/" 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/SF320/244385' 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) 1758111511.1438
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/SF320/244385.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) 1758111511.1319,
'_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/244385',
'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 ��0RExif MM * J R( �i Z x
�� '
�� ' � �� � � �( � /t H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �;��Ő��s�՛�3hk�3���d�+ٸ��e��Z'�b�FDYj��] ���_�cZ>�e��Kps����K*!waqi��)�3���+�gk�90J�z*`�9&f�:ޥ���T��+���\�H߇&���5��M���8�rd�5��x���y<ҷb��!�u0�3�ʠӥ�ᩎ?���ں�ƍ;�V�O;�*�u��2�:���YOLT#S]� ���&_�?��Wd���b�&�H� �����\~�|O�C��d� � �{��A q��ZE�"#�l��4�*���a��� *h���?�;�?{�kG�N�2��K���zX�s� lg �
kxz)-��f3{�m��4�D��e}�Xu�@w��|��)����O��g�F�^ѡB
n[e���$g�t�z����t�ک����?���5�|]�ݟ'R�`��%Aefq�<01^Ia$C×����6G�Z-�:�Q��֤�i�cG�a�x���QZ,gԡ�� �_��� *�k)� �B�� :@h^�M����$V�s��,qw��5�i�4��� ��U��(��$�I��.��<T�|Y8㘅?�0�bmK�P\� �c���_%%���qPi���� *�����;�Wj.�2�^���u1ˤ,��r?
/���-��Q� <zWW�ۋ���X`���UK�@�e7cZzȯ�]\4�<��&cN��'�q�5��ѫ���0���}�� =��S����+#��e��tX�b���,�X���W�B���ܼ�~��J\ѹό�,��&�IѴ�?���I�<��Y�����}[�C�������<Fnᴼs�K[m�4��`B)��*s3
�Jp�f�u�$�Gg��ao�+��FOL�٢�x��<���K}����G�$����� ������O��e\��o>`��(��Ƨ'�6���*b�>,�u��>�0�a&��V��d�x��5�DRA� j���EC�k�S<
�S�I6����Ѐ�&Et�:��{"��.�>�ԯ�Ռ���*��",�|;q>�vJ #b =#��3I�\'g��
�K�p� �,S�o'i�s�H�{�E�C����� ����9�P�#Ҽʓmٞ����.��Z��R[�4k2H�2�c�\d�������� �6d��W
���y��G�Y���h�q��t�O��#�� Jќ�E-&0uMP� ��+ӧ��`�uz'�
:�!��_)�ppH�LtȮLL������\��C�b�i���*<�/ܥ���CX�)����RC),�
�VQ� �@���5�ܬ].V�Z
�\� ���s�U'�G+��q��E��7���07Z1oA���%�OJ�)�d�(>�4E���س�t�[R�tr)����p��)B�9����<�]��F�� �#�I|�ME�])�Q�X��Y�O�2>�!,n�?����kf]�������;��5�k��p��i
�7өć8"5�=� ��^��_�������^�\߯Ϻ�4�!&>��6��N=s�Lbߡ�:w�K�=STI��oK)� ��i�@� ��C)?Q^5�jz+4�d�Z"�k�pp�`��� 냒=H$��3�Y���%J|�6}O3�X35�i�B�K�ݜv��U�XipI(x�kР�|�ʴ�J���%ٶJ@�J�Ҳ<E8O_¯���]t豩j,~�WYw��!�����,�Q��T�b.@�|����㜞LL��=,�Zn���3��{HD "�B c� �X:�x|[
�R�D�[9���5�ڢ:�{:ء�6���I?�T� gx�d��r�hj��}+v1����_��������7ɑ�G��>Y�ҹ˒��
X� �~?:�ݭB��HL��g�ަ�+�(Fk�5�z�ٖcm���W��9�֙��m����6�n.U���Ĥr{
Ǯ+Oj�[dͨŹt>��":f�gH�/0��$X,JTq���kOO���)OY[#�T�\�v4���3/��5Y�L�26)��y�G�?�4�X��Z���\ibG��IUx�^ �\��3��%+����e��<Q��s�I7�4E����?�ny^T�A��X~!݈�l���kЦ�i�cZ2rJ��\��@"�,�c$����
���MkFR�Y�]Knnkfj�E��A�6q=���iWs�ɳc�!�(#�Rr��.�݆�U:]/��ӭ�����죅��?�>�kg�x��B��'`���?�#��N74v㬨�̲�f����%xf_��&��v=�����o2Cd +��k�VV�<�N���QY�I�Y��z�取�����˷,p����N���d�9BX��.�C��X����]s|�S$t�� �
M�j�n���\����4zl���Glצ|4v2�v�2���x�%UQ�F2��i{F��LlTi3��/d�θߴX�@�d=���s���� �4�����b�"rY�� �]1���#����:Lj~��MuĬ2���ߞOҼW�n�q����\�46�������G#�%���+���I%�jy����:�:�0���Eq�_0@y�<dn�O@O�cx��8�{�H�๖W�˲F\q��?�/&z9kN�fji����gҴt�%��!/+�UrX� �Ħ�z�:��H�~��0K�f@�&@V�x���w�F:�;��F����s5�yH�P2��q����t�8Tr]�}�����=5�,M�"�e�O֥�k�U�ʪ�������A�s�k��ѯ5����Xd�O�v�cF?�\��6��W\+*IM-� �Ϟ���r���o&�����4�^[L����,Mʰ>��E
e�j�f�C��� s�}����ӕO����q8h��˯���Lg�D�h�Z&8'��q��j�:m���� D�i�4,Fy9��N%��g
I�eIs����ҬDڮT ��+nXv�m�f�^��="�|ˋ��$S��=O��}�C�k]'�2��{�������YU����v��(=�q���G��Iп�<d�����%�b�<�bq����FΙ5��C�5���D��cfO5�P$pP
"0��$<��q)���Nv�`3\>�o-�nZh�VR���0I g<q^K��5-#Vgi�:e��ʊX�r�)�3����K�����I�+�*�:�7{���<O �|0|Mm/���}� l�a�J��z�=��i%$�~��8)�շs��k���#&�/�Rݍi�ktyS=�)����H�1�G�e��LU8��>'�/
��fw3�A_oq�>ج�.bc�g 6���61����gb�֗g��l/��ɶ/�FN~oP��:`�kE�
s-�\y������8�I�Y�u<�8jt��q�N�u>�C���A��.���ռ����=W�+X�Y�y_S��R�a�x���~h��O#��}��>����WlpԚN��x�J�YS��MZ�G1O�aޖ�Hc�$!x�\<%s�3i�^Ф�q�Z�m��gN@�X�bh����5��g`J��:K�F>�����MS���i:����}��I�G��|��?�[���,m8&�3��g�4�+��ߏ���u��Kߴ���#:��?�5�I]]E��0�!�U���p��Xz���5���y���r>�=�ag����S�%��G�k �<��� �^������s�'�����B�.�
����S���=y ���ߚ��j�
���R��(k�5���}+si� �ᤄp�����hx�${�0����#��
�ӄ�>�(�㍦������ct�������'�W7����(�2Gp��Rx� ֮��>���9E7�7 S��'h{y� � D�G����@��d�l�J:���~�Jj2m���%�w �ʲ�y�KƑ[!T }s����9*UNq='A�;�E2��� ���@��/Z�ۂ>G<�Ɍ��g�
l�z�9Ǵ�4f�WL�x�{�UY�X��Rkf�.J�⸨���9
$���T^A�KXշķ�I}͎�b�}���)�y� i�x��u,k���@����&