forked from science-ation/science-ation
95 lines
2.7 KiB
PHP
95 lines
2.7 KiB
PHP
<?
|
|
|
|
/*
|
|
* This file may contain 2 functions, a db_update_$ver_pre() and a
|
|
* db_update_$ver_post(). _pre() is called before the SQL patch is
|
|
* applied, and as expected, _post() is called after.
|
|
*
|
|
* These functions are called from the main db_update.php file, and included
|
|
* once, so any global variables declared in here WILL REMAIN across both
|
|
* calls. meaning you can pull some stuff out of the database in _pre(), and
|
|
* then the patch will be applied, and they it can be inserted back into the
|
|
* database in _post().
|
|
* Also note that MULTIPLE php scripts could be included if the db update is
|
|
* large, so global variable names probably shouldn't conflict... put the version
|
|
* number in them
|
|
*/
|
|
|
|
$update_62_committee = array();
|
|
|
|
function db_update_62_pre()
|
|
{
|
|
global $update_62_committee;
|
|
$q = $pdo->prepare('SELECT * FROM committees_members');
|
|
$q->execute();
|
|
while ($r = $q->fetch(PDO::FETCH_ASSOC)) {
|
|
$update_62_committee[] = $r;
|
|
}
|
|
}
|
|
|
|
function db_update_62_post()
|
|
{
|
|
global $update_62_committee;
|
|
global $config;
|
|
|
|
foreach ($update_62_committee as $c) {
|
|
list($fn, $ln) = split(' ', $c['name'], 2);
|
|
$username = $c['email'];
|
|
|
|
if ($config['committee_password_expiry_days'] > 0) {
|
|
$passwordexpiry = "DATE_ADD(CURDATE(),
|
|
INTERVAL {$config['committee_password_expiry_days']} DAY)";
|
|
} else {
|
|
$passwordexpiry = 'NULL';
|
|
}
|
|
|
|
$deleted = ($c['deleted'] == 'Y') ? 'yes' : 'no';
|
|
$q = "INSERT INTO users
|
|
(`types`,`firstname`,`lastname`,`username`,`password`,`passwordexpiry`,
|
|
`email`,`phonehome`,`phonework`,`phonecell`,`fax`,`organization`,
|
|
`created`,`deleted`)
|
|
VALUES ('committee',?,?,?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
NOW(),
|
|
?)";
|
|
$stmt = $pdo->prepare($q);
|
|
$stmt->execute([$fn,$ln,$username,$c['password'],$passwordexpiry,$c['email'],$c['phonehome'],$c['phonework'],$c['phonecell'],$c['fax'],$c['organization'],$deleted]);
|
|
echo "$q\n";
|
|
$id = $pdo->lastInsertId();
|
|
|
|
$access_admin = ($c['access_admin'] == 'Y') ? 'yes' : 'no';
|
|
$access_config = ($c['access_config'] == 'Y') ? 'yes' : 'no';
|
|
$access_super = ($c['access_super'] == 'Y') ? 'yes' : 'no';
|
|
$displayemail = ($c['displayemail'] == 'Y') ? 'yes' : 'no';
|
|
$q = "INSERT INTO users_committee(`users_id`,`emailprivate`,
|
|
`ord`,`displayemail`,`access_admin`,`access_config`,
|
|
`access_super`) VALUES (
|
|
?,?,
|
|
?,
|
|
?,
|
|
?,
|
|
?,
|
|
?)";
|
|
$stmt = $pdo->prepare($q);
|
|
$stmt->execute([$id,$c['emailprivate'],$c['ord'],$displayemail,$access_admin,$access_config,$access_super]);
|
|
echo "$q\n";
|
|
show_pdo_errors_if_any($pdo);
|
|
|
|
/* Update committee links */
|
|
$q = "UPDATE committees_link SET users_id=?
|
|
WHERE committees_members_id=?";
|
|
$stmt = $pdo->prepare($q);
|
|
$stmt->execute([$id,$c['id']]);
|
|
echo "$q\n";
|
|
}
|
|
}
|
|
|
|
?>
|