function editgallery($id)
{
global $wpdb;
if (isset($_POST["huge_it_sl_effects"])) {
if (isset($_GET["removeslide"])) {
if ($_GET["removeslide"] != '') {
$idfordelete = $_GET["removeslide"];
$wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->prefix . "huge_itgallery_images WHERE id = %d ", $idfordelete));
}
}
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_gallerys WHERE id= %d", $id);
$row = $wpdb->get_row($query);
if (!isset($row->gallery_list_effects_s)) {
return 'id not found';
}
$images = explode(";;;", $row->gallery_list_effects_s);
$par = explode(' ', $row->param);
$count_ord = count($images);
$cat_row = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_gallerys WHERE id!= %d and sl_width=0", $id));
$cat_row = open_cat_in_tree($cat_row);
$query = $wpdb->prepare("SELECT name,ordering FROM " . $wpdb->prefix . "huge_itgallery_gallerys WHERE sl_width=%d ORDER BY `ordering` ", $row->sl_width);
$ord_elem = $wpdb->get_results($query);
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itgallery_images where gallery_id = %d order by ordering ASC ", $row->id);
$rowim = $wpdb->get_results($query);
if (isset($_GET["addslide"])) {
if ($_GET["addslide"] == 1) {
$table_name = $wpdb->prefix . "huge_itgallery_images";
$sql_2 = "\r\r\nINSERT INTO \r\r\n\r\r\n`" . $table_name . "` ( `name`, `gallery_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width`) VALUES\r\r\n( '', '" . $row->id . "', '', '', '', 'par_TV', 2, '1' )";
$wpdb->query($sql_huge_itgallery_images);
$wpdb->query($sql_2);
}
}
$query = "SELECT * FROM " . $wpdb->prefix . "huge_itgallery_gallerys order by id ASC";
$rowsld = $wpdb->get_results($query);
$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;
}
$query = "SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' order by id ASC";
$rowsposts = $wpdb->get_results($query);
$rowsposts8 = '';
$postsbycat = '';
if (isset($_POST["iframecatid"])) {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "term_relationships where term_taxonomy_id = %d order by object_id ASC", $_POST["iframecatid"]);
$rowsposts8 = $wpdb->get_results($query);
foreach ($rowsposts8 as $rowsposts13) {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' and ID = %d order by ID ASC", $rowsposts13->object_id);
$rowsposts1 = $wpdb->get_results($query);
$postsbycat = $rowsposts1;
}
}
Html_editgallery($ord_elem, $count_ord, $images, $row, $cat_row, $rowim, $rowsld, $paramssld, $rowsposts, $rowsposts8, $postsbycat);
}
function add_category()
{
global $wpdb;
$query = "SELECT name,ordering FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE parent=0 ORDER BY `ordering`";
$ord_elem = $wpdb->get_results($query);
///////ordering elements list
$cat_row = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercatalog_product_categories where parent=0");
$cat_row = open_cat_in_tree($cat_row);
html_add_category($ord_elem, $cat_row);
}
function popup_posts($id)
{
global $wpdb;
if (isset($_GET["removeslide"])) {
if ($_GET["removeslide"] != '') {
$wpdb->query("DELETE FROM " . $wpdb->prefix . "huge_itslider_images WHERE id = " . $_GET["removeslide"] . " ");
}
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE id= %d", $id);
$row = $wpdb->get_row($query);
if (!isset($row->slider_list_effects_s)) {
return 'id not found';
}
$images = explode(";;;", $row->slider_list_effects_s);
$par = explode(' ', $row->param);
$count_ord = count($images);
$cat_row = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE id!=" . $id . " and sl_width=0");
$cat_row = open_cat_in_tree($cat_row);
$query = $wpdb->prepare("SELECT name,ordering FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE sl_width=%d ORDER BY `ordering` ", $row->sl_width);
$ord_elem = $wpdb->get_results($query);
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_images where slider_id = %d order by id ASC ", $row->id);
$rowim = $wpdb->get_results($query);
if (isset($_GET["addslide"])) {
if ($_GET["addslide"] == 1) {
$table_name = $wpdb->prefix . "huge_itslider_images";
$sql_2 = "\nINSERT INTO \n\n`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width`) VALUES\n( '', '" . $row->id . "', '', '', '', 'par_TV', 2, '1' )";
$wpdb->query($sql_huge_itslider_images);
$wpdb->query($sql_2);
}
}
$query = "SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders order by id ASC";
$rowsld = $wpdb->get_results($query);
$query = "SELECT * from " . $wpdb->prefix . "huge_itslider_params ";
$rowspar = $wpdb->get_results($query);
$paramssld = array();
foreach ($rowspar as $rowpar) {
$key = $rowpar->name;
$value = $rowpar->value;
$paramssld[$key] = $value;
}
$query = "SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' order by id ASC";
$rowsposts = $wpdb->get_results($query);
$categories = get_categories();
if (isset($_POST["iframecatid"])) {
$iframecatid = $_POST["iframecatid"];
} else {
$iframecatid = $categories[0]->cat_ID;
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "term_relationships where term_taxonomy_id = %d order by object_id ASC", $iframecatid);
$rowsposts8 = $wpdb->get_results($query);
foreach ($rowsposts8 as $rowsposts13) {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' and ID = %d order by ID ASC", $rowsposts13->object_id);
$rowsposts1 = $wpdb->get_results($query);
$postsbycat = $rowsposts1;
}
if (isset($_GET["closepop"])) {
if ($_GET["closepop"] == 1) {
if (!$_POST["lastposts"]) {
$wpdb->query("UPDATE " . $wpdb->prefix . "huge_itslider_sliders SET published = '" . $_POST["posthuge-it-description-length"] . "' WHERE id = '" . $_GET['id'] . "' ");
}
}
}
if (isset($_POST["lastposts"])) {
$query = "SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' order by id DESC LIMIT 0, " . $_POST["lastposts"] . "";
$rowspostslast = $wpdb->get_results($query);
foreach ($rowspostslast as $rowspostslastfor) {
$my_id = $rowspostslastfor;
$post_id_1 = get_post($my_id);
$post_image = wp_get_attachment_url(get_post_thumbnail_id($rowspostslastfor));
$posturl = get_permalink($rowspostslastfor);
$table_name = $wpdb->prefix . "huge_itslider_images";
$descnohtmlno = strip_tags($post_id_1->post_content);
$descnohtmlno1 = html_entity_decode($descnohtmlno);
$lengthtextpost = '300';
$descnohtmlno2 = substr_replace($descnohtmlno1, "", $lengthtextpost);
$descnohtmlno3 = htmlentities($descnohtmlno2, ENT_QUOTES, "UTF-8");
$posttitle = htmlentities($post_id_1->post_title, ENT_QUOTES, "UTF-8");
$posturl2 = htmlentities($posturl, ENT_QUOTES, "UTF-8");
$sql_lastposts = "INSERT INTO \n`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width`) VALUES\n( '" . $posttitle . "', '" . $row->id . "', '" . $descnohtmlno3 . "', '" . $post_image . "', '" . $posturl . "', 'par_TV', 2, '1' )";
$wpdb->query($sql_huge_itslider_images);
$wpdb->query($sql_lastposts);
}
}
Html_popup_posts($ord_elem, $count_ord, $images, $row, $cat_row, $rowim, $rowsld, $paramssld, $rowsposts, $rowsposts8, $postsbycat);
}
function addProduct()
{
global $wpdb;
$params = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercatalog_params");
$new_param = array();
foreach ($params as $param) {
$new_param[$param->name] = $param->value;
}
$params = $new_param;
$query = "SELECT id,name FROM " . $wpdb->prefix . "spidercatalog_product_categories where published=1";
$rows1 = $wpdb->get_results($query);
$category_id['0'] = array('value' => '0', 'text' => 'Uncategorised');
$query = "SELECT ordering,name FROM " . $wpdb->prefix . "spidercatalog_products order by ordering";
$rows1 = $wpdb->get_results($query);
$cat_row = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercatalog_product_categories where parent=0");
$cat_row = open_cat_in_tree($cat_row);
$lists = $wpdb->get_results("SELECT ordering,name FROM " . $wpdb->prefix . "spidercatalog_products order by ordering");
html_addProduct($lists, $params, $rows1, $cat_row);
}
function popup_posts($id)
{
global $wpdb;
if (isset($_GET["removeslide"])) {
$getremove = intval($_GET["removeslide"]);
if ($getremove != 0) {
$wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->prefix . "huge_itslider_images WHERE id = %d ", $getremove));
// $wpdb->query("DELETE FROM ".$wpdb->prefix."huge_itslider_images WHERE id = ".$_GET["removeslide"]." ");
}
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE id= %d", $id);
$row = $wpdb->get_row($query);
if (!isset($row->slider_list_effects_s)) {
return 'id not found';
}
$images = explode(";;;", $row->slider_list_effects_s);
$par = explode(' ', $row->param);
$count_ord = count($images);
$cat_row = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE id!=" . $id . " and sl_width=0");
$cat_row = open_cat_in_tree($cat_row);
$query = $wpdb->prepare("SELECT name,ordering FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE sl_width=%d ORDER BY `ordering` ", $row->sl_width);
$ord_elem = $wpdb->get_results($query);
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_images where slider_id = %d order by id ASC ", $row->id);
$rowim = $wpdb->get_results($query);
if (isset($_GET["addslide"])) {
$getaddslide = intval($_GET["addslide"]);
if ($getaddslide == 1) {
$table_name = $wpdb->prefix . "huge_itslider_images";
// $sql_2 = "
//INSERT INTO
//
//`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width`) VALUES
//( '', '".$row->id."', '', '', '', 'par_TV', 2, '1' )";
$wpdb->query($sql_huge_itslider_images);
// $wpdb->query($sql_2);
}
}
$query = "SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders order by id ASC";
$rowsld = $wpdb->get_results($query);
$query = "SELECT * from " . $wpdb->prefix . "huge_itslider_params ";
$rowspar = $wpdb->get_results($query);
$paramssld = array();
foreach ($rowspar as $rowpar) {
$key = $rowpar->name;
$value = $rowpar->value;
$paramssld[$key] = $value;
}
$query = "SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' order by id ASC";
$rowsposts = $wpdb->get_results($query);
$categories = get_categories();
if (isset($_POST["iframecatid"])) {
$iframecatid = esc_html($_POST["iframecatid"]);
} else {
if (isset($categories[0]->cat_ID)) {
$iframecatid = $categories[0]->cat_ID;
} else {
$iframecatid = '';
}
}
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "term_relationships where term_taxonomy_id = %d order by object_id ASC", $iframecatid);
$rowsposts8 = $wpdb->get_results($query);
foreach ($rowsposts8 as $rowsposts13) {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' and ID = %d order by ID ASC", $rowsposts13->object_id);
$rowsposts1 = $wpdb->get_results($query);
$postsbycat = $rowsposts1;
}
global $wpdb;
if (isset($_GET["closepop"])) {
$getclosepopup = intval($_GET["closepop"]);
if ($getclosepopup == 1) {
if (isset($_POST["popupposts"])) {
$postpopupposts = esc_html($_POST["popupposts"]);
if ($postpopupposts != 'none' and $postpopupposts != '') {
$popuppostsposts = explode(";", $_POST["popupposts"]);
array_pop($popuppostsposts);
foreach ($popuppostsposts as $popuppostsposts1) {
$my_id = $popuppostsposts1;
$post_id_1 = get_post($my_id);
$post_image = wp_get_attachment_url(get_post_thumbnail_id($popuppostsposts1));
$posturl = get_permalink($popuppostsposts1);
$table_name = $wpdb->prefix . "huge_itslider_images";
$descnohtmlnoq = strip_tags($post_id_1->post_content);
$descnohtmlnoq1 = html_entity_decode($descnohtmlnoq);
$descnohtmlnoq1 = htmlentities($descnohtmlnoq1, ENT_QUOTES, "UTF-8");
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_images where slider_id = %d order by id ASC", $row->id);
$rowplusorder = $wpdb->get_results($query);
foreach ($rowplusorder as $key => $rowplusorders) {
$rowplusorderspl = $rowplusorders->ordering + 1;
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itslider_images SET ordering = '" . $rowplusorderspl . "' WHERE id = %d ", $rowplusorders->id));
}
}
}
}
if (!isset($_POST["lastposts"])) {
if (isset($_POST["posthuge-it-description-length"])) {
$POST_hugeit_description_length = intval($_POST["posthuge-it-description-length"]);
$table_name = $wpdb->prefix . "huge_itslider_sliders";
$wpdb->query($wpdb->prepare("UPDATE %s huge_itslider_sliders SET published = %d WHERE id = ", $table_name, intval($_GET['id'])));
}
}
}
}
if (isset($_POST["lastposts"])) {
$_POST["lastposts"] = esc_html($_POST["lastposts"]);
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "posts where post_type = 'post' and post_status = 'publish' order by id DESC LIMIT 0, " . $_POST["lastposts"] . "");
$rowspostslast = $wpdb->get_results($query);
foreach ($rowspostslast as $rowspostslastfor) {
$my_id = $rowspostslastfor;
$post_id_1 = get_post($my_id);
$post_image = wp_get_attachment_url(get_post_thumbnail_id($rowspostslastfor));
$posturl = get_permalink($rowspostslastfor);
$table_name = $wpdb->prefix . "huge_itslider_images";
$descnohtmlno = strip_tags($post_id_1->post_content);
$descnohtmlno1 = html_entity_decode($descnohtmlno);
$lengthtextpost = '300';
$descnohtmlno2 = substr_replace($descnohtmlno1, "", $lengthtextpost);
$descnohtmlno3 = htmlentities($descnohtmlno2, ENT_QUOTES, "UTF-8");
$posttitle = htmlentities($post_id_1->post_title, ENT_QUOTES, "UTF-8");
$posturl2 = htmlentities($posturl, ENT_QUOTES, "UTF-8");
$wpdb->query($wpdb->prepare("INSERT INTO `" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width` ) VALUES ( '%s', '%s', '%s', '%s', '%s', '0', 2, '1' )", $posttitle, $row->id, $descnohtmlno3, $post_image, $posturl));
// $sql_lastposts = "INSERT INTO
//`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `ordering`, `published`, `published_in_sl_width`) VALUES
//( '".$posttitle."', '".$row->id."', '".$descnohtmlno3."', '".$post_image ."', '".$posturl."', '0', 2, '1' )";
$wpdb->query($sql_huge_itslider_images);
// $wpdb->query($sql_lastposts);
}
}
if (isset($_POST["addlastposts"])) {
$_POST["addlastposts"] = esc_html($_POST["addlastposts"]);
if ($_POST["addlastposts"] == 'addlastposts') {
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_images where slider_id = %d order by id ASC", $row->id);
$rowplusorder = $wpdb->get_results($query);
foreach ($rowplusorder as $key => $rowplusorders) {
$rowplusorderspl = $rowplusorders->ordering + 1;
$wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "huge_itslider_images SET ordering = '" . $rowplusorderspl . "' WHERE id = %d ", $rowplusorders->id));
}
$table_name = $wpdb->prefix . "huge_itslider_images";
$sql_addlastposts = $wpdb->query($wpdb->prepare("INSERT INTO `" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `sl_stitle`, `sl_sdesc`, `sl_postlink`, `ordering`, `published`, `published_in_sl_width` ) VALUES" . "( '%s', '%s', '%s', '', '%s', 'last_posts', '%s', '%s', '%s', '%s', '0', '2', '1' )", $_POST["titleimage"], $row->id, $_POST["im_description"], $_POST["sl_url"], $_POST["sl_link_target"], $_POST["sl_stitle"], $_POST["sl_sdesc"], $_POST["sl_postlink"]));
//$sql_addlastposts = " INSERT INTO
//`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `sl_stitle`, `sl_sdesc`, `sl_postlink`, `ordering`, `published`, `published_in_sl_width`) VALUES
//( '".$_POST["titleimage"]."', '".$row->id."', '".$_POST["im_description"]."', '', '".$_POST["sl_url"]."', 'last_posts', '".$_POST["sl_link_target"]."', '".$_POST["sl_stitle"]."', '".$_POST["sl_sdesc"]."', '".$_POST["sl_postlink"]."', '0', '2', '1' )";
//$wpdb->query($sql_addlastposts);
}
}
if (!isset($postsbycat)) {
$postsbycat = '';
}
Html_popup_posts($ord_elem, $count_ord, $images, $row, $cat_row, $rowim, $rowsld, $paramssld, $rowsposts, $rowsposts8, $postsbycat);
}
function showPublishedProducts_1($cat_id = 1, $show_cat_det = 1, $cels_or_list = '', $show_sub = 1, $show_sub_prod = 1, $show_prod = 1)
{
global $ident;
global $wpdb;
if ($cat_id == 'ALL_CAT') {
$cat_id = 0;
}
$params7['show_sub'] = $show_sub;
$params7['show_sub_prod'] = $show_sub_prod;
$params7['show_prod'] = $show_prod;
if (!isset($params7['show_sub'])) {
$params7['show_sub'] = 1;
}
if (!isset($params7['show_sub_prod'])) {
$params7['show_sub_prod'] = 2;
}
if (!isset($params7['show_prod'])) {
$params7['show_prod'] = 1;
}
$params = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "spidercatalog_params");
$new_param = array();
foreach ($params as $param) {
$new_param[$param->name] = $param->value;
}
$params = $new_param;
switch ($cels_or_list) {
case 'list':
$cels_or_list = 1;
$prod_in_page = $params['list_count_of_products_in_the_page'];
break;
case 'cells2':
$cels_or_list = 2;
$prod_in_page = $params['cells2_count_of_product_in_the_row'] * $params['cells2_count_of_rows_in_the_page'];
break;
case 'wcells':
$cels_or_list = 3;
$prod_in_page = $params['wcells_count_of_products_in_the_page'];
break;
case 'thumb':
$cels_or_list = 4;
$prod_in_page = $params['thumb_count_of_product_in_the_row'] * $params['thumb_count_of_rows_in_the_page'];
break;
case 'cells3':
$cels_or_list = 5;
$prod_in_page = $params['cells3_count_of_product_in_the_row'] * $params['cells3_count_of_rows_in_the_page'];
break;
case '':
$cels_or_list = 0;
$prod_in_page = $params['cells1_count_of_product_in_the_row'] * $params['cells1_count_of_rows_in_the_page'];
break;
}
$params1['show_category_details'] = $show_cat_det;
$params1['categories'] = $cat_id;
if (isset($_GET['page_num_' . $cels_or_list . '_' . $ident . ''])) {
$page_num = $_GET['page_num_' . $cels_or_list . '_' . $ident . ''];
} else {
$page_num = 1;
}
if (isset($_POST['cat_id_' . $cels_or_list . '_' . $ident . ''])) {
if ($_POST['cat_id_' . $cels_or_list . '_' . $ident . ''] != 0) {
$cat_id = (int) $_POST['cat_id_' . $cels_or_list . '_' . $ident . ''];
} else {
$cat_id = 0;
}
} else {
if (isset($_GET['cat_id_' . $cels_or_list . '_' . $ident . ''])) {
if ($_GET['cat_id_' . $cels_or_list . '_' . $ident . ''] != 0) {
$cat_id = (int) $_GET['cat_id_' . $cels_or_list . '_' . $ident . ''];
} else {
$cat_id = 0;
}
}
}
if (isset($_POST['subcat_id_' . $cels_or_list . '_' . $ident . '']) && $_POST['subcat_id_' . $cels_or_list . '_' . $ident . ''] != "") {
$subcat_id = (int) $_POST['subcat_id_' . $cels_or_list . '_' . $ident . ''];
} else {
$subcat_id = $cat_id;
}
$categ_query = "SELECT * FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE parent=" . $subcat_id . " AND `published`=1 ORDER BY `ordering` ASC ";
$child_ids = $wpdb->get_results($categ_query);
if (isset($_POST['prod_name_' . $cels_or_list . '_' . $ident . ''])) {
if ($_POST['prod_name_' . $cels_or_list . '_' . $ident . ''] != '' && $_POST['prod_name_' . $cels_or_list . '_' . $ident . ''] != __('Search...', 'sp_catalog')) {
$prod_name = esc_html(stripslashes($_POST['prod_name_' . $cels_or_list . '_' . $ident . '']));
} else {
$prod_name = '';
}
} else {
if (isset($_GET['prod_name_' . $cels_or_list . '_' . $ident . '']) && $_GET['prod_name_' . $cels_or_list . '_' . $ident . ''] != '' && $_GET['prod_name_' . $cels_or_list . '_' . $ident . ''] != __('Search...', 'sp_catalog')) {
$prod_name = esc_html(stripslashes($_GET['prod_name_' . $cels_or_list . '_' . $ident . '']));
} else {
$prod_name = '';
}
}
/*if ($cat_id > 0) {
$query_count = $wpdb->prepare("SELECT count(" . $wpdb->prefix . "spidercatalog_products.id) as prod_count FROM " . $wpdb->prefix . "spidercatalog_products left join " . $wpdb->prefix . "spidercatalog_product_categories on " . $wpdb->prefix . "spidercatalog_products.category_id=" . $wpdb->prefix . "spidercatalog_product_categories.id WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' and " . $wpdb->prefix . "spidercatalog_products.category_id= %d", $subcat_id);
if ($params7['show_sub_prod'] == 2) {
$query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercatalog_products.*, " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_products left join " . $wpdb->prefix . "spidercatalog_product_categories on " . $wpdb->prefix . "spidercatalog_products.category_id=" . $wpdb->prefix . "spidercatalog_product_categories.id WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' and (" . $wpdb->prefix . "spidercatalog_products.category_id=%d OR ( " . $wpdb->prefix . "spidercatalog_products.category_id IN (" . remov_last_storaket(get_cat_childs_ids($subcat_id)) . ") AND " . $wpdb->prefix . "spidercatalog_products.published_in_parent = '1')) ", $subcat_id);
} else if ($params7['show_sub_prod'] == 1) {
$query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercatalog_products.*, " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_products left join " . $wpdb->prefix . "spidercatalog_product_categories on " . $wpdb->prefix . "spidercatalog_products.category_id=" . $wpdb->prefix . "spidercatalog_product_categories.id WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' and (" . $wpdb->prefix . "spidercatalog_products.category_id=%d OR ( " . $wpdb->prefix . "spidercatalog_products.category_id IN (" . remov_last_storaket(get_cat_childs_ids($subcat_id)) . "))) ", $subcat_id);
} else {
$query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercatalog_products.*, " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_products left join " . $wpdb->prefix . "spidercatalog_product_categories on " . $wpdb->prefix . "spidercatalog_products.category_id=" . $wpdb->prefix . "spidercatalog_product_categories.id WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' and " . $wpdb->prefix . "spidercatalog_products.category_id=%d", $subcat_id);
}
$cat_query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE published = '1' and id= %d", $subcat_id);
}
else {
$query_count = "SELECT count(" . $wpdb->prefix . "spidercatalog_products.id) as prod_count FROM " . $wpdb->prefix . "spidercatalog_products WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' ";
$query = "SELECT " . $wpdb->prefix . "spidercatalog_products.*, " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_products left join " . $wpdb->prefix . "spidercatalog_product_categories on " . $wpdb->prefix . "spidercatalog_products.category_id=" . $wpdb->prefix . "spidercatalog_product_categories.id WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' ";
$cat_query = "SELECT " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE published = '1' ";
if ($cat_id != 0) {
if (is_numeric($cat_id) and $params7['show_sub_prod'] == 2) {
$query_count .= " and (" . $wpdb->prefix . "spidercatalog_products.category_id='" . $cat_id . "' OR ( " . $wpdb->prefix . "spidercatalog_products.category_id IN (" . remov_last_storaket(get_cat_childs_ids($cat_id)) . ") AND " . $wpdb->prefix . "spidercatalog_products.published_in_parent = '1'))";
$query .= " and (" . $wpdb->prefix . "spidercatalog_products.category_id='" . $cat_id . "' OR ( " . $wpdb->prefix . "spidercatalog_products.category_id IN (" . remov_last_storaket(get_cat_childs_ids($cat_id)) . ") AND " . $wpdb->prefix . "spidercatalog_products.published_in_parent = '1'))";
}
else if ($params7['show_sub_prod'] == 1) {
$query_count .= " and (" . $wpdb->prefix . "spidercatalog_products.category_id='" . $cat_id . "' OR ( " . $wpdb->prefix . "spidercatalog_products.category_id IN (" . remov_last_storaket(get_cat_childs_ids($cat_id)) . ")))";
$query .= " and (" . $wpdb->prefix . "spidercatalog_products.category_id='" . $cat_id . "' OR ( " . $wpdb->prefix . "spidercatalog_products.category_id IN (" . remov_last_storaket(get_cat_childs_ids($cat_id)) . ")))";
}
else {
$query_count .= " and " . $wpdb->prefix . "spidercatalog_products.category_id='" . $cat_id . "'";
$query .= " and " . $wpdb->prefix . "spidercatalog_products.category_id='" . $cat_id . "'";
}
}
}*/
if ($cat_id > 0) {
$words = remov_last_storaket(get_cat_childs_ids($subcat_id));
$words = explode(',', $words);
foreach ($words as $word) {
$sql[] = " (CONCAT(',', " . $wpdb->prefix . "spidercatalog_products.category_id) LIKE CONCAT('%,', '" . $word . "', ',%'))";
}
if ($params7['show_sub_prod'] == 2) {
$query = "SELECT " . $wpdb->prefix . "spidercatalog_products.* FROM " . $wpdb->prefix . "spidercatalog_products WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' and ((CONCAT(',', " . $wpdb->prefix . "spidercatalog_products.category_id)LIKE CONCAT('%,', '" . $subcat_id . "', ',%')) OR ((" . implode(" OR ", $sql) . ") AND " . $wpdb->prefix . "spidercatalog_products.published_in_parent = '1')) ";
} else {
if ($params7['show_sub_prod'] == 1) {
$query = "SELECT " . $wpdb->prefix . "spidercatalog_products.* FROM " . $wpdb->prefix . "spidercatalog_products WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' AND ((CONCAT(',', " . $wpdb->prefix . "spidercatalog_products.category_id)LIKE CONCAT('%,', '" . $subcat_id . "', ',%')) OR (" . implode(" OR ", $sql) . ")) ";
} else {
$query = "SELECT " . $wpdb->prefix . "spidercatalog_products.* FROM " . $wpdb->prefix . "spidercatalog_products WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' and CONCAT(',', " . $wpdb->prefix . "spidercatalog_products.category_id)LIKE CONCAT('%,', '" . $subcat_id . "', ',%')";
}
}
$cat_query = $wpdb->prepare("SELECT " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE published = '1' and id= %d", $subcat_id);
} else {
$query = "SELECT " . $wpdb->prefix . "spidercatalog_products.* FROM " . $wpdb->prefix . "spidercatalog_products WHERE " . $wpdb->prefix . "spidercatalog_products.published = '1' ";
$cat_query = "SELECT " . $wpdb->prefix . "spidercatalog_product_categories.name as cat_name," . $wpdb->prefix . "spidercatalog_product_categories.category_image_url as cat_image_url," . $wpdb->prefix . "spidercatalog_product_categories.description as cat_description FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE published = '1' ";
}
if ($prod_name != "") {
//$query_count .= " and (" . $wpdb->prefix . "spidercatalog_products.name like %s or " . $wpdb->prefix . "spidercatalog_products.description like %s ) ";
$prod_name = explode(' ', $prod_name);
foreach ($prod_name as $pr_name) {
$query .= " and (" . $wpdb->prefix . "spidercatalog_products.name like '%" . $pr_name . "%' or " . $wpdb->prefix . "spidercatalog_products.description like '%" . $pr_name . "%' or " . $wpdb->prefix . "spidercatalog_products.param like '%" . $pr_name . "%') ";
}
}
/*if ($prod_name != "") {
$query = $wpdb->prepare($query, "%" . $prod_name . "%", "%" . $prod_name . "%");
//$query_count = $wpdb->prepare($query_count, "%" . $prod_name . "%", "%" . $prod_name . "%");
}*/
$rows = $wpdb->get_results($query);
$prod_count = count($rows);
$query .= " order by " . $wpdb->prefix . "spidercatalog_products.ordering limit " . ($page_num - 1) * $prod_in_page . "," . $prod_in_page . " ";
$rows = $wpdb->get_results($query);
$cat_rows = $wpdb->get_results($cat_query);
$ratings = array();
$voted = array();
$categories = NULL;
if ($params7['show_prod'] == 1) {
foreach ($rows as $row) {
$id = $row->id;
$query = $wpdb->prepare("SELECT AVG(vote_value) as rating FROM " . $wpdb->prefix . "spidercatalog_product_votes WHERE product_id = %d ", $id);
$row1 = $wpdb->get_var($query);
$ratings[$id] = substr($row1, 0, 3);
$query = $wpdb->prepare("SELECT vote_value FROM " . $wpdb->prefix . "spidercatalog_product_votes WHERE product_id = %d and remote_ip='" . $_SERVER['REMOTE_ADDR'] . "' ", $id);
$num_rows = $wpdb->get_var($query);
$voted[$id] = $num_rows;
$query = "SELECT * FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE CONCAT(',', '" . $row->category_id . "') LIKE CONCAT('%,', id, ',%')";
$row2 = $wpdb->get_results($query);
if ($row2) {
foreach ($row2 as $rr) {
$categories[$rr->id] = $rr->name;
}
} else {
$categories[0] = '';
}
}
}
$par = 0;
$query = "SELECT * FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE parent=0 AND `published`=1 ORDER BY `ordering` ASC ";
$category_list = $wpdb->get_results($query);
$cat_query = "SELECT * FROM " . $wpdb->prefix . "spidercatalog_product_categories WHERE `published`=1 AND id=" . $subcat_id . "";
$categor = $wpdb->get_results($cat_query);
foreach ($categor as $chid) {
$par = $chid->parent;
}
if ($params7['show_sub'] == 1) {
$category_list = open_cat_in_tree($category_list);
}
$rows3 = array();
$count_of_cat = count($category_list);
$ii = 0;
for ($k = 0; $k < $count_of_cat; $k++) {
if ($category_list[$k]->published) {
$rows3[$ii] = $category_list[$k];
$ii++;
}
}
$category_list = $rows3;
switch ($cels_or_list) {
case 1:
return front_end_catalog_list($rows, $params, $page_num, $prod_count, $prod_in_page, $ratings, $voted, $categories, $category_list, $params1, $cat_rows, $cat_id, $child_ids, $params7, $categor, $par, $cels_or_list, $ident);
case 2:
return front_end_catalog_cells2($rows, $params, $page_num, $prod_count, $prod_in_page, $ratings, $voted, $categories, $category_list, $params1, $cat_rows, $cat_id, $child_ids, $params7, $categor, $par, $cels_or_list, $ident);
case 3:
return front_end_catalog_wcells($rows, $params, $page_num, $prod_count, $prod_in_page, $ratings, $voted, $categories, $category_list, $params1, $cat_rows, $cat_id, $child_ids, $params7, $categor, $par, $cels_or_list, $ident);
case 4:
return front_end_catalog_thumb($rows, $params, $page_num, $prod_count, $prod_in_page, $ratings, $voted, $categories, $category_list, $params1, $cat_rows, $cat_id, $child_ids, $params7, $categor, $par, $cels_or_list, $ident);
case 5:
return front_end_catalog_cells3($rows, $params, $page_num, $prod_count, $prod_in_page, $ratings, $voted, $categories, $category_list, $params1, $cat_rows, $cat_id, $child_ids, $params7, $categor, $par, $cels_or_list, $ident);
case 0:
return front_end_catalog_cells($rows, $params, $page_num, $prod_count, $prod_in_page, $ratings, $voted, $categories, $category_list, $params1, $cat_rows, $cat_id, $child_ids, $params7, $categor, $par, $cels_or_list, $ident);
}
}
function open_cat_in_tree($catt, $tree_problem = '', $hihiih = 1)
{
global $wpdb;
$search_tag = '';
static $trr_cat = array();
if ($hihiih) {
$trr_cat = array();
}
foreach ($catt as $local_cat) {
$local_cat->name = $tree_problem . $local_cat->name;
array_push($trr_cat, $local_cat);
$new_cat_query = "SELECT a.* , COUNT(b.id) AS count, g.par_name AS par_name FROM " . $wpdb->prefix . "spidercatalog_product_categories AS a LEFT JOIN " . $wpdb->prefix . "spidercatalog_product_categories AS b ON a.id = b.parent LEFT JOIN (SELECT " . $wpdb->prefix . "spidercatalog_product_categories.ordering as ordering," . $wpdb->prefix . "spidercatalog_product_categories.id AS id, COUNT( " . $wpdb->prefix . "spidercatalog_products.category_id ) AS prod_count\nFROM " . $wpdb->prefix . "spidercatalog_products, " . $wpdb->prefix . "spidercatalog_product_categories\nWHERE " . $wpdb->prefix . "spidercatalog_products.category_id = " . $wpdb->prefix . "spidercatalog_product_categories.id\nGROUP BY " . $wpdb->prefix . "spidercatalog_products.category_id) AS c ON c.id = a.id LEFT JOIN\n(SELECT " . $wpdb->prefix . "spidercatalog_product_categories.name AS par_name," . $wpdb->prefix . "spidercatalog_product_categories.id FROM " . $wpdb->prefix . "spidercatalog_product_categories) AS g\n ON a.parent=g.id WHERE a.name LIKE '%" . esc_html($search_tag) . "%' AND a.parent=" . $local_cat->id . " group by a.id";
$new_cat = $wpdb->get_results($new_cat_query);
open_cat_in_tree($new_cat, $tree_problem . "— ", 0);
}
return $trr_cat;
}
function add_video_player()
{
global $wpdb;
$query = "SELECT name,ordering FROM " . $wpdb->prefix . "huge_it_video_players ORDER BY `ordering`";
$ord_elem = $wpdb->get_results($query);
$cat_row = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "huge_it_video_players");
$cat_row = open_cat_in_tree($cat_row);
$table_name = $wpdb->prefix . "huge_it_video_players";
$sql_2 = "\nINSERT INTO \n\n`" . $table_name . "` ( `name`, `album_single`, `layout`, `width`, `ordering`, `align`, `margin_top`, `margin_bottom`, `autoplay`, `preload`, `published`, `ht_videos`) VALUES\n( 'New Video Album', 'single', 'right', '640', '1', 'left', '0', '0', '0', '0', '300', '1')";
$wpdb->query($sql_huge_it_video_players);
$wpdb->query($sql_2);
$query = "SELECT * FROM " . $wpdb->prefix . "huge_it_video_players order by id ASC";
$rowsldcc = $wpdb->get_results($query);
$last_key = key(array_slice($rowsldcc, -1, 1, TRUE));
foreach ($rowsldcc as $key => $rowsldccs) {
if ($last_key == $key) {
header('Location: admin.php?page=video_players_huge_it_video_player&id=' . $rowsldccs->id . '&task=apply');
}
}
html_add_video_player($ord_elem, $cat_row);
}
