How to connect Squirrel 2 BC DB

Because of some emails to this topic I'll share a link to a TUTORIAL
And now have fun exploring the BC DB

And keep in mind Google is your friend :cyclops:

hth
Eumigen

What does this do? What is Squirrel 2 BC DB?

how to use this one ? can we allow edit our db file or just explor ?

@Yaboirobby, this is a SQL-Databasemanager

@silverx123, both if you like

@all, read the tut and ask then, most questions are answered in the tut ...

If any further questions, ask here, I'll try to answer

greetz
Eumigen

I cannot understand for what it will serve... to see u pupils??

argus wrote:

I cannot understand for what it will serve... to see u pupils??

Hmm, then you don't need Squirrel and such tools ...

Yaboirobby wrote:

What does this do? What is Squirrel 2 BC DB?

BC (Brutal Combo) stores all of its pupil information using a small database known as Apache Derby. SQuirrel is a java application that lets you connect to Derby databases (theoretically like the one used in BC though I haven't tried it myself), explore them, add to them, modify them, etc.

However, doing any of this stuff is not something trivial for most users and the tutorial linked to in the first post contains mostly information that will fly right over the heads of 99% of BC users. It's not a BC-specific tutorial, but rather general information on how to use SQuirrel which if you have the time and technical knowledge could be applied to exploring and modifying your BC pupil databases. Though it's a very nice thought to think we could use this to edit our pupil dbs and particularly to merge them together, I don't recommend messing around with this sorta thing unless you really know what you're doing or someone comes up with and posts a good tutorial specifically for the average BC user.

@Eumigen: Have you successfully used SQuirrel to manipulate BC dbs yourself? I started looking into derby-related stuff when I first started using BC but I remember thinking parts of the db were encrypted for some reason. I may be thinking of something else though since I only looked at it for a short while and then moved on to a million different things, lol.

In any case, this does look promising, so I'll see if I can get it to do anything useful but I wanted to make sure you've had success with it yourself.

For everyone else, this isn't an easy to understand matter yet, so please refrain from making "how do I work this?" type posts as there are no easy answers to be pointed to just yet. On the flip-side, useful specific questions/comments are welcomed if you've read the page Eumi pointed to and understood it well enough.

Cheers,

esc-g

Okay, I gave SQuirrel a spin and used it to check out some of my BC dbs... seems to indeed do the trick quite handily. Very much appreciated that you pointed this out, Eumi. I only took a brief look at a couple dbs but it seems like it could be a useful tool once I spend a little more time and figure out the right way to do certain things.

Question: Is it just me overlooking something in my quick look at basic functionality or is the "Master" field not actually used? I'll likely have more questions (and more answers) after I have time to waste on it a bit more, hehe. If you have any tips to get me headed in the right direction on merging brute tables from different sessions, dbs, csv files, or whatever wouldn't mind the pointers... there seems to be a number of ways to possibly do it but I'm a bit rusty with this stuff.

Once I get things figured out, I'd be happy to post a simplified tutorial for BC users to do certain things but in general I still recommend against users messing around with this unless they know a bit about SQL clients and are technically inclined.

If anyone else has the time and desire, feel free to beat me to posting a tutorial as I likely won't get to it right away.

@ESCGoat, yes, I've edited the date - column in the Burtes-Table (the only Table in BC) a few times. And yes, the Names-Column is encrypted, but it must be a weak lettershuffle algorithm because the last 3 or 4 Hex-values are the same on all pupilnames
A friend of mine seems to be able to decrypt and encrypt the names, he put a few handmade pupils into my database so that i can fight them with BC

The masterfield isn't used at all of my databases. I think it is to prevent the makers of BC to get the pupils for their brutes deleted from the database

Actually I don't now anyone who can merge databases The friend of mine means that the type of the Names-column is the problem, squirrel cant import a csv file with hex-formatet data this type

If anyone has more informations, please let us know, I thing we could get a lot going if we work together ...

greetz
Euigen

Eumigen wrote:

but it must be a weak lettershuffle algorithm because the last 3 or 4 Hex-values are the same on all pupilnames

Then I bet there's the stored information on which side the pupils were created as there's no column for the web page (COM, FR, ES).

Rippraff wrote:

Eumigen wrote:

but it must be a weak lettershuffle algorithm because the last 3 or 4 Hex-values are the same on all pupilnames

Then I bet there's the stored information on which side the pupils were created as there's no column for the web page (COM, FR, ES).

Yess, i think that's it 2 or 3 letters (FR, ES or COM) and a char as separator! And I'm shur it's the and where the domain is added

greetz
Eumigen

Hmm this may be a bit off topic, but I thought they need to store more information with the pupils. Like gfx code, since I'm pretty sure its required to work out the K value in the fights.

Neutrino wrote:

Hmm this may be a bit off topic, but I thought they need to store more information with the pupils. Like gfx code, since I'm pretty sure its required to work out the K value in the fights.

That is definitively wrong! The K value is send in the html when you call the fightpage (e.g. http://eumigen.mybrute.com/vs/neutrino). It is send back to the server when you click the fifght button but it is encoded, perhabs with the same algorythm as the names in the database ...

To fight another brute you only need the name and password of your brute, all aditional informations are delivered by the mybrute server

greetz
Eumigen

If you make any headway, I would be inclined to learn about these kinda things when I get enough time

Maccaz wrote:

If you make any headway, I would be inclined to learn about these kinda things when I get enough time

it requires a few people who can code to get any further, are there some here on board?

Wouldn't that make brutal combo slow? If they have to load the fight page and then click the button it would take ages to go through pupils since the fight page takes time to load. Which is why I thought they always send http requests like http://neutrino.mybrute.com/fight/?d=tony;k=bdeb8bccaafc

I only ask since I'm trying to speed up my trainer script(the pupils were made before I started using BC).

I asked this question on the labrute forum which is why I'm confused.

http://forumlabrute.forumactif.org/trucs-et-astuces-f26/calcul-de-k-t8344.htm?sid=3cd2e2c5b70edf4c31d31565e5994d80

I use the google translator to read this.

EDIT: Sorry for the offtopic.

EDIT: Now that I think about it more, the way you described makes more sense, otherwise how would they know if a pupil levels.

Eumigen wrote:

Rippraff wrote:

Eumigen wrote:

but it must be a weak lettershuffle algorithm because the last 3 or 4 Hex-values are the same on all pupilnames

Then I bet there's the stored information on which side the pupils were created as there's no column for the web page (COM, FR, ES).

Yess, i think that's it 2 or 3 letters (FR, ES or COM) and a char as separator! And I'm shur it's the and where the domain is added

greetz
Eumigen

Ah, great stuff. Thanks again for the info Eumi and good call on the domain bits Rippraff! :) Making progress already. I can verify the domain being at the end of the of the entries, but do note if you use custom names for brutes that are longer than the default 8 chars, the last 3-4 values won't be the same due to the way it's encrypted so don't let that throw ya off.

It's not a lettershuffle/Caesar/ROT algorithm but it does seem easy enough to figure out nonetheless. Taking a quick look you should be able to note that letters have the same value representing them if they're in the same position within the name. For example, two names starting with the char "c" would both start with the first value in the name field being "cd". c's after the first letter will have different values dependent on their position. As an example, here are the values for the char "a" in each of the first 8 positions:

a(1)=cf a(2)=ee a(3)=46 a(4)=70 a(5)=81 a(6)=4b a(7)=1c a(=44

so to represent the name "aaaaaaaa" on the mybrute.com server the name field in the brute table would contain:

cf ee 46 70 81 4b 1c 44 ed 0d 12 2e

There's also defnitely a corelation in the order of the values/characters in any given position/column....

examples: x(4)=69 and y(4)=68; h(2)=e7 and g(2)=e8; o(3)=48 and l(3)=49

however, not all relationships are this straightforward.

As simple as it seems, I'm far too tired and braindead to actually even try to spot the cipher being used, but my assumption would be that this storage method has something to do with the way it interacts with the web services more than anything to do with hiding information from the user. That had me thinking some weak form of RC4 which I believe is used in some part of the deciphering info from mybrute until I actually looked at the values and it seems even simpler than that. Even without a decryption method at the moment it's easy enough to map out the values to represent what chars in what positions for the names. I've already used this to quickly fix one of the entires in one of my dbs which was a custom name starting with a captial letter and has been suffering from the bug related to that issue for a while now just by changing one value to make it lowercase. I just haven't been able to test it since the servers have been down again, argh.

@Neutrino - Nope, not too offtopic. :) To my knowledge, there isn't any need for storage of anything else for the operation of BC. All of the gfx information is stored online with the brute and everything else needed for things done by BC can be extrapolated from the ID of the brute (and the name) as well as a few minor things through their server (which I believe is where the fight key generations are done). BC does get those k values for the fights... I remember thinking it did lookups on the somee server to generate the keys but I may be mistaken... bottom line is that the fight keys are gnerated for you based on the brute table and opponents table and I don't recall gfx codes being needed for such (there are different k values used for separate things as well). I hope that makes sense, I'm really passing out here so I'm gonna turn in and perhaps I can better explain tomorrow if this doesn't make any sense, lol.

cheers,

esc-g

A few words for you Goat:

go to sleep

Neutrino wrote:

Wouldn't that make brutal combo slow? If they have to load the fight page and then click the button it would take ages to go through pupils since the fight page takes time to load. Which is why I thought they always send http requests like http://neutrino.mybrute.com/fight/?d=tony;k=bdeb8bccaafc

They don't send an Url, they use a Webservice on an BC-Server. And it's realy only Domain, Name and Password nessesary to let the brutes fight.

Neutrino wrote:

I only ask since I'm trying to speed up my trainer script(the pupils were made before I started using BC).

What type of script is it? A AutoIt-Script?

Neutrino wrote:

EDIT: Now that I think about it more, the way you described makes more sense, otherwise how would they know if a pupil levels.

thats another point, I think they need to load the html from mybrute server to analyse it for different issues.

greetz
Eumigen

@ESCGoat,
yes I think thats it, and when they are using RC4 for some reasons in BC then are the names also encoded with RC4
Why shold they use an additional cypher algorythm?

:arrow: And thanks for the great roundup

Eumigen

Yes AutoIt.

And thanks for ur replies ESCGoat and Eumigen. :)

