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/SF311/RP0034950.jpg',
'FileSize' => '804 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF311/',
'path' => 'Library/SF311/RP0034950',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF311/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF311/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF311/',
'file_name' => 'RP0034950.jpg',
'id' => 'RP0034950',
'sku' => 'RP0034950',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF311/RP0034950.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF311/RP0034950.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF311/RP0034950.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF311/RP0034950.jpg',
'categorycode' => '5RP',
'moreimages' => 'D0703032',
'headline' => 'Ulster Bank Trench Cup Final',
'headlineTruncated' => 'Ulster Bank Trench Cup Final',
'caption' => '3 March 2007; Stephen Farrell, St Pat's, in action against Mark Connihan, LJMU. Ulster Bank Trench Cup Final, St Patrick's, Drumcondra v Liverpool John Moores University, Queen's University, Belfast, Co. Antrim. Picture credit: John McIlwaine / SPORTSFILE',
'DateCreated' => 'Sat, 03 Mar 2007 00:00:00 +0000',
'ShortDate' => '03 Mar 2007',
'LongDate' => 'Saturday 3rd Mar 2007',
'db_DateCreated' => '200703030000',
'event_images_count' => (int) 11,
'event_images_count_text' => '11 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0703032/',
'w' => '3240',
'h' => '2434',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 3240,
'height' => (int) 2434,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '3 March 2007; Stephen Farrell, St Pat's, in action against Mark Connihan, LJMU. Ulster Bank Trench Cup Final, St Patrick's, Drumcondra v Liverpool John Moores University, Queen's University, Belfast, Co. Antrim. Picture credit: John McIlwaine / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/RP0034950/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/RP0034950/'>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%2FRP0034950&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Bank+Trench+Cup+Final" 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/RP0034950&t=Ulster+Bank+Trench+Cup+Final"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/RP0034950/" 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%2FRP0034950&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Bank+Trench+Cup+Final',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/RP0034950&t=Ulster+Bank+Trench+Cup+Final',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2FRP0034950&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Bank+Trench+Cup+Final" 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/RP0034950&t=Ulster+Bank+Trench+Cup+Final"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/RP0034950/" 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/SF311/RP0034950' 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) 1758122995.3916
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/SF311/RP0034950.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) 1758122995.3827,
'_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/RP0034950',
'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 ,, ��*�Exif MM * J R( �i Z x -� ' -� ' � �� � � �( � * H H ��� JFIF ,, �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �]�5X��b�K4lT�V�E������y���))]��F�:U+�5R��F
��S���$���1ɦ1�(a�%2D4� �SGژ�lqO�i�OBY^H�ȧ��X��n�jg�cC0GJ)62���f7Hh:m2�2�En�頮qT��\};d}+6k_h��q�(��`�Cڔ�dU8ݜ���9�/ְR��(�EJ�]���>��ŗ-4��R�bI��C` X�{g�}&��\K����w�,c'�q�C��f>Gk�G�(���%$P荞*YU��bhe�����U��Vop=X���(��YN[5.�ʒ��;�-�8��Mh�
�&�F�2��$��TKFR��[(�%q\>�o�ڰ�+#J1�9�Z#8��=�RzR�Ԗ�p�G�&IF�%��=��Z7����k�!�}n����M=�"2~�W-�8\}��w�6֮nu9�,�.-ⶖy�LC�e��t� ��+��gs��Vg���MN�Kh�(^BȊ�
8��+�3��*��U�ui1�q�j�Ex�n�-�K�+A �Ɉ��_0 �
�U4�
5FK�v�z��h�����
w�F��T�+HlD��q"M��F�S ��Tz�Cb���e�˒x�nZ��K�}�#?�H���\� �d��MCVs�~$��ɒԘ���y�=j[It��ż�HLm���
�X��s1�fj��;�Iḳ!n"�&��Χ#��j/��gs�Xot�
FKg;B��`��9�s�A���&լ�;�����X9�j�����Π��s���.�><�O�]H��V�Q�9�M[}��ط<���4|�jK|��44�J�54d���`<�ԋҡ�-�;�54�lխ���詐��� ר���.nu�2�
�p ����F�b�+3G�/����v�m��;��9�+{���8��Q��]x%-�.�C�N*'wX��"�;�5��x?�V^ռQ�\� l�d�H�A�Q`��8�yl�SI/�;������}�Z#;�9B�ϧ(�?��9۸t��%��]E(NU���U9X��5����Y�7`�9olz��
~j��Zn��+�,m�e��9��#�~�s��0@=G��)�,{��cż��]Egu���"���:+����,|k�L�r����Y��y��e�h�S���52�y&V�e�#˼E�ϢN��J��"(��,�7`Nzz�������y]�S�W e���d`b�D�y�Y�+)tN;Ԭ�o-cM�n5j�#>j)h&�z;vc�W��[AM$y1s��J��>����׆�3�ߌw�G|�K��ʌTc'ҼP�*��^%ZHr���𥅵��k��.�n*�����9�Q�����"���y�=n�ּ��o�/�*@F��p{�W�V6ww>!��'�'�H�̭��}�y#<g�������W��»�]sKԼU?���L�4q�
�,!�B�܆�
vz���qⴷ�����(�k�eGa��d����d�rC���8��ћ� ���r�z�:��.�Y�l^;DYd �$`����20ˬx���ȶ��XA�8B�p��=�<7���8�c�w�&��i�z����zj�g�(���o'���ֱ>-�¾;�Km{M�L�7"Dm��P��m�^�c��"2M]Ʒ��^)��=f�b�� ���qf8�p 9��Ŀ���_xz{��km�J��pe2;q����OQ�mh�[�\ 9�{��E(�*]٤�rS�%jX��EX�|ک���R�O�~��ŷi���Z�7�L� ����h�'�mt{{ti�hU�;w&���:�T�k����x�V�13D�7ˏj� �.մ3sueolX����Sq�s�
th7u.�d�u��s\�U�Xv�|-�χ��w�5B��8#�v����ֽ<���V5&q�����o5���KԆ;[i|�1�T ����|�c|%Ҽc�4��u���6Ou�h�ps�0l@��~��:�P�U����w�T��S�V�����U���H�[���$(�HP77
}+�|C�=;t6ZE,K*���!�$rr�~����k��H�N�_�u=�����[�3̒9|�% b����y�c^V�'������t�����}��R��<
��אq]��+�9iS�����/�<O%�O��������
�H
A���������u�u6aA(�K����mB���V|զ���ﵙ�t+�<9,ͧ_F�u��[9Q���2v���n�����Ɩڍ孴76�� ��w���,�r1�=�i$�!d��*'\
��5���F�$��5)#mC�
���u2g@f 2pM��?�k�xF��G��f ��2*�mJ;���6�2�uȮ�+����RQ]
^-�6�� O�k7oc
����#vE��5�_��]x��R뚊xG�kj$,����s��1��W�����4��WC���X��ie`����3v/V��8�Es> ��t�^���]8�v�G��vu$1ۏ�dc=:�]Jw\�q���WC~kShOcq�K($�e�r�f�����o�jɨ��F����a
�t�Ң������U9F2u�V�˩)9AE=���h� b�D�:%����+D�#�� h����F�8$גi��_�W�v�zZ\y��p=���^N/��Z������v�'�7~!|CԼU)#*���(��#��Xr�ޝ���҄�M����~r�<�Y�>���?��:+�Ԕ�O{"�>�l�/M��+�UR��@d�
��'�rp>��%ߎ���[_M}�4�m��v�B8�pO��{�J�
��嚊��u�|k�5�
�f�c�,�/�4J��e�t�� �+�~,I��=Ua�k��bH�J�fp��82EmZ<��3�Qŧ�y��n5k�﹣�i2jS�,�D���;mTE嘞�>*�c�,�i�6��b\3���2�*= �X�m�.���U��[S�m� �#v�c(d<�n�3�U�du�N�L�i'��s�sO���3����r��q����C2������^-�J�c��~ζ��F��,��F������mJ.S��x�I�h��y�!f5S��z��qmtQ�;I��h�sȠ���r[� g�
?
�ӍF}9n��|�Q� e��q���T����� ��l��^�Q�wf���2�}Q4m�+��D�oT~ O1�Gv�q��^Y���E$vַw��q `��ʃ������K�Ei����SqRm�hj�P[kw�}�ˎ�Qc�X&�g�:f��[Q-�[�]�uE_V=V�uŘ��R}���`̜�}Cu�kSI��Q�tWզ3�u�[�2�+FϷ?/͞q��^k����]��9�kO�M��'x̶Ӽ$���X�F=qZv+��T�-|�(-+�@?��\3���9(��f�Kֵ-#BAmi��_'n�j���wu���/
��?&�u�o)m��ȹW
\nQZ�����S��|A�j7\��$�:�� �8�3��%���$����#��S��ŋ��M"��
�[�RF~n�9�Nμܣ��Tf�_|cv�<)��R|�
�n
y�=+��~�
��k��{���ۮ#I
���`3���NǭJ������h�sgs��_���9����4�����>հ���m�+/e������O^[�_O�Q(�'`s�\��.`����[�̠I%����t� ;UU<֩YY�7vK�G)LEX���Ҋ`z�y�sh��70�Gt�O1���m�/V�ק��bM �Z�Ɇ���P��H c��ٷ%��p�9Q�ы��ƣ�k���j� ��D�s?�̲�������Mo��?�4�¶֟c�Lv�ȶl�1��m��q��s�B�i�W������� �c��:���pg� no!ŹZ0�o̭��s���}+�#�ͭ��K�K�kVTM�����'H�����������W�v�R�8idm���ܓ���M���P�Uq�ʘ�ٕ�L)��z�7̒:�c~�Z��Mi����X��M�z(r�0s��YR���{>W�m�;g�Iip�*9<t�66������x[��]W�1H'�.%-�3�)\�_�985WM�,�����ڲ�d���H�k��
���+B���.��
?ȯwҼe���ZF�ie�ٴ^Y���IJ~
�Uќ]�ox��� &�>�q2O=ÌDT��7u�Ny����M;R��o��Y��g��Bv)�=K~]���-���J5$��Z�v��ll��o}��X� O��1���/�����j��V����E����t����HP 9'��E�ks��R�c�@ď���x �H
��HY���
b_O����BnA�y%Ŵe�R�����쾗$d��VU�� �U����%��r\_�ݙFcO� ��F��Ǧ���-���I�/P��J��0���9һ���{���Ɛ�%�� ���I3����*ř��e��5��~���f��A���m���5Sz4�|����zWey~���~d��F�{[�)��nE̻rY�ǯ$t�� �mg���$Kk��QJ�mܜA�[��:�5�k*M����$\�/����y���m�i6�n�h��>P�Ue�@ֽ�?��
*3F��E���K2 $����K`*���, �A>DtF�w<�����cn�sA�4�c�F�a�p+�,���7����?���Ӗ�5�t�z�'�g� �RV� 5�fi�R��,3���c�Y��/ �t���`�5�<3c� n?S�i
c���e�z;�o��!��?%�傪d �s��u��#�YbY
��IB�Pz��g�W�7�'�QWӥX�q�r���<NX�H�(*kپ| ��i�����Ifd����{���rOD1� ���=k^�[����7��])�2�iwg�˃�ٹO�$�W��d�u��h�]дٴ��^K��:�
����q�۞�I����z�Op=�ĺ<Z��uqp�\pE$��|ʄ��)��{�����8,"�8<ץ��Q��8��%���X�'��;ȥAkk���N�
�L`��8'wu�1�ע�������_�C���y,}9=k�/��3dU�2B���ڻx7�SE���$� I#C� �?*��;��]?H�,.��O2��1�nIv�s܆Y]p3�m�V�9�wZF*0H����CZ״�@46qi��-������YI*>����%����
l��IQ�d�^�)V�/d�QZ�о�� F�֑&��u[�%���m�B,L�r�\q���S[���?����<)�4�E��Cm�2A �$��s��5�:1~�ݗ����f齒<���֮����iP}��..����Bq�s�Z��Χ4�k�q���Ix��O#�
Q���E�F5!�l�;���xA�+{{]o��4��~
ǠV`�~�q�Y�����3xn(e��̕�n~T_j�����j���BZX�?��7���.��OH�6���.(�����^er��){O5``VC�\�H$c89�8�j6�5�� �qR�~u���f5<r
��hhI��J���\��|<�!�+䮗l�T�c'�NO�R�tZ��N���e�@��u�?5{Hty� I��rX��'g�,��ʟtҊ�}g��Fմ�mn���ŷ-�LB�a�g�3_,���;��^�/�0g2ʾK�l��Q[t���YS��{��5�%0m��S����r�ߎO���oE�c�(�Y�7�q���>�:��X����,$��r��u�`�w��A�!|a�G�]��v_���t�O�=#S|�������b}:�?&�� r�����/j����p|�:�[M�\Iipom�Xd��Lgp�^2����
Öp#�l[�B���}�ס�u�g̮e�Ʋ�X�A,[����~]:~U�-����ESZi�U�
�v��w�!�=2s����g�a��z;+�ax�M>m>}R�Q�K�o�N��ceݕM�p ?�S����٤�a��ѕ�n\��)8Î����+5{z_��a�Iɴ�d� '�]�� �g;��O ��$�Wai��j�G�����Dq<{� �� ~�+����<5G�|i�k�]G�Yh6�Kg��^\!fo)�
������|�|��8=�s���i�r�J1R4c+BQ�Um�
!�#�ֽo�w�o�G�X�mQehm�J�8^�H�=�g$���E��l�B�-��Fe�/u�(�G��ۆ�ق�yl��L/Ԇ��\?v���G��Z��<Y2J�6ȠB����,lB�!Y�=���N�"Q�^k��2\i���sб����?%)S�>��{�\N>���X�V�ݯ��� �`���������ەY��a����pG8��?�Xé�v�7
O*D��UR�����Sw �WC���J�_kI�[�������:����r�#ě�ʥ��VB5�3�p�y8�<{WL�=.�s���}�6�sk�yZ̖�yo"�h��\����>nA\x���6��V�or��Jb��B�36pI����F:Gʜt3�\���^�<��m�*��"d
�{��ZO�5�e���ׯ��n��p��U$� �c���J����W4��̑���"�M�|G�a�L�ˏ�U�
d�G�
�|�u
I��҆�5�:Ǹ�mc����?푭�N5#.��DՋ�q}����[1�!�G4P�3��0�{`p}?��j��[�_L���B��D��`V`�.� ��=�����G��x�Z�f/y���&��W�9� nbI_@6��_��0�7?gP���X�i�B����:AA^V)p)��1���f��H������ t�a!e�R õ+�ň��Q�ZIъ�.VU��)�V=��~��Pj�m���,h�P:�#�k"� L����Y�1���q|Y�Y|���qƣ�yR�S��>���NMn��l��.�5mwE}R�In%���4i$��$�@a��� A�xgῇ��#��:����E�ɞ�Ir8�z�*{H)E�Y[�>g�M����l K� �ц�o0��zU�ස�m����>!��`K�ߞ��bO�u�ԟC#�5��F��̖�P䍱
����&%\��w�f��C\�f�<�������t��I1>K`�% �<��.ѿk��v�ߡ��v6�e�[j�3X� �̊˷ԕ� ����<��o�p�A$�' �z��mu%tF�s[����寉�!�D�)C��?�Ҩ���=P��|^��$q�dH� ���۰
�a>�͇�4��Κ��M���o��B�-4oX���CYu+�o��ȍ�7���`s^=�|M�5�f��&u�ƑB��p��33�5��r���|<�l�h�C$0�4[ʅ��z�,68��X�֏�X��KM6�BLaRHr&�����,c兇�W���n����v0My�W=VJ�7+& p٤�N��,���w���ރ��8�)L�s�a��%�X�A�]����'�/��=�UfO2*Ǡ^�HDx"�,�toG��m�ƅu5�ݴ>f�X�Ƕ:����^��ׯo� fPrp$v�Z��� � S:�o��)�kZ��h��,��㔌�a�� M8�uo����E�.&*��S�ӥv}N�R�h�j��Y�=ȵ߉�^���>�^��ڍ��F�dD�$u��ҹox�H�|[7��{�=#J�X���$Dr������VЅ�<5��|K�6���Xۺ�y�|r*����3�d� d�s��/x7��!hl�Ki�H�W�"4��XnI�6�$GDxxڜU6����)��L�=ON�G�*����<Ȯ�Tp:���s��h�5>t3�S��z�o���GcN��]�S��6<'�������9�X�A�Yؐ�+�ώ>]������&�����С#�,A��`�p ;F;מ�1U]7՝1��T��I�S��Xں4l� x���Cc��^�6ywIS�2+ּB�r��:�ޣ,yH��R�W9��A���֔l��Յ�Xh��2�x��5�A�� �S<