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); }