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