Sql Files Guide

Discussion about Helbreath Server Files.
Sparda
Regular
Posts: 44
Joined: Sat May 15, 2004 10:48 pm

Post by Sparda »

I got MainLogServer to connect to my database, but not the WorldLogServer.. this still gives error can't connect to the database...

do I have to HEX WorldLServer.exe as well? what string I should look from there?
Yes u have to hex the WLServer as well. It's similar to how u edited the MLServer where you had to change the password. dsn connection character username sa password xxxxxxx.
drunk
Loyal fan
Posts: 265
Joined: Wed Mar 17, 2004 1:43 pm

Post by drunk »

fixed
RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

huhh.. OK I have connection and it seems to be OK, but when I start HGserver: HGServer-v3.61-(521).exe it complains that potion.cfg and WLserver.cfg errors..
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

Have you got potion.cfg in the same folder as main and world exe
create an empty world.cfg file with notepad ;) not sure what goes in there yet. In Account_t table you will need to create a collumn called iShopID INT
to be able to create a valid account.
RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

Stik wrote: Have you got potion.cfg in the same folder as main and world exe
create an empty world.cfg file with notepad&nbsp; ;)&nbsp; not sure what goes in there yet. In Account_t table you will need to create a collumn called iShopID&nbsp; INT
to be able to create a valid account.
my WLserver.cfg file looks like this at the moment:

[CONFIG]

world-server-name = WS1

world-server-address = 192.168.0.1
world-server-port = 1256
internal-world-server-port = 3840

main-log-server-address = 192.168.0.1
main-log-server-port = 2848

gate-server-address = 192.168.0.1
gate-server-port = 1255

game-server-list = 192.168.0.1


Potion.cfg is on the same directory, where are the gateserver and mailog and etc...

Image
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
CDWriter
Member
Posts: 123
Joined: Sun Feb 22, 2004 12:08 am

Post by CDWriter »

What did your mainlog and World server report when u got this error .....

it may not be the potion.cfg it may be something before it not correct ....



RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

CDWriter wrote: What did your mainlog and World server report when u got this error .....

it may not be the potion.cfg it may be something before it not correct ....
haa... I got off about one error... I created empty file Teleport.cfg and the potion error is gone.. still not happy with my WLserver.cfg

EDIT: ok.. now its fine with my WLserver.cfg... (after making file world.cfg) but now GateServer prints error: Build date mismatch
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

build date in gateserver.cfg should be 521 to match the hgserver.exe
CDWriter
Member
Posts: 123
Joined: Sun Feb 22, 2004 12:08 am

Post by CDWriter »

and here is the teleport.cfg info


[CONFIG]

//---------NUM--NPC_NAME--------SOURCE_MAP------TARGET_MAP------X-------Y-------COST----MinLvl--MaxLvl--Side----bHunt---bNtrl---bCrmnl--
teleport = 1 William cityhall_1 dglv2 263 258 5000 40 300 aresden 0 0 0 0
teleport = 2 William cityhall_2 dglv2 209 258 5000 40 300 elvine 0 0 0 0

teleport = 3 William cityhall_1 middleland 524 524 0 1 300 aresden 0 0 0 1
teleport = 4 William cityhall_2 middleland 392 218 0 1 300 elvine 0 0 0 1

teleport = 5 William cityhall_1 BtField 68 225 0 1 300 aresden 0 0 0 1
teleport = 6 William cityhall_2 BtField 202 70 0 1 300 elvine 0 0 0 1


[END]

Teleport °&#161;´ÉÇ&#209; &#186;η&#249; &#188;&#179;Á¤

Side : ¸¶&#192;»
- both
- aresden
- elvine

bHunt : »ç&#179;É&#178;&#219;µµ °&#161;´ÉÇ&#209;Áö
0
1

bNtrl : Á߸&#179;µµ °&#161;´ÉÇ&#209;Áö
0
1

bCrmnl : &#185;üÁË&#192;Úµµ °&#161;´ÉÇ&#209;Áö
0
1


RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

OK, it took a while... but I got it running... it seamed that it needed Npcitem.cfg named file as well, I created it blank...

but whats really wierd, is that, in my own comp at home WLserver starts normaly, but in server, where I host server.. there WLserver seems to read through the item.cfg's... thats really wierd... but it starts and gets connected and HGserver registres himself as well...

see the picture below (I deleted some IP's and confidential info from there), but as you can see.. somebody already tryed to connect to the server (well that kind of account doesn't exists yet)
Image

How I do a account to log in and test it?

