File: /var/www/html/createImportNewTemplate.php
<?php
set_time_limit(100000);
include("includes/limittext.php");
include('Connections/videoondemand.php');
require("DbSql2.inc.php");
require("NewsSql2.inc.php");
include("includes/processFunctionsX.php");
include("const.inc.php");
$db = new NewsSQL();
include("protect.php");
global $link;
function formatPathData($path_string)
{
//splitting the path data by space
$path_values = explode(" ", $path_string);
$fabric_path = array();
//looping through the path values
for ($i = 0; $i < count($path_values); $i++) {
//if path value is a letter
if (ctype_alpha($path_values[$i])) {
//adding letter in the fabric path array
$fabric_path[] = $path_values[$i];
}
//if path value is a number
if (is_numeric($path_values[$i])) {
//adding number in the fabric path array
$fabric_path[] = (float)$path_values[$i];
}
}
return $fabric_path;
}
function color_luminance( $hex, $percent ) {
// validate hex string
$hex = preg_replace( '/[^0-9a-f]/i', '', $hex );
$new_hex = '#';
if ( strlen( $hex ) < 6 ) {
$hex = $hex[0] + $hex[0] + $hex[1] + $hex[1] + $hex[2] + $hex[2];
}
// convert to decimal and change luminosity
for ($i = 0; $i < 3; $i++) {
$dec = hexdec( substr( $hex, $i*2, 2 ) );
$dec = min( max( 0, $dec + $dec * $percent ), 255 );
$new_hex .= str_pad( dechex( $dec ) , 2, 0, STR_PAD_LEFT );
}
return $new_hex;
}
include('TheBrandZ/jsonF.php');
include('TheBrandZ/jsonBrands.php');
/* echo $dataBrand['hex'][0]['hex'] . "\n";
echo $dataBrand['hex'][1]['hex'] . "\n";*/
$jsonheader ='{
"version": "5.3.0",
"objects": [';
$zy =0;
$er =0;
$i =0;
$polyC = 0;
$pathC = -1;
$stmt2 ="select * from templatesimport where id=10 ORDER BY `templatesimport`.`id` ASC LIMIT 0, 1";
$query = mysqli_query($link,$stmt2) or die(mysqli_error());
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$id=$row["id"];
$json_string= $row["json"];
$json_string = stripslashes($row["json"]);
$json_string = str_replace('\n', "XXXXXXX", $json_string);
$json_string = str_replace('&', "&", $json_string);
$json_string = stripslashes($json_string);
$data = json_decode($json_string, true);
/* */
$processedJson = $json;
// Top-level nodes
$designId = $data['id'];
$designWidth = $data['width'];
$designHeight = $data['height'];
$designCategoryCaption = $data['categoryCaption'];
$designGroup = $data['group'];
$designMeasureUnits = $data['measureUnits'];
$designRemoved = $data['removed'];
$designPixelWidth = $data['pixelWidth'];
$designPixelHeight = $data['pixelHeight'];
$designPreviewImageUrls = $data['previewImageUrls'];
$designHasAnimatedPreview = $data['hasAnimatedPreview'];
$designHasAnimatedScreenPreview = $data['hasAnimatedScreenPreview'];
$designPreviewPending = $data['previewPending'];
$designPreviewUpdatedAt = $data['previewUpdatedAt'];
$designStatus = $data['status'];
$designFormat = $data['format'];
$designKeywords = $data['keywords']['en'];
$keywordsString = implode(", ", $designKeywords);
$keywordsString =str_replace(' ',"",$keywordsString);
$designIndustries = $data['industries'];
$industriesString = implode(", ", $designIndustries);
$industriesString =str_replace(' ',"",$industriesString);
$designTitle = $data['title'];
$designForSubscribers = $data['forSubscribers'];
$designBriefId = $data['briefId'];
$designResizedFromTemplateId = $data['resizedFromTemplateId'];
$designSeoMeta = $data['seoMeta']['shouldIndex'];
$numberofPages = count($data['template']);
$textData = $data;
//update no of views
//update those with more pages for later processsing
/* $sql = "UPDATE templatesimport SET designformat = '$designFormat',designgroup = '$designGroup', premium = '$designForSubscribers' WHERE id = $id";
if (mysqli_query($link, $sql)) {
echo "Record updated successfully $id ,$designFormat,$designGroup,$designForSubscribers<br>";
} else {
echo "Error updating record: " . mysqli_error($link);
}*/
//update those with more pages for later processsing
/* if($numberofPages > 1)
{
$sql = "UPDATE templatesimport SET pages = '$numberofPages' WHERE id = $id";
if (mysqli_query($link, $sql)) {
echo "Record updated successfully $numberofPages <br>";
} else {
echo "Error updating record: " . mysqli_error($link);
}
}*/
/*
$stmtX ="select * from formats where formatname='$designFormat'";
$queryX = mysqli_query($link,$stmtX) or die(mysqli_error());
$rowX = mysqli_fetch_array($queryX, MYSQLI_ASSOC);
if(empty($rowX))
{
if($designGroup =="SMA"){ $designGroup ="Advertising";}
if($designGroup =="SM"){ $designGroup ="Social Media";}
if($designGroup =="AN"){ $designGroup ="Animation";}
if($designGroup =="EO"){ $designGroup ="Invites & Cards";}
if($designGroup =="HC"){ $designGroup ="Covers";}
if($designGroup =="BG"){ $designGroup ="Backgrounds & Graphics";}
if($designGroup =="MM"){ $designGroup ="Documents";}
echo $designTitle."-----------".$designGroup."-------------".$designFormat."<BR>";
$designCategory=$designGroup;
//work out the categories
$stmt2 ="SELECT h_categories_lang.category_id ,h_categories_lang.name,h_categories.parent_id,h_categories.parent_tree ,h_categories.slug FROM h_categories_lang LEFT JOIN h_categories ON h_categories.id = h_categories_lang.category_id where h_categories_lang.name = '$designFormat' ORDER BY h_categories.id DESC limit 0,500";
$query = mysqli_query($link,$stmt2) ;
$row = mysqli_fetch_array($query, MYSQLI_ASSOC) ;
if(!empty($row))
{
//found subcategory
$designCategory; $designFormat;
$name = $row["name"];
$parent_id = $row["parent_id"];
$parent_tree = $row["parent_tree"];
$slug = $row["slug"];
//choose this if no subcategory
$category_id = $row["category_id"];
}
else{
//not found subcategory check if it has main category
$stmt2 ="SELECT h_categories_lang.category_id ,h_categories_lang.name,h_categories.parent_id,h_categories.parent_tree ,h_categories.slug FROM h_categories_lang LEFT JOIN h_categories ON h_categories.id = h_categories_lang.category_id where h_categories_lang.name = '$designCategory' ORDER BY h_categories.id DESC limit 0,100";
$query = mysqli_query($link,$stmt2) ;
$row = mysqli_fetch_array($query, MYSQLI_ASSOC) ;
if(!empty($row))
{
$parent_id = $row["category_id"];
$slug = strtolower($designFormat);
$slug = preg_replace('~[^\pL\d]+~u', '-', $slug);
$slug = preg_replace('~[^-\w]+~', '', $slug);
$slug = trim($slug, '-');
$slug = preg_replace('~-+~', '-', $slug);
//insert subcategory
$sql = "INSERT INTO `h_categories` (`slug`, `parent_id`, `parent_tree`, `category_order`) VALUES
('$slug', $parent_id , $parent_id, '20' )";
mysqli_query($link,$sql);mysqli_query($link,$sql_insert_layer) ;
$idddd = mysqli_insert_id($link);
$category_id=$idddd;
$sql = "INSERT INTO `h_categories_lang` (`category_id`, `lang_id`, `name`) VALUES
('$idddd', '1', '$designFormat')";
mysqli_query($link,$sql);mysqli_query($link,$sql_insert_layer) ;
//$newthemeidlayer = mysqli_insert_id($link);
}
else{
//insert parent
//inser sub
$slug = strtolower($designGroup);
$slug = preg_replace('~[^\pL\d]+~u', '-', $slug);
$slug = preg_replace('~[^-\w]+~', '', $slug);
$slug = trim($slug, '-');
$slug = preg_replace('~-+~', '-', $slug);
//insert new maincategory
$sql = "INSERT INTO `h_categories` (`slug`, `parent_id`, `category_order`) VALUES
('$slug', '0', '20')";
mysqli_query($link,$sql);mysqli_query($link,$sql_insert_layer) ;
$newid = mysqli_insert_id($link);
$sql = "INSERT INTO `h_categories_lang` (`category_id`, `lang_id`, `name`) VALUES
('$newid', '1', '$designCategory')";
mysqli_query($link,$sql);mysqli_query($link,$sql_insert_layer) ;
//inser new sub
$slug = strtolower($designFormat);
$slug = preg_replace('~[^\pL\d]+~u', '-', $slug);
$slug = preg_replace('~[^-\w]+~', '', $slug);
$slug = trim($slug, '-');
$slug = preg_replace('~-+~', '-', $slug);
//insert subcategory
$sql = "INSERT INTO `h_categories` (`slug`, `parent_id`, `parent_tree`, `category_order`) VALUES
('$slug', '$newid', '$newid', '20')";
mysqli_query($link,$sql);mysqli_query($link,$sql_insert_layer) ;
$idlayer = mysqli_insert_id($link);
$sql = "INSERT INTO `h_categories_lang` (`category_id`, `lang_id`, `name`) VALUES
('$idlayer', '1', '$designFormat')";
mysqli_query($link,$sql);mysqli_query($link,$sql_insert_layer) ;
$category_id=$idlayer;
}
}
//end categorirss
}*/
if($designGroup != "AN")
{
/*
if($designGroup =="SMA"){ $designGroup ="Advertising";}
if($designGroup =="SM"){ $designGroup ="Social Media";}
if($designGroup =="AN"){ $designGroup ="Animation";}
if($designGroup =="EO"){ $designGroup ="Invites & Cards";}
if($designGroup =="HC"){ $designGroup ="Covers";}
if($designGroup =="BG"){ $designGroup ="Backgrounds & Graphics";}
if($designGroup =="MM"){ $designGroup ="Documents";}
include('TheBrandZ/textReplace.php');
$title = urlencode($new_title);
$slug = strtolower($new_title."-$id");
$slug = preg_replace('/[^A-Za-z0-9-]+/', '-', $slug);
$slug = urlencode($slug);
$designGroup = urlencode($designGroup);
$designWidth = urlencode($designWidth);
$designHeight = urlencode($designHeight);
$designMeasureUnits = urlencode($designMeasureUnits);
$designPixelWidth = urlencode($designPixelWidth);
$designPixelHeight = urlencode($designPixelHeight);
$designFormat = urlencode($designFormat);
$designTitle = urlencode($designTitle);
$url = "https://www.thebrand.ai/TheBrandZ/mode.php?mode=importTemplatesV4&designCategory=444&designFormat=$designFormat&slug=$slug&title=$title&designWidth=$designWidth&designHeight=$designHeight&designMeasureUnits=$designMeasureUnits&designPixelWidth=$designPixelWidth&designPixelHeight=$designPixelHeight&designKeywords=$keywordsString&designIndustries=$industriesString&designForSubscribers=$designForSubscribers&json=$id";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"$url");
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS,
"1");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$server_output = curl_exec($ch);
$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close ($ch);
if($httpcode>=200 && $httpcode<300)
{
echo $server_output;
sleep(2);
}
else
{
echo "fail";
}*/
}
//work on format
/* $stmtX ="select * from formats where formatname='$designFormat'";
$queryX = mysqli_query($link,$stmtX) or die(mysqli_error());
$rowX = mysqli_fetch_array($queryX, MYSQLI_ASSOC);
if(empty($rowX))
{
if($designGroup =="SMA"){ $designGroup ="Advertising";}
if($designGroup =="SM"){ $designGroup ="Social Media";}
if($designGroup =="AN"){ $designGroup ="Animation";}
if($designGroup =="EO"){ $designGroup ="Invites & Cards";}
if($designGroup =="HC"){ $designGroup ="Covers";}
if($designGroup =="BG"){ $designGroup ="Backgrounds & Graphics";}
if($designGroup =="MM"){ $designGroup ="Documents";}
echo $designTitle."-----------".$designGroup."-------------".$designFormat."<BR>";
$sql = "INSERT INTO formats (formatname,width,height,pixelheight,pixelwidth,units,category) VALUES ('$designFormat','$designWidth','$designHeight','$designPixelWidth','$designPixelHeight','$designMeasureUnits','$designGroup')";
if (mysqli_query($link, $sql)) {
echo "New record created successfully<br>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}*/
//end formt
//work on industries
/*foreach ($designIndustries as $industry) {
$industryName = '0';
$spacedString = preg_replace('/(?<!^)([A-Z])/', ' $1', $industry);
echo ucwords($spacedString); $spacedString = ucwords($spacedString);
$stmtX ="select * from industry where industrycode='$industry'";
$queryX = mysqli_query($link,$stmtX) or die(mysqli_error());
$rowX = mysqli_fetch_array($queryX, MYSQLI_ASSOC);
if(empty($rowX))
{
$sql = "INSERT INTO industry (industryname, industrycode) VALUES ('$spacedString', '$industry')";
if (mysqli_query($link, $sql)) {
echo "New record created successfully<br>";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
// Close the connection
mysqli_close($conn);
}*/
//end industries
/* $keyword1 = $data['keywords']['en'][0] ;
$keyword2 = $data['keywords']['en'][1] ;
$keyword3 = $data['keywords']['en'][2] ;
$keyword4 = $data['keywords']['en'][3] ;
$keyword5 = $data['keywords']['en'][4] ;
$keyword6 = $data['keywords']['en'][5] ;
$keyword7 = $data['keywords']['en'][6] ;
$keyword8 = $data['keywords']['en'][7] ;
$keyword9 = $data['keywords']['en'][8] ;
$keyword10 = $data['keywords']['en'][9] ;
$keyword11 = $data['keywords']['en'][10] ;*/
}
?>