WordPress.org
Get WordPress

Plugin Directory

Changeset 993817


Ignore:
Timestamp:
09/20/2014 10:26:11 AM (12 years ago)
Author:
freshlabs
Message:

SQL query fixes

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r650889 r993817  
    3535        $column_name = 'icon';
    3636        // Add column for icon in terms table
    37         $wpdb->query($wpdb->prepare("ALTER TABLE $terms_table ADD COLUMN $column_name VARCHAR( 255 ) NOT NULL AFTER `color`", null));
     37        $wpdb->query($wpdb->prepare("ALTER TABLE %s ADD COLUMN %s VARCHAR( 255 ) NOT NULL AFTER `color`", array($terms_table, $column_name)));
    3838    }
    3939   
    … …  
    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(
    64                 $wpdb->prepare("ALTER TABLE $wpdb->posts ADD COLUMN $column_name DATETIME NOT NULL DEFAULT %s", array("0000-00-00 00:00:00"))
    65             );
     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)));
    6664        }
    6765    }
Note: See TracChangeset for help on using the changeset viewer.