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/173419.jpg',
'FileSize' => '610 KB',
'is_book' => false,
'keywords' => 'Football, Hurling,',
'real_path' => '/media/images/IMAGES DONE/Library/SF189/',
'path' => 'Library/SF189/173419',
'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' => '173419.jpg',
'id' => '173419',
'sku' => '173419',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173419.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173419.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/173419.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173419.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0504068',
'headline' => '2005 GAA Congress Saturday',
'headlineTruncated' => '2005 GAA Congress Saturday',
'caption' => '16 April 2005; Delegates 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' => '1704',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2464,
'height' => (int) 1704,
'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; Delegates at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/173419/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/173419/'>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%2F173419&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/173419&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173419/" 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%2F173419&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/173419&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%2F173419&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/173419&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173419/" 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/173419' 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) 1758162148.4204
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/173419.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) 1758162148.3879,
'_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/173419',
'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����������������������������������������������������������������������� ? ��Rx��!ekkY/!�O�����z�x�{O�^����N��˼nb�"���2yjFsǷ-JQ挶�����9����|y�x��6k�]�l�����t�ᏻ��#�⺟�χ��+Y-%����{G��H� �s�G �v�h���-��s��c�+�OX��D�zF�
�8��v�+� ���n�GC�����!6�6�4�Ck�U�Z��m}%�\�J�cl�@�?�F0qU*��rJ�0Q�I$��B��? �i ��䩒�Ĺ�5ݓ��`8�{�?�|5g��:�������x��ݮ Ge ��ۀIJ �=8(����,l��H��~��5�k7���ZA�-��*+��0��g��ƣ� ���o<�/oq�|�t�= ���㗾���В���ǝ�,�De�ǚ�����=@�x���WV~Wڡh���u#����%���z���.��Z憚�Ԓ6�y�*3�1����<e�i�G�5mM�3ؤ�!v<��` �s\�|MJ�g�%���j�!%�ɱ�x�V+���X HPϷ���?ֽ������"/떗RH���M���o#�|��kNT�R�抽�|K��[^�:Ư�5��l�"�;(�X�CJ"���rL�K`�~�k��&���X� �m�� |ē��O�m9Y$�� 2*�t��7 �f�;x��� ��v�����R�Q�k�\��F�[�R1h�چ�C�Ó�\u�:�=
N*K��YF���t� <Cr����O�FŸ�q�Ā.�-�N����4�/x�� V��P���x�*�S�D#P�c� �'�z1�\S�|G+�C�3��si{�w��G��E[K+K���+��<�P�B<��;�X^��N� �]&Hb�3$��UdV��g��Z�R�Z;%�X�jIJw�SۼY{�
[�ֵ{eus5�<R�x�K����1 b3������YBQ�������>u���S�^r�-��动%���;�zWUi���x*o�2?$܉$v�hE�a}��w pN:�k\�=z��$n����ďW�����c6��Z4a��*���9����[>��l���#iJ�7�Q&-�!HW+�*7g�x{�G�g�-��\"ݷE����G$��e�m���[��(n�01�X���W�i���}s֤����G Tb�ʢ�𤁜��+lUh9�ksL-IJ1�؞O�����Դ�U}>KM>�|�e���� {��3����_xV�L�Y4�Ԙ,��[�A ����u�+�qpOT�Z�T�9��i���V�[˛�^Ry%W�Q�?*�M���&��=Cɼ����Cc!rX�Kt��Xԓ�h�� �ƴ�gBw�g��7��>�i=�ѻF��n�=2zf�j���{��Miq�fHY%Ic:�2�x�q�8�]R����8c{z��Ëo�?�ߵդ��#G��2,d��!c>��۽y�ڭ�ޡq��m�g��
�A�0r8\1\����ױ�^��r��e; bUWc�q�zҥ��Z�=q�Z;��5���s%6�y<� J���g�5K���8ಈ4��`����ڵ���*��j.i=���A��+c� ^�Ƞ��p�c�$�ںߊ~��:G�%��ڧ�oXJ��Q�ҿ+�����ⴼ�Һn��fp�˙��O�|��2i��w�|�F$����!+���s����<�=1KƐ�i�ڭ����w��� �([��[���b=��y:nt��/� �G\���j�ͻ�Ф\F���c|灒0'� �q����SX>��?�������v1�Ƣ�Z47n�C�[�:ìܼ�l�M�й Fd �� }(�iQ���7��
�)t;�G▟�j���o
�kK���b��3��� sا֯|2�4�I�k~+�T�[�kx��@��T`�`z`c�&��M�K]�E�i{Y�7��5��j>���Il�\%��0%�D�wc�+��O�Լ;�H���V���Z�y�EN�4y`V@Cd#�/
�E8�R�^�*I֜co#������
� �-�Y#��o��.�Q��Z���I�s���ׇ���#3E Y�Wb��$d���I�k�MT���*rQit4�JM%,��# L~Y �$�+�ſJ����Zi���k{�ORX���X$�X�R^IVC�/υ��k��5�j��2����~�5-WS�M>L�۰x���X!�9@H�Zֺ������_i��m���Fۼϗ���� *IR9��S�d��
2�f�e]���[�'��@����'�0��:A���x�]c�Z���-��˺�M�����l��V���o��h^�i�q^&���"~���
��ӏ�
,�AL����f鴎��y�P<��O����2G>�
k���S��m�aV����X�s
ҫ#f܄����~�|)�
b�K�ڵ���`��I��¤��q�\��Κ����ƢQ�Ǚ�LЭ|;��:��� ږm��n@'�+���z�m 7)��k��7tpԏ%U�;��T��M�^M (U�9
�z� y���!���q��6���<�*>lry<��ѓ^�щk�5o���m%�����mȊ�
�*��e�b�@'��]'�SGo�7Qj\
cH�X,�R�Q]��r�$���j��-o�����������b�4��wn�B}:T�&����(�n#C*�!d��P��8hr8�\���mQ�H��:/�� �[�m�M�d���O�6�28+��e �'�zQ\����h]5��r�7 o�\۵����3�nIQ @''�z�_�7�Ƹɧh�~Х� �`YIb@�a��<TTi;�vQ��Y5�;���
n�報��#b�4C?u�U�S�c�j�<���WM�O�dҦs5���$^I�����v���N0�����^��~��v�V�'�R�NT�$\# �\g�ϧ��R֠�kk��v*�g*���v�J��J)��t�*P��#��<�%o�K������B��lT,Km�py$� �rq^_�Hj^մM�-�ݷ�}DJ�èm�8'a㑴Ӟ�Ԏ�M���xO�A��ne�% 3��s y���ڡʞ��8�G^�C�ŭޠ��3]i��I2X ���(%"�<�(�沠�+ɳ������F� ���#����7�C�Z}����M+|b�bs����� ���r��+G���rЪ�x.���z'�����ח^�.�5k;i� ne����H�A�pWn2��ˋf�o;W���r�s�r���NN;F+�^X�7%�м]Ғ�٘�+�c�RI0�i$�1��ں� k)o�au;�KnΌ��ܜ��[�i{Jm"0�y*&އ3�]�k�\ݍ:I��"o+��:`�I��aY�j�y�F���/dJnU9�sQ�m���b������b���:���|8ֵ��������Mfmm��8��0'�J�FG���C����இqv�d��y#�#��$�aUݓ��m)6��8��m����;��|9�W�i�����ח�d��Iv�}>B���S��r���i�<�&�ӑbk�ϓd��l6�2��09�ջI�=OJt�̚#��O��Oy}�ө]���4�OrA*�@��t=:QS<Z��o5B��6<��Di�x�m�����0��?��]�ێI����i_�j&&��@A
��q�DNs�V���� �ү�ޟ�=���sY��oY��Rn~O�}��>��QԼ"�,��`��<l�+1UˍC�e9���-PSp�o���ǒn[���� k�����}��22Kǃ����<?ZǪ���]�f��'%�(��m�@�O'�* �n�|����|=G�M,v#��o�ڵ��[�o����/�<yd�����s_&��]}OQ�GO&��(B�g�<n9v�Tbcy�Ъ5R���[�u���eB!5��y9 ����8���c����\�O"\$r`ɵF�nA�@ aG�5�BKڿ3��� ��Ĉ�Ol� B�� &��� �tm
��+��',�p���������/��cJ\�RF� ��5�D�
om�� {u�29��)8��μ�\����ծmm���k��� 8$==��s�b�&�����1�����yj���`{�9�z����E�K�I�O'R�i#~�Ɛ�$H�f�Ǡ�n=�⢔�etqS����sg�ӧ2ɭ闆�K���t�@ �q�g� �^g�
���%��"� �]����H�H�>�{ן��GVz�X�*Ҍ!
,�cJ@�<ax�T��"cz�##=9��D��6='�~6���I��n�#Vs��1^b��̀Fj���h�4���GB�*�LN�;�*�-Ȏ Y��G�����r�n(�|O��N__����^j����`�b�)o�z��9��[����m̏*��K`X���'��s\���V�N�~z��a��7��+E�n�˓�o�"q2�6��1�Ew�҇��������}���ơ֤���G� ���V��ӃT���
Q�Ҩ��ok�O�}ae��%�W�Ǝ�5�����m��衻pk��C�g�5
V+m.�X��7�g2�@����v�F2ry.5y�R�|�Z�����3���`�l�My��ww����-�����8d"T!_�v�cO�=�4Zx��w�:i�hM�V+"]� ���NO-�v�9�MLR��h�`�"�t���[����Ÿ�ƕ%���-�#O$��Y��I>�Z?��[���c
̑�6SpʤH~`U�6A�q�k͌�S���JT,���<����s�Z���ũ�H�Ϻ(g�|�&�yu�;Ag�ꍨ�/�5�dIq�!1�S��]�<�T�I� ���ML��%���]�%�O�� r�do���S]��;�Ʒ�,m��ڄ�&6*��%A�wVr�MG�CJ��4���ۛ�� ��Xc��v*��ܩ��E������\/�A����|/��Z@��/$<`���C��� �x����%l���5��烼�]9M�������{aI�����?&@��xο�`�k��}�^�~�}��"O%�(�{b@�6�H�@�A��8��4)��Amo�eN��T�$���K���#�γ��@N襷��h\{�f�ϱ��kƯt�B��d��͌s�K�#�+�.;��5�S���K���Ц�Ԇh�F)����ް������TTP�r� �Ͻ�S�gO�T;���1ʬ
?P}9���k$m�p!c��l`j���eʙ�� !4o�y�+
�9#|&�~���x_x��;\��4l�}��6Ny�kv�Y��sC{d�au5�,R��]c
I!�6�\{V"��{�өj۷���b���N�����k��Y�~y��G|sI�|b��?��5:��e��/`�J�$Ȑ���<O�n�b�oS�S���O�|G��i2ūiz4�rJ��l�J��n��9�# K�2}M�8.��/_v�,� q�v2 ����rQٞ�Xg�F�]����'W��u�,�9�th����gbܟ¾��t��Z,Xf
�"��
ۙ�1�=�*���d�1�F�[�;�q��_��z��d�$p���,�� x#$��)�t{MJXo�S�Ḅ��卷�R�7˸����(�Mz������[Y��B ⸿�� �j��*�3���:��`����ivڞ��Ho�e��R��qd1� ��A'�\�v����AQUn־G����^�1��>��
Z�b�[t�$R�p������]��\�R8g�.%0�1��1���z��)J��k���}b\� ��6U��:�h���pXl�N �:;� Z�߄3'���4��ۋ9扞�k�Nҽ0y'u�N����rn&u����=Li��~�mt�Y����ȞNbq�
���M��l�c�Oڻ#��#o�q�23��%�ts��o� #��S&֩~_�|��{�'Ś���tvWr�n�9�9��F��\Y�q�A�O-(l� ��A�pz
�U����'ZNz�*�\�1Fe���i�(sNI�T�[�BR�ݒm1������ �R���b�laԵ�>��C��9�Km܀e�b@#/���߳^Am��E�(�@ F�>��fR��.���4������8��t߈���B�4�3KjP�t��I+�j+�R���"�B�QOD�f�b�ya(��.:!��~=����q�\�r���[�q#r��C0�A˒?�UJ<����T�W*ر{�ͧCap�]XYGt����y�@�61Ӷ+[���h���K�"h�1�
�T� ��湱�T�Fvaa��ݞu�#��{�jz<�b�9#�~�)YNAS�9��i�<$w�j�%�<˶�z���m6����n�p�F�A-���GL�;�4�q�4��jF�5�r�����W#wr@�=zW�Q��
�=��]_s���^�6���S��zTw0���s������-� ��k���m[C��=V[M*��9�K�]lQ���� d#�:c>nZ]N9RiJ�����S�+Q�W�f��Ky���᥍� �#`d��Rzd
�>xD���j�lڲ��љ ����Hr�p��9 �#�����v}b/����?{�'x��Pi4�{�_gfI�X$��a�G&6�8?/ �-?�a�� do�3r�Vӟo��ֽN~m;�NJq�١7�?x�L�M���og��5���z�B[i *c%I��:�=Ez�������]�.4{_.=��D�$+�b��d�æN�``�NT%i�JP�H�,�զ�ki��+�>�n�]٤a�2��~���ұ~
�I<U�^�q�Of��4v�p�$R�\0�(9<��<�.� �*o��J��+����
-3�ں���K�6����&�F7{��_xO_��>(�U煭�/[N�K�X�F(���
��L��9�b/�2w���� ��5 �t�+[o^���z��;+�����yF����h�I0V�)Q�2 8 ��P���s�N���[Y��>!�x-��~��L�#�aU,���8�a.k_TO<-~M��͜�M�wZ: ䷐J|�K��ON��k�<#�Zkz�����XZ�'��W��\��7 �W:^�Gn]YE��g�'�k�?�m�kY�q��Ք�B�+��S��{�G�R�Z쎪1i����h�-��}�tv��/$���WfV�p1"c�X���� �{�\K�[�n8��Qc-��w�TbB��c9<