Changeset 945433

Timestamp:

07/09/2014 08:16:30 AM (11 years ago)

Author:

mindnl

Message:

bugfix DBupgrade

Location:

ad-buttons/trunk

Files:

• adbuttons.php (modified) (3 diffs)
• readme.txt (modified) (2 diffs)

ad-buttons/trunk/adbuttons.php

@@ -5 +5 @@
 Description: Plugin to add ad buttons to your blog
 Author: Nico
-Version: 2.2
+Version: 2.2.1
 Author URI: http://www.blogio.net/blog/
 Questions, sugestions, problems? Let me know at [email protected]
@@ -71 +71 @@
     dbDelta($structure);
     
-    $ad_buttons_version = "2.2";
+    $ad_buttons_version = "2.2.1";
     update_option("ad_buttons_version", $ad_buttons_version);
 
-    $ad_buttons_db_version = "2.2";
+    $ad_buttons_db_version = "2.2.1";
     update_option("ad_buttons_db_version", $ad_buttons_db_version);
     
@@ -82 +82 @@
 
 register_activation_hook(__FILE__,'ad_buttons_install');
+
+$ad_buttons_db_version = get_option("ad_buttons_db_version");
+
+if($ad_buttons_db_version <> "2.2.1"){
+    // update database
+    
+    //set the options
+    $newoptions = get_option('widget_adbuttons_cfg');
+    $newoptions['ab_dspcnt'] = '1';
+    $newoptions['ab_target'] = 'bnk';
+    $newoptions['ab_powered'] = '1';
+    $newoptions['ab_count'] = '1';
+    add_option('widget_adbuttons_cfg', $newoptions);
+    
+    // create table
+    global $wpdb;
+    $table = $wpdb->prefix."ad_buttons";
+    $structure = "CREATE TABLE $table (
+        id INT(9) NOT NULL AUTO_INCREMENT,
+        ad_picture VARCHAR(100) NOT NULL,
+        ad_link VARCHAR(500) NOT NULL,
+        ad_text VARCHAR(80) NOT NULL,
+        ad_strdat DATE NOT NULL,
+        ad_enddat DATE NOT NULL,
+        ad_views INT(9) DEFAULT 0,
+        ad_clicks INT(9) DEFAULT 0,
+        ad_active TINYINT(1) NOT NULL DEFAULT 0,
+        adg_count VARCHAR(500) NOT NULL,
+        adg_show tinytext NOT NULL,
+        ad_pos INT(9) DEFAULT 0,
+        
+    UNIQUE KEY id (id)
+    );";
+    
+    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
+    dbDelta($structure);
+    
+    $ab_plugindir = get_option('siteurl').'/'.PLUGINDIR.'/'.dirname(plugin_basename(__FILE__));
+    
+    $wpdb->query("INSERT INTO $table(id, ad_picture, ad_link, ad_text, ad_views, ad_clicks, ad_active)
+        VALUES(1, '".$ab_plugindir."/ab125.jpg', 'http://wordpress.org/plugins/ad-buttons/', 'ads powered by Ad Buttons', 1, 0, 1)");
+
+    $table = $wpdb->prefix."ad_buttons_stats";
+    $structure = "CREATE TABLE $table (
+    abs_dat date NOT NULL,
+    abs_ip int(10) NOT NULL,
+    abs_view tinyint(4) NOT NULL,
+    abs_click tinyint(4) NOT NULL,
+    KEY abs_dat (abs_dat)
+    );";
+    
+    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
+    dbDelta($structure);
+
+    $table = $wpdb->prefix."ad_buttons_stats_hst";
+    $structure = "CREATE TABLE $table (
+    abs_dat date NOT NULL,
+    abs_view int(11) NOT NULL,
+    abs_click int(11) NOT NULL
+    );";
+    
+    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
+    dbDelta($structure);
+    
+    $ad_buttons_version = "2.2.1";
+    update_option("ad_buttons_version", $ad_buttons_version);
+
+    $ad_buttons_db_version = "2.2.1";
+    update_option("ad_buttons_db_version", $ad_buttons_db_version);
+    
+    $ip2nation_db_version = "2.2";
+    update_option("ip2nation_db_available", $ip2nation_db_version);
+}
 
    //check if user is a bot of some sort

ad-buttons/trunk/readme.txt

@@ -5 +5 @@
 Requires at least: 2.0.2
 Tested up to: 3.9
-Stable tag: 2.2
+Stable tag: 2.2.1
 
 The Ad Buttons plugin displays a number of graphical ads in a sidebar widget.
@@ -39 +39 @@
 
 == Changelog ==
+
+= 2.2.1 =
+* 09-07-2014
+* bugfix to the database upgrade process
 
 = 2.2 =