/** * Activate the plugin */ function vmp_activate() { global $wpdb; // create the table to record up and down votes for each individual posts $wpdb->query("CREATE TABLE IF NOT EXISTS " . TABLE_2 . " (\r\n\t\t\t\t\tid int(11) not null auto_increment,\r\n\t\t\t\t\tpost_id bigint(20) null,\r\n\t\t\t\t\tupvote_count int(11) not null,\r\n\t\t\t\t\tdownvote_count int(11) not null,\r\n\t\t\t\t\tprimary key (id)\r\n\t\t\t\t\t) ENGINE=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); // create the table to record which post is set for registered user voting and which one is for open voting $wpdb->query("CREATE TABLE IF NOT EXISTS " . TABLE_3 . " (\r\n\t\t\t\t\tid int(11) not null auto_increment,\r\n\t\t\t\t\tpost_id bigint(20) not null,\r\n\t\t\t\t\tvote_mode tinyint(1) not null,\r\n\t\t\t\t\tprimary key (id)\r\n\t\t\t\t\t) ENGINE=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); // create the table to record which registered user has voted for which post $wpdb->query("CREATE TABLE IF NOT EXISTS " . TABLE_4 . " (\r\n\t\t\t\t\tid int(11) not null auto_increment,\r\n\t\t\t\t\tuser_id bigint(20) not null,\r\n\t\t\t\t\tpost_id bigint(20) not null,\r\n\t\t\t\t\tprimary key (id)\r\n\t\t\t\t\t) ENGINE=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); // create the table to record the positioning and orientation of voting links $wpdb->query("CREATE TABLE IF NOT EXISTS " . TABLE_5 . " (\r\n\t\t\t\t\tid int(11) not null auto_increment,\r\n\t\t\t\t\tposition tinyint(1) not null,\r\n\t\t\t\t\torientation tinyint(1) not null,\r\n\t\t\t\t\tprimary key (id)\r\n\t\t\t\t\t) ENGINE=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); // create the table to record the positioning and orientation of voting links $wpdb->query("CREATE TABLE IF NOT EXISTS " . TABLE_6 . " (\r\n\t\t\t\t\tid int not null auto_increment,\r\n\t\t\t\t\trepeat_voting tinyint not null default 1,\r\n\t\t\t\t\tvoting_interval int not null default 120,\r\n\t\t\t\t\trow_per_page smallint not null default 5,\r\n\t\t\t\t\tmax_link smallint not null default 7,\r\n\t\t\t\t\tneighbour smallint not null default 3,\r\n\t\t\t\t\tprimary key (id)\r\n\t\t\t\t\t) ENGINE=INNODB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;"); // load settings $settings = array(); $settings = vmp_fetch_settings(); define('REGISTERED_USER_REPEAT_VOTING', $settings[0]); define('COOKIE_EXPIRATION_TIME', $settings[1]); define('VMP_ROW_PER_PAGE', $settings[2]); define('VMP_MAX_PAGE_LINK', $settings[3]); define('VMP_NEIGHBOR', $settings[4]); }
?> <div id="vmp_message_panel_alt" align="center" style="display:none;"> <?php echo $_SESSION['messages']; unset($_SESSION['messages']); ?> </div> <?php } ?> <div class="main_panel" align="center"> <?php $_wpnonce = wp_create_nonce('set_plugin_options'); $action = admin_url('admin.php?action=set_plugin_options_092113&_wpnonce=' . $_wpnonce); $settings = array(); $settings = vmp_fetch_settings(); if (1 == $settings[0]) { $checked_1 = 'checked'; $checked_2 = ''; } else { $checked_1 = ''; $checked_2 = 'checked'; } ?> <form name="vmp_set_plugin_options" id="vmp_set_plugin_options" action="<?php echo $action; ?> " method="post"/> <table class="wp-list-table widefat" cellspacing="0"> <thead> <tr>