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/SF23/023857.jpg',
'FileSize' => '3 MB',
'is_book' => false,
'keywords' => 'gaa, hurling, stock, COMPLETEDIMAGE,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF23/',
'path' => 'Library/SF23/023857',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF23/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/',
'file_name' => '023857.jpg',
'id' => '023857',
'sku' => '023857',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023857.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023857.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF23/023857.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023857.jpg',
'categorycode' => 'ABC',
'moreimages' => 'ARC0001018',
'headline' => 'Tipperary v Kerry - Guinness Munster Senior Hurling Championship Quarter-Final',
'headlineTruncated' => 'Tipperary v Kerry - Guinness Munster Senior Hurling Championship Quarter-',
'caption' => '22 May 1999; Michael Slattery of Kerry during the Guinness Munster Senior Hurling Championship Quarter-Final match between Tipperary and Kerry at Semple Stadium in Thurles, Tipperary. Photo by Brendan Moran/Sportsfile',
'DateCreated' => 'Sat, 22 May 1999 00:00:00 +0000',
'ShortDate' => '22 May 1999',
'LongDate' => 'Saturday 22nd May 1999',
'db_DateCreated' => '199905220000',
'event_images_count' => (int) 40,
'event_images_count_text' => '40 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/ARC0001018/',
'w' => '1691',
'h' => '1932',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1691,
'height' => (int) 1932,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '22 May 1999; Michael Slattery of Kerry during the Guinness Munster Senior Hurling Championship Quarter-Final match between Tipperary and Kerry at Semple Stadium in Thurles, Tipperary. Photo by Brendan Moran/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/023857/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/023857/'>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%2F023857&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-" 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/023857&t=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/023857/" 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%2F023857&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/023857&t=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F023857&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-" 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/023857&t=Tipperary+v+Kerry+-+Guinness+Munster+Senior+Hurling+Championship+Quarter-"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/023857/" 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/SF23/023857' 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) 1758074869.1838
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/SF23/023857.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) 1758074869.163,
'_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/023857',
'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 ��4�Exif MM * J R( �i Z x
�� '
�� ' � � � � � �( � 3� H H ��� JFIF H H �� C !"$"$�� C�� � � ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �9x= ��U���ݐ��4�{��В�o�c�{Ҕ���g�xwf��8��3rorζ���D]�a��7mj�Q����w�z����>[���"x �\��ROQ [��=��ְ�BcJ�K37-
+�3E���>��Z��7����ٱ��}�_/���|�\�-|@��~�r�/�Sft4�n.v���\�r7B3d�4r��m�ǭ+9���/S��Vf�U��q��G-�*2�C(Ya���b���'�n#�-ç���~���%���<���Z&em
�S�0��-��{�S)]�zր1m�j�ǡc\ Y>}(B<�h�I��3Z\���z�r�.QB�qI�� ���cf�K])bԵF�-��ySt���O�]4����#��"4��(��}=�
�h�AńytG��I�n�G��n�'�w��X�!NW��e���#�h���\Y�F���#��#���X:O�nOͿ�%���Z+�k��t�I��N�Y��PyW6�����v9`鑃�H#9�Y�)M��G���R�*����NN��[i�Tn^�z���]6�;c%(�"� �Rn�E&\1��ڏ�@9��6hǍ���Fd7Q拭�KS8��EO1v.Y���CM4�ƕ��<�R�ܨ�3���]����K��r*��<v%�ō*Л���f�Q=_�b�mҲ����R�g#3Ē[�&�BG�F���s�5��\���i45"��M���RՖ�3�i��:��m�9��H��i��Rv�h�V}E�̲���7$E����&��>�z����ԣdD����-����#�
�d��̠�$u5S�1Պ0ue{Ӯ|S�����yb����*�Ͻrc�2��N;����召�'d��x�| >�Vz��5ټ��7��Ll*� �_4�R�q��r�J<�J�߁��[
kI�/��Y��8�)t�FUk�Y����7�
va������c��([��S&a&+s�[��0��lR�i!�0:Ӹ���,�G�z~�k��4� �(�YL�y����+��4t�p���Fũc�u�˱Q�S���;z��/�����C�M3����S=�l�{�j���VH��T��|P�G�E)�Z��
��|���)]A�Z1���Əw�O�X{����U&�4�R���hD�K�\��Q�,N:ץ){89vG
(J��N=Z_y� 4��+�c��R��٧B�UeR2Hell�F������h�6}�/�
�4uk}� V*�<�֑�
Xɪ�Ŵ�ؤ{7`�!RĞ�r����*���s$�+�y�%��7��'�\K�N�f$��T�)l� �5�*���S݆[Yּ��_��i7K-֡q{mu4�ZoX��=r}�*z��m4�|�ѝ,JS�^G5;
�+���#2i?xhK�kQ
�LP�s2`�_z-rY�84X��@fR��i�q�в�w��9��
�ܲ�)qI���p�rHebS��/r}8�$2�w3�lnhy�YJ�� h�+E� EN1X�I�,8�~3ֈ��7�L\���kT�q- ��'��4���8���J�H<Ν�)\����<?�����4�%�"��w�n��������q��J�q�w��h�T��m������]麅��Z�3l-�Yy{Y�]ە�\��1�=8��VG�3�p����;U嵭���{����e�x�^���Z)o��H����1��'�Ͳ�jXx��k��l4Am{wwo���%��X�9��Qk�z����F����-��i$i� �����X�`����Kwc�x�3���rmk���� ��̬�k�����s"�:�ƕ��=�����R�%��AV��A®sғܢ�
�e$i�L�h\����t2�`��}j[G39RČu��~�$y��#96n�B>���
��f�Z���3Ÿ[∢�<�=�y#�ֶ)�Ȳ�J�ӷby�ԯ.ѐ@�+"��ȡX�
V)ɞ���>�|3�M���N�1�� o!Wxg$�Xb_�
��g�֤�6��q��ݭR}�g�G�g�[x.�T������*!�m��WHǩQ�<�rb(��v>�#ͨc��S�?����y�\nCF��Ʀ.2Z��_iBM#KM�}�LWS�w����Q*I��<�0���Y�:t�Y�m���a�9$�q�#߆��5>_7�S���7�ث$k�]<��W�8�����rqکD�"�B��s/S�FC�CEE����zQmKL�el<�A4X9��H:��ZVw*29�_�E�e�'`���G��6�)�-cխS6���9�f�]�s�\Y6i�R��IX�z۠�v�)�&Ȓ�k��#�S�Eg)���Y�cC/��V~��}���z�6�u�Y��M�;)���&+q����<�g yԧS^��u�����S��GkGK� u^�n���KV�=}����0�.���>"��Ze�~��O�s!U��v��ЅZ|�ۿT��?3�c)e0�JN0����]�JΣz'7h����� �_K���)��,L�m��X[�)�������-iI{:��Wu�����Z�>.��`�zo���.��f�>�^��}���e����R�~�r���y;w�d��8�F2�R�^�v�����c��+�}l����~��j~�F�ƙ�C*H��<7j��o($� �2G�8���ө�������էY]Z/g߿�~Fb+�k�Z�ęNӚ���$�vh�V��S�/B�}ڽ����J�J��b�sOнM�3օ���A�.G�weGC�{2O��\�ilD��'��N��P���ґ
��m�0�++��kƑ9�a��F�7s���b�'���>0��nډ�)]���P����ll�H�e�I�PN���\S�;�D~C�f�̱����[n�c}�ڽ�Z��{����Ph��n�����lC�M���˞B��s�;��b�n)i���z2�Ƌ�-�n[Y�}"�������և��8�Ե9/uY|��T �£8 W;�n��c)b3�ڬ��ݒ��^F}�I4���%��X#���#��꧃���*k���)��嘎e�-�$����i�z牾#ζ�d~&���-�V�N�d�fs�J�8Ò0rrN��IS����3�L��0T�Q�H5�q]�w�e{t;-:��uŕվ�Fx&@�U1!db= e����˰x���X�ыI��� ��?�Y��=;U�nWh���廲��y�qHq��C��2�96���C*62�r?-+�Y[�<�v�)ߨ�Vд۱��&CI���)��R���$��wЫ�Q8e 㨢��6���
��0$��!Q��G�s��n�OCR��zժ��J�3�C���#�N(i�-��W��[����E�r�7"���U?�!��`wf_zƬ�tG��vd�a����h�^W������U+jT�� �m�,�l!�Li�Ov9$�Rk�K��Ƈ���[-��.�U����dl0�����R���*��}�m_Q�k����, 1�嶭+����EDz�?���MӼA��-��ė�~��O;�tl2�� M�FC�U�țw���+g�ـ�>-�Ub�;�[5ʵ�K����c#�:T�n�s�ݪ���1�:��T�=��!8Ԋ�vg�c�u��T��w����vy���b�w���轻�����V���õKJu>(���/�s5�FF9t5ޝ�p�qI��� 1�b�0@nXV3֘;
�0��(�Ԣ+��M�OQ��
�6m�g9��k�8��<�y�-�`�֟Q5��<������L�pzqֲfw��w X[$R��--N�S#Ld��j��j̫ԅJ��W#Z���r��=��W%T�e���c��Mɳ�n6x�D�s�Wo�k�1o�7w�'A��ѧ�۫)j�n�Ӡ?y�g��[XhZg��爧i|_zH*����r��ӊ�+E�_MG� �=g�4m�C�V���$Ѥ���[[��a���"gWn�+E�ˤ���>����>� �ԋ��V�t�~��$_덪%�Y �"X�bw��z��=�Q�2q�Ў��R��� ��E�� j�'.���W��E�l�
'���K9� �aW!v��lg�»oN[jr}o���J7W��ۮ�9��I�����św^y��;�3���XU/v�֏�L�r�����d� 0��l�"2�Ѡj[�m�犤L�;c��n�l���D��4r*�
3v�@H��
�V�k¹?���]�5a@�X�#��4j/ v�w1��z��� ���Yȃ����an;QTNKB��%������
�#7B=��y�f���|f�&�~�얶��hU�����y�;�w�?S��|������m�~��)��'�<R�Λ�3�7=V�X�����:�� �I(���Y��xJ�Wm�y�ܾ�
��3�7��rx!XKp�
�,:W���Vj����o�S'�*��9�r�����G�nD�"A��5�PK~��Y?��^\���r�;�� ���(u��o�s� �;
#Ö��7sJι;@B8��\�8���$���|�5lL��K��6t}E�]�n�̱���8b�N�C�b���ֹ�+z%���=�~p� �������/��C��mSʍD(bpJ)=y�_s�W���B�Wv�x��.URX<*�#�n�����w��#�I�R�I����~b)X�H�<1���#�:��m��U$�a�A��:�霎ƹ+�)Q|�z�tp�*ǚ$:������Y���C��G�� ��kB���^��?y<M����i�>�!�sI�lj��dYG�L��o0ɤ4s/>OaL��͗�C:�6o��EL�d{%�y���a#;��+��-�d�jI��j3�n�� CI�2�Ñ�G�\nk��C�<bu����ᔥ�W�_�ʋO��i���=?�Vw�2Q�G��}힕bH�uKX�y@r~�iZ�ѭ����M����݊��1���^��9�m�"��=A$�:qSZ�%)\��d� �h��|Sw�ou6ז�=V�LE��<��F��I��å|�sW��K�����ɗS����rB�q csc�����=߳s���z���mC�Igo��O�I3ob�mS�K�@�z���=
]W&��o�d�+����E+�7�|K�q�V�$��}��ݣk��ޮM�&��OK��|W��mf��u�̧�0-"�тn2��@���5�W��
YʌR���NQM^�r���kw<�8�T�т�)9ɭyy#&������~����t���RY�ԎA��U�a�S�ST��u^ޗ>G�u�J�֯���hwe�*���M<)�{�wXX&c
�gụ�������&+</סۄ��J�:������ub��:`^�N�t�z(���ǩ�c,����FJ��Cއn���:����I�a��V���$��\������ �\��L..)�7��4���?:�~O�G��<{H�}bV>y3*����X�%�����4�)ٝ.�i9a�?JW@�5�fG��iʘ��Jd�z�عQ�>�ڀ#�g&a4{����9���6�0� d)#����.D�����ZeΩ$�ﵑ�b�y9��+6��e\�N����/S_^�����-: �,�\��,�Y�m'