54 lines
1.1 KiB
PHP
54 lines
1.1 KiB
PHP
<?php
|
|
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
$src_school_num = 370;
|
|
$new_school_num = 18428;
|
|
|
|
db_query("DELETE FROM classes WHERE school_num = $new_school_num");
|
|
db_query("DELETE FROM people WHERE school_num = $new_school_num AND people_type = 'Staff'");
|
|
db_query("DELETE FROM users WHERE school_num = $new_school_num AND type = 'Staff'");
|
|
|
|
$staff = db_query("SELECT * FROM people WHERE school_num = $src_school_num AND people_type = 'Staff'");
|
|
|
|
$table = new Table("people");
|
|
|
|
$teachers = array();
|
|
$teachers[0] = 0;
|
|
|
|
while ($row = db_fetch_assoc($staff)) {
|
|
extract($row);
|
|
|
|
echo("$first_name $last_name\n");
|
|
|
|
$school_num = $new_school_num;
|
|
$staff_category = 3768;
|
|
$query = $table->BuildInsert();
|
|
db_query($query);
|
|
|
|
$snum = db_insert_id();
|
|
$teachers[$record_num] = $snum;
|
|
|
|
}
|
|
|
|
echo("\n");
|
|
|
|
$classes = db_query("SELECT * FROM classes WHERE school_num = $src_school_num");
|
|
|
|
$table = new Table("classes");
|
|
|
|
while ($row = db_fetch_assoc($classes)) {
|
|
extract($row);
|
|
|
|
$teacher1 = $teachers[$teacher1];
|
|
$teacher2 = $teachers[$teacher2];
|
|
|
|
$school_num = $new_school_num;
|
|
$query = $table->BuildInsert();
|
|
db_query($query);
|
|
|
|
}
|
|
|
|
?>
|