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/SF279/221540.jpg',
'FileSize' => '301 KB',
'is_book' => false,
'keywords' => 'Rugby',
'real_path' => '/media/images/IMAGES DONE/Library/SF279/',
'path' => 'Library/SF279/221540',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF279/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF279/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF279/',
'file_name' => '221540.jpg',
'id' => '221540',
'sku' => '221540',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF279/221540.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF279/221540.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF279/221540.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF279/221540.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0608196',
'headline' => 'Ulster Rugby Squad Training Wednesday',
'headlineTruncated' => 'Ulster Rugby Squad Training Wednesday',
'caption' => '30 August 2006; Allan Clarke, Ulster Assistant Coach. Newforge Country Club, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Wed, 30 Aug 2006 00:00:00 +0000',
'ShortDate' => '30 Aug 2006',
'LongDate' => 'Wednesday 30th Aug 2006',
'db_DateCreated' => '200608300000',
'event_images_count' => (int) 30,
'event_images_count_text' => '30 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0608196/',
'w' => '2637',
'h' => '2019',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2637,
'height' => (int) 2019,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '30 August 2006; Allan Clarke, Ulster Assistant Coach. Newforge Country Club, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/221540/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/221540/'>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%2F221540&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Squad+Training+Wednesday" 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/221540&t=Ulster+Rugby+Squad+Training+Wednesday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/221540/" 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%2F221540&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Squad+Training+Wednesday',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/221540&t=Ulster+Rugby+Squad+Training+Wednesday',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F221540&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Squad+Training+Wednesday" 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/221540&t=Ulster+Rugby+Squad+Training+Wednesday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/221540/" 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/SF279/221540' 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) 21
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) 1758067302.08
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/SF279/221540.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) 1758067302.0514,
'_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/221540',
'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 � �� ' �� ' � �
M� � � �( � � H H ��� JFIF � � �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �]�5�i�i�rA�������7k�k���)�2��)ܓ5by.2���[hȥr�����}*'����1v8����l V���4��%5"�O$����R��h�,y;�q�U甎�c�=AF�gp��}*2rrke�TRؖ�A �פx�p}��k3*�Q<u���C��g`S�ާ�V�z��s�)8�8�j�����8�v�ȣs.�[��H���2R]�qj�.�9 qOmǒ1ߚW3�/ip&w�iHUW=1I�J!IA�4�9�
`ix7��+��i<V�<�)+{���X ��$_B�>�>�/PI�[�jf��A6�U����E�����p��z#��4�3;��K�MWGԮ4
J����'s���͒�1
����/�,�o�[��K�Ȳ�-�{{��A�b?��}29����kS�B�N����$Č(ɪlw6@�DK�
���P�Y���W.�ֳ�ʂ+�|l�q�����#�FO�N/�^spY��4�|v*
�-��h�RF�i�I&̜Sb�ٺ�+c%.Z����T2��^�6JԊ�Nq��֭��)kq�Y��&e#U�vqɠh` 6*g�B��B;��n4�
�z_�����ZEsu<m�ۋ���b�~B�t\d|Ě�� ��#�T}f�f�D�O���Bpp ���s���*'.E�;�Su4E�~ x�Q�F����:���L�]q��� :W������? |A�k:�%�wW.�29� #��ѲN<�@W�'ճ�&��:%C�
��=d�t�א���]�E�J�U�L��I#HjN:Զ���M�K6�F�EzW�,W�Ҷï|������=�<�Y^@�$��qێ�V(��Thwg8愀)�*݉I�a��g��=��Z�+r��s�W�V��aC�u�����z֊�o=�����# sҩ�?iKa��uk*O���P� ��<�C�W��Y����\�*(!�U��\�7+#��nhéi���5�Q��H<��}2GL�R\]��>�-��qmy<�-��hf��c?uT�}�9�V��4��ZK���BU���W���� �n�Ui-��NG�z��b��&����A C�3I1Y���s�}Ez�����A�]7��q�;o���5͉ ��u>!������L�XKsXlg�9Mh�3H����,T�mgr�#�rGJ�6$r3'����W,۱��zԌ�b"9��S���b�
��tYl�m�/��+h�9��j/���J��6�p=J�M�Zg�n=DR�B+��+���V����UVN]��~�G��-/tX`V����#4�a�r�x=�ڮ�:?���z��-�Xറ�y|���F�b@b�n$f�c4�ձէ�>yq���P?J��3^�g1�8��y4��
�� ^:T��?�#�W�xd����]Xre����jM\ԙ�U>&5�6���)�ފ�F�؈&z�ȁEld8(�jG4VxR�P�:R�Bzm�
���(���A��s�*\�(C>���g�_
x�;�e�˂��H|�F�@8�A #��ϳ�\$���N�m�߀q^N1/h{XI�f��N�S�
r��%�C���S2��6�����O]K��L��ͬ�$fـ�ǶG�H��#�٧(���
M��>\� ��U1�^�<�Yٜu�Ƹ`1�b.*
�*7\R"+d/wI�WѢh��!k��P��*;�'E`�GJ�_���>.�Ee4�k�2.8�*������`Q�a�9���)9�\��c"�����̸�8 �If��GjY��� I'��i�O��]ԭ��o��;�
9o#]N���c!�`��p,6��u9;!��� m���b�ދfֺV��L���C�3��9�� ��U�D�vO�l��eRq��xX��Y��9](��6��j��/mgsup���k�j�F�9[�R(����/췂o23�ᛡWs��p7�ta9*>h-�leG($����b��3�q]�<�Y�TQg��v�U��tpT�Z�+T�g��]�u��%�3gQ�����\�ݔ���)�V2l��{R���L�
b)�q����)5q= ʹ�x�T�}�ޣ{
����u3��4� =꒾�H�����s�Y�>[]�����:�h�etx� ������ �9�=[Qֵ+�CP�i.e��E$�
�X��J�,��|>�̋b���k�Hũ�fF#�����[�A?5z��=�h3$i������}�xَW����
_ػ=��n/�L���T�
Bki!��k2���NՏ��xC�z���/���:V�n"IP�(���� w�Æ� 9#<�fT�R7�ק8��~"�G�����3˥^���eb��I�h�<��6$��'��bP���]X�JǞ�^dgn4� �B,� UK�
�@'�ԝb<s�⽀��9�+��H��1k���5��#5�'�Hfu gQY�Gb�J
$�qT� �H=��@C1qUY<�h��y$X�B��j��I=��<e�k,���T�,��ny��#� x���WV7�7aH�MZ�&���Üc��cF[�6_,�Ks�qֺ�>����^'�����y�zvu�=
Ǎ���1�M{O��
#��Y�s$��|�Aq��V2$v0q��^��X�J9x���d���
J�K�`im�s/����F��Pt�[�ڼ�ȣ��ß�x~��j0� ��%���2�� ��(,� �m�C��/�&О��O �&��YූB���G�O�l���
�_��%�WV�&��)�f�����fd�\d8��ӏ�9}�T�<�*$�.y�P�\g�V��n��f��z+�]�>L�<�S��<���oc\Rܵ�<���),0}�E+f� t(O&���W�q�M\c��i��x>�H�jA3�E u�gA��p*��:*FHڸQ�d�#��vA8ҷrz�V�*��@� ?�V��1�ۺd�H89����>��f�O�"[� �u����%1����T�[��� 5�ߴ���>"ݥ���4_�+\6U���$�8?�U�z'�O��#���iG�vz��V���K߳2ۙ#�T�X3 $�A�`rW�ƺ��5�3R�|/�h�P|��i2��Iy�*����p[#YF{��S�';h���:_��>�B� �5ˢ��#��"�s¸�H��ӝݎ]�bY,Z�/%B����g���诌{�>��h����� �j���9�s$�*��Ll�<�MKv5��#+Fs�o�_"[�F��]>zIUݚ�{���b�b��[�R�\�JkfId
��@�$ԭA����ڃ$� ;���w[Z��0�X�'� ���n��F�>�ʒ�%W2ກ�$�?ϭt� �<�,��a����D��s�8ʐ?�LQ\��(��ƾ7� ��O���u[�͵�3�r�Kˎ�2�靣����E{D(�b� 9�8�]���t�����V�O��Q�Fh�j��
�N��FW<F�5�D��m�[��4���n ���W�Z�9�>l��$o2H��
<�aÓI��R;���º���_�9F��HC�����j��� �%�G��Z����ѵX��l�=�A0�Jwp�<��Wc�T�3���k��K���)����J�u ���=y���R��0��M��=�#�B�gw�k:��j�r���11��Y7q�1��y�qɐ+�H�ya֛�M!�xNܚ�ö�7�m�Փ~����m
�t��;�ҹ��D�^0�9�k[VLtEebW?�j�����-D�K�c���nnd�mn�3{�i
�ݔ��v���|@���m�^H�i�)�O�qY�͎���c��@ �]Um�<�)��RO`*�.]�Ư����Lf�-���#̻
�2:M�uGR�XodVpy�� rŀ�����v}�!VP���io�sj��b�:��vwk�~RѮ~��~����F_�<��
d�A�9� ǚ�32�B;S��ko���F:�6#��1�f�s�[^+�YA�9�mr�y����!#�jΝ"�
k�������#���a���Bж�Nts�Q[|�"���/ӊ�ae�zU{x�nHJ�!���5Qwث��r%���y�T�~��Mc��V��2.!�
J�F�q[��O���,mKxs8A�-�WtV�w;ϲ������9���,<VY1�x��8�儗lsc�Ş� _�Ue�\��h���ഌA,X�
h�:r�Qak��5�6�o� �Z���E=gOk�"s�� U��X��n'iS�K�U�3)V%���?�^Ջ\� ��R�1UOo7�<��Ѷ�ڝ)�lb����xQ0���j�҃��� $�CS�N;V2�L
�H��J技�b(ѓ��!�Ҫ��1�T�R��ϖ�8hl.$K�h�+���'?����?xm��y(��ܫ�1Z6����˽�48�dW~�A��h�U�Хާw�m;� _ � ���mm�^\[�.#�WD+��C0{�� d�R�=�̲F �=}���q'���*f���~�YgO-�D%�� �[lK.��*ϡ�Wwk � )����2}�a�]� �fi+^H����G�����@G'?tt���j!��f��ӭs7b�JqTnCt�;����*]~@6��S�ٍq���Ҳ���rr-�$dc"�e �
��&[�D�q�g��~�*H �S,Y|��qfr������Nj���Q�²�W
���'���~��#�!�C�>g�"�,ٳ�ΐ��+�Bn���;*��n�w$g�ś(��ػq��;\L�+Is?C銼"X��u>¢:���k͖$t �XQcVr� ��V�[5��d��L2�� u��?C���/�c��V8�]ąE
y�;�X���wԥ�+�D�E�p�y����p)-i�Ѧ ����#=FFMEq���r��B�����U;d�4���U�@
�HC09�Id��M��FQ�U>���_�Oo1��(� �2�# �bGnj��̋�Hc'�@�?�Z�O�i�z\sEi�a�(�FK����J�w��o�pG���V�����%��b4 �r2=z
��E�gIN";�pv��m���lhA�#�M�F��3@��_5���+����KF�� �VX�� �0*)av;Pf�@�ee&2¦�
�㡥{��\ҿ�p95WR��l#�v?� B#�A7�:�4���1OP�pEc=qJc�S@�peb���l��!�I�&�PW�-KO�-��[K+�1k#wo�I�т�v��1�s�����mݴ�:���֖1�!�2�o�5�V�Z}�z3�
S��G����k��iiW��(.�|,�pp �8��+Z�nL�ҽ�Q�\���ęd�g�Oj�=�����=8�Ž�$��k ����U��z��ˮ�����RƥM�K�u��l�C�|[�vc��oҲ �T����U�+����P
�{����g������O5�4\i�>�=Fm��t���[�a)n�Q��_�MvK� �t���f��05�2�����E$�5��>�?
a��>��u\��N�K��MA.�!B��2�̧��H�D�r���j;�zU�l�{��+˫���6�d�F �B#7�A�pÒqߚʤUYE��F���{u<� �֓q�Ekm�m./'F?)�c'�rN� ��\*�Kgi��{׳}n����!i6M�n��lD�m��5�ۼ�ۋ��>����Ɩ!W%�nvm���QVb��c7��t���p\�
�r�
� 0Ei�Zv�� ��5�]V�i��E�YH�@�$GgER�Z/�X~��YW�=�i��ϣJN #ڢ�Ę�5�{q&7�r0۾���� ��*�r����0�p �m�?�|ͧ�e�V�7-ɦ1���Vq�][��`�9�ͥ;rV�=����m�hcS�-�n��{H�ӣ��]���B��-�Y#������6��x� %$/�e����H��$z�|�^U̪/��5b�Ve��g�C��*$
Y��� d�g��zf�~���6�(����w09��c�<�:��+���f(�
b҅0x��_�Xz��=��{���,H|��*�Yq���t�pyu�����Љ�*�asi�A��,rzr?}�u�ڢ�~[��lc�QGwbW�X� �&�Ð˃�� �7"������g;�~�Z6�g��y��:��yVq�Q���ddz��ON��e�� �Ӫ`)H�1&z�2��|��k��|��?���/���⸇͘�xRGIH䍣��g$6O�j�`���F0;����i�Gk�m��c"$���%��A��� ���ڙ죧۽�b�Ų��
�U��qЯ�r3�p���v���Q�f�v{���A1Xm��K��� z������g�\Ks&��������;�%��9��T���.v� ty�ͪjV�K.H�, $�$r0z���������ߔ��/�d�/0� �|п�9}� ~R�g�� �z����P_���?��?�_� ߔ�?�·�_���)}A0{/1��x�?�`�� ���s��f@���_�/e�0����-@� �覰����p�K2��s� }�2 �N��P��
( ��
( ��
( ��
( ��
( ��
(���*Photoshop 3.0 8BIM � RP7M4249 ANI Rugby7 20060830<