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/023723.jpg',
'FileSize' => '2 MB',
'is_book' => false,
'keywords' => 'gaa, hurling, stock, COMPLETEDIMAGE,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF23/',
'path' => 'Library/SF23/023723',
'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' => '023723.jpg',
'id' => '023723',
'sku' => '023723',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023723.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023723.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF23/023723.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF23/023723.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; John Leahy of Tipperary 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' => '1680',
'h' => '1757',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1680,
'height' => (int) 1757,
'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; John Leahy of Tipperary 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/023723/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/023723/'>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%2F023723&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/023723&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/023723/" 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%2F023723&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/023723&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%2F023723&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/023723&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/023723/" 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/023723' 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) 2
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) 1758134411.3793
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/023723.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) 1758134411.3649,
'_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/023723',
'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 * > F�i N l
�� '
�� ' � � � � � �( � <% H H ��� JFIF H H �� C !"$"$�� C�� � � ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �Ie$��k��v�*�@�@������+q��<ʘ��m-���HͳX�ɷ������ �2}�*(�&ij]�X�q��ҍ�]���+��I����sG@9�w,�12d�3f"BzQ�+�
Ԍ�H���2�I���sR�*�+q"� R�&��t��=��}J�]��h*�JzX��?� �nɌ��<
��5�ƒ�Q� �i��ՙ�>����s1˦�u4���Ì�v>k+"6�q�WgcR���h�4X��_h]V�w�����QrՖ�o�(9��7v����I�G��)�Ś�����}�D��A*�]L�i#݂c�Ib�o�=�XP�7��<L"��]��ޛ���W���y/��x���Mv,
z��f��M��<!��^��#܈m�K��t3G � �S z��T�8�&tS�7�����v7�W�<6�3Fz�����}��{�V/�Fڊ�b��ODFc�����z��A�kBv!V��4�rUqC�����@�$�4��/� ���klV�F>�ٛ-�K�@���J�{Q�|�4-@8�e�q��Q7g�$})�)`��Rb�=���rޛ��Z��|��I���v�څ?i4�+���U���ɤM|�~��vi�"+�j#mr��Fr�|ǁ^��҅Og'�����JQ��|���}����cx��,>�
�]q�p�תH9�`�sȢ�.�)K��N��٘dX��Q����յ}7�ێ�v�o�h�EqrZVbpd�|��� � �V���p��l��h�.5K=_N���
J�$0B�PJ�#�0[!��漊��$�J��㡜�q��k#[�oUv��XQm3*��v4�O�K�!\�Ǻ��ث<
`�ܳ� ?�'�������N���1�5/q�a����C�a�2��;?Z�D�4|�8�M����v���I2�wdȠ����r�}Mk{�u��Hh�[���F��FL�`���)ܯn(c� �\u�@(�t�ӎ��]J��9�{�ˆX�����A��?0�<kO*�+��cZ�k{�v��mt��I�����
w�[�1$�@V�_Z�~jm�=<E:Xܮ^"K�A�+]6�ݫ� 3��[�<�<Sk�ς#X� K���� , �`E^ע����fٮ2�c(<UG.Eek->I� ���D h1� �A�j�pf�ͭ���8ڱ&I�����1�����W����C��ʍ�)/�Խ�ߥƙ�A[��k4�<��x^uɅ�ؑ��k,CO^�P���B��v��S��+�8�w�f�~n��-�1�S���P-�+s��9�AE�GNi���b���i���P3Ҳ/�=�c<��T���tD*�Z}��}�� �I�R�ȼ�21�=KH�dH�S�89�j����?�G0�L�#ϭRb#�o��\!�v��g��(�S����I�ѣ����I�)X�RKI /�(V8ʅ#�w��rA��䯵�9�mdk�+]��yHB�������^���Vi�lE:\��j�h�uI�l%����g}��ù�&*��h�#�/j�;�� ���Z�*Wז��eiz�ڔ��
�1[��,�2@.�]�uP�7�'W�7�
��}K�o����Amw`�����-܈��$r����s��&�-E�Y�� 䕚�I?�~���%�t��ʗ��P4�Ry'�w
���zI�Ž8e���~�ѵ`u�h���� �K`^eK����EM�h�Z��ͣ��َ_֒v+V��p�
�~UFJ�K�#m�
��1��v�дV ��y�R+DL��T��0Ƞ,F�=�����aa!Urm�0^[�q�>@�j�OjX�6��`S?WZ�%��g�y��5KmgT��A�NfO(��Gt�?t�l����������ԒzY��,�K���6�W���7� <���)�����YV�,����j�{�O}s=�qspIm��m��!�t��oS+��=ڽ�7��� �G��;ơn.��Y������������:t硧Vm��{��P�.�qR}"]k�����G�>��
��$ q
�I����r�_�YIR� ��3�)&�kF"�J7��5��nj�ea��cYE$��.Qpf�}� Ɲ�!�� �OZW���r��M&����;@�l�(�+nğz�R7�:�6�7p:���ɥU�x�&gN�A�ilUȖ�Ojn���l����Kn��"����&>�r6����`����(ҳ$Q&7�*�'����ᧈ�����0�b#B��3ė�%��6R\\Mg:���@2B���y `�� cS��\�[+__3�Y�j���/��� O�;9|7?�'��.�T��d|+�,0��E+��0x݊�z�,ێ�oN���xz�$����*G��Oo�\B�tV�#G�9r � �ny�ISw�ճأ���v�yt��%ւ�c$��)����h�2A#�+�}s�[F��3��a��ך�����kSͦ�E�T�m�I�(��4��HFz��u R�S�Z��:�0�W^}[�~_?�'���<%�����]��Y�HM��/'�K��y=FxU�ا���-[����g^�4V���g�O}~���� M��D�ˁ)�1 !�
��c��u��Ԩ��h����p�Su��G���"��p�c�=dB����d@{z��OB�݀qI���� �)o�փ��\�l�f8��95�އE4JѸ_�kΤ\�P��u�e�i��}���@G� �#JW)"d#ץV.ۨ�:Љ���SZ�ua4��/<Kc�]_i.�
7H�FN��s�y�+��xL,�.7Q�� �N��+�vm?�g�?�q]x��5�m��oeh��m�� x� ��_.�&�����[%�y=�)W�I'�m/$�y���8�n���K!S�J����S������Kk�鵏^kZ-��6���agp�6��X�Hs"F3���!�|�]�eZ)Z�����e���k3\�1���"ѷm�2�_���)Z��zp��O����U���U՚Xǝs9US#���,Ǔ����0T֬孈�"WJ��>���������?h��ݔn�U�����X�
J������z�;�Q�WC���VFb�q�G�Nu��32��=���1z����u��b���K��r��w�}<���~��N��{YʺT�o��W�SN'�V�Z���������x��Y��G�'z=3�ٖ�K�S�_� ���q����|_��>� ��+ȳg�q���S��j�d�b�B��%%rXS-�R���т 6��՚E�ʊ�%r+;��(�#��n��Hn� ���+�\J����Vz�åM�;��W�={-���i�+l�kq����Y�wp�a��G��!M�J+�j*�� �T�ͦ���
���I:�"#�������u�R���SwO�ޭ��L$e�R�M��7�+4���<�\���o�@T�˒nO���z�� %��'U5Q�{�����n�W��H�8�D�`�� � $�$�8$�r��m�$ވ��C�[^�5���ZH�"���v��NA���!iF�Y����_��*���Ə%Ѹ����Z&�3�v1ϱ�9jA�X5{H�{�]x~��i:T�{��s�ˇ�;�V/1��^21�����V��o��@�X����A3f{e�0���#�q�zWtp�kWo�����W"���kۋ�˙.n�'/,�9g��%�<�I�k��8Ї$�0�RU��7�-�y�o���Q]~�K�����Z�֠M:�{ɤ�hcgi���ڹ$w��55�х)J���Vݗ���T��ܺX����ky�� ��Q�̧ƾB�c{�R��4��֧�Ҕ�yY��f2߀+2�cv�sF�g�vmhInv�R���V��֘���ۭ+�%F>�*M��n�Z� +t�#@�X]G���cR۠�Fl�>*G�]iv�n���\Gr奒(��)`1ןlZގ+A�Vi;m}}m�u���T����<�� ���kse,R�K
�a�As�J*}S0��)&���k��%����ؓ��C⫫�?����VO���?
������2����h{,\������z��=W���w~!������o�Óy�
���)�NC��F8�EғO��V�����<�kZҳN� �� �r/�_�>�J�F�m��y$���=9�ǿ�a�a�Q��n�z_���V�I�S]5��O����R�W���)
����k���{���MKZ��w ���T`�z�Ǘ9-�Ǚ�z��|�┹�j�7>�� ���_�j��,�!u� D9e�D��Hx�A�^F2�
x�NS���W�~��>�/ɳ^ b0���o��%��+�z�ǫ�jz\�����x$�Sl�T��8s���0�R�qm��}���-�����"����4�����g�-_ƚ�ӴбĘ{��?����I�"3L��a��][�WV� ˻1˲�م^Jz%�� ���� ��{�^��F���� K�� .9$�
x�'�|�7��Ӯﮑ[/E����>&���1������$p�2�#h�ɣ�(մ6,�t[
ա!Y��+l7u�����&j���N���ϵ��v�|~+�r����O�ڜ4@���iR�4-��ֲ��S���5[�`����W�'�~���fv%�F$=*[�֬�pEd���=�,]�t��=u h\J�s
��Q'�|1��3F���k[#g��3w9�f����Y��Tz}�����%r���y��a^Uo�7U֩Qɻmv��o�>�
��t4�b�������5���|i��Kva�HR<+ts��z�XL
ise��]^�6�Uq��̨sǣ����#��~��k_��F�aBW� ��`c~���Ia�8Օӳ�w��:�S�S��Fֺ�e�����B�x�Ú�nx5x2�$�"8��<�z��n�)Jij�u�B*�c%q���%�r�0�i'̮;[C۾
�U�ލ�i</�&�����Hc��dbZ<9 K|��;p3��p����T��O����q�aO���{�i��㻹�5{Ox�5�ޗkck&�{K[pe�9lawnH�p2@��ùI��w�V3��T!�vJ�[��}7��EOx2KX��+̻��m�;�n��=3� W�ٞ*�i�rw���.��?P�a0�eM�%��V���~-M�e�ހ�o�D� ��K�?�?��{�~��|%�k�|�N��]���� <�)b��P�/�V��>[���k�^����n�LI��ׁ?w����J��'��}mlV�W��״j��{��߽���T��֣ʴ�Mt��_k�մj:t=
|�Fӳ=�p��mA�b�mu�&�2�lW�p��R�g�|�P*�)D�A���q�b�}Wz�+�G]F�J�8 �+���I�^hNH�Դ�.8"���!8�U{"X�oU}C��b���(x����r;���iJ�����{��:MMn�0ռ}�+�Y��匹-��0? ���.˨+*w�m�f�x�1��Kz$�"���?Z�a��/��q�� �I�LFA�������Tu��\}5g.e�ᙛ���S�g�Բ���FP��rs�*��h�X���ƾu���4����>��Vj�zme�Al��Gm���ׯ�p�s�d�4�9��ml�:�T���Ռ�-/e��K/�?���M���� �+�ִ��X'�H�|��L'�X��֟��g]�8�֘�a�y���;��O�=���Yl��V�M5��x��N�������NV����s�9c*�^�e
랔��yUp�i>J�es�=��b�RԔ�φw�� 49��H��Gp��8I� Ny�=��`����� ������)�{�|K֮%��T�tig������q�8�^Ggy&
�W����w� o��c��,�4�QԜ��:%�_/�s���n��ؒ��r������i���Pnd�O�e�<c���Fe���r��VKO�q?��� a(�k��Ao�}��e\�@���x��{�AZŧyX��1�6�!���=�9 �e<��:0M;�s��o���t��0y�%U��m�~ͻX���ol�����I#nh�9B�ʜ�{�=��¬*8�������M�j��J*T��_-�� alu�Ws�6�4Z6Á�h��N̯-�;G����*"H�NԮRHe��f�����{V�,�SN�z�y�%���rki�ԗVW��VI�oc>b�8�RdJ(ln8�3�hc��J��?�KQeID��$ �=�����֍6�����y.�a��!�,g��-�H
��[��kا���w8eJQ��\��;�ЊƲ��E�m ��>�U�`Ӵ�w������'� 2I<