Sql Files Guide

Sparda · Post by **Sparda** » Sun May 22, 2005 2:17 pm

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 · Post by **drunk** » Sun May 22, 2005 2:45 pm

fixed

RageIlluminati · Post by **RageIlluminati** » Sun May 22, 2005 3:49 pm

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

Stik · Post by **Stik** » Sun May 22, 2005 4:14 pm

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 · Post by **RageIlluminati** » Sun May 22, 2005 4:30 pm

Stik wrote: 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.

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

CDWriter · Post by **CDWriter** » Sun May 22, 2005 5:33 pm

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 · Post by **RageIlluminati** » Sun May 22, 2005 5:47 pm

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

Stik · Post by **Stik** » Sun May 22, 2005 6:00 pm

build date in gateserver.cfg should be 521 to match the hgserver.exe

CDWriter · Post by **CDWriter** » Sun May 22, 2005 6:10 pm

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 °¡´ÉÇÑ ºÎ·ù ¼³Á¤

Side : ¸¶À»
- both
- aresden
- elvine

bHunt : »ç³É²Ûµµ °¡´ÉÇÑÁö
0
1

bNtrl : Áß¸³µµ °¡´ÉÇÑÁö
0
1

bCrmnl : ¹üÁËÀÚµµ °¡´ÉÇÑÁö
0
1

RageIlluminati · Post by **RageIlluminati** » Sun May 22, 2005 7:05 pm

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)

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

molo · Post by **molo** » Wed Jun 08, 2005 2:23 pm

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:\program files\.....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:\Program Files\Microsoft SQL Server\MSSQL\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:\Program Files\ 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 · Post by **Unknowen** » Mon Jul 04, 2005 10:38 pm

#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, :\

Help me please

ruberto · Post by **ruberto** » Sat Jul 23, 2005 12:04 am

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 · Post by **ruberto** » Sat Jul 23, 2005 9:45 am

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 · Post by **RageIlluminati** » Mon Jul 25, 2005 7:04 am

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