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/SF1083/1658457.jpg',
'FileSize' => '2 MB',
'is_book' => false,
'keywords' => 'Soccer',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF1083/',
'path' => 'Library/SF1083/1658457',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1083/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF1083/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1083/',
'file_name' => '1658457.jpg',
'id' => '1658457',
'sku' => '1658457',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1083/1658457.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1083/1658457.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF1083/1658457.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1083/1658457.jpg',
'categorycode' => '1RP',
'moreimages' => '1903001',
'headline' => 'UEFA Masterclass in partnership with the Federation of Irish Sport',
'headlineTruncated' => 'UEFA Masterclass in partnership with the Federation of Irish Sport',
'caption' => '1 March 2019; Noel Mooney, Head of National Association Development, UEFA, left, Mary O’Connor, CEO, Federation of Irish Sport, centre, and Roddy Guiney, Chairman of Federation of Irish Sport, during the UEFA Masterclass in partnership with the Federation of Irish Sport at the Aviva Stadium in Dublin. Photo by Seb Daly/Sportsfile',
'DateCreated' => 'Fri, 01 Mar 2019 00:00:00 +0000',
'ShortDate' => '01 Mar 2019',
'LongDate' => 'Friday 1st Mar 2019',
'db_DateCreated' => '201903010000',
'event_images_count' => (int) 45,
'event_images_count_text' => '45 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/1903001/',
'w' => '4153',
'h' => '3097',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 4153,
'height' => (int) 3097,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '1 March 2019; Noel Mooney, Head of National Association Development, UEFA, left, Mary O’Connor, CEO, Federation of Irish Sport, centre, and Roddy Guiney, Chairman of Federation of Irish Sport, during the UEFA Masterclass in partnership with the Federation of Irish Sport at the Aviva Stadium in Dublin. Photo by Seb Daly/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/1658457/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/1658457/'>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%2F1658457&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=UEFA+Masterclass+in+partnership+with+the+Federation+of+Irish+Sport" 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/1658457&t=UEFA+Masterclass+in+partnership+with+the+Federation+of+Irish+Sport"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1658457/" 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%2F1658457&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=UEFA+Masterclass+in+partnership+with+the+Federation+of+Irish+Sport',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/1658457&t=UEFA+Masterclass+in+partnership+with+the+Federation+of+Irish+Sport',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F1658457&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=UEFA+Masterclass+in+partnership+with+the+Federation+of+Irish+Sport" 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/1658457&t=UEFA+Masterclass+in+partnership+with+the+Federation+of+Irish+Sport"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1658457/" 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/SF1083/1658457' 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) 5
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) 1758167503.6504
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/SF1083/1658457.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) 1758167503.6366,
'_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/1658457',
'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 ,, ��,`Exif MM *
O � �
( 1 &2 D; X��
n�i |�% . @1 March 2019; Noel Mooney, Head of National Association Development, UEFA, left, Mary O’Connor, CEO, Federation of Irish Sport, centre, and Roddy Guiney, Chairman of Federation of Irish Sport, during the UEFA Masterclass in partnership with the Federation of Irish Sport at the Aviva Stadium in Dublin. Photo by Seb Daly/Sportsfile NIKON CORPORATION NIKON D4S -� ' -� 'Adobe Photoshop CC (Windows) 2019:03:01 10:56:18 Seb Daly / SPORTSFILE ©SPORTSFILE '�� V�� ^�"