Commit | Line | Data |
---|---|---|
f34d8fad SJ |
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 | ||
555a4512 SJ |
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 | ||
f34d8fad SJ |
71 | /* vim:set et sw=4 sts=4 ts=4: */ |
72 | ?> |