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/SF625/1181979.jpg',
'FileSize' => '2 MB',
'is_book' => false,
'keywords' => 'Athletics',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF625/',
'path' => 'Library/SF625/1181979',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF625/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF625/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF625/',
'file_name' => '1181979.jpg',
'id' => '1181979',
'sku' => '1181979',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF625/1181979.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF625/1181979.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF625/1181979.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF625/1181979.jpg',
'categorycode' => '5RP',
'moreimages' => '1606268',
'headline' => 'GloHealth National Junior and U23 Track & Field Championships',
'headlineTruncated' => 'GloHealth National Junior and U23 Track & Field Championships',
'caption' => '2 July 2016; Emma O'Brien of Sli Cualann A.C., 404, on her way to winning the Junior Womens 1500m, ahead of Abbie Taylor of Dundrum South Dublin A.C., 100, Aisling Joyce, Claremorris A.C., 329 and Sophie Murphy of Dundrum South Dublin, 119, during the GloHealth National Junior and U23 Track & Field Championships at Tullamore Harriers Stadium in Tullamore, Offaly. Photo by Sam Barnes/Sportsfile',
'DateCreated' => 'Sat, 02 Jul 2016 00:00:00 +0000',
'ShortDate' => '02 Jul 2016',
'LongDate' => 'Saturday 2nd Jul 2016',
'db_DateCreated' => '201607020000',
'event_images_count' => (int) 25,
'event_images_count_text' => '25 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/1606268/',
'w' => '3557',
'h' => '2747',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 3557,
'height' => (int) 2747,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '2 July 2016; Emma O'Brien of Sli Cualann A.C., 404, on her way to winning the Junior Womens 1500m, ahead of Abbie Taylor of Dundrum South Dublin A.C., 100, Aisling Joyce, Claremorris A.C., 329 and Sophie Murphy of Dundrum South Dublin, 119, during the GloHealth National Junior and U23 Track & Field Championships at Tullamore Harriers Stadium in Tullamore, Offaly. Photo by Sam Barnes/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/1181979/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/1181979/'>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%2F1181979&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=GloHealth+National+Junior+and+U23+Track+%26+Field+Championships" 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/1181979&t=GloHealth+National+Junior+and+U23+Track+%26+Field+Championships"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1181979/" 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%2F1181979&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=GloHealth+National+Junior+and+U23+Track+%26+Field+Championships',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/1181979&t=GloHealth+National+Junior+and+U23+Track+%26+Field+Championships',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F1181979&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=GloHealth+National+Junior+and+U23+Track+%26+Field+Championships" 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/1181979&t=GloHealth+National+Junior+and+U23+Track+%26+Field+Championships"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1181979/" 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/SF625/1181979' 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) 4
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) 1758121364.5347
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/SF625/1181979.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) 1758121364.5234,
'_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/1181979',
'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 ,, ��C�Exif MM *
� � :
L V ^( 1 f2 �; ���
��i ��% l ~2 July 2016; Emma O'Brien of Sli Cualann A.C., 404, on her way to winning the Junior Womens 1500m, ahead of Abbie Taylor of Dundrum South Dublin A.C., 100, Aisling Joyce, Claremorris A.C., 329 and Sophie Murphy of Dundrum South Dublin, 119, during the GloHealth National Junior and U23 Track & Field Championships at Tullamore Harriers Stadium in Tullamore, Offaly. Photo by Sam Barnes/Sportsfile NIKON CORPORATION NIKON D3S -� ' -� 'Adobe Photoshop CS6 (Windows) 2016:07:04 10:43:01 Sam Barnes / SPORTSFILE ©SPORTSFILE '�� ��� ��"