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/173496.jpg',
'FileSize' => '289 KB',
'is_book' => false,
'keywords' => 'Football, Hurling,',
'real_path' => '/media/images/IMAGES DONE/Library/SF189/',
'path' => 'Library/SF189/173496',
'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' => '173496.jpg',
'id' => '173496',
'sku' => '173496',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173496.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173496.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF189/173496.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF189/173496.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0504068',
'headline' => '2005 GAA Congress Saturday',
'headlineTruncated' => '2005 GAA Congress Saturday',
'caption' => '16 April 2005; The Tyrone Chairman Pat Darcy speaking 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' => '1632',
'h' => '2536',
'dimensions' => 'height='180'',
'mobile_dimensions' => 'style="width:65%;"',
'orientation' => 'vertical',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 1632,
'height' => (int) 2536,
'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; The Tyrone Chairman Pat Darcy speaking at the 2005 GAA Congress. Croke Park, Dublin. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/173496/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/173496/'>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%2F173496&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/173496&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173496/" 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%2F173496&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/173496&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%2F173496&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/173496&t=2005+GAA+Congress+Saturday"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/173496/" 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/173496' 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) 22
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) 1758169233.8767
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/173496.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) 1758169233.841,
'_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/173496',
'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 �� rExif 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����������������������������������������������������������������������� ? � v�v��h��h��?�Cz�GtxH��Z3b@�s�;��q\d������cFs�9��ڽ�|?�_����¾�Ҷ����J��W���0���/#�ɺ���U�%��w�֊.is�gQ�=+�?�1?�%>��{��?���NV�jn?y�y�ҁX�£b}(2M��qC�^�<c_���D�%,�2}++X^�Kc��NzVU��j�19�_���R�4=���J���_��Lh{���py�iG5����_x����B��/\����
���b�������\�Ӈ\v��NI�c��k9TQӨ�����wf
��32���ȫ�+�E ��Nx���]w�a���<=��f�>]�@+�YrG�jWruZ�C���<o%�����|~��7m�x��W��`����%%��B�ȯw��NT�������~���/��%���/^+.�s�krb`I���{4�ۧJ��(�]�L���C�px�W���r�+�]KTR�TN �Iw��2A��Eԗ*5G����l4Ȓ�6���` �Eeh�M3� ijmnV5'��oj�:hR�Wfg�t��������t�Eir�͐]��g'���W:�����n4}^�����x�a�da�>��|a�Mx��K�7���1�+������;���b���ڽ�q9�� n��ĽϪ,G�2�+7W_��D�c��k6e����7�諱g��wfb��b�㨛��$��mٓM]�7�ZϨj6�6˙�$X�{�+������h�9[kT�/B:���Ү�$vw:�ʊ�<�����V��1��A3}�WI�ǩ���]�X��6]����*�_���j9��7Q����śC)
�C������-��F���ơ$��t��=��a��ׇ��c��C�� �U����ݿg��ٮ�lr=Ϫ�[ދX���v���-�[�189�/ZD��uۯZ+SB� �/g���j���}R���C��Y��4�ف����96��@rʌA���lү�˝�9�泬�#D�5
bF�i�O��z��Y�z��g����C^}E�����7�?�1U��?���>Kےzd�<�S��rhon����a�[��Qx�Fo�2kFtdu,I�A�� ��ڔ�+�x��E#�]kK�Ӯ���C��{��q.���n�<��Ϭ,�t� �
p~6��у'@k&�
_C��5yo%b��5АYr{ҋ����"�1��h���|sb"rzW�J�I�� }�f��/�2<
o-��l��6�7���<b��f��"��ƦR�#P=j�+4T"��[t���3v� =i�@���gڋ�W�#ӣ�.d��[�:䕲�G�+N��O�j�?:��=Οk ��jJ\Is��ˣ��HٺI� ��ƶ|)�닝>��b�"��ɏ��Q�J=Q5.�_�}5��湅L�끚�g��
E�q��c�zq�6<��w����T،����kT��8��͡�G ��YEpB���{��0P����*��2��on�Oz*��R��Fv���?}��2\�j�\�Ӈ��7���:�����\7��0r9� ��u
7U�Ⱦk��yn;���q�Z���7��ݒ�u��ĒEѸ`�~57��n�u��Bƿx��\�7��I~���|%�m���BrdU�+���xE,�����8�0:�l:��ݰ�=����Ѯ �Ĉ'�|�Q���kV�D�N��va���$���Ф�DU�_1��6�K(D��
��eڭ���'�0���Цr��G�i^-�kUD�'⸟���ܼ:/S�ޅT���:nǐ.��A{�,�v�[=��~j-uK+rk��-�sX�N�nNv�}�7��W]����k=���6,8�exw���6��'9 �TY2�K�Dj���:m���_�t��]B�i�|��h���W��ݚhҏ�%~�/q��,����<Quc)U�NVR�#�6���V��Ӑ��6*�8�T�n�U*�Pw g�zf�Wct^X^�dIGA��xJ���5�TE*C�B'��έG[؆�&sھ�.��F�B��i�hX�BD#��=jkJQI#��S�ͭ�x��9�x��+I� �[+��ZE1A�JǕ��H�mZ�A���(�+�<7oii�#Ĉ��oR��S��y)��s��׆-^G���N9��KP��4q���O5�C��fyG��Q�o%:��km$(^H��I��(�>��ϭ��_^}��b��̼ch.2��{�z=3[B���sʪ������ �p6�v�^m�:��o����4�:�����"�C��1k�E���6��6��0��J.�r���M];N8
�1����?,ײx[�I�c���A���O�
�-nr֕�8�x�Y�h�H$�A���}�oK��ʊk�7��Z8�f̩��c�u�4���(#��/�2�J�?)����iF
;����-ʳ,`pO$փhZ�WP�4����`�h�b#�yJ��<�s�w���N�S�>!�[Ҵ�˯�&K���1{�����ߵxv���j���w�ޅ��V�?\
�E-Z����$���k:��j1���6 ����3S���U�wl�)lf�Y����Et۹�t:�o�Ku`�X!60p���V�Y�IH�W�\`ד8r��d��ܴ�2��6Ѕ�>��U��O��{�\Ky�)����S��.�Y�x~���>�n������<�}���Y���Omuoy2�8=j���S���:�?��f����"�g�Ȫ�:�Ɓ3i�[ ��S7ea�z�B<M�91��95�|E�q�<��#p54֩=:߇W62i1�m /4�!��I9�u�����7*�#��X�w7
+�yY�<˱���>9# �*���� 6���9c2��4�8�*;��.ặs�ȲFê�9�L�}
��g�
YkV�!�xr��#�D���\ksh�B�Q���n"�����Kv5���YGu�7c�Z�W6��c����=Mr�-3��4f�S��-"�2ҟ:�dF��GL��#ָ�
��X�.��M��m.q$2�6>�滨��<�D�R��?i=sNE��%�z�
� /Q�=�_�E��N��{?�2�."� lgA�Z�yeu�ׇ�{E�-�_Q�B�\G�R9�<g�˨xp�+m� UR��LҭD�G�h3�,�^(r�IR7pH�x�PԵ�m�YF���z�lCn�G���Ud���T��~1�Ey����G��Ԥ�?Z���ñ���ϟ+���!U�J�r*��U�-���u�Sw����|J{���t�&��xr؍�ea�)��l~oo�YM]ӗ,�r:-��2(XR?3Cvl��1���ú]�ׄ�D*����0����GŪ���X���&�죡�xOR���7:��B
����(��>��Ϳ<?g���
c�.�sf�#&�?y ?�?��kO{0��R�m��⻏�>"�O�M�����Q"�E����1>��J*J��2p�2;O�6�wϹ�&�&�
�i�՟x#�]8��&U%'vU���x�Tm;F���f}��p���{}+Ю�_x:��59�J! {
�� ��kE�}FH�O9������jzj�>V�A$Y�<��Q�aVPWo�〤�ퟎU��� &��þ����6|�.���?P��²����#p���~����u-�OH���
�����.���6����Yxf�ÖRϣ��[�m'%��<+Fǐ#*r1�b���Ww^�t�^v���!�]'\���c��T���VL�vv���o�A&��i� y�
�������\��i�Z-�����Ap�M�o,���f�i�s/�yLE�29�j��;�j�3���s���+w�j�>�� ��c�Yd"2p�$&2���-|�S�l}/�?�|=V�$�2��}s^O�Lk�[�AҴ��
Xz��ߺͨ�TI���
�(��}Oj��g����*�q*L�*x���<b�J]Ho\�J���+Im���j�"�6$�,{�#��X�3��ɸ����i��ίY�de!yS�3����)��nTc�r����i%n�2�G��^Mͭϙ���g�G� X����m
M6�=b�T���!�����YF�` �1#��қܦ��喧t{sʜ� �ֵ|?$i�m�E�(�"yP� ��G�ȫM��>��P�j�� �g�m��Ut��p'ZH�=��:�z���F� ����Z���̞\vX�����f��K�>�~
n���+�IP0zsEy����EKo3E a��+�<Q�*�<��A?7�W�$����=��}��k�*��;p�>W w?2�T���l�SȄ�P[��O#>�+�?i�L��'o��I���
��d���9O�� M:�g�F,$���t�w__E?�{.��-s�
�\��cc�sF��>_¸�Ϛz�<cN�<����l�x�K��-��X���C� =c*J�'