Sql Files Guide

tyteman · Post by **tyteman** » Mon May 16, 2005 3:51 am

find the vars for the acc table and i can set it up

$msquery = "SET IDENTITY_INSERT ACCOUNT_T ON
INSERT INTO ACCOUNT_T ()";
$msresults= mssql_query($msquery);

chichon · Post by **chichon** » Mon May 16, 2005 4:57 am

ISPIPlist.cfg???????????????? :unsure:

Post by **binarydata** » Mon May 16, 2005 5:13 am

chichon wrote: ISPIPlist.cfg???????????????? :unsure:

make the cfg and leave it blank

Stik · Post by **Stik** » Mon May 16, 2005 7:28 am

Looks to me like the GateServer.exe is missing from the D/L, all i got is the gate source which wont compile for me ????

Ace · Post by **Ace** » Mon May 16, 2005 8:42 am

where can i download MSsql db ... Srry Noob Questions

Drajwer · Post by **Drajwer** » Mon May 16, 2005 12:02 pm

wtf cant run mssql service

bad login error :blink:

Sparda · Post by **Sparda** » Mon May 16, 2005 1:07 pm

<a href='http://www.microsoft.com/downloads/deta ... laylang=en' target='_blank'>MSSQL</a>

drunk · Post by **drunk** » Wed May 18, 2005 10:05 am

Where can I get the SQLsetupfiles at?

Arkkeri · Post by **Arkkeri** » Sat May 21, 2005 10:57 pm

where can i get the sql files? ::II

drunk · Post by **drunk** » Sun May 22, 2005 9:20 am

Where can I get these files? I'm missing Nicksmainlog.sql and Nicksws1.sql .

RageIlluminati · Post by **RageIlluminati** » Sun May 22, 2005 10:59 am

drunk wrote:Where can I get these files? I'm missing Nicksmainlog.sql and Nicksws1.sql .

this files are named just like this:
ws1.txt and mainlog.txt.. rename them to ws1.sql and mainlog.sql

then start them...

OK i did all thing so far, but have some problems:

1) cant find "account_t" string from WorldServer-3.51.exe, so I cant HEX there password...

2) I HEXed the MainLServer.exe... entered my password, but it still can't connect to the database:-(

Q1: When and how I use Heldian and Crusade SQL scripts?

Q2: what kind of item and skill and other configfiles I have to use?

EDIT: didn't find any item or skill or other usual cfg files... so I can use my onw ones.. that I used with 2.24b HGserver?

EDIT2: on WorldLServer.exe you have to find string: "character_t" there you can change the password.

Sparda · Post by **Sparda** » Sun May 22, 2005 12:33 pm

1) cant find "account_t" string from WorldServer-3.51.exe, so I cant HEX there password...

2) I HEXed the MainLServer.exe... entered my password, but it still can't connect to the database:-(

Q1: When and how I use Heldian and Crusade SQL scripts?

Q2: what kind of item and skill and other configfiles I have to use?

1) account_t is in MainLServer.exe
2) you may have configured your MSSQL server properly
A1) i believe those are used in the ws1 database but that isn't important yet. Another topic will be posted about that when we actually get the server up and running.
A2) those config files are provided in that zipped file that GoldenBoy has uploaded for everyone to download. You can find those files somewhere in this topic or forum, sorry i can't remember exactly where. However you can get them from <a href='http://www.helbreathss.tk' target='_blank'>HelbreathSS</a>.

drunk · Post by **drunk** » Sun May 22, 2005 1:20 pm

I'm having problems doing this part.

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

I did everything like you said and I open up the file hit the blue checkmark and I get a error with both main and ws1.

Could not locate entry in sysdatabases for database 'mainlogin'. No entry found with that name. Make sure that the name is entered correctly.

Pls help me.

RageIlluminati · Post by **RageIlluminati** » Sun May 22, 2005 1:43 pm

first hit CTRL+F5 then it displays these errors.. ignore them... and then hit just F5.. then it creates these databases... and then hit Save button...

after that same thing with mainlog.sql

afterwards you can go look for if there are new files like: ws1_*.mdf and mainlog*.mdf or smthing like that in the folder C:\Program Files\Microsoft SQL Server\MSSQL\Data\

EDIT: 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?

drunk · Post by **drunk** » Sun May 22, 2005 1:50 pm

Thnx for the help Rage