function popup_video($id) { Html_popup_video(); }
function popup_video($id) { global $wpdb; if (isset($_POST["huge_it_add_video_input"])) { $youtubeviminsert = $_POST["huge_it_add_video_input"]; $youtubeinsert = explode("youtu", $youtubeviminsert); $vimeoinsert = explode("vimeo", $youtubeviminsert); } if (isset($_POST["huge_it_add_video_input"])) { if ($_POST["huge_it_add_video_input"] != '') { $table_name = $wpdb->prefix . "huge_itslider_images"; if (isset($youtubeinsert[1])) { $sql_video = $wpdb->query($wpdb->prepare("INSERT INTO `" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `ordering`, `published`, `published_in_sl_width` )" . "VALUES ( '%s', '%s', '%s', '%s', '%s', 'video', '%s', '0', '1', '1' )", $_POST["show_quality"], $id, $_POST["show_volume"], $_POST["huge_it_add_video_input"], $_POST["show_controls"], $_POST["show_info"])); // $sql_video = "INSERT INTO //`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `ordering`, `published`, `published_in_sl_width`) VALUES //( '".$_POST["show_quality"]."', '".$id."', '".$_POST["show_volume"]."', '".$_POST["huge_it_add_video_input"]."', '".$_POST["show_controls"]."', 'video', '".$_POST["show_info"]."', '0', '1', '1' )"; } if (isset($vimeoinsert[1])) { $sql_video = $wpdb->query($wpdb->prepare("INSERT INTO `" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `ordering`, `published`, `published_in_sl_width` )" . "VALUES ( '%s', '%s', '%s', '%s', '%s', 'video', '%s', '0', '1', '1' )", $_POST["show_quality"], $id, $_POST["show_volume"], $_POST["huge_it_add_video_input"], $_POST["show_controls"], $_POST["show_quality_vim"])); // $sql_video = "INSERT INTO //`" . $table_name . "` ( `name`, `slider_id`, `description`, `image_url`, `sl_url`, `sl_type`, `link_target`, `ordering`, `published`, `published_in_sl_width`) VALUES //( '".$_POST["show_quality"]."', '".$id."', '".$_POST["show_volume_v"]."', '".$_POST["huge_it_add_video_input"]."', '".$_POST["show_controls"]."', 'video', '".$_POST["show_quality_vim"]."', '0', '1', '1' )"; } $query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "huge_itslider_sliders WHERE id= %d", $id); $row = $wpdb->get_row($query); $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)); } $wpdb->query($sql_video); } } Html_popup_video(); }