prefix . "saludos"; $saludo= $wpdb->get_var("SELECT saludo FROM $table_name ORDER BY RAND() LIMIT 0, 1; " ); include('template/saludo.html'); }*/ function npl_instala(){ global $wpdb; $table_name= $wpdb->prefix . "previewNPL"; $sql = " CREATE TABLE $table_name( id mediumint( 9 ) NOT NULL , autoinit int NOT NULL , tipo_player varchar(50) NOT NULL, aspecto_player varchar(50) NOT NULL, nonblocking int NOT NULL , listItems int NOT NULL , no_anyadir int NOT NULL , intro_texto text NULL, fin_texto text NULL, style_mediana text NULL, help int NULL, autopreview int NULL , language varchar(50) NULL, PRIMARY KEY ( `id` ) ) ;"; $wpdb->query($sql); /*$sql = "INSERT INTO $table_name (saludo) VALUES ('Hola Mundo');"; $wpdb->query($sql);*/ } function npl_desinstala(){ global $wpdb; $table_name = $wpdb->prefix . "previewNPL"; $sql = "DROP TABLE $table_name"; $wpdb->query($sql); } function npl_panel(){ global $wpdb; $table_name = $wpdb->prefix . "previewNPL"; if(isset($_POST['envio'])){ if ($_POST['npl_autoiniciar']=='on') $_POST['npl_autoiniciar']=1; else $_POST['npl_autoiniciar']=0; if ($_POST['npl_help']=='on') $_POST['npl_help']=1; else $_POST['npl_help']=0; if ($_POST['npl_non_blocking']=='on') $_POST['npl_non_blocking']=1; else $_POST['npl_non_blocking']=0; if (!isset($_POST['npl_tipo_player'])) $_POST['npl_tipo_player']='mini'; if (!isset($_POST['npl_language'])) $_POST['npl_language']='en'; if (!isset($_POST['npl_aspecto_player'])) $_POST['npl_aspecto_player']='horizontal'; if ($_POST['npl_no_anyadir']=='on') $_POST['npl_no_anyadir']=1; else $_POST['npl_no_anyadir']=0; if ($_POST['npl_autopreview']=='on') $_POST['npl_autopreview']=1; else $_POST['npl_autopreview']=0; $sql = "DELETE FROM $table_name WHERE id=0"; $wpdb->query($sql); $npl_intro_texto=htmlentities(addslashes($_POST['npl_intro_texto'])); $npl_fin_texto=htmlentities(addslashes($_POST['npl_fin_texto'])); $npl_style_mediana=htmlentities(addslashes($_POST['npl_style_mediana'])); $sql = "INSERT INTO $table_name (id,autoinit,tipo_player,aspecto_player,nonblocking,listItems,no_anyadir,intro_texto,fin_texto,style_mediana,help,language,autopreview) VALUES (0,'{$_POST['npl_autoiniciar']}','{$_POST['npl_tipo_player']}','{$_POST['npl_aspecto_player']}','{$_POST['npl_blocking']}','{$_POST['npl_listItems']}','{$_POST['npl_no_anyadir']}','{$npl_intro_texto}','{$npl_fin_texto}','{$npl_style_mediana}','{$_POST['npl_help']}','{$_POST['npl_language']}','{$_POST['npl_autopreview']}');"; $wpdb->query($sql); } $npl_autoiniciar= $wpdb->get_var("SELECT autoinit FROM $table_name WHERE id=0" ); $npl_help= $wpdb->get_var("SELECT help FROM $table_name WHERE id=0" ); $npl_is_aspecto_player= $wpdb->get_var("SELECT aspecto_player FROM $table_name WHERE id=0" ); $npl_is_tipo_player= $wpdb->get_var("SELECT tipo_player FROM $table_name WHERE id=0" ); $npl_language= $wpdb->get_var("SELECT language FROM $table_name WHERE id=0" ); $npl_is_blocking= $wpdb->get_var("SELECT nonblocking FROM $table_name WHERE id=0" ); $npl_is_listItems= $wpdb->get_var("SELECT listItems FROM $table_name WHERE id=0" ); $npl_no_anyadir= $wpdb->get_var("SELECT no_anyadir FROM $table_name WHERE id=0" ); $npl_intro_texto= $wpdb->get_var("SELECT intro_texto FROM $table_name WHERE id=0" ); $npl_fin_texto= $wpdb->get_var("SELECT fin_texto FROM $table_name WHERE id=0" ); $npl_style_mediana= $wpdb->get_var("SELECT style_mediana FROM $table_name WHERE id=0" ); $npl_autopreview= $wpdb->get_var("SELECT autopreview FROM $table_name WHERE id=0" ); if (!isset($npl_autoiniciar)) $npl_autoiniciar=0; if (!isset($npl_autopreview)) $npl_autopreview=1; if (!isset($npl_help)) $npl_help=0; if (!isset($npl_is_aspecto_player)) $npl_is_aspecto_player='horizontal'; if (!isset($npl_is_tipo_player)) $npl_is_tipo_player='mini'; if (!isset($npl_language)) $npl_language='en'; if (!isset($npl_is_non_blocking)) $npl_is_non_blocking=0; if (!isset($npl_is_listItems)) $npl_is_listItems=10; if (!isset($npl_no_anyadir)) $npl_no_anyadir=0; if (!isset($npl_intro_texto)) $npl_intro_texto=htmlentities(addslashes('