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