[Plugin: Media Library Categories] Inefficient Column Check

Hi,

There is an inefficient query being run on mc->CheckForTermOrderColumn() call (on init hook) to check if the term_order column exists or not in $wpdb->terms table. The issue is that no database has been specified hence it looks through ALL databases running on the server. (as far as I can tell)

So the fix:

plugins/media-library-categories/media-categories.php (line 148)

//-- CHECK FOR term_order column ---
$query = "
SELECT COUNT(*) FROM information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '" . DB_NAME . "'
AND TABLE_NAME = '$wpdb->terms'
AND COLUMN_NAME = 'term_order';
";

http://ww.wp.xz.cn/extend/plugins/media-library-categories/