by Vitaly, Friday, March 25th, 2016
Opt-In List Manager 1.1.71 has been released.
What’s New
Added option “Sort Lists”->”Count Duplicates”.
Example
Source list:
user1@gmail.com,FirstName1,LastName1
user2@gmail.com,FirstName2,LastName2
user1@gmail.com,F1,L1
Output without “Remove Duplicates“:
2,user1@gmail.com,FirstName1,LastName1
2,user1@gmail.com,F1,L1
1,user2@gmail.com,FirstName2,LastName2
Output with “Remove Duplicates“:
2,user1@gmail.com,FirstName1,LastName1
1,user2@gmail.com,FirstName2,LastName2
Tags: Count, Duplicates, Sort
by Vitaly, Monday, February 15th, 2016
Accurate regular expression to match IPv4 address:
((([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5]))\.){3}(([0-9])|(1[0-9][0-9]?)|([2-9][0-9])|(2[0-4][0-9])|(25[0-5]))
Tags: IPv4, Regular Expression
by Vitaly, Friday, February 12th, 2016
Web Proxy Checker Pro 1.8.46 released.
What’s New
Added support of MySQL databases.
Format of the MySQL source path:
mysql://connection_name/table_name/column1,column2,...[delimiter]/where_statement
Format of the MySQL output path:
mysql://connection_name/table_name/column1,column2,.../value1,value2,...
You can read more about MySQL source/output path formats here: MySQL Support (AV)
Output Values
- :$host – proxy host
- :$port – proxy port
- :$type – proxy type (https, socks4, socks5)
- :$user – proxy user name
- :$pass – proxy password
- :$extip – external IP address
- :$ccode – country code
MySQL Connections
Load from MySQL Table
Save to MySQL Table
Tags: MySQL, SQL
by Vitaly, Tuesday, February 9th, 2016
Account Verifier 1.39 released.
What’s New
New version of AV can read the source lists (account lists, proxy lists, etc.) from MySQL tables and save the output to MySQL tables.
Format of the MySQL source path:
mysql://connection_name/table_name/column1,column2,...[delimiter]/where_statement
Format of the MySQL output path:
mysql://connection_name/table_name/column1,column2,.../value1,value2,...
connection_name – the name of the MySQL connection. Click “MySQL Connections” 
button to edit MySQL connections (Pic.1).
table_name – the name of the MySQL table.
[delimiter] (for source paths) – optional delimiter between columns (default: comma). Example:
mysql://optinsoft/proxies/host,port[:]
where_statement (for source paths) – optional WHERE part of the SQL SELECT statement. Example:
mysql://optinsoft/proxies/host,port/port='1080'
The corresponding SQL SELECT statement:
SELECT host,port FROM proxies WHERE port='1080'
column1,column2,… – the MySQL table column names.
value1,value2,… (for output paths) – the inserted values. Example:
mysql://optinsoft/acc-good/login,pass/:$login,:$pass
The corresponding SQL INSERT statement:
INSERT INTO acc-good (login,pass) VALUES (:$login, :$pass)
You can use these values:
- :$email – source email
- :$login – source login
- :$pass – source password
- :$host – server’s host
- :$port – server’s port
- :$ssl – SSL usage (‘1’ – used, ‘0’ – not used)
- :$authmethod – authentication method
- :$starttls – STARTTLS usage (‘1’ – used, ‘0’ – not used)
- :$proxy – proxy_host:_proxy_port (when connected via proxy)
- :$ip – source IP (when “Rotate IPs” is checked)
- :$ua – HTTP User Agent
- :$reason – fail reason
You can use “Load from MySQL table” and “Save to MySQL table” dialogs to fill MySQL paths (Pic.2,3).
Pic.1 MySQL Connections
Pic.2 Load From MySQL table
Pic.3 Save to MySQL table
Pic.4 View Table
Tags: MySQL, SQL
by Vitaly, Tuesday, February 2nd, 2016
Opt-In List Manager 1.1.69 has been released.
What’s New
Added option “Extract And Clean”->”Convert OEM to ANSI”.
Tags: ANSI, Convert, List, OEM
