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:
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:
[ Last edited by namejm on 2007 - 6 - 6 at 01:05 PM ]
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 ]
尺有所短，寸有所长，学好CMD没商量。
考虑问题复杂化，解决问题简洁化。
考虑问题复杂化，解决问题简洁化。
