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/SF335/254468.jpg',
'FileSize' => '435 KB',
'is_book' => false,
'keywords' => 'athletics, soccer, hurling, gaa,',
'real_path' => '/media/images/IMAGES DONE/Library/SF335/',
'path' => 'Library/SF335/254468',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF335/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF335/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF335/',
'file_name' => '254468.jpg',
'id' => '254468',
'sku' => '254468',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF335/254468.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF335/254468.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF335/254468.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF335/254468.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0706237',
'headline' => 'Preview of New Sports Surgery Clinic (SSC) Dublin',
'headlineTruncated' => 'Preview of New Sports Surgery Clinic (SSC) Dublin',
'caption' => '27 June 2007; Ray Moran, Medical Director & Board Director, in the soon to be opened Sports Surgery Clinic (SSC), the first dedicated othopaedic and sports medicine facility of its kind in Ireland. This new sports surgery clinic will function as an Orthopaedic and Sports Medicine Clinic delivering comprehensive specialist neuromusculo-skeletal sports service and will be located at Santry Demense in Dublin. Sports Surgery Clinic (SSC), Santry, Dublin. Picture credit: Ray McManus / SPORTSFILE',
'DateCreated' => 'Wed, 27 Jun 2007 00:00:00 +0000',
'ShortDate' => '27 Jun 2007',
'LongDate' => 'Wednesday 27th Jun 2007',
'db_DateCreated' => '200706270000',
'event_images_count' => (int) 8,
'event_images_count_text' => '8 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0706237/',
'w' => '2362',
'h' => '1690',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2362,
'height' => (int) 1690,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '27 June 2007; Ray Moran, Medical Director & Board Director, in the soon to be opened Sports Surgery Clinic (SSC), the first dedicated othopaedic and sports medicine facility of its kind in Ireland. This new sports surgery clinic will function as an Orthopaedic and Sports Medicine Clinic delivering comprehensive specialist neuromusculo-skeletal sports service and will be located at Santry Demense in Dublin. Sports Surgery Clinic (SSC), Santry, Dublin. Picture credit: Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/254468/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/254468/'>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%2F254468&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Preview+of+New+Sports+Surgery+Clinic+%28SSC%29+Dublin" 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/254468&t=Preview+of+New+Sports+Surgery+Clinic+%28SSC%29+Dublin"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/254468/" 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%2F254468&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Preview+of+New+Sports+Surgery+Clinic+%28SSC%29+Dublin',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/254468&t=Preview+of+New+Sports+Surgery+Clinic+%28SSC%29+Dublin',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F254468&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Preview+of+New+Sports+Surgery+Clinic+%28SSC%29+Dublin" 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/254468&t=Preview+of+New+Sports+Surgery+Clinic+%28SSC%29+Dublin"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/254468/" 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/SF335/254468' 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) 1758069665.17
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/SF335/254468.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) 1758069665.1391,
'_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/254468',
'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 ��02Exif MM * J R( �i Z �
�� '
�� ' � � :� � � �( � /H H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �w���#i� ��S��<I/%����j��oL�ec4��c���"��ЊWb;�G�Vc�����)p�rz��$�Ν�li�&�{`څ��$��p�c�����
g��IS��pA��V�KQh1�x�M��s0�.��ӻz��V����n\�\g��Tu���U-ҋ=%v�*��Wߟ�}��WV����w&�|�ƶ� !�iM��䳞� ��������x�[Ց��{�kɳm ��R��H��1ǰ\�#ü��M�N������AC)W�M:�:��Nq��Y�S��q����O¾%�!���t!Q����% �s�RI �V����{ ���JO4����/�Y�&BQO���c0ξ���3yH���G$���RM��i�F�+]�v۸V�2��Ɲ�Y���G���p��zF�r?#��S��J��SpbRmn� �l~�� *��V�q��Q�6�S�w�0��� ��(ŹX���x�]�I������|����Wԏ�'��t��|en�4V:�.F~����qW:��t4te�ՙ�.�xn���&�d8|� O_�J�q�����U��V�X� _�B��\�2k����s�j�b��"c��s��ib+��v��M���-ea�i���Oc���$1�OU���&�����sR����_꺔v�F]��v�g�� �5�^#�ִ�:8�K{����[ʨ�iF������ ��M�˼T��Ȗ3���~�֣���^%o+^�V;��\.Q���F��
�b{
Q��s���Sw�܍Bé`1$C����?!YzU��E3H�KԾ���jN�$��tM���)ɺNȼ��Ҋ\�H�|�e
��^�����<!�[��ҷ��C���$���F.g'�'w�ͦ_Jc�x���;\���VsxgVHM"XV�����OR;q�i)���8��Dɼ�Xӳ��X.c^����E-���AH���IV��W:o�Jƽ��cw"ƅG8
ɂMvW��}����gl������D$�m���L����j��.�_����pWv�
Ѿ�{��'��x��N��]B� b��
�烎��_;�S�Y���}�6t�<3���v��y�WvΊb���b?�(������̗
�C՜^�Uv|e�]��r�PI��O�@5��iE<�&B��������r+/�J�˃�9?ʦ�[�K[ܺK&�sF���'۞�u�>���ӓQ��V��ۉ�ު}uC���>�)��T�F�~of1<I�X.5�˦�t���k�
#���=�T��|MƎ�G �����n� Oһ��eR�cU�]�f�l!9��/un�6��h��e��1'���c�~b�oj꺫-�[X��#�����n��)>K3���8ƺf��
G?x�����CSѼ�%ޥ�]F
��0a�Oa�
�|{v4�Gl�F���f �g�?!��֩�Z�q�m�8?
�s��iod]�`~�bԴ9��m�`$�c����}z�3��K��2�JU����~#i��Ҭ.�ݟ��Ȑ��E���+���\�lݾ쀟/>�����jp�q�:s:���m��ᆙw.�5��!�&U]�͞T�� ]��;9o4�'�P�˿jP[��%�x���ҽ(�JG��uRga{�_iz�ءq4I���`�u��:�������~�n�2��#��M�q#ӧ@ �r�R�=���,^)W��IY��K�;?i�������͈2�z���:q�#�<5����өU�\ɴ�5�B��iK���J3��!����-$8�'���R鐰;IS�<�ݤ�9;>�c��mN�ﷰ�́�/���W[�^kW�����ц.�L�u����5�J�n�C��*���[�dZ'������}V��S�9�#}�}3X7�xh-���Fٜ*�T����_Q[��x�rΜ��o_�1�����YM�-dg3H�e�$63�'�d�q�5�Z������v� �)r���#'u'����P��R�wa�2M�i�?�~.ֵ�^�u�f]�����i���CӯA���5�[�>m:�,n� � ���"z�b��S� 5�Y�ʬ�W�p��)_���L�<cv-m/$uCyjv:���Os�א5��7/sx� ;��9?�v��pN[�.;
5�o��z=
�0�G���*os��i��)���g��̡D�Y���6I��;gx��#^ծ�v��0T|�r�1��1N@;WMh��".ɳG��mie.�!�挑���;z�U�Ed��q[��}I�K��;��y����mu�:^�
�,�{-��R�d$1#�Ie�W��B��w+�s)�:
�V��8q2�c����~ԼLu<é\�\0UIB�C�� u����5��.��OR�u]fS&���dI��q#��ԓK�=J<ɶ�;/�~4�ω,g���%��7�'9��8��X������=&}�H,,Ԓ�6�:,�3�%d_~����J#�
��:}.m.�I�q �G�7
$nJ/S�����H�ٙ�r�';</�?Z�T��C�Fx���r�ws_A�/5�I4�>ݧ��B���p:
�u�7�ׁ���罍����~V$B
�r�<��z��ڵ��Q��x��?�!��K�Ⲋ�C�Z�T[ 8���.�u��㺷��*O�"�p3�8�}G~���j.]κ5�IN+v�wv<;�>�� [Ȋ���FC.T��`������M7G��,�D�1�I���I ��sZ�{5ʙN�����o��z,q�YY��8]�p���x�-���3\jzϊ��[��i�Zs8��(�B)��Gj�6�fa�ȅa�<s�D��tXS�(�e��S�q����T~#&��O�I��HV�X"&���8_v=���؈M�K�1�چ�$�j7�i��̓H f���� +��:-��VU�� �hF��ER1�麾��n.�%��Z�!Kdu�@z�oɯY��ӭ�b�ҫn*7
��� �eY9U��^�:h�*����>� �1�l
�/�I=��nx�s��z��wwWe̪�r��01�#���R����)7N�,�|�g��{��s��E.�L�����x=���W#�:u|�˕
έ�rFs�]-�Sʯ��ej�o���֊,R���O0� �f���8y�I�iR�W�\����;GL��s+��|���W�zd�4��-'��4�X���w'ҩx�ڞ�q5G��5l2ǝ���\zqM��)���a�sD��A�o��Mԡ�9Y|�<�Vc�7*���
oN����O4 ���R �p�O�S%&�Gk'c�>