upgrade/1.0.1/phone.php

   1 #!/usr/bin/php5
   2 <?php
   3 require_once 'connect.db.inc.php';
   4
   5 $globals->debug = 0; //do not store backtraces
   6
   7 $phones = array(
   8     'AF' => '93',
   9     'AN' => '599',
  10     'BY' => '375',
  11     'FM' => '691',
  12     'GE' => '995',
  13     'GL' => '299',
  14     'ID' => '62',
  15     'IL' => '972',
  16     'IN' => '91',
  17     'IQ' => '964',
  18     'IR' => '98',
  19     'JO' => '962',
  20     'JP' => '81',
  21     'KG' => '996',
  22     'KW' => '965',
  23     'KZ' => '7',
  24     'LA' => '856',
  25     'LB' => '961',
  26     'LK' => '94',
  27     'MM' => '95',
  28     'MN' => '976',
  29     'MV' => '960',
  30     'MY' => '60',
  31     'NP' => '977',
  32     'OM' => '968',
  33     'PH' => '63',
  34     'PK' => '92',
  35     'QA' => '974',
  36     'SA' => '966',
  37     'SG' => '65',
  38     'SY' => '963',
  39     'TH' => '66',
  40     'TJ' => '992',
  41     'TM' => '993',
  42     'TR' => '90',
  43     'TW' => '886',
  44     'UZ' => '998',
  45     'VG' => '1284',
  46     'VN' => '84',
  47     'YE' => '967',
  48 );
  49
  50 foreach ($phones as $country => $phone) {
  51     XDB::execute('UPDATE  geoloc_countries
  52                      SET  phonePrefix = {?}
  53                    WHERE  iso_3166_1_a2 = {?}',
  54                  $phone, $country);
  55 }
  56
  57 $res = XDB::iterator('SELECT  pid, link_type, link_id, tel_id AS id, search_tel AS search, search_tel AS display
  58                         FROM  profile_phones
  59                        WHERE  search_tel LIKE \'33%\'');
  60 while ($item = $res->next()) {
  61     $phone = new Phone($item);
  62     $phone->format();
  63     XDB::execute('UPDATE  profile_phones
  64                      SET  display_tel = {?}
  65                    WHERE  pid = {?} AND link_type = {?}
  66                           AND link_id = {?} AND tel_id = {?}',
  67                  $phone->display, $phone->pid(), $phone->linkType(),
  68                  $phone->linkId(), $phone->id());
  69 }
  70
  71 /* vim:set et sw=4 sts=4 ts=4: */
  72 ?>