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