/** * 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':