function get_db_versions($limit = 100, $only_needs_upgrade = TRUE) { $mhi_db = Kohana::config('database.default'); $table_prefix = $mhi_db['table_prefix']; $mhi_db_name = $mhi_db['connection']['database']; $dbs = Mhi_Site_Database_Model::get_all_db_details(); // Switch to new DB for a moment $array = array(); $settings = ORM::factory('settings', 1); $current_version = $settings->db_version; $i = 0; foreach ($dbs as $db) { if ($i >= $limit) { break; } mysql_query('USE ' . $db . ';'); // START: Everything that happens in the deployment DB happens below $settings = ORM::factory('settings', 1); if ($only_needs_upgrade == FALSE or $settings->db_version != $current_version) { $array[$db] = $settings->db_version; $i++; } } // END: Everything that happens in the deployment DB happens above //Switch back to our db, otherwise we would be running off some other deployments DB and that wouldn't work mysql_query('USE ' . $mhi_db_name); return $array; }
function get_db_versions() { $mhi_db = Kohana::config('database.default'); $table_prefix = $mhi_db['table_prefix']; $mhi_db_name = $mhi_db['connection']['database']; $dbs = Mhi_Site_Database_Model::get_all_db_details(); // Switch to new DB for a moment $array = array(); foreach ($dbs as $db) { mysql_query('USE ' . $db . ';'); // START: Everything that happens in the deployment DB happens below $settings = ORM::factory('settings', 1); $array[$db] = $settings->db_version; } // END: Everything that happens in the deployment DB happens above //Switch back to our db, otherwise we would be running off some other deployments DB and that wouldn't work mysql_query('USE ' . $mhi_db_name); return $array; }