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/SF1118/1774384.jpg',
'FileSize' => '1 MB',
'is_book' => false,
'keywords' => 'FAI, Soccer,',
'real_path' => '/media/images/IMAGES DONE 2/Library/SF1118/',
'path' => 'Library/SF1118/1774384',
'file_path' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1118/',
'file_pathBig' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF1118/',
'file_pathSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1118/',
'file_name' => '1774384.jpg',
'id' => '1774384',
'sku' => '1774384',
'image' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1118/1774384.jpg',
'imageBig' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1118/1774384.jpg',
'imageBigPreview' => 'https://www.sportsfile.com/web/winshare/w540/Library/SF1118/1774384.jpg',
'imageSmall' => 'https://www.sportsfile.com/web/winshare/p180/Library/SF1118/1774384.jpg',
'categorycode' => 'ABC',
'moreimages' => '775387616',
'headline' => 'UCD v Letterkenny Rovers - Extra.ie FAI Cup First Round',
'headlineTruncated' => 'UCD v Letterkenny Rovers - Extra.ie FAI Cup First Round',
'caption' => '11 August 2019; BJ Banda of Letterkenny Rovers shoots to score his side's first goal, despite the attention of Jack Keaney of UCD, during the Extra.ie FAI Cup First Round match between UCD and Letterkenny Rovers at UCD Bowl in Belfield, Dublin. Photo by Seb Daly/Sportsfile',
'DateCreated' => 'Sun, 11 Aug 2019 00:00:00 +0000',
'ShortDate' => '11 Aug 2019',
'LongDate' => 'Sunday 11th Aug 2019',
'db_DateCreated' => '201908110000',
'event_images_count' => (int) 24,
'event_images_count_text' => '24 Images',
'parent_block' => '',
'parent_block_class' => '',
'image_link_url' => 'https://www.sportsfile.com/more-images/775387616/',
'w' => '3375',
'h' => '2631',
'dimensions' => 'width='180'',
'mobile_dimensions' => 'style="width:100%;"',
'orientation' => 'horizontal',
'iptc_leadimage' => 'False',
'is_editorial' => 'false',
'is_hidden' => 'false',
'width' => (int) 3375,
'height' => (int) 2631,
'display_priority_timestamp' => (int) 0,
'event_group_lead_image' => 'f',
'page_sort' => (int) 0,
'date_sort' => (int) 0,
'display' => 'true',
'reindex' => 'false',
'alt' => '11 August 2019; BJ Banda of Letterkenny Rovers shoots to score his side's first goal, despite the attention of Jack Keaney of UCD, during the Extra.ie FAI Cup First Round match between UCD and Letterkenny Rovers at UCD Bowl in Belfield, Dublin. Photo by Seb Daly/Sportsfile',
'folderid' => (int) 5000,
'link' => 'https://www.sportsfile.com/id/1774384/',
'purchase_item' => true,
'button' => '<a href='https://www.sportsfile.com/id/1774384/'>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%2F1774384&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=UCD+v+Letterkenny+Rovers+-+Extra.ie+FAI+Cup+First+Round" 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/1774384&t=UCD+v+Letterkenny+Rovers+-+Extra.ie+FAI+Cup+First+Round"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1774384/" 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%2F1774384&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=UCD+v+Letterkenny+Rovers+-+Extra.ie+FAI+Cup+First+Round',
'facebook_share_link' => 'https://www.facebook.com/sharer/sharer.php?u=https://www.sportsfile.com/id/1774384&t=UCD+v+Letterkenny+Rovers+-+Extra.ie+FAI+Cup+First+Round',
'gallery_actions' => '<div class="gallery-actions">
<a href="https://twitter.com/intent/tweet?url=https%3A%2F%2Fwww.sportsfile.com%2Fid%2F1774384&via=sportsfile&related=sportsfile%3AIreland%27s+largest+sports+photography+agency.&text=UCD+v+Letterkenny+Rovers+-+Extra.ie+FAI+Cup+First+Round" 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/1774384&t=UCD+v+Letterkenny+Rovers+-+Extra.ie+FAI+Cup+First+Round"><div class="icon-medium icon-medium-facebook"></div></a>
<a href="https://www.sportsfile.com/id/1774384/" 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/SF1118/1774384' 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) 18
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) 1758120096.299
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/SF1118/1774384.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) 1758120096.2712,
'_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/1774384',
'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 ,, ��3�Exif MM * � � � � �( 1 "