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;
}
}
