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 2/',
'drive' => 'D',
'originalpath' => 'D:/Images/Images Done 2/Library/SF633/1189609.jpg',
'FileSize' => '3 MB',
'is_book' => false,
'keywords' => 'daire brennan, rugby, leinster,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF633/',
'path' => 'Library/SF633/1189609',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF633/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF633/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF633/',
'file_name' => '1189609.jpg',
'id' => '1189609',
'sku' => '1189609',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF633/1189609.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF633/1189609.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF633/1189609.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF633/1189609.jpg',
'categorycode' => '1RP',
'moreimages' => '1607072',
'headline' => 'Bank of Ireland Leinster Rugby Summer Camp - Portlaoise RFC',
'headlineTruncated' => 'Bank of Ireland Leinster Rugby Summer Camp - Portlaoise RFC',
'caption' => '21 July 2016; Josh van der Flier, left, and Ross Molony of Leinster with participants during the Bank of Ireland Leinster Rugby Summer Camp at Portlaoise RFC in Portlaoise, Co. Laois. Photo by Daire Brennan/Sportsfile',
'DateCreated' => 'Thu, 21 Jul 2016 00:00:00 +0000',
'ShortDate' => '21 Jul 2016',
'LongDate' => 'Thursday 21st Jul 2016',
'db_DateCreated' => '201607210000',
'event_images_count' => (int) 26,
'event_images_count_text' => '26 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/1607072/',
'w' => '4928',
'h' => '3340',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 4928,
'height' => (int) 3340,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '21 July 2016; Josh van der Flier, left, and Ross Molony of Leinster with participants during the Bank of Ireland Leinster Rugby Summer Camp at Portlaoise RFC in Portlaoise, Co. Laois. Photo by Daire Brennan/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/1189609/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/1189609/'>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%2F1189609&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Bank+of+Ireland+Leinster+Rugby+Summer+Camp+-+Portlaoise+RFC" 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/1189609&t=Bank+of+Ireland+Leinster+Rugby+Summer+Camp+-+Portlaoise+RFC"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1189609/" 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%2F1189609&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Bank+of+Ireland+Leinster+Rugby+Summer+Camp+-+Portlaoise+RFC',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/1189609&t=Bank+of+Ireland+Leinster+Rugby+Summer+Camp+-+Portlaoise+RFC',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F1189609&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Bank+of+Ireland+Leinster+Rugby+Summer+Camp+-+Portlaoise+RFC" 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/1189609&t=Bank+of+Ireland+Leinster+Rugby+Summer+Camp+-+Portlaoise+RFC"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1189609/" 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/SF633/1189609' 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) 1758088165.8858
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 2/Library/SF633/1189609.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) 1758088165.868,
'_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/1189609',
'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 ��2�Exif MM * J R( �i Z � ) ' ) ' � �� � @ �
2016:07:21 13:06:21 � �( 1� H H ��� JFIF
�� C !"$"$�� C�� � � ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? �^];��3�ب�XU�q�M����Z��<V��9�q����ȥp&��.2�(
Lht����i-��
��!U�2@�i ��* ���
6�I�ǽå #�f3�}@ϖ�#9�TI�m����P���ךW�b�$Qp-���ri\%�<Ӹ}�#�=)s�%�L�T�+���;����@I �
@N �-�y�Qp��v4\T)�,S@\iq���Ff Ӱ\a����������2K��
KC�"���.M �i�W9�22N
U� �0�#��k�4���@� 8̋2C�����R�� �B��2�0��+�>�ȪV�lZ1�j�%��&�w��oP(�N���T�d�0�V��H�ۑ�b��db-LD8Q��s��a\g�w���V�G4����Q�O�CZ
2��<qQ�;��hz�?Zv�,�y�Jø� 4��E�����"��
1\��}��;�b2�z����i]�=�L�%b�x�����d�'́UbGq�@�e�r~YGlQrlK���p�z�WC�k|d���Qp�Y���P�QqY�4�Q���|wN�٠.N��24�=�Q�ށ\�5�rj�M�Y��y�)�W���i�.X��bq�OJM
2�3mܱ�=�R�W,��J�� �F9�Ӹ�X��ib/1�gޓ�,��(����� ��u��,,��+�@H��6&9'�O�>�9��%� 9J�ɱ�[5W�W���N���ZKk�yv�g>r���Il�$u����W��_� �x��G�!դ��D�op,��<d�y �Fr
s���b�U�6�����Ŗ�<1mo�eR�4�>7|�,�U��H�#�9��˪ϣ,|i�E,d��6��Y��`P���:}�k�J#"��w�/u[�X�E�H�'�<��I��p�I d���-KC_�ˁ"�:[�y#.�(T4j�`q�I��|˸?��7h ��qr%0��@q���e܊WC����i�i��P^����"�ɰ����n�\R��r�1�G���Z��!����m%h\9Le>�U��T��CE}YӼC�G��O1�B����� x�Z)'ԋ���kS�����,%������@�)9
3��kzRUٍ���[�2�n����c���O.V�N��q���*}�j�����Z\�[�[γ�O���]n}G4��Kyl�]�cH��`��'~���q��g��}�G�����x�ț#r1V� ��f��`*��=y����m.� �p>�-�Y���@��j��l�ՙSy@X�0})1����@�uv���cB�� S�����,t�4�[`$U!6K
��pM �GO�d�(X|����y�"�*�l�Y&u���U�r6�L�L5?5�����G��ݘm߃���yN���n;�[�%-+��3�#$dz��٩��v�#9��Ȑ���o �g�<c�[�K��8.`��YI <+q�`VV��*ȼ�3�l%�'�%��6�@<u�N5"�g��ۋ�H�m�FNUr'=q�g�NoTN�Y�$Y���[q(�x'��涆ہ�x8Z�hӋ�n�h.C�Q��
�3��0rW�{�u%g�݃�d��L����� ������̈́c��g��rx��5RV^�g-H�v����:V�my�ꚋ�n�'�4�'�
�l�á�\cZr�c���v���cy�A����,�s�4M���m�cu]�QϽDc8��ڣ���ʚk���j�[�B�q���-�h~��J D�ʿ)8@2y�J5')���廳4tψ^/x~�M�,ש�I鰢���
��
Í�q<�s��%�������m(��ķ�e���\��+�.6;m8|���ZIi��\<�5����|c�x|(е��V`��$�B�n�Wv1�݀y5��yI��ݍ-S⧋u_G��^#�-B�G��TS��/��#�T7`O<պ����:�O���˪��ga-�@�۷�
�~Q� yݎ),]f��+#� �!x�R8��t�x�li�˸n%~v�s��s�t�I��䇢��"k������_�8�ɵH,1ʓ�N�~����arm;��īD�l�|@�g�<SyeQ~��.��a�"�����}0�NQ��s��О�4�}fo���7���3� �h,x�:�֞)K�яC�����!���%�\[���I� �$���M+��m��i����L��;�Bdae; ��#��8�sο;p���G�i��N��^ϫj3��\<e�q��rH�W��+*n.�l��<#�;-&c�#5��f�b�5 �ı^�'n1����mOo��'ʺ�jR���i�i+�'�n�B��8-n=JS�_[۩*��x(wϷ�j�9=�����t��v}��'�ST�mk�"孎�feC������D�B���:o4Dj�M���f#��~}�8�j�F+�����2��O�7R-bY/!����14 |�:��'�q� �p�aV�-�[�M�rok�i�+qx�~�|�"�� ���)�=~V?0?J��Ц�n�Z���� ����|M�ɬ���GS+=��Hs"�8�͎ 8
���N��;������Kvj�A]'O��Ų�Ӥic{b��ʜ.�E�!��H�f�[�(JW���_�5�(�E-����k�d��i���_i��#v
H=C��>�\}
���J�_k뱞�sP��;�
Yh^3����E�d�7�ev3.� �t��Fk��q�S���{��}�ڔ�3��2_C����������9'�&��h%�# �n���!AM��7�ﯞ̦�Eh� �c�x���kWZ�h����c-��K3�L��`qƑ�e.U��#�N��jr>�`��m�Y�vӧ�����a�d;@/�8�Ǩ�UJ�}�|4#)���-�Om��.X�K,~\�1� �_�`��g�L���:��Bp��ʞ�E�ñj+��]���2����B��ߊ�%-6�ь �S�{��%��'���[F78K:�����ǩ闚l���;�g��p0p�g�x㧭kR�JvS�W�%%-�bo��rRY�s*7#�}2=G�4��&���YZ7��
c �ĎF�#�SYJ��4t�Zؓ�ZDr�����Q\1?t⒣�%pN�j
�W�BX[Z�襙 V�Y�f.�.ޤ�L�[� �����y��Q��p�q��ϭ$�n�,�+[6
���~���7��ϥę�x�"�g���T�g
�A��9��Ts0���o��}b�U�����1�������s�����*7��?�!д�\�D@��*��S�
�>/�趠�K������\���+C�t��k]0���i{$e��@�S��"����rq}��=UR�[lq��w���� KMZ�O�m�y|Ջ�� �R���|�3^�i��&�u�،<� 5;k�_���n�K���$�#���G�7����H0L���wF>e �f=EwW�ʶR��~�'~�n�l�g���y���b=]�c�����Xi�αq}�ioikw|�V%�T� C��g�( ���r��+Q�X%�I����}���v{Ui�z~?�<*�����4A�I%����"��9�2��`����$p1����2�!C�ڕ�o��wKM�Z��E*K��m�3�Agqw~5Ǝ����%��$P���1��ɯIR�N�������{�z��u'/i.�}�#2;9n�M*� �]�������HvƄ#�$���Ȯz���u��oO��Rt�Q���N��|"x�MJ�\@'�"�#��B#�o���9d�U%W�(t{�v�C����Ɵ+�^�y��c� ��{�k�����@�3�H�DL����"��m<c#��u0�i+_U��鲰�uc��R��w�i����3]�Zǩy�3��%���
Ł mDd�F ��rކE���)N�Z���sY|��o��~�p�{�U�Wm�]/W�2����Aeyz�:����'<gql(����_[G/��T�N7mm�橊�[�M輊zN�e��� ��ӭ5;��ǕʿvET�\���c0����U �����]}]��w���*q�a���]���O����ΫľԼQ�X�IU�m�{u8�Dq�#E#��w͌ͫէST��.�w��僥IsB�۩���[�B�u��I%&��yk2��ː�_�:�k��)��jQ�̏jk1��Ar�|;� Ķ��,��m.��EËiJ�o�t�~}D�?�<K4�bEb��J����!���>oW<�U,u5�Ñ�R�9�
�(��|����б�m�r2$���d,4Y ���'����r��������ء0�LАЁ� �ۨ�
d~ݺ���9]�8���`��}�ϧ?�z6��\��RMd&17��Wv�PH u�#z⺰K�� ��7�x�M�~�GI�.�nd�N{��"� idh�G����
�&�kS�LL����]NM�f7�m^�]F�Ɍ�Z+�̃zFa�v�v��K�)���R�R��/o]>� 3��T%'k�G{� Q�t���W|5'Rmٽ��ѫ�8�ޱ���uy��c�|7��V�`{#-����ȌY�0R8;s������F��ݭ�͐�IӔ��v��<q����ŝ��ǃ���1�rX�TO=}�Ids�5:\}��p��UW-X&g�hsO��j`�Tդ�8�5�ģ{y��~S��^��[��b=�]�� �Ia�h�����f�,#�b�M*�e�m�ũ�%$��?e��;�3ǥ��o�� �G��}���3�z5��o��gc��UT4nѝ۲�C�@#�u5�6գh���ﭟ���;�'N��#̼Z�EŜ�GqvIG��YNN9�}���%S��o�}� �c���qJ?�tm�4�7�X�gž��}R��<+����>&�P��*��D�ME���kr�rʬ�>^W� �G9�B��y��+/��^�\kԍF.ɻ����z-�ōu�̺��KS����n���2*���A�d(A�l��
��v�컘OVIFR���c�7W���-���e�a�0�̀#S����l%*r�Z��2�Z_M���f��s���m3�
��q�����('�� ��q,I�`H e�'