stats
Mise à jour de la table COMMUNE vers wp_ip_fai OK
Mise à jour vers wp_ip_fai OK
Insertion vers IP_COMMUNES OK
Insertion vers IP_COMMUNES OK
Update vers IP_COMMUNES OK
Update vers IP_COMMUNES OK
Update vers IP_COMMUNES OK
Update vers wp_ip_pays OK
Insertion vers wp_ip_pays OK
Insertion vers wp_ ip_pays OK
Update vers IP_PAYS_COMMUNS OK
SELECT `Rang0`, `Rang1`, `Rang2`, INet_AToN(Concat(`Rang0`, '.', `Rang1`, '.',`Rang2`, '.1')) AS `IP_NUMBER` ,Concat(`Rang0`, '.', `Rang1`, '.',`Rang2`, '.1') as IP_CONCAT FROM `IP_COMMUNES` WHERE `Ville` = '' ORDER BY `Rang0`, `Rang1`, `Rang2` LIMIT 0, 1000
SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 759016705 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1796560129 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 1914747905 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 2639954433 BETWEEN `IP_FROM` AND `IP_TO`

SELECT `COUNTRY_CODE` FROM `ip_to_country` WHERE 2733719041 BETWEEN `IP_FROM` AND `IP_TO`

UPDATE wp_ip_fai SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Ashburn' , Pays = 'US' WHERE Rang0 = 107 and Rang1 = 21 and Rang2 = 85 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Unified Layer' ,Ville ='Provo' , Pays = 'US' WHERE Rang0 = 162 and Rang1 = 241 and Rang2 = 62 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Chunghwa Telecom Co. Ltd.' ,Ville ='Taipei' , Pays = 'TW' WHERE Rang0 = 114 and Rang1 = 32 and Rang2 = 188 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='Universidad Nacional de Buenos Aires' ,Ville ='Buenos Aires' , Pays = 'AR' WHERE Rang0 = 157 and Rang1 = 90 and Rang2 = 130 ; 1
UPDATE wp_ip_fai SET FOURNISSEUR='IT7 Networks Inc' ,Ville ='Los Angeles' , Pays = 'US' WHERE Rang0 = 45 and Rang1 = 61 and Rang2 = 173 ; 1SELECT `Rang0`, `Rang1`, `Rang2` , Concat(`Rang0`, '.', `Rang1`, '.',`Rang2`, '.1') as IP_CONCAT3 FROM `IP_COMMUNES` WHERE `Ville` ='' OR Ville ='XX' ORDER BY `DERNIERE_VISITE` DESC LIMIT 0, 5000
UPDATE IP_COMMUNES SET FOURNISSEUR='Unified Layer' ,Ville ='Provo' , Pays = 'US' WHERE Rang0 = 162 and Rang1 = 241 and Rang2 = 62 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='IT7 Networks Inc' ,Ville ='Los Angeles' , Pays = 'US' WHERE Rang0 = 45 and Rang1 = 61 and Rang2 = 173 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Universidad Nacional de Buenos Aires' ,Ville ='Buenos Aires' , Pays = 'AR' WHERE Rang0 = 157 and Rang1 = 90 and Rang2 = 130 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Chunghwa Telecom Co. Ltd.' ,Ville ='Taipei' , Pays = 'TW' WHERE Rang0 = 114 and Rang1 = 32 and Rang2 = 188 ; 1
UPDATE IP_COMMUNES SET FOURNISSEUR='Amazon.com Inc.' ,Ville ='Ashburn' , Pays = 'US' WHERE Rang0 = 107 and Rang1 = 21 and Rang2 = 85 ; 1
city_nameISPcountry_code

