/**
* Checks all defined {@link $foreignKeys} to see if the supplied id is referenced
* @param integer The ID of the subject record
* @return boolean true if the record has a reference in another table, otherwise false
*/
function HasFKRef($id)
{
$bHasRef = false;
$oKey = new dclDB();
reset($this->foreignKeys);
while ((list($sTable, $sField) = each($this->foreignKeys)) && !$bHasRef) {
if (is_array($sField)) {
reset($sField);
while ((list($sDummyKey, $sOneField) = each($sField)) && !$bHasRef) {
if ($oKey->ExecuteScalar("SELECT COUNT(*) FROM {$sTable} WHERE {$sOneField}={$id}") > 0) {
$bHasRef = true;
}
}
} else {
if ($oKey->ExecuteScalar("SELECT COUNT(*) FROM {$sTable} WHERE {$sField}={$id}") > 0) {
$bHasRef = true;
}
}
}
return $bHasRef;
}
function GetStatusType($id)
{
$db = new dclDB();
return $db->ExecuteScalar("select dcl_status_type from statuses where id={$id}");
}
}
$content .= '</div>';
include 'install_tpl.php';
break;
case 'updateTables':
include_once "../inc/config.php";
include_once "../inc/functions.inc.php";
include_once 'tables_baseline.inc.php';
$UPGRADE_VERSIONS = array();
include_once 'tables_update.inc.php';
include_once 'class/setup.php';
// Get current version
$oDB = new dclDB();
$oDB->Connect();
if ($oDB->TableExists('dcl_config')) {
$dclVersion = $oDB->ExecuteScalar("SELECT dcl_config_varchar FROM dcl_config WHERE dcl_config_name = 'DCL_VERSION'");
// These versions are translated to pseudo-versions for upgrade purposes
switch ($dclVersion) {
case '20010321':
$dclVersion = '0.5.1';
break;
case '20010327':
$dclVersion = '0.5.2';
break;
case '20010413':
$dclVersion = '0.5.3';
break;
case '20010715':
$dclVersion = '0.5.4';
break;
case '20010729':
