| 1 | #!/usr/bin/php5 |
| 2 | <?php |
| 3 | |
| 4 | require_once 'connect.db.inc.php'; |
| 5 | |
| 6 | $globals->debug = 0; // Do not store backtraces. |
| 7 | |
| 8 | $domains = array( |
| 9 | 'x' => 'polytechnique.org', |
| 10 | 'master' => 'master.polytechnique.org', |
| 11 | 'phd' => 'doc.polytechnique.org' |
| 12 | ); |
| 13 | $domains_ids = XDB::fetchAllAssoc('name', 'SELECT name, id |
| 14 | FROM email_virtual_domains |
| 15 | WHERE name IN {?}', |
| 16 | $domains); |
| 17 | foreach ($domains as $type => $domain) { |
| 18 | XDB::execute('UPDATE accounts |
| 19 | SET best_domain = {?} |
| 20 | WHERE type = {?}', |
| 21 | $domains_ids[$domain], $type); |
| 22 | } |
| 23 | |
| 24 | /* vim:set et sw=4 sts=4 ts=4: */ |
| 25 | ?> |