Le suivi des
visites par pays(Nbr d'enregistrement :=> 167)
PaysNomimageNbr FAINbr de visites
ADAndorre22
AEEmirats Arabe Unis107510
AFAfghanistan6117
AGAntigua-et-Barbuda45
ALAnguilla14
AMArménie15376
ANANTILLES NEERLANDAISES11
AOAngola38188
AQANTARCTIQUE13
ARArgentine1958910
ATAutriche1801708
AUAustralie99543014
AZAzerbaijan1489
BABosnie-Herzegovine771149
BBBarbade22
BDBangladesh2221997
BEBelgique2053150758
BFBurkinaFaso22
BGBulgarie26221167
BHBAHRAIN171211
BIBurundi117
BJBénin1337
BNBrunei618
BOBolivie1028
BRBrésil91119900
BTBhoutan13
BWBotswana46
BYBelarus26321491
BZBelize419
CACanada2102140884
CDCongo ex Zaïre27
CHSuisse991576
CICote d'ivoire54912
CLChilie461275
CMCameroun84747
CNChine3459151
COColombie5423235
CRCosta Rica537
CVCap Vert13
CWCuraçao39
CYChypre18980
CZRepublique Tcheque2644203
DEAllemagne78347788
DKDanemark15674497
DORepublique Dominicaine42234
DZAlgérie229498
ECEquateur52118
EEEstonie1491632
EGEgypte4272614
ESEspagne3749823
FIFinlande612395
FRFrance1870303285
GAGabon615
GBGrande Bretagne186580802
GEGeorgie41718
GHGhana2091
GNGuinee Equatoriale29
GPGUADELOUPE11
GRGrece1271543
GTGuatemala36
GWGuinée Bissau12
HKHong-Kong5267279
HNHonduras931
HRCroatie701208
HUHongrie1961733
IDIndonesie149032654
IEIrelande152640765
ILIsrael7836799
INInde135621426
IQIraq4071
IRIran3386313
ISIslande12516
ITItalie53219815
JMJamaïque1578
JOJordanie1351
JPJapon51415631
KEKenya47174
KGKyrgyzstan15249
KHCambodge63520
KNSaint-Kitts-et-Nevis13
KRCoree du sud67422561
KWKoweit1031
KZKazakhstan68726
LALaos19300
LBLiban1941
LKSri Lanka83357
LRLiberia24
LSLésotho16140
LTLituanie91634
LULuxembourg32517
LVLettonie662617
LYLibye135664
MAMaroc169747
MCMonaco39
MDMoldavie21198
MEMontenegro19869
MGMadagascar1219
MKMacedoine (Ex republique Yugoslave)46288
MMMyanmar13135
MNMongolie18315
MOMoldavie1349
MQ110
MTMalte527
MUIles Maurice47231
MVMaldives44
MWMalawi538
MXMexique1163258
MYMalaisie2937160
MZMozambique33
NANamibie1039
NCNouvelle-Caledonie11111
NGNigeria1013
NINicaragua2351
NLPays-bas1355204304
NONorvege451700
NPNepal521140
NZNouvelle Zélande63641
OMSultana d'Oman2943
PAPanama3386
PEPerou2922339
PFPolynésie Française22
PG15
PHPhilippine4912530
PKPakistan3432996
PLPologne963170
PRPuerto Rico1371
PSPalestine36379
PTPortugal893850
PYParaguay1015
QAQuatar921
RORoumanie5259408
RSSerbie1122173
RURussie2353291688
RWRwanda316
SAArabie-saoudite19621077
SCSeychelles770
SDSoudan714
SESuede19128549
SGSingapour87314627
SISlovénie511911
SKSlovaquie30658
SNSenegal36762
SOSomalie44
SRSuriname5277
SVSan Salvador615
SYSyrie1353
SZSwaziland27
TGTogo11
THThailande8578983
TJTadjikistan5308
TNTunisie60527
TRTurquie108413480
TTTrinidad et Tobago23
TWTaiwan22416509
TZTanzanie961442
UAUkraine64043756
UGUganda871
USUSA234661333426
UYUruguay321256
UZOusbekistan17843
VEVenezuela38695
VIIles Vierge USA11
VNVietnam273441063
YEYemen1865
ZAAfrique au Sud3041374
ZMZambie925
ZWZimbabwe11

Les adresses de
FAI inconnus