INNER JOIN account_profiles AS ap ON (q.user_id = ap.uid AND FIND_IN_SET(\'owner\', ap.perms))
WHERE q.profile_mobile <> \'\'');
while (list($pid, $pub, $phone) = $phones->next()) {
+ $pub = ($pub == '' ? 'private' : $pub);
$fmt_phone = format_phone_number($phone);
if ($fmt_phone != '') {
$display = format_display_number($fmt_phone, $error);
INNER JOIN account_profiles AS ap ON (e.uid = ap.uid AND FIND_IN_SET(\'owner\', ap.perms))
ORDER BY ap.pid');
while ($row = $phones->next()) {
+ $row['tel_pub'] = ($row['tel_pub'] == '' ? 'private' : $row['tel_pub']);
$request = 'INSERT INTO profile_phones (pid, link_type, link_id, tel_id, tel_type, search_tel, display_tel, pub)
VALUES ({?}, \'pro\', {?}, {?}, {?}, {?}, {?}, {?})';
$fmt_fixed = format_phone_number($row['tel']);
$conversions = array();
$other_count = 0;
while ($row = $phones->next()) {
+ $row['tel_pub'] = ($row['tel_pub'] == '' ? 'private' : $row['tel_pub']);
$fmt_phone = format_phone_number($row['tel']);
if ($fmt_phone != '') {
$display = format_display_number($fmt_phone, $error);
. " There is $warnings phone numbers that couldn't be imported.\n"
. " They need to be manually inserted.\n";
}
-echo "\nAfter solving any import problem and checking automatic conversions,\n"
- . "you can drop useless columns and tables by these requests:\n"
- . "DROP TABLE IF EXISTS tels;\n"
- . "ALTER TABLE auth_user_quick DROP COLUMN profile_mobile;\n"
- . "ALTER TABLE auth_user_quick DROP COLUMN profile_mobile_pub;\n"
- . "ALTER TABLE entreprises DROP COLUMN tel;\n"
- . "ALTER TABLE entreprises DROP COLUMN fax;\n"
- . "ALTER TABLE entreprises DROP COLUMN mobile;\n"
- . "ALTER TABLE entreprises DROP COLUMN tel_pub;\n";
-
// auxilliary functions