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/SF298/232278.jpg',
'FileSize' => '488 KB',
'is_book' => false,
'keywords' => 'rugby',
'real_path' => '/media/images/IMAGES DONE/Library/SF298/',
'path' => 'Library/SF298/232278',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF298/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF298/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF298/',
'file_name' => '232278.jpg',
'id' => '232278',
'sku' => '232278',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF298/232278.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF298/232278.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF298/232278.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF298/232278.jpg',
'categorycode' => 'ANI',
'moreimages' => 'D0701029',
'headline' => 'Ulster Rugby Training',
'headlineTruncated' => 'Ulster Rugby Training',
'caption' => '10 January 2007; Ulster's Andrew Trimble, right, and Tommy Bowe, in action during rugby squad training. Newforge Country Club, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'DateCreated' => 'Wed, 10 Jan 2007 00:00:00 +0000',
'ShortDate' => '10 Jan 2007',
'LongDate' => 'Wednesday 10th Jan 2007',
'db_DateCreated' => '200701100000',
'event_images_count' => (int) 32,
'event_images_count_text' => '32 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0701029/',
'w' => '2458',
'h' => '2408',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2458,
'height' => (int) 2408,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '10 January 2007; Ulster's Andrew Trimble, right, and Tommy Bowe, in action during rugby squad training. Newforge Country Club, Belfast, Co. Antrim. Picture credit: Oliver McVeigh / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/232278/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/232278/'>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%2F232278&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Training" 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/232278&t=Ulster+Rugby+Training"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/232278/" 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%2F232278&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Training',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/232278&t=Ulster+Rugby+Training',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F232278&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Ulster+Rugby+Training" 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/232278&t=Ulster+Rugby+Training"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/232278/" 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/SF298/232278' 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) 1758136007.9239
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/SF298/232278.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) 1758136007.9105,
'_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/232278',
'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 ��6�Exif MM * J R( �i Z �
�� '
�� ' � � �� h � �( � 5� H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �KK��/@P ��ޔ��yL#������]�"��$��A�X��U�!r���>٩��#+N��I_�1U��z*Ĭ�b�hCf�#�N3;fM�urV�^�nn��3��+-��
���t�����ȦI�X�{mU$�$�<��v�}���=�����ZԠ?)���(������u��ڍ/I՞;oMv$�]��p����v T��?08nA�_��7�Ũ�-:�+�C6����ks�&IW�#�nM�hV"�ⲓ枤t*G++�Է22�5�/�s^,-� +��^u�Y[
�J�;�%���3��Gu�0sVfGcdұf89�VΓcp�ͪ�x"���X�Wa$�Z&��*ς�md�Z+�x�-
W��u��x��;t�o �IW뚷0�24۲��uG�JI��P�\�MM6�چ�\7��'�MIrŲZ�����[[,q�)�5[dux�>^��pkSS��h��v�Z�Gңis��i�ѵmj�(/S��Z�h�b�[�*f۵6�7|�����ʶ�c}�6!�;+���y�.�a#�����g�se��[K�<1�Oe��{����i �*q� �H�*я+h��>c�/�Zx�e�����ض� �rz��W �<�)R��VQ�*9f���O��<7>\v�s����p;� ��{����ᦍf���'23��pOs��u��*�r����� �G��5m2�Im��-㈤�
�<��>Q������6��یt� ���Q�c��������V�<2eq�=+��Ǔ&�H����O�CGM�F�&�@��\�����q�f�o�d�.�̄�'ڊ������Z���%�1�<Tp}��'�<��8��s���J�Rܦ��^+c�X�Ӊ7e��Ң���b[�w�+q�Z̊_�Ga�AI+$�l��u8���n��G��(<�U˥��gIg4pD�pOL�V��5���*�$�P���WGSk�i
wq�x�ZԮ�uHS[ʯ2@~�*�t}ȯK��4�;N�|6QJ-6�������.G�<zS\�wgT�P0~ �?�e�}����J��Ӧ��4�̏�O�UC��Ga^y4�3y*�\��� ���և4���0�K��:W�g�����B����#!FѴ�#�<3�O�^�d�e�����ir�fI~�c���c=��"�c��w=��e楦[iV�_=�\[�qU0�
��_xs�
x��7�X�-��G�kX,��!�RB��}
�t�=sXQ���Gfx�Xg���r1O��:�RGv%�S#�d�nx~Փ]����Ni�{�}
˶��� �����Y!_�*�/��y�R�I �T���h�L�
�Y��L'�z�Gsz
��[��c9�8�T�����>�陴Ig�<�4��x� �$VW/��Jg=i��ǎ�f��r�zg�n�h|��S�4��õ+�~�>��I�9'=�Kh4�:;�fѝ5[��K@���D�<�� Bp=��L��q�B�ö�[����^����Y|��ر$:�zR�n�t��4�y���Z[��i�?4�E; ��,^I��!��0H�^����:=7�B�X��H��]W
{e#.J�ne�$��r1�tǡ(�ly�M;�~:��-.�A{o$:�3#�</�+�\���# �-�kcöڍ�K�IBcM�����s�p�ySrri�� C�W� j6�"�-l�������pA �1#kgs��Mzw�Wgf4�R���0J0�-����L���E5Q���G�z���r�2EEP���2��:��fC��UᵊM\t*�M5���@� �}z8�e�?J��-7���U> ����m�]��99�E͞�-�Ϗ���u��p^F`�`F�cc���f[KX�j*���}�i\ �i4+��i�.��c��
-'�����rFv�kW$�5wV�$ )�8�D5��w�D]��<T�sEe��9l���ݔ^!�����[�Aq�=wJ2v�1�'��)��:k��+�^��zjs
>��Y�� �ɐ�\m�Ã�
wP��W�aRO�� *��kH��Ao#Df��,�62���z�G���7����� '�Gٜ��Z.������\D���G�|.�,�-�CٚX�o,�f�Ln.����`�<��^��S�KMTEI*��?vc�:���WMX� ��+��/4ص9�D�h]��� �W pwr{�W�|N��t�;M�9/tk��\��D�� ���9Ws���5�)F��jsb�5�Ǚ��'$�֬�*6�y�����-H�<�N
u� K�,�eJ�T>����Į�8أ��7�&�~p2���ʎ�,�G�]�v��\�cѯ�%����n�c���A$����VW��h_O5� �[8�\�'��*� |c>�2���kh6���i4[K��I��Ԛ=J�1�I$�|��@�\��.v pfr*jbg�DX� �V�%\�SZk�S\��O�;�ܶ�8dN��1w6=B1�pk����N�t��<�s�m��Sl����y�q�0G|�e9>En�2J�L�Gk��lo�y�����9luo����=Fqr0�O��*�x�T�oBVǢ�8�dzo����^��]� �I �� ����t�D������iғ34���`}3�b8<�8�\U���zZ�G�����wxkQ�t�3�
��
�g��f�ffUU듞�י��}_S��V�����å�[G���0pp~�,䞥��`
�����c��4���b�4-?�B��B�`��vȋ��s��p���Nb���m=�g_ܒ�S�j���7����]_����_ ���
�'��۩��pF2=k�RG,����Fn�&rɕnqEU��뗗/~�H<�f�r�21�Mr��!��|�O�3��*+8�� ޒu櫡�Q���Q*D��j�V�(�+Fˑ�9���R]v�\�$\*Y��U8b�Al�x�E(��̷�Ex�̓��$�t �J��1�"����p�2��L}�sk;H�;$�#�H�}���~
JdYOp����@�!F�A�3�$� �T����i7���\����qmimt��L%B�8�P�v`3���l<5��]oQ��0�/m
�{�l���+*t�{�Z4����V�u���/I�bђ�S]A��KC\숤q;�2��i9/�+���CA�[mBM�#p�ʙ��a�~�T��BO�5<
����S�D_k`�� �x�V���Ƴ��|g`Y�5�d��H� �O�E�ï(�ڤR�yT!8Ͽ�6y����t��p~�%����]�8?2�3ӥW] �`bâ�Ⱌ�1�WF��q��
�m����j0F,�*Ɵo-�ہ0���Y4v\n�f����s�6 �Cr&�ao�E�H���$s �m��;
[���tX�J��i��j���B[j������ m66�d�J� is��wr]�"�x,�=s�[15)`�W�yĜ�=�+�u�|j��3��(T��x �:kJjڳ)��M�*�8=�>��]���vZŕ��LQ�Dݜ�`$� �1V�*����U���;=3Z�|Ik��j�;MH-�J�`@^6ur�� � �<���cq�ݾ���~g�a�A#��V��*�5(������?��P�Zu�\[y%n�RHo58|S$H���$V���Z��b����j��r�)[�~�X)*c��Rv�$3�i-�zԚ�1���n�� �0
$n�,m������WѾ&�>#����#�H�]�<�q�dB3��Sw���x��
��]wÉ-�(x*Ə�4��OS�D:��ߌ~=��I�ۑ���=�seFM�������0��W\a�����m��ka��t����$���d�ߞ��Gbzf��\�D�mT'o<[�>�mg.85�w9�V��3l��ɣ���}D4��婽u;�4�T��x�qY��ʍ�)�%��2�N|���U�-7R��Emӱ8+�����#CR��� �Cd�
q /�Hr�{x�<�d�'$!�?�t{�A�x���c�f��mx��Ee�%�� �u�%%�ؚ��l���Ւ[��$�&eR�"8@b��q�y�Uf�u�n%2I�E�0��p=��z��#<yw��#n�2�F$ry��Ѵ�/��i��;�Ha6Z| ����oFp0�y8�J�7��|7�eX.���Y���o�k{�:yr�-�ׂJ�?t�5y3]O�W"9��q�OQ�})���4���E�d�,���G�Ҭ�����G�
��ҽ��x�Z�q}&Y��A h�#ֵ�gO+y�pl�}���X��+:*�!�[^B��ۆ�3j��l|�J��a�f�ۓ�4V�VGv��g�F#$ջ�qmh.Bry��S���5�a�l19,s�ޭZ��+����Ij;�/`{fEx�8��D���`��l�9
���5���v,8�k;�Hд��n�ℇs6{�������е��.��
Z�O�K��Z69BHf^J*�v��� p(�~Gm�p����Ǟji�ټ=���ʲ���m����$�s�c�:��iXr��"g��SW���[�1�US��VGhV)��y�� �yO&�c��g��=��WV�qAr2f.;��@�k�q�aGY��|w�Em}=�K�2�2sӨ��*����SA�a�4[�cs+#F������A�.�잇a�/��5� ��CX�kK��f��Ri��� � �ɯ/�d��nj���N\��5�6��o���=�pɣ�j]��b`���� k�?f� x��x�Y�-c�����[Lؖs��]��2 nFG��5oQBwk����4RA�s^���-�<���TQ�f3g�Nͫݜ�����y&���X���֊��,�$[�����ִ���[A�q9�EE�c�洆tF�? ����{�m�������)n\�KW���1"��;U�+$���Y�,y4Zý�� n��q�ڕ,"��d$���Rz
�_�l�4�s:jm3���:G
�l����3,�����A'$gБ�"�y���=�I1%����#��kl��0<���|)qcWv?i�S�]��f���i(�ܺt�4c�w��W�m�MR��m���T�1̏��\eї9#6�$xo��B���G��q,�qڌF\�
H�~�,Nzdu=��ǑIk&��o��+ʤ+5h���Q��൞������4%u)c%���)�+��Ό�뜎T��y��|k�x#W���6�-��Pљ�B�VE�r��Ȯ)$�c��QSf$A�d o�òF�7��x/�/�|H�us�=�r&�\H���'��=�t)��#��
��M՞�=��d����1� |���I�S-�:��Φ ���O���V3��z
<��Q�*<�Ku�3��z?�WA|d�]8���#��X��w d��?�T�a�^�
�zQ@��K����wV���jz�Ҳ��ҝ��Om��P���z�%ڍ��jyn��b���s1�v�#8 ��A�)����@=)�
,[=��5��GRk��u�XXnS�ԥ�nVG1y����$.�<f��uHvG��je{�xCU�"���C����M����t���F���wy��^,Dy��P�����0A;�=�MFM�q�
����f�Lj����J�j��}��?��y�(����S��ь1��|?2Gkk�{�m>���y���DPǂ� '�����q��JQ�����c��Q�Ri��u;x���K-CM�L���;��L�U����g�q�>�h�zv��$��UH!�$����y�'��{�)�7���ul���>R�bٔ��?Ze�ċ(�r�/�*��&W����s:�Ļ�Y�� ?����<my�] �6�Iu�*xb-3oH�&��y��I���Vm7����}Oq��v�M�w�,]�'y5��^���c�n���G#q��J#.���epC�(�.t����ZBq��[Y[��#Q�z�E�6���V�J��n!�J��%�R9�G��/a�t7>�F� B� �zN�s$����ڛ�˩n�A��˙�T�#�5V>3d%��� j��s��XP����+M�a��^Dl�4�qZ�� hp�sz��9���\�����l��Z�g��x�5��C2��*vL����ӑ�G5�V� -u����n� �w�H�|�� :|�5͈�~�M)�M\K_���]��ܒ7����/,�p�k�pN ��� �Y7�gdb!ӠdX"H�)���b[9$�c��*oޒ� 3�Z-r�߹��ݵb�z����.6�?�b�#[M�Z�ݭ��Y�/�nv~�k1���ҽ{���O�C��so��+�2��+��<�q���5;��<��K�d���6Wb�>ϵy-��c>ٮ���h��/�U�|�FӞA��8O�w"I�o��Kg�mN� ��y�X}+����FE:ѳЄX�u*
�Eg�Fވ-�$ o�z��h��8F��Z�h"�(TQ�����%�|��:�J�Dξ�;x��f�T��<=s���1�
���=�:Mn�F����rQY��i5�I�ۀ;�N�nb豫�[�y�qW|t���T'