Just anupdate on one thing I mentioned:

Quote :

I've already used this to quickly fix one of the entires in one of my dbs which was a custom name starting with a captial letter and has been suffering from the bug related to that issue for a while now just by changing one value to make it lowercase. I just haven't been able to test it since the servers have been down again, argh.

I got to test it out and the change worked like a charm. Now I FINALLY don't have to train that pupil manually (which i had to do thanks to the uppercase first letter bug where you make a custom pupil in BC starting with an uppercase char and it reports that it's done the fights for it just like any other pupil but it really hasn't done them at all - changing the first letter to lowercase in the db before running the combats actually made it do the reported combats for the first time, woohoo!). One thing to note when editing the dbs manually is if it gives you problems, try adjusting your settings in preferences for Data Type Controls. Seems it's a bit finicky about the timestamp handling.

I'm going to keep mapping out valid alphanumeric chars values per position until I have a better idea of the complete pattern and can write an algorithm to properly encode/decode or I have enough mapped out to create a script for adding simply named pre-existing brutes to the db. First though I want to mess with the dbcopy plugin to see if it can be used to more or less straight up merge the brute tables from seperate dbs (or at least copy it into a temp table that the records can be copied from into the target brute table) since that would make things much more convenient for training pupils, hehe.

Unfortunately, I'm fairly short on time for a bit... but I'll post updates on any progress I make and hopefully you guys (Eumi! hehe) will do the same.

