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/SF320/244387.jpg',
'FileSize' => '405 KB',
'is_book' => false,
'keywords' => 'hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF320/',
'path' => 'Library/SF320/244387',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/',
'file_name' => '244387.jpg',
'id' => '244387',
'sku' => '244387',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244387.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244387.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF320/244387.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF320/244387.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0704111',
'headline' => 'Offaly v Limerick - Allianz NHL Relegation',
'headlineTruncated' => 'Offaly v Limerick - Allianz NHL Relegation',
'caption' => '15 April 2007; Barry Foley, Limerick, scores a goal despite the attentions of David Franks, Offaly. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'DateCreated' => 'Sun, 15 Apr 2007 00:00:00 +0000',
'ShortDate' => '15 Apr 2007',
'LongDate' => 'Sunday 15th Apr 2007',
'db_DateCreated' => '200704150000',
'event_images_count' => (int) 20,
'event_images_count_text' => '20 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0704111/',
'w' => '2236',
'h' => '1632',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2236,
'height' => (int) 1632,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '15 April 2007; Barry Foley, Limerick, scores a goal despite the attentions of David Franks, Offaly. Allianz National Hurling League, Division 1, Relegation Play-Off, Offaly v Limerick, McDonagh Park, Nenagh, Co. Tipperary. Picture credit; Pat Murphy / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/244387/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/244387/'>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%2F244387&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244387&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244387/" 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%2F244387&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/244387&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F244387&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Limerick+-+Allianz+NHL+Relegation" 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/244387&t=Offaly+v+Limerick+-+Allianz+NHL+Relegation"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/244387/" 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/SF320/244387' 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) 1758104533.1783
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/SF320/244387.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) 1758104533.1659,
'_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/244387',
'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 x
�� '
�� ' � �� ` � �( � '� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ����Ʊ�lf��z�wp-�I��5
]'��?r\63U���I�{TKDb��qU�Y3 ��c�"OB
$�$���A�=��ؖ�L0�V'(#*:f�E��J�ɘ�e
p3R�m�q���KrɌm}*9]���5v�Jz#/P�q��T�!it��n�1�Db�X��S/�V�g�¬�I��mǠ4��'�P����9��M��@�ր�u��= �W�4�DծD��I�f�yS��sI����zv����
I���\u�gr%��s&�H��~5OT�}�Z}���0�{��hg�$�Yu�Mb�C��
.Iy(�ŀ MkQ~��"��3�p�4n�<nj�0x�
�z���L��I�M�XY�K���g�q��ڢ
W�oR�:&��Z�ť�L�3�Y��G#���ǗI��T��@b}�AV���(��jR���p�� lT7�?z�/���� t�&'�X`�
dVl�P��Z�To�w�B�L�J=����ƄjC�,s*� �\R�g�t�ǧ� G�Q��+p�T�V|�밯؞عaҪ��d8 ⣝ɵ�M���33���+Ur/�]��l�Z!�{f7�ZI
�wArK�S�C}�,r����
iS�HQ~�N_�si��QJwe]W�l#SE$3��6ca�z��rG�Z�ݗ.�[G�'������y��ܷ��5܄�_s`}�{~��$�fRgY�\9w�-s& �6y��c��#Ӟ3]���އy;4���U��ٵ�G��A������p��+���Tg�����b�Ω�Tn�h�tQL���s���[��)�tx�i�=������J�8����wv��Z�S�:�<R=����i���w�'��Q���l�ZH�q�1����8����h���.�P�3W��a!�gWM'r'�
���P����:P�rňا���M�8#tya�P8�*|��s�F�b�h�,�.���y��׆es�L��#=y�WU�)�����J�I�˘��hX/�+���Ž��K������kJu9Q�is+��4y��&X�p�i8c���w���'V���Zi�e���2O^y��ʤni
s�]̝wTT�Pn� :�<��h��?�P��'ҩ
�l�T���S���1�s@_A��_��� hQLMԔ����x�:K�o#3�;k�tΛܔ^Bo���jp$�擏`�.]Kef��q=�Ƞ���nA����Z:n�cyM'�0O��~ 1��/�+�Y5YÛ�'��Yb�khS��<O���}y�\-�G�\`�#',:d�9�'��R3���aFT��#nu%t_�,E�(���کk0�'���b��ka�o��+;V�K�&�[al���t�>Zw&*��/�hE�*ٍ�)ě�ʣ��j�m-6i@̎w;���+�v�eFZX�I H�T����j=n��F�D��h����X'dua�wK������v92�YF�?Q��^���)5����ݟ�K&�8\C� )<��O�s[clMwB��m��A���^�����:t�YG��"��V}�|�n� N�q�3�++�7ícg���j:\�勨���~�y��;+�b�8�KIm�[q7�Mnq
��>�PF31��t�i��s���Sϔ�d���6���0���l���1�3K`�{����\SvZ:
I�c#;)a��yj�6-5��C!�&e����Oj�+�M5�8�礪�@~��68��[�>�H��X��zc����˩�� ��G���^�5[MSK�L7t|��ᄊ�2�r3����t������E"���YjK
�T��q�ϧN���%���U����-�9&�� �Iuq,�c'��\R��EE�̗HB���̄K�ņ���5nj����t���b8�!@.��lrƺ}?F�1G=�V� q�$>��s��s֒���9�b#KW�5��]�6�څ���'�J���H�Y�ι�=Uot�T)2�JN;�3�@�5����<����rݒ˫��Ǿ߈خW8 �9Ϧ+]���.�a)M:���<��@l� G������̪�e�܃ᮭ-��{��q���J�x�X�Q�3̙>�����D���>Դ;��h�Nu2%�2�q�$2��=)��*�[��j�Տ�brڃ���� I�硯]#Թ�ij���:��4�U�5"8��QE���C���Ժr:N�$�a\��:z��;�,Ұf�� Et�p����S�# �dƴ���L���i>�粼�x�8���BX)��$���߯R1Z��P�y^�exV(m�~@���t�^��<RTۇ��:
���v�K�fo�C`�ԋȕZ�ɍ�2a�����{VO�՞��\���t�����d��/� �5� JN�wg]Zq�I#+Gli������$y �村��5t˻{k6$���p8�EVk�I�$nOj�s���ot�n��dm5�,rE���}�#PY�o`���rj���6� �Ѕ(�j�o$7�����g'��V���<j�曗��5����G��J�ؑ�MV�K�.��f�� ���ǥ%.k�:U��nI5y�Y�q��;Y��O��zn��jZ��ze�l�9i�U"��ݛ�,Nq��ޕ4�rGMJ����{߇|?�H���[t�%qn�Ly�nUG�;���;�#+��>��_�n|+�}�}�$y�(�j�u�@�] ��1XF�*�SZ�O�無7f|���ɎªÏ6s�]���f��cc���cly��B�!�R@v��1l���5q6�ܜ�
��67�<:�F|n��w|.խ�<r���ЊI��\�:+�n�_.it�]V̪$\4m�@bA�3�Tt:y�:��Fv1�I����j��Q��tjF���k���-<yb�w��fo,�S3�n�P�pA� �+�
��w��]��K�B�Qv��
�nH��b�����������4�9�Y��W��7�ޥ����{S�]R�R<���O�p�}J�Wß�;�\� /�گI0k�ߚ�iF75���n��×7�I8����J�c � ���,��D������VV�5� �m���4�E� ܱ�w��G[� ��e�M
���pT�Q���J�;�̈��r׆�7���Hᵹ6�(�d������
9v秿$
���?Ҽ7j�V^��.`B���(�9�6) ���ҟ��V��`���<��nx�]�[�dxw�28kz�|і `��_�>w�Q�t�����<��}��dcv̅�KyrG��' �P����V2�a=�H�u<N)�q#��W���[�&�Nkm����j[���j�\Z>zQ@X�7$C;u,Es�h��}�m��KO��c�E�܌1رF��8$��s��j��.Z�V����i�?Ǿ]Q�,b1"���lc ��2Iܽ�o��kq�]���H���]D��*
��9�s�g�u�p�^���ާ�=/�>�ӵ���ZT6���|��V19P>G�3�����M�ӭ���Ig�$�c(�O�_������#p��6��MJ�RQoW�sE���t�ٮgNv9�����ޝz�o���?�� ��h���ӥ{�m�a��W��%���Ox'�MJ����u�n�.�����` �*��gu}s}$*�4����'���+J��G�V�����#ҭ�!JY ����<�O��O����*H����(�9��{� M�u��M��˳���9,ǁ�{=��E�Ӡ��T�v�e���\l�8)`2y��y9�i(�v��|����'��ZR�����Q@6�#
J�f���M^/h�;������$�{6IX�����ވ�a�`Le���88�g?J�˭V���f�l�_�Y·��J�)%��x���P���/U9ƚ�Ȥ�X�Jt�#�e�qS'%+�6j�vQ���<Rކf��z*j�$7%�Ƕ��Q&+�2���������\����X���#E,��;�[�
�P�B�]�~ȫ��( ��OL��ս&���G&*�妷g��'�t1o�h��@�O�r��);BDO.A'�r: MOf�:������Y^��a�'�䏿7Q����bX�V~֞�oN� >�Gu<?�\�z��^,�>�;M������ʨ��9<