China DOS Union

Yesterday, when talking about the matter of making mobile phone information queries in the group, vkill immediately sent out a batch processing script of the curl + sed network version ( Professional Mobile Phone Number Locality Query.bat), and I admire his efficiency.

To make batch processing scripts for information query, database support is required. The usual situation is that it's easy to make the batch processing script, but hard to find the database. It's even much harder to search for unencrypted mobile phone databases online.

However, as the saying goes, "Hard work pays off". After more than a week of arduous search, I finally found a text - format, unencrypted database online before the New Year.

The organized database (please click here to download). The relevant information is as follows:

; The original information header of the mobile phone information database is as follows:
; -- phpMyAdmin SQL Dump
; -- version 2.8.1
; -- http://www.phpmyadmin.net
; The posting date is July 18, 2006, and the specific address is no longer traceable

; The area code information is from the network and was added to the original mobile phone information database after being sorted out by me
; The data covers the 130 - 139, 159 number segments
; The data format is: serial number, mobile phone number, area code, province/municipality directly under the Central Government, city, brand
; There are a total of 110,000 data entries, among which 98,107 are valid data entries and 11,893 are invalid data entries

Yesterday, I just started to organize this database and made a simple stand - alone mobile phone information query tool, which has no technical content and is just for everyone's amusement:
@echo off title Mobile Phone Number Locality Query mode con lines=10 cols=31 :Main cls echo.&echo. echo Please enter the mobile phone number: echo. set input= set /p input= if not defined input exit if "%input:~10%"=="" goto Main if not "%input:~11%"=="" goto Main echo %input%|findstr "^1*$">nul||goto Main cls echo. set ID=%input:~0,7% for /f "tokens=2,4,6,8,10 delims='" %%i in ('findstr /r "%ID%" Phone Information Database.txt') do ( echo ━━━━━━━━━━━━━━━ echo From: %%k %%l echo. echo Brand:%%m echo. echo Area code:%%j echo ━━━━━━━━━━━━━━━ ) pause>nul goto Main

[ Last edited by namejm on 2007 - 6 - 6 at 01:05 PM ]

Well, this one I can understand a bit, but what vkill made I don't understand! Still need to improve!

Well, the database is really hard to find~ There are also many advantages to making local queries, heh~ It's more convenient, but there's no way to update it.

Good stuff! I saw one for checking ID cards before. It's really a classic among the essentials. Thanks, moderator for your hard work! Just don't know where to download the updated database.

Good stuff... Collected............. Thanks for sharing

The data cannot be downloaded...

At the time of sending the attachment, I tested it and it could be downloaded, but now it can't be downloaded either. Maybe it's an issue with the download site. I'll contact the webmaster when I have time.

The data is not easy to download. I wrote an automatic download from the web according to plp626. It's just that the speed is a bit slow. Hope to be improved.
@echo off||author:plp626&<%~s0 more +9>%tmp%\gtxt.vbs
md 手机号数据库 2>nul & set n=0
title 手机号数据下载
color 3e
for /l %%i in (1300000,1,1399999) do (cscript //NoLogo //e:vbscript %tmp%\gtxt.vbs "http://www.poptool.net/enet/mobile.asp?key=%%i"|findstr "号码"|more +6 >>手机号数据.db )
for /l %%i in (1530000,1,1539999) do (cscript //NoLogo //e:vbscript %tmp%\gtxt.vbs "http://www.poptool.net/enet/mobile.asp?key=%%i"|findstr "号码"|more +6 >>手机号数据.db )
for /l %%i in (1590000,1,1599999) do (cscript //NoLogo //e:vbscript %tmp%\gtxt.vbs "http://www.poptool.net/enet/mobile.asp?key=%%i"|findstr "号码"|more +6 >>手机号数据.db )
echo 下载完毕!
pause
Set oDOM = WScript.GetObject(WScript.Arguments(0))
do until oDOM.readyState = "complete"
WScript.sleep 100
loop
WScript.echo oDOM.documentElement.outerText