| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Scheduler/ |
Upload File : |
<?
// application_site_additional_code.phpinc
// Perform any additionl code that needs to run for this site after authentication.
// Make sure that the include line in application.phphinc line 147 is not commented if you want to use this file.
t_Begin(); // Begin TRACKing included file.
/** /
// UPDATE scheduler database.
if ( $_SERVER['SCRIPT_NAME'] == '/index.php' ) {
// BEGIN Add table.
$tableToAdd = 'siteneedstatus';
$query = "
SELECT *
FROM information_schema.tables
WHERE table_schema = 'scheduler'
AND table_name = '$tableToAdd'
LIMIT 1
";
$tableToAdd_Result = query_do($query);
#d_Var("\$GLOBALS['_QUERY']['count']",$GLOBALS['_QUERY']['count'],'d');
if (!$GLOBALS['_QUERY']['count']) {
$query = "
CREATE TABLE `siteneedstatus` (
`siteneedstatusId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`siteneedstatusName` varchar(16) DEFAULT NULL,
`siteneedstatusInactive` tinyint(4) NOT NULL DEFAULT '0',
`AddedOn` datetime DEFAULT NULL,
`AddedBy` int(11) unsigned DEFAULT NULL,
`ModifiedOn` datetime DEFAULT NULL,
`ModifiedBy` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`siteneedstatusId`),
KEY `IDX_siteneedstatusAdddedBy` (`AddedBy`),
KEY `IDX_siteneedstatusModifiedBy` (`ModifiedBy`)
)
";
$tableAdd_Result = query_do($query);
$query = "
CREATE TABLE `siteneed` (
`siteneedId` int unsigned NOT NULL AUTO_INCREMENT,
`siteneedName` varchar(48) DEFAULT NULL,
`siteneedText` text,
`siteneedFix` text,
`siteneedstatusId` int unsigned DEFAULT NULL,
`siteneedActive` tinyint unsigned NOT NULL DEFAULT '0',
`siteneedDone` tinyint unsigned NOT NULL DEFAULT '0',
`AddedOn` datetime DEFAULT NULL,
`AddedBy` int unsigned DEFAULT NULL,
`ModifiedOn` datetime DEFAULT NULL,
`ModifiedBy` int unsigned DEFAULT NULL,
PRIMARY KEY (`siteneedId`),
KEY `IDX_siteneedAdddedBy` (`AddedBy`),
KEY `IDX_siteneedModifiedBy` (`ModifiedBy`),
KEY `IDX_siteneed_siteneedstatus` (`siteneedstatusId`),
CONSTRAINT `FK_siteneedAddedBy` FOREIGN KEY (`AddedBy`) REFERENCES `user` (`userId`) ON UPDATE CASCADE,
CONSTRAINT `FK_siteneedModifiedBy` FOREIGN KEY (`ModifiedBy`) REFERENCES `user` (`userId`) ON UPDATE CASCADE,
CONSTRAINT `FK_siteneed_siteneedstatus` FOREIGN KEY (`siteneedstatusId`) REFERENCES `siteneedstatus` (`siteneedstatusId`) ON UPDATE CASCADE
)
";
$tableAdd_Result = query_do($query);
}
// END Add table.
}
/**/
/** /
// BEGIN Update userdata table.
$tableToAlter = 'user';
$fieldToFind = 'userVerficationCode';
// Check for $fieldToFind field in $tableToAlter table.
$query = "SHOW COLUMNS FROM `".$tableToAlter."`";
#d_Var('tableTAlter_fieldResult',$query,'dq');
$tableTAlter_fieldResult = query_do($query,$_SESSION['DATABASE']['Default']);
#d_Var('$tableTAlter_fieldResult',$tableTAlter_fieldResult,'d');
#d_End();
$tableToAlter_fieldCount = $GLOBALS['_QUERY']['count'];
if ( $tableToAlter_fieldCount ) { // Does the table exist?
// Yes, see if we need to alter the table.
$tableFieldFound = false;
query_seek($tableTAlter_fieldResult, 0);
while ($row = query_row($tableTAlter_fieldResult)) {
#d_Var("\$row['Field']",$row['Field'],'d');
if ( $row['Field'] == $fieldToFind ) { $tableFieldFound = true; }
}
if ( !$tableFieldFound ) {
// ALTER the $tableToAlter.
$query = "ALTER TABLE `".$tableToAlter."`
add column `".$fieldToFind."` char(32) NULL after `userLoginPHPSESSID`
";
d_Var('userdataAlter',$query,'q');
$userdataAlter = query_do($query);
displayInfo($tableToAlter.' table altered.');
}
} // Does the table exist?
// END Update userdata table.
/**/
/** /
alter table `scheduler`.`userdata`
add column `departmentIdFilter` varchar(255) NULL after `INSTRUCTOR`
alter table `scheduler`.`user`
add column `userVerficationCode` char(32) NULL after `userLoginIPDecimal`
userLoginPHPSESSID
/**/
/** /
$tableTAlter_fieldResult[1]['Default'] is unset
$tableTAlter_fieldResult[1]['Extra'] == ''
$tableTAlter_fieldResult[1]['Field'] == 'departmentId'
$tableTAlter_fieldResult[1]['Key'] == ''
$tableTAlter_fieldResult[1]['Null'] == 'YES'
$tableTAlter_fieldResult[1]['Type'] == 'int(11) unsigned'
/**/
t_End(); // End TRACKing included file.
?>