what kind of client should I use? at the moment I have HBint 3.7 client with HEXed 3.51.exe

EDIT: btw.. that teleport.cfg you showed here... I have really strange WLserver.cfg file.. where are these lines of yours + more lines smthing about crafting items...

EDIT2: ok I'm as far the other are... I have a account.. but can't make a character..
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
molo
Member
Posts: 140
Joined: Mon Jan 17, 2005 1:19 am

Post by molo »

binarydata wrote: 2. Next we need to setup MSsql db witch i have included here with the reg crack..first run SQLEVAL.exe and place the files in a directory somewhere does not matter where or witch Drive.. after this goto where u extraced the files and hit the autorun.exe and install MSsql DB to your c:&#092;program files&#092;.....Make sure when installing u use MIXED Mode. Add a password and make sure u write that down. then open SQL Crack.zip and copy the crack file to where u installed MSsql DB , mine is C:&#092;Program Files&#092;Microsoft SQL Server&#092;MSSQL&#092;Binn place the crack here and Crack the MSsql DB.

3. Now after this lets setup the MSsql DB from the Orginal files taken from Siementech HB. Open the file called Nicksws1.sql with notepad. This should be in the SQLsetupFiles Directory and change the path to where your MSsql DB Data files should be if u installed it to the Normal path C:&#092;Program Files&#092; then the first and second path should be correct all ready, If u have not then correct the path to where you stalled MSsql. Start again with line 3 but this time open the file called Nicksmainlog.sql and change the paths.

4. After all above is done lets open the MSsql Enterprise Manager, This is assuming u started the Mssql from control panel/Administrative tools/Services. If not go there now and open up services looking for Mssql and start it .. Now goto Tools / SQL Query Analyzer above when the Windows opens make sure master is set - top middle of the window -, Now click on the Open folder and browse to your 361HB directory inside the folder called SQLsetupFiles click on Nicksws1.sql when it opens click the Blue check mark or (Ctrl+F5) u should get a (The command(s) completed successfully.) in the results list. Now click Run green arrow next to the Blue check mark or press f5 it should finish completed. after this hit the save command and open the next file called Nicksmainlog.sql and do the exact same thing. MSSQL Bases COMPLETE.
ok i have every thing but dont get some parts. like #2 were can i get SQLCrack.zip
#3 Nicksws1.sql i dont have this files too.
#4 my comes every thing different. it just small box, it has only Play, Pause and stop on small screan. thats it nuting else. no tools nuting.

that is my problem so hope u help me. i know this is stupid Question but i realy need to set up this thing so please help me out...
thx
Unknowen
just visiting
Posts: 9
Joined: Fri Jul 01, 2005 4:41 am

Post by Unknowen »

#3 Go to the SQL dump files and look for something called ws1.txt, rename to .sql, rename the path names to the correct directorys to your MSSQL, and follow instructions.
#4 Go to Start -> All Programs -> Microsoft SQL Server -> Enterprise manager. Should lead you to where you need to go.

-- My Problems --
Having problems getting my game server to work correctly... Not just with this version but with every version I use, SQL or not, :&#092;

Image

Help me please :(
ruberto
Regular
Posts: 64
Joined: Mon May 31, 2004 7:33 pm

Post by ruberto »

damm please help with.
4.
After all above is done lets open the MSsql Enterprise Manager, This is assuming u started the Mssql from control panel/Administrative tools/Services. If not go there now and open up services looking for Mssql and start it .. Now goto Tools / SQL Query Analyzer above when the Windows opens make sure master is set - top middle of the window -, Now click on the Open folder and browse to your 361HB directory inside the folder called SQLsetupFiles click on Nicksws1.sql when it opens click the Blue check mark or (Ctrl+F5) u should get a (The command(s) completed successfully.) in the results list. Now click Run green arrow next to the Blue check mark or press f5 it should finish completed. after this hit the save command and open the next file called Nicksmainlog.sql and do the exact same thing. MSSQL Bases COMPLETE.

where is this Now goto Tools / SQL Query Analyzer

please make screenshot or smth
ruberto
Regular
Posts: 64
Joined: Mon May 31, 2004 7:33 pm

Post by ruberto »

I cant find Account_T from WorldServer.exe

mainlog were easy could someone help me with world or post it here where i can find Account_T
RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

ruberto wrote: I cant find Account_T from WorldServer.exe

mainlog were easy could someone help me with world or post it here where i can find Account_T
I don't remember excactly .. but in WorlLserver you have to find character_t and in mainlogserver you have to find account_t..
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
Post Reply