WordPress.org
Get WordPress

Plugin Directory

Changeset 993848


Ignore:
Timestamp:
09/20/2014 12:21:08 PM (12 years ago)
Author:
freshlabs
Message:

Fixed sql query for creating event columns in posts table

File:
1 edited

Legend:

Unmodified
Added
Removed

  • wp-simile-timeline/trunk/inc/WPSimileTimelineDatabase.class.php

    r993817 r993848  
    4444        global $wpdb;
    4545        $column_exists = false;
    46         $q = $wpdb->query($wpdb->prepare("SHOW COLUMNS FROM $wpdb->posts LIKE '%s'", $col_name));
     46        $q = $wpdb->query($wpdb->prepare("SHOW COLUMNS FROM $wpdb->posts LIKE %s", $col_name));
    4747        if($q == 1){
    4848            $column_exists = true;
    … …  
    6161        global $wpdb;
    6262        if(!WPSimileTimelineDatabase::columnExists($column_name)) {
    63             $wpdb->query($wpdb->prepare("ALTER TABLE $wpdb->posts ADD COLUMN %s datetime NOT NULL DEFAULT '0000-00-00 00:00:00'", array($column_name)));
     63            $wpdb->query($wpdb->prepare("ALTER TABLE $wpdb->posts ADD COLUMN $column_name datetime NOT NULL DEFAULT %s", array("0000-00-00 00:00:00") ));
    6464        }
    6565    }
    … …  
    7575        global $wpdb;
    7676        $table_name = $wpdb->prefix . $tn;
    77         $wpdb->query($wpdb->prepare("DROP TABLE %s", array($table_name)));
     77        $wpdb->query($wpdb->prepare("DROP TABLE %s", $table_name));
    7878    }
    7979
    … …  
    8585        global $wpdb;
    8686        if(WPSimileTimelineDatabase::columnExists($column_name)) {
    87             $wpdb->query($wpdb->prepare("ALTER TABLE $wpdb->posts DROP COLUMN %s", array($column_name)));
     87            $wpdb->query($wpdb->prepare("ALTER TABLE $wpdb->posts DROP COLUMN %s", $column_name));
    8888        }
    8989    }
Note: See TracChangeset for help on using the changeset viewer.