<?php
/* 
Plugin Name: Logbook 
Plugin URI: http://dh9sb.dx-info.de 
Description: Plugin for searching calls in a logbook. 
Author: M. Konieczny, DH9SB 
Version: 1.0d
Author URI: http://dh9sb.dx-info.de 
*/ 

global $logbook_db_version;
$logbook_db_version = "2";
        


function logbook_install()
{
    global $wpdb;
    global $logbook_db_version;
    
    $table_logbook = $wpdb->prefix."logbook";
    $table_logbookBooks = $wpdb->prefix."logbookBooks";
    $table_logbookRef = $wpdb->prefix."logbookRef";
    
    $structure_logbook = "CREATE TABLE $table_logbook (
                    id mediumint(8) unsigned NOT NULL auto_increment,
                    MyCallsign varchar(20) NOT NULL default '',
                    Date date NOT NULL default '0000-00-00',
                    Time time NOT NULL default '00:00:00',
                    CallSign varchar(30) NOT NULL default '',
                    Band tinyint(3) unsigned NOT NULL default '0',
                    Frequency varchar(15) NOT NULL default '',
                    Mode varchar(15) NOT NULL default '',
                    Prop_Mode varchar(15) NOT NULL default '',
                    RSTS varchar(10) NOT NULL default '',
                    RSTR varchar(10) NOT NULL default '',
                    refid int(11) NOT NULL,
                    booksid int(11) NOT NULL,
                    PRIMARY KEY  (id)
                  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16;";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($structure_logbook);
        $structure_logbookBooks = "CREATE TABLE $table_logbookBooks (
                    `id` int(10) NOT NULL auto_increment,
                    `uploadDate` varchar(25) NOT NULL,
                    `refid` int(10) default NULL,
                    PRIMARY KEY  (`id`)
                  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($structure_logbookBooks);   
        $structure_logbookRef = "CREATE TABLE $table_logbookRef (
                    `id` int(11) NOT NULL auto_increment,
                    `refnumber` varchar(10) NOT NULL,
                    `refdescription` varchar(255) NOT NULL,
                    PRIMARY KEY  (`id`)
                  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($structure_logbookRef);
        
        add_option("logbook_db_version", $logbook_db_version);  

  $installed_db_version = get_option( "logbook_db_version" );

   if( $installed_db_version != $logbook_db_version ) {

    $structure_logbook = "CREATE TABLE $table_logbook (
                    id mediumint(8) unsigned NOT NULL auto_increment,
                    MyCallsign varchar(20) NOT NULL default '',
                    Date date NOT NULL default '0000-00-00',
                    Time time NOT NULL default '00:00:00',
                    CallSign varchar(30) NOT NULL default '',
                    Band tinyint(3) unsigned NOT NULL default '0',
                    Frequency varchar(15) NOT NULL default '',
                    Mode varchar(15) NOT NULL default '',
                    Prop_Mode varchar(15) NOT NULL default '',
                    RSTS varchar(10) NOT NULL default '',
                    RSTR varchar(10) NOT NULL default '',
                    refid int(11) NOT NULL,
                    booksid int(11) NOT NULL,
                    PRIMARY KEY  (id)
                  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16;";
                  
      require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
      dbDelta($structure_logbook);
      add_option('logbook_showProp_Mode','false');
      update_option( "logbook_db_version", $logbook_db_version );
  }
  
}
/*
function logbook_db_update(){
    global $wpdb;
    global $logbook_db_version;
    $table_logbook = $wpdb->prefix."logbook";
        
    $structure_logbook_update = "ALTER TABLE $table_logbook ADD Prop_Mode CHAR(15);";
    $wpdb->query($structure_logbook_update);
              
    update_option( "logbook_db_version", $logbook_db_version );
}

function logbook_version_check(){
    global $wpdb;
    global $logbook_db_version;
    global $installed_db_version;    
        
        if (empty($installed_db_version)) {
    $installed_db_version = 0;
}
          
        if( $logbook_db_version != $installed_db_version ) {
        logbook_db_update();
        }else{
        logbook_install();
        }

}
*/
function logbook_administration() {  
    include('logbook_administration.php');  
}

function logbook_upload() {  
    include('logbook_upload.php');  
}

function logbook_books() {  
    include('books_list.php');  
}

function logbook_refs() {  
    include('references_list.php');  
}  

function logbookAdm_admin_actions() {
        add_menu_page("Options", "Logbook", 10, "Logbook_administration", "logbook_administration");
        add_submenu_page("Logbook_administration", "Upload", "Upload", 10, "Logbook_upload", "logbook_upload"); 
        add_submenu_page("Logbook_administration", "Books", "Books", 10, "Logbook_books", "logbook_books");
        add_submenu_page("Logbook_administration", "References", "References", 10, "Logbook_refs", "logbook_refs"); 
    }

function logbook_frontend($args) {
  echo $args['before_widget'];
  echo $args['before_title'].'Logbook'.$args['after_title'];
  include('logbook_search.php');
  echo $args['after_widget'];
}
 
function logbook_init(){
 register_sidebar_widget("Logbook", "logbook_frontend");
}

function my_init_method() {
    if (!is_admin() )
    wp_deregister_script( 'jquery' );
    wp_register_script( 'jquery', plugins_url( 'js/jquery.min.js' , __FILE__ ));
    wp_enqueue_script( 'jquery' );

    #LOAD THE GOOGLE API JQUERY INCLUDES
		wp_register_script('jquery_ui', plugins_url( 'js/jquery-ui.min.js' , __FILE__ ), false, '1.8.2', false);
    wp_register_style('jquery_ui_css', plugins_url( 'js/jquery-ui.css' , __FILE__ ));
		#REGISTER CUSTOM JQUERY INCLUDES
		wp_enqueue_script('jquery_ui');
    wp_enqueue_style('jquery_ui_css');
}

function add_logbook_stylesheet() {
            wp_register_style('logbookStyleSheets', plugins_url('logbook.css' , __FILE__ ));
            wp_enqueue_style( 'logbookStyleSheets');
    }
    
function set_logbook_options () {
global $logbook_db_version;

     add_option('logbook_showDate','true');
     add_option('logbook_showTime','true');
     add_option('logbook_showCall','false');     
     add_option('logbook_showBand','true');
     add_option('logbook_showFreq','false');
     add_option('logbook_showMode','true');
     add_option('logbook_showProp_Mode','false');
     add_option('logbook_showRSTS','true');
     add_option('logbook_showRSTR','true');
     add_option('logbook_showRefNO','true');
     add_option('logbook_showRefDesc','true');
     add_option('logbook_showMyCallsign','false');
     add_option('logbook_defaultMyCallsign','');

}

function myplugin_update_db_check() {
    global $logbook_db_version;
    if (get_site_option('logbook_db_version') != $logbook_db_version) {
        logbook_install();
    }
}

add_action('plugins_loaded', 'myplugin_update_db_check');
         
add_action('admin_menu', 'logbookAdm_admin_actions'); 
add_action("plugins_loaded", "logbook_init");
add_action('wp_print_styles', 'add_logbook_stylesheet');
add_action('init', 'my_init_method');
register_activation_hook( __FILE__, 'set_logbook_options' );
register_activation_hook(__FILE__,'logbook_install');
?>