| 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 : /nginx/html/Scheduler/site/_work/ |
Upload File : |
<?
// /Fix_scheduleclassSection.php
// Move scheduleclass.scheduleclassSection data to scheduleclasssection.
#$TRACK = false; // Uncomment this line to turn off tracking for this page.
#$debuggingAvailable = true; // Comment this line to disable debugging functions.
#$skipAuthentication = true; // Uncomment this line to skip authentication for this page.
$authorizedGroups = "USER"; // List of groups authorized to view this page (i.e., PUBLIC = anyone, USER = any user, "Admin,Manager" = users in the Admin or Manager groups).
require('../../application.phpinc');
pageHeader('index_php_title');
d_On();
// Check for scheduleclass.scheduleclassSection field.
$fieldQuery="SHOW COLUMNS FROM `scheduleclass` LIKE 'scheduleclassSection'";
$fieldInfo = query_info($fieldQuery);
#d_Var('$fieldInfo',$fieldInfo);
if ( !$fieldInfo ) {
?><h2>The scheduleclass.scheduleclassSection has already been fixed.</h2><?
pageFooter();
}
$query = "
SELECT scheduleclassId
, scheduleclassSection
FROM `scheduleclass`
";
d_Var('scheduleclassResult',$query,'q');
$scheduleclassResult = query_do($query);
$scheduleclassCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassResult',$scheduleclassResult);
if ( $scheduleclassCount ) {
query_seek($scheduleclassResult, 0);
while ($scheduleclassInfo = query_row($scheduleclassResult)) {
$scheduleclassSections = explode(',',$scheduleclassInfo['scheduleclassSection']);
foreach ( $scheduleclassSections as $scheduleclassSection ) {
$query = "
INSERT INTO `scheduleclasssection` (
scheduleclassId
, scheduleclassSection
) VALUES (
".$scheduleclassInfo['scheduleclassId']."
, '".query_safe(trim($scheduleclassSection))."'
)
";
#d_Var('scheduleclasssectionINSERT',$query,'q');
$scheduleclasssectionINSERT = query_do($query);
#d_Var('$scheduleclasssectionINSERT',$scheduleclasssectionINSERT,'l');
}
}
}
$query = "alter table `scheduler`.`scheduleclass` drop column `scheduleclassSection`";
$schedulerALTER = query_do($query);
?>
<h2>The scheduleclass.scheduleclassSection has been moved to the scheduleclasssection table.</h2>
<?
#d_On('foot');
pageFooter();
?>