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/SF193/175996.jpg',
'FileSize' => '413 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF193/',
'path' => 'Library/SF193/175996',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF193/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/',
'file_name' => '175996.jpg',
'id' => '175996',
'sku' => '175996',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/175996.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/175996.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF193/175996.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF193/175996.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0505024',
'headline' => 'Offaly v Carlow',
'headlineTruncated' => 'Offaly v Carlow',
'caption' => '7 May 2005; The Carlow manager Eoin Garvey. Allianz National Hurling League, Division 2 Final, Offaly v Carlow, O' Moore Park, Portlaoise, Co. Laois. Picture credit; Ray McManus / SPORTSFILE',
'DateCreated' => 'Sat, 07 May 2005 00:00:00 +0000',
'ShortDate' => '07 May 2005',
'LongDate' => 'Saturday 7th May 2005',
'db_DateCreated' => '200505070000',
'event_images_count' => (int) 13,
'event_images_count_text' => '13 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0505024/',
'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' => '7 May 2005; The Carlow manager Eoin Garvey. Allianz National Hurling League, Division 2 Final, Offaly v Carlow, O' Moore Park, Portlaoise, Co. Laois. Picture credit; Ray McManus / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/175996/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/175996/'>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%2F175996&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Carlow" 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/175996&t=Offaly+v+Carlow"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/175996/" 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%2F175996&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Carlow',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/175996&t=Offaly+v+Carlow',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F175996&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Offaly+v+Carlow" 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/175996&t=Offaly+v+Carlow"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/175996/" 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/SF193/175996' 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) 6
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) 1758160038.9723
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/SF193/175996.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) 1758160038.9596,
'_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/175996',
'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
�� '
�� ' � `� � � �( � 6 H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �8�z��y͈��)�ɥ��1@\i
ȥF�z���� �I��-�zb����p5�Ţ��6��ۊ�1],�e�8�Ї Oj~�j`.;��<@����:C�g��Ҍ�¡ӼQ��FU��X��F �n뎝j���{f����8����Ls�,F�u��0Aǥ�_3$Q�O�C'QR*�P�������ko2�4=%���[�{���:����p�J!؇�?�vѣʔ�kN�6�7�|9�焤3�� ��*����D&��Yn"�=+�������_|S�7�nV�c����3�ю�[C�}
�i^&�T�n<��S�F����5È�o}��.0�G�+���k�S�T&�`*)�Ǫ�Z�T)��*@*��#��ztq �pJ���ӂO���)��\q�3�[P�����3�+X��
�(=Gj�u�g�(�~�G�$�ۚ䵋�;N�&�W��Xn ��$��U�'�A��^�5�Y<1�[u��
>��h�
<?�I��>�m��ǏR<�>�|c�4���������\m��� S�T��;�2���h�c�W��:R�p �����_�kMٚP֢1懶g��o�V�*�%G�Tz�7�\�e�r�;v�T���|qԚWw�g��͙��I|��Z�X�f����g8�`�"����|{&���P�%̈́2�y( �d�p��E�OJ���H�T;�U����0��e�ڥT�b�8�ϮG��ڼA{��B`��=��}�>܁W�CZ
)ݙ?uKX��9���[�d*nq���C�k3jO%��6�7��m��x�M(�\�[��� �a���.N]ǀH���եg�L0(}{�if�������6U�Q9����q� n��Z��t��:M̖��K�7� ��~�����)JN���-��CӜ�i��`���a\�s�"=���@�h�� n�֧��s֟+�p�)�R��}iXB���^0��kÐ�u���L{@,�<}j��o��4�s:��|�>�0˅��s� �\����S�� ���'�v����r�r�C���1�H�[���k��f�h%H��T.GN�
\�JM���қZ�mXmu�;Or3�V��C}l���r�'��0�H;p��9=(�m�h��{��<�G��A>w٣�3�vќ�5,wp桞4��6�)�q���E�x�Q@�y��#''��AI�]-X�2�Z��N:��ެe�i�]Ht�V����^J��gNڪ<����8c,���I*�T�I ta�������k��![UdT([;����Ev��[��CK�ڌ�[1��9in73g����]GSb}P��C��w�� GF{�� Y_k�q�k
������� x�c�´���)�gy6�?5WK�;��5-/�#�[[�HɪZ��.�(��MD㖩����k��̰�� sJuc���Q������mx7UY<Co���+�p2?�?�TiI�i��v��[�o3N�l
��1MpH� 2�<���Z�Z�S$7�m�l���p>���Z��\�RJ ��+$��6� ��C��I�'��J���B���3����[�n��^�9�Uo�R?-���}}�e;��n"^��߾�jGwSX��K�:�$WAa~N94���z6�GOZ)\G�}�����lo[֔^z�\�z�$/��RZ�2[\Eq;�p�57)#�|E��x�@��[�HA�oU�GN�Z�$�V�M�u�7ɭ"�Vn(���#I2A*0H5�x��.�1u'�6���ebͽ���a\�<��5��m��_F�Z8�P9�ۏğʺ��L�Ƥ�����\[�F��NB� ~c�V��Ҹj�J�(燼�4l�pG5�a~>j�v6WRM���V|���,#�U�]�&�z�ur�sE�oO�/���j�.p_��ر��uv>
"6�(�y*��n��c�k��u_4��Ƶe
��-��oo�b8U�1уO�5�ƥ�[&1��ێ���4U9��x\D�;v0��B���IRO&��YN���Wc��VKCx.i�mn�ym#��PpX�=+�to�/���s|NbD�8}��:�]�e�.�C�.i(v��6���2���/��=�l��Rgnb=�ۇ���֕pq���(�p��Zh&����/O���SZ�:6 �+ȝ9S�,��dd���5�h�(拌��hW����g�>�|A3
:�y1� ����/�z��j�<1��!Zw:��p7�B�w� ��ф�����ߙ�j���w-�� �En6�L ��=�OY��>�a�}�W����H��|i����)�P��� <� ��͵�|��26�ɻ�~��\5����JN:���} *��Nrbd~�v�=bA��B�۩�zt�{:�+�p��f=���-;K�Ճ����>o˵uB:��l�E n� A����]I�X��A��* �����t� ��
ʾV��Aө�ʦ�q���.h�7��?��~�&����|;��*�]]��L��n@�W�/��A�k�y����ʮzޭyie��-4�R��ЪG
t ��N9'�k����Rؕ�k�M(��u."�ڞ�
��ӁZ�ˇ]�\�L�i�I����G�5M5%vo&&� ��ʹ�ic�N�9Xy���W�_!�����TX�Imf�)��v���V)� ����hKԏ���*�pOAZGrKB0[,�A�D�J��tV�ib�t��Z*��'5��W�֫����O1�xT^�Dz��5�?
xR�H��II.FR82v?� v�Ky�[#W��I�#̒5�c�Eg�P췒r9\�[&
6n��$�=�ޯ0p�=jd4W� �I��K <�3Qa���;K1�sU�":@YX�q�U�A��R�� �sW��d ����V$ϖfy|���z���bvk���(OQ�%�'�*��zO�4{_�RYa�d���M>ݥ�<��.x�$��
>-���B��$\�'��r��ĭ]��)";+8G��f�p?�Z����G�g�,�lFA$c9�55䁎O<