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/SF285/225837.jpg',
'FileSize' => '623 KB',
'is_book' => false,
'keywords' => 'Golf',
'real_path' => '/media/images/IMAGES DONE/Library/SF285/',
'path' => 'Library/SF285/225837',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF285/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF285/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF285/',
'file_name' => '225837.jpg',
'id' => '225837',
'sku' => '225837',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF285/225837.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF285/225837.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF285/225837.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF285/225837.jpg',
'categorycode' => 'ABC',
'moreimages' => 'D0610104',
'headline' => 'Darren Clark at new Championship Golf Course in Castle Dargan',
'headlineTruncated' => 'Darren Clark at new Championship Golf Course in Castle Dargan',
'caption' => '16 October 2006; Darren Clarke in action at Castle Dargan's new championship course. Designed by Darren Clarke and Patrick Merrigan, the course will open for full play in 2007. Castle Dargan Estate, Ballygawley, Co.Sligo. Picture credit: James Connolly / SPORTSFILE',
'DateCreated' => 'Mon, 16 Oct 2006 00:00:00 +0000',
'ShortDate' => '16 Oct 2006',
'LongDate' => 'Monday 16th Oct 2006',
'db_DateCreated' => '200610160000',
'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/D0610104/',
'w' => '3104',
'h' => '2144',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 3104,
'height' => (int) 2144,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '16 October 2006; Darren Clarke in action at Castle Dargan's new championship course. Designed by Darren Clarke and Patrick Merrigan, the course will open for full play in 2007. Castle Dargan Estate, Ballygawley, Co.Sligo. Picture credit: James Connolly / SPORTSFILE',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/225837/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/225837/'>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%2F225837&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Darren+Clark+at+new+Championship+Golf+Course+in+Castle+Dargan" 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/225837&t=Darren+Clark+at+new+Championship+Golf+Course+in+Castle+Dargan"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/225837/" 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%2F225837&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Darren+Clark+at+new+Championship+Golf+Course+in+Castle+Dargan',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/225837&t=Darren+Clark+at+new+Championship+Golf+Course+in+Castle+Dargan',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F225837&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Darren+Clark+at+new+Championship+Golf+Course+in+Castle+Dargan" 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/225837&t=Darren+Clark+at+new+Championship+Golf+Course+in+Castle+Dargan"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/225837/" 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/SF285/225837' 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) 2
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) 1758087312.0569
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/SF285/225837.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) 1758087312.047,
'_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/225837',
'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 � � �� hExif MM * J R( �i Z � �� ' �� ' � � � ` � �( � ~ H H ��� JFIF � � �� C !"$"$�� C�� � �! ��
�� � } !1AQa"q2���#B��R��$3br�
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz������������������������������������������������������������������������
�� � w !1AQaq"2�B���� #3R�br�
$4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz����������������������������������������������������������������������� ? ���a�����U�cY�bn��&��.�@
H@u��+%r������8�����jI�E%��%e�Gڥ �nv:-ݰ��-��^���Iy'