50 lines
1.5 KiB
PHP
50 lines
1.5 KiB
PHP
<?php
|
|
|
|
include "../db.php";
|
|
|
|
$query = "SELECT * FROM nb_schools";
|
|
$schools = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($schools)) {
|
|
$url = $row['url'];
|
|
$school_code = $row['school_code'];
|
|
$rnum = $row['record_num'];
|
|
|
|
$query = "SELECT * FROM schools WHERE url = '$url'";
|
|
$results = db_query($query);
|
|
|
|
if (db_num_rows($results) == 0) {
|
|
echo("ERROR: $url not found\n");
|
|
continue;
|
|
}
|
|
|
|
$row = db_fetch_assoc($results);
|
|
$row['nb_school_code'] = $school_code;
|
|
$Schools[$school_code] = $row;
|
|
|
|
$school_num = $row['record_num'];
|
|
|
|
echo("$school_code: ($school_num) $url\n");
|
|
|
|
$query = "SELECT min(added_date) FROM people WHERE school_num = $school_num AND people_type = 'Staff'";
|
|
$uDate = db_getVal($query);
|
|
if (is_string($uDate) && strlen($uDate)) {
|
|
$query = "UPDATE nb_schools SET school_num = $school_num, upload_date = '$uDate' WHERE record_num = $rnum";
|
|
db_query($query);
|
|
}
|
|
|
|
$query = "SELECT count(*) FROM people WHERE school_num = $school_num AND people_type = 'Staff'";
|
|
$nStaff = db_getVal($query);
|
|
|
|
$query = "SELECT count(*) FROM people WHERE school_num = $school_num AND people_type = 'Student' AND class_num > 0";
|
|
$nStudents = db_getVal($query);
|
|
|
|
$query = "SELECT count(*) FROM classes WHERE school_num = $school_num";
|
|
$nClasses = db_getVal($query);
|
|
|
|
$query = "UPDATE nb_schools SET school_num = $school_num, num_staff = $nStaff, num_classes = $nClasses, num_students = $nStudents WHERE record_num = $rnum";
|
|
db_query($query);
|
|
}
|
|
|
|
?>
|