projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch 'xorg/maint' into xorg/master
[platal.git]
/
classes
/
phone.php
diff --git
a/classes/phone.php
b/classes/phone.php
index
8356f64
..
be6f3ad
100644
(file)
--- a/
classes/phone.php
+++ b/
classes/phone.php
@@
-187,10
+187,10
@@
class Phone
if ((!isset($format['phoneprf'])) || ($format['phoneprf'] == '')) {
$res = XDB::query('SELECT phonePrefix AS phoneprf, phoneFormat AS format
FROM geoloc_countries
if ((!isset($format['phoneprf'])) || ($format['phoneprf'] == '')) {
$res = XDB::query('SELECT phonePrefix AS phoneprf, phoneFormat AS format
FROM geoloc_countries
- WHERE phonePrefix =
{?} OR phonePrefix = {?} OR phonePrefix = {?}
- ORDER BY
phonePrefix
DESC
+ WHERE phonePrefix =
SUBSTRING({?}, 1, LENGTH(phonePrefix))
+ ORDER BY
LENGTH(phonePrefix)
DESC
LIMIT 1',
LIMIT 1',
-
substr($tel, 0, 1), substr($tel, 0, 2), substr($tel, 0, 3)
);
+
$tel
);
if ($res->numRows() == 0) {
// No country found, does not format more than prepending a '+' sign.
$this->error = true;
if ($res->numRows() == 0) {
// No country found, does not format more than prepending a '+' sign.
$this->error = true;