query("CREATE TABLE `".$wpdb->prefix."adv_v_base` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`ads_name` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`ads_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`block_width` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`block_height` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`ads_link_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`new_window` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`trace_clicks` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`time_management` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`start_date` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`end_date` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`limit_clicks` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`click_amount` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`clicks_left` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`clicks_done` varchar(10) COLLATE utf8_unicode_ci DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
");
if(!res) die('Cant create tabe');
}
/* DB generation END*/
/* Script and style equation Begin */
wp_enqueue_script('adv_advertizer', WP_PLUGIN_URL . '/advertizer/js/advertizer.js.php', array('jquery'),'1.0' );
wp_enqueue_script('jquery-ui', WP_PLUGIN_URL . '/advertizer/js/jquery-ui-1.7.3.custom.min.js', array('jquery'),'1.0' );
wp_enqueue_script('jquery-datepicker', WP_PLUGIN_URL . '/advertizer/js/datepicker.js', array('jquery'),'1.0' );
wp_enqueue_style('datepick_opt_css', WP_PLUGIN_URL . '/advertizer/css/jquery-ui-1.7.3.custom.css');
wp_enqueue_style('personal_css', WP_PLUGIN_URL . '/advertizer/css/personal.css');
/* Script equation END */
/* Admin Menu generator BEGIN */
/*
add_action('admin_menu', 'adv_v_gen');
function adv_v_gen() {
add_menu_page('Advertizer Featured', 'Advertizer', 'manage_options', 'adv_v_script', 'add_v_advert');
add_submenu_page('adv_v_script', 'Add Advertizing', 'Add Advert', 'manage_options', 'add_v_advertizing','add_ads_v_advert');
add_submenu_page('adv_v_script', 'Viev Ads Stat', 'Ads stat', 'manage_options', 'ads_v_stat','get_ads_v_stat');
}
*/
add_action('admin_menu', 'adv_v_gen');
function adv_v_gen() {
add_options_page('Advertizer Featured', 'Advertizer 
', 'manage_options', 'add_v_advertizing', 'add_ads_v_advert');
}
/* Admin Menu generator END */
/***** CORE FUNCTIONS BEGIN **********/
function add_ads_v_advert(){
echo '
';
}
function get_ads_v_stat(){
echo 'get ads list adb';
}
/***** CORE FUNCTIONS END ************/
/* View all booked data BEGIN*/
function view_calendar(){
echo 'View calendar';
}
/* View all booked data END*/
?>
get_row("SELECT `ads_url`, `ads_link_url`, `new_window`, `limit_clicks` FROM `".$wpdb->prefix."adv_v_base` WHERE `id`='".$instance['ads_id']."' LIMIT 1; ");
if(esc_attr($instance['ads_title_show']) == 1)
echo $before_title.$instance['ads_title'].$after_title;
echo '';
}
function update($new_instance, $old_instance) {
return $new_instance;
}
/********* PRINT WIDGET BACKEND FORM ***********/
function form($instance) {
global $wpdb;
$title = esc_attr($instance['ads_id']);
$res = $wpdb->get_results("SELECT `id`, `ads_name` FROM `".$wpdb->prefix."adv_v_base`; ");
echo '
';
echo '
Show title:
';
}
}
add_action('widgets_init', create_function('', 'return register_widget("Advertizer");'));
/* Widget Generation END */
?>