';
foreach ( $columns as $column_name => $column_display_name ) {
//Style attributes for each col
$class = "class='$column_name column-$column_name'";
$style = "";
//edit link
$editlink = 'admin.php?page=btbe_add&btbe_id='.(int)$rec->id;
$services = json_decode($rec->services, true);
$service_string = "";
if(!empty($services)) {
foreach ($services as $s) {
$service_string .= '
';
}
}
if($rec->book_page != '') {
$booklink = ''.__('View Book Page', 'author-showcase').'';
}
else {
$booklink = '';
}
//Display the cell
switch ( $column_name ) {
case "id": echo ''.stripslashes($rec->id).' | '; break;
case "title": echo ''.stripslashes($rec->title).' | '; break;
case "subtitle": echo ''.stripslashes($rec->subtitle).' | '; break;
case "author": echo ''.stripslashes($rec->author).' | '; break;
case "series": echo ''.stripslashes($rec->series).' '.stripslashes($rec->series_num).' | '; break;
case "cover": echo ' | '; break;
case "updated": echo ''.date("D, M jS Y H:ia", strtotime($rec->updated)).'
'.__('Edit this book', 'author-showcase').' | '; break;
case "links": echo ''.$service_string.' | '; break;
case "book_link": echo ''.$booklink.' | '; break;
}
}
//Close the line
echo'
';
}
}
}
} // class Author_Showcase_Widget
function register_author_showcase() {
register_widget('Author_Showcase_Widget');
}
function btbe_enqueuestylesandjs(){
wp_enqueue_script( 'jquery' );
wp_enqueue_style('bookstyle', plugins_url('style.css', __FILE__));
wp_enqueue_script('bookscript', plugins_url('buybook.js', __FILE__));
}
function btbe_install() {
global $wpdb;
$table_name = $wpdb->prefix."buybooks";
$bb_params = $wpdb->prefix."bb_apis";
if($wpdb->get_var("SHOW TABLES LIKE '$table_name'" ) != $table_name){
$sql= "CREATE TABLE $table_name (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
created DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
updated DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
title VARCHAR(300) DEFAULT '' NOT NULL,
subtitle VARCHAR(300) DEFAULT '' NOT NULL,
series VARCHAR(300) DEFAULT '' NOT NULL,
author VARCHAR(300) DEFAULT '' NOT NULL,
cover VARCHAR(300) DEFAULT '' NOT NULL,
blurb TEXT DEFAULT '' NOT NULL,
asin VARCHAR(20) DEFAULT '' NOT NULL,
isbn VARCHAR(20) DEFAULT '' NOT NULL,
services TEXT DEFAULT '' NULL,
book_page VARCHAR(20) DEFAULT '' NULL,
short_blurb VARCHAR(400) DEFAULT '' NULL,
series_num VARCHAR(20) DEFAULT '' NULL
);";
require_once (ABSPATH. 'wp-admin/includes/upgrade.php' );
dbDelta($sql);
}
if($wpdb->get_var("SHOW TABLES LIKE '$bb_params'" ) != $bb_params) {
$sql= "CREATE TABLE $bb_params (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
api_name VARCHAR(100) DEFAULT '' NOT NULL,
assoc VARCHAR(300) DEFAULT '' NOT NULL,
access_key VARCHAR(300) DEFAULT '' NOT NULL,
secret VARCHAR(300) DEFAULT '' NOT NULL
);";
require_once (ABSPATH. 'wp-admin/includes/upgrade.php' );
dbDelta($sql);
}
add_option( 'buybook_db_version', '1.4.1' );
}
function btbe_admin() {
add_menu_page( __('Author Showcase Book List', 'author-showcase'), __('Author Showcase Book List', 'author-showcase'), 'manage_options', 'btbe_admin', 'btbe_admin_options' );
add_submenu_page( 'btbe_admin', __('Add Book', 'author-showcase'), __('Add Book', 'author-showcase'), 'manage_options', 'btbe_add', 'btbe_add_options');
add_submenu_page( 'btbe_admin', __('Add API Keys', 'author-showcase'), __('Add API Keys', 'author-showcase'), 'manage_options', 'btbe_apis', 'btbe_apis_options');
}
function btbe_admin_options() {
if ( !current_user_can( 'manage_options' ) ) {
wp_die( __( 'You do not have sufficient permissions to access this page.', 'author-showcase' ) );
}
include(dirname(__FILE__) . "/btbe_admin.php");
}
function btbe_add_options() {
if ( !current_user_can( 'manage_options' ) ) {
wp_die( __( 'You do not have sufficient permissions to access this page.' , 'author-showcase') );
}
include(dirname(__FILE__) . "/btbe_add.php");
}
function btbe_apis_options() {
if ( !current_user_can( 'manage_options' ) ) {
wp_die( __( 'You do not have sufficient permissions to access this page.', 'author-showcase' ) );
}
include(dirname(__FILE__) . "/btbe_apis.php");
}
function btbe_page_display($atts) {
global $wpdb;
$books = array();
if(isset($atts['books'])) {
$books = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}buybooks WHERE id IN (".esc_sql($atts['books']).")", ARRAY_A);
}
if(isset($atts['series'])) {
$series = $wpdb->get_results("SELECT DISTINCT series FROM {$wpdb->prefix}buybooks WHERE id IN (".esc_sql($atts['series']).")", ARRAY_A);
$books = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}buybooks WHERE series LIKE '%".esc_sql($series['series'])."%' ORDER BY created", ARRAY_A);
}
if(!empty($books)) {
return btbe_generatePageDisplay($books, $atts);
}
}
function btbe_enqueuemedia($page) {
wp_enqueue_media();
}
function btbe_load_textdomain() {
load_plugin_textdomain( 'author-showcase', false, basename( dirname( __FILE__ ) ) . '/lang/' );
}
add_action('widgets_init', 'register_author_showcase');
add_action('wp_enqueue_scripts', 'btbe_enqueuestylesandjs');
add_filter('admin_enqueue_scripts', 'btbe_enqueuemedia' );
add_action( 'admin_menu', 'btbe_admin' );
add_shortcode( 'btbe_display', 'btbe_page_display' );
add_action('plugins_loaded', 'btbe_load_textdomain');
register_activation_hook( __FILE__, 'btbe_install' );