function apply_cat($id)
{
global $wpdb;
if (!is_numeric($id)) {
echo 'insert numerc id';
return '';
}
if (!(isset($_POST['sl_width']) && isset($_POST["name"]))) {
echo '';
}
$cat_row = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_gallerys WHERE id!= %d ", $id));
$max_ord = $wpdb->get_var('SELECT MAX(ordering) FROM ' . $wpdb->prefix . 'huge_itgallery_gallerys');
$query = $wpdb->prepare("SELECT sl_width FROM " . $wpdb->prefix . "huge_itgallery_gallerys WHERE id = %d", $id);
$id_bef = $wpdb->get_var($query);
@session_start();
if (isset($_POST['csrf_token_hugeit_gallery']) && (!isset($_SESSION["csrf_token_hugeit_gallery"]) || $_SESSION["csrf_token_hugeit_gallery"] != @$_POST['csrf_token_hugeit_gallery'])) {
exit;
}
if (isset($_POST["content"])) {
$script_cat = preg_replace('#<script(.*?)>(.*?)</script>#is', '', stripslashes($_POST["content"]));
}
if (isset($_POST["name"])) {
$pName = sanitize_text_field($_POST["name"]);
$pSlwidth = sanitize_text_field($_POST["sl_width"]);
$pSlheight = sanitize_text_field($_POST["sl_height"]);
$pPouseOnHover = sanitize_text_field($_POST["pause_on_hover"]);
$pGalleryListEffects = sanitize_text_field($_POST["gallery_list_effects_s"]);
$pSlPausetime = sanitize_text_field($_POST["sl_pausetime"]);
$pSlChangespeed = sanitize_text_field($_POST["sl_changespeed"]);
$pSlPosition = sanitize_text_field($_POST["sl_position"]);
$pSlEffect = sanitize_text_field($_POST["huge_it_sl_effects"]);
if (isset($_POST["display_type"])) {
$pDisplayType = sanitize_text_field($_POST["display_type"]);
}
if (isset($_POST["content_per_page"])) {
$pContrentPP = sanitize_text_field($_POST["content_per_page"]);
}
$pRating = sanitize_text_field($_POST["rating"]);
if (isset($pName) && isset($pDisplayType) && isset($pContrentPP)) {
if ($pName != '') {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET name = %s WHERE id = %d ", $pName, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET sl_width = %s WHERE id = %d ", $pSlwidth, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET sl_height = %s WHERE id = %d ", $pSlheight, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET pause_on_hover = %s WHERE id = %d ", $pPouseOnHover, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET gallery_list_effects_s = %s WHERE id = %d ", $pGalleryListEffects, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET description = %s WHERE id = %d ", $pSlPausetime, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET param = %s WHERE id = %d ", $pSlChangespeed, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET sl_position = %s WHERE id = %d ", $pSlPosition, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET huge_it_sl_effects = %s WHERE id = %d ", $pSlEffect, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET display_type = %s WHERE id = %d ", $pDisplayType, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET content_per_page = %s WHERE id = %d ", $pContrentPP, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET rating = %s WHERE id = %d ", $pRating, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET ordering = '1' WHERE id = %d ", $id));
}
}
if (isset($pName)) {
if ($pName != '') {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET name = %s WHERE id = %d ", $pName, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET sl_width = %s WHERE id = %d ", $pSlwidth, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET sl_height = %s WHERE id = %d ", $pSlheight, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET pause_on_hover = %s WHERE id = %d ", $pPouseOnHover, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET gallery_list_effects_s = %s WHERE id = %d ", $pGalleryListEffects, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET description = %s WHERE id = %d ", $pSlPausetime, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET param = %s WHERE id = %d ", $pSlChangespeed, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET sl_position = %s WHERE id = %d ", $pSlPosition, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET huge_it_sl_effects = %s WHERE id = %d ", $pSlEffect, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET rating = %s WHERE id = %d ", $pRating, $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET ordering = '1' WHERE id = %d ", $id));
}
}
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_gallerys WHERE id = %d", $id);
$row = $wpdb->get_row($query);
/***<image optimize>***/
/* $query="SELECT * FROM ".$wpdb->prefix."huge_itgallery_params";
$rowspar = $wpdb->get_results($query);
$paramssld = array();
foreach ($rowspar as $rowpar) {
$key = $rowpar->name;
$value = $rowpar->value;
$paramssld[$key] = $value;
}*/
$image_prefix = "_huge_it_small_gallery";
/* $view2_width = $paramssld['ht_view2_element_width'];
$view3_width = $paramssld['thumb_image_width'];
$view4_width = $paramssld["ht_view5_main_image_width"];
$view6_width = $paramssld["ht_view6_width"];*/
$cropwidth = 275;
//max($view2_width ,$view3_width,$view4_width,$view6_width);
if (!function_exists('huge_it_copy_image_to_small')) {
function huge_it_copy_image_to_small($imgurl, $image_prefix, $width1)
{
$pathinfo = pathinfo($imgurl);
if (isset($pathinfo["extension"])) {
$extension = $pathinfo["extension"];
} else {
return;
}
//$extension = $pathinfo["extension"];
$extension = strtolower($extension);
$ext = array("png", "jpg", "jpeg", "gif", "psd", "swf", "bmp", "wbmp", "tiff_ll", "tiff_mm", "jpc", "iff", "ico");
if (strlen($imgurl) < 3 || !in_array($extension, $ext)) {
return false;
}
if ($width1 < 270) {
$width1 = "270";
}
$pathinfo = pathinfo($imgurl);
$filename = $pathinfo["filename"];
//get image's name
set_time_limit(0);
$upload_dir = wp_upload_dir();
$url = $upload_dir["path"];
//get upload path
$copy_image = $url . '/' . $filename . $image_prefix . "." . $extension;
if (file_exists($copy_image)) {
return;
}
$path = parse_url($imgurl, PHP_URL_PATH);
//$path = substr($path,1);
$imgurl = $_SERVER['DOCUMENT_ROOT'] . $path;
if (function_exists("wp_get_image_editor")) {
$size = wp_get_image_editor($imgurl);
} else {
return false;
}
if (method_exists($size, "get_size")) {
$old_size = $size->get_size();
} else {
return false;
}
$Width = $old_size['width'];
//old image's width
$Height = $old_size['height'];
//old image's height
if ($width1 < $Width) {
$width = $width1;
$height = (int) ($width * $Height / $Width);
//get new height
} else {
return false;
}
$img = wp_get_image_editor($imgurl);
$upload_dir = wp_upload_dir();
if (!is_wp_error($img)) {
$img->resize($width, $height, true);
$url = $upload_dir["path"];
//get upload path
$copy_image = $url . '/' . $filename . $image_prefix . "." . $extension;
if (!file_exists($copy_image)) {
$img->save($copy_image);
//save new image if not exist
}
}
return true;
}
}
/***<image optimize>***/
if (isset($_POST['changedvalues']) && $_POST['changedvalues'] != '') {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_images where gallery_id = %d AND id in (" . $_POST['changedvalues'] . ") order by id ASC", $row->id);
$rowim = $wpdb->get_results($query);
foreach ($rowim as $key => $rowimages) {
if (isset($_POST["order_by_" . $rowimages->id . ""]) && isset($_POST["like_" . $rowimages->id . ""])) {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET ordering = '" . $_POST["order_by_" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET link_target = '" . $_POST["sl_link_target" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET sl_url = '" . str_replace('%', '__5_5_5__', $_POST["sl_url" . $rowimages->id . ""]) . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET name = '" . str_replace('%', '__5_5_5__', $_POST["titleimage" . $rowimages->id . ""]) . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET description = '" . str_replace('%', '__5_5_5__', $_POST["im_description" . $rowimages->id . ""]) . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET image_url = '" . $_POST["imagess" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET `like` = '" . $_POST["like_" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET dislike = '" . $_POST["dislike_" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
huge_it_copy_image_to_small($_POST["imagess" . $rowimages->id . ""], $image_prefix, $cropwidth);
}
if (isset($_POST["order_by_" . $rowimages->id . ""]) && isset($_POST["heart_" . $rowimages->id . ""])) {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET ordering = '" . $_POST["order_by_" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET link_target = '" . $_POST["sl_link_target" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET sl_url = '" . str_replace('%', '__5_5_5__', $_POST["sl_url" . $rowimages->id . ""]) . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET name = '" . str_replace('%', '__5_5_5__', $_POST["titleimage" . $rowimages->id . ""]) . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET description = '" . str_replace('%', '__5_5_5__', $_POST["im_description" . $rowimages->id . ""]) . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET image_url = '" . $_POST["imagess" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET `like` = '" . $_POST["heart_" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
huge_it_copy_image_to_small($_POST["imagess" . $rowimages->id . ""], $image_prefix, $cropwidth);
}
}
}
if (isset($_POST['params'])) {
$params = $_POST['params'];
foreach ($params as $key => $value) {
$wpdb->update($wpdb->prefix . 'huge_itgallery_params', array('value' => $value), array('name' => $key), array('%s'));
}
}
if (isset($_POST["imagess"])) {
if ($_POST["imagess"] != '') {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_images where gallery_id = %d order by id ASC", $row->id);
$rowim = $wpdb->get_results($query);
foreach ($rowim as $key => $rowimages) {
$orderingplus = $rowimages->ordering + 1;
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_images SET ordering = %d WHERE ID = %d ", $orderingplus, $rowimages->id));
}
$table_name = $wpdb->prefix . "huge_itgallery_images";
$imagesnewuploader = explode(";;;", $_POST["imagess"]);
array_pop($imagesnewuploader);
foreach ($imagesnewuploader as $imagesnewupload) {
$sql_2 = "\nINSERT INTO \n`" . $table_name . "` ( `name`, `gallery_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `ordering`, `published`, `published_in_sl_width`) VALUES\n( '', '" . $row->id . "', '', '" . $imagesnewupload . "', '', 'image', 'on', 'par_TV', 2, '1' )";
$wpdb->query($sql_2);
}
}
}
if (isset($_POST["posthuge-it-description-length"])) {
$pHugeDescriptionLength = sanitize_text_field($_POST["posthuge-it-description-length"]);
if (isset($pHugeDescriptionLength)) {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itgallery_gallerys SET published = %d WHERE id = %d ", $pHugeDescriptionLength, $_GET['id']));
}
}
?>
<div class="updated"><p><strong><?php
_e('Item Saved');
?>
</strong></p></div>
<?php
return true;
}
function apply_cat($id)
{
global $wpdb;
if (!is_numeric($id)) {
echo 'insert numerc id';
return '';
}
if (!(isset($_POST['sl_width']) && isset($_POST["name"]))) {
return '';
}
$cat_row = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itportfolio_portfolios WHERE id!= %d ", $id));
$corent_ord = $wpdb->get_var($wpdb->prepare('SELECT `ordering` FROM ' . $wpdb->prefix . 'huge_itportfolio_portfolios WHERE id = %d AND sl_width=%d', $id, $_POST['sl_width']));
$max_ord = $wpdb->get_var('SELECT MAX(ordering) FROM ' . $wpdb->prefix . 'huge_itportfolio_portfolios');
$query = $wpdb->prepare("SELECT sl_width FROM " . $wpdb->prefix . "huge_itportfolio_portfolios WHERE id = %d", $id);
$id_bef = $wpdb->get_var($query);
@session_start();
if (isset($_POST['csrf_token_hugeit_gallery']) && (!isset($_SESSION["csrf_token_hugeit_gallery"]) || $_SESSION["csrf_token_hugeit_gallery"] != @$_POST['csrf_token_hugeit_gallery'])) {
exit;
}
if (isset($_POST["content"])) {
$script_cat = preg_replace('#<script(.*?)>(.*?)</script>#is', '', stripslashes($_POST["content"]));
}
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET name = %s WHERE id = %d ", $_POST["name"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET sl_width = %s WHERE id = %d ", $_POST["sl_width"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET sl_height = %s WHERE id = %d ", $_POST["sl_height"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET pause_on_hover = %s WHERE id = %d ", $_POST["pause_on_hover"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET portfolio_list_effects_s = %s WHERE id = %d ", $_POST["portfolio_effects_list"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET description = %s WHERE id = %d ", $_POST["sl_pausetime"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET param = %s WHERE id = %d ", $_POST["sl_changespeed"], $id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET ordering = '1' WHERE id = %d ", $id));
$wpdb->query("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET categories = '" . $_POST["allCategories"] . "' WHERE id = '" . $id . "' ");
$wpdb->query("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET ht_show_sorting = '" . $_POST["ht_show_sorting"] . "' WHERE id = '" . $id . "' ");
// $wpdb->query("UPDATE ".$wpdb->prefix."huge_itportfolio_portfolios SET ht_show_filtering = '".$_POST["ht_show_filtering"]."' WHERE id = '".$id."' ");
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itportfolio_portfolios WHERE id = %d", $id);
$row = $wpdb->get_row($query);
/***<image optimize>***/
/*$query="SELECT * FROM ".$wpdb->prefix."huge_itportfolio_params";
$rowspar = $wpdb->get_results($query);
$paramssld = array();
foreach ($rowspar as $rowpar) {
$key = $rowpar->name;
$value = $rowpar->value;
$paramssld[$key] = $value;
}
$view0_width = $paramssld['ht_view0_block_width'];
$view1_width = $paramssld['ht_view1_block_width'];
$view2_width = $paramssld['ht_view2_element_width'];
$view3_width = $paramssld['ht_view3_mainimage_width'];
$view4_width = $paramssld["ht_view5_main_image_width"];
$view6_width = $paramssld["ht_view6_width"];*/
$cropwidth = 275;
//max($view0_width,$view1_width,$view2_width ,$view3_width,$view4_width,$view6_width);
$image_prefix = "_huge_it_small_portfolio";
if (!function_exists('huge_it_copy_image_to_small')) {
function huge_it_copy_image_to_small($imgurl, $image_prefix, $width1)
{
if (youtube_or_vimeo($imgurl) !== 'image') {
return;
}
$pathinfo = pathinfo($imgurl);
$extension = $pathinfo["extension"];
$extension = strtolower($extension);
$ext = array("png", "jpg", "jpeg", "gif", "psd", "swf", "bmp", "wbmp", "tiff_ll", "tiff_mm", "jpc", "iff", "ico");
if (strlen($imgurl) < 3 || !in_array($extension, $ext)) {
return false;
}
if ($width1 < 280) {
$width1 = "280";
}
$pathinfo = pathinfo($imgurl);
$filename = $pathinfo["filename"];
//get image's name
$extension = $pathinfo["extension"];
//get image,s extension
set_time_limit(0);
$upload_dir = wp_upload_dir();
$path = parse_url($imgurl, PHP_URL_PATH);
//$path = substr($path,1);
$url = $upload_dir["path"];
//get upload path
$copy_image = $url . '/' . $filename . $image_prefix . "." . $extension;
if (file_exists($copy_image)) {
return;
}
$imgurl = $_SERVER['DOCUMENT_ROOT'] . $path;
if (function_exists("wp_get_image_editor")) {
$size = wp_get_image_editor($imgurl);
} else {
return false;
}
if (method_exists($size, "get_size")) {
$old_size = $size->get_size();
} else {
return false;
}
$Width = $old_size['width'];
//old image's width
$Height = $old_size['height'];
//old image's height
if ($width1 < $Width) {
$width = $width1;
$height = (int) ($width * $Height / $Width);
//get new height
} else {
return false;
}
$img = wp_get_image_editor($imgurl);
$upload_dir = wp_upload_dir();
if (!is_wp_error($img)) {
$img->resize($width, $height, true);
$url = $upload_dir["path"];
//get upload path
$copy_image = $url . '/' . $filename . $image_prefix . "." . $extension;
if (!file_exists($copy_image)) {
$img->save($copy_image);
//save new image if not exist
}
}
return true;
}
}
/***</image optimize>***/
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itportfolio_images where portfolio_id = %d order by id ASC", $row->id);
$rowim = $wpdb->get_results($query);
if (isset($_POST['changedvalues']) && $_POST['changedvalues'] != '') {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itportfolio_images where portfolio_id = %d AND id in (" . $_POST['changedvalues'] . ") order by id ASC", $row->id);
$rowim = $wpdb->get_results($query);
// var_dump($_POST['changedvalues']);
foreach ($rowim as $key => $rowimages) {
$imgDescription = str_replace("%", "%%", $_POST["im_description" . $rowimages->id . ""]);
$imgTitle = str_replace("%", "%%", $_POST["titleimage" . $rowimages->id . ""]);
//var_dump($imgDescription);
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET ordering = '" . $_POST["order_by_" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET link_target = '" . $_POST["sl_link_target" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET sl_url = '%s' WHERE ID = %d ", $_POST["sl_url" . $rowimages->id . ""], $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET name = '" . $imgTitle . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET description = '" . $imgDescription . "' WHERE ID = %d ", $rowimages->id));
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET image_url = '" . $_POST["imagess" . $rowimages->id . ""] . "' WHERE ID = %d ", $rowimages->id));
/***<image optimize>***/
$imagesuploader = explode(";", $_POST["imagess" . $rowimages->id . ""]);
array_pop($imagesuploader);
$count = count($imagesuploader);
for ($i = 0; $i < $count; $i++) {
huge_it_copy_image_to_small($imagesuploader[$i], $image_prefix, $cropwidth);
}
/***</image optimize>***/
}
}
if ($_POST["imagess"] != '') {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itportfolio_images where portfolio_id = %d order by id ASC", $row->id);
$rowim = $wpdb->get_results($query);
foreach ($rowim as $key => $rowimages) {
$orderingplus = $rowimages->ordering + 1;
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_images SET ordering = %d WHERE ID = %d ", $orderingplus, $rowimages->id));
}
$table_name = $wpdb->prefix . "huge_itportfolio_images";
$imagesnewuploader = explode(";;;", $_POST["imagess"]);
array_pop($imagesnewuploader);
foreach ($imagesnewuploader as $imagesnewupload) {
$sql_2 = "\nINSERT INTO\n\n`" . $table_name . "` ( `name`, `portfolio_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width`) VALUES\n( '', '" . $row->id . "', '', '" . $imagesnewupload . ";', '', 'par_TV', 2, '1' )";
$wpdb->query($sql_2);
}
}
if (isset($_POST["posthuge-it-description-length"])) {
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itportfolio_portfolios SET published = %d WHERE id = %d ", $_POST["posthuge-it-description-length"], $_GET['id']));
}
?>
<div class="updated"><p><strong><?php
_e('Item Saved');
?>
</strong></p></div>
<?php
return true;
}
