__('', 'audio7-html5' ), 'data_saved' => __('Data Saved!', 'audio7-html5' ), 'empty_name' => __('Name - required', 'audio7-html5' ), 'empty_mp3' => __('MP3 - required', 'audio7-html5' ), 'empty_ogg' => __('OGG - required', 'audio7-html5' ), 'empty_categ' => __('Category - required', 'audio7-html5' ), 'invalid_request' => __('Invalid Request!', 'audio7-html5' ), 'generate_for_this_player' => __('You can start customizing this player.', 'audio7-html5' ), 'duplicate_complete' => __('Duplication process is complete!', 'audio7-html5' ), 'folder_read' => __('The playlist was generated! Go to "Manage Players" and check the "Playlist" for the selected player', 'audio7-html5' ), 'empty_folder' => __('Folder Path - required', 'audio7-html5' ), 'empty_player' => __('Select Player - required', 'audio7-html5' ), 'no_mp3' => __('No MP3 files in this folder!', 'audio7-html5' ) ); global $wp_version; if ( !version_compare($wp_version,"3.0",">=")) { wp_die (esc_html($lbg_audio7_html5_messages['version'], 'audio7-html5' )); } function lbg_audio7_html5_activate() { //db creation, create admin options etc. global $wpdb; $lbg_audio7_html5_collate = ' COLLATE utf8_general_ci'; $sql0 = "CREATE TABLE `" . $wpdb->prefix . "lbg_audio7_html5_players` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `name` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $sql1 = "CREATE TABLE `" . $wpdb->prefix . "lbg_audio7_html5_settings` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `responsive` varchar(8) NOT NULL DEFAULT 'false', `skin` varchar(255) NOT NULL DEFAULT 'whiteControllers', `sticky` varchar(8) NOT NULL DEFAULT 'true', `startMinified` varchar(8) NOT NULL DEFAULT 'false', `initialVolume` float unsigned NOT NULL DEFAULT '1', `autoPlay` varchar(8) NOT NULL DEFAULT 'true', `loop` varchar(8) NOT NULL DEFAULT 'true', `shuffle` varchar(8) NOT NULL DEFAULT 'false', `preload` varchar(10) NOT NULL DEFAULT 'metadata', `playerBgHexa` varchar(10) NOT NULL DEFAULT '000000', `playerBg` varchar(255) NOT NULL DEFAULT '', `bufferEmptyColor` varchar(10) NOT NULL DEFAULT '929292', `bufferFullColor` varchar(10) NOT NULL DEFAULT '454545', `seekbarColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `volumeOffColor` varchar(10) NOT NULL DEFAULT '454545', `volumeOnColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `timerColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `songTitleColor` varchar(10) NOT NULL DEFAULT 'a6a6a6', `songAuthorColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `googleTrakingOn` varchar(8) NOT NULL DEFAULT 'false', `googleTrakingCode` varchar(255) NOT NULL DEFAULT '', `showVinylRecord` varchar(8) NOT NULL DEFAULT 'true', `showRewindBut` varchar(8) NOT NULL DEFAULT 'true', `showNextPrevBut` varchar(8) NOT NULL DEFAULT 'true', `showShuffleBut` varchar(8) NOT NULL DEFAULT 'true', `showDownloadBut` varchar(8) NOT NULL DEFAULT 'true', `showBuyBut` varchar(8) NOT NULL DEFAULT 'true', `showLyricsBut` varchar(8) NOT NULL DEFAULT 'true', `buyButTitle` varchar(255) NOT NULL DEFAULT 'Buy Now', `lyricsButTitle` varchar(255) NOT NULL DEFAULT 'Lyrics', `buyButTarget` varchar(8) NOT NULL DEFAULT '_blank', `lyricsButTarget` varchar(8) NOT NULL DEFAULT '_blank', `showFacebookBut` varchar(8) NOT NULL DEFAULT 'true', `facebookAppID` varchar(255) NOT NULL DEFAULT '', `facebookShareTitle` varchar(255) NOT NULL DEFAULT 'Apollo - Sticky Full Width HTML5 Audio Player', `facebookShareDescription` varchar(255) NOT NULL DEFAULT 'A top-notch responsive HTML5 Audio Player compatible with all major browsers and mobile devices.', `showTwitterBut` varchar(8) NOT NULL DEFAULT 'true', `showPopupBut` varchar(8) NOT NULL DEFAULT 'true', `showAuthor` varchar(8) NOT NULL DEFAULT 'true', `showTitle` varchar(8) NOT NULL DEFAULT 'true', `showPlaylistBut` varchar(8) NOT NULL DEFAULT 'true', `showPlaylist` varchar(8) NOT NULL DEFAULT 'true', `showPlaylistOnInit` varchar(8) NOT NULL DEFAULT 'false', `playlistTopPos` smallint(5) unsigned NOT NULL DEFAULT '2', `playlistBgColor` varchar(10) NOT NULL DEFAULT '000000', `playlistRecordBgOffColor` varchar(10) NOT NULL DEFAULT '000000', `playlistRecordBgOnColor` varchar(10) NOT NULL DEFAULT '333333', `playlistRecordBottomBorderOffColor` varchar(10) NOT NULL DEFAULT '333333', `playlistRecordBottomBorderOnColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `playlistRecordTextOffColor` varchar(10) NOT NULL DEFAULT '777777', `playlistRecordTextOnColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `categoryRecordBgOffColor` varchar(10) NOT NULL DEFAULT '191919', `categoryRecordBgOnColor` varchar(10) NOT NULL DEFAULT '252525', `categoryRecordBottomBorderOffColor` varchar(10) NOT NULL DEFAULT '2f2f2f', `categoryRecordBottomBorderOnColor` varchar(10) NOT NULL DEFAULT '2f2f2f', `categoryRecordTextOffColor` varchar(10) NOT NULL DEFAULT '4c4c4c', `categoryRecordTextOnColor` varchar(10) NOT NULL DEFAULT '00b4f9', `numberOfThumbsPerScreen` smallint(5) unsigned NOT NULL DEFAULT '5', `playlistPadding` smallint(5) unsigned NOT NULL DEFAULT '18', `showCategories` varchar(8) NOT NULL DEFAULT 'true', `firstCateg` varchar(255) NOT NULL DEFAULT '', `selectedCategBg` varchar(10) NOT NULL DEFAULT '333333', `selectedCategOffColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `selectedCategOnColor` varchar(10) NOT NULL DEFAULT '00b4f9', `selectedCategMarginBottom` smallint(5) unsigned NOT NULL DEFAULT '12', `showSearchArea` varchar(8) NOT NULL DEFAULT 'true', `searchAreaBg` varchar(10) NOT NULL DEFAULT '333333', `searchInputText` varchar(255) NOT NULL DEFAULT 'search...', `searchInputBg` varchar(10) NOT NULL DEFAULT 'ffffff', `searchInputBorderColor` varchar(10) NOT NULL DEFAULT '333333', `searchInputTextColor` varchar(10) NOT NULL DEFAULT '333333', `searchAuthor` varchar(8) NOT NULL DEFAULT 'true', `continuouslyPlayOnAllPages` varchar(8) NOT NULL DEFAULT 'true', `showPlaylistNumber` varchar(8) NOT NULL DEFAULT 'true', `isSliderInitialized` varchar(8) NOT NULL DEFAULT 'false', `isProgressInitialized` varchar(8) NOT NULL DEFAULT 'false', `activateForFooter` varchar(8) NOT NULL DEFAULT 'false', `popupWidth` smallint(5) unsigned NOT NULL DEFAULT '1100', `popupHeight` smallint(5) unsigned NOT NULL DEFAULT '500', `barsColor` varchar(10) NOT NULL DEFAULT 'FFFFFF', `showClearFavoritesBut` varchar(8) NOT NULL DEFAULT 'false', `favoritesCookieExpirationDays` mediumint(7) unsigned NOT NULL DEFAULT '365', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $sql2 = "CREATE TABLE `". $wpdb->prefix . "lbg_audio7_html5_playlist` ( `id` int(10) unsigned NOT NULL auto_increment, `playerid` int(10) unsigned NOT NULL, `mp3` text NOT NULL, `ogg` text, `imgplaylist` text, `category` text NOT NULL, `title` text, `author` text, `authorlink` text, `authorlinktarget` varchar(8), `buylink` text, `lyricslink` text, `ord` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; $sql3 = "CREATE TABLE `". $wpdb->prefix . "lbg_audio7_html5_categories` ( `id` int(10) unsigned NOT NULL auto_increment, `categ` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `categ` ( `categ` ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql0.$lbg_audio7_html5_collate); dbDelta($sql1.$lbg_audio7_html5_collate); dbDelta($sql2.$lbg_audio7_html5_collate); dbDelta($sql3.$lbg_audio7_html5_collate); //initialize the players table with the first player type $rows_count = $wpdb->get_var( "SELECT COUNT(*) FROM ". $wpdb->prefix ."lbg_audio7_html5_players;" ); if (!$rows_count) { $wpdb->insert( $wpdb->prefix . "lbg_audio7_html5_players", array( 'name' => 'White Controllers' ), array( '%s' ) ); } // initialize the settings $rows_count = $wpdb->get_var( "SELECT COUNT(*) FROM ". $wpdb->prefix ."lbg_audio7_html5_settings;" ); if (!$rows_count) { lbg_audio7_html5_insert_settings_record(1); } //initialize categories $rows_count = $wpdb->get_var( "SELECT COUNT(*) FROM ". $wpdb->prefix ."lbg_audio7_html5_categories;" ); if (!$rows_count) { $wpdb->insert( $wpdb->prefix . "lbg_audio7_html5_categories", array( 'categ' => 'ALL CATEGORIES' ), array( '%s' ) ); } } function lbg_audio7_html5_insert_settings_record($player_id) { global $wpdb; $wpdb->insert( $wpdb->prefix . "lbg_audio7_html5_settings", array( 'skin' => 'whiteControllers' ), array( '%s' ) ); } function lbg_audio7_html5_init_sessions() { global $wpdb; if (is_admin()) { if (!session_id()) { session_start(); //initialize the session if (!isset($_SESSION['xid'])) { $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_players) LIMIT 0, 1"; $row = $wpdb->get_row($safe_sql,ARRAY_A); //$row=lbg_audio7_html5_unstrip_array($row); $_SESSION['xid'] = $row['id']; $_SESSION['xname'] = $row['name']; } } } } function lbg_audio7_html5_load_styles() { if(strpos($_SERVER['PHP_SELF'], 'wp-admin') !== false) { //loads css in admin $page = (isset($_GET['page'])) ? $_GET['page'] : ''; if(preg_match('/LBG_AUDIO7_HTML5/i', $page)) { //wp_enqueue_style('lbg-audio7-html5_jquery-custom_css', plugins_url('css/custom-theme/jquery-ui-1.8.10.custom.css', __FILE__)); //wp_enqueue_style('lbg-audio7-html5_jquery-custom_css', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/eggplant/jquery-ui.min.css'); //wp_enqueue_style('lbg-audio7-html5_jquery-custom_css', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/overcast/jquery-ui.min.css'); //wp_enqueue_style('lbg-audio7-html5_jquery-custom_css', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/ui-lightness/jquery-ui.min.css'); wp_enqueue_style('lbg-audio7-html5_jquery-custom_css', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/pepper-grinder/jquery-ui.min.css'); //wp_enqueue_style('lbg-audio7-html5_jquery-custom_css', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/excite-bike/jquery-ui.min.css'); wp_enqueue_style('lbg-audio7-html5_css', plugins_url('css/styles.css', __FILE__)); wp_enqueue_style('lbg-audio7-html5_colorpicker_css', plugins_url('css/colorpicker/colorpicker.css', __FILE__)); wp_enqueue_style('thickbox'); } } else if (!is_admin()) { //loads css in front-end wp_enqueue_style('audio7-html5_site_css', plugins_url('audio7_html5/audio7_html5.css', __FILE__)); } } function lbg_audio7_html5_load_scripts() { $page = (isset($_GET['page'])) ? $_GET['page'] : ''; if(preg_match('/LBG_AUDIO7_HTML5/i', $page)) { //loads scripts in admin //if (is_admin()) { /*wp_deregister_script('jquery-ui-core'); wp_deregister_script('jquery-ui-widget'); wp_deregister_script('jquery-ui-mouse'); wp_deregister_script('jquery-ui-accordion'); wp_deregister_script('jquery-ui-autocomplete'); wp_deregister_script('jquery-ui-slider'); wp_deregister_script('jquery-ui-tabs'); wp_deregister_script('jquery-ui-sortable'); wp_deregister_script('jquery-ui-draggable'); wp_deregister_script('jquery-ui-droppable'); wp_deregister_script('jquery-ui-selectable'); wp_deregister_script('jquery-ui-position'); wp_deregister_script('jquery-ui-datepicker'); wp_deregister_script('jquery-ui-resizable'); wp_deregister_script('jquery-ui-dialog'); wp_deregister_script('jquery-ui-button'); */ wp_enqueue_script('jquery'); /*wp_register_script('lbg-admin-jquery', plugins_url('js/jquery-1.5.1.js', __FILE__)); wp_enqueue_script('lbg-admin-jquery');*/ //wp_register_script('lbg-admin-jquery-ui-min', plugins_url('js/jquery-ui-1.8.10.custom.min.js', __FILE__)); //wp_register_script('lbg-admin-jquery-ui-min', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.23/jquery-ui.min.js'); /*wp_register_script('lbg-admin-jquery-ui-min', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/jquery-ui.min.js'); wp_enqueue_script('lbg-admin-jquery-ui-min');*/ wp_enqueue_script('jquery-ui-core'); wp_enqueue_script('jquery-ui-widget'); wp_enqueue_script('jquery-ui-mouse'); wp_enqueue_script('jquery-ui-accordion'); wp_enqueue_script('jquery-ui-autocomplete'); wp_enqueue_script('jquery-ui-slider'); wp_enqueue_script('jquery-ui-tabs'); wp_enqueue_script('jquery-ui-sortable'); wp_enqueue_script('jquery-ui-draggable'); wp_enqueue_script('jquery-ui-droppable'); wp_enqueue_script('jquery-ui-selectable'); wp_enqueue_script('jquery-ui-position'); wp_enqueue_script('jquery-ui-datepicker'); wp_enqueue_script('jquery-ui-resizable'); wp_enqueue_script('jquery-ui-dialog'); wp_enqueue_script('jquery-ui-button');/***************************/ /*wp_enqueue_script('jquery-form'); wp_enqueue_script('jquery-color'); wp_enqueue_script('jquery-masonry'); wp_enqueue_script('jquery-ui-progressbar'); wp_enqueue_script('jquery-ui-tooltip'); wp_enqueue_script('jquery-effects-core'); wp_enqueue_script('jquery-effects-blind'); wp_enqueue_script('jquery-effects-bounce'); wp_enqueue_script('jquery-effects-clip'); wp_enqueue_script('jquery-effects-drop'); wp_enqueue_script('jquery-effects-explode'); wp_enqueue_script('jquery-effects-fade'); wp_enqueue_script('jquery-effects-fold'); wp_enqueue_script('jquery-effects-highlight'); wp_enqueue_script('jquery-effects-pulsate'); wp_enqueue_script('jquery-effects-scale'); wp_enqueue_script('jquery-effects-shake'); wp_enqueue_script('jquery-effects-slide'); wp_enqueue_script('jquery-effects-transfer');*/ wp_register_script('lbg-admin-colorpicker', plugins_url('js/colorpicker/colorpicker.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-admin-colorpicker'); wp_register_script('lbg-admin-editinplace', plugins_url('js/jquery.editinplace.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-admin-editinplace'); wp_register_script('lbg-admin-toggle', plugins_url('js/myToggle.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-admin-toggle'); /*wp_enqueue_script('media-upload');*/ //old wp_enqueue_script('media-upload'); // before w.p 3.5 wp_enqueue_media();// from w.p 3.5 wp_enqueue_script('thickbox'); //} //wp_enqueue_script('jquery'); //wp_enqueue_script('jquery-ui-core'); //wp_enqueue_script('jquery-ui-sortable'); //wp_enqueue_script('thickbox'); //wp_enqueue_script('media-upload'); //wp_enqueue_script('farbtastic'); } else if (!is_admin()) { //loads scripts in front-end /*wp_deregister_script('jquery-ui-core'); wp_deregister_script('jquery-ui-widget'); wp_deregister_script('jquery-ui-mouse'); wp_deregister_script('jquery-ui-accordion'); wp_deregister_script('jquery-ui-autocomplete'); wp_deregister_script('jquery-ui-slider'); wp_deregister_script('jquery-ui-tabs'); wp_deregister_script('jquery-ui-sortable'); wp_deregister_script('jquery-ui-draggable'); wp_deregister_script('jquery-ui-droppable'); wp_deregister_script('jquery-ui-selectable'); wp_deregister_script('jquery-ui-position'); wp_deregister_script('jquery-ui-datepicker'); wp_deregister_script('jquery-ui-resizable'); wp_deregister_script('jquery-ui-dialog'); wp_deregister_script('jquery-ui-button');*/ wp_enqueue_script('jquery'); //wp_enqueue_script('jquery-ui-core'); //wp_register_script('lbg-jquery-ui-min', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.23/jquery-ui.min.js'); /*wp_register_script('lbg-jquery-ui-min', 'https://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/jquery-ui.min.js'); wp_enqueue_script('lbg-jquery-ui-min');*/ wp_enqueue_script('jquery-ui-core'); /*wp_enqueue_script('jquery-ui-widget'); wp_enqueue_script('jquery-ui-mouse'); wp_enqueue_script('jquery-ui-accordion'); wp_enqueue_script('jquery-ui-autocomplete');*/ wp_enqueue_script('jquery-ui-slider'); /*wp_enqueue_script('jquery-ui-tabs'); wp_enqueue_script('jquery-ui-sortable'); wp_enqueue_script('jquery-ui-draggable'); wp_enqueue_script('jquery-ui-droppable'); wp_enqueue_script('jquery-ui-selectable'); wp_enqueue_script('jquery-ui-position'); wp_enqueue_script('jquery-ui-datepicker'); wp_enqueue_script('jquery-ui-resizable'); wp_enqueue_script('jquery-ui-dialog'); wp_enqueue_script('jquery-ui-button'); wp_enqueue_script('jquery-form'); wp_enqueue_script('jquery-color'); wp_enqueue_script('jquery-masonry');*/ wp_enqueue_script('jquery-ui-progressbar'); /*wp_enqueue_script('jquery-ui-tooltip');*/ wp_enqueue_script('jquery-effects-core'); /*wp_enqueue_script('jquery-effects-blind'); wp_enqueue_script('jquery-effects-bounce'); wp_enqueue_script('jquery-effects-clip'); wp_enqueue_script('jquery-effects-drop'); wp_enqueue_script('jquery-effects-explode'); wp_enqueue_script('jquery-effects-fade'); wp_enqueue_script('jquery-effects-fold'); wp_enqueue_script('jquery-effects-highlight'); wp_enqueue_script('jquery-effects-pulsate'); wp_enqueue_script('jquery-effects-scale'); wp_enqueue_script('jquery-effects-shake'); wp_enqueue_script('jquery-effects-slide'); wp_enqueue_script('jquery-effects-transfer');*/ wp_register_script('lbg-mousewheel', plugins_url('audio7_html5/js/jquery.mousewheel.min.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-mousewheel'); wp_register_script('lbg-touchSwipe', plugins_url('audio7_html5/js/jquery.touchSwipe.min.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-touchSwipe'); wp_register_script('lbg-audio7_html5', plugins_url('audio7_html5/js/audio7_html5.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-audio7_html5'); wp_register_script('lbg-google_a', plugins_url('audio7_html5/js/google_a.js', __FILE__),array('jquery'),false,false); wp_enqueue_script('lbg-google_a'); } } // adds the menu pages function lbg_audio7_html5_plugin_menu() { add_menu_page('LBG AUDIO7 HTML5 Admin Interface', 'LBG AUDIO7 HTML5', 'edit_posts', 'LBG_AUDIO7_HTML5', 'lbg_audio7_html5_overview_page', plugins_url('images/lbg_audio7_icon.png', __FILE__)); add_submenu_page( 'LBG_AUDIO7_HTML5', 'LBG AUDIO7 HTML5 Overview', 'Overview', 'edit_posts', 'LBG_AUDIO7_HTML5', 'lbg_audio7_html5_overview_page'); add_submenu_page( 'LBG_AUDIO7_HTML5', 'LBG AUDIO7 HTML5 Manage Players', 'Manage Players', 'edit_posts', 'LBG_AUDIO7_HTML5_Manage_Players', 'lbg_audio7_html5_player_manage_players_page'); add_submenu_page( 'LBG_AUDIO7_HTML5', 'LBG AUDIO7 HTML5 Manage Players Add New', 'Add New', 'edit_posts', 'LBG_AUDIO7_HTML5_Add_New', 'lbg_audio7_html5_player_manage_players_add_new_page'); add_submenu_page( 'LBG_AUDIO7_HTML5', 'LBG AUDIO7 HTML5 Manage Categories', 'Manage Categories', 'edit_posts', 'LBG_AUDIO7_HTML5_Manage_Categories', 'lbg_audio7_html5_player_manage_categories_page'); add_submenu_page( 'LBG AUDIO7 HTML5 Manage Categories', 'LBG AUDIO7 HTML5 Manage Categories Add New', 'Add New', 'edit_posts', 'LBG_AUDIO7_HTML5_Add_New_Category', 'lbg_audio7_html5_player_manage_players_add_new_category_page'); add_submenu_page( 'LBG AUDIO7 HTML5 Manage Players', 'LBG AUDIO7 HTML5 Player Settings', 'Player Settings', 'edit_posts', 'LBG_AUDIO7_HTML5_Settings', 'lbg_audio7_html5_player_settings_page'); add_submenu_page( 'LBG AUDIO7 HTML5 Manage Players', 'LBG AUDIO7 HTML5 Player Playlist', 'Playlist', 'edit_posts', 'LBG_AUDIO7_HTML5_Playlist', 'lbg_audio7_html5_player_playlist_page'); add_submenu_page( 'LBG_AUDIO7_HTML5_Settings', 'LBG AUDIO7 HTML5 Player Settings', 'Duplicate Player', 'edit_posts', 'LBG_AUDIO7_HTML5_Duplicate_Player', 'lbg_audio7_html5_duplicate_player_page'); add_submenu_page( 'LBG_AUDIO7_HTML5', 'LBG AUDIO7 HTML5 Read Folder', 'Generate Playlist From Folder', 'edit_posts', 'LBG_AUDIO7_HTML5_Read_Folder', 'lbg_audio7_html5_player_read_folder_page'); add_submenu_page( 'LBG_AUDIO7_HTML5', 'LBG AUDIO7 HTML5 Help', 'Help', 'edit_posts', 'LBG_AUDIO7_HTML5_Help', 'lbg_audio7_html5_player_help_page'); } //HTML content for overview page function lbg_audio7_html5_overview_page() { global $lbg_audio7_html5_path; include_once($lbg_audio7_html5_path . 'tpl/overview.php'); } //HTML content for Manage Players function lbg_audio7_html5_player_manage_players_page() { global $wpdb; global $lbg_audio7_html5_messages; global $lbg_audio7_html5_path; //delete player if (isset($_GET['id'])) { //delete from wp_lbg_audio7_html5_players $wpdb->query($wpdb->prepare("DELETE FROM ".$wpdb->prefix."lbg_audio7_html5_players WHERE id = %d",$_GET['id'])); //delete from wp_lbg_audio7_html5_settings $wpdb->query($wpdb->prepare("DELETE FROM ".$wpdb->prefix."lbg_audio7_html5_settings WHERE id = %d",$_GET['id'])); //delete from wp_lbg_audio7_html5_playlist $wpdb->query($wpdb->prepare("DELETE FROM ".$wpdb->prefix."lbg_audio7_html5_playlist WHERE playerid = %d",$_GET['id'])); //initialize the session $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_players) ORDER BY id"; $row = $wpdb->get_row($safe_sql,ARRAY_A); $row=lbg_audio7_html5_unstrip_array($row); if ($row['id']) { $_SESSION['xid']=$row['id']; $_SESSION['xname']=$row['name']; } } $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_players) ORDER BY id"; $result = $wpdb->get_results($safe_sql,ARRAY_A); //echo $wpdb->last_query; include_once($lbg_audio7_html5_path . 'tpl/players.php'); } //HTML content for Manage Categories function lbg_audio7_html5_player_manage_categories_page() { global $wpdb; global $lbg_audio7_html5_messages; global $lbg_audio7_html5_path; //delete player if (isset($_GET['id'])) { //delete from wp_lbg_audio7_html5_categories $wpdb->query($wpdb->prepare("DELETE FROM ".$wpdb->prefix."lbg_audio7_html5_categories WHERE id = %d",$_GET['id'])); } if (isset($_GET['categID']) && isset($_GET['origCategName'])) { $wpdb->update( $wpdb->prefix .'lbg_audio7_html5_categories', array( 'categ' => $_POST['update_value'] ), array( 'id' => $_GET['categID'] ) ); } $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_categories) ORDER BY id"; $result = $wpdb->get_results($safe_sql,ARRAY_A); //echo $wpdb->last_query; include_once($lbg_audio7_html5_path . 'tpl/categories.php'); } //HTML content for Manage Players - Add New function lbg_audio7_html5_player_manage_players_add_new_page() { global $wpdb; global $lbg_audio7_html5_messages; global $lbg_audio7_html5_path; //if($_POST['Submit'] == 'Add New') { if(array_key_exists('Submit', $_POST) && $_POST['Submit'] == 'Add New') { $errors_arr=array(); if (empty($_POST['name'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_name']; if (count($errors_arr)) { include_once($lbg_audio7_html5_path . 'tpl/add_player.php'); ?> insert( $wpdb->prefix . "lbg_audio7_html5_players", array( 'name' => $_POST['name'] ), array( '%s' ) ); //insert default player settings for this new player lbg_audio7_html5_insert_settings_record($wpdb->insert_id); ?> insert( $wpdb->prefix . "lbg_audio7_html5_categories", array( 'categ' => $_POST['categ'] ), array( '%s' ) ); ?> show_errors(); /*if (check_admin_referer('lbg_audio7_html5_settings_update')) { echo "update"; }*/ //if($_POST['Submit'] == 'Update Player Settings') { if(array_key_exists('Submit', $_POST) && $_POST['Submit'] == 'Update Player Settings') { $_GET['xmlf']=''; $except_arr=array('Submit','name','pll_ajax_backend','page_scroll_to_id_instances','_wp_http_referer','set_key_auth','_wpnonce'); $wpdb->update( $wpdb->prefix .'lbg_audio7_html5_players', array( 'name' => $_POST['name'] ), array( 'id' => $_SESSION['xid'] ) ); $_SESSION['xname']=stripslashes($_POST['name']); foreach ($_POST as $key=>$val){ if (in_array($key,$except_arr)) { unset($_POST[$key]); } } //deactivate previous players activated for footer if ($_POST['activateForFooter']=='true') { $wpdb->query("UPDATE ".$wpdb->prefix ."lbg_audio7_html5_settings SET `activateForFooter` = 'false'"); //echo $wpdb->last_query; } $wpdb->update( $wpdb->prefix .'lbg_audio7_html5_settings', $_POST, array( 'id' => $_SESSION['xid'] ) ); ?> prepare( "SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_settings) WHERE id = %d",$_SESSION['xid'] ); $row = $wpdb->get_row($safe_sql,ARRAY_A); $row=lbg_audio7_html5_unstrip_array($row); $_POST = $row; $_POST=lbg_audio7_html5_unstrip_array($_POST); //categories $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_categories) ORDER BY categ"; $result = $wpdb->get_results($safe_sql,ARRAY_A); include_once($lbg_audio7_html5_path . 'tpl/settings_form.php'); } function lbg_audio7_html5_player_playlist_page() { global $wpdb; global $lbg_audio7_html5_messages; global $lbg_audio7_html5_path; if (isset($_GET['id']) && isset($_GET['name'])) { $_SESSION['xid']=$_GET['id']; $_SESSION['xname']=$_GET['name']; } $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_categories) ORDER BY categ"; $result = $wpdb->get_results($safe_sql,ARRAY_A); //if ($_GET['xmlf']=='add_playlist_record') { if (array_key_exists('xmlf', $_GET) && $_GET['xmlf']=='add_playlist_record') { //if($_POST['Submit'] == 'Add Record') { if(array_key_exists('Submit', $_POST) && $_POST['Submit'] == 'Add Record') { $errors_arr=array(); if (empty($_POST['mp3'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_mp3']; /*if (empty($_POST['ogg'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_ogg'];*/ if (empty($_POST['category'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_categ']; if (count($errors_arr)) { include_once($lbg_audio7_html5_path . 'tpl/add_playlist_record.php'); ?> get_var( $wpdb->prepare( "SELECT max(ord) FROM ". $wpdb->prefix ."lbg_audio7_html5_playlist WHERE playerid = %d",$_SESSION['xid'] ) ); $wpdb->insert( $wpdb->prefix . "lbg_audio7_html5_playlist", array( 'playerid' => $_POST['playerid'], 'mp3' => $_POST['mp3'], 'ogg' => $_POST['ogg'], 'category' => $all_categs, 'imgplaylist' => $_POST['imgplaylist'], 'title' => $_POST['title'], 'author' => $_POST['author'], 'authorlink' => $_POST['authorlink'], 'authorlinktarget' => $_POST['authorlinktarget'], 'buylink' => $_POST['buylink'], 'lyricslink' => $_POST['lyricslink'], 'ord' => $max_ord ), array( '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d' ) ); if (isset($_POST['setitfirst'])) { $sql_arr=array(); $ord_start=$max_ord; $ord_stop=1; $elem_id=$wpdb->insert_id; $ord_direction='+1'; $sql_arr[]=$wpdb->prepare( "UPDATE ".$wpdb->prefix."lbg_audio7_html5_playlist SET ord=ord+1 WHERE playerid = %d and ord >= %d and ord < %d", $_SESSION['xid'], $ord_stop, $ord_start); $sql_arr[]=$wpdb->prepare( "UPDATE ".$wpdb->prefix."lbg_audio7_html5_playlist SET ord=%d WHERE id=%d", $ord_stop,$elem_id); //echo "elem_id: ".$elem_id."----ord_start: ".$ord_start."----ord_stop: ".$ord_stop; foreach ($sql_arr as $sql) $wpdb->query($sql); } ?> get_var( $wpdb->prepare( "SELECT max(ord) FROM ". $wpdb->prefix ."lbg_audio7_html5_playlist WHERE playerid = %d",$_SESSION['xid'] ) ); $safe_sql=$wpdb->prepare( "INSERT INTO ".$wpdb->prefix ."lbg_audio7_html5_playlist ( `playerid`, `mp3`, `ogg`, `imgplaylist`, `category`, `title`, `author`, `authorlink`, `authorlinktarget`, `buylink`, `lyricslink`, `ord` ) SELECT `playerid`, `mp3`, `ogg`, `imgplaylist`, `category`, `title`, `author`, `authorlink`, `authorlinktarget`, `buylink`, `lyricslink`, ".$max_ord." FROM (".$wpdb->prefix ."lbg_audio7_html5_playlist) WHERE id = %d",$_GET['duplicate_id'] ); $wpdb->query($safe_sql); //$lastID=$wpdb->insert_id; //echo $wpdb->last_query; echo ""; } $safe_sql=$wpdb->prepare( "SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_playlist) WHERE playerid = %d ORDER BY ord",$_SESSION['xid'] ); $result = $wpdb->get_results($safe_sql,ARRAY_A); $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_categories) ORDER BY categ"; $result_categ = $wpdb->get_results($safe_sql,ARRAY_A); //$_POST=lbg_audio7_html5_unstrip_array($_POST); include_once($lbg_audio7_html5_path . 'tpl/playlist.php'); } } //HTML duplicate player function lbg_audio7_html5_duplicate_player_page() { global $wpdb; global $lbg_audio7_html5_messages; global $lbg_audio7_html5_path; if (isset($_GET['id']) && isset($_GET['name'])) { $_SESSION['xid']=$_GET['id']; $_SESSION['xname']=$_GET['name']; //$wpdb->show_errors(); //echo "WP_PLUGIN_URL: ".WP_PLUGIN_URL; //$safe_sql=$wpdb->prepare( "INSERT INTO ".$wpdb->prefix ."lbg_audio7_html5_settings SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_settings) WHERE id = %d",$_SESSION['xid'] ); //insert player $wpdb->insert( $wpdb->prefix . "lbg_audio7_html5_players", array( 'name' => 'Duplicate of Audio Player '.$_SESSION['xid'] ), array( '%s' ) ); $playerid=$wpdb->insert_id; //duplicate settings $safe_sql=$wpdb->prepare( "INSERT INTO ".$wpdb->prefix ."lbg_audio7_html5_settings (`responsive`, `skin`, `sticky`, `startMinified`, `initialVolume`, `autoPlay`, `loop`, `shuffle`, `preload`, `playerBg`, `bufferEmptyColor`, `bufferFullColor`, `seekbarColor`, `volumeOffColor`, `volumeOnColor`, `timerColor`, `songTitleColor`, `songAuthorColor`, `googleTrakingOn`, `googleTrakingCode`, `showVinylRecord`, `showRewindBut`, `showNextPrevBut`, `showShuffleBut`, `showDownloadBut`, `showBuyBut`, `showLyricsBut`, `buyButTitle`, `lyricsButTitle`, `buyButTarget`, `lyricsButTarget`, `showFacebookBut`, `facebookAppID`, `facebookShareTitle`, `facebookShareDescription`, `showTwitterBut`, `showPopupBut`, `showAuthor`, `showTitle`, `showPlaylistBut`, `showPlaylist`, `showPlaylistOnInit`, `playlistTopPos`, `playlistBgColor`, `playlistRecordBgOffColor`, `playlistRecordBgOnColor`, `playlistRecordBottomBorderOffColor`, `playlistRecordBottomBorderOnColor`, `playlistRecordTextOffColor`, `playlistRecordTextOnColor`, `categoryRecordBgOffColor`, `categoryRecordBgOnColor`, `categoryRecordBottomBorderOffColor`, `categoryRecordBottomBorderOnColor`, `categoryRecordTextOffColor`, `categoryRecordTextOnColor`, `numberOfThumbsPerScreen`, `playlistPadding`, `showCategories`, `firstCateg`, `selectedCategBg`, `selectedCategOffColor`, `selectedCategOnColor`, `selectedCategMarginBottom`, `showSearchArea`, `searchAreaBg`, `searchInputText`, `searchInputBg`, `searchInputBorderColor`, `searchInputTextColor`, `searchAuthor`, `continuouslyPlayOnAllPages`, `showPlaylistNumber`, `isSliderInitialized`, `isProgressInitialized`, `activateForFooter`, `popupWidth`, `popupHeight`, `barsColor`, `playerBgHexa`, `showClearFavoritesBut`, `favoritesCookieExpirationDays` ) SELECT `responsive`, `skin`, `sticky`, `startMinified`, `initialVolume`, `autoPlay`, `loop`, `shuffle`, `preload`, `playerBg`, `bufferEmptyColor`, `bufferFullColor`, `seekbarColor`, `volumeOffColor`, `volumeOnColor`, `timerColor`, `songTitleColor`, `songAuthorColor`, `googleTrakingOn`, `googleTrakingCode`, `showVinylRecord`, `showRewindBut`, `showNextPrevBut`, `showShuffleBut`, `showDownloadBut`, `showBuyBut`, `showLyricsBut`, `buyButTitle`, `lyricsButTitle`, `buyButTarget`, `lyricsButTarget`, `showFacebookBut`, `facebookAppID`, `facebookShareTitle`, `facebookShareDescription`, `showTwitterBut`, `showPopupBut`, `showAuthor`, `showTitle`, `showPlaylistBut`, `showPlaylist`, `showPlaylistOnInit`, `playlistTopPos`, `playlistBgColor`, `playlistRecordBgOffColor`, `playlistRecordBgOnColor`, `playlistRecordBottomBorderOffColor`, `playlistRecordBottomBorderOnColor`, `playlistRecordTextOffColor`, `playlistRecordTextOnColor`, `categoryRecordBgOffColor`, `categoryRecordBgOnColor`, `categoryRecordBottomBorderOffColor`, `categoryRecordBottomBorderOnColor`, `categoryRecordTextOffColor`, `categoryRecordTextOnColor`, `numberOfThumbsPerScreen`, `playlistPadding`, `showCategories`, `firstCateg`, `selectedCategBg`, `selectedCategOffColor`, `selectedCategOnColor`, `selectedCategMarginBottom`, `showSearchArea`, `searchAreaBg`, `searchInputText`, `searchInputBg`, `searchInputBorderColor`, `searchInputTextColor`, `searchAuthor`, `continuouslyPlayOnAllPages`, `showPlaylistNumber`, `isSliderInitialized`, `isProgressInitialized`, `activateForFooter`, `popupWidth`, `popupHeight`, `barsColor`, `playerBgHexa`, `showClearFavoritesBut`, `favoritesCookieExpirationDays` FROM (".$wpdb->prefix ."lbg_audio7_html5_settings) WHERE id = %d",$_SESSION['xid'] ); $wpdb->query($safe_sql); ?> prepare( "SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_playlist) WHERE playerid = %d",$_SESSION['xid'] ); $result = $wpdb->get_results($safe_sql,ARRAY_A); foreach ( $result as $row_playlist ) { $row_playlist=lbg_audio7_html5_unstrip_array($row_playlist); $safe_sql=$wpdb->prepare( "INSERT INTO ".$wpdb->prefix ."lbg_audio7_html5_playlist ( `playerid`, `mp3`, `ogg`, `imgplaylist`, `category`, `title`, `author`, `buylink`, `lyricslink`, `ord` ) SELECT ".$playerid.", `mp3`, `ogg`, `imgplaylist`, `category`, `title`, `author`, `buylink`, `lyricslink`, `ord` FROM (".$wpdb->prefix ."lbg_audio7_html5_playlist) WHERE id = %d",$row_playlist['id'] ); $wpdb->query($safe_sql); //echo $wpdb->last_query; } */ } //echo $wpdb->last_query; $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_players) ORDER BY id"; $result = $wpdb->get_results($safe_sql,ARRAY_A); include_once($lbg_audio7_html5_path . 'tpl/players.php'); } function lbg_audio7_read_mp3_meta($mp3) { $getID3 = new getID3; $fileinformation = $getID3->analyze($mp3); /*if (isset($fileinformation['id3v1'])) { echo 'id3v1:'; print_r ($fileinformation['id3v1']['comments']); } if (isset($fileinformation['id3v2'])) { echo 'id3v2:'; print_r ($fileinformation['id3v2']['comments']); }*/ //echo "-----------------------------------------------------"; //print_r ($fileinformation); $data["song"]=''; $data["artist"]=''; if (isset($fileinformation['id3v2'])) { if (array_key_exists("title",$fileinformation['id3v2']['comments'])) { $data["song"] = trim($fileinformation['id3v2']['comments']['title'][0]); } if (array_key_exists("artist",$fileinformation['id3v2']['comments'])) { $data["artist"]=trim($fileinformation['id3v2']['comments']['artist'][0]); } if ($data["artist"]=='' && array_key_exists("band",$fileinformation['id3v2']['comments'])) { $data["artist"]=trim($fileinformation['id3v2']['comments']['band'][0]); } } if ($data["song"]==='') { if (isset($fileinformation['id3v1'])) { if (array_key_exists("title",$fileinformation['id3v1']['comments'])) { $data["song"] = trim($fileinformation['id3v1']['comments']['title'][0]); } if (array_key_exists("artist",$fileinformation['id3v1']['comments'])) { $data["artist"]=trim($fileinformation['id3v1']['comments']['artist'][0]); } if ($data["artist"]=='' && array_key_exists("band",$fileinformation['id3v1']['comments'])) { $data["artist"]=trim($fileinformation['id3v1']['comments']['band'][0]); } } } return $data; } function lbg_audio7_html5_player_read_folder_page() { global $wpdb; global $lbg_audio7_html5_messages; global $lbg_audio7_html5_path; include_once($lbg_audio7_html5_path . 'getid3/getid3.php'); if (isset($_GET['id']) && isset($_GET['name'])) { $_SESSION['xid']=$_GET['id']; $_SESSION['xname']=$_GET['name']; } $wpdb->show_errors(); $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_players) ORDER BY id"; $result_player = $wpdb->get_results($safe_sql,ARRAY_A); $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_categories) ORDER BY categ"; $result_categ = $wpdb->get_results($safe_sql,ARRAY_A); $errors_arr=array(); //if($_POST['Submit'] == 'Generate Playlist') { if(array_key_exists('Submit', $_POST) && $_POST['Submit'] == 'Generate Playlist') { if (empty($_POST['playerid'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_player']; if (empty($_POST['folder_path'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_folder']; if (count($errors_arr)) { ?> get_var( $wpdb->prepare( "SELECT max(ord) FROM ". $wpdb->prefix ."lbg_audio7_html5_playlist WHERE playerid = %d",$_POST['playerid'] ) ); $no_of_mp3=0; foreach (glob($sPath) AS $mp3) { $no_of_mp3++; $meta_arr=lbg_audio7_read_mp3_meta($mp3); $mp3=substr ( $mp3 , (strlen(get_home_path())) ); $mp3=get_site_url().'/'.$mp3; //check uniqueness $wpdb->query( $wpdb->prepare("SELECT * FROM ".$wpdb->prefix."lbg_audio7_html5_playlist WHERE playerid = %d AND mp3 = %s",$_POST['playerid'],$mp3) ); //echo "NUMBER OF ROWS:".$wpdb->num_rows; if ($wpdb->num_rows==0) { $max_ord++; $wpdb->insert( $wpdb->prefix . "lbg_audio7_html5_playlist", array( 'playerid' => $_POST['playerid'], 'mp3' => $mp3, 'ogg' => $mp3, 'title' => preg_replace("/[^a-zA-Z0-9\s\p{P}]/", "", $meta_arr["song"]), 'author' => preg_replace("/[^a-zA-Z0-9\s\p{P}]/", "", $meta_arr["artist"]), 'authorlinktarget' => '_blank', 'category' => $_POST['category'], 'imgplaylist' => $_POST['imgplaylist'], 'ord' => $max_ord ), array( '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d' ) ); } //get_site_url(); //$the_playlist_code.=$mp3.' ------- '.$meta_arr["song"].' ------- '.$meta_arr["artist"].' ------- || ------- '; /*$the_playlist_code.='

• '.$meta_arr["song"].'
• '.$meta_arr["artist"].'
• '.$mp3.'
• '.$mp3.'

';*/ } //echo $the_playlist_code; if ($no_of_mp3>0) { ?> prepare( "SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_settings) WHERE id = %d",$sliderID ); $row = $wpdb->get_row($safe_sql,ARRAY_A); $row=lbg_audio7_html5_unstrip_array($row); $safe_sql="SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_categories) ORDER BY categ"; $result_categ = $wpdb->get_results($safe_sql,ARRAY_A); //$path_to_plugin = plugin_dir_url().str_replace(basename( __FILE__),"",plugin_basename(__FILE__)); $path_to_plugin = plugin_dir_url(__FILE__); $preload_aux='metadata'; if ($row["preload"]) $preload_aux=$row["preload"]; //first categ $first_categ=''; foreach ( $result_categ as $row_categ ) { if ( $row['firstCateg']==$row_categ['id']) { $first_categ=stripslashes($row_categ['categ']); } } //download $pathToDownloadFile_aux=$path_to_plugin.'audio7_html5/'; $safe_sql=$wpdb->prepare( "SELECT * FROM (".$wpdb->prefix ."lbg_audio7_html5_playlist) WHERE playerid = %d ORDER BY ord",$sliderID ); $result = $wpdb->get_results($safe_sql,ARRAY_A); $playlist_str=''; foreach ( $result as $row_playlist ) { $row_playlist=lbg_audio7_html5_unstrip_array($row_playlist); $mp3_path=$row_playlist["mp3"]; $ogg_path=$row_playlist["ogg"]; $categ_arr=array(); foreach ( $result_categ as $row_categ ) { if (preg_match_all('/\b'.$row_categ["id"].'\b/', $row_playlist['category'], $matches)) { //if ( strpos($row_playlist['category'], $row_categ['id']) === false ) { // nothing //} else { $categ_arr[]=stripslashes($row_categ['categ']); } } $playlist_str.='

• '.$row_playlist["title"].'
• '.$row_playlist["author"].'
• '.$row_playlist["authorlink"].'
• '.$row_playlist["authorlinktarget"].'
• '.$row_playlist["imgplaylist"].'
• '.$row_playlist["buylink"].'
• '.$row_playlist["lyricslink"].'
• '.implode(";",$categ_arr).'
• '.$mp3_path.'
• '.$ogg_path.'

'; } $new_div_start=''; $new_div_end=''; $playerBgColor=''; if ($row['playerBgHexa']) $playerBgColor.='#'.$row['playerBgHexa']; if ($row['playerBg']) $playerBgColor.=' url('.$row['playerBg'].')'; $content='

'.$new_div_start.'

'.$new_div_end.'

'; return str_replace("\r\n", '', $content); } function lbg_audio7_html5_shortcode($atts, $content=null) { global $wpdb; shortcode_atts( array('settings_id'=>''), $atts); if ($atts['settings_id']=='') $atts['settings_id']=1; return lbg_audio7_html5_generate_preview_code($atts['settings_id']); } register_activation_hook(__FILE__,"lbg_audio7_html5_activate"); //activate plugin and create the database add_action('init', 'lbg_audio7_html5_init_sessions'); // initialize sessions add_action('init', 'lbg_audio7_html5_load_styles'); // loads required styles add_action('init', 'lbg_audio7_html5_load_scripts'); // loads required scripts add_action('admin_menu', 'lbg_audio7_html5_plugin_menu'); // create menus add_shortcode('lbg_audio7_html5', 'lbg_audio7_html5_shortcode'); // LBG AUDIO7 HTML5 shortcode /** OTHER FUNCTIONS **/ //stripslashes for an entire array function lbg_audio7_html5_unstrip_array($array){ if (is_array($array)) { foreach($array as &$val){ if(is_array($val)){ $val = unstrip_array($val); } else { $val = stripslashes($val); } } } return $array; } function lbg_audio7_html5_footer_function() { global $wpdb; $safe_sql=$wpdb->prepare( "SELECT `id`,`activateForFooter` FROM (".$wpdb->prefix ."lbg_audio7_html5_settings)",1); $result = $wpdb->get_results($safe_sql,ARRAY_A); $shortcode_id=0; foreach ( $result as $row ) { $row=lbg_audio7_html5_unstrip_array($row); if ($row['activateForFooter']==='true') { $shortcode_id=$row['id']; } } if ($shortcode_id>0) echo do_shortcode("[lbg_audio7_html5 settings_id='".$shortcode_id."']");; } add_action( 'wp_footer', 'lbg_audio7_html5_footer_function', 100 ); /* ajax update playlist record */ add_action('admin_head', 'lbg_audio7_html5_update_playlist_record_javascript'); function lbg_audio7_html5_update_playlist_record_javascript() { global $wpdb; //Set Your Nonce $lbg_audio7_html5_update_playlist_record_ajax_nonce = wp_create_nonce("lbg_audio7_html5_update_playlist_record-special-string"); $lbg_audio7_html5_update_category_record_ajax_nonce = wp_create_nonce("lbg_audio7_html5_update_category_record-special-string"); $lbg_audio7_html5_preview_record_ajax_nonce = wp_create_nonce("lbg_audio7_html5_preview_record-special-string"); if(strpos($_SERVER['PHP_SELF'], 'wp-admin') !== false) { $page = (isset($_GET['page'])) ? $_GET['page'] : ''; if(preg_match('/LBG_AUDIO7_HTML5/i', $page)) { ?> show_errors(); //delete entire record //if ($_POST['updateType']=='lbg_audio7_html5_delete_entire_record') { if (array_key_exists('updateType', $_POST) && $_POST['updateType']=='lbg_audio7_html5_delete_entire_record') { $delete_id=$_POST['delete_id']; $safe_sql=$wpdb->prepare("SELECT * FROM ".$wpdb->prefix."lbg_audio7_html5_playlist WHERE id = %d",$delete_id); $row = $wpdb->get_row($safe_sql, ARRAY_A); $row=lbg_audio7_html5_unstrip_array($row); //delete the entire record $wpdb->query($wpdb->prepare("DELETE FROM ".$wpdb->prefix."lbg_audio7_html5_playlist WHERE id = %d",$delete_id)); //update the oreder for the rest ord=ord-1 for > ord $wpdb->query($wpdb->prepare("UPDATE ".$wpdb->prefix."lbg_audio7_html5_playlist SET ord=ord-1 WHERE playerid = %d and ord>".$row['ord'],$_SESSION['xid'])); } //update elements order //if ($_POST['updateType']=='change_ord') { if (array_key_exists('updateType', $_POST) && $_POST['updateType']=='change_ord') { $sql_arr=array(); $ord_start=$_POST['ord_start']; $ord_stop=$_POST['ord_stop']; $elem_id=(int)$_POST['elem_id']; $ord_direction='+1'; if ($ord_start<$ord_stop) $sql_arr[]=$wpdb->prepare( "UPDATE ".$wpdb->prefix."lbg_audio7_html5_playlist SET ord=ord-1 WHERE playerid = %d and ord > %d and ord <= %d", $_SESSION['xid'], $ord_start, $ord_stop); else $sql_arr[]=$wpdb->prepare( "UPDATE ".$wpdb->prefix."lbg_audio7_html5_playlist SET ord=ord+1 WHERE playerid = %d and ord >= %d and ord < %d", $_SESSION['xid'], $ord_stop, $ord_start); $sql_arr[]=$wpdb->prepare( "UPDATE ".$wpdb->prefix."lbg_audio7_html5_playlist SET ord=%d WHERE id=%d", $ord_stop,$elem_id); //echo "elem_id: ".$elem_id."----ord_start: ".$ord_start."----ord_stop: ".$ord_stop; foreach ($sql_arr as $sql) $wpdb->query($sql); } //submit update if (!isset($_POST['updateType'])) { if (empty($_POST['mp3'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_mp3']; /*if (empty($_POST['ogg'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_ogg'];*/ if (empty($_POST['category'])) $errors_arr[]=$lbg_audio7_html5_messages['empty_categ']; } $theid=isset($_POST['id'])?$_POST['id']:0; if($theid>0 && !count($errors_arr)) { $except_arr=array('Submit'.$theid,'id','ord','action','security','updateType','pll_ajax_backend','page_scroll_to_id_instances','_wp_http_referer','set_key_auth','_wpnonce'); $_POST['category']=implode(";", $_POST['category']); foreach ($_POST as $key=>$val){ if (in_array($key,$except_arr)) { unset($_POST[$key]); } } $wpdb->update( $wpdb->prefix .'lbg_audio7_html5_playlist', $_POST, array( 'id' => $theid ) ); ?> show_errors(); if ($_POST['theCategory']!='') { $wpdb->update( $wpdb->prefix .'lbg_audio7_html5_categories', array( 'categ' => strip_tags($_POST['theCategory']) ), array( 'id' => $_POST['theCategoryID'] ) ); } wp_die(); // this is required to return a proper result } add_action('wp_ajax_lbg_audio7_html5_preview_record', 'lbg_audio7_html5_preview_record_callback'); function lbg_audio7_html5_preview_record_callback() { check_ajax_referer( 'lbg_audio7_html5_preview_record-special-string', 'security' ); //echo lbg_audio7_html5_generate_preview_code($_POST['theSliderID']); $aux_val=' '; $aux_val.=lbg_audio7_html5_generate_preview_code($_POST['theSliderID']); $aux_val.=" "; $filename=plugin_dir_path(__FILE__) . 'tpl/preview.html'; $fp = fopen($filename, 'w+'); $fwrite = fwrite($fp, $aux_val); echo $fwrite; wp_die(); // this is required to return a proper result } ?>