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/SF235/198613.jpg',
'FileSize' => '464 KB',
'is_book' => false,
'keywords' => 'Hurling',
'real_path' => '/media/images/IMAGES DONE/Library/SF235/',
'path' => 'Library/SF235/198613',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/',
'file_name' => '198613.jpg',
'id' => '198613',
'sku' => '198613',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198613.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198613.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF235/198613.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF235/198613.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0601108',
'headline' => 'Dublin v Wexford - Walsh Cup',
'headlineTruncated' => 'Dublin v Wexford - Walsh Cup',
'caption' => '29 January 2006; Wexford manager Seamus Murphy. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'DateCreated' => 'Sun, 29 Jan 2006 00:00:00 +0000',
'ShortDate' => '29 Jan 2006',
'LongDate' => 'Sunday 29th Jan 2006',
'db_DateCreated' => '200601290000',
'event_images_count' => (int) 42,
'event_images_count_text' => '42 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/D0601108/',
'w' => '2464',
'h' => '1704',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 2464,
'height' => (int) 1704,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '29 January 2006; Wexford manager Seamus Murphy. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/198613/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/198613/'>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%2F198613&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup" 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/198613&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198613/" 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%2F198613&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/198613&t=Dublin+v+Wexford+-+Walsh+Cup',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F198613&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Dublin+v+Wexford+-+Walsh+Cup" 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/198613&t=Dublin+v+Wexford+-+Walsh+Cup"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/198613/" 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/SF235/198613' 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) 23
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) 1758082448.8729
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/SF235/198613.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) 1758082448.3842,
'_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/198613',
'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
�� '
�� ' � �� � � �( � N H H ��� JFIF H H �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ��P˓U$'��E�OCXȲ@�w��k&�Lp�ޝ�R�*��ԋ!�Z9GtH��Z�e��&���&jUz�Kc���OZ$>���&ZB�b�A4��v�B*�J�R�Yf'#��,̖�����I��Ru Ӣ=@�5���%)�����*tPy��9�p8;\?�v)"ͮ�u)���i���1��{Qu�j6�[:�d��G�H,ޥy!�8�Y��MV4Z�<9�>����%L�{�L ^:���Rh�Ԋ�J�4ꡉ�zJ��4�R!����W�3�k.�0�Vq��@�Z�wt���A����X���,�2�I���Xdnn1��`+I5]� ֚$w7����-�>�&�9�q�OX���Y�/��4�js��j��\ȑ�P#c��~�R��]���6�n�;RY@<���1ҸgQA�wӤ�-�f�xt�m)�ai�"e#���mǯ}+�W�Ie0�����,2U[Ӧ�S֪�E&e���
MH
t��$S�R+qX�pz���_-�'��2F ����7� N\��f��jZ&�6����X��ĐL�Xzp{��j�ni�ؑ^�V⁎�&� L�*D5��SLV6'Z˾L�^�8��Z�VYQ���W+%�M4��<I��KCh�Nf;�Y����6��lxR�K�^�r�6� �$�}� N@��˖
�4�4�;]/V�D[V[�X.[�Y�=;.����=
�i��fV 9��oO�My5U���w=F�K�U����H���
G�
�V�të�gͲQ��v8^���O2M,4�eb��8=��H&xf��6)$n�YA�r1M
^�>txjr�
\�`�K�mj�I�#�وu5q�#��&�;0s�{�ōg�^9�3m{�j6V�'�K7�!M�|m���I#8����~�����[�{�۽�0$�
�p<�N����;jamZM�?�v*����V�V���6���-$���L$���8*���{��g�^ռ#�K�Z�ʺ�nA�2�HF��@kTrV���dy�y��}&��Y���:�\NJ�!eTo�+ؑ�vy��<�''���?J�b���\�z��u&G\�/�# r9� >���ڜvV�#��Ο0G��܌����rև2H�.]N�A������Y"��DV�jH����X�<���[�I�c�č�����x���c����6RIX���W"��
^\�'���Y�w��F5�N�k���?�4�i��Z�5��a~ңr���6}��Rk��״����KqA�Ԉp<՛ d���|�A���J�H�6�h��h��im����H��^�-����d ,�а�Ƣ2�S�{��7s�|U��3U� �Kk��g#�����
� ?�b�
���g�|}��&�b���M��C�����3�
d� �I%먫Q���ώ|[�xR�Zx�J����D��f9J6���!�q���|�zѣ�i�f/��K�qY�B��ߺ��q^[�+�/�&�7��Oa��+֛9)�)��B�0Ė����h�9�H?��Y��z3�;g&��iZS$��{�?¥���|x5ԥ�iJ�®܌{�����n��;@���Ga��c����+�g��z&{'�/�؎'lf�� �`�d�����F\�GV7ߣo��߶���K<~k��V�#/"6�B��b?�a�{��}���d� i��F@�z͗]���9-�V:�X��֔)s���N\�cyqot�qJ�x���+��2ê7�Rx>�Ŷ��jIKT^�f�'Y[t`�'���Wc�|T�E���y �Y�Ɗ�d+���?�u�H�kB����_>#Yx�������ı]��i�+n*J��b>P,�<d��=<~kZt� ��/ȫ>G��/!U�O
M��M��Ro^�Ɲ>;1�5�M�Y� ?:��0��!u�Q��a���zY�1�R�O�IGM�G{d����,w���P]��X���z��ռ`�qԴ\�&��̛&���p��=:��iV��lw,"�|��rN�ڃ� Q�T�ҽ��RR��
|�:��s��pb�gtu`��_
F�U\*:���O��tZ~�W"g��`8����=k�N��R
Qi�;���E������.���MxLc|�%H�em�:�}+�=��5�P�T�Ϝ�(�I.��=ic��8O���+�Ց��d�UX�]8wh�5�f����-��$��9�C���z�[�I��rBN�W%zo���(�R���_���R��J��b��1M<�M��O�4���n(��ꟼH�\ꔫK�=N�VT����9����B�{������̒�]�Rj0��kh��
Ok9!�.�QR�˺!�$i��E9,�W0 \�C�������1���c��n�`�/sۓAG�l\�2�[�����Tw ;�5��ڔ�T�%��"E�[>�f����]��UK�
uH���%���jZ&߆�ppGq�+�~ ��֖�\����Lo^݇��){�8]*ߦ����_j��<�D0ł�8 ��}AZ���H�9�a�ضF:��c��#>�$�,-%6�-�ً����p�G��l�̰+���c3K��sܞ�.2zMYY�'F�~{҇�T�[���c��@��fߨ�\������K�%nA�h���iiysl�mv3��~�G ���<�;�l�Z��)ᐂ�y�7�cL���Q�x��K;43�2p��0�:�ٮ���x�Ŗ�ǦB��s���pU�
�<�Ү���ۖ���� 1 �&�j��[�i��c����QIܣK�ߦk&Hc��2���_nk�T���#+hB�|Ls�F�1(�Q�]�/ گlfYNT�ⲜMb��=S�O��+U�Xl.�Έe�'C��Qܩ�;�a������Z?��A{m\[�i3��۳��#��=��*sBnQ�c�(ڭ�o�
��}�o;�Jw`�$����pG�Ï��2 ���^�G-&��x"x��t���������i�[S���RFŷ=�I�<� @� W�V��9E)�uc��/�Z�{w��I�Cx�G�úc?$�:G8�_<~Ҿ��_o4�=����f䄓!��$I ��zz�s�8�*>�)=�4�K��]�w<{����̱p��~n�G�Vf�#"��yt.;\�p0IcF�,�.z�=��ZkV�C,��o,r��,HU ��<�����^�s����"��:L��#"ܕ����|��^��{='M�n|Ey�X[�YE�"��(pRîv��^*�h����i��5�0��NW�*�QI2���� �h/��s�YRH#oW�+%da
H�X�3�:Ӓi!b�Lў����Y���m�[-R %�bx�c/⽿ʻ��ھ���C�k70Z��c�`pU��y`�|:��O��o�α�� HU�2��k�</���LY1�q�d_�\؈�64�=Y��Dݖ%]z���^�Q�Y]$��/�dU�� �A��<��)�GeG�|^�/�?&�'�]z�A7Dn^TR�w��X]�O?�ǽq�!�����<Q�X%�m)I wr͎�� ��G95�a�;��hy��\jA����� u<
�yq�R4? 9$w5�Q��l�:�/w ���A�>� ��@G~ކ�[��b0��99�T�7.� �����lj,�?�M��̻]7��ǥz7�h������� I���W�9����\�"���W���zמА����<5�)_HAɑ�<�vA�gK>S��W�{��S�fa��y�"�
�~Y1���m��X�V�Z�J�̎M����G���h]���{K�V��so �$��v�� �u�]��+e2
�Ō�rI�l���qׅ�gu)h�>���5ƅ��O� ��'��&�M=�=��(��k#�q�����r�'������{4��j��w�}[U�~)x��[���Ծ��\��dhЪ��q��?ʹ @:��W�F
�1Z�/^I�OmH'��)!��щ��S��k��CC5���PI�j��"b��9��Ɖ���g�]��<+i�/�>�/|�7���1K$l�
�WV�n����xgG�0k~
��۸�"k`��A�O+��gƷ�,< �:m��1��Ơry ~�ٲ����H�Y4`�5<5M�Lz��Fm�Y$%W�s�Whr�# {�_٣��Ka��� �Ue�aʂ�g:wEBv�H�x���OJ�2L �}��\��
խt���R�e��
�\�ʸ��]�����6�CqW&�� �\���Ӛ��4]ݏT��|Q�]���K�Mf���&�%p�k.O����{w�5�;�
�%��t[��S��+E�v3qg_��S��9�^=Z1�&0K{~gz�8Ps�|q�0�y�����K7��2��Fr�
t�����23���2*{�!а<�Ӛ�j�c�&WQ�3��5^����SR���Ojz��jZe���
�Y����88�Ef���\p�<����T;=��
�jL�^� LHK`� =*���.4� ��i� y� ��Ϊ�Oa$�u<�jz�+��1�ԉP�"d抃C<� *�OD�O/�f|*�������5�9�tsxr?$G,!����5��W�H�y"V8��zwի�� ��a�D�m鷝N)&�n�CڳLN�H��\��їF>6į�#�滟 _\K Q#��pb�v?��Yr{,�v����:i��G��Z�X�T:� �kmT�ɹ��6�Td.Y�e��+�M�L�g{mgo��%���2��Eʌ;��C� ?Ł�ᨺս�E� vb*�:>ϫ<��o-rI<`�Ux�1d���k�n�3��[ݦ�܂�ji�ti��"����h��2چz�i|�
��ן��Z
�?�+�Σ>��l��3��0�
�t֥���=E4�_������K�mg��ECZ}J�Z'�^�ö�`���Q�μu䞆�<c����+�F2�\�v��>Q�皇-,D��R���$y�b�,�2h��5FI�=Oa[���2Fd\���F�q�W��S����n��1�� x�{מ�)n�a���F����S��~��ef�5ubƟg3�����|ЖM���)���~d�>�ԥ���E�RG�g��Q��:�U���p��g5�|:�-�n��څ��D��,� � l��hz��5X�B@
�8�#`U�=�3��^|�:�T�n� �l_M���s��~k��;9���q�>��tIs��M�%��i�����;�N}}�;rEX�K�L�m|<�x��/3��ҕ�p܄f7ЌƢ/
k��_��� �T���G���Z�D`���������r��}���z� A^�8���^Sn^�Gjˡ]MO�<��)�B]��z�5�-bX��o��nr8�㿭]�˅��`��X�$��b��.�R����j*%���f��@\�,�85�(��F�H"��=;gڽ���vFդ��\��Yk�_�HѸ�Q���t��ڮ��x�ݷY]23m �O��k[�;�RW���E���H]Hb�B��s���9��m"�
�T܈pf�N��$/�Ƕ;�$�R-�J�\zƘ�V-��*2�̍ո�{{W�/�Ě՜�(�c�5U���ii�2d@�Ρ����s�ˋ��YI�jQh�O��q��m����Ǹm��+�4����yB;��Y-$� ���@�%��g�Մ���|-���ڿ��`B�Z}�V��c�������^��wD��mt�L�QC"���O����M�`�ўU��:]���� a@��5���@��%X����:L�jw�lm�[e�Uq�� $�������D���tlu'��$e�~����^Z�{n�Z]�a:DA��>�^�8�u�J�oA�X�#x4�B��^�D@>���j[�g��{� }�NqS)Z���ȄMN��X��Q��-\� �li��硫0ط�Me&h�z&�Ed٪9$�F���z���� & }���½�6:����%�.��R9���Oѣ�:�� �(I7v{�V�N<� v�!ۭT�Q��oe�Ӵ�uج�YIjOp�9�I#�G�mk��m�J���9��K�\n�e
�^�iZkZx��T�M���q�n���pG��XF�?ʡw���\�pj�1V<�����"�ִ�d�Iċϗ��3�M�`��n�6��:����[{=z�5� �W$a&�z��>}�sKk��.�xd��>�0�sw$Ф�h��?:��y�x��n�i�@{c*G�֢ڔ�<�U����&��;m6��Nx��H � ��¸=wS�_
^ټ��h� ���z�u�h�2asjڄ�Zm���<d �z��==3ҧ��Y�(�6��w�"�b�Ȗ�Ũ<=N�-#�OJ�4s��^c�n�$M� v�]���f$] d|�4zH�WDɥ�gmY�MP~�Ce$XM?�m���v:��E�����>=��!�y#IeҞU�F�9\��S�'p�<���1�'H�>)X�J�U�:���:������t+E)r��yKA��t�~οٟ���5�#�&��7�g���c��l���\Y,��Է;
��×AYyf<)����{�;ldx���G�Ε�5B�Gp�?�/h ��c�"��o�Y�"�G�ķע���O�F
�����=q�Q���n77�~�o ��'�7s��b7�Tn#wnp �j���U��M_Q}�X�6�t��`���3���8 ����r��_�u�D�MORH��#S.�v�]��APFAnd�Fk�� �Mr�� ڞ3ԯot�ՠy�/y
�YLrŖ�F���-�GIuS�4�}o�~�X��8<Q}oqm�oY|/v<ݲ|����)U9�>��<C���y�ڶ��(�xf�<� 8l�{ԩ�r�y���4j���~6���_� �}윇�r�A ��
C�~�s��k�ᑃƟ�^0�r���AG�"í� e��L���G�n'�;�c8�N~c�A��ݵ�����ܾ'�eW�O�"��ٱ���q�v�iU��yV��gr��
��|C}*:�+�WE�+����i�-8�kڂ�`�o\���s�c߰�\��4�6���|?�m�� �� ��ᘯ��m�� �� ��{'�9�� �c�� ��� � ��ٚ�� �Yg� �-� ��/����=�� ��� [� ��� �5_� ]����]/`��8�o��%v��tQ�q��m��
�1�C�R���!ݲX���r}K1�Nm�7N����!�W�a�G�+��ϻ9��;"��E PE PE PE PE PE ���^Photoshop 3.0 8BIM � BLL 00107106 ABC
BRIAN01409 Hurling7 20060129A Color Factory 8.0P Brian Lawless / SPORTSFILEU
Brian Lawlessg D0601108i Dublin v Wexford - Walsh Cupn
SPORTSFILEt �SPORTSFILEx �29 January 2006; Wexford manager Seamus Murphy. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE� CP_1252�
3468286976� !1E2796C44D1F4509 B94A456F814D8CEC� 543944555324294346�TImage Description: 29 January 2006; Wexford manager Seamus Murphy. Walsh Cup, Dublin v Wexford, Parnell Park, Dublin. Picture credit: Brian Lawless / SPORTSFILE
Orientation: 1
Resolution: 72.000
ResolutionUnit: 2
Software: Adobe Photoshop CS2 Windows
Artist: Brian Lawless / SPORTSFILE
Copyright: ©SPORTSFILE
ColorSpace: 65535
� =E:\SF\CF\TransferSFLibrary\D\IMAGES\IMAGES DONE\Library\SF235�: 8BIM% �C��%?Т1*:$8BIM� H H 8BIM&