blogid;
// Get all blog ids
$blogids = $wpdb->get_col($wpdb->prepare("SELECT blog_id FROM $wpdb->blogs"));
foreach ($blogids as $blog_id) {
switch_to_blog($blog_id);
$this->_tffaq_uninstall();
}
switch_to_blog($old_blog);
return;
}
}
$this->_tffaq_uninstall();
}
function _tffaq_uninstall(){
global $wpdb;
$db_table_name = $wpdb->prefix . "faq_questions";
$sql = 'DROP TABLE IF EXISTS '.$db_table_name;
$wpdb->query( $sql );
$db_table_name = $wpdb->prefix . "faq_categories";
$sql = 'DROP TABLE IF EXISTS '.$db_table_name;
$wpdb->query( $sql );
delete_option( "faq_version" );
delete_option( "faq-email" );
} /**** end uninstall function *****/
/***** FRONT END *****/
function faq_show($questions) {
$new_content = '';
foreach($questions as $question) {
$new_content .= ''.$question->question.'
';
$new_content .= '" '.$question->answer.' "
';
}
return $new_content;
}
function add_faq_front_js() {
wp_register_script( 'faq_frontend', plugins_url( 'js/faq-frontend.js' , __FILE__ ) );
wp_enqueue_script( 'faq_frontend' );
}
add_action('wp_head','add_faq_front_js',0);
function add_faq_front_css() {
wp_register_style( 'faq_frontend', plugins_url( 'css/front.css' , __FILE__ ) );
wp_enqueue_style( 'faq_frontend' );
}
add_action('wp_head','add_faq_front_css',0);
/***** END FRONT END *****/
//add the admin panel
function add_faq_adminpanel() {
global $menu, $submenu;
$minLevelGeneral = 'Editor';
add_menu_page(__('FAQ','faq-you'), __('FAQ','faq-you'), $minLevelGeneral , 'faq-questions', 'faq_questions', plugins_url('images/faq-icon.png' , __FILE__ ));
add_submenu_page('faq-questions', __('Questions','faq-you'), __('Questions','faq-you'), $minLevelGeneral , 'faq-questions', 'faq_questions');
$questions = faq_get_empty_questions();
if(count($questions) > 0) {
$showMenu = ''.__('Unanswered questions','faq-you').' ('.count($questions).')';
} else {
$showMenu = __('Unanswered questions','faq-you');
}
add_submenu_page('faq-questions', __('Unanswered questions','faq-you'), $showMenu, $minLevelGeneral , 'faq-askquestions', 'faq_askquestions');
add_submenu_page('faq-questions', __('Categories','faq-you'), __('Categories','faq-you'), $minLevelGeneral , 'faq-categories', 'faq_categories');
add_submenu_page('faq-questions', __('Options'), __('Options'), 10, 'faq-options', 'faq_options');
}
add_action('admin_menu', 'add_faq_adminpanel');
/***** add to the editor *****/
function init_faq_editor() {
global $current_user;
if(!current_user_can('editor')) {return;}
if(get_user_option("rich_editing") == "true") {
add_filter("mce_external_plugins", "add_faq_editor");
add_filter("mce_buttons", "register_faq_editor");
}
}
add_action("init", "init_faq_editor");
function register_faq_editor($buttons) {
array_push($buttons, "separator", "faq");
return $buttons;
}
function add_faq_editor($plug_array) {
$plug_array['faq'] = plugins_url('/'.str_replace(basename( __FILE__),"",plugin_basename(__FILE__)).'js/faq-add-tinymce.js');
return $plug_array;
}
//the admin panel for question creation
function faq_options() {
require_once('faq-actions.php');
require_once('faq-options.php');
}
function faq_askquestions() {
require_once('faq-askquestions.php');
}
function faq_questions() {
require_once('faq-actions.php');
if(empty($_GET['insert'])) {
if(empty($_GET['edit'])) {
require_once('faq-manage-questions.php');
} else {
require_once('faq-add-question.php');
}
} else {
require_once('faq-insert-category.php');
}
}
function faq_categories() {
require_once('faq-actions.php');
if(empty($_GET['edit'])) {
require_once('faq-manage-categories.php');
} else {
require_once('faq-add-category.php');
}
}
/***** add some css to the admin side *****/
function faq_add_css() {
wp_register_style( 'faq_admin', plugins_url( 'css/faq-style.css' , __FILE__ ) );
wp_enqueue_style( 'faq_admin' );
}
add_action('admin_init','faq_add_css');
/***** faq functions *****/
function faq_get_first_category() {
global $wpdb;
$first_cat = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_categories ORDER BY id ASC LIMIT 0,1");
return $first_cat[0];
}
function faq_get_questions($category) {
global $wpdb;
$questions = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_questions WHERE category='".$category."' AND answer!='' ORDER BY id DESC");
return $questions;
}
function faq_get_empty_questions() {
global $wpdb;
$questions = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_questions WHERE answer='' ORDER BY id DESC");
return $questions;
}
function faq_get_categories() {
global $wpdb;
$categories = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_categories ORDER BY id ASC");
return $categories;
}
function faq_get_category($id) {
global $wpdb;
$the_cat = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_categories WHERE id='".$id."'");
return $the_cat[0];
}
function faq_category_by_name($category) {
global $wpdb;
$the_cat = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_categories WHERE category='".$category."'");
return $the_cat[0];
}
function faq_get_question($id) {
global $wpdb;
$the_question = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_questions WHERE id='".$id."'");
return $the_question[0];
}
/***** new shortcodes *****/
/***** start faq_search *****/
function faq_search() {
global $wpdb;
$string = isset($_POST['faq-search'])? esc_attr($_POST['faq-search']):'';
$new_content = '';
if(!isset($_POST['faq-search'])) {
return $new_content;
} else {
/***** do the search *****/
$questions =(!empty($_POST['faq-cat']))? $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_questions WHERE category='".$_POST['faq-cat']."' AND question LIKE '%".$string."%' OR answer LIKE '%".$string."%'") : $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."faq_questions WHERE question LIKE '%".$string."%' OR answer LIKE '%".$string."%'");
/***** end do the search *****/
if($questions && strlen($string) > 2) {
$new_content .= faq_show($questions);
} else {
$new_content .= __('no search results were found: ','faq-you').''.$string.'.';
}
$new_content .= '';
$content = $new_content;
}
return $content;
}
add_shortcode('faq_search', 'faq_search');
/***** end faq_search *****/
function faq_ask() {
global $wpdb;
if(isset($_POST['new-question']) and isset($_POST['question'])) {
$question = esc_textarea($_POST['question']);
$category = absint($_POST['category']);
$table_name = $wpdb->prefix.'faq_questions';
$wpdb->insert( $table_name, array( 'category' => $category, 'question' => $question, 'answer' => '' ) );
$message = __('Your question has been submitted. Thank you.','faq-you');
$faq_email = get_option('faq-email');
if($faq_email) { /***** send e-mail notification that a question was asked *****/
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset="UTF-8"' . "\r\n";
$cat = faq_get_category($category);
$subject = $cat->category.' '.__('question','faq-you');
$email = '
"'.$cat->category.'" '.__('question','faq-you').'
'.__('Someone asked this question on: ','faq-you').' '.get_option('siteurl').'
'.__('Category').': '.$cat->category.'
'.__('Question').': '.$question.'
click here to answer the question
';
wp_mail($faq_email,$subject,$email,$headers);
}
}
$new_content = '';
return $new_content;
} /***** end [faq_ask] *****/
add_shortcode('faq_ask', 'faq_ask');
function faq_one_category( $atts, $content = null ) {
extract( shortcode_atts( array(
'id' => '1',
), $atts ) );
$new_content = '';
$category = faq_get_category($id);
$new_content .= '';
$questions = faq_get_questions($category->id);
$new_content .= faq_show($questions);
$new_content .= '
';
return $new_content;
}
add_shortcode('faq', 'faq_one_category');
/***** get category by name *****/
function faq_category_name( $atts, $content = null ) {
extract( shortcode_atts( array(
'name' => 'General',
), $atts ) );
$new_content = '';
$category = faq_category_by_name($name);
$new_content .= '';
$questions = faq_get_questions($category->id);
$new_content .= faq_show($questions);
$new_content .= '
';
return $new_content;
}
add_shortcode('faq_name', 'faq_category_name');
function faq_all_category(){
$categories = faq_get_categories();
$new_content = '';
foreach($categories as $category) {
$category = faq_get_category($category->id);
$new_content .= '';
$questions = faq_get_questions($category->id);
$new_content .= faq_show($questions);
$new_content .= '
';
}
return $new_content;
}
add_shortcode('faq_all', 'faq_all_category');
/***** end new shortcodes *****/
/***** end FAQ functions *****/
/***** install and create the database tables *****/
register_activation_hook( __FILE__, 'tffaq_install' );
function tffaq_install() {
global $wpdb;
if (function_exists('is_multisite') && is_multisite()) {
// check if it is a network activation - if so, run the activation function for each blog id
if (isset($_GET['networkwide']) && ($_GET['networkwide'] == 1)) {
$old_blog = $wpdb->blogid;
// Get all blog ids
$blogids = $wpdb->get_col($wpdb->prepare("SELECT blog_id FROM $wpdb->blogs"));
foreach ($blogids as $blog_id) {
switch_to_blog($blog_id);
$this->_tffaq_install();
}
switch_to_blog($old_blog);
return;
}
}
$this->_tffaq_install();
}
function _tffaq_install() {
global $wpdb;
$table_name = $wpdb->prefix . "faq_questions";
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
$sql = "CREATE TABLE " . $table_name . " (
id mediumint(9) NOT NULL AUTO_INCREMENT,
category int(9) DEFAULT '0' NOT NULL,
question text NOT NULL,
answer text NOT NULL,
UNIQUE KEY id (id)
);";
require_once(ABSPATH.'wp-admin/includes/upgrade.php');
dbDelta($sql);
}
$table_name = $wpdb->prefix . "faq_categories";
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
$sql = "CREATE TABLE " . $table_name . " (
id mediumint(9) NOT NULL AUTO_INCREMENT,
category VARCHAR(50) NOT NULL,
UNIQUE KEY id (id)
);";
require_once(ABSPATH.'wp-admin/includes/upgrade.php');
dbDelta($sql);
$insert = "INSERT INTO ".$table_name." (category) "."VALUES ('".__('General','faq-you')."')";
$results = $wpdb->query( $insert );
}
/***** update the version *****/
$tffaq_version = "0.0.3";
if(!add_option("tffaq_version",$tffaq_version)) {
update_option("tffaq_version",$tffaq_version);
}
}
add_action( 'wpmu_new_blog', 'tf_new_blog', 10, 6);
function tf_new_blog($blog_id, $user_id, $domain, $path, $site_id, $meta ) {
global $wpdb;
if ( ! function_exists( 'is_plugin_active_for_network' ) ) {
require_once( ABSPATH . '/wp-admin/includes/plugin.php' );
}
if (is_plugin_active_for_network('tf-faq/faq.php')) {
$old_blog = $wpdb->blogid;
switch_to_blog($blog_id);
_tffaq_install();
switch_to_blog($old_blog);
}
}
/***** show category dropdown *****/
function faq_category_dropdown() {
?>