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/SF295/230347.jpg',
'FileSize' => '307 KB',
'is_book' => false,
'keywords' => 'Football',
'real_path' => '/media/images/IMAGES DONE/Library/SF295/',
'path' => 'Library/SF295/230347',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF295/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/',
'file_name' => '230347.jpg',
'id' => '230347',
'sku' => '230347',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230347.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230347.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF295/230347.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF295/230347.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0612012',
'headline' => 'Ballinderry v Crossmaglen Rangers - AIB Ulster Club Senior Football Championship Final',
'headlineTruncated' => 'Ballinderry v Crossmaglen Rangers - AIB Ulster Club Senior Football ',
'caption' => '3 December 2006; A dejected Sean Donnelly, Ballinderry, at the final whistle. AIB Ulster Club Senior Football Championship Final, Ballinderry v Crossmaglen Rangers, Casement Park, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Sun, 03 Dec 2006 00:00:00 +0000',
'ShortDate' => '03 Dec 2006',
'LongDate' => 'Sunday 3rd Dec 2006',
'db_DateCreated' => '200612030000',
'event_images_count' => (int) 37,
'event_images_count_text' => '37 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0612012/',
'w' => '1970',
'h' => '1573',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1970,
'height' => (int) 1573,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '3 December 2006; A dejected Sean Donnelly, Ballinderry, at the final whistle. AIB Ulster Club Senior Football Championship Final, Ballinderry v Crossmaglen Rangers, Casement Park, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/230347/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/230347/'>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%2F230347&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+" 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/230347&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/230347/" 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%2F230347&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/230347&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F230347&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+" 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/230347&t=Ballinderry+v+Crossmaglen+Rangers+-+AIB+Ulster+Club+Senior+Football+"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/230347/" 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/SF295/230347' 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) 5
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) 1758153673.3884
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/SF295/230347.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) 1758153673.3744,
'_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/230347',
'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 �
�� '
�� ' � � �� % � �( � "� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��;�u�U��%�#���f��-cPp;�]�� lR� ���g�i'��ߌ�z��4��7�ܤ
�kF�n|�&�b�*pE47=뀁��N�q�[�fކNϻ�T:��
i�&��X9�O�O���oʤ�6��oʓO�oʘ�$��?J�$q*�~��A�Y�į;�cΉJ���V&1�+=ӑ'��o�,���A����!I��z���0�C��Q�$6����k;[Ԯ�\�4�NN��2�ѯ/%$�e�q6ۈ�2Gq֬i���(ʓZ�N5,cWާr��Q�S�=h���g<e��Ë�a�!�`}hx��KkAs�6ÌWe
�Oc���;f�o��Mv�� Eh������
����&��)cT��p�G��4����k�J̖U�%4�H�����$B�F)����� g���5'���t;Z,S�8���<N�+}�jD�6�
z
+�P]<Q'����\��d�<���|��Tl�:1�t�>�4 }#n�:Uo̞d0 �L�r���ƾiε9KW�F1T|?�C�8�j諹I
��TbA�jV�2~ၩtF�
[��a6�Yw�2�Aڊ�g*����Aymb�~gU��ѣN���PJ�g5�&j�F}χt�h�@b
�Y���O䉔����P�i�K"^*���y�����ԇ����ޅ�GM�.1�7Q�L��
:�ʞ�"��^��y��K�)(1���{�����2� *Z���4"�I"تI�
�v�$(�9���i�Q�G�
�PL��t�N[ƖX� ���x���
���4Z��&&I���
=��on
p�����Zab�ZdW��Vn��y��k�ҧ������~�o��t
Nx��3���h�(����9ϥwz��oJ� ���z9l!&���M��� �:���*�@j���E���.Fl��5ь�8Ӽ I�N��3j:��L���~�@�-�?J�=��l�� �_Q=g�H|-�v�Qa�~� ��µ�;�Y/�A�u[mMC��p�';TFY�p2�\q}�7;^�;�
z��>xr$�V����pZ�CRx�� �("\�����K⎁�}�Γ6���U xQd�w� p��#��ǃ��c���J2��O{�2��~���Љ>S�v�DH�A�"�c��W�7�'�?J�8�J7��e^�b�WPW�#�J��@�)ٌ��φ� �q�O�k�t�i�F��+7�+�S����Nv�cJ�C���S���0�Ɓs=�L
�ں9Rf�^�ͭ���q�"��Q�}�M:�EҠ7k�5���xDc�=)
D� ���3~TPJL�yeΣ��V�O�K²��Kj7A���܄��<��M��rYoҽ���#JG���r3ҝZ�P`�)�۪����I��U@��)���KŖ9E�Җ)b�e�8L��
��$� :պ��\���<5�j��ck�Mȡ��HaT�%�`O^8���Ƕ�������D�F�s@�?t�3(gi�� t��.�t�Zt��R�>��C���՞���A?�,�/�Wh��NǻkAiS�@"�/�w��-.-�(�A=ؕlu^8�B�P�y�5���M�1�?��Ս�J�U�m�w6<m�xj��M�}j���Xm�l�X㐤����V�G��>��d���EM[{z����_�P-��()�A@I�5�&f>�S,�W�ҷ�S[F�J�h�mJ��m������{f�x�V��p9�sj:��g)�Z�k+��a��p�+�Pصͨ�7�Ȫrԕ�����]Gt.7�(y�W�ξ��yR Yx�+����55)^=�qE68�?�v�u2A �b�3Z��M��\����I8�CL=��9mk�pM�;� �R:w�k��Ck�mF��I�9�i��m���Ac4����ag+#�j歟��{+T/4����ܞù>�� ��{P!{�\MvG�ު��_n���p��>foF��:r��A�Tm R@�Oj�S:/�s�"�T�����K��F`0e�HU��8�
����V�o/�%��ɩ��v[�6�lev�G ����F��˛��j5N��x+���k���e���*���%BFz�FFq�^��M&�˃��J���d֥���S���u\�H���W��w�5h�#�+�ǔ��fFV�*W��V1�ʈޕ�etta��u:W��C. 4�is�l��h�����-nt�u�9��l�
&�``����-f�OH3�մ�ӵY�� C�����{��'�F+Zn�3��jxR]OK�Y[c$sEj�fh�^�]L��W�vTJdV�qSV.��"}G�T��5��tȯ�1��4�$՟B��6���E��SCag;ER�F* ���Q� 0�"���x'�R�[�_e���|M
����h,��F0�ڿ3�%�xc��a��[[�%���nڿ��u_��<ӭ-�˯���.<�4R� ���� �v�� �/�>"��)� ?�S�*}��w�T�B3�.e��2�ZS�RV%��- �����QK�~���]c^���;�K�.a��I �2�u��6�C<���ߍ.�1�G38�<�� 8�[!��}k���f��g!�n�>�W��D�ꎉ^T"�A.��Y�yU�9t�a��[��3��S�j�+�lm �\!� �pjd�5��iS��� ���-���Y�V4���5����*������[X�#$��8�N��&��G�2�5�
�p�d�+h;\��{e��9���ȼ1��w����O�����Q��]I�pє5�I�\�/!�8��O\ MùٟZ�TNM����
]�8�P�q�
��?Z���C��� hi�*������rt^?�*���$� �5xjx��ɅԪ��4�w=X��(��c>�_�_��x�?G�ߊ��|K��|ccmj�"o����H-��c����p{/�t�7����G���Ugf.�g��q�1]8�k
Ft��vM:�s�j�7qٱYȼ��?�!�+�����^;��@%���TmX��`R�pOs^;�#���/kpXxz��%j��V"O3͆@v�
���
*��]�]a�9��;vG�wn�^4r��,G=��|E:t`����_��j�I��� �'��:o�&�����`�#d'�
�.u�&En��O����������J�e�c0p���9]CU7�L�M�K�$(�U�w�)j��j)?'�k���r��*�zf�[D���v� n����)j�Fk�;TC��>#43�$N�%��������7��=���:�֙��+�m�V:�Qg�(�I|)~��N��Kv���
�4�֯�Y<�p� �>XP��.�־χ��g�+o�9q
�w� 2���=A��5}�=4��ex"��7,������O<�Y�_�]��u;���k|J�`�U�7����k�Q��B���C�
�+cO\xZ.P4�L��|� u����ч�s�u!�����JPq�:-s3MѮ��/��(0mZ�,C!�jpH<��g�
k��B��\Iwu#&�O�#��O�v�\X�k�EF�H"�4Ơp(X��¸J"(8�Sڋ�o����>_��;�a�g8��y4��>{SJ�S�<�j(��nzU�'��a��N�1-��iؼϒj�7�[��5J�Rr�c��4�~k&��s��;�<[5�ˋ�2��wDx��]��φ�.�����:��i�Q��(��\�˜�F� �M]ҧuܙÙX�� ��"կ��>-7ְ
��W�+'�CH�>�����ceg�v�{h�(�ϔ�0= �{�R�h�Z(Ε7��#�%���{s��R
��V��@I�<�w���Y�+��=����)��8���S��
�_w�#7k�r(R����4��0#i@����@�x�y��5V�iM0�E;i��S�\A��
�3�(Pwq��$�֝�i�~
K�Iҷ<� z��}w���A��cҽܯ�O����2�nu�h�o� iA-��ʛ�{�zb,ZhK�6��i �3�&Z_��v�u�(��4߲����b���I&*0DfL� �*��yٔ�����6<{SO�|��F88�Z��� �j` �N�#m� ^�J��B�sQ�c"�
-�@rj�\h����A�M<5@V��z��R�
$&�_�)��-Q4iZ�����rȫՐ0��3^��o[W��A��4���XIh�H����S��X�^�WQ$��/��h~7𖿢�q{u�4�]�{��"�w�r���9�E���Q�m�ft?�%]��{ �+�?H����`�m��B[x̏�Hv��J,���;My��'�g���h#V�3�O�J�"<
H }�pzq�sf4��v�_A)���wdSKW�74��cMj^��֚>`�@5KA�@��\SB3�f�:P!\�w�\t�i� j?o|�rMH���Dَ*XUM��<_�iVu�s��=�g�6ި�
p����8�i5��3��ZuE{%��؉� r��[�&��>!�"��ܴ{�L�\`$�s���5ʄcsrX����F ��ϸ�W���������Σ��J�\�tۘn�'�;�X<,E6��s�}��OKi���5��z�-=ջ�Zݎ�E�8~�d�8ʬ=;�/���n����['����<Ae��$�qLDI!t p���q� Vj��W�تJ�iAtg|]��+�H��J�ݣoJc)�&{OS�M2��H�<sQ�;�G�T2�E7k/Zi�V�h�*�� �c�����iϽH��yw�� r���x��i bH��\r3 /"�-R+���"��k�&�p��?����j8՜WU�Ø�Z&1o�K0����99?�P� jH�q�^�?1__*��I��B���J���4 ��M�����n�k4��McUԦ���
j�s���2���B��0?]��K~��j~�G��7~�$� ���[1άJ2�Ǚ}��~R���_�]c�7�
FݷN�)'ӀA� j�����;��z���қr�hb�n����k��Dg# ��zUXCd8�3�I��w��G����������G����vFS��j)��pF�ӎiX���7c^rC`q�Z~� ��d�&����<ԅ�RzҺ�������x��_�<��U����u}��7dp�rP����'�]Ѩ�
�5MOFyΌ���sv�;�%��l�v�-�s�ppJ��4��o���$�.^�9̰" �w�`pA�T�؊��x�s�Og�y�:o��M�W϶t�Xgt$}x5"At�cy�"N�(��z��Ξ�N��u���|Bӵ>����j��[���d�R0��v
s��
�#0�i����#�ܻ0��<�z�=�_5�Z�#�®hs3�|o�<?r���%��2���F��sn`)$���䓉3\��<��h!FG>��;2�J`
Si�
C6�ʪ�z�ҝnT��z�C
� r�5 13mV���|�`X|ǰ��Ⱚ�X�
x���Ǹ䍀�?�M��XB���u���ڮ�<T�-�~2?�C�1e�1�GM�--.;��hl��n$yDp�v � _���WZ���$3j�������.�U�IF%�a2��7��4���;�3�j��"�m'ؠf�F3� `~��縮�R��4mP��4��R#ϱ��@�i���cLQm�_h���2� [����3ưZ�J������;��Ld�ȌFy��Ԝq�X���6�u=��6�2��� ���真"�
�"�q�Q�S��w���h������y`�N����kZ��������$~��*:�s{�ل9"�:�#_�|M�˦_��L��`�a�+�<A�ˢ�r�J�p ���dN�?��*;Hƴvf{�����d�Z*�A�;���8�]��E�y� 8�����}��w�����g�8<d�И�E"��2�(��@<S$W�Dh���;sϭRheD��K�6K��e6 ������D��wbn��8"z���Y�������=��R6x��8��j.ƗaU�BX�3�'�S
�����V�Mr�[�d��TC=ʆ2�!Q���8���OOni�I�Ӵ�[hVzr��@�2�ys���������^�7��_�i(������� k�i�WM#�p/d�$��B� �����>y��j�-������0D+`� $����x�:�')9�v��&��u�]
Z�B� g�Kx�[�����X֧��
sBI�[hh�
��H�'��<�ٮ����{'��!�>s�������T�G*x`~���/�I �a��0�;��B��U�%��:�ZZIf��_�M��>����[kZU�������A���J��aU�A���1��w�s������<����p��CWpbWtJ�6���CF����s�
��j5>B�$�y#�Bk�WqЃ��<�I��X���mg���
�K�z~>���rH�{�h�`+�4�YU]�����'�J�L�� ����j�@\�a��1֤�1�c�
�Rli�P��R �#����m߆�88������"�G�X�v�݂�ʑ�8'��C>��^�2]�.#�y�w��c���i�����X�z���sA[�F6H�"0%[���9\���9����y�Y�ā�O�5���۾��G�ፄVv��zw��jh�,T4km�ݸ\���52�Q���~�#��gnZ1�2sǯ��ll��G�� �#'?���KZ�D�mf��F���}z�$v�"��� �� _��)w��=�U���n<c)J�8d,��O��v���x� ��z�Lx�
���p3�M\C�%����<g$�pz��c�(�A�~��&�a=�n��.���>��h�E�J��J�������B
�.��p�h��i\A>�����w6 ʃu8-s�np:WB�n��]����ҳ��nb=I�S� ��E��Jd�~a���z`S����u)'����Kl4�F'��8����D�;Y��+�4;�79���怐�0�W��y4�w����4' d`�<���X���h����C�M�D�hw2��I,1����ffY;���-@zMo�w�a��9��3�(%��� �@H�#�;��n-��tۃ�)�l�f�M������
/-�2���H����s�䀩nC8�~t��Pf�f|�JG��o4��.(L`oc�~�( ����i��.a�>ns� ^�i�3��" f�ʤ`� :(l|�>��<;��K��%�����w/����'��6G�S�Lr)d�9�l�>"P��Z��W.6B��l���s�=�>�R�����R�Ӽ��?��]/c�3��m#�w�O-p�\� yluNj� '�"<O,�k
3o |���p>���<ϗc�ܫ�rH��b���X9�;���I�l��d��1E��%�7+���$P�Vk���r�H;�ˌ)
2B��b\��R()<G,�F��-����(�\|˷9?�e�y>&��3;�~ŧ�.؏��PA��xg�R�Gt�1m6��'�Gd�ӷ�rf̅Cq��0zg�z�[�n�5���D��c�ǔW�
�N�ʷ�uQ`%�_=��c�R������t$�d<lʸ'k'$r`���1獼B���D��ca� e�II��=��
b=�������d�ǧ� � ����H<6S���c�{���S�t�.��ŭ��XoV�A ���|�CE��}Y7�x��"e�G�(����<t��1� ����Y<Yp��q����9�y�� �=���y<_s$`�1���we
��\���$�����I�vx�P��
�@I\t�:��x� �?�����䄩�O�S�0`�y�i���e>1�~�eq�@0 pA��'��1�rX���"�&������N��>��<`G��| -�HO �q�9�1�KN_x��|�<i�.?� $�}�q����&��e@YI���P�p1���P ��ni�R�وo��@O�ZBA�B��>��d���E PE PE PE PE PE P�� ��*Photoshop 3.0 8BIM � RP7M6388 ANI Football7 20061203<