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/SF609/1168244.jpg',
'FileSize' => '2 MB',
'is_book' => false,
'keywords' => 'Republic of Ireland, Euros, soccer, FAI, EURO2016France,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF609/',
'path' => 'Library/SF609/1168244',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF609/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF609/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF609/',
'file_name' => '1168244.jpg',
'id' => '1168244',
'sku' => '1168244',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF609/1168244.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF609/1168244.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF609/1168244.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF609/1168244.jpg',
'categorycode' => 'ABC',
'moreimages' => '644294977',
'headline' => 'Republic of Ireland Squad Departure for UEFA EURO2016',
'headlineTruncated' => 'Republic of Ireland Squad Departure for UEFA EURO2016',
'caption' => '8 June 2016; Republic of Ireland players, from left, Richard Keogh, Stephen Ward, Shane Long, Cyrus Christie, John O'Shea, Daryl Murphy and Darren Randolph during the squad's departure for UEFA EURO2016 at Dublin Airport in Dublin, Ireland. Photo by David Maher/Sportsfile',
'DateCreated' => 'Wed, 08 Jun 2016 00:00:00 +0000',
'ShortDate' => '08 Jun 2016',
'LongDate' => 'Wednesday 8th Jun 2016',
'db_DateCreated' => '201606080000',
'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/644294977/',
'w' => '4633',
'h' => '2950',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 4633,
'height' => (int) 2950,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '8 June 2016; Republic of Ireland players, from left, Richard Keogh, Stephen Ward, Shane Long, Cyrus Christie, John O'Shea, Daryl Murphy and Darren Randolph during the squad's departure for UEFA EURO2016 at Dublin Airport in Dublin, Ireland. Photo by David Maher/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/1168244/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/1168244/'>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%2F1168244&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Republic+of+Ireland+Squad+Departure+for+UEFA+EURO2016" 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/1168244&t=Republic+of+Ireland+Squad+Departure+for+UEFA+EURO2016"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1168244/" 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%2F1168244&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Republic+of+Ireland+Squad+Departure+for+UEFA+EURO2016',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/1168244&t=Republic+of+Ireland+Squad+Departure+for+UEFA+EURO2016',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F1168244&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=Republic+of+Ireland+Squad+Departure+for+UEFA+EURO2016" 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/1168244&t=Republic+of+Ireland+Squad+Departure+for+UEFA+EURO2016"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1168244/" 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/SF609/1168244' 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) 3
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) 1758172261.0224
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/SF609/1168244.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) 1758172261.0106,
'_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/1168244',
'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 ,, ��8`Exif MM * � �
� � �( 1 �2 �; ��
(�i 6 �8 June 2016; Republic of Ireland players, from left, Richard Keogh, Stephen Ward, Shane Long, Cyrus Christie, John O'Shea, Daryl Murphy and Darren Randolph during the squad's departure for UEFA EURO2016 at Dublin Airport in Dublin, Ireland. Photo by David Maher/Sportsfile NIKON CORPORATION NIKON D4S -� ' -� 'Adobe Photoshop CS6 (Windows) 2016:06:08 15:27:44 David Maher / SPORTSFILE ©SPORTSFILE (�� �� $�"