upgrade/1.1.0/best_domain.php

   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 ?>