28 lines
515 B
PHP
28 lines
515 B
PHP
<?php
|
|
|
|
include "db.php";
|
|
|
|
$query = "SELECT * FROM schools WHERE status != 'Pending'";
|
|
$schools = db_query($query);
|
|
|
|
while ($row = db_fetch_assoc($schools)) {
|
|
$url = $row['url'];
|
|
$rnum = $row['record_num'];
|
|
|
|
$URLparts = explode('.',$url);
|
|
if (count($URLparts) != 3) {
|
|
$base_url = $url;
|
|
}
|
|
else {
|
|
$base_url = $URLparts[1].'.'.$URLparts[2];
|
|
}
|
|
|
|
echo("$url - $base_url\n");
|
|
|
|
$query = "UPDATE schools SET base_url = '$base_url' WHERE record_num = $rnum";
|
|
db_query($query);
|
|
|
|
}
|
|
|
|
?>
|