----------- edit 2 ----------- Final released, Links are at the bottom of this Post
----------- /edit 2 ----------- First I hope the Admin and the Mods did not mind that I opend a new tread, but this new version is a 'quantum jump' of the BC-Decrypter, I just try to hold it clearly represented.
But if the Admin or Mods do not want a new thread they may join it to the old one.
Second I want to say
Thank You to all
Donators!
Now, here it is, the
Eumigen's Brutal Combo Decrypter Version 1.03
And here a sreenshot of the tool:
List of fatures:
- SQL-Inserts
- DB-Importfile
- repair Brutenames
- del. double Brutes
- get Names
- get Masters
IMPORTANTBut before you can use all this you have to be a little common with Squirrel and it's File-Export.
The easiest way for me is it to connect to a databse and select the SQL-Tab to do all my Export-Jobs.
I export the whole database by using this statement:
- Code:
-
SELECT * FROM Brutes
Just make sure that you uncheck the checkbox called
Limit rows!
After clicking the
'running man' I use the right mouse-button to export the hole table to a TXT-file.
You have to select
Export CVS / MS Excel ..., the following dialog appears
The picture ^^^ shows my default settings that are fine for BC-Decrypter. If your settings are the same you only have to choose a propper filename to get the data exported.
The Exported File should look like this:
- Code:
-
NAME;ID;MASTER;LEVEL;PASSWORD;DATE
da bf 53 78 8e 1d 16 4e b0 3a 36 0b 67 96 dc 8c c4 d3;768898;;5;myPW;2009-11-16
9b bf 4c 77 8c 59 1e 46 a1 37 38 c2 25 de dc 89 ef;584242;;4;myPW;2009-11-16
c4 eb 4b 20 86 47 44 40 b2 23 ff 0d 79 d4 dc 8c f2 d3;801740;;5;myPW;2009-11-16
...
or this:
- Code:
-
NAME;ID;MASTER;LEVEL;PASSWORD;DATE
cbfc4429d51f454fbe3ff62543;460448;;1;myPW;2009-10-30
cbfc4422d91e4a7cbc25662543;185816;;1;myPW;2009-10-30
cbfc4426d0194e5ca634772543;687438;;1;myPW;2009-10-30
...
both formats work fine for BC-Decrypter
.
Now lets get the encoded Names for the pupils (Button
get Names)
You need the just exported file as input for BC-Decrypter. Start the BC-Decrypter an choose
get Names. In the dialog use the button with the three dots [...] to select the exported file. After that click the
get Brutename button.
A moment later a message box appears, the message is
names decodet!.
The name of the file ends on
.txt.txt and it contains the real decoded names of the brutes as shown below:
- Code:
-
NAME;ID;MASTER;LEVEL;PASSWORD;DATE;Klarname;Domaene
9af91e778d5a0e4dbd2d3fec70d4dc8aee;231909;;8;myPW;2009-11-20;4v9fmpshdsboap;ES
d4ed1770d4421b53b339450566dddc8aee;906157;;8;myPW;2009-11-20;zb0a4hfvwekfwy;ES
...
If the BC-Decrypter throws a message like
wrong file format you have to use a file like this as input for the BC-Decrypter because the choosen function needs the encrypted name for the selected feature.
TIPP This function creates a file named
*_IDsByDomain.txt. This file makes it posible to filter the pupils on their domain (COM, FR or ES)
You can select the pupils of a domain by using this SQL-Statement:
- Code:
-
SELECT * FROM Brutes WHERE ID IN(123, 234, 345, ...)
And now you will imagine whats the bracket for in the txt file ...
ATTENTION, the ID for the brutes is not unique!! That means, if you delete pupils on their ID's you may loose a few pupils, the amount is about 0.1% but it's there. To prevent this you have to do a export on the ID's, in this case you have about 0.1% unwanted pupils in your databese, and that's a good rate
Now let's join databases (Button
DB-Importfile)
You need a normal export-file to join databases.
Open the export-file by clicking on the button with the three dots [...].
Click the
create DB-Import button and wait for the finished message.
After the Message was shown you should have a file named like
*.txt.sql with a content like this:
- Code:
-
Insert into Brutes (Name,Level,Password) Values(X'9ded506b871c294cb221355160c9dc89ef',2,'myPW');
Insert into Brutes (Name,Level,Password) Values(X'd7b61f24d9530a4db4253c0b28d6dc89ef',2,'myPW');
...
When you have that file you can import the data to any BC-Folder you want. Just start Squirrel, connect to the database, select the
SQL Tab, select the menu
Session / File / open to open the SQL-File. After you opend the SQL-File you have to click the little
running man, and the data will be add to the opend database
Now let's add handmade pupils to a BC-databse (Button
SQL-Inserts)
You need a handmade File of this format to add pupils made outside BC:
- Code:
-
myNewBrute001;2;myPW
myNewBrute002;3;
myNewBrute003;3;myPW
...
It is an easy format, you list the name of the brute, the level of the brute and the password seperated by a semicolon, thats all. If you dont have a password for the brute, so just let it free but keep the semicolon at teh end, as shown in row 2.
If you have created the file, select it by clicking on the Button with the 3 dots. Select the Domain the brutes are for (COM, FR or ES) and click the
create SQL-Inserts Button. After the finish message you will find a *.sql file in the folder your *.txt file is located. The content of the file looks like this:
- Code:
-
- Code:
-
Insert into Brutes (Name,Level,Password) Values(X'9ded506b871c294cb221355160c9dc89ef',2,'myPW');
Insert into Brutes (Name,Level,Password) Values(X'd7b61f24d9530a4db4253c0b28d6dc89ef',2,'myPW');
...
With this file you can add the brutes to every BC-database you want. Just start Squirrel, connect to the database, select the
SQL Tab, select the menu
Session / File / open to open the SQL-File. After you opend the SQL-File you have to click the little
running man, and the data will be add to the opend database
Now let's repair Brutenames with capital letters (Button
repair Brutenames)
You need a normal Squirrel export-file to repair the brutenames with upercase letters.
After you have got the export-file you select it by using the 3 dots button [...]. After the selection is done you click on the button named
repair Brute-Names. When the finish message appears, you will find a new SQL-file in the folder your export-file is located. In this case you use a empty database to add this pupils with repaired names. The procedure is as before, just start Squirrel, connect to the empty database, select the
SQL Tab, select the menu
Session / File / open to open the SQL-File. After you opend the SQL-File you have to click the little
running man, and the data will be add to the empty database.
Now let's delete double Brutenames (Button
del. double Brutenames)
You will love this feature If you join databases that are not realy started with empty databses. In this case you get double entries of brutenames in the database and the import runs on an error. Fixing this by hand is hard work, but I will show you how you can get thru this mess
Get the Squirrel export-files of all databases to get joined. Use the
get Names function on all export-files. After that's done you have to merge the txt-files with the decoded brutenames into one big file.
If you have got the big one, select it by using the 3 dots button and click the button
delete double Entries. After the finish message was shown you will get a fine new SQL-file without double brutenames. As before, you have to add this file to an empty database. Just start Squirrel, connect to the empty database, select the
SQL Tab, select the menu
Session / File / open to open the SQL-File. After you opend the SQL-File you have to click the little
running man, and the data will be add to the empty database.
Now let's get the Masters for the pupils (Button
get Masters)
To use this function you have to use the get Names function before to get a file named
*.txt.txt including the pupils names. After this is done you need a little time because all HTML pages of the pupils cellule will be downloaded. This needs most time on this function. On my internet-connection i need about 6 minutes to download 1000 HTML-pages, that makes about an hour on 10000 pupils. This function actually could not been stopped, the only way is to kill the process with the Task Manager
After the HTML-pages are downloaded, it takes only a few minutes to analyse the HTML-pages and get the masters names. In my case about 2 mins per 10000 pupils
.
As result of this function you get two new txt-files in the
tempHTML folder. This files are called:
- BrutesAndMasters.txt
- MastersAndIds.txt
The first file shows the master of each pupil, the second file shows the ID's for the masters, collected in nice brackets again
You can use this data to make your selections and exports on the database to seperate the pupils of a special master.
ATTENTION, the ID for the brutes is not unique!! That means, if you delete pupils on their ID's you may loose a few pupils, the amount is about 0.1% but it's there. To prevent this you have to do a export on the ID's, in this case you have about 0.1% unwanted pupils in your databese, and that's a good rate
----------- edit ----------- Mirror added because of problems with fuxxing rapidshare
----------- /edit ----------- ----------- edit 2 ----------- Final released, Links are edited to point to the Final-Release
----------- /edit 2 ----------- !!! It's D-Day !!!And here comes the link: BC-Decrypter V 1.03 FinalAnd here comes a mirror: BC-Decrypter V 1.03 Finalenjoy
Eumigen