get_results("SELECT ID FROM ".$wpPrefix."posts WHERE guid = '$path'");
$main_url = '';
$final_url = '';
if(empty($postid_main)){
if ( preg_match( '/^(.*)(\-\d*x\d*)(\.\w{1,})/i', $path, $matches ) ){
$url = $matches[1] . $matches[3];
$post_id = $wpdb->get_results("SELECT ID, guid FROM ".$wpPrefix."posts WHERE guid = '$url'");
if(!empty($post_id)){
$main_url = $post_id[0]->guid;
$postID = $post_id[0]->ID;
$postmeta = $wpdb->get_results("SELECT * FROM ".$wpPrefix."postmeta WHERE meta_key = '_wp_attached_file' && post_id = '$postID'");
if(!empty($postmeta)){
$metaValue = $postmeta[0]->meta_value;
$meta_media_name = basename($metaValue);
$media_name = basename($main_url);
if($media_name != $meta_media_name){
$final_url = str_replace($media_name, $meta_media_name, $main_url);
}else{
$final_url = $main_url;
}
}
}
}else if (strpos($path, '-scaled') !== false) {
$part = implode('-', explode('-', $path, -1));
$img_extension = pathinfo($path, PATHINFO_EXTENSION);
$final_url = $part.".".$img_extension;
}
}
return $final_url;
}
// Function for geetting all the multisite prefixes
function getAllSitePrefix(){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
global $wpdb;
$prefixes = array();
$is_multisite = get_sites();
if($is_multisite){
$abcd = count($is_multisite);
$count = 0;
for ($i=2; $i <= $abcd; $i++) {
$prefixes[$count]['prefix'] = $wpdb->get_blog_prefix($i);
$prefixes[$count]['multisite_id'] = $i;
$count++;
}
}else{
$prefixes =
array(
0 => array("prefix" => "wp_")
);
}
return $prefixes;
}
// Removing cover images from the content
function GetStringBetween($string, $start=false, $end=false){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
$string = ' ' . $string;
$inia = strpos($string, $start);
if ($inia == 0){
$result = $string;
return $result;
}else{
$ini = $inia+strlen($start);
$len = strpos($string, $end, $ini) - $ini;
$extraction = substr($string, $ini, $len);
$strings = str_replace('', "", $string);
return MethodClass::GetStringBetween($strings, '');
}
}
// Function for getting all the details of a post by ID
function getproductdetails($pid){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
global $wpdb;
$pde = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."posts WHERE ID = '".$pid."'");
return $pde[0];
}
// Function for getting all the details of multisite post by ID
function getMultisiteProductDetails($pid,$sitePrefix){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
global $wpdb;
$pde = $wpdb->get_results("SELECT * FROM ".$sitePrefix."posts WHERE ID = '".$pid."'");
return $pde[0];
}
// Function for calculate size of the media
function formatSizeUnits($bytes){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
// Calculate size in KB/MB/GB
if ($bytes >= 1073741824)
{
$bytes = number_format($bytes / 1073741824, 2) . ' GB';
}
elseif ($bytes >= 1048576)
{
$bytes = number_format($bytes / 1048576, 2) . ' MB';
}
elseif ($bytes >= 1024)
{
$bytes = number_format($bytes / 1024, 2) . ' KB';
}
elseif ($bytes > 1)
{
$bytes = $bytes . ' bytes';
}
elseif ($bytes == 1)
{
$bytes = $bytes . ' byte';
}
else
{
$bytes = '0 bytes';
}
return $bytes;
}
// Function for geeting all the attachment of a product
function getattachmentproducts(){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
$mediaexistdata = array();
global $wpdb;
$attachmentdata = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."posts WHERE post_type='attachment'");
if(!empty($attachmentdata)){
$attachmentarray = array();
foreach ($attachmentdata as $key => $attachvalue) {
$media_id = $attachvalue->ID;
$media_url = $attachvalue->guid;
$mediauploaddate = $attachvalue->post_date;
$media_name = substr($media_url, strrpos($media_url, '/') + 1);
$mediabaseurl = substr($media_url, 0, strrpos( $media_url, '/'));
$attachmentarray[] = array('media_id'=>$media_id, 'media_name' => $media_name, 'upload_date' =>$mediauploaddate,'media_url'=>$media_url,'source_from'=>'database');
}
}
if(!empty($attachmentarray)){
foreach ($attachmentarray as $value) {
$media_id = $value['media_id'];
$medianame = $value['media_name'];
$mediadate = $value['upload_date'];
$media_url = $value['media_url'];
$source_from = $value['source_from'];
$productids = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."postmeta WHERE meta_key = '_thumbnail_id' AND meta_value ='".$media_id."'");
if(!empty($productids)){
foreach ($productids as $productValue) {
$postId = $productValue->post_id;
$getAllMeta = '';
$getAllMeta = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."postmeta WHERE post_id = '$postId' AND meta_key = '_variation_description'");
if($getAllMeta){
// get variation product details
$variant_attribute = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."postmeta WHERE post_id = '$postId' AND meta_key LIKE '%attribute_%'");
$variant_attributes = '';
foreach ($variant_attribute as $variant_value) {
$variant_attributes .= $variant_value->meta_value.' | ';
}
$attribute = rtrim($variant_attributes,'| ');
$sku_variant = get_post_meta($postId, '_sku', true);
$productdetails = MethodClass::getproductdetails($postId);
// Get all product categories of this product
$post_categories = wp_get_post_terms($postId,'product_cat');
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
if(!empty($productdetails)){
$mediaexistdata[] = array(
'media_id' => $media_id,
'medianame' => $medianame,
'src' => $media_url,
'media_type' => '',
'title'=> $productdetails->post_title,
'post_type' => $productdetails->post_type,
'page_builder_name' => 'Variation Product',
'post_category' => $post_cats,
'variant_attribute' => $attribute,
'variant_sku' => $sku_variant,
'datetime' => $mediadate,
'linked' => 'Yes',
'source_from' => 'database',
'website_prefix' => $wpdb->prefix
);
}
}
}
}
$pgde = $wpdb->get_results("SELECT post_id FROM ".$wpdb->prefix."postmeta WHERE meta_key = '_product_image_gallery' AND FIND_IN_SET(".$media_id.", meta_value)");
if(!empty($pgde)){
// $productgids = array_column($pgde, 'post_id');
foreach ($pgde as $valueg) {
$valued = $valueg->post_id;
$productdetailsg = MethodClass::getproductdetails($valued);
// Get all product categories of this product
$post_categories = wp_get_post_terms($valued,'product_cat');
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
if(!empty($productdetailsg)){
$mediaexistdata[] = array(
'media_id' => $media_id,
'medianame' => $medianame,
'src' => $media_url,
'media_type' => "",
'title'=> $productdetailsg->post_title,
'post_type' => $productdetailsg->post_type,
'page_builder_name' => 'Product Gallery Image',
'post_category' => $post_cats,
'variant_attribute' => '',
'variant_sku' => '',
'datetime' => $mediadate,
'linked' =>'Yes',
'source_from' => 'database',
'website_prefix' => $wpdb->prefix
);
}
}
}
}
}
return $mediaexistdata;
}
// Function for geeting all the attachment of multisite product
function getMultisiteAttachmentProducts(){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
$mediaexistdata = array();
global $wpdb;
$prefixes = MethodClass::getAllSitePrefix();
foreach ($prefixes as $mutliarray) {
$prefixValue = $mutliarray['prefix'];
$multisiteId = $mutliarray['multisite_id'];
// Get multisite title
$current_blog_details = get_blog_details( array( 'blog_id' => $multisiteId ) );
$site_name = $current_blog_details->blogname;
$attachmentdata = $wpdb->get_results("SELECT * from ".$prefixValue."posts where post_type='attachment'");
if(!empty($attachmentdata)){
$attachmentarray = array();
foreach ($attachmentdata as $key => $attachvalue) {
$media_id = $attachvalue->ID;
$media_url = $attachvalue->guid;
$mediauploaddate = $attachvalue->post_date;
$media_name = substr($media_url, strrpos($media_url, '/') + 1);
$mediabaseurl = substr($media_url, 0, strrpos( $media_url, '/'));
$attachmentarray[] = array('media_id'=>$media_id, 'media_name' => $media_name, 'upload_date' =>$mediauploaddate,'media_url'=>$media_url,'source_from'=>'database');
}
}
if(!empty($attachmentarray)){
foreach ($attachmentarray as $value) {
$media_id = $value['media_id'];
$medianame = $value['media_name'];
$mediadate = $value['upload_date'];
$media_url = $value['media_url'];
$source_from = $value['source_from'];
$productids = $wpdb->get_results("SELECT * FROM ".$prefixValue."postmeta WHERE meta_key = '_thumbnail_id' AND meta_value ='".$media_id."'");
if(!empty($productids)){
foreach ($productids as $productValue) {
$postId = $productValue->post_id;
$getAllMeta = array();
$getAllMeta = $wpdb->get_results("SELECT * FROM ".$prefixValue."postmeta WHERE post_id = '$postId' AND meta_key = '_variation_description'");
if($getAllMeta){
// get variation product details
$variant_attribute = $wpdb->get_results("SELECT * FROM ".$prefixValue."postmeta WHERE post_id = '$postId' AND meta_key LIKE '%attribute_%'");
$variant_attributes = '';
foreach ($variant_attribute as $variant_value) {
$variant_attributes .= $variant_value->meta_value.' | ';
}
$attribute = rtrim($variant_attributes,'| ');
// $attribute_color = get_post_meta($postId, 'attribute_color', true);
// $sku_variant = get_post_meta($postId, '_sku', true);
$getting_sku_inmeta = $wpdb->get_results("SELECT meta_value from ".$prefixValue."postmeta WHERE meta_key='_sku' AND post_id = $postId" );
$sku_variant = '';
if(!empty($getting_sku_inmeta)){
$sku_variant = $getting_sku_inmeta[0]->meta_value;
}
// $productidsarray = array_column($productids, 'post_id');
$productdetails = MethodClass::getMultisiteProductDetails($postId,$prefixValue);
// $post_categories = wp_get_post_terms($postId,'product_cat');
$queryterms = "SELECT * FROM ".$prefixValue."terms terms, ".$prefixValue."term_taxonomy term_taxonomy, ".$prefixValue."term_relationships term_relationships WHERE (terms.term_id = term_taxonomy.term_id AND term_taxonomy.term_taxonomy_id = term_relationships.term_taxonomy_id) AND term_relationships.object_id='".$postId."' AND terms.slug !='variable' AND terms.slug !='simple' AND terms.slug !='grouped' AND terms.slug !='external'";
$post_categories = $wpdb->get_results($queryterms, OBJECT);
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
if(!empty($productdetails)){
$linkedd = 'Yes
'.$site_name.'';
$mediaexistdata[] = array(
'media_id' => $media_id,
'medianame' => $medianame,
'src' => $media_url,
'media_type' => "",
'title'=> $productdetails->post_title,
'post_type' => $productdetails->post_type,
'page_builder_name' => 'Variation Product',
'post_category' => $post_cats,
'variant_attribute' => $attribute,
'variant_sku' => $sku_variant,
'datetime' => $mediadate,
'linked' =>$linkedd,
'source_from' => 'database',
'website_prefix' => $prefixValue
);
}
}
}
}
$pgde = $wpdb->get_results("SELECT post_id FROM ".$prefixValue."postmeta WHERE meta_key = '_product_image_gallery' AND FIND_IN_SET(".$media_id.", meta_value)");
if(!empty($pgde)){
// $productgids = array_column($pgde, 'post_id');
foreach ($pgde as $valueg) {
$valued = $valueg->post_id;
$productdetailsg = MethodClass::getMultisiteProductDetails($valued,$prefixValue);
$queryterms = "SELECT * FROM ".$prefixValue."terms terms, ".$prefixValue."term_taxonomy term_taxonomy, ".$prefixValue."term_relationships term_relationships WHERE (terms.term_id = term_taxonomy.term_id AND term_taxonomy.term_taxonomy_id = term_relationships.term_taxonomy_id) AND term_relationships.object_id='".$valued."' AND terms.slug !='variable' AND terms.slug !='simple' AND terms.slug !='grouped' AND terms.slug !='external'";
$post_categories = $wpdb->get_results($queryterms, OBJECT);
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
if($post_categories){
$post_cat = $post_categories[0]->name;
}
if(!empty($productdetailsg)){
$linkedd = 'Yes
'.$site_name.'';
$mediaexistdata[] = array(
'media_id' => $media_id,
'medianame' => $medianame,
'src' => $media_url,
'media_type' => "",
'title'=> $productdetails->post_title,
'post_type' => $productdetails->post_type,
'page_builder_name' => 'Product Gallery Image',
'post_category' => $post_cats,
'variant_attribute' => '',
'variant_sku' => '',
'datetime' => $mediadate,
'linked' =>$linkedd,
'source_from' => 'database',
'website_prefix' => $prefixValue
);
}
}
}
}
}
}
return $mediaexistdata;
}
// Function for getting all the images from directories
function walkDir($dir) {
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
$dir = rtrim($dir,"/");
global $return;
$dh = new DirectoryIterator($dir);
// Dirctary object
foreach ($dh as $item) {
if (!$item->isDot()) {
if ($item->isDir()) {
if($item !="wp_media_cleaner" && $item !="wp-admin" && $item !="wp-includes"){
MethodClass::walkDir("$dir/$item");
}
} else {
if($item->isFile() && preg_match("/(\.gif|\.png|\.jpe?g|\.svg|\.pdf|\.docx|\.doc|\.ppt|\.xls|\.pps|\.ppsx|\.xlsx|\.odt|\.mp3|\.ogg|\.m4a|\.wav|\.mp4|\.mov|\.wmv|\.avi|\.3gp|\.pptx)$/", $item->getFilename())){
$fullpath = $dir . "/" . $item->getFilename();
$type= $item->getExtension();
$return[] = array('src'=>$fullpath);
}
}
}
}
return $return;
}
// Function for geeting media URL by post ID
function getImageUrlbyId($imgId){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
global $wpdb;
$imgIdget = wp_get_attachment_url($imgId);
if(!empty($imgIdget)){
return $imgIdget;
}else{
return false;
}
}
// Function for geeting media URL by multisite post ID
function getMultiSiteImageUrlbyId($imgId,$prefixValue){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
global $wpdb;
$imgIdget = $wpdb->get_results("SELECT guid from ".$prefixValue."posts WHERE ID = $imgId" );
$imgIdget = $imgIdget[0]->guid;
if(!empty($imgIdget)){
return $imgIdget;
}else{
return false;
}
}
// Function for getting URL by specific functions
function getUrlByExtension($extension,$content){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
preg_match_all('@"'.$extension.'":"([^"]+)"@', $content, $resultant);
return $result[] = $resultant[1];
}
// Get media from page builder
function getPageBuilderContentMedia(){
require get_home_path()."wp-load.php";
require_once get_home_path()."wp-admin/includes/file.php";
global $wpdb;
$pbContent = $wpdb->get_results("SELECT * from ".$wpdb->prefix."posts WHERE post_type !='revision' && (post_status = 'publish' OR post_status = 'draft')");
$uniqueArr = array();
$inc = 0;
$uniqueArrs = array();
$uniqueArrs2 = array();
$uniqueArrs3 = array();
$uniqueArred = array();
// Total types of extensions
$totalExtensionsAvailable = array('gif','jpg','jpeg','png','svg','pdf','docx','doc','ppt','xls','pps','ppsx','xlsx','odt','mp3','ogg','m4a','wav','mp4','mov','wmv','avi','3gp');
foreach ($pbContent as $getvalues) {
$mediadate = $getvalues->post_date;
$getFiles = array();
if(!empty($getvalues)){
// Recognizing posts with their builder
$elem_builder = get_post_meta($getvalues->ID, '_elementor_edit_mode', true);
$vc_builder = get_post_meta($getvalues->ID, '_wpb_vc_js_status', true);
$beaver_builder = get_post_meta($getvalues->ID, '_fl_builder_enabled', true);
$brizy_builder = !empty(get_post_meta($getvalues->ID, 'brizy', true));
$oxygen_builder = !empty(get_post_meta($getvalues->ID, 'ct_builder_shortcodes', true));
$siteorigin_builder = get_post_meta($getvalues->ID, 'panels_data', true);
$siteorigin_ck_builder = '';
if(!empty($siteorigin_builder)){
$siteorigin_ck_builder = "SiteOrigin";
}
$featuredImageArr = get_post_meta($getvalues->ID, '_thumbnail_id');
@$featuredImagesId = $featuredImageArr[0];
if($featuredImagesId){
$featuredImageId = MethodClass::getImageUrlbyId($featuredImagesId);
}else{
$featuredImageId = '';
}
$productgalleryArr = get_post_meta($getvalues->ID, '_product_image_gallery');
@$productgalleryImg = $productgalleryArr[0];
$the_title = $getvalues->post_title;
$post_type = $getvalues->post_type;
$the_content = $getvalues->post_content;
// Code block for page builder: Elementor
if($elem_builder == 'builder'){
$PageId = $getvalues->ID;
$elementor_sql = get_post_meta($PageId, '_elementor_data');
$elementor_content = $elementor_sql[0];
// Get files url from URL & ID tag start
$group4 = array();
$group5 = array();
$getsrcfiles = array();
preg_match_all('@"url":"([^"]+)"@', $elementor_content, $group4);
preg_match_all('@"ids":"([^"]+)"@', $elementor_content, $group5);
// Get all categories
$post_categories = wp_get_post_terms($PageId,'category');
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
$imgArry = array();
foreach ($group4[1] as $ElementorimageUrl) {
$ElementorimageUrl = stripslashes($ElementorimageUrl);
$if_file_exist = str_replace(get_site_url().'/',get_home_path(),$ElementorimageUrl);
if(file_exists($if_file_exist)){
$new_array['media_id'] = '';
$new_array['media_type'] = "";
$new_array['title'] = $the_title;
$new_array['src'] = $ElementorimageUrl;
$new_array['medianame'] = basename($ElementorimageUrl);
$new_array['page_builder_name'] = "Elementor";
// Getting filetime from dir URL
$elementor_unixtime = filemtime($if_file_exist);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
// Get files url from href tag start
$gethreffiles = array();
preg_match_all('/href\h*=.*?\"(.*?)\"(?![^"\n]")/', $elementor_sql[0], $gethreffiles);
$hreffiles = array();
if(!empty($gethreffiles[1])){
foreach ($gethreffiles[1] as $hrefValues) {
$hrefValues = stripslashes($hrefValues);
$elementor2_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$hrefValues);
if(file_exists($elementor2_url_dir_path)){
$new_array['media_id'] = '';
$new_array['title'] = $the_title;
$new_array['src'] = $hrefValues;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($hrefValues);
$new_array['page_builder_name'] = "Elementor";
// Getting filetime from dir URL
$elementor2_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$hrefValues);
$elementor2_unixtime = filemtime($elementor2_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor2_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
}
// Get files url from href tag end
// Get files src from href tag start
$srcfiles = array();
preg_match_all('/src\h*=.*?\"(.*?)\"(?![^"\n]")/', $elementor_content, $getsrcfiles);
if(!empty($getsrcfiles[1])){
foreach ($getsrcfiles[1] as $srcValues) {
$srcValues = stripslashes($srcValues);
$elementor3_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$srcValues);
if(file_exists($elementor3_url_dir_path)){
$new_array['media_id'] = '';
$new_array['media_type'] = "";
$new_array['title'] = $the_title;
$new_array['src'] = $srcValues;
$new_array['medianame'] = basename($srcValues);
$new_array['page_builder_name'] = "Elementor";
// Getting filetime from dir URL
$elementor3_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$srcValues);
$elementor3_unixtime = filemtime($elementor3_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor3_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
}
// Get files src from href tag start
$contentimgid = implode(',', $imgArry);
if($group5[1][0] != ""){
$group5arr = explode(',', $group5[1][0]);
foreach ($group5arr as $imggelid) {
$getidurlimge = MethodClass::getImageUrlbyId($imggelid);
$getidurlimge = stripslashes($getidurlimge);
$elementor4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$getidurlimge);
if(file_exists($elementor4_url_dir_path)){
$new_array['media_id'] = '';
$new_array['title'] = $the_title;
$new_array['media_type'] = "";
$new_array['src'] = $getidurlimge;
$new_array['medianame'] = basename($getidurlimge);
$new_array['page_builder_name'] = "Elementor";
// Getting filetime from dir URL
$elementor4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$getidurlimge);
$elementor4_unixtime = filemtime($elementor4_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor4_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
}
// If have featured image
if(!empty($featuredImageId)){
$new_array['media_id'] = $featuredImagesId;
$new_array['title'] = $the_title;
$new_array['media_type'] = "";
$new_array['src'] = $featuredImageId;
$new_array['medianame'] = basename($featuredImageId);
$new_array['page_builder_name'] = "Featured Image | Elementor";
// Getting filetime from dir URL
$elementor4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$featuredImageId);
$elementor4_unixtime = filemtime($elementor4_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor4_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
// Code block for page builder: Visual Composer
if($vc_builder == 'true'){
$totalExtensionsAvailable = array('gif','jpg','jpeg','png','pdf','docx','doc','ppt','xls','pps','ppsx','xlsx','odt','mp3','ogg','m4a','wav','mp4','mov','wmv','avi','3gp','pptx');
$the_content = $getvalues->post_content;
// Matching following pattern for getting respective images
preg_match_all('@vc_single_image image="([^"]+)"@', $the_content, $group1);
preg_match_all('@vc_gallery interval="([^"]+)" images="([^"]+)"@', $the_content, $group2);
preg_match_all('@vc_images_carousel images="([^"]+)"@', $the_content, $group3);
preg_match_all('@vc_hoverbox image="([^"]+)"@', $the_content, $group4);
/* Raw HTML */
preg_match_all('@vc_raw_html([^"]+)/vc_raw_html@', $the_content, $group15);
$RowHtmls = str_replace([']','['], ['',''], $group15[1]);
if(!empty($RowHtmls)){
foreach ($RowHtmls as $RowHtml) {
$RowContent = rawurldecode( base64_decode( wp_strip_all_tags( $RowHtml ) ) );
if(function_exists('wpb_js_remove_wpautop')){
$RowContent = wpb_js_remove_wpautop( apply_filters( 'vc_raw_html_module_content', $RowContent ) );
}
preg_match_all('@src="([^"]+)"@', $RowContent, $group16);
$getFiles[] = str_replace(['?_=1'], [''], $group16[1]);
}
}
preg_match_all('@src="([^"]+)"@', $the_content, $group9);
preg_match_all('@mp3="([^"]+)"@', $the_content, $group11);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group12);
preg_match_all('@pdf="([^"]+)"@', $the_content, $group13);
preg_match_all('@docx="([^"]+)"@', $the_content, $group14);
preg_match_all('@doc="([^"]+)"@', $the_content, $group15);
preg_match_all('@ppt="([^"]+)"@', $the_content, $group16);
preg_match_all('@xls="([^"]+)"@', $the_content, $group17);
preg_match_all('@pps="([^"]+)"@', $the_content, $group18);
preg_match_all('@ppsx="([^"]+)"@', $the_content, $group19);
preg_match_all('@xlsx="([^"]+)"@', $the_content, $group20);
preg_match_all('@odt="([^"]+)"@', $the_content, $group21);
preg_match_all('@ogg="([^"]+)"@', $the_content, $group22);
preg_match_all('@m4a="([^"]+)"@', $the_content, $group23);
preg_match_all('@wav="([^"]+)"@', $the_content, $group24);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group25);
preg_match_all('@mov="([^"]+)"@', $the_content, $group26);
preg_match_all('@wmv="([^"]+)"@', $the_content, $group27);
preg_match_all('@avi="([^"]+)"@', $the_content, $group28);
preg_match_all('@3gp="([^"]+)"@', $the_content, $group29);
preg_match_all('@pptx="([^"]+)"@', $the_content, $group30);
preg_match_all('/link\h*=.*?\"(.*?)\"(?![^"\n]")/', $the_content, $vc_video_url);
preg_match_all('@href="([^"]+)"@', $RowContent, $groupsfiles);
$groupsfiles = $groupsfiles[1];
if(!empty($groupsfiles)){
foreach ($groupsfiles as $filesvalue) {
$fileExtension = pathinfo($filesvalue, PATHINFO_EXTENSION);
if(in_array($fileExtension, $totalExtensionsAvailable)){
$getFiles[] = $filesvalue;
}
}
}
// for vc video
if(!empty($vc_video_url[1])){
foreach ($vc_video_url[1] as $vc_video) {
$getFiles[] = $vc_video;
}
}
// for src
if(!empty($group9[1])){
foreach ($group9[1] as $group9s) {
$getFiles[] = $group9s;
}
}
// for mp3
if(!empty($group11[1])){
foreach ($group11[1] as $group11s) {
$getFiles[] = $group11s;
}
}
// for mp4
if(!empty($group12[1])){
foreach ($group12[1] as $group12s) {
$getFiles[] = $group12s;
}
}
// for pdf
if(!empty($group13[1])){
foreach ($group13[1] as $group13s) {
$getFiles[] = $group13s;
}
}
// for docx
if(!empty($group14[1])){
foreach ($group14[1] as $group14s) {
$getFiles[] = $group14s;
}
}
// for doc
if(!empty($group15[1])){
foreach ($group15[1] as $group15s) {
$getFiles[] = $group15s;
}
}
// for ppt
if(!empty($group16[1])){
foreach ($group16[1] as $group16s) {
$getFiles[] = $group16s;
}
}
// for xls
if(!empty($group17[1])){
foreach ($group17[1] as $group17s) {
$getFiles[] = $group17s;
}
}
// for pps
if(!empty($group18[1])){
foreach ($group18[1] as $group18s) {
$getFiles[] = $group18s;
}
}
// for ppsx
if(!empty($group19[1])){
foreach ($group19[1] as $group19s) {
$getFiles[] = $group19s;
}
}
// for xlsx
if(!empty($group20[1])){
foreach ($group20[1] as $group20s) {
$getFiles[] = $group20s;
}
}
// for odt
if(!empty($group21[1])){
foreach ($group21[1] as $group21s) {
$getFiles[] = $group21s;
}
}
// for ogg
if(!empty($group22[1])){
foreach ($group22[1] as $group22s) {
$getFiles[] = $group22s;
}
}
// for m4a
if(!empty($group23[1])){
foreach ($group23[1] as $group23s) {
$getFiles[] = $group23s;
}
}
// for wav
if(!empty($group24[1])){
foreach ($group24[1] as $group24s) {
$getFiles[] = $group24s;
}
}
// for mp4
if(!empty($group25[1])){
foreach ($group25[1] as $group25s) {
$getFiles[] = $group25s;
}
}
// for mov
if(!empty($group26[1])){
foreach ($group26[1] as $group26s) {
$getFiles[] = $group26s;
}
}
// for avi
if(!empty($group27[1])){
foreach ($group27[1] as $group27s) {
$getFiles[] = $group27s;
}
}
// for 3gp
if(!empty($group28[1])){
foreach ($group28[1] as $group28s) {
$getFiles[] = $group28s;
}
}
// for pptx
if(!empty($group29[1])){
foreach ($group29[1] as $group29s) {
$getFiles[] = $group29s;
}
}
/* Raw HTML */
$PageId = $getvalues->ID;
preg_match_all('@href="([^"]+)"@', $the_content, $groupsfile);
$groupsfile = $groupsfile[1];
if(!empty($groupsfile)){
foreach ($groupsfile as $filesvalue) {
$fileExtension = pathinfo($filesvalue, PATHINFO_EXTENSION);
if(in_array($fileExtension, $totalExtensionsAvailable)){
$getFiles[] = $filesvalue;
}
}
}
preg_match_all('@src="([^"]+)"@', $the_content, $group9);
preg_match_all('@background-image: url([^"]+)@', $the_content, $group10);
$bgimgUrlArr = str_replace(['(',')'], ['',''], $group10[1]);
$bgimgUrl = array();
foreach ($bgimgUrlArr as $BGvalue) {
$bgimgUrl[] = substr($BGvalue, 0, strrpos($BGvalue, '?'));
}
// Merging Arrays Start
$VCmediaContentPre = array();
if(!empty($group9[1]) && !empty($bgimgUrl)){
$VCmediaContentPre = array_merge($group9[1],$bgimgUrl);
}elseif(!empty($group9[1]) && empty($bgimgUrl)){
$VCmediaContentPre = $group9[1];
}elseif(empty($group9[1]) && !empty($bgimgUrl)){
$VCmediaContentPre = $bgimgUrl;
}
$VCmediaContent = array();
if(!empty($VCmediaContentPre) && !empty($getFiles)){
$VCmediaContent = array_merge($VCmediaContentPre,$getFiles);
}elseif(!empty($VCmediaContentPre) && empty($getFiles)){
$VCmediaContent = $VCmediaContentPre;
}elseif(empty($VCmediaContentPre) && !empty($getFiles)){
$VCmediaContent = $getFiles;
}
$VCsingleimageids = implode(',',array_unique(explode(',', implode(',', $group1[1]))));
$VCgalleryimageids = implode(',',array_unique(explode(',', implode(',', $group2[2]))));
$VCcarouselimageids = implode(',',array_unique(explode(',', implode(',', $group3[1]))));
$VChoverboximageids = implode(',',array_unique(explode(',', implode(',', $group4[1]))));
// Get all categories
$post_categories = wp_get_post_terms($PageId,'category');
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
if($VCsingleimageids != "" || $VCgalleryimageids != "" || $VCcarouselimageids != "" || $VChoverboximageids != "" || !empty($VCmediaContent)){
$VCimageids = '';
$comma = '';
if($VCsingleimageids != ""){
$VCsingleimageidsArr = array();
$VCsingleimageidsArr = explode(",", $VCsingleimageids);
foreach ($VCsingleimageidsArr as $VCsingleimageidsArrValue) {
$VCimages = MethodClass::getImageUrlbyId($VCsingleimageidsArrValue);
$vc_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$VCimages);
if(file_exists($vc_url_dir_path)){
$new_array['media_id'] = $idvalue;
$new_array['title'] = $the_title;
$new_array['src'] = $VCimages;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($VCimages);
$new_array['page_builder_name'] = "Visual Composer";
// Getting filetime from dir URL
$vc_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$VCimages);
$vc_unixtime = filemtime($vc_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$vc_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
}
if(!empty($VCmediaContent)){
$incs = 0;
foreach ($VCmediaContent as $VCmediaContentUrl) {
// Getting filetime from dir URL
$vc2_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$VCmediaContentUrl);
if(file_exists($vc2_url_dir_path)){
$new_array['media_id'] = '';
$new_array['title'] = $the_title;
$new_array['src'] = $VCmediaContentUrl;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($VCmediaContentUrl);
$new_array['page_builder_name'] = "Visual Composer";
$vc2_unixtime = filemtime($vc2_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$vc2_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
$incs++;
array_push($uniqueArr,$new_array);
}
}
}
if($VCgalleryimageids != ""){
if($VCimageids != ''){ $comma = ','; }
$theGalIds = explode(",", $VCgalleryimageids);
$inc = 0;
foreach ($theGalIds as $idvalue) {
$VCimage = MethodClass::getImageUrlbyId($idvalue);
// Getting filetime from dir URL
$vc3_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$VCimage);
if(file_exists($vc3_url_dir_path)){
$new_array['media_id'] = $idvalue;
$new_array['title'] = $the_title;
$new_array['src'] = $VCimage;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($VCimage);
$new_array['page_builder_name'] = "Visual Composer";
$vc3_unixtime = filemtime($vc3_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$vc3_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
$inc++;
array_push($uniqueArr,$new_array);
}
}
}
if($VCcarouselimageids != ""){
if($VCimageids != ''){ $comma = ','; }
$theGalIds2 = explode(",", $VCcarouselimageids);
$inc2 = 0;
foreach ($theGalIds2 as $idvalue2) {
$VCimage2 = MethodClass::getImageUrlbyId($idvalue2);
// Getting filetime from dir URL
$vc4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$VCimage2);
if(file_exists($vc4_url_dir_path)){
$new_array['media_id'] = $idvalue2;
$new_array['title'] = $the_title;
$new_array['src'] = $VCimage2;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($VCimage2);
$new_array['page_builder_name'] = "Visual Composer";
$vc4_unixtime = filemtime($vc4_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$vc4_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
$inc2++;
array_push($uniqueArr,$new_array);
}
}
}
if($VChoverboximageids != ""){
if($VCimageids != ''){ $comma = ','; }
$VChoverboximagesIdArr2 = array();
$VChoverboximagesIdArr2 = explode(",", $VChoverboximageids);
foreach ($VChoverboximagesIdArr2 as $VChoverboximagesIdArrValue2) {
$VCimage3 = MethodClass::getImageUrlbyId($VChoverboximagesIdArrValue2);
// Getting filetime from dir URL
$vc5_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$VCimage3);
if(file_exists($vc5_url_dir_path)){
$new_array['media_id'] = $VChoverboximageids;
$new_array['title'] = $the_title;
$new_array['src'] = $VCimage3;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($VCimage3);
$new_array['page_builder_name'] = "Visual Composer";
$vc5_unixtime = filemtime($vc5_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$vc5_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
}
// If have featured image
if(!empty($featuredImageId)){
$new_array['media_id'] = $featuredImagesId;
$new_array['title'] = $the_title;
$new_array['src'] = $featuredImageId;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($featuredImageId);
$new_array['page_builder_name'] = "Featured Image | Visual Composer";
// Getting filetime from dir URL
$elementor4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$featuredImageId);
$elementor4_unixtime = filemtime($elementor4_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor4_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
}
// Code block for page builder: Oxygen builder
if($oxygen_builder){
$totalExtensionsAvailable = array('jpg','png','gif','svg','pdf','docx','doc','ppt','xls','pps','ppsx','xlsx','odt','mp3','ogg','m4a','wav','mp4','mov','wmv','avi','3gp','pptx');
$PageId = $getvalues->ID;
$the_content = get_post_meta($PageId, 'ct_builder_shortcodes', true);
// Matching following pattern for getting respective images
preg_match_all('@"url":"([^"]+)"@', $the_content, $WordPressWidgetImages);
preg_match_all('@"src":"([^"]+)"@', $the_content, $contentimgurl);
preg_match_all('@"background-image":"([^"]+)"@', $the_content, $contentimgurl1);
preg_match_all('@"image_ids":"([^"]+)"@', $the_content, $gelleryimgids);
preg_match_all('@"code-php":"([^"]+)"@', $the_content, $phpcodes_encode);
$OxyCodeArr = array();
foreach ($phpcodes_encode[1] as $phpcode_encode) {
$phpcodes_decode = base64_decode($phpcode_encode);
preg_match_all('@(?:src[^>]+>)(.*?)@', $phpcodes_decode, $phpcodesImgUrl);
$phpcode_encode_url = str_replace(['src=',"'",'"',"/>",">"," type=application/pdf"], ['','','','','',''], $phpcodesImgUrl[0]);
$OxyCodeArr[] = explode(" ", $phpcode_encode_url[0]);
}
$OXImageurls = array();
foreach ($OxyCodeArr as $OxyCodevalue) {
$OXImageurls[] = $OxyCodevalue[0];
}
$widget_images = array();
foreach ($WordPressWidgetImages[1] as $WordPressWidgetValue) {
$widget_images[] = base64_decode($WordPressWidgetValue);
}
preg_match_all('@src="([^"]+)"@', $the_content, $group9);
preg_match_all('@mp3="([^"]+)"@', $the_content, $group11);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group12);
preg_match_all('@pdf="([^"]+)"@', $the_content, $group13);
preg_match_all('@docx="([^"]+)"@', $the_content, $group14);
preg_match_all('@doc="([^"]+)"@', $the_content, $group15);
preg_match_all('@ppt="([^"]+)"@', $the_content, $group16);
preg_match_all('@xls="([^"]+)"@', $the_content, $group17);
preg_match_all('@pps="([^"]+)"@', $the_content, $group18);
preg_match_all('@ppsx="([^"]+)"@', $the_content, $group19);
preg_match_all('@xlsx="([^"]+)"@', $the_content, $group20);
preg_match_all('@odt="([^"]+)"@', $the_content, $group21);
preg_match_all('@ogg="([^"]+)"@', $the_content, $group22);
preg_match_all('@m4a="([^"]+)"@', $the_content, $group23);
preg_match_all('@wav="([^"]+)"@', $the_content, $group24);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group25);
preg_match_all('@mov="([^"]+)"@', $the_content, $group26);
preg_match_all('@wmv="([^"]+)"@', $the_content, $group27);
preg_match_all('@avi="([^"]+)"@', $the_content, $group28);
preg_match_all('@3gp="([^"]+)"@', $the_content, $group29);
preg_match_all('@pptx="([^"]+)"@', $the_content, $group30);
preg_match_all('/"image_ids"\h*:.*?\"(.*?)\"(?![^"\n]")/', $the_content, $oxy_gallery);
// for gallery image
$urls = '';
if(!empty($oxy_gallery[1])){
foreach ($oxy_gallery[1] as $oxy_gallery_id) {
$urls .= $oxy_gallery_id.',';
}
}
$imageID = rtrim($urls,",");
$imageIDs = explode(",", $imageID);
foreach ($imageIDs as $EachId) {
$getFiles[] = MethodClass::getImageUrlbyId($EachId);
}
preg_match_all('/link\h*=.*?\"(.*?)\"(?![^"\n]")/', $the_content, $vc_video_url);
preg_match_all('@href="([^"]+)"@', $the_content, $groupsfiles);
$groupsfiles = $groupsfiles[1];
if(!empty($groupsfiles)){
foreach ($groupsfiles as $filesvalue) {
$fileExtension = pathinfo($filesvalue, PATHINFO_EXTENSION);
if(in_array($fileExtension, $totalExtensionsAvailable)){
$getFiles[] = $filesvalue;
}
}
}
// for vc video
if(!empty($vc_video_url[1])){
foreach ($vc_video_url[1] as $vc_video) {
$getFiles[] = $vc_video;
}
}
// for src
if(!empty($group9[1])){
foreach ($group9[1] as $group9s) {
$getFiles[] = $group9s;
}
}
// for mp3
if(!empty($group11[1])){
foreach ($group11[1] as $group11s) {
$getFiles[] = $group11s;
}
}
// for mp4
if(!empty($group12[1])){
foreach ($group12[1] as $group12s) {
$getFiles[] = $group12s;
}
}
// for pdf
if(!empty($group13[1])){
foreach ($group13[1] as $group13s) {
$getFiles[] = $group13s;
}
}
// for docx
if(!empty($group14[1])){
foreach ($group14[1] as $group14s) {
$getFiles[] = $group14s;
}
}
// for doc
if(!empty($group15[1])){
foreach ($group15[1] as $group15s) {
$getFiles[] = $group15s;
}
}
// for ppt
if(!empty($group16[1])){
foreach ($group16[1] as $group16s) {
$getFiles[] = $group16s;
}
}
// for xls
if(!empty($group17[1])){
foreach ($group17[1] as $group17s) {
$getFiles[] = $group17s;
}
}
// for pps
if(!empty($group18[1])){
foreach ($group18[1] as $group18s) {
$getFiles[] = $group18s;
}
}
// for ppsx
if(!empty($group19[1])){
foreach ($group19[1] as $group19s) {
$getFiles[] = $group19s;
}
}
// for xlsx
if(!empty($group20[1])){
foreach ($group20[1] as $group20s) {
$getFiles[] = $group20s;
}
}
// for odt
if(!empty($group21[1])){
foreach ($group21[1] as $group21s) {
$getFiles[] = $group21s;
}
}
// for ogg
if(!empty($group22[1])){
foreach ($group22[1] as $group22s) {
$getFiles[] = $group22s;
}
}
// for m4a
if(!empty($group23[1])){
foreach ($group23[1] as $group23s) {
$getFiles[] = $group23s;
}
}
// for wav
if(!empty($group24[1])){
foreach ($group24[1] as $group24s) {
$getFiles[] = $group24s;
}
}
// for mp4
if(!empty($group25[1])){
foreach ($group25[1] as $group25s) {
$getFiles[] = $group25s;
}
}
// for mov
if(!empty($group26[1])){
foreach ($group26[1] as $group26s) {
$getFiles[] = $group26s;
}
}
// for avi
if(!empty($group27[1])){
foreach ($group27[1] as $group27s) {
$getFiles[] = $group27s;
}
}
// for 3gp
if(!empty($group28[1])){
foreach ($group28[1] as $group28s) {
$getFiles[] = $group28s;
}
}
// for pptx
if(!empty($group29[1])){
foreach ($group29[1] as $group29s) {
$getFiles[] = $group29s;
}
}
// Merging arrays
$OXI1mageurlsArr = array();
if(!empty($OXImageurls) && !empty($contentimgurl[1])){
$OXI1mageurlsArr = array_merge($OXImageurls,$contentimgurl[1]);
}elseif(!empty($OXImageurls) && empty($contentimgurl[1])){
$OXI1mageurlsArr = $OXImageurls;
}elseif(empty($OXImageurls) && !empty($contentimgurl[1])){
$OXI1mageurlsArr = $contentimgurl[1];
}
$OXI2mageurlsArr = array();
if(!empty($OXI1mageurlsArr) && !empty($contentimgurl1[1])){
$OXI2mageurlsArr = array_merge($OXI1mageurlsArr,$contentimgurl1[1]);
}elseif(!empty($OXI1mageurlsArr) && empty($contentimgurl1[1])){
$OXI2mageurlsArr = $OXI1mageurlsArr;
}elseif(empty($OXI1mageurlsArr) && !empty($contentimgurl1[1])){
$OXI2mageurlsArr = $contentimgurl1[1];
}
$OXImageurlsArr = array();
if(!empty($OXI2mageurlsArr) && !empty($getFiles)){
$OXImageurlsArr = array_merge($OXI2mageurlsArr,$getFiles);
}elseif(!empty($OXI2mageurlsArr) && empty($getFiles)){
$OXImageurlsArr = $OXI2mageurlsArr;
}elseif(empty($OXI2mageurlsArr) && !empty($getFiles)){
$OXImageurlsArr = $getFiles;
}
$OXImageurlsArrFinal = array();
if(!empty($OXImageurlsArr) && !empty($widget_images)){
$OXImageurlsArrFinal = array_merge($OXImageurlsArr,$widget_images);
}elseif(!empty($OXImageurlsArr) && empty($widget_images)){
$OXImageurlsArrFinal = $OXImageurlsArr;
}elseif(empty($OXImageurlsArr) && !empty($widget_images)){
$OXImageurlsArrFinal = $widget_images;
}
$OXimgidsArr = array();
if(!empty($OXImageurlsArrFinal)){
foreach ($OXImageurlsArrFinal as $OXImageurl) {
array_push($OXimgidsArr, $OXImageurl);
}
}
if(!empty($gelleryimgids[1])){
foreach ($gelleryimgids[1] as $gelleryimgid) {
$gelleryimgURlbyid = array(MethodClass::getImageUrlbyId($gelleryimgid));
array_push($OXimgidsArr,$gelleryimgURlbyid);
}
}
$OXimgidsArrUni = array();
$OXimgidsArrUni = array_unique($OXimgidsArr, SORT_REGULAR);
// Get all categories
$post_categories = wp_get_post_terms($PageId,'category');
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
foreach ($OXimgidsArrUni as $oxi_url) {
// Get the created date of this media
$dir_path = str_replace(get_site_url().'/',get_home_path(),$oxi_url);
if(file_exists($dir_path)){
$oxy_unixtime = filemtime($dir_path);
$new_array['media_id'] = "";
$new_array['title'] = $the_title;
$new_array['src'] = $oxi_url;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($oxi_url);
$new_array['page_builder_name'] = "Oxygen Builder";
$new_array['datetime'] = date("Y-m-d h:i:s",$oxy_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
// If have featured image
if(!empty($featuredImageId)){
$new_array['media_id'] = $featuredImagesId;
$new_array['title'] = $the_title;
$new_array['src'] = $featuredImageId;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($featuredImageId);
$new_array['page_builder_name'] = "Featured Image | Oxygen Builder";
// Getting filetime from dir URL
$elementor4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$featuredImageId);
$elementor4_unixtime = filemtime($elementor4_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor4_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
// Code block for page builder: Beaver
if($beaver_builder == 1){
$getFiles = array();
$BBmergeArray = array();
$totalExtensionsAvailable = array('jpg','png','gif','svg','pdf','docx','doc','ppt','xls','pps','ppsx','xlsx','odt','mp3','ogg','m4a','wav','mp4','mov','wmv','avi','3gp','pptx');
$the_content = $getvalues->post_content;
$PageId = $getvalues->ID;
// Matching following pattern for getting respective images
preg_match_all('@src="([^"]+)"@', $the_content, $group6);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group7);
preg_match_all('@src="([^"]+)"@', $the_content, $group9);
preg_match_all('@mp3="([^"]+)"@', $the_content, $group11);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group12);
preg_match_all('@pdf="([^"]+)"@', $the_content, $group13);
preg_match_all('@docx="([^"]+)"@', $the_content, $group14);
preg_match_all('@doc="([^"]+)"@', $the_content, $group15);
preg_match_all('@ppt="([^"]+)"@', $the_content, $group16);
preg_match_all('@xls="([^"]+)"@', $the_content, $group17);
preg_match_all('@pps="([^"]+)"@', $the_content, $group18);
preg_match_all('@ppsx="([^"]+)"@', $the_content, $group19);
preg_match_all('@xlsx="([^"]+)"@', $the_content, $group20);
preg_match_all('@odt="([^"]+)"@', $the_content, $group21);
preg_match_all('@ogg="([^"]+)"@', $the_content, $group22);
preg_match_all('@m4a="([^"]+)"@', $the_content, $group23);
preg_match_all('@wav="([^"]+)"@', $the_content, $group24);
preg_match_all('@mp4="([^"]+)"@', $the_content, $group25);
preg_match_all('@mov="([^"]+)"@', $the_content, $group26);
preg_match_all('@wmv="([^"]+)"@', $the_content, $group27);
preg_match_all('@avi="([^"]+)"@', $the_content, $group28);
preg_match_all('@3gp="([^"]+)"@', $the_content, $group29);
preg_match_all('@pptx="([^"]+)"@', $the_content, $group30);
preg_match_all('@href="([^"]+)"@', $the_content, $groupsfiles);
$groupsfiles = $groupsfiles[1];
if(!empty($groupsfiles)){
foreach ($groupsfiles as $filesvalue) {
$fileExtension = pathinfo($filesvalue, PATHINFO_EXTENSION);
if(in_array($fileExtension, $totalExtensionsAvailable)){
$getFiles[] = $filesvalue;
}
}
}
// Loop for getting vc media video
if(!empty($vc_video_url[1])){
foreach ($vc_video_url[1] as $vc_video) {
$getFiles[] = $vc_video;
}
}
// Loop for getting src media
if(!empty($group9[1])){
foreach ($group9[1] as $group9s) {
$getFiles[] = $group9s;
}
}
// Loop for getting mp3 media
if(!empty($group11[1])){
foreach ($group11[1] as $group11s) {
$getFiles[] = $group11s;
}
}
// Loop for getting mp4 media
if(!empty($group12[1])){
foreach ($group12[1] as $group12s) {
$getFiles[] = $group12s;
}
}
// Loop for getting pdf media
if(!empty($group13[1])){
foreach ($group13[1] as $group13s) {
$getFiles[] = $group13s;
}
}
// Loop for getting docx media
if(!empty($group14[1])){
foreach ($group14[1] as $group14s) {
$getFiles[] = $group14s;
}
}
// Loop for getting doc media
if(!empty($group15[1])){
foreach ($group15[1] as $group15s) {
$getFiles[] = $group15s;
}
}
// Loop for getting ppt media
if(!empty($group16[1])){
foreach ($group16[1] as $group16s) {
$getFiles[] = $group16s;
}
}
// Loop for getting xls media
if(!empty($group17[1])){
foreach ($group17[1] as $group17s) {
$getFiles[] = $group17s;
}
}
// Loop for getting pps media
if(!empty($group18[1])){
foreach ($group18[1] as $group18s) {
$getFiles[] = $group18s;
}
}
// Loop for getting ppsx media
if(!empty($group19[1])){
foreach ($group19[1] as $group19s) {
$getFiles[] = $group19s;
}
}
// Loop for getting xlsx media
if(!empty($group20[1])){
foreach ($group20[1] as $group20s) {
$getFiles[] = $group20s;
}
}
// Loop for getting odt media
if(!empty($group21[1])){
foreach ($group21[1] as $group21s) {
$getFiles[] = $group21s;
}
}
// Loop for getting ogg media
if(!empty($group22[1])){
foreach ($group22[1] as $group22s) {
$getFiles[] = $group22s;
}
}
// Loop for getting m4a media
if(!empty($group23[1])){
foreach ($group23[1] as $group23s) {
$getFiles[] = $group23s;
}
}
// Loop for getting wav media
if(!empty($group24[1])){
foreach ($group24[1] as $group24s) {
$getFiles[] = $group24s;
}
}
// Loop for getting mp4 media
if(!empty($group25[1])){
foreach ($group25[1] as $group25s) {
$getFiles[] = $group25s;
}
}
// Loop for getting mov media
if(!empty($group26[1])){
foreach ($group26[1] as $group26s) {
$getFiles[] = $group26s;
}
}
// Loop for getting avi media
if(!empty($group27[1])){
foreach ($group27[1] as $group27s) {
$getFiles[] = $group27s;
}
}
// Loop for getting 3gp media
if(!empty($group28[1])){
foreach ($group28[1] as $group28s) {
$getFiles[] = $group28s;
}
}
// Loop for getting pptx media
if(!empty($group29[1])){
foreach ($group29[1] as $group29s) {
$getFiles[] = $group29s;
}
}
$beaver_src_array = $group6[1];
$beaver_mp4_array = $group7[1];
// Merging arrays
$BBmergePreArray = array();
if(!empty($getFiles) && !empty($beaver_src_array)){
$BBmergePreArray = array_merge(array_unique($beaver_src_array),array_unique($getFiles));
}elseif(!empty($getFiles) && empty($beaver_src_array)){
$BBmergePreArray = array_unique($getFiles);
}elseif(empty($getFiles) && !empty($beaver_src_array)){
$BBmergePreArray = array_unique($beaver_src_array);
}
$BBmergeArray = array();
if(!empty($BBmergePreArray) && !empty($beaver_mp4_array)){
$BBmergeArray = array_merge(array_unique($beaver_mp4_array),array_unique($BBmergePreArray));
}elseif(!empty($BBmergePreArray) && empty($beaver_mp4_array)){
$BBmergeArray = array_unique($BBmergePreArray);
}elseif(empty($BBmergePreArray) && !empty($beaver_mp4_array)){
$BBmergeArray = array_unique($beaver_mp4_array);
}
// Get all categories
$post_categories = wp_get_post_terms($PageId,'category');
$post_cat = array();
$post_cats = "";
if(!empty($post_categories)){
foreach ($post_categories as $cat_value) {
$post_cat[] = $cat_value->name;
}
$post_cats = implode(",", $post_cat);
}
// Beaver Builder Final Array
foreach ($BBmergeArray as $beaver_urls) {
$beaver_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$beaver_urls);
if(file_exists($beaver_url_dir_path)){
$new_array['media_id'] = "";
$new_array['title'] = $the_title;
$new_array['src'] = $beaver_urls;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($beaver_urls);
$new_array['page_builder_name'] = "Beaver Builder";
$beaver_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$beaver_urls);
$beaver_unixtime = filemtime($beaver_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$beaver_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
// If have featured image
if(!empty($featuredImageId)){
$new_array['media_id'] = $featuredImagesId;
$new_array['title'] = $the_title;
$new_array['src'] = $featuredImageId;
$new_array['media_type'] = "";
$new_array['medianame'] = basename($featuredImageId);
$new_array['page_builder_name'] = "Featured Image | Beaver Builder";
// Getting filetime from dir URL
$elementor4_url_dir_path = str_replace(get_site_url().'/',get_home_path(),$featuredImageId);
$elementor4_unixtime = filemtime($elementor4_url_dir_path);
$new_array['datetime'] = date("Y-m-d h:i:s",$elementor4_unixtime);
$new_array['post_type'] = $post_type;
$new_array['post_category'] = $post_cats;
$new_array['variant_attribute'] = '';
$new_array['variant_sku'] = '';
$new_array['source_from'] = 'database';
$new_array['linked'] = 'Yes';
$new_array['website_prefix'] = $wpdb->prefix;
array_push($uniqueArr,$new_array);
}
}
// Code block for page builder: Brizy
if($brizy_builder){
$PageId = $getvalues->ID;
$the_content = get_post_meta($PageId, 'brizy', true);
$brizy_decode = base64_decode($the_content['brizy-post']['editor_data']);
$brizy_content_str = str_replace(['\"'], [''], $brizy_decode);
preg_match_all('@bgImageSrc":"([^"]+)"@', $brizy_content_str, $group14);
preg_match_all('@imageSrc":"([^"]+)"@', $brizy_content_str, $group12);
// HREF CASE 1: Get url when pattern is
preg_match_all('~href=(.*?)>~',$brizy_content_str,$case1_gethreffiles);
foreach ($case1_gethreffiles[1] as $case1_href_value){
$case1_href_value = strtok($case1_href_value, " ");
$case1_dir_path = str_replace(get_site_url().'/',get_home_path(),$case1_href_value);
if(file_exists($case1_dir_path)){
$hrefcase1[] = $case1_href_value;
}
}
// HREF CASE 2: Get url when pattern is
preg_match_all('~href=\'(.*?)\'~',$brizy_content_str,$case2_gethreffiles);
foreach ($case2_gethreffiles[1] as $case2_href_value) {
$case2_href_value = strtok($case2_href_value, " ");
$case2_dir_path = str_replace(get_site_url().'/',get_home_path(),$case2_href_value);
if(file_exists($case2_dir_path)){
$hrefcase2[] = $case2_href_value;
}
}
// CASE 3 (EMBED) : Get url when pattern is