query("DROP TABLE `".$wpdb->prefix."twp_vid`"); $wpdb->query("DROP TABLE `".$wpdb->prefix."twp_vid_cat`"); } function atwp_youtube_shortcode( $atts ) { global $wpdb; wp_enqueue_script('shortcode_sctipt',plugins_url().'/appsaur-twp-youtube/script/shortcode.js'); wp_enqueue_style('shortcode_style',plugins_url().'/appsaur-twp-youtube/style/shortcode.css'); if($atts['cat']!=''){ $sql=$wpdb->get_results("SELECT * FROM `".$wpdb->prefix."twp_vid_cat` WHERE `id`='".$atts['cat']."' LIMIT 1"); if($sql){ $sql=$wpdb->get_results("SELECT * FROM `".$wpdb->prefix."twp_vid` WHERE `cat`='".$sql[0]->id."' ORDER BY `id` ASC"); if($sql){ foreach($sql as $row){ $shrt.='

'; } } } } if($atts['cat']=='no-category'){ $sql=$wpdb->get_results("SELECT * FROM `".$wpdb->prefix."twp_vid` WHERE `cat`='0' ORDER BY `id` ASC"); if($sql){ foreach($sql as $row){ $shrt.='

'; } } } if($atts['cat']=='all'){ $sql=$wpdb->get_results("SELECT * FROM `".$wpdb->prefix."twp_vid` ORDER BY `id` ASC"); if($sql){ foreach($sql as $row){ $shrt.='

'; } } } elseif($atts['id']!=''){ $sql=$wpdb->get_results("SELECT * FROM `".$wpdb->prefix."twp_vid` WHERE `vid`='".$atts['id']."' LIMIT 1"); if($sql){ foreach($sql as $row){ $shrt.='

'; } } } return $shrt; }