RegExp List Generator

by Vitaly, Wednesday, December 21st, 2016

RegExp List Generator 1.16 has been released.

What’s New

1. New option: “Don’t output Columns that start with @”.

This option is useful for generate values that are used in several columns.
For example, if you want to generate the user name as a combination of the first name, last name, or initials, you can do that this way:

Columns:

@FI=[A-Z]
FirstName=%%=@FI%%[a-z]{5,12}
@LI=[A-Z]
LastName=%%=@LI%%[a-z]{5,15}
Username=(%%=@FI%%|%%=FirstName%%)[._-]?(%%=@LI%%|%%=LastName%%)

Example of the Output:

FirstName,LastName,Username
Bpeeahda,Gbkdtl,B_G
Hnnbov,Hocadrtjzyx,HnnbovHocadrtjzyx
Hojbxuinx,Okalcywmpxsczwjn,H-Okalcywmpxsczwjn
Pfrezeezto,Vkkagdqnobo,P.V
Dkncdbdkiatl,Uwcicfbo,DkncdbdkiatlUwcicfbo
Mkqyehiqxgdwp,Hqbbuaf,Mkqyehiqxgdwp-H
Buefvilfxyjyr,Uybtxynfiha,Buefvilfxyjyr-Uybtxynfiha
Amlbvlak,Jgmyurg,AmlbvlakJ
Moxmemuh,Abbmpfwkpg,M_A

2. Generate SQL Insert Statements.

Example of the generated SQL Insert Statements:

INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Xjbusbgffhgo','Zyzcmng','XZ');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Bcgdhbxsdxgnd','Kvcxgkrkbzg','Bcgdhbxsdxgnd.Kvcxgkrkbzg');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Umklpw','Crpehsl','UCrpehsl');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Subcwhyx','Gxjkfyrcc','Subcwhyx_Gxjkfyrcc');
INSERT INTO "schema1"."table1" ("FirstName","LastName","Username") VALUES ('Symupexprzm','Sossuifnbgieighh','SymupexprzmS');

3. Save, Load or Delete stored Columns

Tags:


MySQL Support (WPC)

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

wpcp.1.8.46-1-tn

Load from MySQL Table

wpcp.1.8.46-2-tn

Save to MySQL Table

wpcp.1.8.46-3-tn

Tags: ,


MySQL Support (AV)

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” 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

av-1-38-1-tn

Pic.2 Load From MySQL table

av-1-38-2-tn

Pic.3 Save to MySQL table

av.1.38-4-tn
 

Pic.4 View Table

av.1.39-tn

Tags: ,