Sql Files Guide
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);
$msquery = "SET IDENTITY_INSERT ACCOUNT_T ON
INSERT INTO ACCOUNT_T ()";
$msresults= mssql_query($msquery);
"<i>One night I was talking to God, but I realized I was talking to <u>myself</u></i>"<br><br><img src='http://img61.imageshack.us/img61/2678/untitled13bf.gif' border='0' alt='user posted image' /><br><br><b><u>Links</u></b><br>
-
- DBfiller
- Posts: 3816
- Joined: Fri Oct 31, 2003 5:30 am
- Location: San Diego CA, USA
- Contact:
make the cfg and leave it blankchichon wrote: ISPIPlist.cfg???????????????? :unsure:
<img src='http://img88.exs.cx/img88/2290/7666.jpg' border='0' alt='user posted image' />
wtf cant run mssql service
bad login error :blink:
bad login error :blink:
<img src='http://img440.imageshack.us/img440/2627/15pt.jpg' border='0' alt='user posted image' /><br><br>HBPolska characters:<br><br>Hellios 150+ Aresden Hero Mage<br>TheBill 120 Aresden plrider<br>Kill_Me 100 Full-Hero plrider<br>Rockeater 110+ Aresden Plate Mage<br><br><a href='http://www.helbreath.org' target='_blank'>http://www.helbreath.org</a> come and play (250 ppl online)
<a href='http://www.microsoft.com/downloads/deta ... laylang=en' target='_blank'>MSSQL</a>
-
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
this files are named just like this:drunk wrote:Where can I get these files? I'm missing Nicksmainlog.sql and Nicksws1.sql .
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.
<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)
1) account_t is in MainLServer.exe1) 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?
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>.
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.
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.
-
- Outpost bitch
- Posts: 559
- Joined: Wed Mar 30, 2005 6:45 am
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?
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?
<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)