cheers,

esc-g

I decompiled the BC java a couple weeks ago to figure out the database. It appears the name column contains the name, the stats and the supers all rolled up in to bit data.

I was going to work on a way to combine databases at a minimum. Were there other things you guys wanted to do to the database?

I have found that some databases contain puplis that are not mine, so I wanted to weed them out and make 1 (or many) databases that only had my pupils...

Hi ESCGoat,

Thanx for the response on that point.

ESCGoat wrote:

... but I'll post updates on any progress I make and hopefully you guys (Eumi! hehe) will do the same.

You can bet your life on it

cu
Eumigen

NippleLuvs wrote:

I decompiled the BC java a couple weeks ago to figure out the database. It appears the name column contains the name, the stats and the supers all rolled up in to bit data.

Thats wrong! The Bitstring is to short to hold all this data!
Yesterday evenig, inspired by Rippraff, I made a little Test and created 2 Pupils, one on elBruto.es and one on laBrute.fr, the COM site was down again
The special on this brutes is that their names nearly the same, just the last char differs, because of a restriction of BC
And the result of that test was, that both bitstrings nearly the same. Just the last 4 chars are different!
So sory for your Idea

NippleLuvs wrote:

I was going to work on a way to combine databases at a minimum. Were there other things you guys wanted to do to the database?

Thats what we all want;)

NippleLuvs wrote:

I have found that some databases contain puplis that are not mine, so I wanted to weed them out and make 1 (or many) databases that only had my pupils...

Right, thats the target.

greetz
Eumigen