| | How to connect Squirrel 2 BC DB |  |
|
+17Azturiar Sioc bamb@m bboy_kurei Stsin taitoune mystorage redneck-giant99 NippleLuvs Maccaz Neutrino Rippraff ESCGoat argus silverx123 Yaboirobby Eumigen 21 posters |
|
| Author | Message |
|---|
NippleLuvs
* * * *
Posts : 54
Join date : 2009-09-25
|  Subject: Re: How to connect Squirrel 2 BC DB  Thu 15 Oct 2009, 17:13 | |
| In BC, when you CREATE a pupil but don't level the pupil, they all have default values in the stats, supers, weapons. See, except for the name, all values are useless. Not sure where BC comes up with those initial values as it seems to be random. - Code:
-
COLUMN HEADINGS
name;id;level;endurance;force;agilite;rapidite;Voleur;Brute féroce;Potion tragique;Filet;Bombe;Marteau-pilon;Cri-qui-poutre;Hypnose;Deluge;Force herculéenne;Agilité du félin;Frappe éclair;Vitalité;Immortel;Maître d"armes;Arts martiaux;6ème sens;Pugnace;Tornade de coups;Bouclier;Armure;Peau renforcée;Intouchable;Sabotage;Choc;Gros-bras;Implacable;Survie;chien A;chien B;chien C;panthère;ours;mains;couteau;glaive;lance;baton;trident;hache;cimeterre;marteau;épee;éventail;shuriken;crocs;massue;étoile du matin;os de mammouth;fléau;fouet;sai;poireau;mug;poële;piou piou;hallebarde;trombone;clavier;bol de noodle;raquette
DATA
iwftvhjw;0;0;266;32;15;42;;43;66;24;59;;;;;;;2;;;19;15;10;;35;47;64;13;;;;;;;30;;;;;;3;9;76;1;;12;;62;16;;17;;7;;5;56;8;;;;;;;;;;;25
rsgqjjgy;0;0;266;32;15;42;;43;66;24;59;;;;;;;2;;;19;15;10;;35;47;64;13;;;;;;;30;;;;;;3;9;76;1;;12;;62;16;;17;;7;;5;56;8;;;;;;;;;;;25
fizxabtn;0;0;266;32;15;42;;43;66;24;59;;;;;;;2;;;19;15;10;;35;47;64;13;;;;;;;30;;;;;;3;9;76;1;;12;;62;16;;17;;7;;5;56;8;;;;;;;;;;;25
efanzxqo;0;0;266;32;15;42;;43;66;24;59;;;;;;;2;;;19;15;10;;35;47;64;13;;;;;;;30;;;;;;3;9;76;1;;12;;62;16;;17;;7;;5;56;8;;;;;;;;;;;25
When you start leveling pupils, then stats are captured for them. - Code:
-
iwftvhjw;459657;3;308;34;21;22;;47;;14;;;;;21;2;;;;;5;;17;;;42;37;12;;;;;;;51;43;;;;;6;;1;4;;3;;;61;;;;19;20;28;32;;;;;;;;;;;;20
rsgqjjgy;913368;3;254;24;28;49;;7;66;41;46;;48;45;;;3;33;;;;;31;;;6;;12;;80;2;;;;15;53;;;1;;19;20;28;5;;9;44;13;;;8;;4;55;30;;;56;;43;;;;;;;;29
fizxabtn;161470;3;308;40;18;19;;22;18;19;;;;;;8;;;;;64;;;;21;11;;32;;;24;5;;;7;51;53;;;;1;4;62;12;31;2;15;36;;;;;3;6;;78;;;;17;;;;44;;;;26
efanzxqo;758977;3;272;27;30;42;;22;25;40;;;;69;;;1;45;;;41;21;;37;66;2;46;19;;;51;17;;59;3;28;;;;;7;6;11;18;12;14;78;;15;79;;;26;16;5;;4;;;;;;;;;;;31
On a side note: For people looking for those really special brutes with EVERYTHING, they should export some leveled brutes and use EXCEL or something else to find brutes with TripleT, Implacable, Untouchable, etc... | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 17:28 | |
| - NippleLuvs wrote:
- In BC, when you CREATE a pupil but don't level the pupil, they all have default values in the stats, supers, weapons.
See, except for the name, all values are useless. Not sure where BC comes up with those initial values as it seems to be random.... Thats right, but this data is NOT stored in the BC database, the bitstring is to short, and last 3 or 4 chars represent the domain (COM, FR or ES) where the brute is registred this is proved. | |
|
| | |
NippleLuvs
* * * *
Posts : 54
Join date : 2009-09-25
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 17:44 | |
| I just exported both of those 4 lines. BC is not connecting to COM to get the values.
If you are only storing the LEVEL at which you will get an item and not the NAME of the item, it does not take that much space to store a 2 digit number. BC does not seem to look for items acquired any later than level 80.
Here is the code that is pulling weapons from the NAME
Bonus.getWeapon("4Hd,O"), Bonus.getWeapon("(Nl"), Bonus.getWeapon("3;KeJ"), Bonus.getWeapon("0JE(G"), Bonus.getWeapon("8n*1"), Bonus.getWeapon("4u[MY"), Bonus.getWeapon("7FuzF("), Bonus.getWeapon("9k59O")
Anyway, i don't think any of this is relevant for just deleting and merging pupils. You probably only need the name. | |
|
| | |
redneck-giant99
Forum Mod
Posts : 1377
Join date : 2009-04-29
Age : 50
Location : Hurt Locker
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 17:49 | |
| will these 2 squirrels help out  | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 18:18 | |
| - redneck-giant99 wrote:
- will these 2 squirrels help out
Öhhmm, there are one, two, three Squirrels  | |
|
| | |
NippleLuvs
* * * *
Posts : 54
Join date : 2009-09-25
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 19:34 | |
| This is gross! - Code:
-
public static byte[] decode(String s)
{
byte abyte0[] = new byte[s.length() / 2];
s = s.toLowerCase();
for(int i = 0; i < abyte0.length; i++)
{
int j = "0123456789abcdef".indexOf(s.charAt(2 * i + 0));
int k = "0123456789abcdef".indexOf(s.charAt(2 * i + 1));
abyte0[i] = (byte)(j * 16 + k);
}
return abyte0;
}
I'm going to convert this to SQL so we can pull names straight from the table, without a program. | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 21:28 | |
| | |
|
| | |
Rippraff
* * * * * * * * * *
Posts : 1352
Join date : 2009-05-24
Age : 58
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 21:46 | |
| Great, congratz!  Nevertheless a SQL script would be much appreciated too.  | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 21:51 | |
| - Rippraff wrote:
- Great, congratz!
Thanx a lot, did you test it, anny comments? | |
|
| | |
Rippraff
* * * * * * * * * *
Posts : 1352
Join date : 2009-05-24
Age : 58
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 21:53 | |
| Yep I did a test and it worked. Have to verify the result though. :) | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Thu 15 Oct 2009, 21:56 | |
| - Rippraff wrote:
- Yep I did a test and it worked. Have to verify the result though. :)
Thanx a lot man, thats fine, anny further comments are pritty welcome  Ich danke dir, das ist gut, weitere Kommentare sind sehr wilkommen greetz Eumigen  | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: [TUTORIAL] Addon to Suns Tut Sat 17 Oct 2009, 10:49 | |
| Hi, because of lot PMs about the connect thing, I decide to write a little addon to the sun Tut. 1. you have to download Squirrel and install it. 2. Read the Sun Tut. Do as described in section Configuring SQuirreL for the Derby Embedded JDBC Driver this Driver is needed to connect to BC database! 3. create an alias for your connetion as shown below:  At point 1. type in a name for the connection At point 2. select the embedded Driver At point 3. edit the URL as shown. it shoul point to your BC database (the subfolder db in the data folder of BC) After that click the Test-Button. The following Window appears:  Click the Connect-Button, if following message appears it's done.  Save the alias. From now you can connet to the database by doubleclick on the alias on the alias-tab in Squirrel. enjoy Eumigen | |
|
| | |
silverx123
* * * * * * * * *
Posts : 532
Join date : 2009-08-05
| | Subject: Re: How to connect Squirrel 2 BC DB Sat 17 Oct 2009, 11:11 | |
| | |
|
| | |
mystorage
* * * * *
Posts : 94
Join date : 2009-04-21
| | Subject: Re: How to connect Squirrel 2 BC DB Sat 17 Oct 2009, 11:15 | |
| it worked!!! | |
|
| | |
taitoune
* *
Posts : 13
Join date : 2009-10-16
Age : 47
| | Subject: Re: How to connect Squirrel 2 BC DB Sat 17 Oct 2009, 13:37 | |
| - 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.
The stats and supers are not stored in the db. They are computed when using the "export function". The inventory and stats only depend on the ID and level of a brute. No need to store them in database. You can see this inventory computation here for example: http://brutalcombo.comlu.com/SaisieID.php - 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... Maybe it's wasusuge's pupils ...  From the very beginning of BC we never hid the fact that a small percentage of the brute created with BC are going to "our brutes". This percentage is fixed at 10%. At the moment, it's wasusuge wo benefits from it (sometimes we change the brute who benefits it but never the %age). We believe that those brutes are not really bothering anyone. At least, what users gain by using BC is worth the 10% brutes that get created for us. But if deleting "our pupils" from the DB was simple, I bet a lot of people would do it. That's why the DB is (minimally) protected: only people who hate our pupils enough to spend hours to decrypt the database wil be able to delete those brutes. Taitoune. | |
|
| | |
NippleLuvs
* * * *
Posts : 54
Join date : 2009-09-25
| | Subject: Re: How to connect Squirrel 2 BC DB Sat 17 Oct 2009, 16:30 | |
| Honesty! Thanks taitoune. I like that. | |
|
| | |
Stsin
* * * * * * * * *
Posts : 889
Join date : 2009-07-18
| | Subject: Re: How to connect Squirrel 2 BC DB Sat 28 Nov 2009, 06:24 | |
| For those running Windows 7 x64 and/or only Jre6 installed, should notice that squirrel-sql.bat doesn't work. While you can directly execute squirrel-sql.jar, you'll probably want to run that bat script so that it assigns squirrel's classpath and uses/or can modify the optional parameters. Set the JAVA_HOME environmental variable if not set, as it wasn't on mine:  Right click My Computer > Select Properties > Advanced Tab > Environmental Variables > New Then add JAVA_HOME and the path that your java is at. In squirrel-sql.bat, change this line: - Code:
-
IF NOT "%JAVA_HOME%"=="" SET LOCAL_JAVA=%JAVA_HOME%\bin\java to this: - Code:
-
IF NOT "%JAVA_HOME%"=="" SET LOCAL_JAVA=%JAVA_HOME%\jre6\bin\java Modifying the path to how your java directory is set up. I honestly don't know why they didn't just set LOCAL_JAVA to ....\bin\javaw since they have to add the w whenever it's used.Here is an alternate way: - Spoiler:
This script is a cleaned up version without having to do any of the above, removing the version/update checks and unused options. Just modify the java path in the last line, if needed: - Code:
-
@echo off
set basedir=%~f0
:strip
set removed=%basedir:~-1%
set basedir=%basedir:~0,-1%
if NOT "%removed%"=="\" goto strip
set SQUIRREL_SQL_HOME=%basedir%
@rem build SQuirreL's classpath
set TMP_CP="%SQUIRREL_SQL_HOME%\squirrel-sql.jar"
dir /b "%SQUIRREL_SQL_HOME%\lib\*.*" > %TEMP%\squirrel-lib.tmp
FOR /F %%I IN (%TEMP%\squirrel-lib.tmp) DO CALL "%SQUIRREL_SQL_HOME%\addpath.bat" "%SQUIRREL_SQL_HOME%\lib\%%I"
SET SQUIRREL_CP=%TMP_CP%;"%CLASSPATH%"
echo "SQUIRREL_CP=%SQUIRREL_CP%"
SET TMP_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
start "SQuirreL SQL Client" /B "C:\Program Files (x86)\Java\jre6\bin\javaw" -Xmx256m -cp %SQUIRREL_CP% net.sourceforge.squirrel_sql.client.Main %TMP_PARMS% Be sure to save and run this batch file in the main SQuirrel directory (same as the other batch file.)
| |
|
| | |
silverx123
* * * * * * * * *
Posts : 532
Join date : 2009-08-05
| | Subject: Re: How to connect Squirrel 2 BC DB Sat 28 Nov 2009, 06:46 | |
| - Stsin wrote:
- For those running Windows 7 x64 and/or only Jre6 installed, should notice that squirrel-sql.bat doesn't work.
While you can directly execute squirrel-sql.jar, you'll probably want to run that bat script so that it assigns squirrel's classpath and uses/or can modify the optional parameters.
Set the JAVA_HOME environmental variable if not set, as it wasn't on mine:
Right click My Computer > Select Properties > Advanced Tab > Environmental Variables > New
Then add JAVA_HOME and the path that your java is at.
In squirrel-sql.bat, change this line: - Code:
-
IF NOT "%JAVA_HOME%"=="" SET LOCAL_JAVA=%JAVA_HOME%\bin\java to this: - Code:
-
IF NOT "%JAVA_HOME%"=="" SET LOCAL_JAVA=%JAVA_HOME%\jre6\bin\java Modifying the path to how your java directory is set up.
I honestly don't know why they didn't just set LOCAL_JAVA to ....\bin\javaw since they have to add the w whenever it's used.
Here is an alternate way:
- Spoiler:
This script is a cleaned up version without having to do any of the above, removing the version/update checks and unused options. Just modify the java path in the last line, if needed: - Code:
-
@echo off
set basedir=%~f0
:strip
set removed=%basedir:~-1%
set basedir=%basedir:~0,-1%
if NOT "%removed%"=="\" goto strip
set SQUIRREL_SQL_HOME=%basedir%
@rem build SQuirreL's classpath
set TMP_CP="%SQUIRREL_SQL_HOME%\squirrel-sql.jar"
dir /b "%SQUIRREL_SQL_HOME%\lib\*.*" > %TEMP%\squirrel-lib.tmp
FOR /F %%I IN (%TEMP%\squirrel-lib.tmp) DO CALL "%SQUIRREL_SQL_HOME%\addpath.bat" "%SQUIRREL_SQL_HOME%\lib\%%I"
SET SQUIRREL_CP=%TMP_CP%;"%CLASSPATH%"
echo "SQUIRREL_CP=%SQUIRREL_CP%"
SET TMP_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
start "SQuirreL SQL Client" /B "C:\Program Files (x86)\Java\jre6\bin\javaw" -Xmx256m -cp %SQUIRREL_CP% net.sourceforge.squirrel_sql.client.Main %TMP_PARMS% Be sure to save and run this batch file in the main SQuirrel directory (same as the other batch file.)
emm...thank you..... you know windows7 x64 did not work when try to open squirrel-sql.bat ( open and close instant ) for now i just go to squirrel forder and open squirrel-sql.jar now i should try this one.... Thank you.... | |
|
| | |
bboy_kurei
* * * *
Posts : 40
Join date : 2009-11-15
Age : 34
Location : VietNam
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 03:38 | |
| | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 15:28 | |
| | |
|
| | |
bboy_kurei
* * * *
Posts : 40
Join date : 2009-11-15
Age : 34
Location : VietNam
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 18:13 | |
| I've created for you 10 pupils and added to my BCDB - Quote :
- vufptabchgtvi
vufptecgdcsva
vufpthnecqxes
vufptyuvrrsgw
vufptznojpoul
vufptnsazrujj
vufptwfgokuuj
vufpttsdtmzko
vufptbvsrwopx
vufptwhgahecu Thk you for this useful tool | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 18:20 | |
| | |
|
| | |
Yaboirobby
* * * * * * * * * * *
Posts : 4322
Join date : 2009-05-21
Age : 28
Location : Atlanta, GA
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 18:28 | |
| I am going to try and merge some DB's. So first, I need to Download and connect the Squirrel application. Then I can download your Decrypter tool and then follow the merge DB steps to make one big file.
Is that correct Eumigen? | |
|
| | |
Eumigen
VIP
Posts : 487
Join date : 2009-09-25
Location : somewhere in Germany
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 18:36 | |
| - Yaboirobby wrote:
- I am going to try and merge some DB's. So first, I need to Download and connect the Squirrel application. Then I can download your Decrypter tool and then follow the merge DB steps to make one big file.
Hmm, that's curious, I thought a friend of you has made this already .... - Yaboirobby wrote:
- Is that correct Eumigen?
Yes, thats right, but if you get double entries you have to read the Now let's delete double Brutenames section of my tut greetz Eumigen | |
|
| | |
Yaboirobby
* * * * * * * * * * *
Posts : 4322
Join date : 2009-05-21
Age : 28
Location : Atlanta, GA
| | Subject: Re: How to connect Squirrel 2 BC DB Sun 29 Nov 2009, 18:38 | |
| - Eumigen wrote:
- Yaboirobby wrote:
- I am going to try and merge some DB's. So first, I need to Download and connect the Squirrel application. Then I can download your Decrypter tool and then follow the merge DB steps to make one big file.
Hmm, that's curious, I thought a friend of you has made this already ....
- Yaboirobby wrote:
- Is that correct Eumigen?
Yes, thats right, but if you get double entries you have to read the Now let's delete double Brutenames section of my tut
greetz
Eumigen Yes my friend runs them all but he runs them one by one. I would like to merge them and start running that one file myself. And do I have to delete the double named brutes if there are any? If i leave the double named brutes, will it not run or something? | |
|
| | |
Sponsored content
| | Subject: Re: How to connect Squirrel 2 BC DB | |
| |
|
| | |
| | How to connect Squirrel 2 BC DB | |
|
... Sorry, but I am happy married 