public static function getAllVersions() { $versions = array(); $db = Zend_Registry::get('my_db'); $v = new Versions($db); $result = $v->fetchAll("version_id = " . $id); foreach ($result as $row) { switch (DB_TYPE) { case 'mysql': $version = new Version($row->version_id); break; case 'oci8': $version = new Version($row->version_id); break; } array_push($versions, $version); } return $versions; }
public static function getAllVersions() { $versions = array(); //$db = ZitDBAdapter::getDBAdapter(); $db = Zend_Registry::get('my_db2'); $v = new Versions($db); $result = $v->fetchAll("active = 1"); foreach ($result as $row) { switch (DB_TYPE) { case 'mysql': $version = new Version($row->version_id); break; case 'oci8': $version = new Version($row->VERSION_ID); break; } array_push($versions, $version); } return $versions; }
public static function checkVersion($passVer) { $db = Zend_Registry::get('my_db'); $versions = new Versions($db); $quoted = $db->quote($passVer); $result = $versions->fetchAll("active = 1 and version_num = {$quoted}"); foreach ($result as $row) { switch (DB_TYPE) { case 'mysql': if ($passVer == $row->version_num) { return true; } break; case 'oci8': if ($passVer == $row->VERSION_NUM) { return true; } break; } } return false; }
public static function getZoneVersion() { $db = Zend_Registry::get('my_db'); $v = new Versions($db); $version_id = $_SESSION['ZONE_VERSION_ID']; $result = $v->fetchAll("version_id = {$version_id}"); switch (DB_TYPE) { case 'mysql': $_SESSION['VERSION_NAMESPACE'] = $result[0]->version_namespace; $_SESSION['ZONE_VERSION'] = $result[0]->version_num; $_SESSION['ZONE_VERSION_DIRECTORY'] = $result[0]->version_directory; $_SESSION['ZONE_VERSION_SCHEMA_DIR'] = $result[0]->schema_directory; break; case 'oci8': $_SESSION['VERSION_NAMESPACE'] = $result[0]->VERSION_NAMESPACE; $_SESSION['ZONE_VERSION'] = $result[0]->VERSION_NUM; $_SESSION['ZONE_VERSION_DIRECTORY'] = $result[0]->VERSION_DIRECTORY; $_SESSION['ZONE_VERSION_SCHEMA_DIR'] = $result[0]->SCHEMA_DIRECTORY; break; } }